SQL 2008 - domain user can`t login , local SQL user can
Hello,
I created a new login on my sql server for a domain user.
local sql user works with no problem
I checked the user and pwd in AD - all OK
user is enabled & i checked the effective permissions and the user has connect & select enabled.
Windows server 2008 R2 + SQL Server 2008
thanks in advance
I created a new login on my sql server for a domain user.
local sql user works with no problem
I checked the user and pwd in AD - all OK
user is enabled & i checked the effective permissions and the user has connect & select enabled.
Windows server 2008 R2 + SQL Server 2008
thanks in advance
Scott Pletcher
Verify that the AD user/group has access to the default db assigned in SQL Server for that user/group. Login will fail if you can't get to the default db -- or the db specified in the connect string that overrides the default db.
ASKER
I tried adding the account to the default database but same problem
I also changed the default database to the database that I need access to and verify the user I created has datareader rights - same error
I can login using management studio with the user but when i try to connect from excel I get an error - login failed for user
I tried with domain\user syntax and just the user - but same error on both
I also changed the default database to the database that I need access to and verify the user I created has datareader rights - same error
I can login using management studio with the user but when i try to connect from excel I get an error - login failed for user
I tried with domain\user syntax and just the user - but same error on both
Oh, from Excel. Can you connect from SS Management Studio as that AD user?
My interpretation, you've created a SQL Server instance on your workstation and you want someone on your domain to interact with that instance via Active-Directory. Without seeing the error, and assuming you've created the login correctly in your instance; I suspect a firewall is preventing access to the port your instance is listening for requests.
ASKER
I can connect with the AD user with the management studio.
About the excel - if I use an SQL user I can connect with no problem
About the excel - if I use an SQL user I can connect with no problem
Probably the Excel connection is set to "native SQL login" and not to "trusted login". You need to change the connection setting to specify "trusted"/"domain" login in Excel when using an AD login.
ASKER
how do i change it in excel ?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
that was the solution that solved it