Mirroring between sp1 and sp2 - SQL Server Forums

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

High Availability (2005)

Mirroring between sp1 and sp2

Author

Topic

bogey
Posting Yak Master

166 Posts

Posted - 2007-05-30 : 17:02:00

Are there any problem with mirroring between sql server standard sp1 and sp2. We are doing some tests from our prod to a new server and we are getting the 1418 error

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2007-05-30 : 17:05:42

We are currently mirroring from sp1 to sp2 on multiple databases across multiple instances. We haven't encountered any errors.

We upgraded the mirror site to sp2 while mirroring was there though. We'll be upgrading the other site to sp2 soon.

Do you have the user error message for 1418?

Tara Kizer
http://weblogs.sqlteam.com/tarad/

bogey
Posting Yak Master

166 Posts

Posted - 2007-05-31 : 09:55:23

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

An error occurred while starting mirroring.

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

Alter failed for Database 'TEST'. (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://DBSQLP01.xxx.edu:5022" 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.2050&EvtSrc=MSSQLServer&EvtID=1418&LinkId=20476

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

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

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2007-05-31 : 12:19:28

Can you telnet to port 5022 from the server that is getting this error to DBSQLP01?

Tara Kizer
http://weblogs.sqlteam.com/tarad/

bogey
Posting Yak Master

166 Posts

Posted - 2007-05-31 : 13:22:54

Seems like doing this solved the problem.

SELECT * FROM sys.tcp_endpoints
then drop the endpoint
DROP ENDPOINT Mirroring

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources