Database Mirroring - Port Error

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

SQL Server Administration (2005)

Database Mirroring - Port Error

Author

Topic

sbalaji
Starting Member

48 Posts

Posted - 2007-09-11 : 15:32:41

OS:Windows XP Professional Edition
SQLServer: 2005(DE).SP2(Have installed 2 instances of 2005 in my local system)
I am trying to do database mirroring,via SQL Server Management Studio.
1)configure security setup,(showed success).
2)when i start mirroring,i am getting the following error.

TITLE: Database Properties
------------------------------

An error occurred while starting mirroring.

------------------------------
ADDITIONAL INFORMATION:

Alter failed for Database 'MIRROR_DEMO'. (Microsoft.SqlServer.Smo)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.3042.00&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Alter+Database&LinkId=20476

------------------------------

An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)

------------------------------

The server network address "TCP://tp190.DELL.servers.corp:5023" can not be reached or does not exist. Check the network address name and that the ports for the local and remote endpoints are operational. (Microsoft SQL Server, Error: 1418)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.3042&EvtSrc=MSSQLServer&EvtID=1418&LinkId=20476

------------------------------
BUTTONS:

OK
------------------------------

I have followed the microsoft link and i have enabled the port numbers aswell.

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2007-09-11 : 15:37:01

Did you setup the end points on both the principal and mirror server?

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

sbalaji
Starting Member

48 Posts

Posted - 2007-09-11 : 15:52:33

Yes.Both the instances are holding values
I have checked these tables
sys.tcp_endpoints
sys.endpoints
sys.database_mirroring_endpoints

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2007-09-11 : 15:56:25

I wrote a blog that shows the steps to setup database mirroring via T-SQL. Check it out to ensure you haven't missed a step:

http://weblogs.sqlteam.com/tarad/archive/2007/02/13/60091.aspx

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2007-09-11 : 15:57:55

If you haven't missed anything, then I'd suggest trying to telnet to tp190.DELL.servers.corp over port 5023 on the server where you are getting the error to ensure that it can connect to the specified serverName and port. If you aren't able to telnet to it, then the problem is not with SQL Server or database mirroring.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

sbalaji
Starting Member

48 Posts

Posted - 2007-09-11 : 17:20:47

I am not able to connect thru telnet.telnet service is disabled,i am not able to start it.Do we have any link to this??

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2007-09-11 : 23:33:10

You can check with you network guys for port issue.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources