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 |
|
Pooh99
Starting Member
14 Posts |
 Posted - 2010-03-11 : 06:07:19
|
| Managed to Set up the database ready for mirroring but have a problem with setting up the mirror itself via the Configure Security wizard in the Database Properties Wizard....The Server network addresses is where the problem lies.The error I get states that my computer is not accessible.The computer is called sps-lap-01.local and on domain spectrum.local.Any advice or ideas would be gratefully appreciated! |
|
|
Lumbago
Norsk Yak Master
3271 Posts |
Posted - 2010-03-11 : 06:18:50
|
| The mirror database will always me in a state of "restoring..." and it needs to be to be able to accept new transactions from the principal database.- LumbagoIf the facts don't fit the theory, change the facts. Albert Einstein |
 |
|
|
Lumbago
Norsk Yak Master
3271 Posts |
Posted - 2010-03-11 : 06:38:16
|
| Use IP-addresses for your local machine as well...that's always the better choice.- LumbagoIf the facts don't fit the theory, change the facts. Albert Einstein |
|
|
|
Lumbago
Norsk Yak Master
3271 Posts |
Posted - 2010-03-11 : 06:42:31
|
| Btw: what is the ".local" part of the computer name? When I configure my endpoints using the wizard it says under server network addresses:Principal: TCP://PCHEF02.no.mycompany:5022Mirror: TCP://PCHEF02.no.mycompany:5023(port 5023 is because I've set up mirroring between two instances on the same computer)- LumbagoIf the facts don't fit the theory, change the facts. Albert Einstein |
|
|
|
|
|
|
Database Mirroring