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
FiremanFpGAsked:
Who is Participating?
 
FiremanFpGConnect With a Mentor Author Commented:
I Found the problem, i needed to add the users to the local SQL group on the server (Local Server 2008 group)
now it`s working
0
 
Scott PletcherSenior DBACommented:
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.
0
 
FiremanFpGAuthor Commented:
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
0
Cloud Class® Course: Python 3 Fundamentals

This course will teach participants about installing and configuring Python, syntax, importing, statements, types, strings, booleans, files, lists, tuples, comprehensions, functions, and classes.

 
Scott PletcherSenior DBACommented:
Oh, from Excel.  Can you connect from SS Management Studio as that AD user?
0
 
John_VidmarCommented:
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.
0
 
FiremanFpGAuthor Commented:
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
0
 
Scott PletcherSenior DBACommented:
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.
0
 
FiremanFpGAuthor Commented:
how do i change it in excel ?
0
 
FiremanFpGAuthor Commented:
that was the solution that solved it
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.