Please enable JavaScript to view this site.

Navigation: Get Your Software: Installed > Network Install: SQL Authentication

Give Database Rights to Users for EventPro On-Prem SQL Authentication

Scroll Prev Top Next More

1.Return to SQL Server Management Studio, once again ensuring that the Server Name is correct, and selecting Windows Authentication or SQL Server Authentication as appropriate.

Click Connect.

Connect to SQL Server in SQL Server Management Studio

2.In the Object Explorer panel, expand the Logins folder.

3.Double-click User1 to open its Login Properties.

4.Under Server Roles, unselect the dbcreator checkbox.

Change User Server Roles in SQL Server Management Studio

5.Under User Mapping, you can check to ensure that User1 has db_owner rights for both EventProData and EventProMaster.  

This would have been set automatically during database creation.

User Mapping in SQL Server Management Studio

6.Click OK.

7.You can now proceed to Install EventPro to Server.

Copyright Profit Systems Inc. EventPro Software is a wholly owned subsidiary of Profit Systems Inc.