I have a sql2k clustered server. now this server need remote server connection to other server. I have set up remote server on both site, but only one way works: connection to clustered server is ok while from clustered server I can not get the remote sit
e. error msg:
Server: Msg 17, Level 16, State 1, Line 1
SQL Server does not exist or access denied.
I am sure network access to 1433 port on both virtual server IP and remote server IP is OK Do I still need to open 1433 port on each node of clustered server to remote server?
Pls help.
Thanks
George
If the remote server is in another forest/domain you may need a two-way trust between the domains. What forest + domain functionality level are they both running? (eg W2K mixed, W2K native, W2K3 native etc). Can you browse the Active Directory objects i
n the remote site (from both directions) using dsa.msc? If you can you don't have a trust problem. If the trusts are okay (or both servers are in the same domain) then you can add the SQL Server service account from one server to the local admins group
of the other (just as a test!). If this fails then you know you have bigger problems on your WAN than just SQL Server and permissions.
|||Thanks Stephen. But I can not see active directory; and the remote server is in a workgroup, not a domain.
pls advise, thanks a lot
George
No comments:
Post a Comment