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?
Network_PadawanAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Network_PadawanAuthor Commented:
Hey tried that...same error.
0
Raja Jegan RSQL Server DBA & Architect, EE Solution GuideCommented:
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Cloud Class® Course: SQL Server Core 2016

This course will introduce you to SQL Server Core 2016, as well as teach you about SSMS, data tools, installation, server configuration, using Management Studio, and writing and executing queries.

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 & Architect, EE Solution GuideCommented:
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 & Architect, EE Solution GuideCommented:
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
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server 2008

From novice to tech pro — start learning today.