Products

Evoq Content Overview Content Creation Workflow Asset Management Mobile Responsive Personalization Content Analytics SEO Integrations Security Website PerformanceEvoq Engage Overview Community Management  Dashboard  Analytics  Member Profile Gamification Advocate Marketing Community Engagement  Ideas  Answers  Discussions  Groups  Wikis  Events Mobile ReadyDNN Support PackagesEvoq: CMS FeaturesEvoq OnDemandCompare DNN's CMS Products

Solutions

Content Management SystemMulti-Channel PublishingDigital MarketingOnline Community ManagementIntranet Software SolutionOur CustomersPrime

Resources

Test DrivesSchedule A DemoDocumentation CenterWebinarsWhite PapersProduct ManualsRequest PricingData SheetsCase StudiesEvoq Preferred Products Content Management Ecommerce Forms Identity Management and Authentication Site Management Social Themes

Partners

DNN Partners Partner Directory Become a DNN Partner Partner Program Overview  Hosting  Implementation  ISV  Training  Competencies

Community

Participate Ask a Question Forums Community Showcase DNN MVP  Program Overview  Lifetime MVPs  Honorary MVPs Subscribe to DNN Digest Advisory Groups  Awareness Advisory Group  Developer Advisory Group  Partner Advisory Group  Technology Advisory GroupLearn Documentation Wiki Community Blog Video Library Project History Development RoadmapDownload DNN Store Language Packs Manuals Nightly BuildsSecurity Policies Security Center

Blog

About

News Press Releases News Coverage Press KitCareersContact DNN

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 ...Can't create login in SQL 2008 (using SQL Authentication and 'iis appPool\' )Can't create login in SQL 2008 (using SQL Authentication and 'iis appPool\' )
Previous
 
Next
New Post
7/1/2014 9:53 AM
 
mark richardson

Joined: 7/30/2007
Posts: 501

I am try to create a user in SQL 2008.

We are using:  Windows 2008 r2, SQL 2008, ASP.net4, and IIS7.

According to this page:
http://www.dnnsoftware.com/wiki/page/...section 5.i
it says:

' ...For Windows 7 or Windows 2008R2 running IIS 7.5 you'll need to add the application pool ie; "IIS AppPool\{AppPoolName}" (without the quotes). '

I don't why I can't just use a login name without the 'IIS appPool' prefix..?

It also says on the above DNN page: "...To read why Windows 7/2008R2 differ click here."
- But on suggested link - it does NOT explain why Windows 7/2008R2 differs!

 

However, creating a login with a \ backslash results in an error.
ERROR is something like this:

"...iis apppool\[myUserName] is not a valid name because it contains invalid characters error code: 15006..."

Secondly,
is it possible to create the database login first in SQL before creating the website and appPool in iis? (if using SQL Authentication).

thanks

 

 

 
 
New Post
7/2/2014 7:31 AM
 
Mark Eckeard


Joined: 1/19/2004
Posts: 924
Yes. That's how I do it. In fact, I never use the apppool to access the database. It's my personal preference to keep all access separate.

Here's what I do:

1) create the DB
2) create a SQL account with ownership to the new DB
3) download "install" version of DNN and unzip it to c:\websites\dnnv730 (or wherever you want it to be)
4) set up new site in iis and point to location above
5) make sure new app pool for this new site is .net 4.0. I see .net 2.0 as default most times
6) launch site and get to install wizard
7) select full version of SQL Server and supply server name, DB name and account/password from step 2 above
8) let install run and launch new DNN web site

Works every time for me.

Mark
 
New Post
7/2/2014 9:27 AM
 
cathal connolly


cathal connolly's Avatar

www.cathal.co.uk
Joined: 4/9/2003
Posts: 9676
I've updated the wiki to point to http://blogs.msdn.com/b/webdevelopert... as for some reason that blog entry was lost when the blog data was migrated. That section only applies to sql server express user instances - if you're using sql express or sql server you can also use standard windows authentication (with impersonation) or sql authentication
Buy the new Professional DNN7: Open Source .NET CMS Platform book Amazon US
 
New Post
7/2/2014 9:48 AM
 
mark richardson

Joined: 7/30/2007
Posts: 501
cathal connolly wrote:
I've updated the wiki to point to http://blogs.msdn.com/b/webdevelopert... as for some reason that blog entry was lost when the blog data was migrated. That section only applies to sql server express user instances - if you're using sql express or sql server you can also use standard windows authentication (with impersonation) or sql authentication

 alas! The missing piece of the jigsaw! - Thank you.

so, just to confirm... (if I'm using Windows 2008 R2 and iis7.5) can I create a login within the 'iis appPool' prefix?
and also when using SQL Authentication?

 
 
New Post
7/2/2014 10:40 AM
Accepted Answer 
Michael Tobisch


Michael Tobisch's Avatar

https://www.dnnwerk.at
Joined: 6/27/2005
Posts: 2083

Mark,

the IIS AppPool\whatever is a Windows login, not an SQL Server login. If you have the SQL Server running on a different machine in the same domain, you can use the name of the web server as (Windows) login for the database.

But you are free to create a SQL Server login named IIS_AppPool_whatever for example.

Best wishes
Michael

 

Michael Tobisch
DNN★MVP

dnn-Connect.org - The most vibrant community around the DNN-platform
 
 Page 1 of 3
123Next 
Previous
 
Next
HomeHomeGetting StartedGetting StartedInstalling DNN ...Installing DNN ...Can't create login in SQL 2008 (using SQL Authentication and 'iis appPool\' )Can't create login in SQL 2008 (using SQL Authentication and 'iis appPool\' )


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