You are currently reviewing an older revision of this page.
promis•e and Bentley Substation can be configured to use either Windows Authentication or SQL Server Authentication to connect to the SQL Server hosting the project database. To use SQL Server Authentication, a valid SQL Server Login must exist on the server and its name and password must be known and entered into the Setup dialog of promis•e or Bentley Substation.
After creating the project database with the Project Database Utility and using Windows Authentication, the SQL Server may not have a SQL Server Login that users can specify on the Setup dialog, depending on the application and version. Similarly, the SqlServerProject.sql script for some versions does not include lines for creating an SQL login.
After restoring a backup of a project database, the SQL Server may already have a SQL Server Login but it will not be properly associated with the restored database, preventing the login from being used to connect to the database.
To address the above issues, an SQL Server Login can be created and/or associated with database.
The following script adds the "ecaduser" login with a "Ecad1pass" password for SQL Server Authentication access to the SQL Server and adds the "ecaduser" user to the promiseX database and links it to the login.
It can be copied into a text document and saved with a .sql extension then opened and executed using SQL Server Management Studio (SSMS), or pasted directly into a new query in SSMS.
Substitute the correct database name for all of the instances of “promiseX” in the script and make other changes appropriate to the situation before executing the script.
use masterGOif not exists (select * from syslogins WHERE loginname=N'ecaduser')begin EXEC sp_addlogin 'ecaduser','Ecad1pass','promiseX'; ALTER LOGIN [ecaduser] WITH DEFAULT_DATABASE=[promiseX], CHECK_EXPIRATION=OFF, CHECK_POLICY=OFF;endGOuse promiseXGOif not exists(select * from sysusers WHERE name=N'ecaduser') EXEC sp_adduser 'ecaduser','ecaduser','db_owner'GOALTER USER ecaduser WITH LOGIN = ecaduser;GOALTER USER ecaduser WITH DEFAULT_SCHEMA = dbo;GO
Creating and Updating the Project Database
Troubleshooting Project Database Connection Problems
Moving Projects
SELECTsupport TechNotes and FAQs
How to: Create a SQL Server Login
Bentley Technical Support KnowledgeBase
Bentley LEARN Server
Bentley's Technical Support Group requests that you please submit any comments you have on this Wiki article to the "Comments" area below. THANK YOU!