Help connecting to remote Sql server

[bill]

I am having difficulties connecting to a remote Sql server database in
VB.net.

Lets say my remote server is found at 255.255.255.255 and its name is
MyServer. The database is called MyDatabase.

I drap my SQLDataAdapter on to the form and set up a new connection at
the wizard. I am putting the IP address of my server under server name
and entering my login and password. I get an access denied. Sql Server
Error: 17.

I know when I access a local database I put in something like
MyServer\VSdotNet.dbo.

Do I need to put something like that when connecting to a remote
server? if so how would I find the name of the instance of my remote
sql server?


Any help you can provide would be great.

 

[One Handed Man]

First of all 255.255.255.255 is not an IP address, its a poorly formed
subnet mask, however, to asnwer you question you need to set up the
connection string for it, this should help a bit.

http://www.connectionstrings.com/

Regards - OHM

 

[Herfried K. Wagner [MVP]]

* (e-mail address removed) (bill) scripsit:

I am having difficulties connecting to a remote Sql server database in
VB.net.

Lets say my remote server is found at 255.255.255.255 and its name is
MyServer. The database is called MyDatabase.

I drap my SQLDataAdapter on to the form and set up a new connection at
the wizard. I am putting the IP address of my server under server name
and entering my login and password. I get an access denied. Sql Server
Error: 17.

I know when I access a local database I put in something like
MyServer\VSdotNet.dbo.

Do I need to put something like that when connecting to a remote
server? if so how would I find the name of the instance of my remote
sql server?

Did you have a look at <http://www.connectionstrings.com>?

 

[Bill McCloskey]

Yes. sorry should have been 25.25.25.25

I had already seen that resource but was still unable to connect. Any
other suggestions?

 

[Cor]

Hi Bill,

If you did it with the wizard, you probably also have done a test for the
connection, did that tell that there was a connection.?

Cor

 

[Bill McCloskey]

I did and now I get a "sql server error: 6" message