Hello SQL Guru,
I’m newbie to create SQL Login that utilized Active Directory.
I have a SQL Server 2008 Enterprise edition 64-bits that runs in Window Server 2008 R2 Standard Edition 64-bit operating Systems.
I configured the SQL Server 2008 with Window Authentication.
Then, I login with built-in Administrator account into computer and connected to my SQL Server 2008.
e.g: Object Explorer displayed COMPUTER NAME\Database Instance Name (SQL Server 10.0.2531 – COMPUTER NAME\Admin Account)
Then, I created SQL login on the following:
CREATE USER DomainName\User Name FOR LOGIN DomainName\User Name
EXEC sp_addrolemember N’db_datareader’, N’DomainName\User Name’
I tested it out and the specific login still did not have an access to specific database instance e.g: “AccountingDatabase”
Also, I did not see the “User Mapping” under properties checked/assigned to those specific user.
Can anyone help and give me light on best practice.