MSSQL-config - Revision history

Makopoppo: Redirecting to Database Settings

2011-05-28T07:10:38Z

Redirecting to Database Settings

Fritigern at 09:38, 23 November 2010

2010-11-23T09:38:59Z

Justincc at 00:45, 19 June 2010

2010-06-19T00:45:03Z

Ideia Boa at 22:37, 21 May 2009

2009-05-21T22:37:24Z

StrawberryFride: 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...

2009-03-22T21:00:39Z

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...

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/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.

← Older revision		Revision as of 09:38, 23 November 2010
Line 15:		Line 15:

	See the instructions in OpenSim.ini and the .ini files in bin/config-include for instructions on how to connect OpenSim 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.
		+
		+
		+
		+	[[Category:Database]]

← Older revision		Revision as of 22:37, 21 May 2009
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.

@@ 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.
-−
-See the instructions in OpenSim.ini and the .ini files in bin/config-include for instructions on how to connect OpenSim to the database.
-−
-−
-−
-[[Category:Database]]

@@ 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.
+See the instructions in OpenSim.ini and the .ini files in bin/config-include for instructions on how to connect OpenSim 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.