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
  Need Help?  
Professional technical support for DotNetNuke is available from DotNetNuke Corporation.
 


  Ads  
OnyakTech
 


  Sponsors  

Meet Our Sponsors

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


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

 


Software Development and Integration with DNN
HNP Solutions focuses on the pragmatic use of technology and process to meet an organization's business objectives. HNP Solutions employs seasoned Enterprise and Solution Architects, Delivery Managers and QA & Business Leads. Our capabilities range from project assessments & recommendations, design & code reviews, to full program implementations. We also work with organizations in need of senior staff augmentation purposes in the areas of Enterprise and Solution architecture.
www.hnpsolutions.com
Alki Homes - Seattle, WA
Exemplary service for your Seattle Real Estate needs. It's what you deserve from your Realtor®!
www.alkihomes.com
PointClick DotNetNuke Solutions
PointClick Technologies provides high-end DNN Hosting for businesses.
PointClick.Net Hosted Solutions

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