Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
nilupa
Starting Member
8 Posts |
 Posted - 2010-09-06 : 00:25:47
|
| I'm trying to setup database mirroring using windows server 2008 sp2 and ms sql server 2008 standard sp1 with windows vista business sp1 and ms sql server 2008 standard sp1 on a workgroup.I follow these steps.1)setup principal database to full recovery mode2)got full backup & Transactional log backup of principal database and restored it to mirror database with NORECOVERY option.3)then follow the steps of mirroring using sql server management studio.But i could not configure mirroring it gives me a error.-------------------------------------------------------The server network address "TCP://sqlserver:5023 cannot be reached or does not exist.check the network address name and that the ports for the local and remote endpoint are opreational.(Microsoft SQL Server, Error:1418)--------------------------------------------------------------------then i googled the error and i found this page [url]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/[/url]i done the all the suggestion except the suggestion 6. that is ----------------------------------------------------------------try the following command as one of the last options.GRANT CONNECT ON ENDPOINT::Mirroing TO ALL-----------------------------------------------------------------i cannot run this command give me a error saying you don't have permission to run this.i'm desperate do this mirroing thing.anyone can help me i will be greatly thank ful.nilupa. |
|
|
nilupa
Starting Member
8 Posts |
Posted - 2010-09-08 : 06:30:42
|
| anyone 4 help.. |
 |
|
|
sks198117
Starting Member
46 Posts |
Posted - 2010-09-13 : 09:02:11
|
| are you using the domain user to connect principal and mirror server? |
|
|
|
nilupa
Starting Member
8 Posts |
Posted - 2010-09-15 : 05:43:42
|
| no all in workgroup. |
|
|
|
sks198117
Starting Member
46 Posts |
Posted - 2010-09-15 : 06:49:11
|
| If its not production server.can you please change the service account logon user to user which you are using during mirroring setup for both the services SQL SERVER and SQL SERVER AGENT and restart the services using this account.Hope this should workThanks |
|
|
|
|
|
|
cannot setup mirror server...