July 7, 2008 at 10:12 am
Hey guys.... I am having some issues with a remote connection to our instance of SQL. On the installed instance I am trying to connect to, we have selected to allow remote connections, and have no maximum number of concurrent connections. The connections string is as follows:
Initial Catalog=DATABASENAME; Datasource=IP ADDRESS; User ID=sa; PWD=xxx
This returns sql Error 40 and says that our server does not allow remote connections... anyone know what I might be missing here?I found a few Microsoft articles about this, but nothing that corrected the problem. I just want to connect via TCP/IP using an IP address. Thanks.
July 7, 2008 at 10:19 am
A couple of things.
Be sure the remote connection is using TCP/IP on both sides. It must be enabled on the server and set to be used on the client.
Also, if it's remote, be sure that TCP 1433 is open.
July 7, 2008 at 10:20 am
Let me elaborate a little. I apologize for the lack of information...
This is MS SQL Server 2005 Standard edition. Surface Area Configuration shows that remote connections are allowed and that TCP/IP only connections are allowed remotely. Also, my browser service is running. Thanks.
July 7, 2008 at 10:21 am
Steve Jones - Editor (7/7/2008)
A couple of things.Be sure the remote connection is using TCP/IP on both sides. It must be enabled on the server and set to be used on the client.
Also, if it's remote, be sure that TCP 1433 is open.
Now, what do you mean be sure that the connection is using tcp/ip on both sides?
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply