Re:Copy SQL Server Logins and Passwords

From: Rob (rhchin@hotmail.com)
Date: 11/27/02


From: "Rob" <rhchin@hotmail.com>
Date: Wed, 27 Nov 2002 06:22:03 -0800


Thanks but that only address for version 7.0. For 6.5
there is no option to have the logins & passwords copied
to another SQL 6.5 Server.

>-----Original Message-----
>
>You can to it using SQL Server DTS wizard. for more
>information visit following URL
>
>http://support.microsoft.com/default.aspx?scid=kb;EN-
>US;q246133
>
>--Vishal
>>-----Original Message-----
>>Hello:
>>
>>Is there a way to Transfer Logins and Passwords Between
>>SQL Servers version 6.5.
>>
>>Thanks.
>>.
>>
>.
>



Relevant Pages

  • Re: Sql Server 2005 Dev. Ed. on Windows Server 2003
    ... Check out this KB which is about transferring Logins: http://support.microsoft.com/kb/246133 ... Also, since this is running on a newly installed Windows Server 2003, is ... them from your older SQL Server instance to the newer one. ...
    (microsoft.public.sqlserver.setup)
  • RE: Fulltext failure on a 2 node cluster
    ... Server full-text search resource online: "SQL Cluster Resource 'Full Text' ...
    (microsoft.public.sqlserver.clustering)
  • Re: HELP PLEASE ~ ???
    ... You mentioned that it went ahead and added a SQL ... SQL Server 2000 database for all my data. ... find the connectionString in the newly recreated SQLExpress database. ... The connection string specifies a local Sql Server Express instance ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: object level permissions being lost when migrating
    ... Just want to confirm that you are talking about SQL Logins and not windows Logins correct? ... As far as I know the compatibility level should not be an issue one way or the other but exactly how are you looking at the permissions? ... I first transferred the logins from the 2000 server to the 2005 server via ...
    (microsoft.public.sqlserver.security)
  • Re: Multi-Channel Raid VS SAN Storage
    ... A 5~6 years old server is a very old server. ... As I mentioned, the server is one node in a cluster environment, and SQL is ... We actually are running RAID 1+0 and our aplication is definately more ... needs it's own SAN device, or at least a dedicated IO channel on the SAN. ...
    (microsoft.public.sqlserver.setup)