[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 614
  • Last Modified:

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.ConnectionInfo)

------------------------------

The server network address "TCP://WIN-4DL3VZ7HITK.corp.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?
0
Network_Padawan
Asked:
Network_Padawan
  • 4
  • 4
1 Solution
 
Network_PadawanAuthor Commented:
Hey tried that...same error.
0
 
Raja Jegan RSQL Server DBA & ArchitectCommented:
0
Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

 
Network_PadawanAuthor Commented:
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.
0
 
Raja Jegan RSQL Server DBA & ArchitectCommented:
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
0
 
Network_PadawanAuthor Commented:
Hey yes i have done that and its a blank page...it does not reject the connection.
0
 
Raja Jegan RSQL Server DBA & ArchitectCommented:
Do it the reverse way from the other server with the port on which it is listening..
0
 
Network_PadawanAuthor Commented:
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
0

Featured Post

Take Control of Web Hosting For Your Clients

As a web developer or IT admin, successfully managing multiple client accounts can be challenging. In this webinar we will look at the tools provided by Media Temple and Plesk to make managing your clients’ hosting easier.

  • 4
  • 4
Tackle projects and never again get stuck behind a technical roadblock.
Join Now