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.

 All Forums
 General SQL Server Forums
 Database Design and Application Architecture
 do i need same User id

Author  Topic 

jkshahs
Starting Member

2 Posts

Posted - 2010-03-24 : 05:04:32
I have production SQL server and DR Sql Server, want to restrict some users from running query on my production server, so have made same user id on DR , do i need to have the same user id on production too, can i go ahead and delete the same from production server, if some one can plz reply me back with appropriate solution

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2010-03-24 : 13:56:01
Are you using mirroring?

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page
   

- Advertisement -