468,247 Members | 1,325 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,247 developers. It's quick & easy.

Help connecting to remote Sql server

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.
Nov 20 '05 #1
5 2171
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

bill wrote:
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.


--
Best Regards - OHM

O_H_M{at}BTInternet{dot}com
Nov 20 '05 #2
* bi**@emerging.com (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>?

--
Herfried K. Wagner [MVP]
<http://www.mvps.org/dotnet>
Nov 20 '05 #3


Yes. sorry should have been 25.25.25.25

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

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
Nov 20 '05 #4
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
Nov 20 '05 #5


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

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
Nov 20 '05 #6

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

1 post views Thread by Jim Bayers | last post: by
16 posts views Thread by peshekeedweller | last post: by
reply views Thread by Suresh | last post: by
8 posts views Thread by =?Utf-8?B?U3JpcmFtIE1hbGxhanlvc3VsYQ==?= | last post: by
3 posts views Thread by Me LK | last post: by
reply views Thread by NPC403 | last post: by
reply views Thread by kermitthefrogpy | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.