June 24, 2009 at 8:28 am
Hi All,
Sql server is running on a particular domain and I got a request to access a database from a user in different trusted domain.
Through the Search button, I selected the particular trusted domain and retrieved the NT id of the particular user.
When I click on "OK" button to create the login I am getting the following error,
TITLE: Microsoft SQL Server Management Studio
------------------------------
Create failed for Login 'domain\username'. (Microsoft.SqlServer.Smo)
------------------------------
ADDITIONAL INFORMATION:
An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)
------------------------------
Windows NT user or group 'domain\username' not found. Check the name again. (Microsoft SQL Server, Error: 15401)
Any help is greatly appreciated.
---------------------------------------------------
Thanks,
Satheesh.
June 24, 2009 at 9:12 am
you can try this:
Can the client connect using IP address of this SQL server.
on Client Machine:
Start->run->cliconfg
add TCP/IP in Alias tab and specify the IP of this Database Server.
save and close.
in the client Enterprise Manager or SSMS, register another server using IP address.
then check to see if you are able to connect.....
or try SQL logins insted of Windows NT logins... this might be the only way to connect to SQL server across domain.
Maninder
www.dbanation.com
June 24, 2009 at 9:34 am
Thanks for a your reply Mani.
As a work around, I had shared a sql login for that user in the dev box ( the project is in development) and he can able to access the server with that ID. But I can't do the same in production.
And I am getting this error, while I am trying to Create a login for that particular user using windows authentication. So I am unable to create a login with his NT account itself.
---------------------------------------------------
Thanks,
Satheesh.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply