Re: login failed for user'sa'

From: Ron Talmage (rtalmage@prospice.com)
Date: 08/30/02 

From: "Ron Talmage" <rtalmage@prospice.com>
Date: Fri, 30 Aug 2002 12:21:14 -0700

Pranali,

You were right to change the sa password. But don't let the application use
the sa login. Create a login with the minimal amount of permission required
for the application to run, and use it.

The application may be disconnecting from SQL Server and so it has to log in
again.

Ron 

--
Ron Talmage
SQL Server MVP
"Pranali" <psuva@freightdatasoftware.com> wrote in message
news:#5vRxAFUCHA.1636@tkmsftngp10...
> Hi ,
>
> I did changed the password for 'sa' from blank to one strong password for
> security purposes but still it fails again and again and I have to enter
it
> again and refresh the connection any help will be appreciated.
>
> PS
>
> "Pranali" <psuva@freightdatasoftware.com> wrote in message
> news:u9JF82EUCHA.1436@tkmsftngp13...
> > Hi ,
> >
> > I have asp pages on web which connects to sql7.0 through login user'sa'
> with
> > no password and have sql set on mixed mode security everything works
fine
> > but it is giving me error all the time when I go on web that login
failed
> > for user'sa' then when I go in security in logins and in properties for
> 'sa'
> > login and clear password field and apply it it starts again but its
doing
> > this again and again .I dont have any stored procedure or triggers only
I
> > have DTS Packages .Can somebody tell me why the password for 'sa' which
is
> > blank keeps changing without anybody doing anything on webserver is
there
> > any fix please help me .
> >
> > PS
> >
> >
>
>
Quantcast