Server Registration Issues

Hot Topic

Backup error
Data alignment in Textbox
Stored procedure problem
transform Active X script to what?
Delte from 3 table in one procedure
DROP USER
using for xml and xquery to create a new xml
SQL Server 2005 Evaluation edition setup fails!
Changing SID of a USER
file corrupted message on query of restored db

SQL Server

problems connecting to sql express 2005 server, where mdf file go?
SQL SERVER 2005 Logon Service Failed
How to specify datatypes for Excel columns?
Intermittent rsProcessingAborted - rsErrorOpeningConnection across all reports, users
Connection Manager problem in ScriptComponent
sp_browsereplcmds causes "Failed to initialize the Common Language Runtime..."
SQL Server 2005 Express install---Win 3.1 Installer
Truncate Table function not available
SQL Server Setup Fails
Is there a way to have numbers listed against each rows

Server Registration Issues

Hi All,

I have a very critical question. It is very important for to me to go on my disaster recovery test. I have a production machine that resides in a different geographic location and I have another machine that resides on with me. When I try to register the production machine from my side there is no problem, I can do it however when I try to connect from my remote machine to the machine that is with me then the production machine is able to register the machine that I have but cannot connect to the database. The error that I am getting is:

" A connection could not be established to 'IP Number'

Reason: SQL Server does not exist or access denied ConnectionOpen(Connect())...

Please verify SQL Server is running and check your SQL Server registration properties..."

I have checked SQL Server properties, I tried to define everything the same, but I dont know wheather I missed something or not. Or is this a network problem I am not clear about that. I am stocked here. Can someone help me on this issue please

PS : The reason I m doing is I will create log-shipping therefore I need this connection

Regards

LS




Answer this question

Server Registration Issues

  • HJ2PM

    A few possible causes. Firstly, can you ping the server name

    Make sure your firewall is not blocking the port that SQL is running on - 1433 or another port if named instance.

    Have you tried creating an alias for the server in the Client Network Utility On the machine you are trying to connect from, open this tool and go to the alias tab. In the network libraries, choose tcp/ip. In server name, enter the IP Address and the instance name e.g. : 192.168.1.2\Sales. Enter a friendly name in the server alias e.g. : londonSales, and optionally specify a port - try it with the dynamic setting first and see if that works.

    Hope this helps.



  • Shirvo

    Thank you

    Our Admin made me crazy. He told me that everything was set on Firewall , I was checking all the possible ways and then I realized that I wasnt able to ping the machine. It turned out to be a firewall problem. One quetion when the SQL makes the register does it always send ping to the other machine to check connection or after you register pinging is not important

    Thanks

    LS



  • smurf347

    SQL doesn't ping as such, it just stores the connection information and each time you connect it uses that information to connect.

  • Server Registration Issues
Answer this question