Login Problems

• Norm-475848

  Newbie

  Points: 3

  More actions

  August 14, 2007 at 6:44 pm

  #69047

  Would anybody know why my DB wants to only use Windows only authentication even though I have SQL Server and Windows checked as the authentication method? I installed Service Pack 3 and now when I go to my site, it asks me for a local user account. It did NOT do this before Service Pack 3. I also checked the registry for the proper settings and they are set for 'SQL Server and Windows' Authentication.

  Any ideas?

  Much thanks for any help.

  Norm....

• Lowell

  SSC Guru

  Points: 323518

  More actions

  August 15, 2007 at 11:27 am

  #727130

  I'm confused about what you mean when you said "I go to my site, it asks me for a local user account"

  Are you sure it's SQL server that is asking for a login, and not Internet Information Services asking for a login because the site was changed to private somehow?

  IIS can create websites that force a login dialog, and you might have to fix that; maybe it's a co-incidence that you upgraded SQL, and now you are getting an IIS issue?

  if it might be IIS, roght click>>Properties on youe web site in IIS>>

  directory security>>Anonymous Access and Authentication control>>Edit Button.

  is the checkbox for Allow Anonymous Access checked? it it's unchecked, youd get a dialog like you described.

  is the checkbox for

  Lowell

  ---

  --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

• Norm-475848

  Newbie

  Points: 3

  More actions

  August 17, 2007 at 10:32 am

  #727700

  I'm sorry that I wasn't specific enough--lots on my mind & plate. Yes, I have a site that requires a DB. I thought that would be the problem as well and I do have a check in the 'Allow Anonymous Access' box. That SHOULD control the login, but there must / has to be something else, somewhere else. I am just missing it. Any help IS much appreciated.

  Thanks,

  Norm....

• Norm-475848

  Newbie

  Points: 3

  More actions

  August 20, 2007 at 2:08 pm

  #728119

  Can ANYBODY think of anything else to check/change? Thanks, Norm....

• Joe Clifford

  SSCrazy Eights

  Points: 8739

  More actions

  August 20, 2007 at 10:33 pm

  #728177

  Norm -

  Assuming this is a .ASP or .Net application what are the connection strings for the database specified in the web.config or global.aspx? 

  If your connection string specifies integrated security (look for "integrated security=sspi") you'll need to make sure that your application pool is running using the correct identity and that the specified account has permissions on the database server as well.  It gets a little more complicated with IIS & sql server on seperate machines but not too bad.

  Is your application using integrated security or a SQL account?

  Joe