SQL .NET STRING PROBLEM

  • Thread starter Thread starter Gina Hernandez
  • Start date Start date
G

Gina Hernandez

Hello:

I am using this connection in my .NET 2003 web application , in order to
establish a connection with my sql database , that is in a MS 2003 server.
The database is defined in a INSTANCE

"Server=SERVER\INSTANCE,port;Database=Your_Database_Name;User
ID=Your_Username;Password=Your_Password;Trusted_Connection=False"

I am not able to get a connection, when I use the port I am getting the
message SQL SERVER DOES NOT EXISTS, but If I dont' do it I am getting the
message "login failed"

I have been dealing with this for so long, I need help urgently.

Could somebody tell me if I have to change the connection because of 2003,
of there is something that neeeds to be installed in both server to let the
two servers talk each other.

thanks
 
Gina..

as far as I can tell, your connection string should work..

however a couple of sugestions..

1. If you have a userid and pasword, don't say trusted connection = false
2. Try using the tcpip network lib in your connection string
Network Library=DBMSSOCN;

HTH


Rob
 
Back
Top