Migrating from Access to SQL Server

I recently migrated some user tables from Access to SQL Server while leaving
the forms, reports, and queries in Access with Linked tables to the SQL
instance. Some of the users queries/forms are not working correctly? It
seems that Access Queries return a single empty row when no matches are foun
d
while SQL Server returns an empty result set. In Access, the users use a
query to search for a customer number, if no matching number is found the
customer form is displayed with one record containing no values and the user
s
can then input new customer information. When the query/form is pointed to
SQL Server, when no matching customer is found a blank page is displayed. I
s
there a way to force SQL Server to return an empty row if none are found?Hi,
probably the attached script would help to you (I'm not sure how to
implement it within Access enviroment):
create table t (col1 int null, col2 varchar(10) null)
--without variables
select col1,col2 from t
union all
select null, null
--with variables
declare @.r as int
select * from t
set @.r=@.@.rowcount
if @.r>0
return
else
select null as col1, null as col2
drop table t
Denis
"DT" wrote:

> I recently migrated some user tables from Access to SQL Server while leavi
ng
> the forms, reports, and queries in Access with Linked tables to the SQL
> instance. Some of the users queries/forms are not working correctly? It
> seems that Access Queries return a single empty row when no matches are fo
und
> while SQL Server returns an empty result set. In Access, the users use a
> query to search for a customer number, if no matching number is found the
> customer form is displayed with one record containing no values and the us
ers
> can then input new customer information. When the query/form is pointed t
o
> SQL Server, when no matching customer is found a blank page is displayed.
Is
> there a way to force SQL Server to return an empty row if none are found?
>|||Although your solution does cause the form to be displayed (progress!) I can
not enter data on the form? Am I missing something?
"Denis" wrote:
> Hi,
> probably the attached script would help to you (I'm not sure how to
> implement it within Access enviroment):
> create table t (col1 int null, col2 varchar(10) null)
> --without variables
> select col1,col2 from t
> union all
> select null, null
> --with variables
> declare @.r as int
> select * from t
> set @.r=@.@.rowcount
> if @.r>0
> return
> else
> select null as col1, null as col2
>
> drop table t
> Denis
> "DT" wrote:
>|||There is no such thing as an "empty" row in SQL Server. The functionality
you are wanting would probably be a property of the recordset or data grid.
"DT" <DT@.discussions.microsoft.com> wrote in message
news:0D425E66-49D7-4C46-97E2-7813DB70A6D0@.microsoft.com...
>I recently migrated some user tables from Access to SQL Server while
>leaving
> the forms, reports, and queries in Access with Linked tables to the SQL
> instance. Some of the users queries/forms are not working correctly? It
> seems that Access Queries return a single empty row when no matches are
> found
> while SQL Server returns an empty result set. In Access, the users use a
> query to search for a customer number, if no matching number is found the
> customer form is displayed with one record containing no values and the
> users
> can then input new customer information. When the query/form is pointed
> to
> SQL Server, when no matching customer is found a blank page is displayed.
> Is
> there a way to force SQL Server to return an empty row if none are found?
>

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/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.

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

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.

migrate users

