Before you begin, you should be familiar with standard database maintenance procedures.
For more information about Microsoft SQL, see the following references:
The following database tool can be helpful:
To create a Microsoft SQL database:
Review the Microsoft SQL requirements listed in Section 2.2, Vibe 3.4 Server Requirements.
Make sure that the Microsoft SQL Server and Client have been installed and configured properly.
IMPORTANT:Make sure that TCP/IP is enabled for the Microsoft SQL Server.
For more information, see
Microsoft SQL Server.
Make sure that the Microsoft SQL database client is also installed on the Vibe server.
The Vibe installation program needs the Microsoft SQL client in order to communicate with the remote Microsoft SQL database server.
When you install Microsoft SQL Server, selectfor authentication.
The default is, which is not appropriate for Vibe.
Immediately establish the database administrator username and password for the SQL database server.
Change to the directory where you copied the database scripts in Step 4 in Section 13.1, Preparing to Manually Create a Database.
Enter the following command to run the Microsoft SQL database creation script:
osql -Uuser -Ppassword -i create-database-sqlserver.sql