Alter database failed error message when setting up database mirroring

Posted on by jayanth.kurup

TITLE: Microsoft SQL Server Management Studio

——————————

Alter failed for Database ‘Mirror’. (Microsoft.SqlServer.Smo)

The ALTER DATABASE command could not be sent to the remote server instance ‘TCP://XXXXXX:2022’. The database mirroring configuration was not changed. Verify that the server is connected, and try again. (Microsoft SQL Server, Error: 1456)

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

 

Please Consider Subscribing

Subscribe

This post was written by Jayanth Kurup. A Microsoft SQL Server Consultant and Trainer based out of Bangalore, India. Jayanth has been working on MS SQL Server for over 15 years. He is a performance tuning and Business Intelligence expert. Having worked with companies like Microsoft, DELL, Wells Fargo, Thomson Reuters and many other fortune 100 companies. Some other technologies Jayanth works on include Microsoft Azure, PowerBI, Python and AWS. When he isn’t consulting or training, Jayanth like to travel, paint and read. He is also very active in social causes and the founder of Enabled Business Solutions. Visit his company by clicking the link in the menu or email him directly.