Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Express Edition and Compact Edition (2005)
 Connect to SQL Express 2005 by IP address

Author  Topic 

Razzle00
Starting Member

35 Posts

Posted - 2007-08-31 : 10:27:28
Hi,

I am trying to connect to SQL Server Express 2005 from a remote connection through the internet using an IP address in a string like this;

Data Source=190.190.200.100,1433;Network Library=DBMSSOCN;Initial Catalog=myDataBase;User ID=myUsername;Password=myPassword;

the error I am getting is this

A connection was successfully established with the server, but then an error occurred during the login process. (provider: TCP Provider, error: 0 - The specified network name is no longer available.)


anyone have any suggestions or maybe another way to achieve this type of connection?

Thanks,

Razzle

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2007-08-31 : 15:31:44
Is port open on your network?
Go to Top of Page
   

- Advertisement -