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.
| Author |
Topic |
|
emest
Starting Member
5 Posts |
 Posted - 2009-02-19 : 03:31:30
|
| Hello,I have a problem when starting mirroring in High availability mode. Everything goes ok, if I do mirroring without Witness. Everything goes also ok with Witness during the configuration, but when I start mirroring, it gives the error (at the end of this msg).Principal and Mirror servers are running SQL Server 2008, and Witness is running SQL Server 2005 Express. Similar mirroring is already working with same Witness server, but in that mirroring Principal and Mirror are also running SQL Server 2005.So, is there some incompability problem if P and M are running SQL Server 2008 and W is running SQL Server 2005? Or should same Witness server be able to be Witness for several (more than 1) mirrorings?And here is the error (I replaced some unessential words with x's):TITLE: Database Properties------------------------------An error occurred while starting mirroring.------------------------------ADDITIONAL INFORMATION:Alter failed for Database 'xxxxx'. (Microsoft.SqlServer.Smo)For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=10.0.1600.22+((SQL_PreRelease).080709-1414+)&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 ALTER DATABASE command could not be sent to the remote server instance 'TCP://WITNESS.xxxx.xx:5022'. 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.00.1600&EvtSrc=MSSQLServer&EvtID=1456&LinkId=20476------------------------------BUTTONS:OK------------------------------ |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2009-02-19 : 06:56:39
|
| Yes the witness should be same version. |
 |
|
|
emest
Starting Member
5 Posts |
Posted - 2009-02-23 : 06:14:19
|
quote:
Originally posted by sodeep
Yes the witness should be same version.
Can anyone confirm this? |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2009-02-23 : 07:24:29
|
quote:
Originally posted by emest
quote:
Originally posted by sodeep
Yes the witness should be same version.
Can anyone confirm this?
Then What have I said? |
|
|
|
emest
Starting Member
5 Posts |
Posted - 2009-02-23 : 07:44:15
|
quote:
Originally posted by sodeep
quote:
Originally posted by emest
quote:
Originally posted by sodeep
Yes the witness should be same version.
Can anyone confirm this?
Then What have I said?
I just want to be 100% sure that SQL Server 2005 and 2008 are incompatible in this case. Thanks for response, anyway :) |
|
|
|
|
|
|
|
|
Database Mirroring problem (Witn. is 2005 express)