In case a SQL ( Express) database is installed manually and you would have to create a user and database in the server you can follow the steps below:
custo diagnostic Setup is a script based but compiled exe. There gives no external command line interpreter to execute some parts of the script.
But you can get the SQL commands to create all things in the SQL server (you can use the command line tool "sqlcmd.exe" - its installed with the SQL server - or directly inside in the SQL Management Studio). BTW: The Microsoft SQL Management Studio is license free!!!
This are the original commands from the Setup. The Setup uses the same SQL commands to create the Login, Database, User and so on.
You can adapt all names and the collation - but we recommend to leave it in standard.
("custodiagnostic" means every time "Name", "Password" or "Databasename")
1. Create Login
CREATE LOGIN custodiagnostic WITH PASSWORD=N'custodiagnostic', DEFAULT_DATABASE=[master], CHECK_EXPIRATION=OFF, CHECK_POLICY=OFF
2. Create Database
CREATE DATABASE custodiagnostic COLLATE Latin1_General_CI_AS
3. Assign Login as User to the Database
USE custodiagnostic
CREATE USER custodiagnostic FOR LOGIN custodiagnostic
4. Make the Database User as an DB_OWNER
EXEC sp_addrolemember N'db_owner', N'custodiagnostic'
Overview
Content Tools