How to test for SQL server connetivity using MS ODBC manager

How to test for SQL server connetivity using MS ODBC manager

When PassagePoint fails to connect to SQL server, it's possible to use windows ODBC manager to test the connection to SQL server.

If you don't know what sql server passagepoint connects to, see the  "sqlcontext.xml"  file, 

Ile is in \\PPGlobal\Config\sqlcontext.xml

a sample file is below:

Red line is the location of sql server and DB name




Using windows ODBC manager.

search for ODBC, and run ODBC Data Sources (64bit)





Hit Add:



select SQL server, and hit Finish   ***NOTE***, your driver may be a different version, but should work just as well.





using the name from your sqlcontext.xml file, copy it into the server field and hit "next"





change that to "with sql server authentication...." and type in the sql username/password






You should be able to connect and get the passagepoint DB



hit "next" and hit finish



hit test data source. You should get a success


    • Related Articles

    • How to connect to Microsoft SQL database and encyrpt user password

      Note: For windows authentication see KB article https://support.stopware.com/portal/en/kb/articles/sqlcontext-for-windows-authentication For SQL Authentication see instructions below. If TLS is required, see attachements. 1) Create a clean database ...

    • Using windows authentication for SQL server

      To use Windows Authentication,  add service account to "PassagePoint Server" services The account used to start the passagepoint service is the account used to connect to SQL server The SQL context file will need to contain the following string: ...

    • How do I move PassagePoint global to a different server?

      How do I move PassagePoint Global to a different server? Source Machine = Production server is the customer's server that contains the PassagePoint Global “config” folder and database Destination Machine = New server for the PassagePoint Global ...

    • Reset passagepoint Admin password with SQL server Backend

      If you don't know what back end DB you are running, see here first: https://support.stopware.com/portal/en/kb/articles/what-backend-database-am-i-running If PassagePoint is running Postgresql, see this: ...

    • Migrate Data Source to SQL Server

      To migrate to SQL: 1. Have SQL DBA create a clean database on SQL Server. Have DBA create a user with DBO rights to the database, and get the username/password (SQL authentication) from the DBA (database administrator). 2. In Database tools => select ...