This discussion has been locked.
You can no longer post new replies to this discussion. If you have a question you can start a new discussion

Can not connect to MS SQL Server

I am trying to connect with MS SQL Server using acuSql but I get:
SQLCODE -1
SQLSTATE 08001

01 servername pic x(30) value "(LocalDb)\MSSQLLocalDB".

01 userid         pic x(20) value "PCANDRE\andre".


EXEC SQL CONNECT TO :servername as C1
USER :userid USING :passwd

also tried withoud userid.

Configuration: ACUSQL_RUNTIME_DLL asqlsrvr.dll

However this works: sqlcmd -S (LocalDb)\MSSQLLocalDB

  • 0 in reply to   

    Solved:

    Uninstalled SQL Server Management Studio

    Installed SQL Server 2019 Express

    (Re)installed SQL Server Management Studio

    Servername: localhost\SQLEXPRESS

    Due to lack of my knowledge of SQL I didn't install SQL Server Express first but thanks for your help.