Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
rumblepup
Starting Member
14 Posts |
 Posted - 2007-07-17 : 16:25:30
|
| I had an issue where my database was transfered from a SQL 2000 database to a SQL 2005 database.The SQL 2005 database works fine, but my development environment is SQL 2000.So I created a new SQL 2000 database and used the SQL 2005 DTS wizard to transfer the data. As far as I can tell, everything went fine, and the DTS wizard showed no errors.However, when I changed my website application's connection string to the new database, the application (LaGarde StoreFront 6.0) throws a licensing error. When I checked with LaGarde, they said that it was a permissions issue, that the permissions on the database where incorrect.I never really heard of that, but have no way to check. I really need to transfer this database back to 2000. Any help?http://www.cushionsandumbrellas.com |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2007-07-17 : 17:33:08
|
| you'll have to recreate all users and map them to logins_______________________________________________Causing trouble since 1980blog: http://weblogs.sqlteam.com/mladenp |
 |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-07-17 : 22:50:21
|
| Or copy sql logins with ssis task. |
|
|
|
|
|
|
SQL 2005 back to SQL 2000