Cannot connect to sql server over the network.

  • Thread starter Thread starter Mark
  • Start date Start date
M

Mark

This is really weird.

Basically I have the website(asp.net 1.1, written in vb) and sql
server 2000 running on my machine.

I have to copy the database over to another server for testing. So i
change the connection string to point to that database, and it doesn't
work. I've tried it on 3 different machines now. Changing the
connection string correctly each time.
And nothing. But it always works when connecting to the database thats
local, not remote.

Can anyone help?

Cheers
Mark
 
User ID=sa;Password=;Initial Catalog=testdatabase;Data Source=1022_CCR\HARPER"

I suppose that you adapt the 'data source' to match the proper machine. However, you might have problems using the user/password combination. Are you sure the remote machines have 'SQL Authentication' enabled and the 'sa' password is indeed empty?

You can try to connect to the remote machine using SQL Query Analyzer and specify 'SQL Authentication' with username 'sa' and an empty password. If it doesn't work, then check if 'SQL Server and Windows' authentication is enabled (SQL Server properties, security tab). If not, then you'll need to enable it or use the Windows user settings. If the authentication is correct, then check the 'sa' password.
 
William Ryan eMVP said:
Try using the IP Address and see if that helps. Also, don't use SA and a
blank password - that's begging for trouble.

Let me know if that doesn't fix it.

--

W.G. Ryan, eMVP

Have an opinion on the effectiveness of Microsoft Embedded newsgroups?
Let Microsoft know!
https://www.windowsembeddedeval.com/community/newsgroups
Click to expand...

Tried it with the ip and specifying the port number, still no joy. We
have just thought of something though. On the pc I'm using it has
securemote vpn clien installed. It could be that. Have had problems
with it i nthe past. Will find out on monday. What do you think?
 
Back
Top