Re: add domain login from management studio
- From: JPD <nospam@xxxxxxxxxx>
- Date: Tue, 10 Jul 2007 13:18:40 +0100
Hi Matt,
It's probably that when you're logging into the system on that desktop you are logging into the local computer instead of the domain. So log back off, hit CTRL-ALT-DEL click on options and make sure that you log into the domain and not the local computer. That should solve it.
Jonathan
Matt Ziegler wrote:
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: ExecutionEngineException in Sql 2005 management studio
- Next by Date: Re: Search Stored Procedures and User-Defined Functions
- Previous by thread: Add-in for SQL Server Mnagement Studio 2005
- Next by thread: Re: SQL Server Express
- Index(es):
Relevant Pages
|
