Re: Windows security

From: Uri Dimant (urid_at_iscar.co.il)
Date: 07/17/05 

Date: Sun, 17 Jul 2005 09:52:21 +0300

Hi
There are two stored procedures provided by Microsoft to transfer
users/logins with their original SID.
Please do searching on the internet

If you login has an appropriate (a login should be created on remote
server)permissions perform a backup to another computer
BACKUP DATABASE DataBaseTO DISK =
    N'\\Server\backup\Database.BAK'

"pmcguire" <pmcguire@discussions.microsoft.com> wrote in message
news:165C4A5A-8D38-4850-8C7A-7805B98D8A46@microsoft.com...
> I have 2 SQL servers (SQL1 and SQL2) residing on two Windows servers (Win1
> and Win2). I want to back up a database (mydbase) from SQL1 and restore
it
> to SQL2. I am using Windows authentication, and I would LIKE to be able
to
> do this without rebuilding the User list every time.
>
> For example, I want mydbowner to have db_owner rights on mydbase on both
> SQL1 and SQL2; Win1/mydbowner and Win2/mydbowner logins exist already,
and
> Win1/mydbowner already has db_owner privileges to SQL1.mydbase. When I
> backup and restore, Win1/mydbowner exists as a user on SQL2.mydbase, but
of
> course the login doesn't exist on SQL2.
>
> I guess what I would like to be able to do is create the user
Win2/mydbowner
> (and grant it db_owner privileges) on SQL1.mydbase without creating the
login
> on SQL1. Can this be done?
> --
> Pat

Relevant Pages

  • RE: Login from Internet
    ... \par - You would like to know how to prevent a user not log on the site from Internet if he didn't input his domain credential. ... \par Microsoft Online Partner Support ... \par Subject: Login from Internet ... they get prompted for their credentials again. ...
    (microsoft.public.sharepoint.portalserver)
  • RE: Login restrictions in NIS environment
    ... and nbaker to login, but it seems to block out IMAP connections - not after ... > Richard Hobbs ... >>> This e-mail has been scanned for viruses by MCI's Internet ...
    (RedHat)
  • Re: Intranet/Internet Site Permissions
    ... require ntfs login from internet and no login from intranet. ...
    (microsoft.public.inetserver.iis)
  • Re: too many login attempts from Internet
    ... but do they require login from the internet or just from your lan? ... internet to get a listing of accounts on a machine then start an attack to ... and be sure to enable lockouts after just a couple failed login ... >> you have users that are trying to login to user accounts on your server ...
    (microsoft.public.win2000.security)
  • RE: Login restrictions in NIS environment
    ... IMAP authenticates perfectly now :-) ... All other users cannot login from anywhere except LOCAL. ... > Richard Hobbs ... >>> This e-mail has been scanned for viruses by MCI's Internet ...
    (RedHat)