Created By
DMG Development
As Seen On

Main Page  |  Forums  |  Register  |  Active Topics  |  Members  |  Search

 
Username:
Password:
DMG Forums >> DMG Forums Discussion >> Tutorials & HOWTO Articles >> Using MSDE or SQL Server Express 2005 With DMG Forums Page of 2
Using MSDE or SQL Server Express 2005 With DMG Forums
Author Topic
grimmeissen


Administrator


Join Date: 8/30/2005
Posts: 656
Location: Cincinnati, Ohio

Posted: 2/13/2006 2:23:58 PM

If you are a developer who is looking to utilize the features of DMG Forums in your environment but do not wish to set up a full SQL Server installation, we now offer support for MSDE or SQL Server Express 2005. These software products are FREE distributions from Microsoft for lightweight applications or for development environments and have been thoroughly tested as the back-end software for DMG Forums. This tutorial will explain how to set up MSDE or SQL Server Express in your environment and how to set up DMG Forums to connect to these data sources.

grimmeissen


Administrator


Join Date: 8/30/2005
Posts: 656
Location: Cincinnati, Ohio

Posted: 2/13/2006 2:24:44 PM

Microsoft SQL Server 2005 Express Setup

Before installing SQL Server or DMG Forums, be sure that the latest version of IIS is installed and a version of the Microsoft .NET Framework is installed. After these two items are on the machine, follow the steps below to install SQL Server Express.



Installing SQL Server Express 2005

1. Microsoft SQL Server Express 2005 can be downloaded from this location. Download the file SQLEXPR.exe.

2. Once the file is downloaded to a location on the computer that you wish to install on, run SQLEXPR.exe to begin the installation. Follow the prompts to install SQL Server Express.

3. When the following dialog box appears, be sure to set all Client Components to install.



4. When the following dialog box appears, check "Mixed Mode" and then type in a system admin password in the text boxes. Be sure to remember this password as it will be the SQL Server administrator account and will also be needed to install DMG Forums.



5. For any other dialog boxes just choose the default options.



Installing SQL Server Express Management Studio

1. Unlike MSDE, SQL Server 2005 Express does have a graphical interface for managing your databases. To download this software, click here. Download SQLServer2005_SSMSEE.msi.

2. Once the file is downloaded, run the MSI to begin the installation. Follow the prompts to install the management studio.

3. After installation, go to Start Menu -> Programs -> Microsoft SQL Server 2005 -> SQL Server Management Studio Express CTP. When the login dialog appears as shown in the picture below, select the Authentication dropdown and choose "SQL Server Authentication." Then type in "sa" as the login and your system admin password that you specified during installation as the password.



4. Right-click on the tab at the left that is titled "Databases." Click "New Database" in the menu that pops up. Give the database a unique name. Leave all other options default unless you are an experienced SQL administrator and then click the OK button to create the database.

5. Next move to the tab that is titled "Security." Expand the tree and right-click on "Logins." Click "New Login" to set up an account that will be used to read your database from DMG Forums. Choose a unique login name, then change the authentication to "SQL Server Authentication." Provide the account a password and be sure to remember it. Uncheck the box that says "Enforce password policy." Select the dropdown box that is titled "Default database" and choose the database that was created in the previous step.

6. Click the tab at the left that is titled "User Mapping." Check the box in the "Map" tab that is next to the database that you created in step 4. At the bottom of the screen check the boxes next to "db_datareader" and "db_datawriter" to give this account read/write access to your new database. Press OK to complete the account setup.



Installing DMG Forums

1. Download the latest version of DMG Forums and install it to a virtual directory on your server such as C:\inetpub\wwwroot\dmgforums. Make sure this directory is set up as an ASP.Net application in IIS.

2. Open the file web.config and set the Value of the DatabaseString line to "Provider=SQLOLEDB;Data Source=YOURSERVERNAME\SQLEXPRESS;database=YOURDATABASE;uid=sa;pwd=YOURSAPASSWORD;" where YOURSERVERNAME is the name of the computer, YOURDATABASE is the name you gave your database, and YOURSAPASSWORD is the system admin password you declared for SQL Server.

3. In a web browser open the file http://SERVERNAME/YourWebSite/setup.aspx and fill in the details for your installation. Be sure to remember the admin username and password. When all details are entered press Submit to install the forums.

