Which version of SQL Server/MSDE you are connecting to??
If you have SQL Server client tools installed, you can start Query Analyzer (ISQLW.exe) and type
SELECT @@VERSION
GO
to find out the version information.
From the log, it looks like, the datatype SYSNAME is not being recognized.
New database creation in AdminStudio 5.01 (SP1) always runs AMS scripts as well, irrespective of if AMS is installed or not, or if it is Enterprise or Professional release.
Please email me the version information at
darshans@Installshield.com.
Try the following:
a.) Start Queary analyzer (ISQLW.exe).
b.) Create new database using following command:
CREATE DATABASE AdminStudioDB
GO
-- make this the current database
USE AdminStudioDB
GO
***IMPORTANT: Before running the following scripts, search for SYSNAME and replace it with varchar(128).***
Now, open AS_System_Schema.sql from the support folder and run it in this database (to run the script in Query analyzer, open the file [Ctrl+Shift+P] and then click on green arrow or press Ctrl+E or press F5).
Next, open AMS_System_Schema.sql from the support folder and run it in the same database.
Finally, Open AMS_Data.SQL (use the attached SQL File).
Now, start ConflictSolver and connect to this database (AdminStudioDB)