You need to Register for free and Login to post a message in the forum.

Forum

Forums > Users Lounge > DNN Creative Articles
Subject: Issue 32 - Powerful Efficient Techniques for DotNetNuke Administration using SQL
Prev Next
You are not authorized to post a reply.

Author Messages
leesykes
DNN Creative Staff
Nuke Master III
Nuke Master III
Posts:3325
10 Oct 2008 8:01 AM  
Hello Lee,

First, let me say that I love your videos and this is my second year with your magazine.
Your instructions are clear, with details and cover all aspects of the subjects you cover.
You saved me a lot of time and I really appreciate it.

I have a problem with
Issue 32 - Powerful Efficient Techniques for DotNetNuke Administration using SQL
Introduction to SQL Queries with SQL Server Express, DotNetNuke and Vista
I work with Windows XP Pro.
I followed your instructions.
I attached my local DNN484 database to MSSQL Express server.
When I run my local DNN484 I get the following error:
Cannot open user default database. Login failed.
Login failed for user 'USER-2595F5A09E\ASPNET'.
I attached here a screen capture of the error.

Do you know what is wrong? Can you help?

Sincerely,
Nir Petrank


Hello,

Glad to hear you find the videos useful, it is always good to hear.

This problem may be related to your setup of SQL Server, have you previously installed a localhost installation of DotNetNuke to your computer and successfully got it running?

Your problem that may be related to the server authentication mode, it needs to be set to 'SQL server and Windows authentication' mode rather than 'Windows authentication'

I discussed how to fix this problem in this forum post SQL Server authentication mode

Thanks,
Lee Sykes
Site Administrator
Subscribe to the website : DotNetNuke Video Tutorials : The Skinning Toolkit : DotNetNuke Podcasts

Twitter: www.twitter.com/leesykes

Lee Sykes's Facebook Profile
nirpet
DNN Creative Magazine Subscriber
Nuke Newbie
Nuke Newbie
Posts:4
10 Oct 2008 10:11 AM  

Hello Lee,

I worked with my locallhost DNN installation before I worked with your videos. I checked some DNN modules on this installation. It worked well.

I have checked my MSSQL Server Express authentication and it is already set to "SQL Server and Windows authentication" mode. I restart my MSSQL Server to make sure that the server run in this mode. But I still get:

Login failed for use 'USER-2595F5A09E\ASPNET'.

Pay attention to the fact that this is not the user that I configured in my web.config. This the ASPNET process which run all my local websites. The user I configured in web.config is "nirpet".

Nir
leesykes
DNN Creative Staff
Nuke Master III
Nuke Master III
Posts:3325
10 Oct 2008 11:43 AM  
not sure, could you post you web.config connection string for your local installation? anyone else any ideas?
Lee Sykes
Site Administrator
Subscribe to the website : DotNetNuke Video Tutorials : The Skinning Toolkit : DotNetNuke Podcasts

Twitter: www.twitter.com/leesykes

Lee Sykes's Facebook Profile
nirpet
DNN Creative Magazine Subscriber
Nuke Newbie
Nuke Newbie
Posts:4
11 Oct 2008 3:29 AM  
This is my web.config connection string:

Data Source=.\SQLExpress;Initial Catalog=C:\DOTNETNUKE SITES\DNN484\APP_DATA\DATABASE.MDF;User ID=nirpet;Password=xxxxxxxx

Nir
jncraig
DNN Creative Staff
Nuke Master II
Nuke Master II
Posts:2318
11 Oct 2008 8:51 AM  
Just to double-check: You have edited both connection strings?
Joe Craig
DNN Creative Support
Subscribe to the website
nirpet
DNN Creative Magazine Subscriber
Nuke Newbie
Nuke Newbie
Posts:4
11 Oct 2008 9:09 AM  

I checked it again after I saw your post.
The answer is Yes.
I have edited both connection strings.

Nir
leesykes
DNN Creative Staff
Nuke Master III
Nuke Master III
Posts:3325
13 Oct 2008 10:05 AM  

have you created the username + password access that you specified in the connection string for the database?
Lee Sykes
Site Administrator
Subscribe to the website : DotNetNuke Video Tutorials : The Skinning Toolkit : DotNetNuke Podcasts

Twitter: www.twitter.com/leesykes

Lee Sykes's Facebook Profile
You are not authorized to post a reply.
Forums > Users Lounge > DNN Creative Articles > Issue 32 - Powerful Efficient Techniques for DotNetNuke Administration using SQL


ActiveForums 3.7

Latest Forum Posts

RE: Reversing Limited Access to the Admin Menu by wynnjon
OK-So I've updated the TABS table entries in the database and set the previously modified entries (t...
RE: localhost Install issues by leesykes
If you go to the subscribe page and click on the get free trial button - this takes you to a page wh...
localhost Install issues by cdees
I've set up a local host and want to run DNN for a local development machine.  The host is set up; h...
RE: Reversing Limited Access to the Admin Menu by wynnjon
That is what I thought.  So for my clients that will need to manage user accounts, I can not limit t...
RE: Reversing Limited Access to the Admin Menu by leesykes
I seem to recall it doesn't work
RE: Reversing Limited Access to the Admin Menu by wynnjon
Thanks Lee-  I will give that a try.An additional question- If you place the "User Accounts" page un...
RE: Reversing Limited Access to the Admin Menu by leesykes
all you need to do is reverse the process within the SQL tables.Compare the data to the other rows i...
RE: Module not working when logged off. by leesykes
thanks for the info,
Reversing Limited Access to the Admin Menu by wynnjon
Hi!  I followed the tutorial for limiting the access to the admin menu.  What a great thing!However,...
RE: Trouble installing! Designer trying to be a Developer. by leesykes
glad to hear you found a solution, thanks,
RE: Skim Question by leesykes
You could but you will not be able to have an XHTML compliant page as the SolpartMenu is non-complia...
RE: Include in Menu - Weird Request by leesykes
For your sitemap.xml file - use GSiteCrawlerYou could create the site map before moving the sub menu...
RE: Trouble installing! Designer trying to be a Developer. by awright14
It looks like I had ASP installed in the wrong order.  Copying and pasting this into the Run Command...
RE: Need Help Changing Containers Contentpane's Text Color by leesykes
Hello,Have you tried adding a class to the content area of your container and then styling the p, a,...
RE: Vertical SolpartMenu by leesykes
hello,If you wish to display the admin and host menus within the house menu, you need to enable it i...
RE: Firefox Does Not Display WMV File In Media Module by leesykes
Hello,I have just tested this and I can play a wmv file in Firefox 3.0.3, so it does suggest that it...
RE: advice wanted convert site to DNN while keeping existing asp functionality by leesykes
You could try using the IFrame module in DotNetNuke and then just link the IFrame to the current pag...
RE: Need Help Changing Containers Contentpane's Text Color by CROKeefe
Thanks for the quick update... I know it looks broken right now, but I had the TITLE classes working...
RE: Need Help Changing Containers Contentpane's Text Color by leesykes
The default class for a container is .head so you will find that the .head class will override any s...
RE: Module not working when logged off. by t.ramya85
have to set the cache time to '0' in that module setting.
DotNetNuke Modules
RSS Feeds