Trsuted in MS-SQL 2005

ASH

Active member
Joined
Nov 20, 2005
Messages
30
Location
Riyadh
Programming Experience
Beginner
I am try to connect to MS-SQL 2005 server locally and I have this error "

VB.NET:
Login failed for user 'MMMUser'. The user is not associated with a trusted SQL Server connection.

my connection string is
VB.NET:
data Source=.;Database=MMMDB;User ID=MMMUser;Password=!MMM!;


How I can fix this problem ?
 
Well.... 1) For starters, decide how you want to connect, using a trusted connection or not. - what you are using there isn't a trusted connection. 2) Take a look at ConnectionString.com for the proper format for a connection string.
3) Lastly, no matter the connection type, make sure that the user you are trying to connect as has permissions to the database.

-tg
 
Back
Top