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.
| Author |
Topic |
|
irenavassilia
Starting Member
1 Post |
 Posted - 2008-05-15 : 12:11:16
|
| Hi, I'm not a DBA and our DBA is not available.I get the following error for my connection string when I try to connect to a specific database on the SQL Server 2005:Below is the connection string:cnn = "data source=" & CompanyT & ";driver=VPC-002\BALGORD\\SQLEXPRESS;AttachDBFilename=" & ArInvoice.FilePath & ";username=sa;password=balgord;Trusted_Connection=no"SQLdb.Open cnnI get the following error:[Microsoft][SQL Native Client][SQL Server]Login failed for user. the user is not associated with a trusted SQL Server connectionMixed mode is set in the Server Security properties (SQL Server authenticaion and Windows Authentication).I searched googled and everyone says set the authentication to mixed mode... It is set to mixed mode so I'm all out of ideas. I think if there was an error in the connection string it would give me a different error right? I dont know I'm all out of ideas, any help will be greatly appreaciated.Thank you.Regards,Irena V. |
|
|
rgombina
Constraint Violating Yak Guru
319 Posts |
Posted - 2008-05-15 : 12:32:21
|
| Create a DB connection from BIDS and use connection string from properties. |
 |
|
|
|
|
|
Unable to connect to SQL Server 2005 though VBA