473,325 Members | 2,771 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,325 software developers and data experts.

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 2350
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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

3
by: stabbert | last post by:
We are running DB2 UDB 8.1.6 in a partitioned environment where we have 8 physical nodes. We have a process that remotely connects to each individual node and loads some data. By setting the...
1
by: Jim Bayers | last post by:
Our network nazi doesn't want us running a webserver on the server that has a connection to the campus database so we created a remote object that runs as a windows service. The windows service...
16
by: peshekeedweller | last post by:
Using asp.net 1.1. vb.net 2003. I am trying to connect to a remote sql server 2000 on a virtual machine running windows 2000 server. I can connect through the server explorer in visual studio,...
1
by: davidman73 | last post by:
Hello, I have VS 2005 with SQL Server Express in the same machine, but need to connect to a remote SQL Server 2000. I'm getting this error: An error has occurred while establishing a...
0
by: Suresh | last post by:
Hi Guys I have Db2 server installed on remote server. i am connecting to that remote server by using VPN. I want to connect that remote DB2 server instance using my local machine DB2...
14
by: Marcus | last post by:
I have a function that simply returns TRUE if it can connect to a particular Sql Server 2005 express, or FALSE if it cannot. I am getting some strange error codes returned when the computer that...
8
by: =?Utf-8?B?U3JpcmFtIE1hbGxhanlvc3VsYQ==?= | last post by:
Hi, I am not sure whether this is the correct newsgroup where I need to post my question. Let me know where I need to post for a quick response. I get the following error when I try to connect...
3
by: Me LK | last post by:
I did a search but could not find an aswer that worked so here it goes. I just did an upgrade from 2003 to vs 2005 express. I am using a remote sql server 2000. I specifically upgrade to make...
0
by: aboutjav.com | last post by:
Hi, I need some help. I am getting this error after I complete the asp.net register control and click on the continue button. It crashed when it tries to get it calls this Profile property ...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.