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> go

1> exec sp_addlogin 'conquest','conquest','conquest'
2> use conquest
3> exec sp_changedbowner 'conquest'
4> go
1>^C

start 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 database

NOW 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