Overview<\/h3>\n\nSQL Server<\/i> does not allow to create a new database with certain privilege settings on the operating system.<\/p>\n
This document explains what changes are required on a computer on which SQL Server Service<\/i> is running, so that the TopTeam Database<\/i> installer or TopTeam Schema<\/i> upgrade works.<\/p>\n<\/div><\/div>\n\nWho should read this? <\/h3>\n\n\n- Database Administrators<\/li>\n
- TopTeam Application Server Administrators<\/li>\n<\/ul>\n<\/div><\/div>\n\n
Step 1. Start the TopTeam SQL Server Database installer<\/h3>\n\n![\"wpid2600-media_1281163107996.png\"](\"data:image\/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==\")
\n<\/div>\n\nCreate Database<\/i> raises the following error in certain scenarios. How to resolve it is described below.<\/p>\n
NOTE:<\/strong> The folder path that you are specifying here should exist on the computer on which SQL Server Service<\/i> is running because this file is created on a computer on which SQL Server<\/i> is installed, and not on the computer from on which you are running the TopTeam SQL Server DB Schema<\/i> installer.<\/p>\n<\/div><\/div>\n\nExample Error<\/h3>\n\n\n<\/div>\n\nAbove is the error that is raised if SQL Server Service<\/i> on the database server doesn’t have sufficient privileges to create files in the specified folder.<\/p>\n<\/div><\/div>\n\nStep 2. Open Properties of SQL Server Service from Windows Control Panel<\/h3>\n\n\n<\/div>\n<\/p><\/div>\n\nStep 3. Navigate to the Log On page<\/h3>\n\n\n<\/div>\n\nChange the Log on<\/strong><\/i> <\/strong>as <\/strong>option as shown in the above screenshot. Click OK<\/strong><\/i> to make the changes permanent.
\nOr,
\nChoose the This account<\/strong> <\/i>option and specify Administrator Username and Password.<\/p>\n<\/div><\/div>\n\nStep 4. Now run the TopTeam Database Schema installer for SQL Server<\/h3>\n\nYou should be able to create SQL Server Database<\/i> for TopTeam<\/i> now.<\/p>\n
If you are still not able to create the database, then try the following option.<\/p>\n<\/div><\/div>\n
\nStep 5. Create a new database from SQL Server Management Studio<\/h3>\n\nAsk your SQL Server Database Administrator<\/i> to create an empty database using SQL Server Server Management Studio<\/i> or any similar tool.<\/p>\n<\/div><\/div>\n\nStep 6. Choose the following option in the TopTeam Database Schema installer and click Next<\/h3>\n\n\n<\/div>\n\nThe next page will allow you to select the database where you want to install TopTeam Database Objects<\/i> (Tables, Triggers, etc).
\nChoose the database that you have created in the above step.
\nClick Next<\/i> to continue to install TopTeam SQL Server Database Schema.<\/i><\/p>\n<\/div><\/div>\n
SQL Server<\/i> does not allow to create a new database with certain privilege settings on the operating system.<\/p>\n
This document explains what changes are required on a computer on which SQL Server Service<\/i> is running, so that the TopTeam Database<\/i> installer or TopTeam Schema<\/i> upgrade works.<\/p>\n<\/div><\/div>\n Create Database<\/i> raises the following error in certain scenarios. How to resolve it is described below.<\/p>\n NOTE:<\/strong> The folder path that you are specifying here should exist on the computer on which SQL Server Service<\/i> is running because this file is created on a computer on which SQL Server<\/i> is installed, and not on the computer from on which you are running the TopTeam SQL Server DB Schema<\/i> installer.<\/p>\n<\/div><\/div>\n Above is the error that is raised if SQL Server Service<\/i> on the database server doesn’t have sufficient privileges to create files in the specified folder.<\/p>\n<\/div><\/div>\n Change the Log on<\/strong><\/i> <\/strong>as <\/strong>option as shown in the above screenshot. Click OK<\/strong><\/i> to make the changes permanent. You should be able to create SQL Server Database<\/i> for TopTeam<\/i> now.<\/p>\n If you are still not able to create the database, then try the following option.<\/p>\n<\/div><\/div>\n Ask your SQL Server Database Administrator<\/i> to create an empty database using SQL Server Server Management Studio<\/i> or any similar tool.<\/p>\n<\/div><\/div>\n The next page will allow you to select the database where you want to install TopTeam Database Objects<\/i> (Tables, Triggers, etc).Who should read this? <\/h3>\n
\n
Step 1. Start the TopTeam SQL Server Database installer<\/h3>\n
\n<\/div>\n
Example Error<\/h3>\n
\n<\/div>\n
Step 2. Open Properties of SQL Server Service from Windows Control Panel<\/h3>\n
\n<\/div>\n<\/p><\/div>\n
Step 3. Navigate to the Log On page<\/h3>\n
\n<\/div>\n
\nOr,
\nChoose the This account<\/strong> <\/i>option and specify Administrator Username and Password.<\/p>\n<\/div><\/div>\nStep 4. Now run the TopTeam Database Schema installer for SQL Server<\/h3>\n
Step 5. Create a new database from SQL Server Management Studio<\/h3>\n
Step 6. Choose the following option in the TopTeam Database Schema installer and click Next<\/h3>\n
\n<\/div>\n
\nChoose the database that you have created in the above step.
\nClick Next<\/i> to continue to install TopTeam SQL Server Database Schema.<\/i><\/p>\n<\/div><\/div>\n