|
|
| (One intermediate revision by one user not shown) |
| Line 1: |
Line 1: |
| − | __NOTOC__
| + | #Redirect [[Database Settings]] |
| − | {{Template:Quicklinks}}
| + | |
| − | <br />
| + | |
| − | | + | |
| − | To download MSSQL 2008 Express edition: [http://www.microsoft.com/Sqlserver/2008/en/us/express.aspx]
| + | |
| − | Make sure you download SQL Express 2008 with tools ([http://www.microsoft.com/downloads/details.aspx?FamilyId=7522A683-4CB2-454E-B908-E805E9BD4E28&displaylang=en]) 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.
| + | |
| − | | + | |
| − | | + | |
| − | In OpenSim.ini:
| + | |
| − | | + | |
| − | storage_plugin = OpenSim.Data.MSSQL.dll
| + | |
| − | storage_connection_string = "Data Source=servername\sqlexpress;Database=OpenSim;User=adminuser;password=password;";
| + | |
| − | | + | |
| − | inventory_plugin = OpenSim.Data.MSSQL.dll
| + | |
| − | inventory_source = "Data Source=servername\sqlexpress;Database=OpenSim;User=adminuser;password=password;";
| + | |
| − | | + | |
| − | userDatabase_plugin = OpenSim.Data.MSSQL.dll
| + | |
| − | user_source = "Data Source=servername\sqlexpress;Database=OpenSim;User=adminuser;password=password;";
| + | |
| − | | + | |
| − | asset_database = "grid"
| + | |
| − | asset_plugin = OpenSim.Data.MSSQL.dll
| + | |
| − | asset_source ="Data Source=servername\sqlexpress;Database=OpenSim;User=adminuser;password=password;";
| + | |
| − | | + | |
| − | You can now run all OpenSim servers using these settings, and when prompted for the individual servers (user, grid, asset, inventory, messaging) you will need to re-enter that connection string when prompted.
| + | |
