If you’re getting the error mentioned above it’s likely there is a problem with SQL Server Browser Service, a component which helps inFlow communicate with the database. It may not have been installed properly and as a result cannot restart itself.
OPTION 1: Restart your computer
Before trying anything else please restart your computer and attempt the switch to Multi-User Mode again. Sometimes the simple act of restarting the computer will help to correct the trouble you’re having. If that does not work please move on to option 2 (as below).
OPTION 2: Attempt re-installing SQL Server
To correct the issue please attempt the following:
1. Uninstall SQL Server via the Windows Control Panel. From the program list, uninstall everything start with Microsoft SQL Server > then Restart your computer.
2. Go to this directory:
32-bit Windows: C:Program FilesMicrosoft SQL Server
64-bit Windows: C:Program Files (x86)Microsoft SQL Server
If this directory doesn’t exist, skip to the next step.
If there are MSSQL.1 AND MSSQL.2 (or more), skip to next step.
If there’s only one called MSSQL.1, and no MSSQL.2, etc., then delete the files in these two folders:
32-bit Windows: C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLData
C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLTemplate Data
64-bit Windows: C:Program Files (x86)Microsoft SQL ServerMSSQL.1MSSQLData
C:Program Files (x86)Microsoft SQL ServerMSSQL.1MSSQLTemplate Data
3. Go the start menu and type “regedit”, hit enter (this will open the registry editor). Go to:
HKEY_LOCAL_MACHINE/Software/Microsoft/MSSQLServer
Rename this folder by right clicking and add “backup” to the end, then close the registry.
4. Follow these steps to install SQL Server separately (please skip step 0) then restart inFlow:
https://onpremise.inflowinventory.com/software-support.aspx#/article/21247283
5. When you restart the program you will be prompted to click the “Fix the Problem for me” button. Please do and when prompted enter a new password for the database (123456 should be fine).
6. Once the program has reloaded try switching to Multi-user mode again.
If you’re still having trouble please do let us know (support@inflowinventory.com) and any screenshots of error messages you can provide would also be helpful!
