Wednesday, March 7, 2012

How to cpy logins from one Server to another

Hi there! I don't remember if it was about 1 or 2 months ago that I posted
this same question. I wanted to know how to copy logins from one server to
another. Some one pointed to me an url to at microsoft knowledgebase, but I
lost it. Can some one or the person who helped me that time send me one
more time the url.
Thanks in advance,
Flix Melndez
PCI
Managua, NicaraguaHere are some links related to that subject:
http://www.support.microsoft.com/?id=314546 Moving DB's between Servers
http://www.support.microsoft.com/?id=224071 Moving SQL Server Databases
to a New Location with Detach/Attach
http://support.microsoft.com/?id=221465 Using WITH MOVE in a
Restore
http://www.support.microsoft.com/?id=246133 How To Transfer Logins and
Passwords Between SQL Servers
http://www.support.microsoft.com/?id=298897 Mapping Logins & SIDs after a
Restore
http://www.dbmaint.com/SyncSqlLogins.asp Utility to map logins to
users
http://www.support.microsoft.com/?id=168001 User Logon and/or Permission
Errors After Restoring Dump
http://www.support.microsoft.com/?id=240872 How to Resolve Permission
Issues When a Database Is Moved Between SQL Servers
http://www.sqlservercentral.com/scr...sp?scriptid=599
Restoring a .mdf
Andrew J. Kelly
SQL Server MVP
"Flix Melndez" <fmelende@.ibw.com.ni> wrote in message
news:%2383aC1izDHA.604@.tk2msftngp13.phx.gbl...
quote:

> Hi there! I don't remember if it was about 1 or 2 months ago that I posted
> this same question. I wanted to know how to copy logins from one server

to
quote:

> another. Some one pointed to me an url to at microsoft knowledgebase, but

I
quote:

> lost it. Can some one or the person who helped me that time send me one
> more time the url.
> Thanks in advance,
> --
> Flix Melndez
> PCI
> Managua, Nicaragua
>
|||Thanks a lot
"Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
news:#HEFjFjzDHA.548@.tk2msftngp13.phx.gbl...
quote:

> Here are some links related to that subject:
>
> http://www.support.microsoft.com/?id=314546 Moving DB's between

Servers
quote:

> http://www.support.microsoft.com/?id=224071 Moving SQL Server

Databases
quote:

> to a New Location with Detach/Attach
> http://support.microsoft.com/?id=221465 Using WITH MOVE in a
> Restore
> http://www.support.microsoft.com/?id=246133 How To Transfer Logins and
> Passwords Between SQL Servers
> http://www.support.microsoft.com/?id=298897 Mapping Logins & SIDs after

a
quote:

> Restore
> http://www.dbmaint.com/SyncSqlLogins.asp Utility to map logins to
> users
> http://www.support.microsoft.com/?id=168001 User Logon and/or

Permission
quote:

> Errors After Restoring Dump
> http://www.support.microsoft.com/?id=240872 How to Resolve Permission
> Issues When a Database Is Moved Between SQL Servers
> http://www.sqlservercentral.com/scr...sp?scriptid=599
> Restoring a .mdf
> --
> Andrew J. Kelly
> SQL Server MVP
>
> "Flix Melndez" <fmelende@.ibw.com.ni> wrote in message
> news:%2383aC1izDHA.604@.tk2msftngp13.phx.gbl...
posted[QUOTE]
> to
but[QUOTE]
> I
>

No comments:

Post a Comment