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 |
|
laddu
Constraint Violating Yak Guru
332 Posts |
 Posted - 2009-11-19 : 17:09:18
|
| I had setup logshipping for production DB from prod to DR server. Now we are testing ours users to connect to Website thru Dr server DB(stand by mode). throwing error like login can't have access to open database and can't read database.Please advice...I noticed that once did logshipping in secondary server permisssion are not there for login to that database |
|
|
MartinH
Starting Member
5 Posts |
Posted - 2009-11-20 : 05:30:46
|
| Are the logins on the DR Server exactly the same is Prod? run select name,sid,password from sys.syslogins on both servers to check.MartinHhttp://uk.linkedin.com/in/martinhandsley |
 |
|
|
laddu
Constraint Violating Yak Guru
332 Posts |
Posted - 2009-11-20 : 10:18:56
|
| all login names and pw are same. what is sid? |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
laddu
Constraint Violating Yak Guru
332 Posts |
Posted - 2009-11-20 : 14:02:38
|
| Still SID is different for 2 logins ...how to map SID?If SID is not matching, will application work when failover occurs |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
Secondary database- standby(readonly mode)