Connecting remotely without any issues.

I already have local and remote connections enabled. What else do I have to
enable? Also, I have installed all components I thought possible. How do I
access or install Data Transforation Project in 2005?
"Geoff N. Hiten" wrote:
> Login locally to the server and run the SQL Surface Area Configuration Tool.
> SQL 2005 is "secure by default". One aspect of this is the SQL server
> disables all external network connections by default. You can connect
> locally on the box, but not across the network. This allows a DBA to load
> and patch a SQL server without exposing it to network attacks like a SQL
> 2000 system.
>
> --
> Geoff N. Hiten
> Senior Database Administrator
> Microsoft SQL Server MVPericzaj wrote:
> I already have local and remote connections enabled. What else do I have to
> enable? Also, I have installed all components I thought possible. How do I
> access or install Data Transforation Project in 2005?
>
Do you mean DTS (Data Transformation Services)? That no longer exists
in SQL 2005, it has been replaced with SSIS (SQL Server Integration
Services).
Tracy McKibben
MCDBA
http://www.realsqlguy.com