Cannot connect to MSSQL

General usage of Access to MySQL

Moderator: jr

bobalston
Posts: 3
Joined: Wed Apr 19, 2017 6:40 pm

Cannot connect to MSSQL

Post by bobalston »

Using Access to MSSQL. Cannot connect to MSSQL.

Error message/log:

SETTINGS
--------
Moving data directly to MSSQL server

TABLES
------------
Error connecting to destination database.
Connection: Driver={SQL Server};Server=CJAM-NAS;Database=;Uid=sa;Pwd=marypa2385;
Program Version: 5.5.0.276
ODBC Version:
Function: modMySql.MoveData2MySql
Error: -2147467259
Hint: Open connection to destination database
Reason: [Microsoft][ODBC SQL Server Driver][Shared Memory]SQL Server does not exist or access denied.

I am able to connect to MSSQL via the SQL server management studio.

I created the target database in the SQL server instance before running Bullzip.

Suggestions? :?: