When installing Microsoft SQL Server or SQL Server Express, ensure that the following points have been configured appropriately:
- Ensure that SQL Server Browser service is running and set to start automatically. You can enable the SQL Server Browser using
the SQL Server Configuration Manager or the Windows Services App.
- Ensure that both the server and client are configure for TCP/IP for 32bit connections. The default port to use is 1433.
- If
Enterprise Analyzer is running on a remote machine to the Microsoft SQL Server or SQL Server Express installations, ensure that the server is
configured to accept remote connections.
- Ensure that the users are registered in the database and they are active and can connect to the SQL Server.
- Ensure that the users use the dbo alias when connecting to the database that holds the workspace.
- All users must have the db_datareader and db_datawriter roles. In addition, the master users of the workspace must also be
granted the db_owner database role.
- All users must be granted execute permissions on the stored procedures that are created by
Enterprise Analyzer.