Products

Solutions

Resources

Partners

Community

Blog

About

QA

Ideas Test

New Community Website

Ordinarily, you'd be at the right spot, but we've recently launched a brand new community website... For the community, by the community.

Yay... Take Me to the Community!

Welcome to the DNN Community Forums, your preferred source of online community support for all things related to DNN.
In order to participate you must be a registered DNNizen

HomeHomeGetting StartedGetting StartedInstalling DNN ...Installing DNN ...Problem with user ASPNET after installing and running DNN 4.0.3Problem with user ASPNET after installing and running DNN 4.0.3
Previous
 
Next
New Post
5/31/2006 9:45 AM
 
Hi to everyone!
I've installed correctly and running DNN 4.0.3 using WIN XP SP2,
SQL Server Express 2005, VWD, IIS5.1 and the starter kit.
The user ASPNET has any file permissions to database file,
is local Administrator on the computer.
Sometimes (and I underline it!), when I navigate to the web site as a simple user or the host user, the server report this error for MYCOMPUTER\ASPNET:
Error Installing DotNetNuke
Current Assembly Version: 04.00.03
ERROR: Could not connect to database specified in connectionString for SqlDataProviderSystem.Data.SqlClient.SqlException.
As  I see in this forum, this error is usually bind when the installation of DNN failed...
The database (Database.mdf) owner is dbo...So I try to add a new db owner (MYCOMPUTER\ASPNET),
but when I use Sql server Management studio, it doesn't view Database.mdf. Why?
Have you other solution to my occasionally problem?
Help me please,
thank you very much
Cristina
 
New Post
5/31/2006 11:27 PM
 

Hi,

1. was the initial installation of DNN completely successful ?

2. you are using SQL Express, by default the database will not appear in the Management Studio, you would need to use the "Attach" database function of the MS.

3. give +r+w permissions to your root DNN folder using windows explorer. (ex: c:\inetpub\wwwroot\DNN)

4. "Could not connect to database specified in connectionString for SqlDataProviderSystem" -- did your set the correct connection string in the web.config, there are 2 places to do this AND there are also connection strings for SQL Server

Here's a sample of the Express Settings:

  <!-- Connection String for SQL Server 2005 Express -->
    <add name="SiteSqlServer" connectionString="Data Source=.\SQLExpress;Integrated Security=True;uid=DNNUser;pwd=00000000;User Instance=True;AttachDBFilename=|DataDirectory|DATABASE.mdf;" providerName="System.Data.SqlClient"/>
  </connectionStrings>

 <appSettings>
  <!-- Connection String for SQL Server 2005 Express -->
  <add key="SiteSqlServer" value="Data Source=.\SQLExpress;Integrated Security=True;uid=DNNUser;pwd=00000000;User Instance=True;AttachDBFilename=|DataDirectory|DATABASE.mdf;"/>

5. take a look at www.traincert.net, there is a very good step-by-step video installation tutorial that may help you.

HTH,

Johnny

 

 

 
New Post
6/1/2006 5:33 AM
 

Hi sticcino,

thank you so much for your fast response...

Now you will hate me...

My problems doesn't stop ...

1) Yes the installation complete successufly

2) Thank you for this suggestion..now I see in MS my DNN's database..

3)Yes..yes..

4)This is my settings in web.config:


<add name="SiteSqlServer"

         connectionString="Data Source=.\SQLExpress;Integrated Security=True;

         uid=LAPDM\ASPNET;pwd=;User Instance=True;AttachDBFilename=|DataDirectory|Database.mdf;"

         providerName="System.Data.SqlClient" />

  

  </connectionStrings>

  <appSettings>

    <!-- Connection String for SQL Server 2005 Express - kept for backwards compatability - legacy modules   -->

    <add key="SiteSqlServer"

         value="Data Source=.\SQLExpress;Integrated Security=True;

         uid=LAPDM\ASPNET;pwd=;User Instance=True;AttachDBFilename=|DataDirectory|Database.mdf;" />


In MS, LAPDM\ASPNET user hasn't a password...(I don't know where this passw can be set.. ) and i haven't specified in connection string and appsettings...

So, after your suggestion and the traincert's video i build the site and start without debugging....

The response is very very drammactically...


Server Application Unavailable

The web application you are attempting to access on this web server is currently unavailable.  Please hit the "Refresh" button in your web browser to retry your request.

Administrator Note: An error message detailing the cause of this specific request failure can be found in the application event log of the web server. Please review this log entry to discover what caused this error to occur.


What is this?????
I've tried to detect this error eliminating the LAPDM\ASPNET as a user of the database in MS, and MS block me because LAPDM\ASPNET is set to be a db_owner and this setting could not be clean..
Excuse me...help me..
Cristina

 
New Post
6/1/2006 8:47 PM
 

Hi,

ok, you don't want to use the LAPDM\ASPNET for your login account to the DB.

- in SQL Management Studio, in your DB,create a user login called DNNUser (you can create one specific to you later) and also give it a password

so, you will create a [security]-[Login] called DNNUser using SQL Server Authentication, give it a password also.

assign this user to your login at the bottom of the screen. Click OK

Under your database - [Security]-[Users], create a new login using the above DNNUser as the "login" name, default schema is db_owner... click ok and save everything

- with windows explorer, give [Change] permissions to your DNN Directory (ex: c:\inetpub\wwwroot\dnn)

in your web.config

Change: uid=LAPDM\ASPNET;pwd=;

TO: uid=dnnuser;pwd=MYPASSWORD, in both locations

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

this video basically explains the above in greater detail

http://www.traincert.net/LinkClick.aspx?link=DotNetNuke3_1_Installation_And_Configuration.zip&tabid=1&mid=458

 see if this helps you, let me know if you need more help

Johnny

 

 

 

 

 
New Post
6/5/2006 8:02 AM
 
    Hi Johnny,
the problem persist after your suggestion...
I haven't touched anything in the IIS, what is the event log file of the application?
I'm disperate to such point that I've tried to construst a new web site with the starter kit template.. and the problem of "server application unavailable" persist...
The video is greater but it doesn't reply to my problem..
Can you help (one more time, excuse me) me?
Thank you very much, please forgive me..
 
Previous
 
Next
HomeHomeGetting StartedGetting StartedInstalling DNN ...Installing DNN ...Problem with user ASPNET after installing and running DNN 4.0.3Problem with user ASPNET after installing and running DNN 4.0.3


These Forums are dedicated to discussion of DNN Platform and Evoq Solutions.

For the benefit of the community and to protect the integrity of the ecosystem, please observe the following posting guidelines:

  1. No Advertising. This includes promotion of commercial and non-commercial products or services which are not directly related to DNN.
  2. No vendor trolling / poaching. If someone posts about a vendor issue, allow the vendor or other customers to respond. Any post that looks like trolling / poaching will be removed.
  3. Discussion or promotion of DNN Platform product releases under a different brand name are strictly prohibited.
  4. No Flaming or Trolling.
  5. No Profanity, Racism, or Prejudice.
  6. Site Moderators have the final word on approving / removing a thread or post or comment.
  7. English language posting only, please.
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out