Newest KB Articles in Databases

How to configure the ASP.NET 2.0 Membership/Roles Provider to use SQL 2000 or SQL 2005?

Tue, 01 Jul 2008 17:43:15 GMT

The information in this article applies to:

ASP.NET 2.0
MS SQL 2000
MS SQL 2005

SUMMARY

This article describes how to configure the ASP.NET 2.0 Membership/Roles provider to use SQL 2000 or SQL 2005.

DETAILS

First you will need to create the database in HELM control panel to use with DotNetNuke. If you have purchased a DotNetNuke hosting package then you will already have a SQL Server database resource for you to utilize.

Now use the following steps to create the full Application Services database schema on our SQL Server database.
Open the command prompt on your local computer, and navigate to: C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727
Execute the command: aspnet_regsql.exe -S [DB Server Name] -U [DB login] -P [Password] -A all -d [Database name]
Currently, there is no management interface to manage the membership database besides using Visual Web Developer or creating your own application using the membership provider class.

Below is an example of how to configure Visual Web Developer to manage the membership database.

Create a web application in Visual Web Developer or Visual Studio 2005.
Open the web.config.
The default membership provider uses a connection string called "LocalSqlServer". Therefore, replace:
<connectionStrings/>

with

<connectionStrings>
<remove name="LocalSqlServer" />
<add name="LocalSqlServer" connectionString="Data Source=;Integrated Security=false;Initial Catalog=;User ID=;Password=" providerName="System.Data.SqlClient" />
</connectionStrings>

Save and close the web.config.
Go to Website menu, and run the ASP.NET Configuration tool. This will open the Web Site Administration tool.
In the Web Site Administration tool, go to the Security tab.
Click on "Select authentication type".
Select "From the internet". Click the Done button.
Create your admin roles and users.
Then create access rules.
Create a rule that applies to the "Anonymous users" with "Deny" permissions.
Create another rule that applies to the admin role you created with "Allow" permissions.
Your application is now ready to use the membership provider, and you can begin creating your login forms.

How can I secure my Access database on your servers?

Tue, 01 Jul 2008 17:42:03 GMT

The information in this article applies to:

Database Security

DETAILS

You have a /db/ or a /data/ folder above the wwwroot folder so that your access database cannot be downloaded via the web. *NOTE You will also be required to enable Parent Paths under 'Website Settings' in the control panel.

What databases are supported?

Tue, 01 Jul 2008 17:41:18 GMT

This information in this article applies to:

Database Support

DETAILS

We support the following database types:

Microsoft Access (mdb)
Microsoft Excel (xls)
Text (txt/csv)
Extensible Markup Language (xml)
Microsoft SQL Server 2000
Microsoft SQL Server 2005

Remote Connections for SQL Server 2005

Tue, 01 Jul 2008 12:30:48 GMT

Remote Connections to the MS SQL Server are enabled for all SQL Server 2005 instances.

HELM3 Accounts:
Connection information can be found within the Database Manager screen. to get to the Database Manager; Control Panel to, Domains, then select Database Manager.

Once in the Database Manager, select the database you wish to make a remote connection to. Notice the "Connection Information" field. This will be populated with the remote connection string and local connection strings you should be using.

DotNetPanel Accounts:
The connection information from within DotNetPanel can be found in the "Space Summary". To navigate to the space summary login to your DotNetPanel account and click on your space. On the next screen click the "Space Summary" link located on the right of the screen.

Please be aware that in order to connect remotely use SQL Server Management Studio 2005. Enterprise Manager is not supported and will fail if you try to connect to an SQL Server 2005 database.