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 |
|
richieasir
Starting Member
13 Posts |
 Posted - 2010-03-14 : 05:04:49
|
| Hi All,Greetings from Richards.I have two named instance in my SQl server 2008, where i tried to mirror a database from the default instance to named instance on the same sql server , am getting the below error"You must connect to this server instance using a login or account with the necessary permissions to save the security configuration before continuing this wizard."is it possible to mirror a database from one instance to other instance on the same sqlserver?what resolution for the above error and?Please explain it in details.Am very new to SQL server Thank youRichards [/font=Arial][/size=2] |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2010-03-14 : 10:44:00
|
| yes it is but you have to use a different ports for principal, mirror and witness instances.___________________________________________________________________________Causing trouble since 1980Blog: http://weblogs.sqlteam.com/mladenpSpeed up SSMS development: www.ssmstoolspack.com <- version 1.7 out! |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
Database Mirroring