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 |
|
steel
Posting Yak Master
107 Posts |
 Posted - 2008-04-09 : 05:18:08
|
| is it necessary that the acounts on which the sqlserver are running on primary and secondary servers must have same pass words.thank you |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-04-09 : 09:37:10
|
| It will be good if you have that. |
 |
|
|
steel
Posting Yak Master
107 Posts |
Posted - 2008-04-09 : 23:57:47
|
| if they dont have same pass words and are on different domains then how to configure log shipping.thank you for your reply |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2008-04-10 : 00:02:32
|
| If they are on a different domain, then you need to setup a trust relationship between the two domains and provide access to the primary server's share for the account on the secondary server. The secondary server pulls the information.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/ |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-04-10 : 00:03:51
|
| I don't know about 2000 but in 2005 we create certificates. |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-04-10 : 22:34:40
|
| Still need trust domains even for sql2k5, if servers are in different domain and start servive with domain account. |
|
|
|
|
|
|
log shipping