Is there a SQL Server command to connect a user of a single database to a login for the database server of the same name?
For example:
Database Server – Default Instance
Database: TestDBServer Login – TestUser
Existing user on TestDB – TestUser
If I try to make the TestUser
login a user of the TestDB
database, the "User, group, or role" already exists.
Does anybody know of an easy way to assign the DB user to the server login?
Best Answer
The new way (SQL 2008 onwards) is to use ALTER USER