SQL - Grant group access to database fails
Posted on 2013-06-11
Hoping someone can help me out here.
I've create a database in SQL 2005 and need to have users access it via Excel.
If I gran login access to a user account, excel quite happily connects, all is good.
I however want to grant access with an AD global group instead of per user. When I do so, using the same server & database permissions, Excel gives me a login failed.
To be clear, I'm assigning my database as the default database in the General tab.
Server Roles - Public (default)
User Mapping - public, db_datareader
In the server event log I get a Failure Audit on the user (when I've assigned group access to the database), event ID 18456.
Can't figure this out. Still searching...
Thank you for your time.