September 2, 2011 at 1:22 pm
hi all,
Yesterday i've added a sqladmins group in my windows 2003 domain controller, in which i've added 5 users as sql dba admins,
and then on my windows 2003 member server where sql server 2005 is installed, i created a sql server login with the sqladmins group and assigned sysadmin server role,
now when i am trying to connect using one of the 5 users (say sqladmin1) login, i am getting the above error
login failed or valid login but server access failure.
when i've tried to connect using via sqladmin1 individual login , i was successful,
can u please help me in this regard, btw the exact message even in the error log has no extra information.
September 2, 2011 at 2:45 pm
just curious ... Is the domain group name length > 20 chars ?
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
September 3, 2011 at 1:08 am
no! the domain name is less than 20 chars, why?
September 3, 2011 at 1:45 am
no, not the domain name, the group name you intended for your collection of sql sysadmins.
( there have been issues with it, although I don't have the refs at hand right now )
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
September 4, 2011 at 6:21 am
okay! it is also less than 20 name: sqladmins
September 4, 2011 at 9:00 am
Troubleshooting Login failed Error 18456:
http://sql-articles.com/articles/troubleshooting/troubleshooting-login-failed-error-18456/
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply