AnsweredAssumed Answered

SQL connection string

Question asked by on Jun 6, 2011
Latest reply on Jun 8, 2011 by
Hi All,

I am trying to open a connection to my SQL 2008 server, and have been using the supplied examples and they do work as long as I am logged in (I have administrative rights).
However using our test system user account, I can not make it work.
I have tried to change the sql connection string by modifying the "Build SQL Server ConnectionString", specifying User ID and Password, but it keeps
trying to use the logged on user account domain\xxx when making the call to dbLib.OpenDatabase. This throws a SQLException: Login failed for user domain\xxx
I would expect it to use the credentials specified in the connection string ?
My connection string: Data Source=ServerName;Initial Catalog=DbName;User ID=UserId;Password=Password;integrated security=True;Pooling=True

Does anyone here have a working example ?

Best regards