Re: SQL server acess from ASP.NET

From: Eugene N Agafonov (gollum@zmail.ru)
Date: 09/13/02 

From: "Eugene N Agafonov" <gollum@zmail.ru>
Date: Fri, 13 Sep 2002 09:20:49 +0400

Greetings!
"Mark Johnson" <private@nowhere.com> wrote in message
news:esPeBvpWCHA.3792@tkmsftngp11...
> Just to confirm... you have
>
> Unchecked the "Allow anonymous connections" box on Directory Security
> properties of the web site, right?

right, it is unchecked. I tried to check both digest authentification and
windows authentification,
and when i didnt work i unchecked digest, but it didnt wok still.

>
> And you're using a connection string something like the following:
>
> data source=(local);initial catalog=MyDB;integrated security=SSPI;
>
> (integrated security being the key here)

yes all is the same, except data source isnt local, it is my remote SQL
server

> And you've created a windows group in which your web users are members.
> And you've created an integrated login in SQL Server based on that group.
> And you've granted access from that login to the database (MyDB above).
This
> creates a user in MyDB.
> And you've granted permissions to database resources for the database user
> resulting from the previous step.

security model is the following: we have Win2K domain, and corresponding
domain
users have asll nessesary permissions to use SQL database.

Thanks for help, will be digging it more :)

WBR,
Eugene

Relevant Pages

  • Web Site Administration Tool in VS 2005 Doesnt Work
    ... I am using MS VS 2005 and I'm trying to simply test the Security setup ... The ASP.NET Web Site Administration Tool seems to be really sluggish, ... This tool should open in a new browser. ... Unable to connect to SQL Server database. ...
    (microsoft.public.vsnet.general)
  • using the ASP.net Security features.
    ... I have setup a web site that uses the asp.net security features. ... I have setup the security provider to use a database that is different to my ...
    (microsoft.public.dotnet.framework.aspnet)
  • [NT] Vulnerability in HTML Help Allows Code Execution (MS05-001)
    ... The following security advisory is sent to the securiteam mailing list, and can be found at the SecuriTeam web site: http://www.securiteam.com ... Get your security news from a reliable source. ... * Microsoft Windows XP Service Pack 1 and Microsoft Windows XP Service ...
    (Securiteam)
  • [NT] Microsoft JScript Remote Code Execution (MS06-023)
    ... The following security advisory is sent to the securiteam mailing list, and can be found at the SecuriTeam web site: http://www.securiteam.com ... Get your security news from a reliable source. ... There is a remote code execution vulnerability in JScript. ... Configure Internet Explorer to prompt before running Active Scripting ...
    (Securiteam)
  • [NT] Cumulative Security Update for Internet Explorer (MS05-052)
    ... The following security advisory is sent to the securiteam mailing list, and can be found at the SecuriTeam web site: http://www.securiteam.com ... Get your security news from a reliable source. ... A remote code execution vulnerability exists in the way Internet Explorer ...
    (Securiteam)