Copy Database Wizard problem

Hi
Just a quick question: I often perform CDW from one server to the next as
part of clients server upgrades. All works fine:
The only major headache i am getting is that when i select the logins to be
copied as part of the CDW (including databases), the logins get copied
over, but their default database in the logins console is pointing to master
database and not the correct database compared to the old server? Sometimes
it works and sometimes it don't. I am not sure if i am doing anything
wrong.
Both servers are SQL 2000 inc SP3a using the same domain account. The
databases do not exist on the new server before the CDW.
Within the database itself, the alias Name has the correct assigned Login
Name
Can anyone give me some pointers?
Regards
J
Most likely you need to check to see if the dbid of the target databases are the same on both servers.
|||Ken
All dbid are the same, including same DBO and collation sort.
"Ken Dutton" <fj60landcruiser@.yahoo.com> wrote in message
news:22A8C534-A6D6-400C-BABB-22404154062A@.microsoft.com...
> Most likely you need to check to see if the dbid of the target databases
are the same on both servers.
|||This is documented in fhe following article:
PRB: The Copy Database Wizard Does Not Copy the Default Database
Information for Logins
http://support.microsoft.com/?id=331450
Rand
This posting is provided "as is" with no warranties and confers no rights.
|||Many thanks for link, this is just what i am looking for.
Thanks
J
"James" <hush@.dontspamme.com> wrote in message
news:uOW72LjQEHA.3732@.TK2MSFTNGP11.phx.gbl...
> Hi
> Just a quick question: I often perform CDW from one server to the next as
> part of clients server upgrades. All works fine:
> The only major headache i am getting is that when i select the logins to
be
> copied as part of the CDW (including databases), the logins get copied
> over, but their default database in the logins console is pointing to
master
> database and not the correct database compared to the old server?
Sometimes
> it works and sometimes it don't. I am not sure if i am doing anything
> wrong.
> Both servers are SQL 2000 inc SP3a using the same domain account. The
> databases do not exist on the new server before the CDW.
> Within the database itself, the alias Name has the correct assigned Login
> Name
> Can anyone give me some pointers?
> Regards
> J
>
>
sqlsql