June 2, 2005 at 10:59 am
I have PC_1 with MSDE 2000. Is not in Domain. Is in WORKGROUP.
I have PC_2 with SQL Server 2000. Is in domain.
PC_1 pings to PC_2 and vice versa.
I want to add (Register New Server in Enterprise Manager) this servers but they don't see each other. (osql -L)
What's the solution?
Thank's Claudia
Cláudia Rego
www.footballbesttips.com
June 3, 2005 at 2:02 am
Check whether the Network protocols (TCP/IP and Named Pipes) are enabled at both PCs.
Enable the Network protocols using SQL Server Network Utility (To enable, Right click on the server registration in the Enterprise Manager and select properties, then click Network Configuration under General tab)
One more important issue, in PC1 u need to set authentication. By default in MSDE 2000, authentication will be Windows only. U need to set it as SQL Server and Windows as PC1 is WORKGROUP machine. (To set authentication, Right click on the server registration in the Enterprise Manager and select properties, then select SQL Server and Windows optin in the Security Tab)
Hope this will solve your problem.
June 3, 2005 at 4:31 pm
to add to Mahender post
if PC1 is XP PRO sp2 you will need to configure or turn off the windows fire wall.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply