MigrationStudio relies on a SQL database to access all data collected about your migration, from application usage to deployment schedules.  Any issues connecting to the database could result in poor performance or, in extreme cases, being unable to use MigrationStudio.

If you're experiencing issues connecting to the database, use the information below to determine where the issue lies.

The Ping Test

The ping command is a simple way to check that one computer can communicate with another over the network.  To check that the servers in the MigrationStudio solution can communicate with each other, you will need to:

  • Ping the MigrationStudio IIS from your machine,
  • Ping the MigrationStudio SQL server from your machine,
  • Ping the MigrationStudio SQL server from the MigrationStudio IIS server.

To start a ping:

  • Press the 'Windows' and 'R' key together to load the Run dialogue
  • Type cmd and hit the 'Enter' key
  • In the cmd windows, type ping [servername] and press 'Enter'.  For example:

ping svr-migstd-001

If the servers are running and accessible on the network, you should see a successful ping response:

Pinging svr-migstd-001 with 32 bytes of data:
Reply from svr-migstd-001: bytes=32 time=2ms TTL=64
Reply from svr-migstd-001: bytes=32 time=4ms TTL=64
Reply from svr-migstd-001: bytes=32 time=3ms TTL=64
Reply from svr-migstd-001: bytes=32 time=2ms TTL=64

Ping statistics for svr-migstd-001:
Packets: Sent = 4, Received = 4, Lost = 0 (0% loss),
Approximate round trip times in milli-seconds:
    Minimum = 2ms, Maximum = 4ms, Average = 2ms

If any of the pings fail, rerun the test using the IP address to rule out any issues with DNS, then check the servers to ensure they're running and have network connectivity.

Check Database Connectivity

To check the connectivity between the MigrationStudio IIS and the SQL server:

  • Create a file on the MigrationStudio IIS host called SQLTest.udl
  • Double-click the file to open the Data Link Properties window
  • Enter the following details:
    • The name of your SQL server and the SQL instance
    • The account that was used during setup to connect to the MigrationStudio database
    • Select the MigrationStudio database from the drop-down
  • Click the 'Test Connection' button to verify connectivity.

If this test fails, check the connectivity in your datacentre between the MigrationStudio IIS host and the MigrationStudio SQL server.

If this document hasn't resolved your issue, please contact the support team (support@migrationstudio.com) for further assistance.