Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Remote Access Woes AGAIN
Message
General information
Forum:
Microsoft SQL Server
Category:
Other
Miscellaneous
Thread ID:
01450522
Message ID:
01450574
Views:
34
>>>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:
>>
>>Connect using what technology?
>>>
>>>
>>>
>>>
>>>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?
>>
>>Snip : "I see cannot see MAROIS-DEV1" - wanna take another stab at that statement :-}
>>Anyway - can you connect using the IP address of the server rather than the instance name ?
>
>I tried loggin in with the IP, and it failed to connect.

Is there a firewall on the host machine that could be causing the problem?
When you say "remotely" - do you mean via the internet - or are you logged into the same network?
ICQ 10556 (ya), 254117
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform