Learn DNN / DotNetNuke

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

Forum

Forums
Search Forum
Advanced SearchTopicsPosts

Forums > Users Lounge > DNN Creative Articles

Issue 32 - Powerful Efficient Techniques for DotNetNuke Administration using SQL

Last Post 10/13/2008 10:05 AM by Lee Sykes. 6 Replies.

Sort:

Check this box to subscribe to this topic.	Prev Next
You are not authorized to post a reply.

Author

Messages

Lee Sykes
DNN Creative Staff

Nuke Master VI
Posts:4945

10/10/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/DNNCreative

Nir Petrank

Nuke Newbie
Posts:3

10/10/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

Lee Sykes
DNN Creative Staff

Nuke Master VI
Posts:4945

10/10/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/DNNCreative

Nir Petrank

Nuke Newbie
Posts:3

10/11/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

Joseph Craig
DNN MVP
Posts:11667

10/11/2008 8:51 AM
Just to double-check: You have edited both connection strings?

Joe Craig, Patapsco Research Group Complete DNN Support

Nir Petrank

Nuke Newbie
Posts:3

10/11/2008 9:09 AM
I checked it again after I saw your post. The answer is Yes. I have edited both connection strings. Nir

Lee Sykes
DNN Creative Staff

Nuke Master VI
Posts:4945

10/13/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/DNNCreative

You are not authorized to post a reply.

Forums > Users Lounge > DNN Creative Articles

Latest Forum Posts

Can you Run Xcode in Linux? by Aman Singh

Can you Run Xcode in Linux?

Can you Run Xcode in Linux? by Aman Singh

Can you Run Xcode in Linux?

Billed for subscription that was canceled by Ryan

I was just billed for a subscription that was canc eled / inactivetive how do I get a refund for th

Meta Title and Meta Description are not showing properly by DNN User

Hi, On my site the meta title and meta descriptions are not showing properly. It's showing the m

Search is not functioning properly by DNN User

Site: https://www.prv-engineering.co.uk/search If I search any item only the 1st option under sea

Search is not functioning properly by DNN User

Site: https://www.prv-engineering.co.uk/search If I search any item only the 1st option under sea

DNN Platform import site optio by Melanie Weaver

Is it possible to import site template in DNN Platform 8.0? We have internal Evoq Content 8.1 tha

Events Module for DNN V5? by Tugboat

Would anyone have a download link for the version 5.0.3 Events Module? Thanks!

"Ghost" TabID Number? by Tugboat

Hi! I have a portal instance with multiple child portals and on one of the child portals, there i

RE: DNN Load Testing by ayman sharkawy

Hi. Have you already implemented a site using the DNN . And how the performance of the site and its

Publish All Pages by NSUOK

I'm using DNN Evoq Content Basic 8.2.0. When I make the HTML Pro module display on all pages, I h

Simpler profile needed in 9.2.2 by Donald

We are upgrading a DNN 4.8.4 site to DNN 9.2.2. On 4.8.4, the top bar shows the user’s name. If yo

How to link from dnnmodal popup to web site page? by Donald

Hello all. I am using a dnnmodal.show popup. The popup works correctly, showing the content that I

RE: Document Collaboration by Nick Davern

That feature would be super beneficial for our needs as well! Does anyone have an update as to if th

RE: DNN 9.2, how to set default theme? by Andy Stephenson DNN Creative

you do that under "Manage/Themes". Note the highlight blue border around the default container and d

DNN 9.2, how to set default theme? by Donald

Please disregard, found Manage Themes I cannot find how to set a default portal theme in DNN 9.2

RE: Looking for DataSprings Dynamic Forms by Andy Stephenson DNN Creative

Your best chance would be to contact Chad Nash @ http://www.datasprings.com/

Looking for DataSprings Dynamic Forms by Jakir HM

Looking for DataSprings Dynamic Forms 3.4 for DNN 4.x 5.x for my site (https://themasters2018s.com/)

RE: Help with Cycle Image Carousel not displaying images by peter

I had the same problem with the Will Strohl Content Slider after upgrading to DNN 9.1 The above an

RE: Object reference not set to an instance of an object by Andy Stephenson DNN Creative

Check this one might be useful: http://www.dnnsoftware.com/answers/im-tryin-to-move-my-site-to-pr

Used
By

Testimonials

| The SoloCoder Podcast | Google | Privacy Statement | Terms Of Use