How can I script out existing SQL users from a user database on Production s
erver to the same user databse migrated to Test server ? (Both srv are on w2
k, sql2000)
When I migrate the user database to Test server, I accidentally deleted all
the SQL users for that database on the Test server.
I hve looked at these KB, but not sure if the "logins transfer" will removed
the existing logins or any impact on the Production server,
http://support.microsoft.com/default.aspx?kbid=298897
http://support.microsoft.com/default.aspx?kbid=246133
http://support.microsoft.com/default.aspx?kbid=240872
pls helpHi,
You can script the users and associated roles for that user using the SQL
Server ENterprise manager "Generate SQL script"
1. Open Enterprise manager and connect to the SQL server where your actual
database resides.
2. Expand the datbases and select the database.
3. Right click above the database and choose All tasks and select "Generate
SQL Scripts"
4. Go to Options tab in the new window displayed
5. Check the option "Script database users and database roles"
6. Go back to "General Tab"
7. CLick Preview.. This will display you the database users and roles
assigned
8. copy the script and paste in to a notepad
9. Login to TEST SQL servers Query analyzer using 'SA'
10. Go to the database you have dropped the users
11. copy the notepad contents and paste it in Query analyzer
12. Execute the script... Ensure that you are in correct database.
This will create all the users back with correct previlages.
FYI, I have never tested this steps before.
Thanks
Hari
MCDBA
"pk" <pk@.discussions.microsoft.com> wrote in message
news:AB82B609-55E7-4D10-9344-4ACC87721FA6@.microsoft.com...
> How can I script out existing SQL users from a user database on Production
server to the same user databse migrated to Test server ? (Both srv are on
w2k, sql2000)
> When I migrate the user database to Test server, I accidentally deleted
all the SQL users for that database on the Test server.
> I hve looked at these KB, but not sure if the "logins transfer" will
removed the existing logins or any impact on the Production server,
> http://support.microsoft.com/default.aspx?kbid=298897
> http://support.microsoft.com/default.aspx?kbid=246133
> http://support.microsoft.com/default.aspx?kbid=240872
>
> pls help

migrate users

How can I script out existing SQL users from a user database on Production server to the same user databse migrated to Test server ? (Both srv are on w2k, sql2000)
When I migrate the user database to Test server, I accidentally deleted all the SQL users for that database on the Test server.
I hve looked at these KB, but not sure if the "logins transfer" will removed the existing logins or any impact on the Production server,
http://support.microsoft.com/default.aspx?kbid=298897
http://support.microsoft.com/default.aspx?kbid=246133
http://support.microsoft.com/default.aspx?kbid=240872
pls help
Hi,
You can script the users and associated roles for that user using the SQL
Server ENterprise manager "Generate SQL script"
1. Open Enterprise manager and connect to the SQL server where your actual
database resides.
2. Expand the datbases and select the database.
3. Right click above the database and choose All tasks and select "Generate
SQL Scripts"
4. Go to Options tab in the new window displayed
5. Check the option "Script database users and database roles"
6. Go back to "General Tab"
7. CLick Preview.. This will display you the database users and roles
assigned
8. copy the script and paste in to a notepad
9. Login to TEST SQL servers Query analyzer using 'SA'
10. Go to the database you have dropped the users
11. copy the notepad contents and paste it in Query analyzer
12. Execute the script... Ensure that you are in correct database.
This will create all the users back with correct previlages.
FYI, I have never tested this steps before.
Thanks
Hari
MCDBA
"pk" <pk@.discussions.microsoft.com> wrote in message
news:AB82B609-55E7-4D10-9344-4ACC87721FA6@.microsoft.com...
> How can I script out existing SQL users from a user database on Production
server to the same user databse migrated to Test server ? (Both srv are on
w2k, sql2000)
> When I migrate the user database to Test server, I accidentally deleted
all the SQL users for that database on the Test server.
> I hve looked at these KB, but not sure if the "logins transfer" will
removed the existing logins or any impact on the Production server,
> http://support.microsoft.com/default.aspx?kbid=298897
> http://support.microsoft.com/default.aspx?kbid=246133
> http://support.microsoft.com/default.aspx?kbid=240872
>
> pls help
sql

migrate users

