December 3, 2002 at 10:04 am
I could not register the server on different domain in Enterprise Manager. Is there any workaround for that. My EM is on one domain while the SQL-Server is located on another. I could ping to the server but don't know what needs to be set up.
December 3, 2002 at 10:24 am
What error are you getting? Are you getting server not found or are you getting a login failure error?
If the login failure error and you're trying to use Windows authentication to make the login:
Does the domain the SQL Server resides in trust the domain your user account resides in? If it is, your user account will need to be granted login rights (YourDomain\YourUser).
If the domain isn't trusted, you'll need a local account on the server that matches your username and password exactly. That account will need to be granted logon rights, etc.
K. Brian Kelley
http://www.truthsolutions.com/
Author: Start to Finish Guide to SQL Server Performance Monitoring
http://www.netimpress.com/shop/product.asp?ProductID=NI-SQL1
Edited by - bkelley on 12/03/2002 10:26:13 AM
K. Brian Kelley
@kbriankelley
December 5, 2002 at 2:07 pm
Thanks, I did not get any error because I just could not find the server name on the list of SQL-server in my domain (as it is located in another domain). When I tried using the IP address to register the SQL-server, it did return an error saying could not find the SQL-Server. However, my colleagues just move it to my domain and I don't have any problem finding it now. Thanks for you input.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply