Enabling remote connections to MSSQL

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2008 Forums

SQL Server Administration (2008)

Enabling remote connections to MSSQL

Author

Topic

afrika
Master Smack Fu Yak Hacker

2706 Posts

Posted - 2010-02-11 : 09:52:57

Hello,
am running MSSQL 2008 and cant seem to enable remote login with the IP address.

I have enabled
1. remote login on the sql instance
2. added the server IP to surface configuation manager to the TCP/IP configurations
3. I have enabled remote login on windows firewall

However when i try to login with the IPaddress,port number either directly through the server or remotely, I get this error message

TITLE: Connect to Server
------------------------------

Cannot connect to 00.00.000.000,4533.

------------------------------
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: TCP Provider, error: 0 - A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond.) (Microsoft SQL Server, Error: 10060)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=10060&LinkId=20476

------------------------------
BUTTONS:

OK
------------------------------

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2010-02-11 : 09:54:59

is remote connections option enabled in surface configuration manager?

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

afrika
Master Smack Fu Yak Hacker

2706 Posts

Posted - 2010-02-12 : 18:25:21

in 2008, its actually under facets and it is enabled.

Its also enabled in windows firewall and the tcp address too is active.

afrika
Master Smack Fu Yak Hacker

2706 Posts

Posted - 2010-02-14 : 04:41:32

I finally sorted the problem, after changing the connection parameters i didnt restart the server, i have done so and can connect now, thanks for your assistnace

Ehi

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources