Spotfire 7.9 :: what permissions are granted to user spotfire_db on the database spotfire_server

Hello Spotfire community,

while installing Spotfire 7.9, we wondered what permissions are granted to user spotfire_db on the database spotfire_server? Below is a snipplet from the create_databases.bat from the install manual.  You can guess, something went wrong and we like to understand what we did wrong.

rem Set these variable to reflect the local environment:
set CONNECTIDENTIFIER=DBSERVER\MSSQL
set ADMINNAME=sa
set ADMINPASSWORD=admin123
set SERVERDB_NAME=spotfire_server
set SERVERDB_USER=spotfire_db
set SERVERDB_PASSWORD=spotfire_db123

Also, is there a script/ batchfile / sql we  could use to test the database, basically validating that the database setup was successful?

Thanks a lot in advance,

--T

(1) Answer

Login