Showing posts with label article. Show all posts
Showing posts with label article. Show all posts

Wednesday, March 7, 2012

Help moving users to from old instance

Hello,
I know there is a kb article on how to move users from an old instance
to a new one, but I cannot find it. Can someone point me in the right
direction please? We are moving our instances to new hardware. Thanks.
INF: How To Transfer Logins and Passwords Between SQL Servers
http://support.microsoft.com/default...;en-us;Q246133
PRB: User Logon and/or Permission Errors After Restoring Dump
http://support.microsoft.com/default...;en-us;Q168001
INF: How to Resolve Permission Issues When a Database is Moved Between SQL
Servers
http://support.microsoft.com/default...;en-us;Q240872
PRB: "Troubleshooting Orphaned Users" Topic in Books Online is Incomplete
http://support.microsoft.com/default...;en-us;Q274188
HTH
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Jake Smythe" <rondican@.hotmail.com> wrote in message
news:uWBV%238nJFHA.2628@.tk2msftngp13.phx.gbl...
> Hello,
> I know there is a kb article on how to move users from an old instance
> to a new one, but I cannot find it. Can someone point me in the right
> direction please? We are moving our instances to new hardware. Thanks.
>

Help moving users to from old instance

Hello,
I know there is a kb article on how to move users from an old instance
to a new one, but I cannot find it. Can someone point me in the right
direction please? We are moving our instances to new hardware. Thanks.INF: How To Transfer Logins and Passwords Between SQL Servers
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q246133
PRB: User Logon and/or Permission Errors After Restoring Dump
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q168001
INF: How to Resolve Permission Issues When a Database is Moved Between SQL
Servers
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q240872
PRB: "Troubleshooting Orphaned Users" Topic in Books Online is Incomplete
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q274188
--
HTH
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Jake Smythe" <rondican@.hotmail.com> wrote in message
news:uWBV%238nJFHA.2628@.tk2msftngp13.phx.gbl...
> Hello,
> I know there is a kb article on how to move users from an old instance
> to a new one, but I cannot find it. Can someone point me in the right
> direction please? We are moving our instances to new hardware. Thanks.
>

Help moving users to from old instance

Hello,
I know there is a kb article on how to move users from an old instance
to a new one, but I cannot find it. Can someone point me in the right
direction please? We are moving our instances to new hardware. Thanks.INF: How To Transfer Logins and Passwords Between SQL Servers
http://support.microsoft.com/defaul...b;en-us;Q246133
PRB: User Logon and/or Permission Errors After Restoring Dump
http://support.microsoft.com/defaul...b;en-us;Q168001
INF: How to Resolve Permission Issues When a Database is Moved Between SQL
Servers
http://support.microsoft.com/defaul...b;en-us;Q240872
PRB: "Troubleshooting Orphaned Users" Topic in Books Online is Incomplete
http://support.microsoft.com/defaul...b;en-us;Q274188
HTH
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Jake Smythe" <rondican@.hotmail.com> wrote in message
news:uWBV%238nJFHA.2628@.tk2msftngp13.phx.gbl...
> Hello,
> I know there is a kb article on how to move users from an old instance
> to a new one, but I cannot find it. Can someone point me in the right
> direction please? We are moving our instances to new hardware. Thanks.
>

help moving system databases

sql 2000 sp3.
i need to move my system databases to a new drive. i've been reading kb
article 224071. it says to do model before msdb, but it doesn't say
when to do master. so do you do master first or last?master is independent from the others, as you don't attach or reattach
master, you just change the location in the startup properties in Enterprise
Manager.
--
Jacco Schalkwijk
SQL Server MVP
"ch" <ch@.dontemailme.com> wrote in message
news:409F91AB.493BB3C4@.dontemailme.com...
> sql 2000 sp3.
> i need to move my system databases to a new drive. i've been reading kb
> article 224071. it says to do model before msdb, but it doesn't say
> when to do master. so do you do master first or last?
>
>