Windows stand-alone: Create databases manually
Use this alternative method for creating databases if you have problems running the create-database task that is documented for setting up a remote SQL Server database on Windows™ for a stand-alone production server.
Before you begin, create the databases.
Prerequisites
Install SQL Server
Modify SQL Server database properties
- Expand the nodes to see Databases.
- Right-click Databases to see New database.
- Enter the database name. For information on the recommended database architecture and the databases you will need to create, see Plan for SQL Server
- On the Options page, select Collation Name from the drop-down list that matches environment. Set the collation to case-sensitive. For example, on an English system: SQL_Latin1_General_CP1_CS_AS
For LikeMinds, CI is the default setting; however, CS can also be used.
- Click OK to save the database changes.
Parent
Set up a remote SQL Server database
Previous
Modify SQL Server database properties
Next topic
Set up SQL Server automatically or manually