Investigate SQL connection problems

If an SQL connection is not possible, you can proceed as follows to test the SQL connection:

Create a new file (for example, a text document). The file extension is then changed to UDL (for example: Text.txt -> Test.udl). Double-click to start the data link properties dialogue. In this dialogue you can enter the server data yourself to test the connection:

  • Server name: Selection via drop-down menu or server\instance name (example values: 192.168.2.2\GEBIOM or Server2000\GEBIOMV7)
  • User name and password are in the rule:
    • User: sa
    • Password: GeBioM2012
  • database on the server is usually:
    • GpBank

The database connection can then be terminated with "Test connection" should be checked. If no connection is established, proceed as follows:

  1. Is the service started on the server? Computer management -> Services
    • With a server solution, in addition to the instance SQL Server (INSTANZNAME) the following services must also be started.
    • SQL Server Browser
    • SQL Server Agent (INSTANZNAME)
  2. Is there a GpBank.ldf and GpBank.mdf in the correct folder?
  3. Can the server be reached (Does DNS work, can the server be reached with the "ping" command?)
  4. Is a firewall blocking access to the server (see Server installation)?