Cannot Access Database 49153 database setup with server


Hi All.

I have error when i want connect new PC from sql.

Cannot Access Database 49153, it means the PC cannot read the sql server.

No issued with another PC, only problem from this PC.

But if i create ODBC, connection is sucsessfull, and change from database setup server to data source is connected.

My Question, why if i use server not connected? any solutions?

  • verified answer

    If you set the database(s) to use Server instead of ODBC, the system wants to create a System 32bit ODBC entry.  If you launch for the first time with non-administrative / power user permissions, the ODBC entry will likely not be created.
    Try the following:
    1. Set databases to Server (SQL connection)
    2. From the client, launch Database Setup - AS ADMINISTRATOR
    3. Click the Verify icon
    4. Select a database to verify

    If the above fails, there is an issue with the PC and workstation setup should be run again (as administrator).  If it connects and scans tables, the system will have created a 32bit server-level ODBC connection in the system section of the ODBC admin snap in and you should be good.

  • 0 in reply to Shane - Ascend Business Solutions

    Hello Gentlemen,

    All the usual mentioned as possible culprits in this thread turns out okay. That is, they have been setup accordingly. I am running Sage 300 2023 on Windows 11. What I picked up during the WSSETUP is that Sage 300 installs "ODBC Driver 18 for SQL Server" and by default an ODBC DSN is setup to use this driver even though it still fails to connect. When I remove this data source and to setup a new data source using "SQL Server Native Client 11.0", it still fails to connect. The client is running MSSQL Server 2019 EXPRESS.

    I don't really like SQLEXPRESS because of its default settings, but I don't have a choice here. Is there anything else that I could be missing?

  • 0 in reply to SeisaT

    Go through the ODBC configuration settings for the client.  There is one screen that has a check box field to trust the server.  If you put a check mark in that field, it will work

Reply Children