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.