Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
orphaned users and sa login
0 views
Skip to first unread message
jb
Aug 25, 2003, 2:26:03 PM8/25/03
to
I'm try to move SQL and applications to a new server on
the same domain.. Only login that uses SQL is the SA login
from the application. Do I need to be concerned with SA
not working if the SID is different?
the same domain.. Only login that uses SQL is the SA login
from the application. Do I need to be concerned with SA
not working if the SID is different?
Gopal Ashok [MS]
Aug 26, 2003, 10:48:10 AM8/26/03
to
Normally we maintain the same sid for sa on all installations, so you
should not have a problem. In case you see any issues
use sp_change_users_login to check for orphaned users and to fix it
should not have a problem. In case you see any issues
use sp_change_users_login to check for orphaned users and to fix it
Thanks
Gopal
jb
Aug 27, 2003, 12:59:31 PM8/27/03
to
can you give me an example of running this with all the
syntax.. looks like there are different options. thanks.
syntax.. looks like there are different options. thanks.
>.
>
0 new messages