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 |
|
pelegk2
Aged Yak Warrior
723 Posts |
 Posted - 2011-06-14 : 09:31:47
|
| i want to configure mirror like this :Principal : TCP://[192.168.0.30]:5022Mirror : TCP://[192.168.0.31]:5022but i get an error : TCP://[192.168.0.30]:5022 CANNOT BE REACHEDmy Service is running under Administrator (should i change it to network service?)any idea?Thankspeleg |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2011-06-14 : 09:50:01
|
| Don't put brackets around the IP address. You should also only use the server names to set the partners. IP address may work but it's not recommended by Microsoft.Your SQL service account should also run under a domain account, and that account should never be a domain admin or have elevated privileges. |
 |
|
|
pelegk2
Aged Yak Warrior
723 Posts |
Posted - 2011-06-14 : 10:02:45
|
| but if i put the server name, it's on another ip that i want to use.the servers are not in a domian, and the service run under the server local administrator |
|
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2011-06-14 : 10:54:08
|
| Is this strictly for testing purposes? It may work under the network service account, but I've never tried it and I know MS doesn't recommend it. Can't vouch for it after that. |
|
|
|
pelegk2
Aged Yak Warrior
723 Posts |
Posted - 2011-06-15 : 02:27:03
|
| this is for production. |
|
|
|
|
|
|
mirror based on ip address