Monday, March 12, 2012

logins transfer

How do I transfer logins from one SQL server to another? Thanks.In SQL Server 2000 use the Transfer Logins Task. On the Transfer Logins
Properties just specify the source and destination servers and the logins to
transfer.
Ben Nevarez, MCDBA, OCP
Database Administrator
"00KobeBrian" wrote:
> How do I transfer logins from one SQL server to another? Thanks.
>
>|||Oops, I forgot to mention that the Transfer Logins Task is available on the
DTS packages so you will need to create a DTS package first.
Ben Nevarez, MCDBA, OCP
Database Administrator
"Ben Nevarez" wrote:
> In SQL Server 2000 use the Transfer Logins Task. On the Transfer Logins
> Properties just specify the source and destination servers and the logins to
> transfer.
> Ben Nevarez, MCDBA, OCP
> Database Administrator
>
> "00KobeBrian" wrote:
> > How do I transfer logins from one SQL server to another? Thanks.
> >
> >
> >|||Look at
http://support.microsoft.com/default.aspx?kbid=246133
Regards
Amish Shah|||Hi All,
Great information sharing.
KobeBrian, let me know if you still have concerns in this issue. Feel free
to post back.
Best regards,
Vincent Xu
Microsoft Online Partner Support
======================================================Get Secure! - www.microsoft.com/security
======================================================When responding to posts, please "Reply to Group" via your newsreader so
that others
may learn and benefit from this issue.
======================================================This posting is provided "AS IS" with no warranties,and confers no rights.
======================================================>>From: "amish" <shahamishm@.gmail.com>
>>Newsgroups: microsoft.public.sqlserver.server
>>Subject: Re: logins transfer
>>Date: 9 May 2006 22:31:23 -0700
>>Organization: http://groups.google.com
>>Lines: 6
>>Message-ID: <1147239083.882328.121810@.u72g2000cwu.googlegroups.com>
>>References: <u$D5aT#cGHA.3348@.TK2MSFTNGP03.phx.gbl>
>> <5AB1EFD4-413C-49BE-A101-16470D66CD73@.microsoft.com>
>> <1B440201-B2C5-4D07-B4AC-8DE3085AAC6D@.microsoft.com>
>>NNTP-Posting-Host: 203.27.235.5
>>Mime-Version: 1.0
>>Content-Type: text/plain; charset="iso-8859-1"
>>X-Trace: posting.google.com 1147239089 1034 127.0.0.1 (10 May 2006
05:31:29 GMT)
>>X-Complaints-To: groups-abuse@.google.com
>>NNTP-Posting-Date: Wed, 10 May 2006 05:31:29 +0000 (UTC)
>>In-Reply-To: <1B440201-B2C5-4D07-B4AC-8DE3085AAC6D@.microsoft.com>
>>User-Agent: G2/0.2
>>X-HTTP-UserAgent: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.0; .NET
CLR 2.0.50727),gzip(gfe),gzip(gfe)
>>X-HTTP-Via: 1.0 MLXLDCR01
>>Complaints-To: groups-abuse@.google.com
>>Injection-Info: u72g2000cwu.googlegroups.com; posting-host=203.27.235.5;
>> posting-account=EMkDJA0AAABVpxHyye2-j9m4ZUnK4SBu
>>Path:
TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP01.phx.gbl!TK2MSFTFEEDS01.phx.gbl!newsfeed.c
w.net!cw.net!news-FFM2.ecrc.de!news.glorb.com!postnews.google.com!u72g2000cw
u.googlegroups.com!not-for-mail
>>Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.server:430903
>>X-Tomcat-NG: microsoft.public.sqlserver.server
>>Look at
>>http://support.microsoft.com/default.aspx?kbid=246133
>>Regards
>>Amish Shah
>>

No comments:

Post a Comment