Aquired new site and pretty confident with all other areas except SQL
server. If I change the administrator password will anything need to be done
to SQL ?

TIA

--
www.smallbizserver.net (2000 and 2003)

microsoft.public.backoffice.smallbiz2000 (2000 NG)

microsoft.public.windows.server.sbs (2003 NG)

http://groups.google.com/groups?hl=en&safe=off&group=microsoft.public.backoffice.smallbiz2000

http://groups.google.com/groups?hl=en&lr=lang_en&ie=UTF-8&safe=off&group=microsoft.public.windows.server.sbs

http://www.sbslinks.com/

Re: sql experts... by Henry

Henry
Sun May 02 08:49:31 CDT 2004

Depending on how SQL Server was set up, it could be using Windows
Authentication so no, not unless you want to harden the SQL Server
administrator (SA) account password as well, but watch out for that, a
lot of --bad- coders Hardwire the SA Account and Password into their
code.

--
Henry Craven {SBS-MVP}
Melbourne Australia

"Bill (nee Gizmo) Swan" <bill@nospam.firstresponseit.co.uk> wrote in
message news:eduQX1DMEHA.1348@TK2MSFTNGP12.phx.gbl...
> Aquired new site and pretty confident with all other areas except SQL
> server. If I change the administrator password will anything need to
be done
> to SQL ?
>
> TIA
>
> --
> www.smallbizserver.net (2000 and 2003)
>
> microsoft.public.backoffice.smallbiz2000 (2000 NG)
>
> microsoft.public.windows.server.sbs (2003 NG)
>
>
http://groups.google.com/groups?hl=en&safe=off&group=microsoft.public.backoffice.smallbiz2000
>
>
http://groups.google.com/groups?hl=en&lr=lang_en&ie=UTF-8&safe=off&group=microsoft.public.windows.server.sbs
>
> http://www.sbslinks.com/
>
>



Re: sql experts... by David

David
Sun May 02 19:04:06 CDT 2004

Bill,

Might also want to check to see what account SQL is running under.. If it or
any other service is running under the Administrator account then be sure
and change the password to match on them as well. Can check by going into
Start/Administrative Tools/Services and then right click and select
Properties on the service you want to check.. then click on the Log on tab.

In SQL Enterprise Manager you could right click on the server's name and
select Properties, then click on the Security tab.then check in the Startup
service account section.


--

Hope that helps,
David Copeland
Microsoft Small Business Server Support

This posting is provided "AS IS" with no warranties, and confers no rights.

Newsgroups:
SBS v4.x : microsoft.public.backoffice.smallbiz
SBS 2000: microsoft.public.backoffice.smallbiz2000
SBS 2003: microsoft.public.windows.server.sbs


"Henry Craven" <IUnknown@d.com> wrote in message
news:%23Po8K0EMEHA.3012@tk2msftngp13.phx.gbl...
> Depending on how SQL Server was set up, it could be using Windows
> Authentication so no, not unless you want to harden the SQL Server
> administrator (SA) account password as well, but watch out for that, a
> lot of --bad- coders Hardwire the SA Account and Password into their
> code.
>
> --
> Henry Craven {SBS-MVP}
> Melbourne Australia
>
> "Bill (nee Gizmo) Swan" <bill@nospam.firstresponseit.co.uk> wrote in
> message news:eduQX1DMEHA.1348@TK2MSFTNGP12.phx.gbl...
>> Aquired new site and pretty confident with all other areas except SQL
>> server. If I change the administrator password will anything need to
> be done
>> to SQL ?
>>
>> TIA
>>
>> --
>> www.smallbizserver.net (2000 and 2003)
>>
>> microsoft.public.backoffice.smallbiz2000 (2000 NG)
>>
>> microsoft.public.windows.server.sbs (2003 NG)
>>
>>
> http://groups.google.com/groups?hl=en&safe=off&group=microsoft.public.backoffice.smallbiz2000
>>
>>
> http://groups.google.com/groups?hl=en&lr=lang_en&ie=UTF-8&safe=off&group=microsoft.public.windows.server.sbs
>>
>> http://www.sbslinks.com/
>>
>>
>
>