>I have been trying to get SQL 2005 Remote Access configured on my Win 2003 server. I followed the directions here:
>
http://support.microsoft.com/kb/914277>
>
>When I attempt to connect to SQL on the server from my WinXP PC I get this:
>
>
>
>
>Cannot connect to MAROIS-DEV1.
>
>ADDITIONAL INFORMATION:
>A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not
>found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote
>connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) (Microsoft SQL Server,
>Error: 1326)
>For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=1326&LinkId=20476
>
>
>The link points to nothing.
>
>The KB page says to add exceptions in the firewall. When I enable the firewall, even with the exceptions, I see cannot see MAROIS-DEV1 in the list of network servers. When I disable the firewall I can see it, I just cannot connect.
>
>Anyone know what's going on?
Make sure your are configured to use TCP/IP.
Make sure the SQL Server is set to allow remote connections.
Open TCP Port 1433 and you should be all set.
____________________________________
Don't Tread on Me
Overthrow the federal government NOW!
____________________________________