aspnet account issue moving to different server 1

[VE]

I'm trying to move a database using SSIS from one server to another.

I'm getting an error that is telling me that the new server does not have oldserver\aspnet as a windows user or group.

I do have a newserver\aspnet account and user set up for the database. It's pretty much identical to the one on the other server except that it has it's own server's name.

How do I get around the server name issue with the aspnet account?

 

[JayKusch]

It sounds lijke you are having a SID issue. The security ID of the "oldserver\aspnet" account\group does not match the SID on the "newserver\aspnet". This is very common.

The DB you are moving has the SID for the old ASP group in it and of course once moved to the new server, it becomes orphaned.

Can you drop the login from the DB on the new server and then assign the NewServer ASPNet group\account login to point to the newly moved DB?



Thanks

J. Kusch