Network_Padawan
asked on
SQL 2008 Mirroring error
I am configuring mirroring on two sql 2008 servers. I have a principle server and a standby server with a restored database (in NORECOVERY mode).
When I choose to mirror, and then choose the primary and mirror server...I get the following error. Now, i can connect to both servers, ping each other and with DNS, can telnet to each respective port on 5022 so its not a connectivity issue.
TITLE: Database Properties
-------------------------- ----
An error occurred while starting mirroring.
-------------------------- ----
ADDITIONAL INFORMATION:
Alter failed for Database 'GGConnectV3'. (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.Conne ctionInfo)
-------------------------- ----
The server network address "TCP://WIN-4DL3VZ7HITK.cor p.cluster. net: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=10.00.1600&EvtSrc=MSSQLServer&EvtID=1418&LinkId=20476
-------------------------- ----
BUTTONS:
OK
-------------------------- ----
Can it be a user security issue?
When I choose to mirror, and then choose the primary and mirror server...I get the following error. Now, i can connect to both servers, ping each other and with DNS, can telnet to each respective port on 5022 so its not a connectivity issue.
TITLE: Database Properties
--------------------------
An error occurred while starting mirroring.
--------------------------
ADDITIONAL INFORMATION:
Alter failed for Database 'GGConnectV3'. (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.Conne
--------------------------
The server network address "TCP://WIN-4DL3VZ7HITK.cor
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=10.00.1600&EvtSrc=MSSQLServer&EvtID=1418&LinkId=20476
--------------------------
BUTTONS:
OK
--------------------------
Can it be a user security issue?
ASKER
Hey tried that...same error.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Hi rrjean17...yes done all that and still same error. I have no idea why this doesnt work. I am using the wizard to configure the mirror.
try the below one from your command prompt which should open up a blank window
telnet WIN-4DL3VZ7HITK 5022
If blank window is not opened, then you have some network connectivity issues.
Make sure that port 5022 is excluded in windows firewall and give it a try
telnet WIN-4DL3VZ7HITK 5022
If blank window is not opened, then you have some network connectivity issues.
Make sure that port 5022 is excluded in windows firewall and give it a try
ASKER
Hey yes i have done that and its a blank page...it does not reject the connection.
Do it the reverse way from the other server with the port on which it is listening..
ASKER
Hey guys thanks for your help but I figured out the problem...it was because I was using the admin account to create the mirror.
I needed to create an AD account with SQL rights and then using that account to run and manage the mirror did the trick.
Thanks anyways
I needed to create an AD account with SQL rights and then using that account to run and manage the mirror did the trick.
Thanks anyways
http://blog.sqlauthority.com/2007/04/22/sql-server-fix-error-1418-microsoft-sql-server-the-server-network-address-can-not-be-reached-or-does-not-exist-check-the-network-address-name-and-reissue-the-command/