add domain login from management studio
- From: Matt Ziegler <idahoakl@xxxxxxxxx>
- Date: Wed, 13 Jun 2007 20:46:52 -0000
We have a SQL Server 2005 SP2 server that also functions as a
secondary domain controller in active directory. Everything works
extremely well except for 1 bug that was found today. Currently
windows authentication is the only method. When creating a new sql
login either physically at the server or through a remote desktop
connection the user is found in the domain and works just fine.
However when trying to do the same process using management studio
from a desktop connecting to the sql instance as soon as you try to
find the user in the domain you get this error: "The program cannot
open the required dialog box because it cannot determine whether the
computer name "COMPNAME" is joined to a domain."
I have sysadmin privileges on the sql server and if I use my login
name on the server physically I am able to create logins.
Any help would be greatly appreciated.
Thanks
Matt
.
- Prev by Date: Re: Server registration
- Next by Date: SQL Server 2005 login with Windows Authentication
- Previous by thread: Server registration
- Next by thread: SQL Server 2005 login with Windows Authentication
- Index(es):
Relevant Pages
|
|
