Re: SQL Server 2000 - Service Manager



"Don Grover" <dgrover@xxxxxxxxxxxxx> wrote in message
news:eXQWlQyCGHA.2596@xxxxxxxxxxxxxxxxxxxxxxx
>
> "jackwc" <jackwc@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
> news:DD6543F9-782F-47F1-88C4-CACE6019AAFB@xxxxxxxxxxxxxxxx
>> On occasion, I will open Service Manager and I will see a Server Name
>> that I
>> do not recognize. I don't understand how it got there. The latest server
>> name
>> was USATLBMUTZ1. I am a beginner using SS2000. Is it possible for someone
>> to
>> hack their way into my local version from the outside? All I have is an
>> eval
>> version of SS2000 on my laptop. The only data on it are sample databases.
>> --
>> jackwc
>
> Assuming you have XP and are either using a router / Modem.
>
> Things that should be done.
> 1) Install XP SP2
> 2) Install all OS Updates.
> 3) Install latest SQL Service pack
> 4) Have no OS users loggins without passwords , Including Administrator
> 5) Have no SQL users loggins without passwords Including SA
> 6) If using MSSQL Mixed mode See 5
> 7) Configure XP Firewall.
> 8) Run free MS Base Line Security Analyser, (Its free) and implement any
> relevant changes.
>
> If all of the above are done then you should be resonably secure.

MBSA is an excelent suggestion; it will warn about most of the other items
when relevant.

Something else that MBSA will warn about is if the account used for SQL
Server provides too much privilege. The recomendation is to use an account
we create, right?


.



Relevant Pages

  • RE: How do I get back to base SQL server on my SBS 2003 server?
    ... After you uninstall SQL 2005, the instance which you upgraded will not go ... Uninstall and then reinstall ISA server. ... Uninstall and then reinstall the Monitoring component. ... Tools to Maintenance, change Monitoring component to Install, and then ...
    (microsoft.public.windows.server.sbs)
  • RE: How do I get back to base SQL server on my SBS 2003 server?
    ... What's the error message you see when installing SQL? ... the easier way is to restore the server from recent backup. ... Screen shot of the error when you install SQL 2005 Workgroup edition. ... <The server-based applications that were running fine are: McAFee EPO, ...
    (microsoft.public.windows.server.sbs)
  • Re: SBS 2003 and Sql Server ~ Client Install
    ... I've found the client tools and have now ... A word mail merge document could access a SQL database via ... We want to install to gain an understanding. ... Once we've managed to install the SQL Server Client we can start to ...
    (microsoft.public.backoffice.smallbiz2000)
  • Re: how do I change the user install wizard to create user folder in different location?
    ... Some people read the instructions in such a way that they install both a new ... instance of sql, ... Never slight the SBS wizards. ... I reinstalled from scratch using the Dell OpenManage Server ...
    (microsoft.public.windows.server.sbs)
  • Re: Any help here???
    ... SQL 200 Server is not local - it's on separate server all by itself. ... trust me - all that's been done here was to install SP2 or upgrade of XP from ... I've completed the install of Visual Studio.NET like I've ...
    (microsoft.public.dotnet.framework.aspnet)