July 28, 2011 at 12:24 am
Hi All,
We have set up a DB Mirroring without witness server and its working fine.
We tried to set up the mirror with witness server getting below error:
TITLE: Database Properties
------------------------------
An error occurred while starting mirroring.
------------------------------
ADDITIONAL INFORMATION:
Alter failed for Database 'MirroringHA'. (Microsoft.SqlServer.Smo)
------------------------------
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://servername.ad.ii.com:5024'. 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=09.00.4035&EvtSrc=MSSQLServer&EvtID=1456&LinkId=20476
------------------------------
BUTTONS:
OK
------------------------------
3 instances are 9.00.4035 version and developer edition.
I have provided Grant control on NT Authority\Systems.
Services are running on Local System account.
End Point are 5022-- Principle
5023 -- Mirror
5024 -- Witness.
Can you please let me know how to resolve the issue ?
Thank You.
Regards,
Raghavender Chavva
July 29, 2011 at 5:00 am
I think your issue is the use of local system accounts - ideally you should be using domain accounts. If you are not using domain accounts you need to use certificates, as explained here:
http://technet.microsoft.com/en-us/library/ms366346.aspx
Mike.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply