VB.Net Sql Connection Problem

[bb9786]

Hi all,

I have a form that connects to a Sql Server 2005 database. I specify the connection string, but when the form opens it gives me a Microsoft .Net Framework error that says "Login failed for user 'OPERATIONS\xxxx'". The 'OPERATIONS\xxxx' is the user's Windows login id. My connection string specifies a login id and password for the sql database though. The program acts like it's bypassing the login info from the connection string and trying to connect using the user's Windows id.

Here's my connection string -

Dim ConnectionString As String = "Network Library=DBMSSOCN;Data Source=*server*,1433;Initial Catalog=*dbname*;User ID=*userid*;Password=*pwd*"

Dim cnAutoDB As New SqlConnection(ConnectionString)

This connection works for other programs that read from the same database. Also, if the user's Windows login id is added to the list of user's in the Sql database, it works fine. I'm perplexed. Any help would be greatly appreciated.

 

[gmmastros]

try adding Trusted_Connection=False; to the connection string.

-George

"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom

 

[bb9786]

Nope, that didn't work either. I'm getting the same error message.

 

[Sorwen]

My only thought would be to make sure you don't/didn't have a open connection to the SQL server in Server Explorer. If I remember right that will try to connect before anything else is done. Or have you stepped through and seen that it does hit your connection string before you get the error?

-I hate Microsoft!
-Forever and always forward.
-My kingdom for a edit button!

 

[Kliot]

If you are using windows loging try removing the username and password and set "Integrated Security=True