Installation guide

After this, follow the instructions that appear on the screen to complete the
setup.
3. Validating the network connection
As SQL Server 2008 R2 Express permits only the local client connection by default,
you need to enable the network connection.
In addition, SQL Server Browser must be started and Firewall exceptions must be
created.
Reference: Refer to the following site for more details.
http://support.microsoft.com/kb/914277/en-us
4. Creating a database
Run the following command on the Command Prompt window. Always use pvminf
as the database name used as the configuration database.
E.g.1)
> sqlcmd -E -S (local)\SSCCMDB -Q "create database pvminf"
E.g.2)
> sqlcmd -E -S (local)\SSCCMDB
1> create database pvminf
2> go
5. Restarting the service
Click the Start menu, and click Control Panel. From Control Panel, double-click
Administrative Tools. From Administrative Tools, and double-click Services to
start the Services Snap-in on the SERVER1.
Right-click the following service and click Restart.
Displayed Name: SQL Server (SSCCMDB)
Service Name: MSSQL$SSCCMDB
6. Transferring the database to the SERVER1
Restore the file backed up in the procedure 1.
Put the backup file on the local disk on the SERVER1 in advance. In the following
example, the name of the backup file is set as C:\temp\backup.dat.
E.g.1)
> sqlcmd -E -S (local)\SSCCMDB -Q "restore database pvminf
from disk = 'C:\temp\backup.dat' with replace"