ERROR: SQL Server Does Not Exist or Access Denied

This error is most typically encountered upon first installing Tailwind CMS, and is most likely a result of the client machine not being configured to point to the database server correctly.

On the client machine:

  • Verify that your network connection (or Internet connection) is working properly.
  • Double-check your database connection settings (click Options → Edit Entry at the login screen)
    • If you don’t know what your connection settings should be, try having the CMS client scan the network for databases by choosing Options → Scan for Databases at the login screen. This will automatically map a connection to any CMS databases found on the network.

If you are unable to resolve this error with any of the steps outlined above, please contact your network administrator or Tailwind technical support.

This error may also be a result of incorrect configuration of the SQL server. Follow the steps below to ensure your SQL server is configured correctly for remote connections:

On the server machine:

  1. Click Start–>Run.
  2. Type “svrnetcn” and press enter.
  3. Make sure that only “TCP/IP” is listed under “Enabled Protocols”.
  4. Highlight “TCP/IP” and click “Properties”. Make sure that the default port is set to “1433”.
  5. Click “OK” to save your settings.
  6. Click Start–>Run.
  7. Type “regedit” and press enter.
  8. Open the “HKEY_LOCAL_MACHINE\Software\Microsoft\MSSQLServer\MSSQLServer” folder.
  9. Ensure that the “LoginMode” key is set to “2” (Mixed SQL and NT Authentication).
  10. Ensure that the “AuditLevel” key is set to “2” (Log Failures).
  11. Restart SQL Server.