1. When trying to export tables from my local developer SQLServer to shared
SQLServer on my commercial host, upload of table data fails with error
"Cannot find user ASPNET". Table structure loads, but not data rows.

2. My hostsed shared SQLServer has two usernames, dbo and my userid., and
uses SQLServer security.

3. My local SQLServer as 4 users - DBO(Administrator), I_USR, ASPNET,
IIS_WPG. I'm logged on as Administrator under Windows integrated security.

4. If I delete user ASPNET from my local SQL, the host SQLServer then looks
for user IIS_WPG.

4. So far, I've been exporting my data to an interim table that has only
user DBO, and then exporting to shared SQLServer from there.
However, is there a way I can export to my hosted SQLServer directly from
my local SQLServer and get around the above problem?

Thanks.

Alan

___________________________
Alan Z. Scharf
GrapeVine Systems
New York City

Hi Alan,

From your description, I am not sure where the problem is. I would like you
to provide the following information so that I can narrow down this issue.

1. I would like to know the SQL Server version (Service Pack).

2. "When trying to export tables from my local developer SQLServer to
shared SQLServer on my commercial host, upload of table data fails with
error "Cannot find user ASPNET". Table structure loads, but not data rows."

I am not clear how the error occurs. Could you please describe the detailed
steps so that I could reproduce this problem on my side? Also, if it is
possible, please provide screenshot with the error message to expedite the
process of troubleshoot.

3. "If I delete user ASPNET from my local SQL, the host SQLServer then
looks for user IIS_WPG."

How about you delete the user IIS_WPG? If there is only user dbo on your
local SQL Server, what will happen?

4. I would like to know the owner of the table which you want to transform
from local table to shared SQL Server. If you only transform the tables
whose owner is dbo, what will happen?

I am standing by for your response.

Regards,

Michael Shao
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.

Michael,

Thanks for your reply.

1. SQL2000, SP3.

2. Occurs after import progress bar stops. Says "Copying failed" Click on
grid and message:

"[Microsoft][ODBC SQLSERVER Driver][SQL Server]NT User or Group
DELL--8250\ASPENT not found. Check the name again."

That's true as far as it goes. There is no ASPNET user on my hosted
SQLServer.

3. I can import to another database on my owm machine that does not have
ASPNET user. It's the hosted server that gives me the error.

.. If I delete user ASPNET from my own SQLServer, then get remote SQL error
can't find user IIS_WPG.

If I delete all but dbo from my local database, then I can import to hosted
SQLServer with no user errors.

Same problem if I transfer tables only ownd by dbo.

4. You could probably duplicate the problem by trying to transfer data from
a local SQLServer database that has user ASPNET to remote server database
that does not have user ASPNET.

5. I've seen other newsgroup messages on this problem. One suggestion is to
add user ASPNET to remote machine with same password as ASPNET user on local
machine.
ince it's a remote hosted server and I have to go through their
administrators, I'm looking for a safe way to do database transfer without
messing around with users. My .NET web application otherwise works great on
their system, and I don't want to start messing around with permissions if I
don't have to.

Thanks.

Alan






"Michael Shao [MSFT]" <v-yshao (AT) online (DOT) microsoft.com> wrote

Hi Alan,

Thanks for your feedback. I know that we can use DTS Import/Export Wizard
to transform data from local server to remote server. I am not sure which
option you select in the "Specify table copy or query" dialog when you are
setting in the DTS Import/Export Wizard.

I would like you to try to select the "Copy objects and data between SQL
Server databases" option. And then uncheck "Use default Option" and click
option button. You need to make sure the options under "Security options"
are checked. Press OK and Next until finish the DTS Import/export Wizard
setting. Does it work?

If not, I would like you to provide the detailed steps when you set the DTS
Import/Export Wizard.

I am standing by for your response.

Best Regards

Regards,

Michael Shao
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.

Michael,

1. After following your instructions, I get

User does not have permission to perf"orm this action"

2. My web host says they don't have any users ASPNET and IIS_WPG on their
SQLServer. I'm going to set up a clean install of SQLServer on another
machine without those users and see what happens.

Thanks for your help to date.

Regards,

Alan

after copy executes and I click on indicated error line in completion grid
"Michael Shao [MSFT]" <v-yshao (AT) online (DOT) microsoft.com> wrote

Hi Alan,

Thanks for your response. Based on my further research, it seems that
ASPNET is a local Windows NT user on the local SQL Server. The user did not
exist on the remote SQL Server. I would like you to try the following steps
to see if these steps help resolve this problem.

1. Please select the "Copy objects and data between SQL Server databases"
option in the Specify table copy or query" dialog when you are setting in
the DTS Import/Export Wizard.
2. In the "Select Objects to Copy" dialog, the "Use Default Options" was
checked. Please unchecked that and then clicked "Options" button.
3. "Copy database users and database roles" was checked. Please unchecked
this as well as unchecking "Copy SQL Server logins".
4. Press OK and go ahead.

Does it work on your side?

Also, I noticed that you are going to setup a clean install of SQL Server
on another machine without those users. It's a good way to narrow this
problem down. I am standing by for the results.

Thanks for using MSDN newsgroup.

Regards,

Michael Shao
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.