Small width layout Medium width layout Maximum width layout Small text Medium text Large text
     Search
Downloads Downloads Directory Directory Forums Forums Forge Forge Blogs Blogs        Marketplace Marketplace Careers Program Careers
Community › Forums Register  |  

PortalWebHosting
  Ads  
OnyakTech
 


  Sponsors  

Meet Our Sponsors

The Official Microsoft ASP.NET Website
Portal Webhosting - Hosting For Developers
Red-Gate Software
MaximumASP
SourceGear - Tools for Developers
.: CounterSoft :.
 


DotNetNuke Forums
 
  Forum  DotNetNuke® Pro...  Media Module [L...  Trouble with Database
Previous Previous
 
Next Next
New Post 10/29/2007 12:44 PM
Resolved
User is offline fegimedia
3 posts
10th Ranked


Trouble with Database 

Hello,

I've uninstalled the media module built-in with DotNetNuke 4.62 for an error. Now I've reinstalled it but I get this error saying that it couldn't access with the user 'NT AUTHORITY\NETWORK SERVICE' .... I'm getting mad with this. I've set up the database with all the right authorities but it still give me this error.

I'm using SQL Express 2005 and IIS6 on Win2003Server and this is my connection string:

<add name="SiteSqlServer" connectionString="Server=DATSERVER\SQLExpress;Database=DATABASE;uid=sa;pwd=passw0rd; Trusted_Connection=True;" providerName="System.Data.SqlClient" />

I hope that someone can help!!!

Thanks in advance.

 

 

 
New Post 10/29/2007 5:34 PM
User is offline Sebastian Leupold
15228 posts
www.deutschnetnuke.de
1st Ranked












Re: Trouble with Database 

the connection string is used to access the database, but Network Service is used for accessing files in the installation directory and needs full access to all files and subfolders


Sebastian Leupold

DeutschNetNuke dnnWerk - The DotNetNuke Experts German DotNetNuke User-Group

DotNetNuke Project UserDefinedTable
DotNetNuke Project Release Tracker
 
New Post 10/30/2007 2:02 AM
Accepted Answer 
User is offline fegimedia
3 posts
10th Ranked


Re: Trouble with Database 

Hi and thanks for the answer!

Anyway I couldn't solve my problem. I've checked all my permission on the folders and they seems to be ok. I noticed that the error is that it cannot open the preferred database. It says access failed and then Access failed for user NT AUTHORITY\NETWORK SERVICE.

Sorry If I explain this way but my .NET framework is in Italian. Anyway this is what it returns:

"DotNetNuke.Services.Exceptions.ModuleLoadException: Impossibile aprire il database utente predefinito. Accesso non riuscito. Accesso non riuscito per l'utente 'NT AUTHORITY\SERVIZIO DI RETE'. ---> System.Data.SqlClient.SqlException: Impossibile aprire il database utente predefinito."

Translated should be something like this:

"DotNetNuke.Services.Exceptions.ModuleLoadException: Cannot open the preferred user database. Access failed. Access failed for user 'NT AUTHORITY\NETWORK SERVICE'. ---> System.Data.SqlClient.SqlException: Cannot open the preferred user database."

Please help!!!!

 
New Post 10/30/2007 8:40 AM
User is offline fegimedia
3 posts
10th Ranked


Re: Trouble with Database 

Ok I've solved my problem!!!

It was just a permission problem on my Database! So I've been setting all permissions to NT AUTHORITY\NETWORK SERVICE making it the dbo.

Now everything works great. Thanks to everyone and I hope this will be useful to everyone will need it.

 
Previous Previous
 
Next Next
  Forum  DotNetNuke® Pro...  Media Module [L...  Trouble with Database
 


Forum Policy

These Discussion Forums are dedicated to the discussion of the DotNetNuke Web Application Framework.

For the benefit of the community and to protect the integrity of the project, 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 DotNetNuke.
2. Discussion or promotion of DotNetNuke product releases under a different brand name are strictly prohibited.
3. No Flaming or Trolling.
4. No Profanity, Racism, or Prejudice.
5. Site Moderators have the final word on approving/removing a thread or post or comment.
6. English language posting only, please.

 


AfterImage Internet Consulting and SEO Services
AfterImage provides search engine optimization (SEO), Internet consulting and hosting services for the Windows platform (IIS, ASP, SQL Server).
www.afterimage.nl/
Alki Homes - Seattle, WA
Exemplary service for your Seattle Real Estate needs. It's what you deserve from your Realtor®!
www.alkihomes.com
Swanzey Internet Group LLC
DotNetNuke design, development, e-Commerce, hosting, maintenance, and training. Exclusively DotNetNuke.
www.swanzey.com

DotNetNuke Corporation   Terms Of Use  Privacy Statement
DotNetNuke®, DNN®, and the DotNetNuke logo are trademarks of DotNetNuke Corporation
Hosted by MaximumASP