PrintBOS Settings: Connecting to SQL Using SQL User Authentication

1. Configure SQL Server and Add a User

Follow these steps to configure SQL Server and create a user for PrintBOS:

1. Open SQL Server Management Studio (SSMS).
2. Navigate to Security > Logins and add a new user.
3. Assign appropriate roles (e.g., db_owner) for the PrintBOS database.

2. Add Database User in PrintBOS AdminTools

Once the SQL user is created, you need to configure it in PrintBOS:

1. Open PrintBOS AdminTools.
2. Go to the Database User section.
3. Add the previously created SQL user and provide the required credentials.

3. Modify the Connection String

Update the connection string in PrintBOS to use the new SQL user authentication:

1. Go to the PrintBOS configuration file or admin settings.
2. Update the connection string to include the SQL user's credentials.

4. Examples for SQL Connections

4.1 SQL Connection Using DSN

DSN=PrintBOS;PB_USE_SCHEMA=dbo;PB_DB_USER=DB_USER;
    

4.2 SQL Connection Without DSN

Driver={SQL Server};Server=localhost\sqlexpress;Database=PrintBOS;PB_DB_USER=DB_USER;PB_USE_SCHEMA=dbo;
    

5. Conclusion

By following the steps above, you can configure PrintBOS to connect to SQL Server using SQL user authentication. Ensure all connection strings are tested and verified to avoid runtime errors.