create blank sqlserver database 6.5.4
I have been trying to use the VMCVTUTL program to create a blank sandbox on my sqlserver 2008 R2 and when it runs the final sql statement SS653654.sql it keeps coming up with the error 'Database is at version Null and it is supposed to be at version 6.5.3' 'Do you want to continue'. I click yes and it finishes and says it was created succesfully but, I get errors when trying to load the database. I was told that if this comes up that the database is no good. I ordered the CD from infor and replaced the SQL scripts SS652653.sql, SS653BSE.sql, SSTRG653.sql. The CD did not have the SSFKY653.sql so I was not able to replace that one. Not sure if there are any more that could be replaced. I was able to get (supposedly) a good blank database from a tech at infor so I go to do a restore of the databaseinstead. It seems to restore it just fine but, when I go into the security - right click on SYSADM and select properties then go to the user mapping select the newdb1 database then select the database role memberships. It already has public so I click on db_securityAdmin and db_owner and click OK and It comes up with the error,
Create failed for user 'SYSADM' (microsoft.sqlserver.smo)
An exception occurred while executing a transact-sql statement or batch
user, group, or role 'sysadm' already exists in the current database error 15023
Any help is very appreciated
thanks
Joel
Comments
There are no comments yet