Connection error for SQL Server OleDB

  • Thread starter Thread starter feng
  • Start date Start date
F

feng

I am connecting to SQL Server through OleDB provider. The
SQL server I am testing is running on the same machine
that my VB.Net app is running. Here is my connection
string:

"Provider=SQLOLEDB;Data
Source=MyMachine\MySQLInstance;Initial catalog=testDB;user
id=sa;Password=mypwd"

What I got is an error message that says "Login failed for
user 'sa'. Reason: Not associated with a trusted SQL
Server connection."

What am I doing wrong here?

Please help!

Thanks
 
Back
Top