4. After the confirmation screen appears, open web.config and change the UID to the username that you created in the SQL Server Management Utility and change the password to this account's password. Click the button that takes you to the default page and your forums should be up and running.

5. Be sure to delete the files setup.aspx, setup-update.aspx, and /bin/setup.dll from your web site after the installation is complete.

grimmeissen


Administrator


Join Date: 8/30/2005
Posts: 656
Location: Cincinnati, Ohio

Posted: 2/13/2006 3:34:27 PM

Microsoft SQL Server Desktop Edition (MSDE) Setup

Before installing SQL Server or DMG Forums, be sure that the latest version of IIS is installed and a version of the Microsoft .NET Framework is installed. After these two items are on the machine, follow the steps below to install MSDE.



Installing MSDE

1. MSDE can be downloaded from this location. Download the file MSDE2000A.exe.

2. Once the file is downloaded to a location on the computer that you wish to install on, run MSDE2000A.exe and unpack the setup files to a directory on your computer.

3. Open the command prompt and browse to the folder that you just unpacked all of the files to. Run the exact command shown below changing YOURSAPASSWORD to a unique password that you establish for your SQL Server system admin account.

setup.exe SAPWD="YOURSAPASSWORD" SECURITYMODE="SQL"


4. After the installation is finished, go to Control Panel -> Administrative Tools -> Services. Find the service named "MSSQLSERVER" and right click on it. Start the service. Make sure this service is set to start automatically.



Installing SQL Server Databases & User Accounts

MSDE does not have a user interface for creating databases or user accounts. During installation the "sa" account was already created with the password you specified, but the DMG forums database as well as the read/write user account still need to be created.

Starting with DMG Forums 2.0, we have provided a file named CreateDatabase.bat under the Database Setup folder. Place this file anywhere on the computer you have installed SQL Server on and browse to this location in a command prompt. From this location run the exact command below, replacing DBNAME with the name of the database you want to create, DBUSER with your chosen username, and DBPASS with your chosen password.

CreateDatabase.bat DBNAME DBUSER DBPASS


If your SQL server is set up correctly, this will create a new database as well as your read/write user account.



Installing DMG Forums

1. Download the latest version of DMG Forums and install it to a virtual directory on your server such as C:\inetpub\wwwroot\dmgforums. Make sure this directory is set up as an ASP.Net application in IIS.

2. Open the file web.config and set the Value of the DatabaseString line to "Provider=SQLOLEDB;Data Source=YOURSERVERNAME;database=YOURDATABASE;uid=sa;pwd=YOURSAPASSWORD;" where YOURSERVERNAME is the name of the computer, YOURDATABASE is the name you gave your database, and YOURSAPASSWORD is the system admin password you declared for SQL Server during the MSDE installation.

3. In a web browser open the file http://SERVERNAME/YourWebSite/setup.aspx and fill in the details for your installation. Be sure to remember the admin username and password. When all details are entered press Submit to install the forums.

4. After the confirmation screen appears, open web.config and change the UID to the username that you created using the CreateDatabase.bat file and change the password to this account's password. Click the button that takes you to the default page and your forums should be up and running.

5. Be sure to delete the files setup.aspx, setup-update.aspx, and /bin/setup.dll from your web site after the installation is complete.

GavinMannion


Newbie


Join Date: 7/27/2006
Posts: 3

Posted: 7/27/2006 3:11:44 AM

grimmeissen,

Can I change the Connection String to connect to a MySQL 5 database? Would you database sripts work in MySQL?

grimmeissen


Administrator


Join Date: 8/30/2005
Posts: 656
Location: Cincinnati, Ohio

Posted: 7/27/2006 10:05:25 AM

The forum code uses an OleDb connector by default, which is not natively supported by MySQL. However, there is a free MyOleDB adaptor out there if you can find it.

The application has not been tested with MySQL, but it is a project that is currently going on. If all goes well we could be seeing full MySQL support with the next release.

kherrerab


Newbie

Join Date: 10/23/2006
Posts: 4

Posted: 10/23/2006 7:14:10 PM

i'm running it on sql server 2005 but it trows an error whe you try to log in

http://www.nicadeportes.com/default.aspx


---------------------


The statement has been terminated.
The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.OleDb.OleDbException: The statement has been terminated.
The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value.

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

Stack Trace:

