Database setup : Unable to connect to database error 49153

SUGGESTED

Hello Everyone, I am currently learning Sage 300 2019.

I did install all the software and setup the database as seen on the textbook Using Sage 300 by 2017 Christine A. Heaney.

After I setup the database in SQL Server Management Studio, for two database OMNDAT and OMSYS, I started to setup database. However, I keep getting "Unable to connect to database error 49153".

Can anyone help me out?

Thank you in advance.

Parents
  • 0

    What version of SQL Server did you install?

    Are you using Data Source or Server in your ODBC DSN?

    If you are using SQL Server Express, you may also need to:

    • enter the server name and instance name (e.g. <Server Name>\<Instance Name>) in the Server name field of the Database Setup screen, or the ODBC DSN that you are using
    • ensure that TCP/IP is enabled for the SQL Server Express instance, under SQL server Configuration Manager > SQL Server Network Conifguration > Protocols for SQLEXPRESS > TCP/IP
    • ensure the SQL Browser Service is running (Non-default SQL instances, like the one installed with SQL Express, are assigned random port numbers, the SQL Browser Service keeps track of which port belongs to which instance and directs SQL connections to the right instance)

    If you are using Windows Authentication in SQL Server, you may also need to:

    • set Server > Properties > Server Authentication > SQL Server and Windows Authentication mode in SQL Server Management Studio
Reply
  • 0

    What version of SQL Server did you install?

    Are you using Data Source or Server in your ODBC DSN?

    If you are using SQL Server Express, you may also need to:

    • enter the server name and instance name (e.g. <Server Name>\<Instance Name>) in the Server name field of the Database Setup screen, or the ODBC DSN that you are using
    • ensure that TCP/IP is enabled for the SQL Server Express instance, under SQL server Configuration Manager > SQL Server Network Conifguration > Protocols for SQLEXPRESS > TCP/IP
    • ensure the SQL Browser Service is running (Non-default SQL instances, like the one installed with SQL Express, are assigned random port numbers, the SQL Browser Service keeps track of which port belongs to which instance and directs SQL connections to the right instance)

    If you are using Windows Authentication in SQL Server, you may also need to:

    • set Server > Properties > Server Authentication > SQL Server and Windows Authentication mode in SQL Server Management Studio
Children
No Data