Offline Database.

[ytho]

Hi, i'm trying to setup Comarch ERP Optima (basically an app to take care of invoices, paychecks etc.). It needs Microsoft SQL Server database to write it's data.
It's going to be used on one computer only, do i really need to buy another computer and setup a database on it just to use this app? Or is it possible to setup this database localy on the computer that this app is going to be used on? If so, can i simply use a pendrive to transfer these files somewhere else? How does it work?  I've never used SQL Server. I've been used Filezilla a couple of times for basic things like accessing a server from my PC, but that's it. Please help me.
Thank you in advance. 

[igormp]

2 minutes ago, ytho said:

Or is it possible to setup this database localy on the computer that this app is going to be used on?

Yes, simply get a valid SQL Server installer and install it on the machine. AFAIK, there's a free version available.

[Eigenvektor]

You can simply install the free version from here: https://www.microsoft.com/en-us/sql-server/sql-server-downloads

Search for Express –> "SQL Server 2019 Express is a free edition of SQL Server, ideal for development and production for desktop, web, and small server applications."

 

A database server doesn't have to be on a remote machine. You can connect to it on the same PC just as you would on a remote machine.

[ytho]

28 minutes ago, igormp said:

Yes, simply get a valid SQL Server installer and install it on the machine. AFAIK, there's a free version available.

Hi, thank you for responding so fast. What type of database should i choose in my situation? I don't really know the exact differences.

[ytho]

25 minutes ago, Eigenvektor said:

You can simply install the free version from here: https://www.microsoft.com/en-us/sql-server/sql-server-downloads

Search for Express –> "SQL Server 2019 Express is a free edition of SQL Server, ideal for development and production for desktop, web, and small server applications."

 

A database server doesn't have to be on a remote machine. You can connect to it on the same PC just as you would on a remote machine.

Hi, thank you for fast response. Do i need to change some options or do some extra steps if i'm not planning for this computer to be turned on 24/7? Do i need to connect everytime, or startup the server? 

[Eigenvektor]

14 minutes ago, ytho said:

Hi, thank you for fast response. Do i need to change some options or do some extra steps if i'm not planning for this computer to be turned on 24/7? Do i need to connect everytime, or startup the server? 

The database simply has to be available when the application wants to connect to it. If they're installed on the same computer that shouldn't be an issue. By default SQL Server is installed as a Windows service. So it'll run any time your computer runs, which means the app can connect to it.

[ytho]

On 12/21/2021 at 8:17 PM, Eigenvektor said:

The database simply has to be available when the application wants to connect to it. If they're installed on the same computer that shouldn't be an issue. By default SQL Server is installed as a Windows service. So it'll run any time your computer runs, which means the app can connect to it.

Hey, i tried to make it work but i can't connect to the database. Says "sa user login failed" and no error code or reasons for that. Are there any more steps after installing a server and then a database? Can you please tell me in simple steps how to do that? Surely im missing a step, like adding users or something. What i did so far:
Installed MS SQL Server 2014, and went through installation without any problems.
Installed SSMS, and then added a new database, named it etc.
And then i tried to connect to it, but got that "sa user login failed".

[Eigenvektor]

18 hours ago, ytho said:

Hey, i tried to make it work but i can't connect to the database. Says "sa user login failed" and no error code or reasons for that.

Where does it say this, the ERP or when using SSMS? The "sa" user (Server Administrator) is the default user for SQL Server. It's like root on Linux or Administrator on Windows, the primary account with all possible permissions. The message is telling you that login failed, so you probably need to configure a password somewhere.

 

18 hours ago, ytho said:

Are there any more steps after installing a server and then a database? Can you please tell me in simple steps how to do that? Surely im missing a step, like adding users or something.

The sa user should exist by default, but I think it is normally disabled for security reasons. You probably need to enable it and set a password, try this:

https://community.boschsecurity.com/t5/Security-Intrusion/How-to-Reset-or-change-the-SA-Password-in-SQL-Server/ta-p/10193

 

18 hours ago, ytho said:

Installed MS SQL Server 2014, and went through installation without any problems.

Installed SSMS, and then added a new database, named it etc.

And then i tried to connect to it, but got that "sa user login failed".

I hope you mean MSSQL 2019, since MSSQL 2014 has been EOL for 2 years already

 

I assume you used Windows Authentication in SSMS for that? If possible configure the ERP to also use Windows Authentication, or alternatively enable the sa user, set a password and then configure that password in the ERP.

[ytho]

2 hours ago, Eigenvektor said:

I hope you mean MSSQL 2019, since MSSQL 2014 has been EOL for 2 years already

 

I assume you used Windows Authentication in SSMS for that? If possible configure the ERP to also use Windows Authentication, or alternatively enable the sa user, set a password and then configure that password in the ERP.

On the ERP Optima's site it says that it works with MSSQL 2012 version or newer, and so happens that PC i'm using this app on is Win7. 
I have two options to connect to the database. Windows NT Authentication and normal user/login. Both of them don't work and i'm getting the same message. I tried to configure the SA user but any changes i make just get rolled back after closing SQL Server Management Studio.
I'm logging in to the server using both sa user and windows authentication in SQL Server Management Studio without any problems.