Scroll to the top of the Other options list. However, after removing one instance of 2008 R2. I uninstalled everything I could using the windows installer (control panel-> programs and features). It had several versions of SQL server installed, including multiple instances of SQL server 2008 R2. The Database Properties dialog is displayed. I have a server with Windows Server 2008 R2.

In SQL Server Management Studio, right-click the database then select Properties. In SQL Server Management Studio, right-click Security > Logins then select New Login.Įnter the username (for example, papercut).Īfter creating the PaperCut NG/MF database, assign this user db_owner permissions on the database, so that it can create the required database tables. PaperCut NG/MF requires a user to connect to the database. Restart the Microsoft SQL Server service using either the standard service control panel or the SQL Server tools. In SQL Server Management Studio, right-click the instance of SQL Server to configure then select Properties.Ĭhange the Server Authentication to SQL Server and Windows Authentication mode. PaperCut NG/MF requires SQL Server authentication to be enabled on the instance of SQL Server. If the connection requires additional properties (not expected, based on what we know), you can find them here: Database.driver=.SQLServerDriverĭatabase.url=jdbc:sqlserver:// serverName: portNumber databaseName= databasename socketTimeout=600000

Sql server versions