# Database Setup for SQL Server

This topic provides the steps that need to be performed by the individual responsible for the administration of SQL Server to setup the database for PDFKeeper.

Note, this topic only provides instructions for performing the setup on the same computer as SQL Server. This requires PDFKeeper to be installed on the same computer as SQL Server to perform the database setup. As an alternative, you can copy SqlServerDatabaseSetup.sql from %LOCALAPPDATA%\Programs\PDFKeeper to the computer hosting SQL Server.

Perform the following steps on the same computer as SQL Server while logged in as the same user that installed SQL Server:

1. Open a Command Prompt.

2. Execute sqlcmd -S localhost\<Instance Name> -i <ABSOLUTE_PATH>\SqlServerDatabaseSetup.sql

- Replace <Instance Name> with the instance name of the SQL Server Database Engine you want to connect to. For SQL Server (not Express), do not specify -S localhost\<Instance Name> if you accepted the default instance name MSSQLSERVER during the installation of SQL Server. For SQL Server Express, you can specify sqlexpress if you accepted the default instance name during the installation of SQL Server Express.

- Replace <ABSOLUTE_PATH> with %LOCALAPPDATA%\Programs\PDFKeeper if PDFKeeper is installed on the same computer as SQL Server or the folder path where SqlServerDatabaseSetup.sql was copied to.