
vhartline1.5524930832832842E12 asked a question.
Unable to create new catalog in AdminStudio 9.5
Trying to create a new catalog where SQL Server Express 2005 is already installed with other instances. I reinstall Express to create a new instance with these parameters: INSTANCENAME=AdminStudio SECURITYMODE=SQL SAPWD=test SQLACCOUNT="NT AUTHORITY\SYSTEM" SQLBROWSERACCOUNT="NT AUTHORITY\NETWORK SERVICE" SQLBROWSERAUTOSTART=0 ADDLOCAL=SQL_Data_Files.
I receive this error when trying to create a new catalog: Creating the application catalog...
User 'Administrator' does not have enough permissions to create the database 'AdminStudio'.
ERROR Unable to create the application catalog
I am using Windows Authentication.
We are gearing up to migrate from Wise Package Studio to AdminStudio.
Creating the application catalog...
Invalid object name 'AdminStudio.dbo.AMS_SchemaInfo'.
ERROR Unable to create the application catalog
Any ideas?
With regards to what's taking place, it's not too clear based on the error. Can you try manually running the creation scripts against the catalog?
Here's the order that they should be:
AMS_System_Schema.sql
AMSCreateIndex.sql
AMS_SamplePackagingTemplate.sql
AS_System_Schema.sql
Seed_Data.sql
CustomReportWizard.sql
I suspect one of these will produce the error you're seeing, and give us a better idea as to what the problem is. Make sure to run these scripts against a newly created empty database, as this will have none of the tables the scripts are trying to create.
InstallShield and Repackager should work without having a database set up. But, generally you should be able to complete the catalog creation wizard as long as you have a SQL account that has DBO rights.
Do the same errors occur, or is it different ones during login now?