Setup Database Window

Hello,

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.

Please help,

Thanks.

  • 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?

    Thanks!

  • 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:

    1. Log into Windows under the previous drafter's account.
    2. Start SQL Server Management Studio (SSMS). If a Search finds no such application, download and install it.
    3. On the Connect To Server dialog that appears when SSMS starts up, use Windows Authentication and click Connect.
    4. Click the New Query button.
    5. Copy the following script and paste it into the new query window.
      use master
      GO
      if not exists (select * from syslogins WHERE loginname=N'ecaduser')
      begin
         EXEC sp_addlogin 'ecaduser','Ecad1pass','promise';
         ALTER LOGIN [ecaduser] WITH DEFAULT_DATABASE=[promise], CHECK_EXPIRATION=OFF, CHECK_POLICY=OFF;
      end
      GO
      use promise
      GO
      if not exists(select * from sysusers WHERE name=N'ecaduser')
         EXEC sp_adduser 'ecaduser','ecaduser','db_owner'
      GO
      ALTER USER ecaduser WITH LOGIN = ecaduser;
      GO
      ALTER USER ecaduser WITH DEFAULT_SCHEMA = dbo;
      GO
    6. Click the Execute button.
    7. Log into your Windows account and run Promis.e.
    8. Set the Setup dialog to use SQL Authentication, the ecaduser login, and the Ecad1pass password.

    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.