Re: SA or Account

From: Hari (hari_prasad_k_at_hotmail.com)
Date: 03/25/04 

Date: Thu, 25 Mar 2004 18:20:00 +0530

Hi,

(Please do not use SA password to access the application)

In this scenario, Preferably you can create a user in SQL server (SQL
Authenticated user) to access your application with db_reader and db_writer
role.

 Try look into Application roles in books online. Application roles are
generally more secured and restrict users to access Query Analyzer, so that
users cant fire any DML directly from Query ANalyzer.
They will gain access only if they provide the password which enable the
appliaction role and give the update previlages.

Tahnks
Hari
MCDBA

"Keith" <@.> wrote in message news:OZTQ6plEEHA.3040@TK2MSFTNGP12.phx.gbl...
> I have SQL 2000 Developer Edition installed while I develop an
application.
> Eventually is will be rolled out using MSDE. The applicartion is being
> developed using a mixture of ASP, VB.NET and ASP.NET, just to confuse
> things!
>
> Before I get too deeply involved in this, what is the correct way of
> authenticating to the SQL database?
>
> I have an SA password in use currently, which is what I use in my
connection
> strings. Now I have heard that this is most definately not the correct
way
> of doing this.
>
> I develop using a PC on a 2k domain (the same domain that will ultimately
be
> used to host the application and MSDE installation), but I also do a lot
of
> work on my laptop, which is not on the same domain, and indeed is in a
> workgroup.
>
> How would you experts recommend I authenticate to the DB?
>
>

Relevant Pages

  • SA or Account
    ... I have SQL 2000 Developer Edition installed while I develop an application. ... Eventually is will be rolled out using MSDE. ... The applicartion is being ... authenticating to the SQL database? ...
    (microsoft.public.sqlserver.server)
  • Re: How to move current SQL server from Domain A to Domain B?
    ... > Users are authenticating to SQL using a local SQL login ID/PWD. ... > retiring the old domain and as far as windows security, ... SQL Server security? ...
    (microsoft.public.sqlserver.setup)
  • Re: How to move current SQL server from Domain A to Domain B?
    ... Users are authenticating to SQL using a local SQL login ID/PWD. ... retiring the old domain and as far as windows security, ... > removing the domain you will have to recreate your security setup. ...
    (microsoft.public.sqlserver.setup)
  • Re: SP - output parameter not coming back
    ... > Also I have tested the SP using SQL Query Analyzer and it does not ... If it does not work in query analyzer, it has no chance of working in asp ... > If I do not find out about the output parameter I am considering ... You definitely need to work on the stored procedure so that you can see the ...
    (microsoft.public.inetserver.asp.db)
  • Re: Missing table
    ... execute the commands within Query Analyzer. ... The first piece of sql displays the table owner, type, and the name of the table. ...
    (microsoft.public.sqlserver.server)