MSSQL-config

From OpenSimulator

(Difference between revisions)
Jump to: navigation, search
(New page: 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...)
 
Line 1: Line 1:
 +
__NOTOC__
 +
{{Template:Quicklinks}}
 +
<br />
 +
 
To download MSSQL 2008 Express edition: [http://www.microsoft.com/Sqlserver/2008/en/us/express.aspx]
 
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.  
 
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.  

Revision as of 15:37, 21 May 2009


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.


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.

Personal tools
General
About This Wiki