472,982 Members | 2,202 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,982 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 2329
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: lllomh | last post by:
Define the method first this.state = { buttonBackgroundColor: 'green', isBlinking: false, // A new status is added to identify whether the button is blinking or not } autoStart=()=>{
0
by: Aliciasmith | last post by:
In an age dominated by smartphones, having a mobile app for your business is no longer an option; it's a necessity. Whether you're a startup or an established enterprise, finding the right mobile app...
0
tracyyun
by: tracyyun | last post by:
Hello everyone, I have a question and would like some advice on network connectivity. I have one computer connected to my router via WiFi, but I have two other computers that I want to be able to...
2
by: giovanniandrean | last post by:
The energy model is structured as follows and uses excel sheets to give input data: 1-Utility.py contains all the functions needed to calculate the variables and other minor things (mentions...
4
NeoPa
by: NeoPa | last post by:
Hello everyone. I find myself stuck trying to find the VBA way to get Access to create a PDF of the currently-selected (and open) object (Form or Report). I know it can be done by selecting :...
1
by: Teri B | last post by:
Hi, I have created a sub-form Roles. In my course form the user selects the roles assigned to the course. 0ne-to-many. One course many roles. Then I created a report based on the Course form and...
0
NeoPa
by: NeoPa | last post by:
Introduction For this article I'll be focusing on the Report (clsReport) class. This simply handles making the calling Form invisible until all of the Reports opened by it have been closed, when it...
0
isladogs
by: isladogs | last post by:
The next online meeting of the Access Europe User Group will be on Wednesday 6 Dec 2023 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, Mike...
4
by: GKJR | last post by:
Does anyone have a recommendation to build a standalone application to replace an Access database? I have my bookkeeping software I developed in Access that I would like to make available to other...

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.