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-18 : 04:33:03
|
| I have managed to get mirroring sorted out between two systems using Domain accounts. I am trying the same with local accounts. I understand that you need an SQL self-certificate. I have set this up but still cannot get a valid connection via the Configure security.All endpoints are good and a master encryption ley has been created on each box.Does anyone have any ideas on this one ?Thanks....markg |
|
|
DaleTurley
Yak Posting Veteran
76 Posts |
Posted - 2010-03-18 : 05:57:13
|
| What error do you get in event viewer?I've just had to raise a call with Microsoft about this issue becuase i couldn't get it working reliably... |
 |
|
|
thewebhosting
Starting Member
17 Posts |
Posted - 2010-03-21 : 00:41:00
|
| Hi,Once you have selected instances and the mode to use, a few other requirements must be met. You must have SQL Server 2005 Standard, Enterprise or Developer editions plus SQL Server 2005 Service Pack 1 to run the mirror. These are the specification on Database mirroring setup via SQL Server Management StudioAs with most things in SQL Server, you have the option to use GUI tools and an option to use T-SQL commands. To get started select the database and instances for the principal, mirror and the witness, if you are going to use one. Again these only need to be unique instances, so they can all be on the same physical server. For testing and development this makes sense, but for your production environment the whole idea of mirroring is to use physically different servers; if there is a problem with your primary server you can fail over to a secondary server. |
|
|
|
|
|
|
Database Mirroring SQL 2005