Can I create normal MSSQL databases if I have DSC installed?

[gpburdell]

I have Citadel 5 with DSC installed on my machine. It is obvious that an instance of MSSQL is installed, which Citadel runs on top of. The question is this a special runtime version of MSSQL for use only by Citadel? Note, I have not installed any other database software other than MS Access. I am interested in having a web server with access to both Citadel data, as well as normal relational data.

Can I some how incorporate normal relational databases as one would with MSSQL? Do I just need to download MSSQL Express management tool? 

If it is a special runtime, can I just load a version of MSSQL Express?

If so, will they be seperate services that fight each other for resources? I am assuming I want to use MSSQL as opposed to another database program prinicipally for this reason.

[Eli_S]

Hi,

First of all I would like to clarify a few things. Citadel itself is not based on SQL. Citadel is a numeric database optimized for data streaming. The database where alarms and events are stored is based on SQL but everything happens through Citadel and the SQL database is not directly accessed. The version of SQL that is installed with DSC is Microsoft SQL express 2005. If you want to install the full version of SQL, there should not be any problems because Citadel will use another instance of the database.

Another important thing you should know is that Citadel installs an OBDC driver that allows you to communicate with the database using normal SQL calls from any other program.

Lastly, I would really like you to take a look at this whitepaper which has very detailed information about the Citadel database and should answer any further questions you may have.

[mikeporter]

The answer to your question is: yes. You can use the instance of SQL Server outside the Citadel environment. The name of the instance should be "Citadel" and it should by default be configured for mixed authentication. All you have to do is download Microsoft's (FREE!) development tools and you are on your way...

Mike...