Reputation: 381
I'm trying to connect Visual Studio to my local database using Microsoft SSMS, but when I try to create a new user, his password isn't what I have chosen. I have also tried modifying the "sa" user, but nothing helped because password is always the same and I can't get it. I want a user so I can connect my DB to Visual studio using SQL authentification. How could I change the user password?
Upvotes: 0
Views: 176
Reputation: 381
I solved this problem by using another method...i connected using Windows authentication instead so I didn't have to write credentials for any user, but just send server name
Upvotes: 1