[OleDbException (0x80040e07): The statement has been terminated.
The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value.]
System.Data.OleDb.OleDbCommand.ExecuteReaderInternal(CommandBehavior behavior, String method) +764
System.Data.OleDb.OleDbCommand.ExecuteNonQuery() +108
DMGForums.Global.Database.Write(String strSql) +71
DMGForums.Global.Login.LoginUser(Object sender, EventArgs e) +1319
System.EventHandler.Invoke(Object sender, EventArgs e) +0
System.Web.UI.WebControls.Button.OnClick(EventArgs e) +104
System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument) +107
System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +7
System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +11
System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +33
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +5610





grimmeissen


Administrator


Join Date: 8/30/2005
Posts: 656
Location: Cincinnati, Ohio

Posted: 10/24/2006 9:00:16 PM

The error you are talking about has been addressed numerous times. Please check the link below.

http://www.dmgforums.com/topics.aspx?ID=96

bignides


Newbie

Join Date: 12/26/2007
Posts: 3

Posted: 12/26/2007 12:50:10 PM

While trying to install dmgforums using SQLExpress, I get the following error:

ERROR: There was a SQL error during setup. View the error message below and then Click Here to try again.

System.Data.Odbc.OdbcException: ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified at System.Data.Odbc.OdbcConnection.HandleError(OdbcHandle hrHandle, RetCode retcode) at System.Data.Odbc.OdbcConnectionHandle..ctor(OdbcConnection connection, OdbcConnectionString constr, OdbcEnvironmentHandle environmentHandle) at System.Data.Odbc.OdbcConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningObject) at System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(DbConnection owningConnection, DbConnectionPoolGroup poolGroup) at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) at System.Data.Odbc.OdbcConnection.Open() at DMGForums.Global.Database.Read(String strSql, Int32 Rows) at DMGForums.Setup.SQLSetup.Page_Load(Object sender, EventArgs e)

Anyone know what I'm doing wrong?
grimmeissen


Administrator


Join Date: 8/30/2005
Posts: 656
Location: Cincinnati, Ohio

Posted: 12/27/2007 3:21:38 PM

Oftentimes this is caused because SQL Express normally gets installed as an instance.

What are you putting as the Data Source in your SQL string? Typically it needs to be something like this.

Data Source=YOUR_SERVER_NAME\SQLEXPRESS
wansari


Newbie

Join Date: 1/2/2008
Posts: 1

Posted: 1/2/2008 4:25:42 PM

Hi All,

I am getting this error when i try to setp the database

ERROR: There was a SQL error during setup. View the error message below and then Click Here to try again.

System.Data.Odbc.OdbcException: ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified at System.Data.Odbc.OdbcConnection.HandleError(OdbcHandle hrHandle, RetCode retcode) at System.Data.Odbc.OdbcConnectionHandle..ctor(OdbcConnection connection, OdbcConnectionString constr, OdbcEnvironmentHandle environmentHandle) at System.Data.Odbc.OdbcConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningObject) at System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(DbConnection owningConnection, DbConnectionPoolGroup poolGroup) at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) at System.Data.Odbc.OdbcConnection.Open() at DMGForums.Global.Database.Read(String strSql, Int32 Rows) at DMGForums.Setup.SQLSetup.Page_Load(Object sender, EventArgs e)


Connection string is

<add key="DatabaseString" value="Provider=SQLOLEDB;Data Source=PCName\SQLEXPRESS;Initial Catalog=databasename;uid=****;pwd=****;" />

can you please help me

thanks



bignides


Newbie

Join Date: 12/26/2007
Posts: 3

Posted: 1/4/2008 9:05:10 AM

As you can see, wansari, I was having a similar problem. It only took me 2 weeks to fix but I think the problem lay with the provider value. I made DBstring "Driver={SQL Server};Server=PCNAME\SQLEXPRESS;etc..." and that seemed to fix the problem.
du5ty


Newbie


Join Date: 1/2/2008
Posts: 9

Posted: 1/16/2008 12:34:12 AM

hey i am having the same problem but i am using ms 2000 devloper edition

<add key="DatabaseString" value="Driver={SQL Server};Server=localhost;Database=XXXX;Uid=XXXX;Pwd=XXXX;" />

anything wrong with my statment?


NEWBI


Newbie

Join Date: 1/26/2008
Posts: 1

Posted: 1/26/2008 7:04:30 PM

