dbTalk Databases Forums  

Remote server setting -- Urgent

microsoft.public.sqlserver.clustering microsoft.public.sqlserver.clustering


Discuss Remote server setting -- Urgent in the microsoft.public.sqlserver.clustering forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
George
 
Posts: n/a

Default Remote server setting -- Urgent - 04-02-2004 , 02:16 PM






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 site. error msg:
Server: Msg 17, Level 16, State 1, Line
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
Thank
George

Reply With Quote
  #2  
Old   
Stephen Strong
 
Posts: n/a

Default RE: Remote server setting -- Urgent - 04-04-2004 , 05:51 PM






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 in 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.

Reply With Quote
  #3  
Old   
George
 
Posts: n/a

Default RE: Remote server setting -- Urgent - 04-05-2004 , 06:16 AM



Thanks Stephen. But I can not see active directory; and the remote server is in a workgroup, not a domain
pls advise, thanks a lo
Georg


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.