question

Timothy avatar image
Timothy asked

Sql Server Remote Connection

Please can any body help me out, am having problems with my Sql server connection via both intranet and internet.

I developed a software which need to access an SQL server 2005 over an internet or intranet... but despite the setting to allow SQL Sever Remote connection, I still received an error message saying : "Can not connect to SQL server, this is because under the default setting, sql does not support remote connection...." and I have tried my best to resolve this but no way. please guys help me out...

sql-server-2005
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

3 Answers

·
ThomasRushton avatar image
ThomasRushton answered

Have you gone through this? http://support.microsoft.com/kb/914277 - How to configure SQL Server 2005 for remote connections.

10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Magnus Ahlkvist avatar image
Magnus Ahlkvist answered

You say you did allow remote connections in Sql Server Surface Area Configuration?

How are you connecting (TCP/IP, Named Pipes etc)? Have you enabled the network protocol you're trying to connect to the server with (done in SQL Server Configuration Manager)?

10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Kev Riley avatar image
Kev Riley answered

The error message can be misleading - what it is trying to say is it 'couldn't connect to your SQL server, oh and by the way did you know that by default this is turned off for remote connections'!

It is trying to help you, but if you have already allowed remote connections, then the issue is elsewhere.

Is there a firewall between you and the SQL server? Is SQL traffic allowed? Has SQL been setup to listen on a different port, rather than the standard 1433? Is it a default instance or named instance?

Is SQL browser service running?

10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.