Hello!
Today, I've successfully migrated a domain controler named DC2 to the new
domain. I've also changed its computer name, after joining him into the
new domain. And later i've promoted this server back to DC.
Now here is my Q: This server is also running SQL 2000 and OLAP services.
The migration of the server was success, I've rebuild the master tables
(on default and second instance) fine with exactly
defined stored procedures. But a lot of applications were using domain
logons to connect to SQL. For examle: on one of the instances there were
users like OLD_DOMAIN_NAME\user1, OLD_DOMAIN_NAME\user2 etc...
Now the problem is that domain name has changed but domain user info
stayed. HOW do i tell SQL server to change the domain name OLD_DOMAIN_NAME
to NEW_DOMAIN_NAME (the users were migrated successfuly into the new
domain, so they already exist in the new domain.
To make thing short:
How to tell SQL server to change the
OLD_DOMAIN_NAME\users* --> NEW_DOMAIN_NAME\users* logins?
Please help!!!!
You want to start with this:
http://support.microsoft.com/kb/246133/
-oj
"Francelj Smuk" <Francelj.Smuk@.email.si> wrote in message
news:pan.2005.04.16.18.50.16.974701@.email.si...
> Hello!
> Today, I've successfully migrated a domain controler named DC2 to the new
> domain. I've also changed its computer name, after joining him into the
> new domain. And later i've promoted this server back to DC.
> Now here is my Q: This server is also running SQL 2000 and OLAP services.
> The migration of the server was success, I've rebuild the master tables
> (on default and second instance) fine with exactly
> defined stored procedures. But a lot of applications were using domain
> logons to connect to SQL. For examle: on one of the instances there were
> users like OLD_DOMAIN_NAME\user1, OLD_DOMAIN_NAME\user2 etc...
> Now the problem is that domain name has changed but domain user info
> stayed. HOW do i tell SQL server to change the domain name OLD_DOMAIN_NAME
> to NEW_DOMAIN_NAME (the users were migrated successfuly into the new
> domain, so they already exist in the new domain.
> --
> To make thing short:
> How to tell SQL server to change the
> OLD_DOMAIN_NAME\users* --> NEW_DOMAIN_NAME\users* logins?
> Please help!!!!
>
|||Hi
Check out the links on http://support.microsoft.com/kb/246133/
John
"Francelj Smuk" <Francelj.Smuk@.email.si> wrote in message
news:pan.2005.04.16.18.50.16.974701@.email.si...
> Hello!
> Today, I've successfully migrated a domain controler named DC2 to the new
> domain. I've also changed its computer name, after joining him into the
> new domain. And later i've promoted this server back to DC.
> Now here is my Q: This server is also running SQL 2000 and OLAP services.
> The migration of the server was success, I've rebuild the master tables
> (on default and second instance) fine with exactly
> defined stored procedures. But a lot of applications were using domain
> logons to connect to SQL. For examle: on one of the instances there were
> users like OLD_DOMAIN_NAME\user1, OLD_DOMAIN_NAME\user2 etc...
> Now the problem is that domain name has changed but domain user info
> stayed. HOW do i tell SQL server to change the domain name OLD_DOMAIN_NAME
> to NEW_DOMAIN_NAME (the users were migrated successfuly into the new
> domain, so they already exist in the new domain.
> --
> To make thing short:
> How to tell SQL server to change the
> OLD_DOMAIN_NAME\users* --> NEW_DOMAIN_NAME\users* logins?
> Please help!!!!
>
|||On Sat, 16 Apr 2005 12:23:47 -0700, oj wrote:
> You want to start with this:
> http://support.microsoft.com/kb/246133/
I wrote the whole thing a bit confusing, so here is the article that
describes my dilema:
http://support.microsoft.com/kb/240872/
I'm reading this article and I'm wondering... Do i really need to go thrue
this procedure, or is it enough just to delete old sql domain user
login and than recreate it, for example:
I'll delete OLD_DOMAIN_NAME\user1 (in SQL logins)
and than i will create a new user:
NEW_DOMAIN_NAME\user1.
Is this ok, or will I be experiences some problems when trying to connect
(because of SID's etc..)?
This is a production server, so I really need to get clear with his facts
here.
Thank you!
|||Yes, follow the instruction in this kb. sp_sidmap should help resolve your
issue.
-oj
"Francelj Smuk" <Francelj.Smuk@.email.si> wrote in message
news:pan.2005.04.16.20.21.39.620670@.email.si...
> On Sat, 16 Apr 2005 12:23:47 -0700, oj wrote:
>
> I wrote the whole thing a bit confusing, so here is the article that
> describes my dilema:
> http://support.microsoft.com/kb/240872/
> I'm reading this article and I'm wondering... Do i really need to go thrue
> this procedure, or is it enough just to delete old sql domain user
> login and than recreate it, for example:
> I'll delete OLD_DOMAIN_NAME\user1 (in SQL logins)
> and than i will create a new user:
> NEW_DOMAIN_NAME\user1.
> Is this ok, or will I be experiences some problems when trying to connect
> (because of SID's etc..)?
> This is a production server, so I really need to get clear with his facts
> here.
> Thank you!
|||On Sat, 16 Apr 2005 13:25:01 -0700, oj wrote:
> Yes, follow the instruction in this kb. sp_sidmap should help resolve your
> issue.
Ok, so I've study the material, I understand everything except this:
1.) "Log on to the server that is running SQL Server as a system
administrator, and then run the Sp_sidmap.sql file in the user database."
So, where exactly is the user database? I really don't know what's meant
by that.
2.) I need to execute this script and the other things on the second
instance too, right?
Thank you.
|||The script can be download from:
http://download.microsoft.com/downlo...us/mapsids.exe
The user database is your database (i.e. not master, msdb, tempdb, model).
Yes, you will have to do it for each (unfortunately).
-oj
"Francelj Smuk" <Francelj.Smuk@.email.si> wrote in message
news:pan.2005.04.16.20.45.00.969560@.email.si...
> On Sat, 16 Apr 2005 13:25:01 -0700, oj wrote:
>
> Ok, so I've study the material, I understand everything except this:
> 1.) "Log on to the server that is running SQL Server as a system
> administrator, and then run the Sp_sidmap.sql file in the user database."
> So, where exactly is the user database? I really don't know what's meant
> by that.
> 2.) I need to execute this script and the other things on the second
> instance too, right?
> Thank you.
Showing posts with label domain. Show all posts
Showing posts with label domain. Show all posts
Wednesday, March 28, 2012
migrating domain and sql domain user logins
Hello!
Today, I've successfully migrated a domain controler named DC2 to the new
domain. I've also changed its computer name, after joining him into the
new domain. And later i've promoted this server back to DC.
Now here is my Q: This server is also running SQL 2000 and OLAP services.
The migration of the server was success, I've rebuild the master tables
(on default and second instance) fine with exactly
defined stored procedures. But a lot of applications were using domain
logons to connect to SQL. For examle: on one of the instances there were
users like OLD_DOMAIN_NAME\user1, OLD_DOMAIN_NAME\user2 etc...
Now the problem is that domain name has changed but domain user info
stayed. HOW do i tell SQL server to change the domain name OLD_DOMAIN_NAME
to NEW_DOMAIN_NAME (the users were migrated successfuly into the new
domain, so they already exist in the new domain.
--
To make thing short:
How to tell SQL server to change the
OLD_DOMAIN_NAME\users* --> NEW_DOMAIN_NAME\users* logins?
Please help!!!!You want to start with this:
http://support.microsoft.com/kb/246133/
--
-oj
"Francelj Smuk" <Francelj.Smuk@.email.si> wrote in message
news:pan.2005.04.16.18.50.16.974701@.email.si...
> Hello!
> Today, I've successfully migrated a domain controler named DC2 to the new
> domain. I've also changed its computer name, after joining him into the
> new domain. And later i've promoted this server back to DC.
> Now here is my Q: This server is also running SQL 2000 and OLAP services.
> The migration of the server was success, I've rebuild the master tables
> (on default and second instance) fine with exactly
> defined stored procedures. But a lot of applications were using domain
> logons to connect to SQL. For examle: on one of the instances there were
> users like OLD_DOMAIN_NAME\user1, OLD_DOMAIN_NAME\user2 etc...
> Now the problem is that domain name has changed but domain user info
> stayed. HOW do i tell SQL server to change the domain name OLD_DOMAIN_NAME
> to NEW_DOMAIN_NAME (the users were migrated successfuly into the new
> domain, so they already exist in the new domain.
> --
> To make thing short:
> How to tell SQL server to change the
> OLD_DOMAIN_NAME\users* --> NEW_DOMAIN_NAME\users* logins?
> Please help!!!!
>|||Hi
Check out the links on http://support.microsoft.com/kb/246133/
John
"Francelj Smuk" <Francelj.Smuk@.email.si> wrote in message
news:pan.2005.04.16.18.50.16.974701@.email.si...
> Hello!
> Today, I've successfully migrated a domain controler named DC2 to the new
> domain. I've also changed its computer name, after joining him into the
> new domain. And later i've promoted this server back to DC.
> Now here is my Q: This server is also running SQL 2000 and OLAP services.
> The migration of the server was success, I've rebuild the master tables
> (on default and second instance) fine with exactly
> defined stored procedures. But a lot of applications were using domain
> logons to connect to SQL. For examle: on one of the instances there were
> users like OLD_DOMAIN_NAME\user1, OLD_DOMAIN_NAME\user2 etc...
> Now the problem is that domain name has changed but domain user info
> stayed. HOW do i tell SQL server to change the domain name OLD_DOMAIN_NAME
> to NEW_DOMAIN_NAME (the users were migrated successfuly into the new
> domain, so they already exist in the new domain.
> --
> To make thing short:
> How to tell SQL server to change the
> OLD_DOMAIN_NAME\users* --> NEW_DOMAIN_NAME\users* logins?
> Please help!!!!
>|||On Sat, 16 Apr 2005 12:23:47 -0700, oj wrote:
> You want to start with this:
> http://support.microsoft.com/kb/246133/
I wrote the whole thing a bit confusing, so here is the article that
describes my dilema:
http://support.microsoft.com/kb/240872/
I'm reading this article and I'm wondering... Do i really need to go thrue
this procedure, or is it enough just to delete old sql domain user
login and than recreate it, for example:
I'll delete OLD_DOMAIN_NAME\user1 (in SQL logins)
and than i will create a new user:
NEW_DOMAIN_NAME\user1.
Is this ok, or will I be experiences some problems when trying to connect
(because of SID's etc..)?
This is a production server, so I really need to get clear with his facts
here.
Thank you!|||Yes, follow the instruction in this kb. sp_sidmap should help resolve your
issue.
--
-oj
"Francelj Smuk" <Francelj.Smuk@.email.si> wrote in message
news:pan.2005.04.16.20.21.39.620670@.email.si...
> On Sat, 16 Apr 2005 12:23:47 -0700, oj wrote:
>> You want to start with this:
>> http://support.microsoft.com/kb/246133/
> I wrote the whole thing a bit confusing, so here is the article that
> describes my dilema:
> http://support.microsoft.com/kb/240872/
> I'm reading this article and I'm wondering... Do i really need to go thrue
> this procedure, or is it enough just to delete old sql domain user
> login and than recreate it, for example:
> I'll delete OLD_DOMAIN_NAME\user1 (in SQL logins)
> and than i will create a new user:
> NEW_DOMAIN_NAME\user1.
> Is this ok, or will I be experiences some problems when trying to connect
> (because of SID's etc..)?
> This is a production server, so I really need to get clear with his facts
> here.
> Thank you!|||On Sat, 16 Apr 2005 13:25:01 -0700, oj wrote:
> Yes, follow the instruction in this kb. sp_sidmap should help resolve your
> issue.
Ok, so I've study the material, I understand everything except this:
1.) "Log on to the server that is running SQL Server as a system
administrator, and then run the Sp_sidmap.sql file in the user database."
So, where exactly is the user database? I really don't know what's meant
by that.
2.) I need to execute this script and the other things on the second
instance too, right?
Thank you.|||The script can be download from:
http://download.microsoft.com/download/sqlsvr2000/utility/5.0/win98me/en-us/mapsids.exe
The user database is your database (i.e. not master, msdb, tempdb, model).
Yes, you will have to do it for each (unfortunately).
--
-oj
"Francelj Smuk" <Francelj.Smuk@.email.si> wrote in message
news:pan.2005.04.16.20.45.00.969560@.email.si...
> On Sat, 16 Apr 2005 13:25:01 -0700, oj wrote:
>> Yes, follow the instruction in this kb. sp_sidmap should help resolve
>> your
>> issue.
> Ok, so I've study the material, I understand everything except this:
> 1.) "Log on to the server that is running SQL Server as a system
> administrator, and then run the Sp_sidmap.sql file in the user database."
> So, where exactly is the user database? I really don't know what's meant
> by that.
> 2.) I need to execute this script and the other things on the second
> instance too, right?
> Thank you.sql
Today, I've successfully migrated a domain controler named DC2 to the new
domain. I've also changed its computer name, after joining him into the
new domain. And later i've promoted this server back to DC.
Now here is my Q: This server is also running SQL 2000 and OLAP services.
The migration of the server was success, I've rebuild the master tables
(on default and second instance) fine with exactly
defined stored procedures. But a lot of applications were using domain
logons to connect to SQL. For examle: on one of the instances there were
users like OLD_DOMAIN_NAME\user1, OLD_DOMAIN_NAME\user2 etc...
Now the problem is that domain name has changed but domain user info
stayed. HOW do i tell SQL server to change the domain name OLD_DOMAIN_NAME
to NEW_DOMAIN_NAME (the users were migrated successfuly into the new
domain, so they already exist in the new domain.
--
To make thing short:
How to tell SQL server to change the
OLD_DOMAIN_NAME\users* --> NEW_DOMAIN_NAME\users* logins?
Please help!!!!You want to start with this:
http://support.microsoft.com/kb/246133/
--
-oj
"Francelj Smuk" <Francelj.Smuk@.email.si> wrote in message
news:pan.2005.04.16.18.50.16.974701@.email.si...
> Hello!
> Today, I've successfully migrated a domain controler named DC2 to the new
> domain. I've also changed its computer name, after joining him into the
> new domain. And later i've promoted this server back to DC.
> Now here is my Q: This server is also running SQL 2000 and OLAP services.
> The migration of the server was success, I've rebuild the master tables
> (on default and second instance) fine with exactly
> defined stored procedures. But a lot of applications were using domain
> logons to connect to SQL. For examle: on one of the instances there were
> users like OLD_DOMAIN_NAME\user1, OLD_DOMAIN_NAME\user2 etc...
> Now the problem is that domain name has changed but domain user info
> stayed. HOW do i tell SQL server to change the domain name OLD_DOMAIN_NAME
> to NEW_DOMAIN_NAME (the users were migrated successfuly into the new
> domain, so they already exist in the new domain.
> --
> To make thing short:
> How to tell SQL server to change the
> OLD_DOMAIN_NAME\users* --> NEW_DOMAIN_NAME\users* logins?
> Please help!!!!
>|||Hi
Check out the links on http://support.microsoft.com/kb/246133/
John
"Francelj Smuk" <Francelj.Smuk@.email.si> wrote in message
news:pan.2005.04.16.18.50.16.974701@.email.si...
> Hello!
> Today, I've successfully migrated a domain controler named DC2 to the new
> domain. I've also changed its computer name, after joining him into the
> new domain. And later i've promoted this server back to DC.
> Now here is my Q: This server is also running SQL 2000 and OLAP services.
> The migration of the server was success, I've rebuild the master tables
> (on default and second instance) fine with exactly
> defined stored procedures. But a lot of applications were using domain
> logons to connect to SQL. For examle: on one of the instances there were
> users like OLD_DOMAIN_NAME\user1, OLD_DOMAIN_NAME\user2 etc...
> Now the problem is that domain name has changed but domain user info
> stayed. HOW do i tell SQL server to change the domain name OLD_DOMAIN_NAME
> to NEW_DOMAIN_NAME (the users were migrated successfuly into the new
> domain, so they already exist in the new domain.
> --
> To make thing short:
> How to tell SQL server to change the
> OLD_DOMAIN_NAME\users* --> NEW_DOMAIN_NAME\users* logins?
> Please help!!!!
>|||On Sat, 16 Apr 2005 12:23:47 -0700, oj wrote:
> You want to start with this:
> http://support.microsoft.com/kb/246133/
I wrote the whole thing a bit confusing, so here is the article that
describes my dilema:
http://support.microsoft.com/kb/240872/
I'm reading this article and I'm wondering... Do i really need to go thrue
this procedure, or is it enough just to delete old sql domain user
login and than recreate it, for example:
I'll delete OLD_DOMAIN_NAME\user1 (in SQL logins)
and than i will create a new user:
NEW_DOMAIN_NAME\user1.
Is this ok, or will I be experiences some problems when trying to connect
(because of SID's etc..)?
This is a production server, so I really need to get clear with his facts
here.
Thank you!|||Yes, follow the instruction in this kb. sp_sidmap should help resolve your
issue.
--
-oj
"Francelj Smuk" <Francelj.Smuk@.email.si> wrote in message
news:pan.2005.04.16.20.21.39.620670@.email.si...
> On Sat, 16 Apr 2005 12:23:47 -0700, oj wrote:
>> You want to start with this:
>> http://support.microsoft.com/kb/246133/
> I wrote the whole thing a bit confusing, so here is the article that
> describes my dilema:
> http://support.microsoft.com/kb/240872/
> I'm reading this article and I'm wondering... Do i really need to go thrue
> this procedure, or is it enough just to delete old sql domain user
> login and than recreate it, for example:
> I'll delete OLD_DOMAIN_NAME\user1 (in SQL logins)
> and than i will create a new user:
> NEW_DOMAIN_NAME\user1.
> Is this ok, or will I be experiences some problems when trying to connect
> (because of SID's etc..)?
> This is a production server, so I really need to get clear with his facts
> here.
> Thank you!|||On Sat, 16 Apr 2005 13:25:01 -0700, oj wrote:
> Yes, follow the instruction in this kb. sp_sidmap should help resolve your
> issue.
Ok, so I've study the material, I understand everything except this:
1.) "Log on to the server that is running SQL Server as a system
administrator, and then run the Sp_sidmap.sql file in the user database."
So, where exactly is the user database? I really don't know what's meant
by that.
2.) I need to execute this script and the other things on the second
instance too, right?
Thank you.|||The script can be download from:
http://download.microsoft.com/download/sqlsvr2000/utility/5.0/win98me/en-us/mapsids.exe
The user database is your database (i.e. not master, msdb, tempdb, model).
Yes, you will have to do it for each (unfortunately).
--
-oj
"Francelj Smuk" <Francelj.Smuk@.email.si> wrote in message
news:pan.2005.04.16.20.45.00.969560@.email.si...
> On Sat, 16 Apr 2005 13:25:01 -0700, oj wrote:
>> Yes, follow the instruction in this kb. sp_sidmap should help resolve
>> your
>> issue.
> Ok, so I've study the material, I understand everything except this:
> 1.) "Log on to the server that is running SQL Server as a system
> administrator, and then run the Sp_sidmap.sql file in the user database."
> So, where exactly is the user database? I really don't know what's meant
> by that.
> 2.) I need to execute this script and the other things on the second
> instance too, right?
> Thank you.sql
migrating domain and sql domain user logins
Hello!
Today, I've successfully migrated a domain controler named DC2 to the new
domain. I've also changed its computer name, after joining him into the
new domain. And later i've promoted this server back to DC.
Now here is my Q: This server is also running SQL 2000 and OLAP services.
The migration of the server was success, I've rebuild the master tables
(on default and second instance) fine with exactly
defined stored procedures. But a lot of applications were using domain
logons to connect to SQL. For examle: on one of the instances there were
users like OLD_DOMAIN_NAME\user1, OLD_DOMAIN_NAME\user2 etc...
Now the problem is that domain name has changed but domain user info
stayed. HOW do i tell SQL server to change the domain name OLD_DOMAIN_NAME
to NEW_DOMAIN_NAME (the users were migrated successfuly into the new
domain, so they already exist in the new domain.
To make thing short:
How to tell SQL server to change the
OLD_DOMAIN_NAME\users* --> NEW_DOMAIN_NAME\users* logins?
Please help!!!!You want to start with this:
http://support.microsoft.com/kb/246133/
-oj
"Francelj Smuk" <Francelj.Smuk@.email.si> wrote in message
news:pan.2005.04.16.18.50.16.974701@.email.si...
> Hello!
> Today, I've successfully migrated a domain controler named DC2 to the new
> domain. I've also changed its computer name, after joining him into the
> new domain. And later i've promoted this server back to DC.
> Now here is my Q: This server is also running SQL 2000 and OLAP services.
> The migration of the server was success, I've rebuild the master tables
> (on default and second instance) fine with exactly
> defined stored procedures. But a lot of applications were using domain
> logons to connect to SQL. For examle: on one of the instances there were
> users like OLD_DOMAIN_NAME\user1, OLD_DOMAIN_NAME\user2 etc...
> Now the problem is that domain name has changed but domain user info
> stayed. HOW do i tell SQL server to change the domain name OLD_DOMAIN_NAME
> to NEW_DOMAIN_NAME (the users were migrated successfuly into the new
> domain, so they already exist in the new domain.
> --
> To make thing short:
> How to tell SQL server to change the
> OLD_DOMAIN_NAME\users* --> NEW_DOMAIN_NAME\users* logins?
> Please help!!!!
>|||Hi
Check out the links on http://support.microsoft.com/kb/246133/
John
"Francelj Smuk" <Francelj.Smuk@.email.si> wrote in message
news:pan.2005.04.16.18.50.16.974701@.email.si...
> Hello!
> Today, I've successfully migrated a domain controler named DC2 to the new
> domain. I've also changed its computer name, after joining him into the
> new domain. And later i've promoted this server back to DC.
> Now here is my Q: This server is also running SQL 2000 and OLAP services.
> The migration of the server was success, I've rebuild the master tables
> (on default and second instance) fine with exactly
> defined stored procedures. But a lot of applications were using domain
> logons to connect to SQL. For examle: on one of the instances there were
> users like OLD_DOMAIN_NAME\user1, OLD_DOMAIN_NAME\user2 etc...
> Now the problem is that domain name has changed but domain user info
> stayed. HOW do i tell SQL server to change the domain name OLD_DOMAIN_NAME
> to NEW_DOMAIN_NAME (the users were migrated successfuly into the new
> domain, so they already exist in the new domain.
> --
> To make thing short:
> How to tell SQL server to change the
> OLD_DOMAIN_NAME\users* --> NEW_DOMAIN_NAME\users* logins?
> Please help!!!!
>|||On Sat, 16 Apr 2005 12:23:47 -0700, oj wrote:
> You want to start with this:
> http://support.microsoft.com/kb/246133/
I wrote the whole thing a bit confusing, so here is the article that
describes my dilema:
http://support.microsoft.com/kb/240872/
I'm reading this article and I'm wondering... Do i really need to go thrue
this procedure, or is it enough just to delete old sql domain user
login and than recreate it, for example:
I'll delete OLD_DOMAIN_NAME\user1 (in SQL logins)
and than i will create a new user:
NEW_DOMAIN_NAME\user1.
Is this ok, or will I be experiences some problems when trying to connect
(because of SID's etc..)?
This is a production server, so I really need to get clear with his facts
here.
Thank you!|||Yes, follow the instruction in this kb. sp_sidmap should help resolve your
issue.
-oj
"Francelj Smuk" <Francelj.Smuk@.email.si> wrote in message
news:pan.2005.04.16.20.21.39.620670@.email.si...
> On Sat, 16 Apr 2005 12:23:47 -0700, oj wrote:
>
> I wrote the whole thing a bit confusing, so here is the article that
> describes my dilema:
> http://support.microsoft.com/kb/240872/
> I'm reading this article and I'm wondering... Do i really need to go thrue
> this procedure, or is it enough just to delete old sql domain user
> login and than recreate it, for example:
> I'll delete OLD_DOMAIN_NAME\user1 (in SQL logins)
> and than i will create a new user:
> NEW_DOMAIN_NAME\user1.
> Is this ok, or will I be experiences some problems when trying to connect
> (because of SID's etc..)?
> This is a production server, so I really need to get clear with his facts
> here.
> Thank you!|||On Sat, 16 Apr 2005 13:25:01 -0700, oj wrote:
> Yes, follow the instruction in this kb. sp_sidmap should help resolve your
> issue.
Ok, so I've study the material, I understand everything except this:
1.) "Log on to the server that is running SQL Server as a system
administrator, and then run the Sp_sidmap.sql file in the user database."
So, where exactly is the user database? I really don't know what's meant
by that.
2.) I need to execute this script and the other things on the second
instance too, right?
Thank you.|||The script can be download from:
http://download.microsoft.com/downl...id
s.exe
The user database is your database (i.e. not master, msdb, tempdb, model).
Yes, you will have to do it for each (unfortunately).
-oj
"Francelj Smuk" <Francelj.Smuk@.email.si> wrote in message
news:pan.2005.04.16.20.45.00.969560@.email.si...
> On Sat, 16 Apr 2005 13:25:01 -0700, oj wrote:
>
> Ok, so I've study the material, I understand everything except this:
> 1.) "Log on to the server that is running SQL Server as a system
> administrator, and then run the Sp_sidmap.sql file in the user database."
> So, where exactly is the user database? I really don't know what's meant
> by that.
> 2.) I need to execute this script and the other things on the second
> instance too, right?
> Thank you.
Today, I've successfully migrated a domain controler named DC2 to the new
domain. I've also changed its computer name, after joining him into the
new domain. And later i've promoted this server back to DC.
Now here is my Q: This server is also running SQL 2000 and OLAP services.
The migration of the server was success, I've rebuild the master tables
(on default and second instance) fine with exactly
defined stored procedures. But a lot of applications were using domain
logons to connect to SQL. For examle: on one of the instances there were
users like OLD_DOMAIN_NAME\user1, OLD_DOMAIN_NAME\user2 etc...
Now the problem is that domain name has changed but domain user info
stayed. HOW do i tell SQL server to change the domain name OLD_DOMAIN_NAME
to NEW_DOMAIN_NAME (the users were migrated successfuly into the new
domain, so they already exist in the new domain.
To make thing short:
How to tell SQL server to change the
OLD_DOMAIN_NAME\users* --> NEW_DOMAIN_NAME\users* logins?
Please help!!!!You want to start with this:
http://support.microsoft.com/kb/246133/
-oj
"Francelj Smuk" <Francelj.Smuk@.email.si> wrote in message
news:pan.2005.04.16.18.50.16.974701@.email.si...
> Hello!
> Today, I've successfully migrated a domain controler named DC2 to the new
> domain. I've also changed its computer name, after joining him into the
> new domain. And later i've promoted this server back to DC.
> Now here is my Q: This server is also running SQL 2000 and OLAP services.
> The migration of the server was success, I've rebuild the master tables
> (on default and second instance) fine with exactly
> defined stored procedures. But a lot of applications were using domain
> logons to connect to SQL. For examle: on one of the instances there were
> users like OLD_DOMAIN_NAME\user1, OLD_DOMAIN_NAME\user2 etc...
> Now the problem is that domain name has changed but domain user info
> stayed. HOW do i tell SQL server to change the domain name OLD_DOMAIN_NAME
> to NEW_DOMAIN_NAME (the users were migrated successfuly into the new
> domain, so they already exist in the new domain.
> --
> To make thing short:
> How to tell SQL server to change the
> OLD_DOMAIN_NAME\users* --> NEW_DOMAIN_NAME\users* logins?
> Please help!!!!
>|||Hi
Check out the links on http://support.microsoft.com/kb/246133/
John
"Francelj Smuk" <Francelj.Smuk@.email.si> wrote in message
news:pan.2005.04.16.18.50.16.974701@.email.si...
> Hello!
> Today, I've successfully migrated a domain controler named DC2 to the new
> domain. I've also changed its computer name, after joining him into the
> new domain. And later i've promoted this server back to DC.
> Now here is my Q: This server is also running SQL 2000 and OLAP services.
> The migration of the server was success, I've rebuild the master tables
> (on default and second instance) fine with exactly
> defined stored procedures. But a lot of applications were using domain
> logons to connect to SQL. For examle: on one of the instances there were
> users like OLD_DOMAIN_NAME\user1, OLD_DOMAIN_NAME\user2 etc...
> Now the problem is that domain name has changed but domain user info
> stayed. HOW do i tell SQL server to change the domain name OLD_DOMAIN_NAME
> to NEW_DOMAIN_NAME (the users were migrated successfuly into the new
> domain, so they already exist in the new domain.
> --
> To make thing short:
> How to tell SQL server to change the
> OLD_DOMAIN_NAME\users* --> NEW_DOMAIN_NAME\users* logins?
> Please help!!!!
>|||On Sat, 16 Apr 2005 12:23:47 -0700, oj wrote:
> You want to start with this:
> http://support.microsoft.com/kb/246133/
I wrote the whole thing a bit confusing, so here is the article that
describes my dilema:
http://support.microsoft.com/kb/240872/
I'm reading this article and I'm wondering... Do i really need to go thrue
this procedure, or is it enough just to delete old sql domain user
login and than recreate it, for example:
I'll delete OLD_DOMAIN_NAME\user1 (in SQL logins)
and than i will create a new user:
NEW_DOMAIN_NAME\user1.
Is this ok, or will I be experiences some problems when trying to connect
(because of SID's etc..)?
This is a production server, so I really need to get clear with his facts
here.
Thank you!|||Yes, follow the instruction in this kb. sp_sidmap should help resolve your
issue.
-oj
"Francelj Smuk" <Francelj.Smuk@.email.si> wrote in message
news:pan.2005.04.16.20.21.39.620670@.email.si...
> On Sat, 16 Apr 2005 12:23:47 -0700, oj wrote:
>
> I wrote the whole thing a bit confusing, so here is the article that
> describes my dilema:
> http://support.microsoft.com/kb/240872/
> I'm reading this article and I'm wondering... Do i really need to go thrue
> this procedure, or is it enough just to delete old sql domain user
> login and than recreate it, for example:
> I'll delete OLD_DOMAIN_NAME\user1 (in SQL logins)
> and than i will create a new user:
> NEW_DOMAIN_NAME\user1.
> Is this ok, or will I be experiences some problems when trying to connect
> (because of SID's etc..)?
> This is a production server, so I really need to get clear with his facts
> here.
> Thank you!|||On Sat, 16 Apr 2005 13:25:01 -0700, oj wrote:
> Yes, follow the instruction in this kb. sp_sidmap should help resolve your
> issue.
Ok, so I've study the material, I understand everything except this:
1.) "Log on to the server that is running SQL Server as a system
administrator, and then run the Sp_sidmap.sql file in the user database."
So, where exactly is the user database? I really don't know what's meant
by that.
2.) I need to execute this script and the other things on the second
instance too, right?
Thank you.|||The script can be download from:
http://download.microsoft.com/downl...id
s.exe
The user database is your database (i.e. not master, msdb, tempdb, model).
Yes, you will have to do it for each (unfortunately).
-oj
"Francelj Smuk" <Francelj.Smuk@.email.si> wrote in message
news:pan.2005.04.16.20.45.00.969560@.email.si...
> On Sat, 16 Apr 2005 13:25:01 -0700, oj wrote:
>
> Ok, so I've study the material, I understand everything except this:
> 1.) "Log on to the server that is running SQL Server as a system
> administrator, and then run the Sp_sidmap.sql file in the user database."
> So, where exactly is the user database? I really don't know what's meant
> by that.
> 2.) I need to execute this script and the other things on the second
> instance too, right?
> Thank you.
Migrating database from 7.0 to 2k
Hi,
I want to move a database from server A (Sql 7.0) to Server B (Sql 2000) in
the same domain.
I try exporting from A to B and work fine with the tables but it not tranfer
views.
There is any utility that i could download to migrate in a better way? If
yes, where to find it?
Thanks a lot,
Daniel Abellá
MCSE / MCT
UruguayThis is a multi-part message in MIME format.
--=_NextPart_000_0105_01C37D00.0FB3A7D0
Content-Type: text/plain;
charset="Windows-1252"
Content-Transfer-Encoding: quoted-printable
Why don't you just do just do a backup and restore? Just make sure you =transfer the logins first.
-- Tom
---
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinnaclepublishing.com/sql
"Daniel_A" <dabella@.empower.edu.uy> wrote in message =news:e$zwwCSfDHA.620@.TK2MSFTNGP11.phx.gbl...
Hi,
I want to move a database from server A (Sql 7.0) to Server B (Sql 2000) =in
the same domain.
I try exporting from A to B and work fine with the tables but it not =tranfer
views.
There is any utility that i could download to migrate in a better way? =If
yes, where to find it?
Thanks a lot,
Daniel Abell=E1
MCSE / MCT
Uruguay
--=_NextPart_000_0105_01C37D00.0FB3A7D0
Content-Type: text/html;
charset="Windows-1252"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
&
Why don't you just do just do a backup =and restore? Just make sure you transfer the logins =first.
-- Tom
---T=homas A. Moreau, BSc, PhD, MCSE, MCDBASQL Server MVPColumnist, SQL =Server ProfessionalToronto, ON Canadahttp://www.pinnaclepublishing.com/sql">www.pinnaclepublishing.com=/sql
"Daniel_A" =wrote in message news:e$zwwCSfDHA.620@.T=K2MSFTNGP11.phx.gbl...Hi,I want to move a database from server A (Sql 7.0) to Server B (Sql 2000) =inthe same domain.I try exporting from A to B and work fine with the =tables but it not tranferviews.There is any utility that i could =download to migrate in a better way? Ifyes, where to find it?Thanks a =lot,Daniel Abell=E1MCSE / =MCTUruguay
--=_NextPart_000_0105_01C37D00.0FB3A7D0--|||This is a multi-part message in MIME format.
--=_NextPart_000_00B4_01C37D38.0A7339B0
Content-Type: text/plain;
charset="Windows-1252"
Content-Transfer-Encoding: quoted-printable
Click "From Device" in Enterprise Manager, or use Query Analyzer and the =RESTORE command.
-- Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=3Ddjq&as =ugroup=3Dmicrosoft.public.sqlserver
"Daniel_A" <dabella@.empower.edu.uy> wrote in message =news:uqYjmZSfDHA.2352@.TK2MSFTNGP09.phx.gbl...
Thanks for your answer tom.
I try wat you tell me. I back up the database and then try to restore =it in sql 2000 but i dont find an option to catch the file of the =backup. I try creating a backup set with that file but it seems not to =see it because it was not created in the same server.
any idea?
"Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message =news:Oz$6dGSfDHA.1872@.TK2MSFTNGP09.phx.gbl...
Why don't you just do just do a backup and restore? Just make sure =you transfer the logins first.
-- Tom
---
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinnaclepublishing.com/sql
"Daniel_A" <dabella@.empower.edu.uy> wrote in message =news:e$zwwCSfDHA.620@.TK2MSFTNGP11.phx.gbl...
Hi,
I want to move a database from server A (Sql 7.0) to Server B (Sql =2000) in
the same domain.
I try exporting from A to B and work fine with the tables but it not =tranfer
views.
There is any utility that i could download to migrate in a better =way? If
yes, where to find it?
Thanks a lot,
Daniel Abell=E1
MCSE / MCT
Uruguay
--=_NextPart_000_00B4_01C37D38.0A7339B0
Content-Type: text/html;
charset="Windows-1252"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
&
Click "From Device" in Enterprise =Manager, or use Query Analyzer and the RESTORE command.
-- Tibor Karaszi, SQL Server MVPArchive at: http://groups.google.com/groups?oi=3Ddjq&as">http://groups.go=ogle.com/groups?oi=3Ddjq&as ugroup=3Dmicrosoft.public.sqlserver
"Daniel_A" =wrote in message news:uqYjmZSfDHA.2352=@.TK2MSFTNGP09.phx.gbl...
Thanks for your answer =tom.
I try wat you tell me. I back up the =database and then try to restore it in sql 2000 but i dont find an option to catch =the file of the backup. I try creating a backup set with that file but it seems =not to see it because it was not created in the same server.
any idea?
"Tom Moreau"= wrote in message news:Oz$6dGSfDHA.1872=@.TK2MSFTNGP09.phx.gbl...
Why don't you just do just do a =backup and restore? Just make sure you transfer the logins =first.
-- Tom
=---T=homas A. Moreau, BSc, PhD, MCSE, MCDBASQL Server MVPColumnist, SQL =Server ProfessionalToronto, ON Canadahttp://www.pinnaclepublishing.com/sql">www.pinnaclepublishing.com=/sql
"Daniel_A" =wrote in message news:e$zwwCSfDHA.620@.T=K2MSFTNGP11.phx.gbl...Hi,I want to move a database from server A (Sql 7.0) to Server B (Sql =2000) inthe same domain.I try exporting from A to B and work =fine with the tables but it not tranferviews.There is any utility =that i could download to migrate in a better way? Ifyes, where to find it?Thanks a lot,Daniel Abell=E1MCSE / MCTUruguay
--=_NextPart_000_00B4_01C37D38.0A7339B0--|||This is a multi-part message in MIME format.
--=_NextPart_000_0074_01C37D10.A58EE520
Content-Type: text/plain;
charset="Windows-1252"
Content-Transfer-Encoding: quoted-printable
Ok, i find it
But, when i try to restore it i receive error of SQL-DMO (ODBC SQLState: =42000) saying: "The backup set holds a backup of a database other than =the exsisting 'xxxx' database. RESTORE DATABASE is terminating =abnormaly.
...
"Tibor Karaszi" =<tibor.please_reply_to_public_forum.karaszi@.cornerstone.se> wrote in =message news:#IhNLdSfDHA.460@.TK2MSFTNGP12.phx.gbl...
Click "From Device" in Enterprise Manager, or use Query Analyzer and =the RESTORE command.
-- Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=3Ddjq&as =ugroup=3Dmicrosoft.public.sqlserver
"Daniel_A" <dabella@.empower.edu.uy> wrote in message =news:uqYjmZSfDHA.2352@.TK2MSFTNGP09.phx.gbl...
Thanks for your answer tom.
I try wat you tell me. I back up the database and then try to =restore it in sql 2000 but i dont find an option to catch the file of =the backup. I try creating a backup set with that file but it seems not =to see it because it was not created in the same server.
any idea?
"Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message =news:Oz$6dGSfDHA.1872@.TK2MSFTNGP09.phx.gbl...
Why don't you just do just do a backup and restore? Just make =sure you transfer the logins first.
-- Tom
---
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinnaclepublishing.com/sql
"Daniel_A" <dabella@.empower.edu.uy> wrote in message =news:e$zwwCSfDHA.620@.TK2MSFTNGP11.phx.gbl...
Hi,
I want to move a database from server A (Sql 7.0) to Server B (Sql =2000) in
the same domain.
I try exporting from A to B and work fine with the tables but it =not tranfer
views.
There is any utility that i could download to migrate in a better =way? If
yes, where to find it?
Thanks a lot,
Daniel Abell=E1
MCSE / MCT
Uruguay
--=_NextPart_000_0074_01C37D10.A58EE520
Content-Type: text/html;
charset="Windows-1252"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; =charset=3Dwindows-1252">
<META content=3D"MSHTML 6.00.2600.0" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#c0c0c0>
<DIV><FONT face=3DArial size=3D2>Ok, i find it</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>But, when i try to restore it i receive =error of SQL-DMO (ODBC SQLState: 42000) saying: "The backup set holds a backup of =a database other than the exsisting 'xxxx' database. RESTORE DATABASE is terminating abnormaly.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>...</FONT></DIV>
<BLOCKQUOTE dir=3Dltr style=3D"PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; =BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
<DIV>"Tibor Karaszi" <<A =href=3D"mailto:tibor.please_reply_to_public_forum.karaszi@.cornerstone.se"=>tibor.please_reply_to_public_forum.karaszi@.cornerstone.se</A>> wrote in message <A =href=3D"news:#IhNLdSfDHA.460@.TK2MSFTNGP12.phx.gbl">news:#IhNLdSfDHA.460@.T=K2MSFTNGP12.phx.gbl</A>...</DIV>
<DIV><FONT face=3DArial size=3D2>Click "From Device" in Enterprise =Manager, or use Query Analyzer and the RESTORE command.</FONT></DIV>
<DIV><BR>-- <BR>Tibor Karaszi, SQL Server MVP<BR>Archive at: <A =href=3D"http://groups.go=">http://groups.google.com/groups?oi=3Ddjq&as">http://groups.go=
ogle.com/groups?oi=3Ddjq&as</A> ugroup=3Dmicrosoft.public.sqlserver</DIV>
<DIV> </DIV>
<DIV> </DIV>
<BLOCKQUOTE dir=3Dltr style=3D"PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; =BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
<DIV>"Daniel_A" <<A =href=3D"mailto:dabella@.empower.edu.uy">dabella@.empower.edu.uy</A>> =wrote in message <A =href=3D"news:uqYjmZSfDHA.2352@.TK2MSFTNGP09.phx.gbl">news:uqYjmZSfDHA.2352=@.TK2MSFTNGP09.phx.gbl</A>...</DIV>
<DIV><FONT face=3DArial size=3D2>Thanks for your answer =tom.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>I try wat you tell me. I back up =the database and then try to restore it in sql 2000 but i dont find an option to =catch the file of the backup. I try creating a backup set with that file =but it seems not to see it because it was not created in the same server.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>any idea?</FONT></DIV>
<DIV> </DIV>
<BLOCKQUOTE style=3D"PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; =BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
<DIV>"Tom Moreau" <<A =href=3D"mailto:tom@.dont.spam.me.cips.ca">tom@.dont.spam.me.cips.ca</A>>= wrote in message <A =href=3D"news:Oz$6dGSfDHA.1872@.TK2MSFTNGP09.phx.gbl">news:Oz$6dGSfDHA.1872=@.TK2MSFTNGP09.phx.gbl</A>...</DIV>
<DIV><FONT face=3DTahoma size=3D2>Why don't you just do just do a =backup and restore? Just make sure you transfer the logins =first.</FONT></DIV>
<DIV><BR>-- <BR>Tom</DIV>
<DIV> </DIV>
=<DIV>---<BR>T=homas A. Moreau, BSc, PhD, MCSE, MCDBA<BR>SQL Server MVP<BR>Columnist, =SQL Server Professional<BR>Toronto, ON Canada<BR><A =href=3D"www.pinnaclepublishing.com=">http://www.pinnaclepublishing.com/sql">www.pinnaclepublishing.com=
/sql</A></DIV>
<DIV> </DIV>
<DIV> </DIV>
<DIV>"Daniel_A" <<A =href=3D"mailto:dabella@.empower.edu.uy">dabella@.empower.edu.uy</A>> =wrote in message <A =href=3D"news:e$zwwCSfDHA.620@.TK2MSFTNGP11.phx.gbl">news:e$zwwCSfDHA.620@.T=K2MSFTNGP11.phx.gbl</A>...</DIV>Hi,<BR><BR>I want to move a database from server A (Sql 7.0) to Server B (Sql =2000) in<BR>the same domain.<BR><BR>I try exporting from A to B and work =fine with the tables but it not tranfer<BR>views.<BR><BR>There is any =utility that i could download to migrate in a better way? If<BR>yes, where =to find it?<BR><BR>Thanks a lot,<BR><BR>Daniel Abell=E1<BR>MCSE / =MCT<BR>Uruguay<BR><BR></BLOCKQUOTE></BLOCKQUOTE></BLOCKQUOTE></BODY></HTM=L>
--=_NextPart_000_0074_01C37D10.A58EE520--|||This is a multi-part message in MIME format.
--=_NextPart_000_0210_01C37D0A.09F5E240
Content-Type: text/plain;
charset="Windows-1252"
Content-Transfer-Encoding: quoted-printable
You can use:
restore database MyDB
from disk =3D 'C:\temp\MyDB.bak'
with replace
-- Tom
---
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinnaclepublishing.com/sql
"Daniel_A" <dabella@.empower.edu.uy> wrote in message =news:et#fnnSfDHA.620@.TK2MSFTNGP11.phx.gbl...
Ok, i find it
But, when i try to restore it i receive error of SQL-DMO (ODBC SQLState: =42000) saying: "The backup set holds a backup of a database other than =the exsisting 'xxxx' database. RESTORE DATABASE is terminating =abnormaly.
...
"Tibor Karaszi" =<tibor.please_reply_to_public_forum.karaszi@.cornerstone.se> wrote in =message news:#IhNLdSfDHA.460@.TK2MSFTNGP12.phx.gbl...
Click "From Device" in Enterprise Manager, or use Query Analyzer and =the RESTORE command.
-- Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=3Ddjq&as =ugroup=3Dmicrosoft.public.sqlserver
"Daniel_A" <dabella@.empower.edu.uy> wrote in message =news:uqYjmZSfDHA.2352@.TK2MSFTNGP09.phx.gbl...
Thanks for your answer tom.
I try wat you tell me. I back up the database and then try to =restore it in sql 2000 but i dont find an option to catch the file of =the backup. I try creating a backup set with that file but it seems not =to see it because it was not created in the same server.
any idea?
"Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message =news:Oz$6dGSfDHA.1872@.TK2MSFTNGP09.phx.gbl...
Why don't you just do just do a backup and restore? Just make =sure you transfer the logins first.
-- Tom
---
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinnaclepublishing.com/sql
"Daniel_A" <dabella@.empower.edu.uy> wrote in message =news:e$zwwCSfDHA.620@.TK2MSFTNGP11.phx.gbl...
Hi,
I want to move a database from server A (Sql 7.0) to Server B (Sql =2000) in
the same domain.
I try exporting from A to B and work fine with the tables but it =not tranfer
views.
There is any utility that i could download to migrate in a better =way? If
yes, where to find it?
Thanks a lot,
Daniel Abell=E1
MCSE / MCT
Uruguay
--=_NextPart_000_0210_01C37D0A.09F5E240
Content-Type: text/html;
charset="Windows-1252"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; =charset=3Dwindows-1252">
<META content=3D"MSHTML 6.00.2800.1226" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#c0c0c0>
<DIV><FONT face=3DTahoma size=3D2>You can use:</FONT></DIV>
<DIV><FONT face=3DTahoma size=3D2></FONT> </DIV>
<DIV><FONT face=3D"Courier New" size=3D2>restore database =MyDB</FONT></DIV>
<DIV><FONT face=3D"Courier New" size=3D2>from disk =3D ='C:\temp\MyDB.bak'</FONT></DIV>
<DIV><FONT face=3D"Courier New" size=3D2>with replace</FONT></DIV>
<DIV><BR>-- <BR>Tom</DIV>
<DIV> </DIV>
<DIV>---<BR>T=homas A. Moreau, BSc, PhD, MCSE, MCDBA<BR>SQL Server MVP<BR>Columnist, SQL =Server Professional<BR>Toronto, ON Canada<BR><A href=3D"www.pinnaclepublishing.com=">http://www.pinnaclepublishing.com/sql">www.pinnaclepublishing.com=
/sql</A></DIV>
<DIV> </DIV>
<DIV> </DIV>
<DIV>"Daniel_A" <<A href=3D"mailto:dabella@.empower.edu.uy">dabella@.empower.edu.uy</A>> =wrote in message <A href=3D"news:et#fnnSfDHA.620@.TK2MSFTNGP11.phx.gbl">news:et#fnnSfDHA.620@.T=K2MSFTNGP11.phx.gbl</A>...</DIV>
<DIV><FONT face=3DArial size=3D2>Ok, i find it</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>But, when i try to restore it i receive =error of SQL-DMO (ODBC SQLState: 42000) saying: "The backup set holds a backup of =a database other than the exsisting 'xxxx' database. RESTORE DATABASE is terminating abnormaly.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>...</FONT></DIV>
<BLOCKQUOTE dir=3Dltr style=3D"PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; =BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
<DIV>"Tibor Karaszi" <<A =href=3D"mailto:tibor.please_reply_to_public_forum.karaszi@.cornerstone.se"=>tibor.please_reply_to_public_forum.karaszi@.cornerstone.se</A>> wrote in message <A =href=3D"news:#IhNLdSfDHA.460@.TK2MSFTNGP12.phx.gbl">news:#IhNLdSfDHA.460@.T=K2MSFTNGP12.phx.gbl</A>...</DIV>
<DIV><FONT face=3DArial size=3D2>Click "From Device" in Enterprise =Manager, or use Query Analyzer and the RESTORE command.</FONT></DIV>
<DIV><BR>-- <BR>Tibor Karaszi, SQL Server MVP<BR>Archive at: <A =href=3D"http://groups.go=">http://groups.google.com/groups?oi=3Ddjq&as">http://groups.go=
ogle.com/groups?oi=3Ddjq&as</A> ugroup=3Dmicrosoft.public.sqlserver</DIV>
<DIV> </DIV>
<DIV> </DIV>
<BLOCKQUOTE dir=3Dltr style=3D"PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; =BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
<DIV>"Daniel_A" <<A =href=3D"mailto:dabella@.empower.edu.uy">dabella@.empower.edu.uy</A>> =wrote in message <A =href=3D"news:uqYjmZSfDHA.2352@.TK2MSFTNGP09.phx.gbl">news:uqYjmZSfDHA.2352=@.TK2MSFTNGP09.phx.gbl</A>...</DIV>
<DIV><FONT face=3DArial size=3D2>Thanks for your answer =tom.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>I try wat you tell me. I back up =the database and then try to restore it in sql 2000 but i dont find an option to =catch the file of the backup. I try creating a backup set with that file =but it seems not to see it because it was not created in the same server.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>any idea?</FONT></DIV>
<DIV> </DIV>
<BLOCKQUOTE style=3D"PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; =BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
<DIV>"Tom Moreau" <<A =href=3D"mailto:tom@.dont.spam.me.cips.ca">tom@.dont.spam.me.cips.ca</A>>= wrote in message <A =href=3D"news:Oz$6dGSfDHA.1872@.TK2MSFTNGP09.phx.gbl">news:Oz$6dGSfDHA.1872=@.TK2MSFTNGP09.phx.gbl</A>...</DIV>
<DIV><FONT face=3DTahoma size=3D2>Why don't you just do just do a =backup and restore? Just make sure you transfer the logins =first.</FONT></DIV>
<DIV><BR>-- <BR>Tom</DIV>
<DIV> </DIV>
=<DIV>---<BR>T=homas A. Moreau, BSc, PhD, MCSE, MCDBA<BR>SQL Server MVP<BR>Columnist, =SQL Server Professional<BR>Toronto, ON Canada<BR><A =href=3D"www.pinnaclepublishing.com=">http://www.pinnaclepublishing.com/sql">www.pinnaclepublishing.com=
/sql</A></DIV>
<DIV> </DIV>
<DIV> </DIV>
<DIV>"Daniel_A" <<A =href=3D"mailto:dabella@.empower.edu.uy">dabella@.empower.edu.uy</A>> =wrote in message <A =href=3D"news:e$zwwCSfDHA.620@.TK2MSFTNGP11.phx.gbl">news:e$zwwCSfDHA.620@.T=K2MSFTNGP11.phx.gbl</A>...</DIV>Hi,<BR><BR>I want to move a database from server A (Sql 7.0) to Server B (Sql =2000) in<BR>the same domain.<BR><BR>I try exporting from A to B and work =fine with the tables but it not tranfer<BR>views.<BR><BR>There is any =utility that i could download to migrate in a better way? If<BR>yes, where =to find it?<BR><BR>Thanks a lot,<BR><BR>Daniel Abell=E1<BR>MCSE / =MCT<BR>Uruguay<BR><BR></BLOCKQUOTE></BLOCKQUOTE></BLOCKQUOTE></BODY></HTM=L>
--=_NextPart_000_0210_01C37D0A.09F5E240--
I want to move a database from server A (Sql 7.0) to Server B (Sql 2000) in
the same domain.
I try exporting from A to B and work fine with the tables but it not tranfer
views.
There is any utility that i could download to migrate in a better way? If
yes, where to find it?
Thanks a lot,
Daniel Abellá
MCSE / MCT
UruguayThis is a multi-part message in MIME format.
--=_NextPart_000_0105_01C37D00.0FB3A7D0
Content-Type: text/plain;
charset="Windows-1252"
Content-Transfer-Encoding: quoted-printable
Why don't you just do just do a backup and restore? Just make sure you =transfer the logins first.
-- Tom
---
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinnaclepublishing.com/sql
"Daniel_A" <dabella@.empower.edu.uy> wrote in message =news:e$zwwCSfDHA.620@.TK2MSFTNGP11.phx.gbl...
Hi,
I want to move a database from server A (Sql 7.0) to Server B (Sql 2000) =in
the same domain.
I try exporting from A to B and work fine with the tables but it not =tranfer
views.
There is any utility that i could download to migrate in a better way? =If
yes, where to find it?
Thanks a lot,
Daniel Abell=E1
MCSE / MCT
Uruguay
--=_NextPart_000_0105_01C37D00.0FB3A7D0
Content-Type: text/html;
charset="Windows-1252"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
&
Why don't you just do just do a backup =and restore? Just make sure you transfer the logins =first.
-- Tom
---T=homas A. Moreau, BSc, PhD, MCSE, MCDBASQL Server MVPColumnist, SQL =Server ProfessionalToronto, ON Canadahttp://www.pinnaclepublishing.com/sql">www.pinnaclepublishing.com=/sql
"Daniel_A"
--=_NextPart_000_0105_01C37D00.0FB3A7D0--|||This is a multi-part message in MIME format.
--=_NextPart_000_00B4_01C37D38.0A7339B0
Content-Type: text/plain;
charset="Windows-1252"
Content-Transfer-Encoding: quoted-printable
Click "From Device" in Enterprise Manager, or use Query Analyzer and the =RESTORE command.
-- Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=3Ddjq&as =ugroup=3Dmicrosoft.public.sqlserver
"Daniel_A" <dabella@.empower.edu.uy> wrote in message =news:uqYjmZSfDHA.2352@.TK2MSFTNGP09.phx.gbl...
Thanks for your answer tom.
I try wat you tell me. I back up the database and then try to restore =it in sql 2000 but i dont find an option to catch the file of the =backup. I try creating a backup set with that file but it seems not to =see it because it was not created in the same server.
any idea?
"Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message =news:Oz$6dGSfDHA.1872@.TK2MSFTNGP09.phx.gbl...
Why don't you just do just do a backup and restore? Just make sure =you transfer the logins first.
-- Tom
---
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinnaclepublishing.com/sql
"Daniel_A" <dabella@.empower.edu.uy> wrote in message =news:e$zwwCSfDHA.620@.TK2MSFTNGP11.phx.gbl...
Hi,
I want to move a database from server A (Sql 7.0) to Server B (Sql =2000) in
the same domain.
I try exporting from A to B and work fine with the tables but it not =tranfer
views.
There is any utility that i could download to migrate in a better =way? If
yes, where to find it?
Thanks a lot,
Daniel Abell=E1
MCSE / MCT
Uruguay
--=_NextPart_000_00B4_01C37D38.0A7339B0
Content-Type: text/html;
charset="Windows-1252"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
&
Click "From Device" in Enterprise =Manager, or use Query Analyzer and the RESTORE command.
-- Tibor Karaszi, SQL Server MVPArchive at: http://groups.google.com/groups?oi=3Ddjq&as">http://groups.go=ogle.com/groups?oi=3Ddjq&as ugroup=3Dmicrosoft.public.sqlserver
"Daniel_A"
Thanks for your answer =tom.
I try wat you tell me. I back up the =database and then try to restore it in sql 2000 but i dont find an option to catch =the file of the backup. I try creating a backup set with that file but it seems =not to see it because it was not created in the same server.
any idea?
"Tom Moreau"
Why don't you just do just do a =backup and restore? Just make sure you transfer the logins =first.
-- Tom
=---T=homas A. Moreau, BSc, PhD, MCSE, MCDBASQL Server MVPColumnist, SQL =Server ProfessionalToronto, ON Canadahttp://www.pinnaclepublishing.com/sql">www.pinnaclepublishing.com=/sql
"Daniel_A"
--=_NextPart_000_00B4_01C37D38.0A7339B0--|||This is a multi-part message in MIME format.
--=_NextPart_000_0074_01C37D10.A58EE520
Content-Type: text/plain;
charset="Windows-1252"
Content-Transfer-Encoding: quoted-printable
Ok, i find it
But, when i try to restore it i receive error of SQL-DMO (ODBC SQLState: =42000) saying: "The backup set holds a backup of a database other than =the exsisting 'xxxx' database. RESTORE DATABASE is terminating =abnormaly.
...
"Tibor Karaszi" =<tibor.please_reply_to_public_forum.karaszi@.cornerstone.se> wrote in =message news:#IhNLdSfDHA.460@.TK2MSFTNGP12.phx.gbl...
Click "From Device" in Enterprise Manager, or use Query Analyzer and =the RESTORE command.
-- Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=3Ddjq&as =ugroup=3Dmicrosoft.public.sqlserver
"Daniel_A" <dabella@.empower.edu.uy> wrote in message =news:uqYjmZSfDHA.2352@.TK2MSFTNGP09.phx.gbl...
Thanks for your answer tom.
I try wat you tell me. I back up the database and then try to =restore it in sql 2000 but i dont find an option to catch the file of =the backup. I try creating a backup set with that file but it seems not =to see it because it was not created in the same server.
any idea?
"Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message =news:Oz$6dGSfDHA.1872@.TK2MSFTNGP09.phx.gbl...
Why don't you just do just do a backup and restore? Just make =sure you transfer the logins first.
-- Tom
---
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinnaclepublishing.com/sql
"Daniel_A" <dabella@.empower.edu.uy> wrote in message =news:e$zwwCSfDHA.620@.TK2MSFTNGP11.phx.gbl...
Hi,
I want to move a database from server A (Sql 7.0) to Server B (Sql =2000) in
the same domain.
I try exporting from A to B and work fine with the tables but it =not tranfer
views.
There is any utility that i could download to migrate in a better =way? If
yes, where to find it?
Thanks a lot,
Daniel Abell=E1
MCSE / MCT
Uruguay
--=_NextPart_000_0074_01C37D10.A58EE520
Content-Type: text/html;
charset="Windows-1252"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; =charset=3Dwindows-1252">
<META content=3D"MSHTML 6.00.2600.0" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#c0c0c0>
<DIV><FONT face=3DArial size=3D2>Ok, i find it</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>But, when i try to restore it i receive =error of SQL-DMO (ODBC SQLState: 42000) saying: "The backup set holds a backup of =a database other than the exsisting 'xxxx' database. RESTORE DATABASE is terminating abnormaly.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>...</FONT></DIV>
<BLOCKQUOTE dir=3Dltr style=3D"PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; =BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
<DIV>"Tibor Karaszi" <<A =href=3D"mailto:tibor.please_reply_to_public_forum.karaszi@.cornerstone.se"=>tibor.please_reply_to_public_forum.karaszi@.cornerstone.se</A>> wrote in message <A =href=3D"news:#IhNLdSfDHA.460@.TK2MSFTNGP12.phx.gbl">news:#IhNLdSfDHA.460@.T=K2MSFTNGP12.phx.gbl</A>...</DIV>
<DIV><FONT face=3DArial size=3D2>Click "From Device" in Enterprise =Manager, or use Query Analyzer and the RESTORE command.</FONT></DIV>
<DIV><BR>-- <BR>Tibor Karaszi, SQL Server MVP<BR>Archive at: <A =href=3D"http://groups.go=">http://groups.google.com/groups?oi=3Ddjq&as">http://groups.go=
ogle.com/groups?oi=3Ddjq&as</A> ugroup=3Dmicrosoft.public.sqlserver</DIV>
<DIV> </DIV>
<DIV> </DIV>
<BLOCKQUOTE dir=3Dltr style=3D"PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; =BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
<DIV>"Daniel_A" <<A =href=3D"mailto:dabella@.empower.edu.uy">dabella@.empower.edu.uy</A>> =wrote in message <A =href=3D"news:uqYjmZSfDHA.2352@.TK2MSFTNGP09.phx.gbl">news:uqYjmZSfDHA.2352=@.TK2MSFTNGP09.phx.gbl</A>...</DIV>
<DIV><FONT face=3DArial size=3D2>Thanks for your answer =tom.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>I try wat you tell me. I back up =the database and then try to restore it in sql 2000 but i dont find an option to =catch the file of the backup. I try creating a backup set with that file =but it seems not to see it because it was not created in the same server.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>any idea?</FONT></DIV>
<DIV> </DIV>
<BLOCKQUOTE style=3D"PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; =BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
<DIV>"Tom Moreau" <<A =href=3D"mailto:tom@.dont.spam.me.cips.ca">tom@.dont.spam.me.cips.ca</A>>= wrote in message <A =href=3D"news:Oz$6dGSfDHA.1872@.TK2MSFTNGP09.phx.gbl">news:Oz$6dGSfDHA.1872=@.TK2MSFTNGP09.phx.gbl</A>...</DIV>
<DIV><FONT face=3DTahoma size=3D2>Why don't you just do just do a =backup and restore? Just make sure you transfer the logins =first.</FONT></DIV>
<DIV><BR>-- <BR>Tom</DIV>
<DIV> </DIV>
=<DIV>---<BR>T=homas A. Moreau, BSc, PhD, MCSE, MCDBA<BR>SQL Server MVP<BR>Columnist, =SQL Server Professional<BR>Toronto, ON Canada<BR><A =href=3D"www.pinnaclepublishing.com=">http://www.pinnaclepublishing.com/sql">www.pinnaclepublishing.com=
/sql</A></DIV>
<DIV> </DIV>
<DIV> </DIV>
<DIV>"Daniel_A" <<A =href=3D"mailto:dabella@.empower.edu.uy">dabella@.empower.edu.uy</A>> =wrote in message <A =href=3D"news:e$zwwCSfDHA.620@.TK2MSFTNGP11.phx.gbl">news:e$zwwCSfDHA.620@.T=K2MSFTNGP11.phx.gbl</A>...</DIV>Hi,<BR><BR>I want to move a database from server A (Sql 7.0) to Server B (Sql =2000) in<BR>the same domain.<BR><BR>I try exporting from A to B and work =fine with the tables but it not tranfer<BR>views.<BR><BR>There is any =utility that i could download to migrate in a better way? If<BR>yes, where =to find it?<BR><BR>Thanks a lot,<BR><BR>Daniel Abell=E1<BR>MCSE / =MCT<BR>Uruguay<BR><BR></BLOCKQUOTE></BLOCKQUOTE></BLOCKQUOTE></BODY></HTM=L>
--=_NextPart_000_0074_01C37D10.A58EE520--|||This is a multi-part message in MIME format.
--=_NextPart_000_0210_01C37D0A.09F5E240
Content-Type: text/plain;
charset="Windows-1252"
Content-Transfer-Encoding: quoted-printable
You can use:
restore database MyDB
from disk =3D 'C:\temp\MyDB.bak'
with replace
-- Tom
---
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinnaclepublishing.com/sql
"Daniel_A" <dabella@.empower.edu.uy> wrote in message =news:et#fnnSfDHA.620@.TK2MSFTNGP11.phx.gbl...
Ok, i find it
But, when i try to restore it i receive error of SQL-DMO (ODBC SQLState: =42000) saying: "The backup set holds a backup of a database other than =the exsisting 'xxxx' database. RESTORE DATABASE is terminating =abnormaly.
...
"Tibor Karaszi" =<tibor.please_reply_to_public_forum.karaszi@.cornerstone.se> wrote in =message news:#IhNLdSfDHA.460@.TK2MSFTNGP12.phx.gbl...
Click "From Device" in Enterprise Manager, or use Query Analyzer and =the RESTORE command.
-- Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=3Ddjq&as =ugroup=3Dmicrosoft.public.sqlserver
"Daniel_A" <dabella@.empower.edu.uy> wrote in message =news:uqYjmZSfDHA.2352@.TK2MSFTNGP09.phx.gbl...
Thanks for your answer tom.
I try wat you tell me. I back up the database and then try to =restore it in sql 2000 but i dont find an option to catch the file of =the backup. I try creating a backup set with that file but it seems not =to see it because it was not created in the same server.
any idea?
"Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message =news:Oz$6dGSfDHA.1872@.TK2MSFTNGP09.phx.gbl...
Why don't you just do just do a backup and restore? Just make =sure you transfer the logins first.
-- Tom
---
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinnaclepublishing.com/sql
"Daniel_A" <dabella@.empower.edu.uy> wrote in message =news:e$zwwCSfDHA.620@.TK2MSFTNGP11.phx.gbl...
Hi,
I want to move a database from server A (Sql 7.0) to Server B (Sql =2000) in
the same domain.
I try exporting from A to B and work fine with the tables but it =not tranfer
views.
There is any utility that i could download to migrate in a better =way? If
yes, where to find it?
Thanks a lot,
Daniel Abell=E1
MCSE / MCT
Uruguay
--=_NextPart_000_0210_01C37D0A.09F5E240
Content-Type: text/html;
charset="Windows-1252"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; =charset=3Dwindows-1252">
<META content=3D"MSHTML 6.00.2800.1226" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#c0c0c0>
<DIV><FONT face=3DTahoma size=3D2>You can use:</FONT></DIV>
<DIV><FONT face=3DTahoma size=3D2></FONT> </DIV>
<DIV><FONT face=3D"Courier New" size=3D2>restore database =MyDB</FONT></DIV>
<DIV><FONT face=3D"Courier New" size=3D2>from disk =3D ='C:\temp\MyDB.bak'</FONT></DIV>
<DIV><FONT face=3D"Courier New" size=3D2>with replace</FONT></DIV>
<DIV><BR>-- <BR>Tom</DIV>
<DIV> </DIV>
<DIV>---<BR>T=homas A. Moreau, BSc, PhD, MCSE, MCDBA<BR>SQL Server MVP<BR>Columnist, SQL =Server Professional<BR>Toronto, ON Canada<BR><A href=3D"www.pinnaclepublishing.com=">http://www.pinnaclepublishing.com/sql">www.pinnaclepublishing.com=
/sql</A></DIV>
<DIV> </DIV>
<DIV> </DIV>
<DIV>"Daniel_A" <<A href=3D"mailto:dabella@.empower.edu.uy">dabella@.empower.edu.uy</A>> =wrote in message <A href=3D"news:et#fnnSfDHA.620@.TK2MSFTNGP11.phx.gbl">news:et#fnnSfDHA.620@.T=K2MSFTNGP11.phx.gbl</A>...</DIV>
<DIV><FONT face=3DArial size=3D2>Ok, i find it</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>But, when i try to restore it i receive =error of SQL-DMO (ODBC SQLState: 42000) saying: "The backup set holds a backup of =a database other than the exsisting 'xxxx' database. RESTORE DATABASE is terminating abnormaly.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>...</FONT></DIV>
<BLOCKQUOTE dir=3Dltr style=3D"PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; =BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
<DIV>"Tibor Karaszi" <<A =href=3D"mailto:tibor.please_reply_to_public_forum.karaszi@.cornerstone.se"=>tibor.please_reply_to_public_forum.karaszi@.cornerstone.se</A>> wrote in message <A =href=3D"news:#IhNLdSfDHA.460@.TK2MSFTNGP12.phx.gbl">news:#IhNLdSfDHA.460@.T=K2MSFTNGP12.phx.gbl</A>...</DIV>
<DIV><FONT face=3DArial size=3D2>Click "From Device" in Enterprise =Manager, or use Query Analyzer and the RESTORE command.</FONT></DIV>
<DIV><BR>-- <BR>Tibor Karaszi, SQL Server MVP<BR>Archive at: <A =href=3D"http://groups.go=">http://groups.google.com/groups?oi=3Ddjq&as">http://groups.go=
ogle.com/groups?oi=3Ddjq&as</A> ugroup=3Dmicrosoft.public.sqlserver</DIV>
<DIV> </DIV>
<DIV> </DIV>
<BLOCKQUOTE dir=3Dltr style=3D"PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; =BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
<DIV>"Daniel_A" <<A =href=3D"mailto:dabella@.empower.edu.uy">dabella@.empower.edu.uy</A>> =wrote in message <A =href=3D"news:uqYjmZSfDHA.2352@.TK2MSFTNGP09.phx.gbl">news:uqYjmZSfDHA.2352=@.TK2MSFTNGP09.phx.gbl</A>...</DIV>
<DIV><FONT face=3DArial size=3D2>Thanks for your answer =tom.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>I try wat you tell me. I back up =the database and then try to restore it in sql 2000 but i dont find an option to =catch the file of the backup. I try creating a backup set with that file =but it seems not to see it because it was not created in the same server.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>any idea?</FONT></DIV>
<DIV> </DIV>
<BLOCKQUOTE style=3D"PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; =BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
<DIV>"Tom Moreau" <<A =href=3D"mailto:tom@.dont.spam.me.cips.ca">tom@.dont.spam.me.cips.ca</A>>= wrote in message <A =href=3D"news:Oz$6dGSfDHA.1872@.TK2MSFTNGP09.phx.gbl">news:Oz$6dGSfDHA.1872=@.TK2MSFTNGP09.phx.gbl</A>...</DIV>
<DIV><FONT face=3DTahoma size=3D2>Why don't you just do just do a =backup and restore? Just make sure you transfer the logins =first.</FONT></DIV>
<DIV><BR>-- <BR>Tom</DIV>
<DIV> </DIV>
=<DIV>---<BR>T=homas A. Moreau, BSc, PhD, MCSE, MCDBA<BR>SQL Server MVP<BR>Columnist, =SQL Server Professional<BR>Toronto, ON Canada<BR><A =href=3D"www.pinnaclepublishing.com=">http://www.pinnaclepublishing.com/sql">www.pinnaclepublishing.com=
/sql</A></DIV>
<DIV> </DIV>
<DIV> </DIV>
<DIV>"Daniel_A" <<A =href=3D"mailto:dabella@.empower.edu.uy">dabella@.empower.edu.uy</A>> =wrote in message <A =href=3D"news:e$zwwCSfDHA.620@.TK2MSFTNGP11.phx.gbl">news:e$zwwCSfDHA.620@.T=K2MSFTNGP11.phx.gbl</A>...</DIV>Hi,<BR><BR>I want to move a database from server A (Sql 7.0) to Server B (Sql =2000) in<BR>the same domain.<BR><BR>I try exporting from A to B and work =fine with the tables but it not tranfer<BR>views.<BR><BR>There is any =utility that i could download to migrate in a better way? If<BR>yes, where =to find it?<BR><BR>Thanks a lot,<BR><BR>Daniel Abell=E1<BR>MCSE / =MCT<BR>Uruguay<BR><BR></BLOCKQUOTE></BLOCKQUOTE></BLOCKQUOTE></BODY></HTM=L>
--=_NextPart_000_0210_01C37D0A.09F5E240--
Monday, March 26, 2012
Migrating a database
We have a database running under SQL Server 7 on a Win NT server. We
have recently added Win2K servers, created a new domain and installed
SQL Server 7 on one of the servers. I would like to be able to log into
either domain from a workstation, use Enterprise Manager to access
either database and use the migration tools to copy the database from
the NT server to the 2K server.
We have created a trust relationship that allows me to log into either
domain, but when I try to use Enterprise Manager to create a
registration to the database on the other domain, or try to use the
migration tool to copy the database, I get an error saying that my user
account cannot log into the other system. ( I have the same user name
and password on both domains and domain admin privileges).
Can this be done directly? How?
Do I need "linked servers"? -- It doesn't like my account to create this
either.
Do I need a "remote server"?
Reading the documentation creates more questions than answers. I would
appreciate someone pointing me in the right direction. ThanksWhat is the exact error you are seeing and which domain are you logging
into, the new one or the other one.
Rand
This posting is provided "as is" with no warranties and confers no rights.|||When I'm logged into the NT domain and trying to register SQL Server on the 2K
server, I get "login failed for user 'patenaude'".
When I'm logged into the 2K domain and trying to register SQL server on the NT
server, I get " loged failed for user 'null'. Not associated with a trusted
SQL Server connection."
I get similar messages trying to set up a linked server.
"Rand Boyd [MS]" wrote:
> What is the exact error you are seeing and which domain are you logging
> into, the new one or the other one.
> Rand
> This posting is provided "as is" with no warranties and confers no rights.|||When you are logged into the Windows NT domain are you trying to register
the SQL Server using NT or SQL authentication. The error indicates SQL
authentication. If so does the 'patenaude' SQL login exist? Is the password
correct?
When you are logging into the Win 2K domain, the error indicates that you
cannot be validated on the domain controller. That is where the null is
coming from. Check the security log of the domain controller for this
domain for errors related to this account. Also if you are logged on to the
workstation using a local account you will see this error.
Rand
This posting is provided "as is" with no warranties and confers no rights.|||I changed the system on the 2K server to use NT authentication, so now I get
the same error message about my user account not being valid. (The user id is
good, the password is good.) My workstation is a member of the NT domain and
the trust relationship is set up to the point where I can log into either
domain. The user name is the same on both domains. I have tried registering
across the domain from both directions, using the default log-in with NT
authentication, using the specific login with my user name and using the
specific log-in with each of the domains added ( NTdomain\user & 2Kdomain\user)
I get the same results each time. I looked in the event logs on the servers and
there is no mention of the attempt in any of the logs.
"Rand Boyd [MS]" wrote:
> When you are logged into the Windows NT domain are you trying to register
> the SQL Server using NT or SQL authentication. The error indicates SQL
> authentication. If so does the 'patenaude' SQL login exist? Is the password
> correct?
> When you are logging into the Win 2K domain, the error indicates that you
> cannot be validated on the domain controller. That is where the null is
> coming from. Check the security log of the domain controller for this
> domain for errors related to this account. Also if you are logged on to the
> workstation using a local account you will see this error.
> Rand
> This posting is provided "as is" with no warranties and confers no rights.
have recently added Win2K servers, created a new domain and installed
SQL Server 7 on one of the servers. I would like to be able to log into
either domain from a workstation, use Enterprise Manager to access
either database and use the migration tools to copy the database from
the NT server to the 2K server.
We have created a trust relationship that allows me to log into either
domain, but when I try to use Enterprise Manager to create a
registration to the database on the other domain, or try to use the
migration tool to copy the database, I get an error saying that my user
account cannot log into the other system. ( I have the same user name
and password on both domains and domain admin privileges).
Can this be done directly? How?
Do I need "linked servers"? -- It doesn't like my account to create this
either.
Do I need a "remote server"?
Reading the documentation creates more questions than answers. I would
appreciate someone pointing me in the right direction. ThanksWhat is the exact error you are seeing and which domain are you logging
into, the new one or the other one.
Rand
This posting is provided "as is" with no warranties and confers no rights.|||When I'm logged into the NT domain and trying to register SQL Server on the 2K
server, I get "login failed for user 'patenaude'".
When I'm logged into the 2K domain and trying to register SQL server on the NT
server, I get " loged failed for user 'null'. Not associated with a trusted
SQL Server connection."
I get similar messages trying to set up a linked server.
"Rand Boyd [MS]" wrote:
> What is the exact error you are seeing and which domain are you logging
> into, the new one or the other one.
> Rand
> This posting is provided "as is" with no warranties and confers no rights.|||When you are logged into the Windows NT domain are you trying to register
the SQL Server using NT or SQL authentication. The error indicates SQL
authentication. If so does the 'patenaude' SQL login exist? Is the password
correct?
When you are logging into the Win 2K domain, the error indicates that you
cannot be validated on the domain controller. That is where the null is
coming from. Check the security log of the domain controller for this
domain for errors related to this account. Also if you are logged on to the
workstation using a local account you will see this error.
Rand
This posting is provided "as is" with no warranties and confers no rights.|||I changed the system on the 2K server to use NT authentication, so now I get
the same error message about my user account not being valid. (The user id is
good, the password is good.) My workstation is a member of the NT domain and
the trust relationship is set up to the point where I can log into either
domain. The user name is the same on both domains. I have tried registering
across the domain from both directions, using the default log-in with NT
authentication, using the specific login with my user name and using the
specific log-in with each of the domains added ( NTdomain\user & 2Kdomain\user)
I get the same results each time. I looked in the event logs on the servers and
there is no mention of the attempt in any of the logs.
"Rand Boyd [MS]" wrote:
> When you are logged into the Windows NT domain are you trying to register
> the SQL Server using NT or SQL authentication. The error indicates SQL
> authentication. If so does the 'patenaude' SQL login exist? Is the password
> correct?
> When you are logging into the Win 2K domain, the error indicates that you
> cannot be validated on the domain controller. That is where the null is
> coming from. Check the security log of the domain controller for this
> domain for errors related to this account. Also if you are logged on to the
> workstation using a local account you will see this error.
> Rand
> This posting is provided "as is" with no warranties and confers no rights.
Friday, March 23, 2012
Migrate to New Domain
I migrated my SQL 7 server running on Win 2K Server from
the existing domain to a new domain using the Active
Directory Migration tool but now SQL won't start and I
cannot get it to start whether I log on to the old or new
domains. Does anyone have an insight?Wht error do yo get? I guess SQL Server service can't logo to Windows
domain. Check te username and password SQL Server service is using.
Dejan Sarka, SQL Server MVP
Associate Mentor
Solid Quality Learning
More than just Training
www.SolidQualityLearning.com
"Kevin" <anonymous@.discussions.microsoft.com> wrote in message
news:54af01c42cdd$7a56a5f0$a101280a@.phx.gbl...
> I migrated my SQL 7 server running on Win 2K Server from
> the existing domain to a new domain using the Active
> Directory Migration tool but now SQL won't start and I
> cannot get it to start whether I log on to the old or new
> domains. Does anyone have an insight?
the existing domain to a new domain using the Active
Directory Migration tool but now SQL won't start and I
cannot get it to start whether I log on to the old or new
domains. Does anyone have an insight?Wht error do yo get? I guess SQL Server service can't logo to Windows
domain. Check te username and password SQL Server service is using.
Dejan Sarka, SQL Server MVP
Associate Mentor
Solid Quality Learning
More than just Training
www.SolidQualityLearning.com
"Kevin" <anonymous@.discussions.microsoft.com> wrote in message
news:54af01c42cdd$7a56a5f0$a101280a@.phx.gbl...
> I migrated my SQL 7 server running on Win 2K Server from
> the existing domain to a new domain using the Active
> Directory Migration tool but now SQL won't start and I
> cannot get it to start whether I log on to the old or new
> domains. Does anyone have an insight?
Migrate to New Domain
I migrated my SQL 7 server running on Win 2K Server from
the existing domain to a new domain using the Active
Directory Migration tool but now SQL won't start and I
cannot get it to start whether I log on to the old or new
domains. Does anyone have an insight?
Wht error do yo get? I guess SQL Server service can't logo to Windows
domain. Check te username and password SQL Server service is using.
Dejan Sarka, SQL Server MVP
Associate Mentor
Solid Quality Learning
More than just Training
www.SolidQualityLearning.com
"Kevin" <anonymous@.discussions.microsoft.com> wrote in message
news:54af01c42cdd$7a56a5f0$a101280a@.phx.gbl...
> I migrated my SQL 7 server running on Win 2K Server from
> the existing domain to a new domain using the Active
> Directory Migration tool but now SQL won't start and I
> cannot get it to start whether I log on to the old or new
> domains. Does anyone have an insight?
sql
the existing domain to a new domain using the Active
Directory Migration tool but now SQL won't start and I
cannot get it to start whether I log on to the old or new
domains. Does anyone have an insight?
Wht error do yo get? I guess SQL Server service can't logo to Windows
domain. Check te username and password SQL Server service is using.
Dejan Sarka, SQL Server MVP
Associate Mentor
Solid Quality Learning
More than just Training
www.SolidQualityLearning.com
"Kevin" <anonymous@.discussions.microsoft.com> wrote in message
news:54af01c42cdd$7a56a5f0$a101280a@.phx.gbl...
> I migrated my SQL 7 server running on Win 2K Server from
> the existing domain to a new domain using the Active
> Directory Migration tool but now SQL won't start and I
> cannot get it to start whether I log on to the old or new
> domains. Does anyone have an insight?
sql
Migrate to New Domain
I migrated my SQL 7 server running on Win 2K Server from
the existing domain to a new domain using the Active
Directory Migration tool but now SQL won't start and I
cannot get it to start whether I log on to the old or new
domains. Does anyone have an insight?Wht error do yo get? I guess SQL Server service can't logo to Windows
domain. Check te username and password SQL Server service is using.
--
Dejan Sarka, SQL Server MVP
Associate Mentor
Solid Quality Learning
More than just Training
www.SolidQualityLearning.com
"Kevin" <anonymous@.discussions.microsoft.com> wrote in message
news:54af01c42cdd$7a56a5f0$a101280a@.phx.gbl...
> I migrated my SQL 7 server running on Win 2K Server from
> the existing domain to a new domain using the Active
> Directory Migration tool but now SQL won't start and I
> cannot get it to start whether I log on to the old or new
> domains. Does anyone have an insight?
the existing domain to a new domain using the Active
Directory Migration tool but now SQL won't start and I
cannot get it to start whether I log on to the old or new
domains. Does anyone have an insight?Wht error do yo get? I guess SQL Server service can't logo to Windows
domain. Check te username and password SQL Server service is using.
--
Dejan Sarka, SQL Server MVP
Associate Mentor
Solid Quality Learning
More than just Training
www.SolidQualityLearning.com
"Kevin" <anonymous@.discussions.microsoft.com> wrote in message
news:54af01c42cdd$7a56a5f0$a101280a@.phx.gbl...
> I migrated my SQL 7 server running on Win 2K Server from
> the existing domain to a new domain using the Active
> Directory Migration tool but now SQL won't start and I
> cannot get it to start whether I log on to the old or new
> domains. Does anyone have an insight?
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
>
>.
>
Subscribe to:
Posts (Atom)