3. In a web browser open the file http://SERVERNAME/YourWebSite/setup.aspx and fill in the details for your installation. Be sure to remember the admin username and password. When all details are entered press Submit to install the forums.


Hi, I installed everything until this point and now I am stuck here.
What is the step before #3.

I uploaded the file C:/Inetpub/wwwroot/DMG_FORUMS3-1 to my HELM hosting server under wwwroot.

I already edited my webconfig before uploading to my hosting:

<!-- Web.Config Configuration File -->

<configuration>
<system.web>
<compilation defaultLanguage="VB" debug="false" />
<pages validateRequest="false" />
</system.web>

<appSettings>
<add key="DatabaseString" value="Driver={SQL Server};Server=LIVESOURCE\SQLEXPRESS;Database=*************;Uid=sa;Pwd=***********;" />
<!-- Comment the SQL connection string and uncomment the two lines below for MySQL -->
<!-- <add key="DatabaseString" value="DRIVER={MySQL ODBC 3.51 Driver};SERVER=YOUR_SERVER;DATABASE=YOUR_DATABASE;UID=YOUR_USERNAME;PASSWORD=YOUR_PASSWORD;OPTION=3;" /> -->
<!-- <add key="DatabaseType" value="MySQL" /> -->
<add key="DatabasePrefix" value="DMG" />
<add key="LongDateFormat" value="MMMM d, yyyy" />
<add key="ShortDateFormat" value="M/d/yyyy" />
<add key="DateTimeFormat" value="M/d/yyyy h:mm:ss tt" />
</appSettings>

</configuration>




http://SERVERNAME/YourWebSite/setup.aspx????

I dont understand how to get here ???

http://LIVESOURCE/www.*********.com/setup.aspx ???

or am I supposed to use my hosting servername.

My hosting has allowed me to create a SQL 2005 user and password
connection: mssql.***********.com,1435

How is this used?

Ok Im newbie at this, but the file is installed in SQL exactly and IIS. I need to know the step to set up now.thanks

grimmeissen


Administrator


Join Date: 8/30/2005
Posts: 656
Location: Cincinnati, Ohio

Posted: 1/28/2008 10:45:53 AM

http://SERVERNAME/YourWebSite/setup.aspx

This is the URL on your server that you will need to use to access the site. If you have a domain name set up for your web page already, then you can use www.******.com/setup.aspx. If you are on the actual server, you can use http://LIVESOURCE/folder_name/setup.aspx where "folder_name" is changed to the directory on LIVESOURCE where your files are.

The SQL 2005 username/password are the credentials that you need to put into the "DatabaseString" for connection to the SQL database. If you know the "sa" credentials, use these first to run the setup, but then change to non-administrator credentials once the site is ready.
AugmentedReality


Newbie


Join Date: 4/8/2008
Posts: 6

Posted: 4/9/2008 11:18:02 PM

iam having the following problem when i try to run setup.aspx in browser..
Server Error in '/dmg_forum' Application.
Parser Error
Description: An error occurred during the parsing of a resource required to service this request. Please review the following specific parse error details and modify your source file appropriately.

Parser Error Message: Could not load type 'DMGForums.Setup.SQLSetup'.

Source Error:

Line 1: <%@ Page language="VB" Inherits="DMGForums.Setup.SQLSetup" %>
Line 2:
Line 3: <!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">

grimmeissen


Administrator


Join Date: 8/30/2005
Posts: 656
Location: Cincinnati, Ohio

Posted: 4/12/2008 11:01:15 AM

Quote:
Quoted From AugmentedReality:

iam having the following problem when i try to run setup.aspx in browser..
Server Error in '/dmg_forum' Application.
Parser Error
Description: An error occurred during the parsing of a resource required to service this request. Please review the following specific parse error details and modify your source file appropriately.

Parser Error Message: Could not load type 'DMGForums.Setup.SQLSetup'.

Source Error:

Line 1: <%@ Page language="VB" Inherits="DMGForums.Setup.SQLSetup" %>
Line 2:
Line 3: <!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">


This is unrelated to MSDE or SQL Express, but I'll answer anyway. The problem you are having is because the IIS virtual directory is not set up as an application. You must go into IIS and change this directory to an application before any ASP.NET code will work.
   Page of 2 Next »    Last »


  Copyright DMG Development DMG Forums 3.2