Solution Properties
Solution ID:
223924150029690
Last Modified Date:
Wed Aug 23 09:32:08 UTC 2023
Taxonomy Path:
Category//Data
Author:
legacyauthor
Error: "You are not currently set up as a user of the selected Estimating server" (Security.Fix required) (SQL)
Description

Cause
Security of out of sync.

Note: Customer may have entered new SQL Estimate User through SQL Management Studio and NOT through Estimating Management Console. Recommendation is to remove the new user through SQL Management Studio. Open Estimating Management Console, select Security, add new user in this manner.
Resolution
In SQL Estimating 13.2 and higher:

  1. Launch Microsoft SQL Server Management Studio and connect to the correct SQL instance (which the default one is (local)\SAGE_ESTIMATING.)
    1. Open the Run Command.
    2. Type in SSMS.exe and press Enter.
  2. Expand Databases and look for the SQL database that corresponds to the Estimates database.
  3. Expand Programmability and Stored Procedures.
  4. Scroll down and locate Security.Fix.
  5. Right-click Security.Fix and select Execute Stored Procedure.
  6. Click OK.

This will open a window in the console with "Executing..." displayed in the lower left corner. Wait for the query to complete, make sure to note any errors (red text), then test to be sure the issue is resolved.

Note: Customer may have entered new SQL Estimate User through SQL Management Studio and NOT through Estimating Management Console. Recommendation is to remove the new user through SQL Management Studio. Open Estimating Management Console, select Security, add new user in this manner.


[BCB:164:Chat Estimating US:ECB]



Steps to duplicate
Related Solutions

Error: "You are not currently set up as a user of the selected Estimating server." (Master Page) (SQL)

How do I migrate my SQL Estimating Data from one SQL Server to another SQL server or instance? (SQL)