ODBC Connection to SQL Server

From support-works
Revision as of 13:44, 26 January 2018 by Pamelal (talk | contribs) (Created page with "{{Template:Basic Cover |title=ODBC Connection to SQL Server |type=FAQ |htl=Y }} {{Template:Basic Status |status=Published |version=1.0 |authors=HTL QA |applicableto=Core Serv...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search



Status: Published
Version: 1.0
Authors: HTL QA
Applies to: Core Services Version 3.1.x

If you currently have an existing Supportworks installation, and you want to copy the contents to another server with Supportworks installed and your first application database is housed inside Microsoft SQL Server, the first thing you will need is an ODBC connection to the new application database.

Set up a blank database inside Microsoft SQL Server. Add a new System DSN inside the ODBC Data Source Administrator (32-bit). Take note its 32-bit, and NOT 64-bit. The new DSN should have SQL Server as the driver. Provide all the required connection details. Server name/ip address credentials default database. (Should be the new blank database, you've created in step 1.) don't forget to test the connection. If you're attempting to copy the database, you might want to use swsqldbmig.exe, found inside the Supporworks Server\bin folder. The process should be straight forward.

If you want a fresh blank one, you'll need to start up the Supportworks Database Schema Editor. And do the following:

Click on Database\Manage Database Entities in the menu. On the Database Entities window, select the lone entry and click on the Edit button. Change the DSN value to the DSN you've created above. Click on OK until the Database Entities window disappears. Click on the Database\Apply Specification to Physical Database in the menu. In the Apply Specification to Physical Database window, click on Apply button. This should provide you with the database schema inside the new database. The tables should be there but there would be no data. Lastly, in the Supportworks Server Configuration tool. Under the Database tab, another tab (Application Database tab)roughly in the middle of the window, change the value of the DSN, using the ellipse(...) button to the DSN you've created above. Make sure the credentials are correct.

Once that is done, you can now try to start up the server.