How to SQL Express/IIS/Security???

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I've got a very simple ASP.NET 2.0 web application that uses some
SpDiscoverParameterSet with my database queries. It works fine when running
or debugging under Visual Studio.

When I try to run it through IIS, like a real web app, I get a
SpDiscoverParameterSet Failed". This is a security issue, but I don't know
how to:

1) Change the setup of the .MDF file so that it will NOT use integrated
security, but accept an sa id and password

AND/OR

2) Specify a connection string that will solve the problem.

Please don't tell me that I "should not be using sa logins" - and please
don't tell me not to use SpDiscoverParameterSet. I don't want to have to
re-write the code just to get this running under IIS.

Arrghhhhhhhhh... this one day project has turned into a 2 day project, just
because of this silly security issue.
 
enabling sa login is a feature set at the server level, not the database.
use sqlserver setup to enable this feature.

-- bruce (sqlwork.com)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Web Service call times out under IIS 5.1 1
VS2008 / IIS - cannot debug 1
IIS Security w/ASP.NET 2.0 5
Integrated Security issues 1
Switching to IIS 8
How can IIS access the database without having ASPNET account in the database 7
How to Make Web Application Project Use IIS 5
IIS 6 .net version conflict? 3

Back
Top