How to share or transfer user ID and password between 2 SQL server?
From: Darren Fuller (darrenjfuller_at_hotmail.com)
Date: 05/28/03
- Next message: Galore: "Re: SP3 on MSDE"
- Previous message: Usman: "Re: powerfull user"
- In reply to: Michael: "How to share or transfer user ID and password between 2 SQL server?"
- Next in thread: Jobi: "Re: How to share or transfer user ID and password between 2 SQL server?"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Date: Wed, 28 May 2003 04:07:57 -0700
Michael,
Logins & encrypted passwords can be scripted. Please
check: http://support.microsoft.com/?kbid=246133
Darren Fuller
>-----Original Message-----
>Hi, all
>
>I am using a Win2000+SQL2000 Server, with a huge database
running on it.
>
>Now, I setup a new server with more hard disk space to
use, by using SQL
>Server Backup/Restore function, I can transfered the
database to the new
>server.
>
>Can anyone tell me how to transfer all the user_id and
password to the new
>server?
>
>All my existing user account and password are created in
SQL Server, not
>windows domain account. I know
>they are stored in Master database, but how can I
transfer them the new
>server?
>or
>Is there any way can share the user accounts and password?
>
>
>Many thanks
>
>
> Michael
>
>
>
>
>.
>
- Next message: Galore: "Re: SP3 on MSDE"
- Previous message: Usman: "Re: powerfull user"
- In reply to: Michael: "How to share or transfer user ID and password between 2 SQL server?"
- Next in thread: Jobi: "Re: How to share or transfer user ID and password between 2 SQL server?"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
|
