Cannot connect to MSSQL

General usage of Access to MySQL

Moderator: jr

Cannot connect to MSSQL

Postby bobalston » Wed Apr 19, 2017 6:46 pm

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? :?:
bobalston
 
Posts: 0
Joined: Wed Apr 19, 2017 6:40 pm

Return to General

Who is online

Users browsing this forum: No registered users and 1 guest

cron