How can I script out existing SQL users from a user database on Production server to the same user databse migrated to Test server ? (Both srv are on w2k, sql2000)
When I migrate the user database to Test server, I accidentally deleted all the SQL users for that database on the Test server.
I hve looked at these KB, but not sure if the "logins transfer" will removed the existing logins or any impact on the Production server,
http://support.microsoft.com/default.aspx?kbid=298897
http://support.microsoft.com/default.aspx?kbid=246133
http://support.microsoft.com/default.aspx?kbid=240872
pls helpHi,
You can script the users and associated roles for that user using the SQL
Server ENterprise manager "Generate SQL script"
1. Open Enterprise manager and connect to the SQL server where your actual
database resides.
2. Expand the datbases and select the database.
3. Right click above the database and choose All tasks and select "Generate
SQL Scripts"
4. Go to Options tab in the new window displayed
5. Check the option "Script database users and database roles"
6. Go back to "General Tab"
7. CLick Preview.. This will display you the database users and roles
assigned
8. copy the script and paste in to a notepad
9. Login to TEST SQL servers Query analyzer using 'SA'
10. Go to the database you have dropped the users
11. copy the notepad contents and paste it in Query analyzer
12. Execute the script... Ensure that you are in correct database.
This will create all the users back with correct previlages.
FYI, I have never tested this steps before.
--
Thanks
Hari
MCDBA
"pk" <pk@.discussions.microsoft.com> wrote in message
news:AB82B609-55E7-4D10-9344-4ACC87721FA6@.microsoft.com...
> How can I script out existing SQL users from a user database on Production
server to the same user databse migrated to Test server ? (Both srv are on
w2k, sql2000)
> When I migrate the user database to Test server, I accidentally deleted
all the SQL users for that database on the Test server.
> I hve looked at these KB, but not sure if the "logins transfer" will
removed the existing logins or any impact on the Production server,
> http://support.microsoft.com/default.aspx?kbid=298897
> http://support.microsoft.com/default.aspx?kbid=246133
> http://support.microsoft.com/default.aspx?kbid=240872
>
> pls help

Migrate user account to a different server

I need to migrate a user account to a different SQL Server. I can't just recreate it, becuase I don't know the password and can't change it because some applications are using it.

Is there a way to copy this user account and all of it's associated properties to a new server?

Any help is appreciated.

MikeI need to migrate a user account to a different SQL Server. I can't just recreate it, becuase I don't know the password and can't change it because some applications are using it.

Q1 Is there a way to copy this user account and all of it's associated properties to a new server?

Any help is appreciated.

Mike

A1 Generally, yes. You have not mentioned sufficient details to know for certain i.e.(standard logins or domain accounts, different domains, source and target versions etc.). Between 7.0 and / or 2k versions there are (at least) two ways that generally may work. Within and / or between newer and older versions (6.x, etc.) you may be able to selectively bcp out the applicable login data and then bcp in the output file into the target server(s)|||Yep, there was definitely more information that I could have provided. :)

Here goes:
SQL Server accounts, not NT accounts.
SQL Servers are in the same domain.
Both servers are SQL 2000 SP-2.|||Are any of the databases being transferred that require this login ? If not, then you can use the dts transfer logins task. If there are databases being transferred you will have to make sure the sids match up - the following article describes both scenarios:

