MSSQL-config
From OpenSimulator
| Line 14: | Line 14: | ||
Navigate to the newly-created OpenSim database and go to the Security, then Users section. In there, create a new user, select your new admin account. In the default schema box, enter '''dbo''', in Schemas owned by this user, check the '''db_owner''' checkbox, in the Database role membership section, also check the '''db_owner''' box. Click OK and you should be ready to use that account to connect to the database. | Navigate to the newly-created OpenSim database and go to the Security, then Users section. In there, create a new user, select your new admin account. In the default schema box, enter '''dbo''', in Schemas owned by this user, check the '''db_owner''' checkbox, in the Database role membership section, also check the '''db_owner''' box. Click OK and you should be ready to use that account to connect to the database. | ||
| − | + | See the instructions in OpenSim.ini and the .ini files in bin/config-include for instructions on how to connect OpenSim to the database. | |
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
Revision as of 17:45, 18 June 2010
 |
Languages: |
|
To download MSSQL 2008 Express edition: [1] Make sure you download SQL Express 2008 with tools ([2]) since you will likely want a nice tool to work with your database.
You will need to enable Mixed Mode authentication on SQL Server.
Right-click on your database server in Management Studio and select Properties, then go to the Security tab and select SQL Server and Windows Authentication mode, click OK. Back in Management Studio, expand the Security node and in the Logins section right-click and create a new user, called whatever you like, select SQL Server authentication, give it a strong password, Click OK.
Right-click on the Databases node and and select New Database. Call it OpenSim, accept all defaults and click OK.
Navigate to the newly-created OpenSim database and go to the Security, then Users section. In there, create a new user, select your new admin account. In the default schema box, enter dbo, in Schemas owned by this user, check the db_owner checkbox, in the Database role membership section, also check the db_owner box. Click OK and you should be ready to use that account to connect to the database.
See the instructions in OpenSim.ini and the .ini files in bin/config-include for instructions on how to connect OpenSim to the database.
