Re: How to disable all this security?

Disable ALL security? How about disable IIS and SQL Server altogether? :(.

It seems your ASP.NET cannot access Pub database on SQL server. It is
simple: you need to grant the user account , which is used to run ASP.NET
application on the IIS, access permission to SQL Server and Pub database (or
any other database that your ASP.NET app uses). If you did not make special
configuration to your Asp.net app, by default, the user account used is
MachineName\ASPNET. You need create a login on SQL Server for this account
and grant it access to Pub database. If you have SQL Server' Enterprise
Manager installed, it is a very simple task.

I understand your "disable all security" rant was out of frustration, but
the reality is, if no security, no SQL Server and no ASP.NET. Period.

"kvr901" <kvr901@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:0074A8BD-B0B5-43FE-BAEE-94A5096F1EB3@xxxxxxxxxxxxxxxx
> I'm trying to learn how to build a simple ASP.NET application that
accesses
> one table in the SQL Server pubs database..... and I'm going crazy. I
have
> been reading and trying, reading and trying, but am constantly having
> security problems.
> I am using a laptop with XP Pro and IIS 5.(something) to design and then
> deploy it on a Win 2003 Server. I am having the same issues on both
machines
> and am totally frustrated now.
>
> What is the easiest way to disable security? I don't care if someone can
> hack into the system and destroy it. I have plenty of Ghost images and
can
> restore it in a few minutes.
>
> I want to allow anonymous access without any extra security. Later, when
I
> learn this stuff, then I'll worry about security.
>
> I installed Front Page 2003 on my laptop and tried that locally and to the
> server, but that has some issue with SharePoint (whatever that is) on the
> Win2k3 machine. Do I need SharePoint? If not, how do I get rid of it?
>
> Let me be very clear.... I don't care about security AT ALL.
>
> Please help.
>


.

Relevant Pages

  • Re: Cryptography in SQL Server 2000
    ... SQL Server 2000 Out-of-the-Box database security solution. ... database protection and privacy software is an industry-proven ...
    (microsoft.public.sqlserver.security)
  • Re: SQL or Access DB
    ... i am aware of the security modell of SQL server (we do use SQL server ... an end user,,, there is not reall alternative as a worgroup Access database ... MSDE and SQL express are all free ...
    (microsoft.public.dotnet.languages.vb)
  • Re: Cryptography in SQL Server 2000
    ... A company is vulnerable when its security ... > database encryption solution with protected key-management software ... > tested by the SQL Server Test Lab. ...
    (microsoft.public.sqlserver.security)
  • Re: Trusted connections??
    ... implement role or user based security at the SQL Server. ... If the ASP.Net app controls what the user can request of the database then I ... I implement user authentication at the application and the application ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: SQL or Access DB
    ... As far as encryption goes though... ... with Sql Server you can use SQL DMO and encrypt your stored procedures ... installation - Security was absolutely critical and in most instances, ... > then we create a nice gui around this database and sell it to automotive ...
    (microsoft.public.dotnet.languages.vb)