article (http://support.microsoft.com/default.aspx?scid=kb;EN-US;246133)|||RE: Yep, there was definitely more information that I could have provided. :)
Here goes:
SQL Server accounts, not NT accounts.
SQL Servers are in the same domain.
Both servers are SQL 2000 SP-2.

That makes things fairly simple. You may choose to create a tsql script that you may edit and simply run on as many target servers as necessary. {Assuming completley new and different databas(es) are to be accessible by the same login on the target server(s), you will of course have to grant the new login any permissions / rights on the target database(s) on the target server(s)}.

To create such scripts you would need to create and use the stored procedures which are fully described in:
http://support.microsoft.com/default.aspx?scid=kb;EN-US;246133 (as already noted by rnealejr).|||That is exactly what I needed, thanks guys!!!!

Don't know why I couldn't find that article... :D|||Happy to help.

Good luck.

Migrate from user instance to native db in SQL Server Express ?

Hello,
I am currently looking at migrating a database which has been running in
"user instance" mode, onto the standard sql server express mode. Basically I
need to be able to connect to the database while it's running from other
scripts and the management studio, which I cannot do nicely while the DB is
running in user mode.
Is there any tools or good instructions on doing this?
At this point I've re-created the database from scratch and imported data,
however I am looking for a cleaner/effective way of doing this. Any
suggestions?Hi
I am not a SQLExpress expert, ut SSEUTIL will allow you to attach to a user
instance of SQL Express.
http://www.microsoft.com/downloads/...&DisplayLang=en
You could then detach (sp_detach_db) the database and re-attach
(sp_attach_db) it to the main instance of SQL Server.
You would need to change the connection string in the application that
creates the user instance to reference the main instance of SQL Server and
not create the user instance.
John
"NSiggel" wrote:

> Hello,
> I am currently looking at migrating a database which has been running in
> "user instance" mode, onto the standard sql server express mode. Basically
I
> need to be able to connect to the database while it's running from other
> scripts and the management studio, which I cannot do nicely while the DB i
s
> running in user mode.
> Is there any tools or good instructions on doing this?
> At this point I've re-created the database from scratch and imported data,
> however I am looking for a cleaner/effective way of doing this. Any
> suggestions?
>sql

Migrate from user instance to native db in SQL Server Express ?

Hello,
I am currently looking at migrating a database which has been running in
"user instance" mode, onto the standard sql server express mode. Basically I
need to be able to connect to the database while it's running from other
scripts and the management studio, which I cannot do nicely while the DB is
running in user mode.
Is there any tools or good instructions on doing this?
At this point I've re-created the database from scratch and imported data,
however I am looking for a cleaner/effective way of doing this. Any
suggestions?
Hi
I am not a SQLExpress expert, ut SSEUTIL will allow you to attach to a user
instance of SQL Express.
http://www.microsoft.com/downloads/details.aspx?FamilyID=fa87e828-173f-472e-a85c-27ed01cf6b02&DisplayLang=en
You could then detach (sp_detach_db) the database and re-attach
(sp_attach_db) it to the main instance of SQL Server.
You would need to change the connection string in the application that
creates the user instance to reference the main instance of SQL Server and
not create the user instance.
John
"NSiggel" wrote:

> Hello,
> I am currently looking at migrating a database which has been running in
> "user instance" mode, onto the standard sql server express mode. Basically I
> need to be able to connect to the database while it's running from other
> scripts and the management studio, which I cannot do nicely while the DB is
> running in user mode.
> Is there any tools or good instructions on doing this?
> At this point I've re-created the database from scratch and imported data,
> however I am looking for a cleaner/effective way of doing this. Any
> suggestions?
>

Migrate from user instance to native db in SQL Server Express ?

Hello,
I am currently looking at migrating a database which has been running in
"user instance" mode, onto the standard sql server express mode. Basically I
need to be able to connect to the database while it's running from other
scripts and the management studio, which I cannot do nicely while the DB is
running in user mode.
Is there any tools or good instructions on doing this?
At this point I've re-created the database from scratch and imported data,
however I am looking for a cleaner/effective way of doing this. Any
suggestions?Hi
I am not a SQLExpress expert, ut SSEUTIL will allow you to attach to a user
instance of SQL Express.
http://www.microsoft.com/downloads/details.aspx?FamilyID=fa87e828-173f-472e-a85c-27ed01cf6b02&DisplayLang=en
You could then detach (sp_detach_db) the database and re-attach
(sp_attach_db) it to the main instance of SQL Server.
You would need to change the connection string in the application that
creates the user instance to reference the main instance of SQL Server and
not create the user instance.
John
"NSiggel" wrote:
> Hello,
> I am currently looking at migrating a database which has been running in
> "user instance" mode, onto the standard sql server express mode. Basically I
> need to be able to connect to the database while it's running from other
> scripts and the management studio, which I cannot do nicely while the DB is
> running in user mode.
> Is there any tools or good instructions on doing this?
> At this point I've re-created the database from scratch and imported data,
> however I am looking for a cleaner/effective way of doing this. Any
> suggestions?
>

migrate database incl. user and password to other server

hi all,
i need to migrate a database including the user and their passwords to
another server.
create the users manually is not possible because i do not know the
passwords. is there a possibility to get them to another db server?
im talking about sql server 2000 sp3
thanks
mic
Hi
There are to stored procedures provided by MS to transfer logins with their
original SID
Search on internet for 'sp_help_revlogin'
"j.goines" <muchos@.hotmail.com> wrote in message
news:e6z4rANIGHA.2948@.TK2MSFTNGP10.phx.gbl...
> hi all,
> i need to migrate a database including the user and their passwords to
> another server.
> create the users manually is not possible because i do not know the
> passwords. is there a possibility to get them to another db server?
> im talking about sql server 2000 sp3
> thanks
> mic
>
|||thanks a lot,
greets
mic
"Uri Dimant" <urid@.iscar.co.il> schrieb im Newsbeitrag
news:uZirDKNIGHA.984@.tk2msftngp13.phx.gbl...
> Hi
> There are to stored procedures provided by MS to transfer logins with
> their original SID
> Search on internet for 'sp_help_revlogin'
>
> "j.goines" <muchos@.hotmail.com> wrote in message
> news:e6z4rANIGHA.2948@.TK2MSFTNGP10.phx.gbl...
>

migrate database incl. user and password to other server

hi all,
i need to migrate a database including the user and their passwords to
another server.
create the users manually is not possible because i do not know the
passwords. is there a possibility to get them to another db server?
i´m talking about sql server 2000 sp3
thanks
micHi
There are to stored procedures provided by MS to transfer logins with their
original SID
Search on internet for 'sp_help_revlogin'
"j.goines" <muchos@.hotmail.com> wrote in message
news:e6z4rANIGHA.2948@.TK2MSFTNGP10.phx.gbl...
> hi all,
> i need to migrate a database including the user and their passwords to
> another server.
> create the users manually is not possible because i do not know the
> passwords. is there a possibility to get them to another db server?
> i´m talking about sql server 2000 sp3
> thanks
> mic
>|||thanks a lot,
greets
mic
"Uri Dimant" <urid@.iscar.co.il> schrieb im Newsbeitrag
news:uZirDKNIGHA.984@.tk2msftngp13.phx.gbl...
> Hi
> There are to stored procedures provided by MS to transfer logins with
> their original SID
> Search on internet for 'sp_help_revlogin'
>
> "j.goines" <muchos@.hotmail.com> wrote in message
> news:e6z4rANIGHA.2948@.TK2MSFTNGP10.phx.gbl...
>> hi all,
>> i need to migrate a database including the user and their passwords to
>> another server.
>> create the users manually is not possible because i do not know the
>> passwords. is there a possibility to get them to another db server?
>> i´m talking about sql server 2000 sp3
>> thanks
>> mic
>

migrate database incl. user and password to other server

hi all,
i need to migrate a database including the user and their passwords to
another server.
create the users manually is not possible because i do not know the
passwords. is there a possibility to get them to another db server?
im talking about sql server 2000 sp3
thanks
micHi
There are to stored procedures provided by MS to transfer logins with their
original SID
Search on internet for 'sp_help_revlogin'
"j.goines" <muchos@.hotmail.com> wrote in message
news:e6z4rANIGHA.2948@.TK2MSFTNGP10.phx.gbl...
> hi all,
> i need to migrate a database including the user and their passwords to
> another server.
> create the users manually is not possible because i do not know the
> passwords. is there a possibility to get them to another db server?
> im talking about sql server 2000 sp3
> thanks
> mic
>|||thanks a lot,
greets
mic
"Uri Dimant" <urid@.iscar.co.il> schrieb im Newsbeitrag
news:uZirDKNIGHA.984@.tk2msftngp13.phx.gbl...
> Hi
> There are to stored procedures provided by MS to transfer logins with
> their original SID
> Search on internet for 'sp_help_revlogin'
>
> "j.goines" <muchos@.hotmail.com> wrote in message
> news:e6z4rANIGHA.2948@.TK2MSFTNGP10.phx.gbl...
>

migrate a local SQL user account

whats the simplest way to migrate a user account from a master development SQL server to local development sql servers and also to a production server?

we can recreate the SQL account everywhere, but if we take a backup from one machine and restore to another, we loose access because the accounts arent truly the same account.Very few info can be found in sql books online.
You need to read Microsoft Knowledge Base Article - 246133
check out this link
http://support.microsoft.com/default.aspx?scid=kb;[LN];Q246133|||thanks for the article...i need to run the process that keeps the SID intact.

somehow i new the was no copy/paste solution... :-(

Microsoft.Reporting.WebForms.ReportViewer does not contain a definition for Reset

Hi everyone I developed a web form with a report viewer. I change the report datasource and report path based on user input. Before i do anything on the report i first reset it with this line:

rvWaitTime.Reset();

And then set the parameters, datasources, etc. It works fine on my dev machine: Windows Vista with .NET 2.0 installed (.NET 3.0 is installed as well). When I move the code to the production box: Windows Server 2003 with .NET 2.0 and 3.0 installed i get this error:

'Microsoft.Reporting.WebForms.ReportViewer' does not contain a definition for 'Reset'

and of course it fails on the line of code mentioned above.

Any ideas?

Who would have thought that you needed a seperate installation for a control that comes built in with VS 2005? I finally solved the problem. I needed to install theMicrosoft Report Viewer Redistributable 2005 SP1 (Full Installation) on my server and now everything works like a charm!

Microsoft.AnalysisServices.AdomdClient.AdomdCacheExpiredException

Hello,

I have a asp.net application that connects to a cube in Analysis Service 2005 to do graphs. It's possible that other user might be using the same cube at the same time and make changes to the cube. If I use the graphing tol right after the cube is updated, I sometimes get an error message : "Microsoft.AnalysisServices.AdomdClient.AdomdCacheExpiredException : The Cubes collection has been updated on the server".

Is there a way to refresh the cache or refresh the cube collection? Any suggestion on how to handle this exception is appreciated.

Thank you,

Sincerely,

Annie

I beleive the better solution for the user in this case is to prompt your user to re-connect.

User session on the server has been disvalidated as a result of the some else's activity. To see consistent picture prompt your user to reconnect and refresh all the stuctures.
BTW this is behavior you would see in SQL Management Studio's Cube browser. The minute cube becomes invalid cube browser will asks you to re-connect.

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.

Microsoft user group

Sorry for this post but can anyone direct me to Windows XP
Home edition user group ? I Think I locked myself out of
my computer unless Installing SP2 messed me up which is
not installed at all......
Thanks.....
Users group or newsgroup?
For newsgroups, try:
microsoft.public.windowsxp.help_and_support
-Sue
On Mon, 15 Nov 2004 11:20:44 -0800, "Dan"
<anonymous@.discussions.microsoft.com> wrote:

>Sorry for this post but can anyone direct me to Windows XP
>Home edition user group ? I Think I locked myself out of
>my computer unless Installing SP2 messed me up which is
>not installed at all......
>Thanks.....

Microsoft user group

Sorry for this post but can anyone direct me to Windows XP
Home edition user group ? I Think I locked myself out of
my computer unless Installing SP2 messed me up which is
not installed at all......
Thanks.....
"Dan" <anonymous@.discussions.microsoft.com> wrote in news:5be201c4cb48
$325c2540$a401280a@.phx.gbl:

> Sorry for this post but can anyone direct me to Windows XP
> Home edition user group ? I Think I locked myself out of
> my computer unless Installing SP2 messed me up which is
> not installed at all......
> Thanks.....
>
alt.os.windows-xp

Microsoft user group

Sorry for this post but can anyone direct me to Windows XP
Home edition user group ' I Think I locked myself out of
my computer unless Installing SP2 messed me up which is
not installed at all......
Thanks....."Dan" <anonymous@.discussions.microsoft.com> wrote in news:5be201c4cb48
$325c2540$a401280a@.phx.gbl:

> Sorry for this post but can anyone direct me to Windows XP
> Home edition user group ' I Think I locked myself out of
> my computer unless Installing SP2 messed me up which is
> not installed at all......
> Thanks.....
>
alt.os.windows-xp