XEM: Error You do not have the necessary permission to create SQL database.

XEM: Error You do not have the necessary permission to create SQL database.

Please use the following steps to grant SQL database permission to a specific user:
  1. Click START on the Windows Task Bar
  2. Click ALL PROGRAMS
  3. Click MICROSOFT SQL SERVER 2005
  4. Click CONFIGURATION TOOLS
  5. Click SQL SERVER SURFACE AREA CONFIGURATION
  6. Click YES on the User Account Control Dialog Box
  7. Click ADD NEW ADMINISTRATOR
  8. Highlight MEMBER OF SQL SERVER SYSADMIN ROLE ON XYGATESQL2005
  9. Click > to Select
  10. Enter New User Name in the USER TO PROVISION Box
  11. Click OK to Save & Close
If this article did not provide a solution, please open a case with our support team by sending an email message to support@xypro.com.

    • Related Articles

    • XSW: "Incompatible Database Version" Wrong Error

      The actual problem was found in the SQL database error log, this error was " Error occurred - schema common cannot be created." The Database User, who will be creating the database should have the sysadmin role (or similar permissions to a sysadmin ...

    • The SQLXPress installer fails to create SQLXPress DB in SQL/MX with error 1017

      Logon as a userID that has been granted CREATE CATALOG permission to the SQLXPress installer or to run the SETUPX program. Or grant permissions to create an SQL/MX Catalog. The example below grants the privilege to create a catalog to user ...

    • XMA: XMA_MANAGER prompts to Create SQL Environment.

      If you have just upgraded the software: If you have just upgraded the software, you should follow the prompts. This performs any required database upgrades and will sqlcomp any necessary object files. If you haven't upgraded the software: If you ...

    • XMA: *** ERROR from SQL ~[-1206~]: ??? is not a valid name for a catalog

      *** ERROR from SQL ~[-1206~]: ??? is not a valid name for a catalog A SQL ERROR -1206 can occur during the installation of XYGATEMA and XYGATETR if SQL has not been initialized. As per the SQL/MP Installation guide: Before you can use SQL/MP for the ...

    • XMA:Ways to address SQL error due to error 45 in AUDDET or AUDSESS

      Below are the Steps for ?Option 1? clean up the obsolete data records: Step: Option 1.0. Logon as an owner of XMA installation and install XMA macro at TACL Step: Option 1.1. Stop XMA Pathway by running the XMA_PWSTOP macro at TACL (or at the ...