SQL Monitor 2

Error messages - creating a Data Repository database account

The table below lists the error messages that may be displayed if SQL Monitor cannot create a database account for the Data Repository.

These messages may relate to either the authentication details you have entered, or to your current Windows login (i.e., the login on the PC running the installer).

Message

Possible cause

Login failed for user <username>

User name or password is incorrect, or account does not have permissions to log in to the specified SQL Server.

CREATE DATABASE permission denied in database 'MASTER'

Account does not have CREATE DATABASE permissions on the SQL Server.

dbcreator role permissions are required.

A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible

The SQL Server instance cannot be located or connected to on the network; check the following:

  • The name of the SQL Server is entered correctly.
  • The database engine is configured to accept remote connections.
  • SQL Server service is running on the specified machine.
  • Your firewall is configured to allow connections to this server (check the port number and instance).
  • The Network protocol is enabled/supported on the SQL Server (click Edit connection properties to change the network protocol).
  • Ping the server to ensure that there is network connection to the host server.

Login failed. The login is from an untrusted domain and cannot be used with Windows authentication

SQL Server has rejected the credentials because the SQL Server is on a different domain from the account:

  • Ensure that the account is a domain account. 
  • Verify that you are logged in to the correct domain and that SQL Server is set up to allow this login.

A connection was successfully established with the server, but then an error occurred during the pre-login handshake

The SQL Server you selected does not support encrypted connections:

Click Edit connection properties and ensure that the Encrypt connection option is turned off.


Do you have any feedback on this documentation?

Let us know at sqlmonitorfeedback@red-gate.com


Didn't find what you were looking for?