I am relatively new to promis.e. I just installed a fresh copy on my machine and when I start the software I get this Setup Screen:
I am unsure on how to proceed from here.
So I was logged in to the last Drafter's Windows account and Promis.e works fine. But when I log-in to my own Windows account and I start up Promis.e it gives me that setup database screen and then when I click apply I get that error.
On my Windows account I tried going with the SQL server authentication option, typed in ecaduser in username and Ecad1pass in the password and I get this:
How do I set up promis.e (Or the SQL database) so that I have permission to access the database on my own Windows log-in? Is it recommended to just create my own database on my own Windows account? If so, how do I proceed with that, or at least can you point me in the right direction?
Edmund, giving your Windows account or the ecaduser login access to the database each require SQL Server Management Studio to be installed. Whether you use SQL Authentication or Windows Authentication makes no difference in how Promis.e operates, so I recommend the following:
if not exists (select * from syslogins WHERE loginname=N'ecaduser')
EXEC sp_addlogin 'ecaduser','Ecad1pass','promise';
ALTER LOGIN [ecaduser] WITH DEFAULT_DATABASE=[promise], CHECK_EXPIRATION=OFF, CHECK_POLICY=OFF;
if not exists(select * from sysusers WHERE name=N'ecaduser')
EXEC sp_adduser 'ecaduser','ecaduser','db_owner'
ALTER USER ecaduser WITH LOGIN = ecaduser;
ALTER USER ecaduser WITH DEFAULT_SCHEMA = dbo;
You may next be prompted to update the database. This is required if you have upgraded Promis.e since the database was used. Alternatively, if you do not need to access previous projects in that database, you could create a new database.