Has anyone tried using Conquest with SQL Express? I am going to try and set one up, seems like it should be the same as running with SQL server.
Tom
SQL Server Express
-
-
Hi,
I tried but did not find an easy way to create the database and login (enterprise manager is not included). Let me know if you succeed and how.
Marcel
-
Hi Tom,
i did successfully with SQL Express. You have to modify the ODBC settings.
Remove within the ODBC DSN setting the SQL config that comes with the generate ODBC from the Conquest Dicom server.Instead you have to set up the native SQL client with the same settings (SQL Server, database, security and so on)
Of course you can download from Microsoft the free management tools for the express version. http://msdn.microsoft.com/vstudio/express/sql/
-> free management tool for further administration of the DB. The max. db size is now 4GB.Regards Michael
-
Thanks for the tip. I had not seen the free management tool!
Marcel
-
The server console is 39 MB and requires service XP pack 2. An easier alternative: install MSDERalA (sql 2000 desktop version) - if you can still find it - with:
setup SAPWD="conquest" SECURITYMODE=SQL
start MSSQLSERVER service
osql /Usa /Pconquest
1> create database conquest
2> go1> exec sp_addlogin 'conquest','conquest','conquest'
2> use conquest
3> exec sp_changedbowner 'conquest'
4> go
1>^Cstart dicomserver installation
Database type: SQL Server Database
Save config
Verify tcp/ip
make ODBC: server = (local), database = conquest
start the conquest dicom server
go to installation page
verify database install
reinit databaseNOW YOU ARE UP AND RUNNING
Marcel
-
Version 1.4.13alpha makes life much easier for users of SQL server and SQL server express, it creates the database and login if you pass it the correct SA password:
setup SAPWD="conquest" SECURITYMODE=SQL
start MSSQLSERVER service
start dicomserver installation
Database type: SQL Server Database
Save config
Verify tcp/ip
make ODBC: server = (local), database = conquest, login = conquest, password = conquest, SA password = conquest
verify database install
reinit database
Participate now!
Don’t have an account yet? Register yourself now and be a part of our community!