Monday, March 26, 2012

Establishing a remote connection..! (Again)

Hi,

I am trying to connect via the Management Studio Express. I share a LAN with the server. In Netowrk connections I can see the server and I can even access the "Shared" folders. However,when I try to connect I get an error that says the error may be caused by the server not allowing remote connections. I have already done the following:

With the Surface Area Configuration facility I have set the server to allow remote connections I have selected TCP/IP as the preferred mode of connection. I have selected Windows authentification as mode of authorisation

What else can I do?

Please help.

Derekprinsloo

Verify that there is no local firewall blocking.

These resources should help you.

Configuration -Configure SQL Server 2005 to allow remote connections
http://support.microsoft.com/default.aspx?scid=kb;EN-US;914277
http://blogs.msdn.com/sqlexpress/archive/2005/05/05/415084.aspx

Configuration -Connect to SQL Express from "downlevel clients"
http://blogs.msdn.com/sqlexpress/archive/2004/07/23/192044.aspx

Configuration -Connect to SQL Express and ‘Stay Connected’
http://betav.com/blog/billva/2006/06/getting_and_staying_connected.html

No comments:

Post a Comment