Re: Connecting to SQL Server from Web Service

Tech-Archive recommends: Speed Up your PC by fixing your registry

From: Dino Chiesa [Microsoft] (dinoch_at_online.microsoft.com)
Date: 05/06/04 

Date: Thu, 6 May 2004 00:02:24 -0400

Also, please read this chapter, from the book
"Building Secure ASP.NET Applications"
http://msdn.microsoft.com/library/en-us/dnnetsec/html/SecNetch12.asp

This chapter is "Data Access Security"

-Dino

"Leonardo Rodríguez" <lcrodriguez@fibertel.com.ar> wrote in message
news:uhiUv7sMEHA.936@TK2MSFTNGP11.phx.gbl...
> Yes, u can. You should create first the login on the sql server and then
add
> a user with that login to your desired db.
> But i would suggest to use a normal user if u can.
>
> Regards,
>
> --
>
> Leonardo C. Rodríguez
> Email at: lcrodriguez@fibertel.com.ar
> Location : Bs.As., Argentina
>
>
>
> "John*" <anonymous@discussions.microsoft.com> wrote in message
> news:EF21C109-E708-4AC5-B4BF-A6D16F6A4275@microsoft.com...
> > Actually, the SQL Server is running on the same machine as the web
> service. Does that make IWAM a valid user to access the SQL database?
>
>

Relevant Pages

  • detecting group of logins
    ... I have some applications that talks with sql server. ... In all of them they are use windows authentication. ... there a way to know what login the user tried to access? ...
    (microsoft.public.sqlserver.security)
  • Re: Unexpected Login Screen When Accessing SQL Data Via .NET Intra
    ... >> data and the SQL Server is on the same server. ... >> My problem is that one user has started getting a login popup ... >> right in via Windows Authentication like everyone else and like they ...
    (microsoft.public.sqlserver.connect)
  • Re: cannot acees two databases as owner
    ... it does not matter you are a member of the ... the sysadmin fixed server role or if there is no any other Login which is ... group if it's a domain) and you can login to your SQL Server with, ...
    (microsoft.public.sqlserver.setup)
  • Re: Database security design with ASP.net and form-based authentication
    ... Since you already have forms-based security, why not use a single SQL login ... for all database access? ... data entry, guest/view only, admin, report viewer. ... so I'm using SQL Server authentication. ...
    (microsoft.public.sqlserver.security)
  • Re: Credentials not being passed with remote access
    ... allowed windows authentication to work, ... I had assumed johnx was a domain user rather than a local Windows account. ... johnx was set up as a local login on sql server. ...
    (microsoft.public.sqlserver.security)