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.
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
--------------------------
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?
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?
Who is Participating?
Experts Exchange Solution brought to you by
Enjoy your complimentary solution view.
Get every solution instantly with Premium.
Start your 7-day free trial.
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.
Oops.. Attached the wrong link
http://blog.sqlauthority.com/2010/01/11/the-server-network-address-tcpsqlserver5023-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-microso/
try that and do let me know whether you are using TSQL or Wizard approach to configure mirroring..
http://blog.sqlauthority.com/2010/01/11/the-server-network-address-tcpsqlserver5023-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-microso/
try that and do let me know whether you are using TSQL or Wizard approach to configure mirroring..
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
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
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
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.
Experts Exchange Solution brought to you by
Enjoy your complimentary solution view.
Get every solution instantly with Premium.
Start your 7-day free trial.
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/