Hello,
I have to migrate SQL 200o from an NT4 to a 2003 machine. I would like to
keep al the settings/users/databases intact.
How could this be acomplished?
Kind regards,
Paul.
One or more of below should get you started:
Moving SQL Server Databases
http://www.support.microsoft.com/?id=224071
Moving Databases between Servers
http://www.support.microsoft.com/?id=314546
Using WITH MOVE in a Restore to a New Location with Detach/Attach
http://support.microsoft.com/?id=221465
How To Transfer Logins and Passwords Between SQL Servers
http://www.support.microsoft.com/?id=246133
Mapping Logins & SIDs after a Restore
http://www.support.microsoft.com/?id=298897
Utility to map users to the correct login
http://www.dbmaint.com/SyncSqlLogins.asp
How to Resolve Permission Issues When a Database Is Moved Between SQL Servers
http://www.support.microsoft.com/?id=240872
User Logon and/or Permission Errors After Restoring Dump
http://www.support.microsoft.com/?id=168001
Disaster Recovery Articles for SQL Server
http://www.support.microsoft.com/?id=307775
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Paul" <microsoftnews@.knipsel.nl> wrote in message news:%23CO5wfIoEHA.800@.TK2MSFTNGP14.phx.gbl...
> Hello,
> I have to migrate SQL 200o from an NT4 to a 2003 machine. I would like to
> keep al the settings/users/databases intact.
> How could this be acomplished?
> Kind regards,
>
> Paul.
>
>
|||Thanks Tibor!
This will cetainly help!
Regards,
Paul
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:OXnhJvIoEHA.3324@.TK2MSFTNGP10.phx.gbl...
> One or more of below should get you started:
>
> Moving SQL Server Databases
> http://www.support.microsoft.com/?id=224071
> Moving Databases between Servers
> http://www.support.microsoft.com/?id=314546
> Using WITH MOVE in a Restore to a New Location with Detach/Attach
> http://support.microsoft.com/?id=221465
> How To Transfer Logins and Passwords Between SQL Servers
> http://www.support.microsoft.com/?id=246133
> Mapping Logins & SIDs after a Restore
> http://www.support.microsoft.com/?id=298897
> Utility to map users to the correct login
> http://www.dbmaint.com/SyncSqlLogins.asp
> How to Resolve Permission Issues When a Database Is Moved Between SQL
> Servers
> http://www.support.microsoft.com/?id=240872
> User Logon and/or Permission Errors After Restoring Dump
> http://www.support.microsoft.com/?id=168001
> Disaster Recovery Articles for SQL Server
> http://www.support.microsoft.com/?id=307775
>
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Paul" <microsoftnews@.knipsel.nl> wrote in message
> news:%23CO5wfIoEHA.800@.TK2MSFTNGP14.phx.gbl...
>
Showing posts with label users. Show all posts
Showing posts with label users. Show all posts
Monday, March 26, 2012
Migrating an SQL server to another machine
Hello,
I have to migrate SQL 200o from an NT4 to a 2003 machine. I would like to
keep al the settings/users/databases intact.
How could this be acomplished?
Kind regards,
Paul.One or more of below should get you started:
Moving SQL Server Databases
http://www.support.microsoft.com/?id=224071
Moving Databases between Servers
http://www.support.microsoft.com/?id=314546
Using WITH MOVE in a Restore to a New Location with Detach/Attach
http://support.microsoft.com/?id=221465
How To Transfer Logins and Passwords Between SQL Servers
http://www.support.microsoft.com/?id=246133
Mapping Logins & SIDs after a Restore
http://www.support.microsoft.com/?id=298897
Utility to map users to the correct login
http://www.dbmaint.com/SyncSqlLogins.asp
How to Resolve Permission Issues When a Database Is Moved Between SQL Servers
http://www.support.microsoft.com/?id=240872
User Logon and/or Permission Errors After Restoring Dump
http://www.support.microsoft.com/?id=168001
Disaster Recovery Articles for SQL Server
http://www.support.microsoft.com/?id=307775
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Paul" <microsoftnews@.knipsel.nl> wrote in message news:%23CO5wfIoEHA.800@.TK2MSFTNGP14.phx.gbl...
> Hello,
> I have to migrate SQL 200o from an NT4 to a 2003 machine. I would like to
> keep al the settings/users/databases intact.
> How could this be acomplished?
> Kind regards,
>
> Paul.
>
>|||Thanks Tibor!
This will cetainly help!
Regards,
Paul
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:OXnhJvIoEHA.3324@.TK2MSFTNGP10.phx.gbl...
> One or more of below should get you started:
>
> Moving SQL Server Databases
> http://www.support.microsoft.com/?id=224071
> Moving Databases between Servers
> http://www.support.microsoft.com/?id=314546
> Using WITH MOVE in a Restore to a New Location with Detach/Attach
> http://support.microsoft.com/?id=221465
> How To Transfer Logins and Passwords Between SQL Servers
> http://www.support.microsoft.com/?id=246133
> Mapping Logins & SIDs after a Restore
> http://www.support.microsoft.com/?id=298897
> Utility to map users to the correct login
> http://www.dbmaint.com/SyncSqlLogins.asp
> How to Resolve Permission Issues When a Database Is Moved Between SQL
> Servers
> http://www.support.microsoft.com/?id=240872
> User Logon and/or Permission Errors After Restoring Dump
> http://www.support.microsoft.com/?id=168001
> Disaster Recovery Articles for SQL Server
> http://www.support.microsoft.com/?id=307775
>
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Paul" <microsoftnews@.knipsel.nl> wrote in message
> news:%23CO5wfIoEHA.800@.TK2MSFTNGP14.phx.gbl...
>> Hello,
>> I have to migrate SQL 200o from an NT4 to a 2003 machine. I would like to
>> keep al the settings/users/databases intact.
>> How could this be acomplished?
>> Kind regards,
>>
>> Paul.
>>
>>
>
I have to migrate SQL 200o from an NT4 to a 2003 machine. I would like to
keep al the settings/users/databases intact.
How could this be acomplished?
Kind regards,
Paul.One or more of below should get you started:
Moving SQL Server Databases
http://www.support.microsoft.com/?id=224071
Moving Databases between Servers
http://www.support.microsoft.com/?id=314546
Using WITH MOVE in a Restore to a New Location with Detach/Attach
http://support.microsoft.com/?id=221465
How To Transfer Logins and Passwords Between SQL Servers
http://www.support.microsoft.com/?id=246133
Mapping Logins & SIDs after a Restore
http://www.support.microsoft.com/?id=298897
Utility to map users to the correct login
http://www.dbmaint.com/SyncSqlLogins.asp
How to Resolve Permission Issues When a Database Is Moved Between SQL Servers
http://www.support.microsoft.com/?id=240872
User Logon and/or Permission Errors After Restoring Dump
http://www.support.microsoft.com/?id=168001
Disaster Recovery Articles for SQL Server
http://www.support.microsoft.com/?id=307775
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Paul" <microsoftnews@.knipsel.nl> wrote in message news:%23CO5wfIoEHA.800@.TK2MSFTNGP14.phx.gbl...
> Hello,
> I have to migrate SQL 200o from an NT4 to a 2003 machine. I would like to
> keep al the settings/users/databases intact.
> How could this be acomplished?
> Kind regards,
>
> Paul.
>
>|||Thanks Tibor!
This will cetainly help!
Regards,
Paul
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:OXnhJvIoEHA.3324@.TK2MSFTNGP10.phx.gbl...
> One or more of below should get you started:
>
> Moving SQL Server Databases
> http://www.support.microsoft.com/?id=224071
> Moving Databases between Servers
> http://www.support.microsoft.com/?id=314546
> Using WITH MOVE in a Restore to a New Location with Detach/Attach
> http://support.microsoft.com/?id=221465
> How To Transfer Logins and Passwords Between SQL Servers
> http://www.support.microsoft.com/?id=246133
> Mapping Logins & SIDs after a Restore
> http://www.support.microsoft.com/?id=298897
> Utility to map users to the correct login
> http://www.dbmaint.com/SyncSqlLogins.asp
> How to Resolve Permission Issues When a Database Is Moved Between SQL
> Servers
> http://www.support.microsoft.com/?id=240872
> User Logon and/or Permission Errors After Restoring Dump
> http://www.support.microsoft.com/?id=168001
> Disaster Recovery Articles for SQL Server
> http://www.support.microsoft.com/?id=307775
>
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Paul" <microsoftnews@.knipsel.nl> wrote in message
> news:%23CO5wfIoEHA.800@.TK2MSFTNGP14.phx.gbl...
>> Hello,
>> I have to migrate SQL 200o from an NT4 to a 2003 machine. I would like to
>> keep al the settings/users/databases intact.
>> How could this be acomplished?
>> Kind regards,
>>
>> Paul.
>>
>>
>
Migrated NT users to AD - Permissions (Cross Posted)
(This message is cross posted to SQL and AD groups).
I'm in the process of migrating NT users to Active Directory. For file share
access this is fine because I migrate with SID history so everything just
works.
However I've done some test migrations for users with SQL permissions and
they can't access any databases. (As the permissions says their old name).
Short of me having to go through every single server for ever user is there
a way to update or a way for this to work?
Thanks
Rob.
Thanks.
Do you know what scripting i would be looking at or what third party tools?
I've spent a good while searching on this topic and am unable to find
anything so would appreciated any advice.
Thanks.
Rob.
"Jorge de Almeida Pinto [MVP - DS]"
<SubstituteThisWithMyFullNameSeparatedByDots@.gmail .com> wrote in message
news:%23ZQC3GxaIHA.1212@.TK2MSFTNGP05.phx.gbl...
> ADMT does not update SQL DBs. You might do it yourself (scripting) or buy
> third party software
> --
> Cheers,
> (HOPEFULLY THIS INFORMATION HELPS YOU!)
> # Jorge de Almeida Pinto # MVP Windows Server - Directory Services
> BLOG (WEB-BASED)--> http://blogs.dirteam.com/blogs/jorge/default.aspx
> BLOG (RSS-FEEDS)--> http://blogs.dirteam.com/blogs/jorge/rss.aspx
> ----
> * How to ask a question --> http://support.microsoft.com/?id=555375
> ----
> * This posting is provided "AS IS" with no warranties and confers no
> rights!
> * Always test before implementing!
> ----
> #################################################
> #################################################
> ----
> "Robert Nafty" <rob_nafty_spam@.hotmail.co.uk> wrote in message
> news:ODqqU8waIHA.6024@.TK2MSFTNGP06.phx.gbl...
>
|||Hi
If you need to change the domain then look at
http://support.microsoft.com/kb/298897
This may also be used:
http://support.microsoft.com/kb/246133/
You may have orphaned users in which case see
http://support.microsoft.com/kb/274188/
Also check out http://support.microsoft.com/kb/240872/
John
"Robert Nafty" wrote:
> Thanks.
> Do you know what scripting i would be looking at or what third party tools?
> I've spent a good while searching on this topic and am unable to find
> anything so would appreciated any advice.
>
> Thanks.
> Rob.
>
> "Jorge de Almeida Pinto [MVP - DS]"
> <SubstituteThisWithMyFullNameSeparatedByDots@.gmail .com> wrote in message
> news:%23ZQC3GxaIHA.1212@.TK2MSFTNGP05.phx.gbl...
>
>
I'm in the process of migrating NT users to Active Directory. For file share
access this is fine because I migrate with SID history so everything just
works.
However I've done some test migrations for users with SQL permissions and
they can't access any databases. (As the permissions says their old name).
Short of me having to go through every single server for ever user is there
a way to update or a way for this to work?
Thanks
Rob.
Thanks.
Do you know what scripting i would be looking at or what third party tools?
I've spent a good while searching on this topic and am unable to find
anything so would appreciated any advice.
Thanks.
Rob.
"Jorge de Almeida Pinto [MVP - DS]"
<SubstituteThisWithMyFullNameSeparatedByDots@.gmail .com> wrote in message
news:%23ZQC3GxaIHA.1212@.TK2MSFTNGP05.phx.gbl...
> ADMT does not update SQL DBs. You might do it yourself (scripting) or buy
> third party software
> --
> Cheers,
> (HOPEFULLY THIS INFORMATION HELPS YOU!)
> # Jorge de Almeida Pinto # MVP Windows Server - Directory Services
> BLOG (WEB-BASED)--> http://blogs.dirteam.com/blogs/jorge/default.aspx
> BLOG (RSS-FEEDS)--> http://blogs.dirteam.com/blogs/jorge/rss.aspx
> ----
> * How to ask a question --> http://support.microsoft.com/?id=555375
> ----
> * This posting is provided "AS IS" with no warranties and confers no
> rights!
> * Always test before implementing!
> ----
> #################################################
> #################################################
> ----
> "Robert Nafty" <rob_nafty_spam@.hotmail.co.uk> wrote in message
> news:ODqqU8waIHA.6024@.TK2MSFTNGP06.phx.gbl...
>
|||Hi
If you need to change the domain then look at
http://support.microsoft.com/kb/298897
This may also be used:
http://support.microsoft.com/kb/246133/
You may have orphaned users in which case see
http://support.microsoft.com/kb/274188/
Also check out http://support.microsoft.com/kb/240872/
John
"Robert Nafty" wrote:
> Thanks.
> Do you know what scripting i would be looking at or what third party tools?
> I've spent a good while searching on this topic and am unable to find
> anything so would appreciated any advice.
>
> Thanks.
> Rob.
>
> "Jorge de Almeida Pinto [MVP - DS]"
> <SubstituteThisWithMyFullNameSeparatedByDots@.gmail .com> wrote in message
> news:%23ZQC3GxaIHA.1212@.TK2MSFTNGP05.phx.gbl...
>
>
Migrated NT users to AD - Permissions (Cross Posted)
(This message is cross posted to SQL and AD groups).
I'm in the process of migrating NT users to Active Directory. For file share
access this is fine because I migrate with SID history so everything just
works.
However I've done some test migrations for users with SQL permissions and
they can't access any databases. (As the permissions says their old name).
Short of me having to go through every single server for ever user is there
a way to update or a way for this to work'
Thanks
Rob.ADMT does not update SQL DBs. You might do it yourself (scripting) or buy
third party software
--
Cheers,
(HOPEFULLY THIS INFORMATION HELPS YOU!)
# Jorge de Almeida Pinto # MVP Windows Server - Directory Services
BLOG (WEB-BASED)--> http://blogs.dirteam.com/blogs/jorge/default.aspx
BLOG (RSS-FEEDS)--> http://blogs.dirteam.com/blogs/jorge/rss.aspx
----
* How to ask a question --> http://support.microsoft.com/?id=555375
----
* This posting is provided "AS IS" with no warranties and confers no rights!
* Always test before implementing!
----
#################################################
#################################################
----
"Robert Nafty" <rob_nafty_spam@.hotmail.co.uk> wrote in message
news:ODqqU8waIHA.6024@.TK2MSFTNGP06.phx.gbl...
> (This message is cross posted to SQL and AD groups).
> I'm in the process of migrating NT users to Active Directory. For file
> share access this is fine because I migrate with SID history so everything
> just works.
> However I've done some test migrations for users with SQL permissions and
> they can't access any databases. (As the permissions says their old name).
> Short of me having to go through every single server for ever user is
> there a way to update or a way for this to work'
> Thanks
> Rob.
>|||Thanks.
Do you know what scripting i would be looking at or what third party tools?
I've spent a good while searching on this topic and am unable to find
anything so would appreciated any advice.
Thanks.
Rob.
"Jorge de Almeida Pinto [MVP - DS]"
<SubstituteThisWithMyFullNameSeparatedByDots@.gmail.com> wrote in message
news:%23ZQC3GxaIHA.1212@.TK2MSFTNGP05.phx.gbl...
> ADMT does not update SQL DBs. You might do it yourself (scripting) or buy
> third party software
> --
> Cheers,
> (HOPEFULLY THIS INFORMATION HELPS YOU!)
> # Jorge de Almeida Pinto # MVP Windows Server - Directory Services
> BLOG (WEB-BASED)--> http://blogs.dirteam.com/blogs/jorge/default.aspx
> BLOG (RSS-FEEDS)--> http://blogs.dirteam.com/blogs/jorge/rss.aspx
> ----
> * How to ask a question --> http://support.microsoft.com/?id=555375
> ----
> * This posting is provided "AS IS" with no warranties and confers no
> rights!
> * Always test before implementing!
> ----
> #################################################
> #################################################
> ----
> "Robert Nafty" <rob_nafty_spam@.hotmail.co.uk> wrote in message
> news:ODqqU8waIHA.6024@.TK2MSFTNGP06.phx.gbl...
>> (This message is cross posted to SQL and AD groups).
>> I'm in the process of migrating NT users to Active Directory. For file
>> share access this is fine because I migrate with SID history so
>> everything just works.
>> However I've done some test migrations for users with SQL permissions and
>> they can't access any databases. (As the permissions says their old
>> name).
>> Short of me having to go through every single server for ever user is
>> there a way to update or a way for this to work'
>> Thanks
>> Rob.
>>
>|||maybe SQL scripts, vbs scripts
third party tooling, try Quest
--
Cheers,
(HOPEFULLY THIS INFORMATION HELPS YOU!)
# Jorge de Almeida Pinto # MVP Windows Server - Directory Services
BLOG (WEB-BASED)--> http://blogs.dirteam.com/blogs/jorge/default.aspx
BLOG (RSS-FEEDS)--> http://blogs.dirteam.com/blogs/jorge/rss.aspx
----
* How to ask a question --> http://support.microsoft.com/?id=555375
----
* This posting is provided "AS IS" with no warranties and confers no rights!
* Always test before implementing!
----
#################################################
#################################################
----
"Robert Nafty" <rob_nafty_spam@.hotmail.co.uk> wrote in message
news:u6y7cDyaIHA.356@.TK2MSFTNGP03.phx.gbl...
> Thanks.
> Do you know what scripting i would be looking at or what third party
> tools?
> I've spent a good while searching on this topic and am unable to find
> anything so would appreciated any advice.
>
> Thanks.
> Rob.
>
> "Jorge de Almeida Pinto [MVP - DS]"
> <SubstituteThisWithMyFullNameSeparatedByDots@.gmail.com> wrote in message
> news:%23ZQC3GxaIHA.1212@.TK2MSFTNGP05.phx.gbl...
>> ADMT does not update SQL DBs. You might do it yourself (scripting) or buy
>> third party software
>> --
>> Cheers,
>> (HOPEFULLY THIS INFORMATION HELPS YOU!)
>> # Jorge de Almeida Pinto # MVP Windows Server - Directory Services
>> BLOG (WEB-BASED)--> http://blogs.dirteam.com/blogs/jorge/default.aspx
>> BLOG (RSS-FEEDS)--> http://blogs.dirteam.com/blogs/jorge/rss.aspx
>> ----
>> * How to ask a question --> http://support.microsoft.com/?id=555375
>> ----
>> * This posting is provided "AS IS" with no warranties and confers no
>> rights!
>> * Always test before implementing!
>> ----
>> #################################################
>> #################################################
>> ----
>> "Robert Nafty" <rob_nafty_spam@.hotmail.co.uk> wrote in message
>> news:ODqqU8waIHA.6024@.TK2MSFTNGP06.phx.gbl...
>> (This message is cross posted to SQL and AD groups).
>> I'm in the process of migrating NT users to Active Directory. For file
>> share access this is fine because I migrate with SID history so
>> everything just works.
>> However I've done some test migrations for users with SQL permissions
>> and they can't access any databases. (As the permissions says their old
>> name).
>> Short of me having to go through every single server for ever user is
>> there a way to update or a way for this to work'
>> Thanks
>> Rob.
>>
>|||Hi
If you need to change the domain then look at
http://support.microsoft.com/kb/298897
This may also be used:
http://support.microsoft.com/kb/246133/
You may have orphaned users in which case see
http://support.microsoft.com/kb/274188/
Also check out http://support.microsoft.com/kb/240872/
John
"Robert Nafty" wrote:
> Thanks.
> Do you know what scripting i would be looking at or what third party tools?
> I've spent a good while searching on this topic and am unable to find
> anything so would appreciated any advice.
>
> Thanks.
> Rob.
>
> "Jorge de Almeida Pinto [MVP - DS]"
> <SubstituteThisWithMyFullNameSeparatedByDots@.gmail.com> wrote in message
> news:%23ZQC3GxaIHA.1212@.TK2MSFTNGP05.phx.gbl...
> > ADMT does not update SQL DBs. You might do it yourself (scripting) or buy
> > third party software
> >
> > --
> >
> > Cheers,
> > (HOPEFULLY THIS INFORMATION HELPS YOU!)
> >
> > # Jorge de Almeida Pinto # MVP Windows Server - Directory Services
> >
> > BLOG (WEB-BASED)--> http://blogs.dirteam.com/blogs/jorge/default.aspx
> > BLOG (RSS-FEEDS)--> http://blogs.dirteam.com/blogs/jorge/rss.aspx
> > ----
> > * How to ask a question --> http://support.microsoft.com/?id=555375
> > ----
> > * This posting is provided "AS IS" with no warranties and confers no
> > rights!
> > * Always test before implementing!
> > ----
> > #################################################
> > #################################################
> > ----
> > "Robert Nafty" <rob_nafty_spam@.hotmail.co.uk> wrote in message
> > news:ODqqU8waIHA.6024@.TK2MSFTNGP06.phx.gbl...
> >> (This message is cross posted to SQL and AD groups).
> >>
> >> I'm in the process of migrating NT users to Active Directory. For file
> >> share access this is fine because I migrate with SID history so
> >> everything just works.
> >>
> >> However I've done some test migrations for users with SQL permissions and
> >> they can't access any databases. (As the permissions says their old
> >> name).
> >>
> >> Short of me having to go through every single server for ever user is
> >> there a way to update or a way for this to work'
> >>
> >> Thanks
> >> Rob.
> >>
> >>
> >
>
>
I'm in the process of migrating NT users to Active Directory. For file share
access this is fine because I migrate with SID history so everything just
works.
However I've done some test migrations for users with SQL permissions and
they can't access any databases. (As the permissions says their old name).
Short of me having to go through every single server for ever user is there
a way to update or a way for this to work'
Thanks
Rob.ADMT does not update SQL DBs. You might do it yourself (scripting) or buy
third party software
--
Cheers,
(HOPEFULLY THIS INFORMATION HELPS YOU!)
# Jorge de Almeida Pinto # MVP Windows Server - Directory Services
BLOG (WEB-BASED)--> http://blogs.dirteam.com/blogs/jorge/default.aspx
BLOG (RSS-FEEDS)--> http://blogs.dirteam.com/blogs/jorge/rss.aspx
----
* How to ask a question --> http://support.microsoft.com/?id=555375
----
* This posting is provided "AS IS" with no warranties and confers no rights!
* Always test before implementing!
----
#################################################
#################################################
----
"Robert Nafty" <rob_nafty_spam@.hotmail.co.uk> wrote in message
news:ODqqU8waIHA.6024@.TK2MSFTNGP06.phx.gbl...
> (This message is cross posted to SQL and AD groups).
> I'm in the process of migrating NT users to Active Directory. For file
> share access this is fine because I migrate with SID history so everything
> just works.
> However I've done some test migrations for users with SQL permissions and
> they can't access any databases. (As the permissions says their old name).
> Short of me having to go through every single server for ever user is
> there a way to update or a way for this to work'
> Thanks
> Rob.
>|||Thanks.
Do you know what scripting i would be looking at or what third party tools?
I've spent a good while searching on this topic and am unable to find
anything so would appreciated any advice.
Thanks.
Rob.
"Jorge de Almeida Pinto [MVP - DS]"
<SubstituteThisWithMyFullNameSeparatedByDots@.gmail.com> wrote in message
news:%23ZQC3GxaIHA.1212@.TK2MSFTNGP05.phx.gbl...
> ADMT does not update SQL DBs. You might do it yourself (scripting) or buy
> third party software
> --
> Cheers,
> (HOPEFULLY THIS INFORMATION HELPS YOU!)
> # Jorge de Almeida Pinto # MVP Windows Server - Directory Services
> BLOG (WEB-BASED)--> http://blogs.dirteam.com/blogs/jorge/default.aspx
> BLOG (RSS-FEEDS)--> http://blogs.dirteam.com/blogs/jorge/rss.aspx
> ----
> * How to ask a question --> http://support.microsoft.com/?id=555375
> ----
> * This posting is provided "AS IS" with no warranties and confers no
> rights!
> * Always test before implementing!
> ----
> #################################################
> #################################################
> ----
> "Robert Nafty" <rob_nafty_spam@.hotmail.co.uk> wrote in message
> news:ODqqU8waIHA.6024@.TK2MSFTNGP06.phx.gbl...
>> (This message is cross posted to SQL and AD groups).
>> I'm in the process of migrating NT users to Active Directory. For file
>> share access this is fine because I migrate with SID history so
>> everything just works.
>> However I've done some test migrations for users with SQL permissions and
>> they can't access any databases. (As the permissions says their old
>> name).
>> Short of me having to go through every single server for ever user is
>> there a way to update or a way for this to work'
>> Thanks
>> Rob.
>>
>|||maybe SQL scripts, vbs scripts
third party tooling, try Quest
--
Cheers,
(HOPEFULLY THIS INFORMATION HELPS YOU!)
# Jorge de Almeida Pinto # MVP Windows Server - Directory Services
BLOG (WEB-BASED)--> http://blogs.dirteam.com/blogs/jorge/default.aspx
BLOG (RSS-FEEDS)--> http://blogs.dirteam.com/blogs/jorge/rss.aspx
----
* How to ask a question --> http://support.microsoft.com/?id=555375
----
* This posting is provided "AS IS" with no warranties and confers no rights!
* Always test before implementing!
----
#################################################
#################################################
----
"Robert Nafty" <rob_nafty_spam@.hotmail.co.uk> wrote in message
news:u6y7cDyaIHA.356@.TK2MSFTNGP03.phx.gbl...
> Thanks.
> Do you know what scripting i would be looking at or what third party
> tools?
> I've spent a good while searching on this topic and am unable to find
> anything so would appreciated any advice.
>
> Thanks.
> Rob.
>
> "Jorge de Almeida Pinto [MVP - DS]"
> <SubstituteThisWithMyFullNameSeparatedByDots@.gmail.com> wrote in message
> news:%23ZQC3GxaIHA.1212@.TK2MSFTNGP05.phx.gbl...
>> ADMT does not update SQL DBs. You might do it yourself (scripting) or buy
>> third party software
>> --
>> Cheers,
>> (HOPEFULLY THIS INFORMATION HELPS YOU!)
>> # Jorge de Almeida Pinto # MVP Windows Server - Directory Services
>> BLOG (WEB-BASED)--> http://blogs.dirteam.com/blogs/jorge/default.aspx
>> BLOG (RSS-FEEDS)--> http://blogs.dirteam.com/blogs/jorge/rss.aspx
>> ----
>> * How to ask a question --> http://support.microsoft.com/?id=555375
>> ----
>> * This posting is provided "AS IS" with no warranties and confers no
>> rights!
>> * Always test before implementing!
>> ----
>> #################################################
>> #################################################
>> ----
>> "Robert Nafty" <rob_nafty_spam@.hotmail.co.uk> wrote in message
>> news:ODqqU8waIHA.6024@.TK2MSFTNGP06.phx.gbl...
>> (This message is cross posted to SQL and AD groups).
>> I'm in the process of migrating NT users to Active Directory. For file
>> share access this is fine because I migrate with SID history so
>> everything just works.
>> However I've done some test migrations for users with SQL permissions
>> and they can't access any databases. (As the permissions says their old
>> name).
>> Short of me having to go through every single server for ever user is
>> there a way to update or a way for this to work'
>> Thanks
>> Rob.
>>
>|||Hi
If you need to change the domain then look at
http://support.microsoft.com/kb/298897
This may also be used:
http://support.microsoft.com/kb/246133/
You may have orphaned users in which case see
http://support.microsoft.com/kb/274188/
Also check out http://support.microsoft.com/kb/240872/
John
"Robert Nafty" wrote:
> Thanks.
> Do you know what scripting i would be looking at or what third party tools?
> I've spent a good while searching on this topic and am unable to find
> anything so would appreciated any advice.
>
> Thanks.
> Rob.
>
> "Jorge de Almeida Pinto [MVP - DS]"
> <SubstituteThisWithMyFullNameSeparatedByDots@.gmail.com> wrote in message
> news:%23ZQC3GxaIHA.1212@.TK2MSFTNGP05.phx.gbl...
> > ADMT does not update SQL DBs. You might do it yourself (scripting) or buy
> > third party software
> >
> > --
> >
> > Cheers,
> > (HOPEFULLY THIS INFORMATION HELPS YOU!)
> >
> > # Jorge de Almeida Pinto # MVP Windows Server - Directory Services
> >
> > BLOG (WEB-BASED)--> http://blogs.dirteam.com/blogs/jorge/default.aspx
> > BLOG (RSS-FEEDS)--> http://blogs.dirteam.com/blogs/jorge/rss.aspx
> > ----
> > * How to ask a question --> http://support.microsoft.com/?id=555375
> > ----
> > * This posting is provided "AS IS" with no warranties and confers no
> > rights!
> > * Always test before implementing!
> > ----
> > #################################################
> > #################################################
> > ----
> > "Robert Nafty" <rob_nafty_spam@.hotmail.co.uk> wrote in message
> > news:ODqqU8waIHA.6024@.TK2MSFTNGP06.phx.gbl...
> >> (This message is cross posted to SQL and AD groups).
> >>
> >> I'm in the process of migrating NT users to Active Directory. For file
> >> share access this is fine because I migrate with SID history so
> >> everything just works.
> >>
> >> However I've done some test migrations for users with SQL permissions and
> >> they can't access any databases. (As the permissions says their old
> >> name).
> >>
> >> Short of me having to go through every single server for ever user is
> >> there a way to update or a way for this to work'
> >>
> >> Thanks
> >> Rob.
> >>
> >>
> >
>
>
Friday, March 23, 2012
migrate users
How can I script out existing SQL users from a user database on Production s
erver to the same user databse migrated to Test server ? (Both srv are on w2
k, sql2000)
When I migrate the user database to Test server, I accidentally deleted all
the SQL users for that database on the Test server.
I hve looked at these KB, but not sure if the "logins transfer" will removed
the existing logins or any impact on the Production server,
http://support.microsoft.com/default.aspx?kbid=298897
http://support.microsoft.com/default.aspx?kbid=246133
http://support.microsoft.com/default.aspx?kbid=240872
pls helpHi,
You can script the users and associated roles for that user using the SQL
Server ENterprise manager "Generate SQL script"
1. Open Enterprise manager and connect to the SQL server where your actual
database resides.
2. Expand the datbases and select the database.
3. Right click above the database and choose All tasks and select "Generate
SQL Scripts"
4. Go to Options tab in the new window displayed
5. Check the option "Script database users and database roles"
6. Go back to "General Tab"
7. CLick Preview.. This will display you the database users and roles
assigned
8. copy the script and paste in to a notepad
9. Login to TEST SQL servers Query analyzer using 'SA'
10. Go to the database you have dropped the users
11. copy the notepad contents and paste it in Query analyzer
12. Execute the script... Ensure that you are in correct database.
This will create all the users back with correct previlages.
FYI, I have never tested this steps before.
Thanks
Hari
MCDBA
"pk" <pk@.discussions.microsoft.com> wrote in message
news:AB82B609-55E7-4D10-9344-4ACC87721FA6@.microsoft.com...
> How can I script out existing SQL users from a user database on Production
server to the same user databse migrated to Test server ? (Both srv are on
w2k, sql2000)
> When I migrate the user database to Test server, I accidentally deleted
all the SQL users for that database on the Test server.
> I hve looked at these KB, but not sure if the "logins transfer" will
removed the existing logins or any impact on the Production server,
> http://support.microsoft.com/default.aspx?kbid=298897
> http://support.microsoft.com/default.aspx?kbid=246133
> http://support.microsoft.com/default.aspx?kbid=240872
>
> pls help
erver to the same user databse migrated to Test server ? (Both srv are on w2
k, sql2000)
When I migrate the user database to Test server, I accidentally deleted all
the SQL users for that database on the Test server.
I hve looked at these KB, but not sure if the "logins transfer" will removed
the existing logins or any impact on the Production server,
http://support.microsoft.com/default.aspx?kbid=298897
http://support.microsoft.com/default.aspx?kbid=246133
http://support.microsoft.com/default.aspx?kbid=240872
pls helpHi,
You can script the users and associated roles for that user using the SQL
Server ENterprise manager "Generate SQL script"
1. Open Enterprise manager and connect to the SQL server where your actual
database resides.
2. Expand the datbases and select the database.
3. Right click above the database and choose All tasks and select "Generate
SQL Scripts"
4. Go to Options tab in the new window displayed
5. Check the option "Script database users and database roles"
6. Go back to "General Tab"
7. CLick Preview.. This will display you the database users and roles
assigned
8. copy the script and paste in to a notepad
9. Login to TEST SQL servers Query analyzer using 'SA'
10. Go to the database you have dropped the users
11. copy the notepad contents and paste it in Query analyzer
12. Execute the script... Ensure that you are in correct database.
This will create all the users back with correct previlages.
FYI, I have never tested this steps before.
Thanks
Hari
MCDBA
"pk" <pk@.discussions.microsoft.com> wrote in message
news:AB82B609-55E7-4D10-9344-4ACC87721FA6@.microsoft.com...
> How can I script out existing SQL users from a user database on Production
server to the same user databse migrated to Test server ? (Both srv are on
w2k, sql2000)
> When I migrate the user database to Test server, I accidentally deleted
all the SQL users for that database on the Test server.
> I hve looked at these KB, but not sure if the "logins transfer" will
removed the existing logins or any impact on the Production server,
> http://support.microsoft.com/default.aspx?kbid=298897
> http://support.microsoft.com/default.aspx?kbid=246133
> http://support.microsoft.com/default.aspx?kbid=240872
>
> pls help
Migrate users
Does anyone knows if it's possible to migrate users to another server? I use windows 2000 server and SQL server 2000, Integrated windows sequrity.
I want to use the second server as "Standby" Server. On the first server there are already created many windows-accounts. Do I have to create all theat users again on the other server? and all roles and permissions?You can script the users and permissions by selecting the SCRIPT DATABASE USERS AND DATABASE ROLES and the SCRIPT OBJECT LEVEL PERMISSIONS from the Options Tab in the Scripting dialog boxes from within Enterprise manager.
After the scripts are created, you can edit them to remove everything except the Permission statements.
Now you can execute the script anytime you need to re-create the rolls and permissions.|||can these scripts be run on another machine??|||Any SQL script can be run on any SQL Server. The real question is probably should it be run. There should be no harm, if the script does not drop tables/procedures/views, or delete data. You should review the script to make sure you understand what it is doing.
I want to use the second server as "Standby" Server. On the first server there are already created many windows-accounts. Do I have to create all theat users again on the other server? and all roles and permissions?You can script the users and permissions by selecting the SCRIPT DATABASE USERS AND DATABASE ROLES and the SCRIPT OBJECT LEVEL PERMISSIONS from the Options Tab in the Scripting dialog boxes from within Enterprise manager.
After the scripts are created, you can edit them to remove everything except the Permission statements.
Now you can execute the script anytime you need to re-create the rolls and permissions.|||can these scripts be run on another machine??|||Any SQL script can be run on any SQL Server. The real question is probably should it be run. There should be no harm, if the script does not drop tables/procedures/views, or delete data. You should review the script to make sure you understand what it is doing.
migrate users
How can I script out existing SQL users from a user database on Production server to the same user databse migrated to Test server ? (Both srv are on w2k, sql2000)
When I migrate the user database to Test server, I accidentally deleted all the SQL users for that database on the Test server.
I hve looked at these KB, but not sure if the "logins transfer" will removed the existing logins or any impact on the Production server,
http://support.microsoft.com/default.aspx?kbid=298897
http://support.microsoft.com/default.aspx?kbid=246133
http://support.microsoft.com/default.aspx?kbid=240872
pls help
Hi,
You can script the users and associated roles for that user using the SQL
Server ENterprise manager "Generate SQL script"
1. Open Enterprise manager and connect to the SQL server where your actual
database resides.
2. Expand the datbases and select the database.
3. Right click above the database and choose All tasks and select "Generate
SQL Scripts"
4. Go to Options tab in the new window displayed
5. Check the option "Script database users and database roles"
6. Go back to "General Tab"
7. CLick Preview.. This will display you the database users and roles
assigned
8. copy the script and paste in to a notepad
9. Login to TEST SQL servers Query analyzer using 'SA'
10. Go to the database you have dropped the users
11. copy the notepad contents and paste it in Query analyzer
12. Execute the script... Ensure that you are in correct database.
This will create all the users back with correct previlages.
FYI, I have never tested this steps before.
Thanks
Hari
MCDBA
"pk" <pk@.discussions.microsoft.com> wrote in message
news:AB82B609-55E7-4D10-9344-4ACC87721FA6@.microsoft.com...
> How can I script out existing SQL users from a user database on Production
server to the same user databse migrated to Test server ? (Both srv are on
w2k, sql2000)
> When I migrate the user database to Test server, I accidentally deleted
all the SQL users for that database on the Test server.
> I hve looked at these KB, but not sure if the "logins transfer" will
removed the existing logins or any impact on the Production server,
> http://support.microsoft.com/default.aspx?kbid=298897
> http://support.microsoft.com/default.aspx?kbid=246133
> http://support.microsoft.com/default.aspx?kbid=240872
>
> pls help
sql
When I migrate the user database to Test server, I accidentally deleted all the SQL users for that database on the Test server.
I hve looked at these KB, but not sure if the "logins transfer" will removed the existing logins or any impact on the Production server,
http://support.microsoft.com/default.aspx?kbid=298897
http://support.microsoft.com/default.aspx?kbid=246133
http://support.microsoft.com/default.aspx?kbid=240872
pls help
Hi,
You can script the users and associated roles for that user using the SQL
Server ENterprise manager "Generate SQL script"
1. Open Enterprise manager and connect to the SQL server where your actual
database resides.
2. Expand the datbases and select the database.
3. Right click above the database and choose All tasks and select "Generate
SQL Scripts"
4. Go to Options tab in the new window displayed
5. Check the option "Script database users and database roles"
6. Go back to "General Tab"
7. CLick Preview.. This will display you the database users and roles
assigned
8. copy the script and paste in to a notepad
9. Login to TEST SQL servers Query analyzer using 'SA'
10. Go to the database you have dropped the users
11. copy the notepad contents and paste it in Query analyzer
12. Execute the script... Ensure that you are in correct database.
This will create all the users back with correct previlages.
FYI, I have never tested this steps before.
Thanks
Hari
MCDBA
"pk" <pk@.discussions.microsoft.com> wrote in message
news:AB82B609-55E7-4D10-9344-4ACC87721FA6@.microsoft.com...
> How can I script out existing SQL users from a user database on Production
server to the same user databse migrated to Test server ? (Both srv are on
w2k, sql2000)
> When I migrate the user database to Test server, I accidentally deleted
all the SQL users for that database on the Test server.
> I hve looked at these KB, but not sure if the "logins transfer" will
removed the existing logins or any impact on the Production server,
> http://support.microsoft.com/default.aspx?kbid=298897
> http://support.microsoft.com/default.aspx?kbid=246133
> http://support.microsoft.com/default.aspx?kbid=240872
>
> pls help
sql
migrate users
How can I script out existing SQL users from a user database on Production server to the same user databse migrated to Test server ? (Both srv are on w2k, sql2000)
When I migrate the user database to Test server, I accidentally deleted all the SQL users for that database on the Test server.
I hve looked at these KB, but not sure if the "logins transfer" will removed the existing logins or any impact on the Production server,
http://support.microsoft.com/default.aspx?kbid=298897
http://support.microsoft.com/default.aspx?kbid=246133
http://support.microsoft.com/default.aspx?kbid=240872
pls helpHi,
You can script the users and associated roles for that user using the SQL
Server ENterprise manager "Generate SQL script"
1. Open Enterprise manager and connect to the SQL server where your actual
database resides.
2. Expand the datbases and select the database.
3. Right click above the database and choose All tasks and select "Generate
SQL Scripts"
4. Go to Options tab in the new window displayed
5. Check the option "Script database users and database roles"
6. Go back to "General Tab"
7. CLick Preview.. This will display you the database users and roles
assigned
8. copy the script and paste in to a notepad
9. Login to TEST SQL servers Query analyzer using 'SA'
10. Go to the database you have dropped the users
11. copy the notepad contents and paste it in Query analyzer
12. Execute the script... Ensure that you are in correct database.
This will create all the users back with correct previlages.
FYI, I have never tested this steps before.
--
Thanks
Hari
MCDBA
"pk" <pk@.discussions.microsoft.com> wrote in message
news:AB82B609-55E7-4D10-9344-4ACC87721FA6@.microsoft.com...
> How can I script out existing SQL users from a user database on Production
server to the same user databse migrated to Test server ? (Both srv are on
w2k, sql2000)
> When I migrate the user database to Test server, I accidentally deleted
all the SQL users for that database on the Test server.
> I hve looked at these KB, but not sure if the "logins transfer" will
removed the existing logins or any impact on the Production server,
> http://support.microsoft.com/default.aspx?kbid=298897
> http://support.microsoft.com/default.aspx?kbid=246133
> http://support.microsoft.com/default.aspx?kbid=240872
>
> pls help
When I migrate the user database to Test server, I accidentally deleted all the SQL users for that database on the Test server.
I hve looked at these KB, but not sure if the "logins transfer" will removed the existing logins or any impact on the Production server,
http://support.microsoft.com/default.aspx?kbid=298897
http://support.microsoft.com/default.aspx?kbid=246133
http://support.microsoft.com/default.aspx?kbid=240872
pls helpHi,
You can script the users and associated roles for that user using the SQL
Server ENterprise manager "Generate SQL script"
1. Open Enterprise manager and connect to the SQL server where your actual
database resides.
2. Expand the datbases and select the database.
3. Right click above the database and choose All tasks and select "Generate
SQL Scripts"
4. Go to Options tab in the new window displayed
5. Check the option "Script database users and database roles"
6. Go back to "General Tab"
7. CLick Preview.. This will display you the database users and roles
assigned
8. copy the script and paste in to a notepad
9. Login to TEST SQL servers Query analyzer using 'SA'
10. Go to the database you have dropped the users
11. copy the notepad contents and paste it in Query analyzer
12. Execute the script... Ensure that you are in correct database.
This will create all the users back with correct previlages.
FYI, I have never tested this steps before.
--
Thanks
Hari
MCDBA
"pk" <pk@.discussions.microsoft.com> wrote in message
news:AB82B609-55E7-4D10-9344-4ACC87721FA6@.microsoft.com...
> How can I script out existing SQL users from a user database on Production
server to the same user databse migrated to Test server ? (Both srv are on
w2k, sql2000)
> When I migrate the user database to Test server, I accidentally deleted
all the SQL users for that database on the Test server.
> I hve looked at these KB, but not sure if the "logins transfer" will
removed the existing logins or any impact on the Production server,
> http://support.microsoft.com/default.aspx?kbid=298897
> http://support.microsoft.com/default.aspx?kbid=246133
> http://support.microsoft.com/default.aspx?kbid=240872
>
> pls help
Migrate SQL Server 2000 to SQL Server 2005: login
Hi!
I'm trying to migrate (side-by-side) databases from SQL Server 2000 to SQL
Server 2005 and have had some problems with the logins and users, so I
wonder which is the "correct" way to make it right =)Ooops, I hit send accidently and sent this message before I was done with
it. =)
Here's the continuation:
So far I have used sp_help_revlogin and after that sp_change_users_login,
but the password for a login was wrong after this. Is there something else I
should do?
Thanks
//Malin
> Hi!
> I'm trying to migrate (side-by-side) databases from SQL Server 2000 to SQL
> Server 2005 and have had some problems with the logins and users, so I
> wonder which is the "correct" way to make it right =)
>|||Check out:
http://support.microsoft.com/defaul...kb;en-us;246133
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Toronto, ON Canada
"Malin Davidsson" <malin.davidsson(at)aus.teleca.se> wrote in message
news:ejLryIm1GHA.4264@.TK2MSFTNGP05.phx.gbl...
Hi!
I'm trying to migrate (side-by-side) databases from SQL Server 2000 to SQL
Server 2005 and have had some problems with the logins and users, so I
wonder which is the "correct" way to make it right =)|||The best way to do this is to transfer the logins with sp_help_revlogin to a
clean server - i.e. one with no logins. Do this just before you want to cut
over or advise your users that their password won't be current on the new
box if they change their passwords on the old box after you've transferred
them. You won't need sp_change_users_login in that case.
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Toronto, ON Canada
"Malin Davidsson" <malin.davidsson(at)aus.teleca.se> wrote in message
news:%23Xf$aNm1GHA.4908@.TK2MSFTNGP02.phx.gbl...
Ooops, I hit send accidently and sent this message before I was done with
it. =)
Here's the continuation:
So far I have used sp_help_revlogin and after that sp_change_users_login,
but the password for a login was wrong after this. Is there something else I
should do?
Thanks
//Malin
> Hi!
> I'm trying to migrate (side-by-side) databases from SQL Server 2000 to SQL
> Server 2005 and have had some problems with the logins and users, so I
> wonder which is the "correct" way to make it right =)
>
I'm trying to migrate (side-by-side) databases from SQL Server 2000 to SQL
Server 2005 and have had some problems with the logins and users, so I
wonder which is the "correct" way to make it right =)Ooops, I hit send accidently and sent this message before I was done with
it. =)
Here's the continuation:
So far I have used sp_help_revlogin and after that sp_change_users_login,
but the password for a login was wrong after this. Is there something else I
should do?
Thanks
//Malin
> Hi!
> I'm trying to migrate (side-by-side) databases from SQL Server 2000 to SQL
> Server 2005 and have had some problems with the logins and users, so I
> wonder which is the "correct" way to make it right =)
>|||Check out:
http://support.microsoft.com/defaul...kb;en-us;246133
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Toronto, ON Canada
"Malin Davidsson" <malin.davidsson(at)aus.teleca.se> wrote in message
news:ejLryIm1GHA.4264@.TK2MSFTNGP05.phx.gbl...
Hi!
I'm trying to migrate (side-by-side) databases from SQL Server 2000 to SQL
Server 2005 and have had some problems with the logins and users, so I
wonder which is the "correct" way to make it right =)|||The best way to do this is to transfer the logins with sp_help_revlogin to a
clean server - i.e. one with no logins. Do this just before you want to cut
over or advise your users that their password won't be current on the new
box if they change their passwords on the old box after you've transferred
them. You won't need sp_change_users_login in that case.
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Toronto, ON Canada
"Malin Davidsson" <malin.davidsson(at)aus.teleca.se> wrote in message
news:%23Xf$aNm1GHA.4908@.TK2MSFTNGP02.phx.gbl...
Ooops, I hit send accidently and sent this message before I was done with
it. =)
Here's the continuation:
So far I have used sp_help_revlogin and after that sp_change_users_login,
but the password for a login was wrong after this. Is there something else I
should do?
Thanks
//Malin
> Hi!
> I'm trying to migrate (side-by-side) databases from SQL Server 2000 to SQL
> Server 2005 and have had some problems with the logins and users, so I
> wonder which is the "correct" way to make it right =)
>
Migrate SQL Server 2000 to SQL Server 2005: login
Hi!
I'm trying to migrate (side-by-side) databases from SQL Server 2000 to SQL
Server 2005 and have had some problems with the logins and users, so I
wonder which is the "correct" way to make it right =)Ooops, I hit send accidently and sent this message before I was done with
it. =)
Here's the continuation:
So far I have used sp_help_revlogin and after that sp_change_users_login,
but the password for a login was wrong after this. Is there something else I
should do?
Thanks
//Malin
> Hi!
> I'm trying to migrate (side-by-side) databases from SQL Server 2000 to SQL
> Server 2005 and have had some problems with the logins and users, so I
> wonder which is the "correct" way to make it right =)
>|||Check out:
http://support.microsoft.com/default.aspx?scid=kb;en-us;246133
--
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Toronto, ON Canada
"Malin Davidsson" <malin.davidsson(at)aus.teleca.se> wrote in message
news:ejLryIm1GHA.4264@.TK2MSFTNGP05.phx.gbl...
Hi!
I'm trying to migrate (side-by-side) databases from SQL Server 2000 to SQL
Server 2005 and have had some problems with the logins and users, so I
wonder which is the "correct" way to make it right =)|||The best way to do this is to transfer the logins with sp_help_revlogin to a
clean server - i.e. one with no logins. Do this just before you want to cut
over or advise your users that their password won't be current on the new
box if they change their passwords on the old box after you've transferred
them. You won't need sp_change_users_login in that case.
--
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Toronto, ON Canada
"Malin Davidsson" <malin.davidsson(at)aus.teleca.se> wrote in message
news:%23Xf$aNm1GHA.4908@.TK2MSFTNGP02.phx.gbl...
Ooops, I hit send accidently and sent this message before I was done with
it. =)
Here's the continuation:
So far I have used sp_help_revlogin and after that sp_change_users_login,
but the password for a login was wrong after this. Is there something else I
should do?
Thanks
//Malin
> Hi!
> I'm trying to migrate (side-by-side) databases from SQL Server 2000 to SQL
> Server 2005 and have had some problems with the logins and users, so I
> wonder which is the "correct" way to make it right =)
>sql
I'm trying to migrate (side-by-side) databases from SQL Server 2000 to SQL
Server 2005 and have had some problems with the logins and users, so I
wonder which is the "correct" way to make it right =)Ooops, I hit send accidently and sent this message before I was done with
it. =)
Here's the continuation:
So far I have used sp_help_revlogin and after that sp_change_users_login,
but the password for a login was wrong after this. Is there something else I
should do?
Thanks
//Malin
> Hi!
> I'm trying to migrate (side-by-side) databases from SQL Server 2000 to SQL
> Server 2005 and have had some problems with the logins and users, so I
> wonder which is the "correct" way to make it right =)
>|||Check out:
http://support.microsoft.com/default.aspx?scid=kb;en-us;246133
--
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Toronto, ON Canada
"Malin Davidsson" <malin.davidsson(at)aus.teleca.se> wrote in message
news:ejLryIm1GHA.4264@.TK2MSFTNGP05.phx.gbl...
Hi!
I'm trying to migrate (side-by-side) databases from SQL Server 2000 to SQL
Server 2005 and have had some problems with the logins and users, so I
wonder which is the "correct" way to make it right =)|||The best way to do this is to transfer the logins with sp_help_revlogin to a
clean server - i.e. one with no logins. Do this just before you want to cut
over or advise your users that their password won't be current on the new
box if they change their passwords on the old box after you've transferred
them. You won't need sp_change_users_login in that case.
--
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Toronto, ON Canada
"Malin Davidsson" <malin.davidsson(at)aus.teleca.se> wrote in message
news:%23Xf$aNm1GHA.4908@.TK2MSFTNGP02.phx.gbl...
Ooops, I hit send accidently and sent this message before I was done with
it. =)
Here's the continuation:
So far I have used sp_help_revlogin and after that sp_change_users_login,
but the password for a login was wrong after this. Is there something else I
should do?
Thanks
//Malin
> Hi!
> I'm trying to migrate (side-by-side) databases from SQL Server 2000 to SQL
> Server 2005 and have had some problems with the logins and users, so I
> wonder which is the "correct" way to make it right =)
>sql
Wednesday, March 21, 2012
migrate SQL 2000 system users
I have installed a new SQL 2005 server and successfully moved a db from one to the other. The users from that db were also imported, but the system security was not. Users cannot access the SQL system to even attempt to login to the db. What am I missing to import/transfer/migrate the system logins from SQL2000 to SQL2005?
Thanks
David
Moving to the setup and upgrade forum.
Donald
|||Take a look at http://support.microsoft.com/kb/918992/
Thanks,
Peter
Migrate Roles
Hi,
I need to migrate all databases from one server to another
existing database server, at this time i know how to
migrate all users logins avoiding orphaned users but i
dont know how to migrate all existing roles and how to
assign logins to existing Server Roles on the destination
with the minimum effort.
Best regards
Hi,
As soon as you transfer the syslogins table the server wide fixed roles also
will be transferred.
Have a look into the below link , This script will provide a easy method to
quickly generate a script that will move all logins along with same id and
password from one server to other.
http://www.databasejournal.com/featu...le.php/2228611
Thanks
Hari
MCDBA
"CC&JM" <anonymous@.discussions.microsoft.com> wrote in message
news:22d9501c45dd8$18b37630$a401280a@.phx.gbl...
> Hi,
> I need to migrate all databases from one server to another
> existing database server, at this time i know how to
> migrate all users logins avoiding orphaned users but i
> dont know how to migrate all existing roles and how to
> assign logins to existing Server Roles on the destination
> with the minimum effort.
> Best regards
|||Hi,
As soon as you transfer the syslogins table the server wide fixed roles also
will be transferred.
Have a look into the below link , This script will provide a easy method to
quickly generate a script that will move all logins along with same id and
password from one server to other.
http://www.databasejournal.com/featu...le.php/2228611
Thanks
Hari
MCDBA
"CC&JM" <anonymous@.discussions.microsoft.com> wrote in message
news:22d9501c45dd8$18b37630$a401280a@.phx.gbl...
> Hi,
> I need to migrate all databases from one server to another
> existing database server, at this time i know how to
> migrate all users logins avoiding orphaned users but i
> dont know how to migrate all existing roles and how to
> assign logins to existing Server Roles on the destination
> with the minimum effort.
> Best regards
|||Hi Hari,
I tried and the server roles were migrated to the new
server but the roles appear with no members. The users
that belong to any existing server roles do not belong to
the destination server roles too.
I think that i must use the sp_addrolemember to assign the
users migrated to the corresponding database roles
Best regards
>--Original Message--
>Hi,
>As soon as you transfer the syslogins table the server
wide fixed roles also
>will be transferred.
>Have a look into the below link , This script will
provide a easy method to
>quickly generate a script that will move all logins along
with same id and
>password from one server to other.
>
>http://www.databasejournal.com/featu...l/article.php/
2228611
>--
>Thanks
>Hari
>MCDBA
>"CC&JM" <anonymous@.discussions.microsoft.com> wrote in
message[vbcol=seagreen]
>news:22d9501c45dd8$18b37630$a401280a@.phx.gbl...
another[vbcol=seagreen]
destination
>
>.
>
|||Hi Hari,
I tried and the server roles were migrated to the new
server but the roles appear with no members. The users
that belong to any existing server roles do not belong to
the destination server roles too.
I think that i must use the sp_addrolemember to assign the
users migrated to the corresponding database roles
Best regards
>--Original Message--
>Hi,
>As soon as you transfer the syslogins table the server
wide fixed roles also
>will be transferred.
>Have a look into the below link , This script will
provide a easy method to
>quickly generate a script that will move all logins along
with same id and
>password from one server to other.
>
>http://www.databasejournal.com/featu...l/article.php/
2228611
>--
>Thanks
>Hari
>MCDBA
>"CC&JM" <anonymous@.discussions.microsoft.com> wrote in
message[vbcol=seagreen]
>news:22d9501c45dd8$18b37630$a401280a@.phx.gbl...
another[vbcol=seagreen]
destination
>
>.
>
|||HI,
After migration, Can you execute the below command:-
select * from syslogins
and see the below column values:-
sysadmin int 1, if login is a member of the sysadmin server role.
securityadmin int 1, if login is a member of the securityadmin server
role.
serveradmin int 1, if login is a member of the serveradmin fixed
server role.
setupadmin int 1, if login is a member of the setupadmin fixed server
role.
processadmin int 1, if login is a member of the processadmin fixed
server role.
diskadmin int 1, if login is a member of the diskadmin fixed server
role.
dbcreator int 1, if login is a member of the dbcreator fixed server
role.
If you have the value 1 for the column then the role is transfered from
source server to destination.
Thanks
Hari
MCDBA
<anonymous@.discussions.microsoft.com> wrote in message
news:2269701c45de4$91a25c80$a601280a@.phx.gbl...[vbcol=seagreen]
> Hi Hari,
> I tried and the server roles were migrated to the new
> server but the roles appear with no members. The users
> that belong to any existing server roles do not belong to
> the destination server roles too.
> I think that i must use the sp_addrolemember to assign the
> users migrated to the corresponding database roles
> Best regards
> wide fixed roles also
> provide a easy method to
> with same id and
> 2228611
> message
> another
> destination
|||HI,
After migration, Can you execute the below command:-
select * from syslogins
and see the below column values:-
sysadmin int 1, if login is a member of the sysadmin server role.
securityadmin int 1, if login is a member of the securityadmin server
role.
serveradmin int 1, if login is a member of the serveradmin fixed
server role.
setupadmin int 1, if login is a member of the setupadmin fixed server
role.
processadmin int 1, if login is a member of the processadmin fixed
server role.
diskadmin int 1, if login is a member of the diskadmin fixed server
role.
dbcreator int 1, if login is a member of the dbcreator fixed server
role.
If you have the value 1 for the column then the role is transfered from
source server to destination.
Thanks
Hari
MCDBA
<anonymous@.discussions.microsoft.com> wrote in message
news:2269701c45de4$91a25c80$a601280a@.phx.gbl...[vbcol=seagreen]
> Hi Hari,
> I tried and the server roles were migrated to the new
> server but the roles appear with no members. The users
> that belong to any existing server roles do not belong to
> the destination server roles too.
> I think that i must use the sp_addrolemember to assign the
> users migrated to the corresponding database roles
> Best regards
> wide fixed roles also
> provide a easy method to
> with same id and
> 2228611
> message
> another
> destination
I need to migrate all databases from one server to another
existing database server, at this time i know how to
migrate all users logins avoiding orphaned users but i
dont know how to migrate all existing roles and how to
assign logins to existing Server Roles on the destination
with the minimum effort.
Best regards
Hi,
As soon as you transfer the syslogins table the server wide fixed roles also
will be transferred.
Have a look into the below link , This script will provide a easy method to
quickly generate a script that will move all logins along with same id and
password from one server to other.
http://www.databasejournal.com/featu...le.php/2228611
Thanks
Hari
MCDBA
"CC&JM" <anonymous@.discussions.microsoft.com> wrote in message
news:22d9501c45dd8$18b37630$a401280a@.phx.gbl...
> Hi,
> I need to migrate all databases from one server to another
> existing database server, at this time i know how to
> migrate all users logins avoiding orphaned users but i
> dont know how to migrate all existing roles and how to
> assign logins to existing Server Roles on the destination
> with the minimum effort.
> Best regards
|||Hi,
As soon as you transfer the syslogins table the server wide fixed roles also
will be transferred.
Have a look into the below link , This script will provide a easy method to
quickly generate a script that will move all logins along with same id and
password from one server to other.
http://www.databasejournal.com/featu...le.php/2228611
Thanks
Hari
MCDBA
"CC&JM" <anonymous@.discussions.microsoft.com> wrote in message
news:22d9501c45dd8$18b37630$a401280a@.phx.gbl...
> Hi,
> I need to migrate all databases from one server to another
> existing database server, at this time i know how to
> migrate all users logins avoiding orphaned users but i
> dont know how to migrate all existing roles and how to
> assign logins to existing Server Roles on the destination
> with the minimum effort.
> Best regards
|||Hi Hari,
I tried and the server roles were migrated to the new
server but the roles appear with no members. The users
that belong to any existing server roles do not belong to
the destination server roles too.
I think that i must use the sp_addrolemember to assign the
users migrated to the corresponding database roles
Best regards
>--Original Message--
>Hi,
>As soon as you transfer the syslogins table the server
wide fixed roles also
>will be transferred.
>Have a look into the below link , This script will
provide a easy method to
>quickly generate a script that will move all logins along
with same id and
>password from one server to other.
>
>http://www.databasejournal.com/featu...l/article.php/
2228611
>--
>Thanks
>Hari
>MCDBA
>"CC&JM" <anonymous@.discussions.microsoft.com> wrote in
message[vbcol=seagreen]
>news:22d9501c45dd8$18b37630$a401280a@.phx.gbl...
another[vbcol=seagreen]
destination
>
>.
>
|||Hi Hari,
I tried and the server roles were migrated to the new
server but the roles appear with no members. The users
that belong to any existing server roles do not belong to
the destination server roles too.
I think that i must use the sp_addrolemember to assign the
users migrated to the corresponding database roles
Best regards
>--Original Message--
>Hi,
>As soon as you transfer the syslogins table the server
wide fixed roles also
>will be transferred.
>Have a look into the below link , This script will
provide a easy method to
>quickly generate a script that will move all logins along
with same id and
>password from one server to other.
>
>http://www.databasejournal.com/featu...l/article.php/
2228611
>--
>Thanks
>Hari
>MCDBA
>"CC&JM" <anonymous@.discussions.microsoft.com> wrote in
message[vbcol=seagreen]
>news:22d9501c45dd8$18b37630$a401280a@.phx.gbl...
another[vbcol=seagreen]
destination
>
>.
>
|||HI,
After migration, Can you execute the below command:-
select * from syslogins
and see the below column values:-
sysadmin int 1, if login is a member of the sysadmin server role.
securityadmin int 1, if login is a member of the securityadmin server
role.
serveradmin int 1, if login is a member of the serveradmin fixed
server role.
setupadmin int 1, if login is a member of the setupadmin fixed server
role.
processadmin int 1, if login is a member of the processadmin fixed
server role.
diskadmin int 1, if login is a member of the diskadmin fixed server
role.
dbcreator int 1, if login is a member of the dbcreator fixed server
role.
If you have the value 1 for the column then the role is transfered from
source server to destination.
Thanks
Hari
MCDBA
<anonymous@.discussions.microsoft.com> wrote in message
news:2269701c45de4$91a25c80$a601280a@.phx.gbl...[vbcol=seagreen]
> Hi Hari,
> I tried and the server roles were migrated to the new
> server but the roles appear with no members. The users
> that belong to any existing server roles do not belong to
> the destination server roles too.
> I think that i must use the sp_addrolemember to assign the
> users migrated to the corresponding database roles
> Best regards
> wide fixed roles also
> provide a easy method to
> with same id and
> 2228611
> message
> another
> destination
|||HI,
After migration, Can you execute the below command:-
select * from syslogins
and see the below column values:-
sysadmin int 1, if login is a member of the sysadmin server role.
securityadmin int 1, if login is a member of the securityadmin server
role.
serveradmin int 1, if login is a member of the serveradmin fixed
server role.
setupadmin int 1, if login is a member of the setupadmin fixed server
role.
processadmin int 1, if login is a member of the processadmin fixed
server role.
diskadmin int 1, if login is a member of the diskadmin fixed server
role.
dbcreator int 1, if login is a member of the dbcreator fixed server
role.
If you have the value 1 for the column then the role is transfered from
source server to destination.
Thanks
Hari
MCDBA
<anonymous@.discussions.microsoft.com> wrote in message
news:2269701c45de4$91a25c80$a601280a@.phx.gbl...[vbcol=seagreen]
> Hi Hari,
> I tried and the server roles were migrated to the new
> server but the roles appear with no members. The users
> that belong to any existing server roles do not belong to
> the destination server roles too.
> I think that i must use the sp_addrolemember to assign the
> users migrated to the corresponding database roles
> Best regards
> wide fixed roles also
> provide a easy method to
> with same id and
> 2228611
> message
> another
> destination
Migrate Roles
Hi,
I need to migrate all databases from one server to another
existing database server, at this time i know how to
migrate all users logins avoiding orphaned users but i
dont know how to migrate all existing roles and how to
assign logins to existing Server Roles on the destination
with the minimum effort.
Best regardsHi,
As soon as you transfer the syslogins table the server wide fixed roles also
will be transferred.
Have a look into the below link , This script will provide a easy method to
quickly generate a script that will move all logins along with same id and
password from one server to other.
http://www.databasejournal.com/features/mssql/article.php/2228611
--
Thanks
Hari
MCDBA
"CC&JM" <anonymous@.discussions.microsoft.com> wrote in message
news:22d9501c45dd8$18b37630$a401280a@.phx.gbl...
> Hi,
> I need to migrate all databases from one server to another
> existing database server, at this time i know how to
> migrate all users logins avoiding orphaned users but i
> dont know how to migrate all existing roles and how to
> assign logins to existing Server Roles on the destination
> with the minimum effort.
> Best regards|||Hi Hari,
I tried and the server roles were migrated to the new
server but the roles appear with no members. The users
that belong to any existing server roles do not belong to
the destination server roles too.
I think that i must use the sp_addrolemember to assign the
users migrated to the corresponding database roles
Best regards
>--Original Message--
>Hi,
>As soon as you transfer the syslogins table the server
wide fixed roles also
>will be transferred.
>Have a look into the below link , This script will
provide a easy method to
>quickly generate a script that will move all logins along
with same id and
>password from one server to other.
>
>http://www.databasejournal.com/features/mssql/article.php/
2228611
>--
>Thanks
>Hari
>MCDBA
>"CC&JM" <anonymous@.discussions.microsoft.com> wrote in
message
>news:22d9501c45dd8$18b37630$a401280a@.phx.gbl...
>> Hi,
>> I need to migrate all databases from one server to
another
>> existing database server, at this time i know how to
>> migrate all users logins avoiding orphaned users but i
>> dont know how to migrate all existing roles and how to
>> assign logins to existing Server Roles on the
destination
>> with the minimum effort.
>> Best regards
>
>.
>|||HI,
After migration, Can you execute the below command:-
select * from syslogins
and see the below column values:-
sysadmin int 1, if login is a member of the sysadmin server role.
securityadmin int 1, if login is a member of the securityadmin server
role.
serveradmin int 1, if login is a member of the serveradmin fixed
server role.
setupadmin int 1, if login is a member of the setupadmin fixed server
role.
processadmin int 1, if login is a member of the processadmin fixed
server role.
diskadmin int 1, if login is a member of the diskadmin fixed server
role.
dbcreator int 1, if login is a member of the dbcreator fixed server
role.
If you have the value 1 for the column then the role is transfered from
source server to destination.
Thanks
Hari
MCDBA
<anonymous@.discussions.microsoft.com> wrote in message
news:2269701c45de4$91a25c80$a601280a@.phx.gbl...
> Hi Hari,
> I tried and the server roles were migrated to the new
> server but the roles appear with no members. The users
> that belong to any existing server roles do not belong to
> the destination server roles too.
> I think that i must use the sp_addrolemember to assign the
> users migrated to the corresponding database roles
> Best regards
> >--Original Message--
> >Hi,
> >
> >As soon as you transfer the syslogins table the server
> wide fixed roles also
> >will be transferred.
> >
> >Have a look into the below link , This script will
> provide a easy method to
> >quickly generate a script that will move all logins along
> with same id and
> >password from one server to other.
> >
> >
> >http://www.databasejournal.com/features/mssql/article.php/
> 2228611
> >
> >--
> >Thanks
> >Hari
> >MCDBA
> >
> >"CC&JM" <anonymous@.discussions.microsoft.com> wrote in
> message
> >news:22d9501c45dd8$18b37630$a401280a@.phx.gbl...
> >> Hi,
> >>
> >> I need to migrate all databases from one server to
> another
> >> existing database server, at this time i know how to
> >> migrate all users logins avoiding orphaned users but i
> >> dont know how to migrate all existing roles and how to
> >> assign logins to existing Server Roles on the
> destination
> >> with the minimum effort.
> >>
> >> Best regards
> >
> >
> >.
> >
I need to migrate all databases from one server to another
existing database server, at this time i know how to
migrate all users logins avoiding orphaned users but i
dont know how to migrate all existing roles and how to
assign logins to existing Server Roles on the destination
with the minimum effort.
Best regardsHi,
As soon as you transfer the syslogins table the server wide fixed roles also
will be transferred.
Have a look into the below link , This script will provide a easy method to
quickly generate a script that will move all logins along with same id and
password from one server to other.
http://www.databasejournal.com/features/mssql/article.php/2228611
--
Thanks
Hari
MCDBA
"CC&JM" <anonymous@.discussions.microsoft.com> wrote in message
news:22d9501c45dd8$18b37630$a401280a@.phx.gbl...
> Hi,
> I need to migrate all databases from one server to another
> existing database server, at this time i know how to
> migrate all users logins avoiding orphaned users but i
> dont know how to migrate all existing roles and how to
> assign logins to existing Server Roles on the destination
> with the minimum effort.
> Best regards|||Hi Hari,
I tried and the server roles were migrated to the new
server but the roles appear with no members. The users
that belong to any existing server roles do not belong to
the destination server roles too.
I think that i must use the sp_addrolemember to assign the
users migrated to the corresponding database roles
Best regards
>--Original Message--
>Hi,
>As soon as you transfer the syslogins table the server
wide fixed roles also
>will be transferred.
>Have a look into the below link , This script will
provide a easy method to
>quickly generate a script that will move all logins along
with same id and
>password from one server to other.
>
>http://www.databasejournal.com/features/mssql/article.php/
2228611
>--
>Thanks
>Hari
>MCDBA
>"CC&JM" <anonymous@.discussions.microsoft.com> wrote in
message
>news:22d9501c45dd8$18b37630$a401280a@.phx.gbl...
>> Hi,
>> I need to migrate all databases from one server to
another
>> existing database server, at this time i know how to
>> migrate all users logins avoiding orphaned users but i
>> dont know how to migrate all existing roles and how to
>> assign logins to existing Server Roles on the
destination
>> with the minimum effort.
>> Best regards
>
>.
>|||HI,
After migration, Can you execute the below command:-
select * from syslogins
and see the below column values:-
sysadmin int 1, if login is a member of the sysadmin server role.
securityadmin int 1, if login is a member of the securityadmin server
role.
serveradmin int 1, if login is a member of the serveradmin fixed
server role.
setupadmin int 1, if login is a member of the setupadmin fixed server
role.
processadmin int 1, if login is a member of the processadmin fixed
server role.
diskadmin int 1, if login is a member of the diskadmin fixed server
role.
dbcreator int 1, if login is a member of the dbcreator fixed server
role.
If you have the value 1 for the column then the role is transfered from
source server to destination.
Thanks
Hari
MCDBA
<anonymous@.discussions.microsoft.com> wrote in message
news:2269701c45de4$91a25c80$a601280a@.phx.gbl...
> Hi Hari,
> I tried and the server roles were migrated to the new
> server but the roles appear with no members. The users
> that belong to any existing server roles do not belong to
> the destination server roles too.
> I think that i must use the sp_addrolemember to assign the
> users migrated to the corresponding database roles
> Best regards
> >--Original Message--
> >Hi,
> >
> >As soon as you transfer the syslogins table the server
> wide fixed roles also
> >will be transferred.
> >
> >Have a look into the below link , This script will
> provide a easy method to
> >quickly generate a script that will move all logins along
> with same id and
> >password from one server to other.
> >
> >
> >http://www.databasejournal.com/features/mssql/article.php/
> 2228611
> >
> >--
> >Thanks
> >Hari
> >MCDBA
> >
> >"CC&JM" <anonymous@.discussions.microsoft.com> wrote in
> message
> >news:22d9501c45dd8$18b37630$a401280a@.phx.gbl...
> >> Hi,
> >>
> >> I need to migrate all databases from one server to
> another
> >> existing database server, at this time i know how to
> >> migrate all users logins avoiding orphaned users but i
> >> dont know how to migrate all existing roles and how to
> >> assign logins to existing Server Roles on the
> destination
> >> with the minimum effort.
> >>
> >> Best regards
> >
> >
> >.
> >
Migrate Roles
Hi,
I need to migrate all databases from one server to another
existing database server, at this time i know how to
migrate all users logins avoiding orphaned users but i
dont know how to migrate all existing roles and how to
assign logins to existing Server Roles on the destination
with the minimum effort.
Best regardsHi,
As soon as you transfer the syslogins table the server wide fixed roles also
will be transferred.
Have a look into the below link , This script will provide a easy method to
quickly generate a script that will move all logins along with same id and
password from one server to other.
http://www.databasejournal.com/feat...cle.php/2228611
Thanks
Hari
MCDBA
"CC&JM" <anonymous@.discussions.microsoft.com> wrote in message
news:22d9501c45dd8$18b37630$a401280a@.phx
.gbl...
> Hi,
> I need to migrate all databases from one server to another
> existing database server, at this time i know how to
> migrate all users logins avoiding orphaned users but i
> dont know how to migrate all existing roles and how to
> assign logins to existing Server Roles on the destination
> with the minimum effort.
> Best regards|||Hi Hari,
I tried and the server roles were migrated to the new
server but the roles appear with no members. The users
that belong to any existing server roles do not belong to
the destination server roles too.
I think that i must use the sp_addrolemember to assign the
users migrated to the corresponding database roles
Best regards
>--Original Message--
>Hi,
>As soon as you transfer the syslogins table the server
wide fixed roles also
>will be transferred.
>Have a look into the below link , This script will
provide a easy method to
>quickly generate a script that will move all logins along
with same id and
>password from one server to other.
>
>http://www.databasejournal.com/feat...ql/article.php/
2228611
>--
>Thanks
>Hari
>MCDBA
>"CC&JM" <anonymous@.discussions.microsoft.com> wrote in
message
> news:22d9501c45dd8$18b37630$a401280a@.phx
.gbl...
another[vbcol=seagreen]
destination[vbcol=seagreen]
>
>.
>|||HI,
After migration, Can you execute the below command:-
select * from syslogins
and see the below column values:-
sysadmin int 1, if login is a member of the sysadmin server role.
securityadmin int 1, if login is a member of the securityadmin server
role.
serveradmin int 1, if login is a member of the serveradmin fixed
server role.
setupadmin int 1, if login is a member of the setupadmin fixed server
role.
processadmin int 1, if login is a member of the processadmin fixed
server role.
diskadmin int 1, if login is a member of the diskadmin fixed server
role.
dbcreator int 1, if login is a member of the dbcreator fixed server
role.
If you have the value 1 for the column then the role is transfered from
source server to destination.
Thanks
Hari
MCDBA
<anonymous@.discussions.microsoft.com> wrote in message
news:2269701c45de4$91a25c80$a601280a@.phx
.gbl...[vbcol=seagreen]
> Hi Hari,
> I tried and the server roles were migrated to the new
> server but the roles appear with no members. The users
> that belong to any existing server roles do not belong to
> the destination server roles too.
> I think that i must use the sp_addrolemember to assign the
> users migrated to the corresponding database roles
> Best regards
>
> wide fixed roles also
> provide a easy method to
> with same id and
> 2228611
> message
> another
> destination
I need to migrate all databases from one server to another
existing database server, at this time i know how to
migrate all users logins avoiding orphaned users but i
dont know how to migrate all existing roles and how to
assign logins to existing Server Roles on the destination
with the minimum effort.
Best regardsHi,
As soon as you transfer the syslogins table the server wide fixed roles also
will be transferred.
Have a look into the below link , This script will provide a easy method to
quickly generate a script that will move all logins along with same id and
password from one server to other.
http://www.databasejournal.com/feat...cle.php/2228611
Thanks
Hari
MCDBA
"CC&JM" <anonymous@.discussions.microsoft.com> wrote in message
news:22d9501c45dd8$18b37630$a401280a@.phx
.gbl...
> Hi,
> I need to migrate all databases from one server to another
> existing database server, at this time i know how to
> migrate all users logins avoiding orphaned users but i
> dont know how to migrate all existing roles and how to
> assign logins to existing Server Roles on the destination
> with the minimum effort.
> Best regards|||Hi Hari,
I tried and the server roles were migrated to the new
server but the roles appear with no members. The users
that belong to any existing server roles do not belong to
the destination server roles too.
I think that i must use the sp_addrolemember to assign the
users migrated to the corresponding database roles
Best regards
>--Original Message--
>Hi,
>As soon as you transfer the syslogins table the server
wide fixed roles also
>will be transferred.
>Have a look into the below link , This script will
provide a easy method to
>quickly generate a script that will move all logins along
with same id and
>password from one server to other.
>
>http://www.databasejournal.com/feat...ql/article.php/
2228611
>--
>Thanks
>Hari
>MCDBA
>"CC&JM" <anonymous@.discussions.microsoft.com> wrote in
message
> news:22d9501c45dd8$18b37630$a401280a@.phx
.gbl...
another[vbcol=seagreen]
destination[vbcol=seagreen]
>
>.
>|||HI,
After migration, Can you execute the below command:-
select * from syslogins
and see the below column values:-
sysadmin int 1, if login is a member of the sysadmin server role.
securityadmin int 1, if login is a member of the securityadmin server
role.
serveradmin int 1, if login is a member of the serveradmin fixed
server role.
setupadmin int 1, if login is a member of the setupadmin fixed server
role.
processadmin int 1, if login is a member of the processadmin fixed
server role.
diskadmin int 1, if login is a member of the diskadmin fixed server
role.
dbcreator int 1, if login is a member of the dbcreator fixed server
role.
If you have the value 1 for the column then the role is transfered from
source server to destination.
Thanks
Hari
MCDBA
<anonymous@.discussions.microsoft.com> wrote in message
news:2269701c45de4$91a25c80$a601280a@.phx
.gbl...[vbcol=seagreen]
> Hi Hari,
> I tried and the server roles were migrated to the new
> server but the roles appear with no members. The users
> that belong to any existing server roles do not belong to
> the destination server roles too.
> I think that i must use the sp_addrolemember to assign the
> users migrated to the corresponding database roles
> Best regards
>
> wide fixed roles also
> provide a easy method to
> with same id and
> 2228611
> message
> another
> destination
Monday, March 19, 2012
Migrate database objects to new server
How to migrate all SQL 2000 objects (tables, views, SPs)
and users from current SQL server to a new SQL 2000
server in different domain? DO I need to modify DTS
packages?
Thanks in advance.
-DonHi
You could restore a backup or detach/attach the database. This should be
alot quicker.
See
http://support.microsoft.com/default.aspx?scid=kb%3ben-us%3b224071
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q314546
For DTS packages you can either follow the instructions in the second link
or use DTS backup utility from
http://www.sqldts.com/default.aspx?242
John
"Don Walter" <anonymous@.discussions.microsoft.com> wrote in message
news:8e2c01c3b5cf$38e49cb0$a601280a@.phx.gbl...
> How to migrate all SQL 2000 objects (tables, views, SPs)
> and users from current SQL server to a new SQL 2000
> server in different domain? DO I need to modify DTS
> packages?
> Thanks in advance.
> -Don|||Thank you John for your advice.
-Don
>--Original Message--
>Hi
>You could restore a backup or detach/attach the
database. This should be
>alot quicker.
>See
>http://support.microsoft.com/default.aspx?scid=kb%3ben-
us%3b224071
>http://support.microsoft.com/default.aspx?scid=kb;en-
us;Q314546
>For DTS packages you can either follow the instructions
in the second link
>or use DTS backup utility from
>http://www.sqldts.com/default.aspx?242
>John
>"Don Walter" <anonymous@.discussions.microsoft.com> wrote
in message
>news:8e2c01c3b5cf$38e49cb0$a601280a@.phx.gbl...
>> How to migrate all SQL 2000 objects (tables, views,
SPs)
>> and users from current SQL server to a new SQL 2000
>> server in different domain? DO I need to modify DTS
>> packages?
>> Thanks in advance.
>> -Don
>
>.
>
and users from current SQL server to a new SQL 2000
server in different domain? DO I need to modify DTS
packages?
Thanks in advance.
-DonHi
You could restore a backup or detach/attach the database. This should be
alot quicker.
See
http://support.microsoft.com/default.aspx?scid=kb%3ben-us%3b224071
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q314546
For DTS packages you can either follow the instructions in the second link
or use DTS backup utility from
http://www.sqldts.com/default.aspx?242
John
"Don Walter" <anonymous@.discussions.microsoft.com> wrote in message
news:8e2c01c3b5cf$38e49cb0$a601280a@.phx.gbl...
> How to migrate all SQL 2000 objects (tables, views, SPs)
> and users from current SQL server to a new SQL 2000
> server in different domain? DO I need to modify DTS
> packages?
> Thanks in advance.
> -Don|||Thank you John for your advice.
-Don
>--Original Message--
>Hi
>You could restore a backup or detach/attach the
database. This should be
>alot quicker.
>See
>http://support.microsoft.com/default.aspx?scid=kb%3ben-
us%3b224071
>http://support.microsoft.com/default.aspx?scid=kb;en-
us;Q314546
>For DTS packages you can either follow the instructions
in the second link
>or use DTS backup utility from
>http://www.sqldts.com/default.aspx?242
>John
>"Don Walter" <anonymous@.discussions.microsoft.com> wrote
in message
>news:8e2c01c3b5cf$38e49cb0$a601280a@.phx.gbl...
>> How to migrate all SQL 2000 objects (tables, views,
SPs)
>> and users from current SQL server to a new SQL 2000
>> server in different domain? DO I need to modify DTS
>> packages?
>> Thanks in advance.
>> -Don
>
>.
>
migrate database incl. user and password to other server
hi all,
i need to migrate a database including the user and their passwords to
another server.
create the users manually is not possible because i do not know the
passwords. is there a possibility to get them to another db server?
im talking about sql server 2000 sp3
thanks
mic
Hi
There are to stored procedures provided by MS to transfer logins with their
original SID
Search on internet for 'sp_help_revlogin'
"j.goines" <muchos@.hotmail.com> wrote in message
news:e6z4rANIGHA.2948@.TK2MSFTNGP10.phx.gbl...
> hi all,
> i need to migrate a database including the user and their passwords to
> another server.
> create the users manually is not possible because i do not know the
> passwords. is there a possibility to get them to another db server?
> im talking about sql server 2000 sp3
> thanks
> mic
>
|||thanks a lot,
greets
mic
"Uri Dimant" <urid@.iscar.co.il> schrieb im Newsbeitrag
news:uZirDKNIGHA.984@.tk2msftngp13.phx.gbl...
> Hi
> There are to stored procedures provided by MS to transfer logins with
> their original SID
> Search on internet for 'sp_help_revlogin'
>
> "j.goines" <muchos@.hotmail.com> wrote in message
> news:e6z4rANIGHA.2948@.TK2MSFTNGP10.phx.gbl...
>
i need to migrate a database including the user and their passwords to
another server.
create the users manually is not possible because i do not know the
passwords. is there a possibility to get them to another db server?
im talking about sql server 2000 sp3
thanks
mic
Hi
There are to stored procedures provided by MS to transfer logins with their
original SID
Search on internet for 'sp_help_revlogin'
"j.goines" <muchos@.hotmail.com> wrote in message
news:e6z4rANIGHA.2948@.TK2MSFTNGP10.phx.gbl...
> hi all,
> i need to migrate a database including the user and their passwords to
> another server.
> create the users manually is not possible because i do not know the
> passwords. is there a possibility to get them to another db server?
> im talking about sql server 2000 sp3
> thanks
> mic
>
|||thanks a lot,
greets
mic
"Uri Dimant" <urid@.iscar.co.il> schrieb im Newsbeitrag
news:uZirDKNIGHA.984@.tk2msftngp13.phx.gbl...
> Hi
> There are to stored procedures provided by MS to transfer logins with
> their original SID
> Search on internet for 'sp_help_revlogin'
>
> "j.goines" <muchos@.hotmail.com> wrote in message
> news:e6z4rANIGHA.2948@.TK2MSFTNGP10.phx.gbl...
>
migrate database incl. user and password to other server
hi all,
i need to migrate a database including the user and their passwords to
another server.
create the users manually is not possible because i do not know the
passwords. is there a possibility to get them to another db server?
i´m talking about sql server 2000 sp3
thanks
micHi
There are to stored procedures provided by MS to transfer logins with their
original SID
Search on internet for 'sp_help_revlogin'
"j.goines" <muchos@.hotmail.com> wrote in message
news:e6z4rANIGHA.2948@.TK2MSFTNGP10.phx.gbl...
> hi all,
> i need to migrate a database including the user and their passwords to
> another server.
> create the users manually is not possible because i do not know the
> passwords. is there a possibility to get them to another db server?
> i´m talking about sql server 2000 sp3
> thanks
> mic
>|||thanks a lot,
greets
mic
"Uri Dimant" <urid@.iscar.co.il> schrieb im Newsbeitrag
news:uZirDKNIGHA.984@.tk2msftngp13.phx.gbl...
> Hi
> There are to stored procedures provided by MS to transfer logins with
> their original SID
> Search on internet for 'sp_help_revlogin'
>
> "j.goines" <muchos@.hotmail.com> wrote in message
> news:e6z4rANIGHA.2948@.TK2MSFTNGP10.phx.gbl...
>> hi all,
>> i need to migrate a database including the user and their passwords to
>> another server.
>> create the users manually is not possible because i do not know the
>> passwords. is there a possibility to get them to another db server?
>> i´m talking about sql server 2000 sp3
>> thanks
>> mic
>
i need to migrate a database including the user and their passwords to
another server.
create the users manually is not possible because i do not know the
passwords. is there a possibility to get them to another db server?
i´m talking about sql server 2000 sp3
thanks
micHi
There are to stored procedures provided by MS to transfer logins with their
original SID
Search on internet for 'sp_help_revlogin'
"j.goines" <muchos@.hotmail.com> wrote in message
news:e6z4rANIGHA.2948@.TK2MSFTNGP10.phx.gbl...
> hi all,
> i need to migrate a database including the user and their passwords to
> another server.
> create the users manually is not possible because i do not know the
> passwords. is there a possibility to get them to another db server?
> i´m talking about sql server 2000 sp3
> thanks
> mic
>|||thanks a lot,
greets
mic
"Uri Dimant" <urid@.iscar.co.il> schrieb im Newsbeitrag
news:uZirDKNIGHA.984@.tk2msftngp13.phx.gbl...
> Hi
> There are to stored procedures provided by MS to transfer logins with
> their original SID
> Search on internet for 'sp_help_revlogin'
>
> "j.goines" <muchos@.hotmail.com> wrote in message
> news:e6z4rANIGHA.2948@.TK2MSFTNGP10.phx.gbl...
>> hi all,
>> i need to migrate a database including the user and their passwords to
>> another server.
>> create the users manually is not possible because i do not know the
>> passwords. is there a possibility to get them to another db server?
>> i´m talking about sql server 2000 sp3
>> thanks
>> mic
>
Monday, March 12, 2012
migrate database incl. user and password to other server
hi all,
i need to migrate a database including the user and their passwords to
another server.
create the users manually is not possible because i do not know the
passwords. is there a possibility to get them to another db server?
im talking about sql server 2000 sp3
thanks
micHi
There are to stored procedures provided by MS to transfer logins with their
original SID
Search on internet for 'sp_help_revlogin'
"j.goines" <muchos@.hotmail.com> wrote in message
news:e6z4rANIGHA.2948@.TK2MSFTNGP10.phx.gbl...
> hi all,
> i need to migrate a database including the user and their passwords to
> another server.
> create the users manually is not possible because i do not know the
> passwords. is there a possibility to get them to another db server?
> im talking about sql server 2000 sp3
> thanks
> mic
>|||thanks a lot,
greets
mic
"Uri Dimant" <urid@.iscar.co.il> schrieb im Newsbeitrag
news:uZirDKNIGHA.984@.tk2msftngp13.phx.gbl...
> Hi
> There are to stored procedures provided by MS to transfer logins with
> their original SID
> Search on internet for 'sp_help_revlogin'
>
> "j.goines" <muchos@.hotmail.com> wrote in message
> news:e6z4rANIGHA.2948@.TK2MSFTNGP10.phx.gbl...
>
i need to migrate a database including the user and their passwords to
another server.
create the users manually is not possible because i do not know the
passwords. is there a possibility to get them to another db server?
im talking about sql server 2000 sp3
thanks
micHi
There are to stored procedures provided by MS to transfer logins with their
original SID
Search on internet for 'sp_help_revlogin'
"j.goines" <muchos@.hotmail.com> wrote in message
news:e6z4rANIGHA.2948@.TK2MSFTNGP10.phx.gbl...
> hi all,
> i need to migrate a database including the user and their passwords to
> another server.
> create the users manually is not possible because i do not know the
> passwords. is there a possibility to get them to another db server?
> im talking about sql server 2000 sp3
> thanks
> mic
>|||thanks a lot,
greets
mic
"Uri Dimant" <urid@.iscar.co.il> schrieb im Newsbeitrag
news:uZirDKNIGHA.984@.tk2msftngp13.phx.gbl...
> Hi
> There are to stored procedures provided by MS to transfer logins with
> their original SID
> Search on internet for 'sp_help_revlogin'
>
> "j.goines" <muchos@.hotmail.com> wrote in message
> news:e6z4rANIGHA.2948@.TK2MSFTNGP10.phx.gbl...
>
Subscribe to:
Posts (Atom)