Re: SQL Server sa Password reset

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Hari Prasad (hari_prasad_k_at_hotmail.com)
Date: 10/11/04 

Date: Sun, 10 Oct 2004 21:52:23 -0500

Hello,

There is no password policies for SQL Server authenticated users. Login SA
is a SQL Server authenticated user. So the password for SA will never
expire.
Is there any chances that some one will change the password? if there are
chances then set a strong password for SA and do not share to any one. 

-- 
Thanks
Hari
SQL Server MVP
"Suresh Nadesan" <s.nadesan@welcome-rt.com> wrote in message 
news:3b2101c4af39$30fc3c10$a601280a@phx.gbl...
> Hi there,
>        I have both Windows Sharepoint Services and
> Microsoft SQL Database Running in the Same Server. Every
> two months, I get this error "Cannot connect to
> configuration Database Error" when I try to connect to our
> local Sharepoint Site.
>
>         In order to get around this problem, I reset the
> SQL Database password for sa. After this step, the
> sharepoint site will be up, i.e it will be up and running
> for 2 months and then the problem reoccurs.
>
> Any soultion to this problem? Is there a password expiry
> period username sa? How can I set the password to be non
> expiry?
>
> SuresH
>
> SuresH
> .
>
>

Relevant Pages

  • Re: Newbee password question
    ... SQL Server stores passwords using a one-way hash. ... > Is there a way to retreive passords for SQL Server authenticated users ...
    (microsoft.public.sqlserver.security)
  • Re: Total Newbie - Maintainenance of SQL Database
    ... If you are having a consultancy migrate/install this packaged solution then ... > exactly is involved in maintaining/supporting a SQL database? ... > intend to run on SQL server. ... > The only maintenance I do on the Access version is a scheduled nightly ...
    (comp.databases.ms-sqlserver)
  • RE: Event 3760 Error
    ... SQL Database 'STS_TSMAIL_1' on SQL Server instance ... Microsoft CSS Online Newsgroup Support ... <Source: Windows SharePoint Services 3 ... <SQL Database 'STS_TSMAIL_1' on SQL Server instance ...
    (microsoft.public.windows.server.sbs)
  • Re: Questions on a Database with Mass Data
    ... SQL server, how much involvement would I expect from our IT department? ... SQL Server 2005 learning resources (free online videos) ... FE to each BE and let a query to grab the specific data from a specific year ... I also heard that SQL database can handle the massive data. ...
    (microsoft.public.access.modulesdaovba)
  • The need to get around the 4000 character limit in varchar2
    ... I was approached by a developer this morning, who has a SQL server ... The SQL database has a few columns that are varchar columns, ... At this point I know of no way to migrate this data across to Oracle ...
    (comp.databases.oracle.server)