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?
Cannot connect to MSSQL
Moderator: jr