Creating multiple SQL database instances
Create SQL database instances using the SQL Server installation wizard. If you need to have only one database instance, you can skip this task.
Before you begin
Windows only: Complete these
steps for each instance that you plan to create:
- Create a new user and add it to the Administrators group.
- Remove the user account from the Users group.
- Grant rights to the new user:
- Click and enter secpol.msc.
- Expand Local Policies and click User Rights Assignment.
- Open each of the following rights, click Add User or Group and add the
new user:
- Act as part of the operating system
- Adjust memory quotas|Increase quotas for a process
- Create a token object
- Debug programs
- Lock pages in memory
- Log on as a service
- Replace a process level token
Tip: The new account uses the local system as the
domain.
About this task
For more information, go to the Microsoft™ SQL Server Developer Center to view the SQL Server documentation.
Procedure
To create SQL database instances, follow these steps:
- Run the SQL Server installation wizard. On the Instance Name panel of the installation wizard, select Named instance, and then specify a new instance name in the field.
- Edit your firewall configuration to allow the new instances to communicate through their listening ports.
- Ensure that Named Pipes is enabled in the SQL Server Network
Configuration for all instances. For more information, refer to your
SQL Server documentation. Notes:
- Use the same collation that you are using for the application databases; that is: Latin1_General_BIN. Ensure that the ancillary databases, such as the master, model, tempdb, and msdb databases, use that collation.
- For Authentication mode, use Mixed Mode (Windows™ Authentication and SQL Server Authentication).
- If you receive any warnings or errors from the System Configuration Check dialog, correct them from the SQL Server 2012 instance installation.