Windows stand-alone: Create SQL Server databases manually
- To work with SQL Server, we use Microsoft SQL Server Management Studio...
Start menu | All Programs | Microsoft SQL Server 2008 R2 | SQL Server Management Studio
In the Connect to Server dialog box, verify the default settings, and then click Connect. To connect, the Server name box must contain the name of the computer where SQL Server is installed. If the Database Engine is a named instance, the Server name box should also contain the instance name in the format \.
SQL Server Management Studio is not installed by default. If Management Studio is unavailable, install it by running Setup. Management Studio is not available with SQL Server Express. Management Studio Express is available as a free download from the Microsoft Download Center.
- 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 Planning for SQL Server
- On the Options page, select Collation Name from the drop-down list. 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.
- Increase transaction log size