Re: SQL Server 6.5 - probe account

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

  • Next message: lwmccksg: "SQL Server 6.5 Security - Identify Users to granted tables" 
    Date: Mon, 15 Nov 2004 23:38:43 -0600

    Hi,

    As far as I know Probe account in SQL Server will not do any changes. SQL
    Server uses this account to manage Performance monitor
     counters and writing in to even logs. Assigning password for this user may
    cause some functionalities to fail.

    Thanks
    Hari
    SQL Server MVP

    "lwmccksg" <lwmccksg@discussions.microsoft.com> wrote in message
    news:28EF3D6D-D456-47F3-81AA-A8DFF6F3F4AB@microsoft.com...
    >I have noted that the SQL Server 6.5 has a probe user account with no
    >password.
    >
    > 1) Can this account subject to brute force attack if the default blank
    > password is not changed?
    >
    > 2) Beside I have noted that the probe account can access the following
    > tables:
    > dbo_helpsql,
    > dbo_spt_datatype_info,
    > dbo_spt_datatype_info_ext,
    > dbo_spt_fallback_db,
    > dbo_spt_fallback_dev,
    > dbo_spt_fallback_usg,
    > dbo_spt_monitor,
    > dbo_spt_provider_types,
    > dbo_spt_server_info,
    > dbo_spt_values.
    >
    > Can the probe user account change any value to these tables assigned by
    > default? Will there be any implication if the tables values are changed?
    >
    > Thanks in advance.
    >
    > Lawrence
    >

  • Next message: lwmccksg: "SQL Server 6.5 Security - Identify Users to granted tables"

    Relevant Pages

    • Re: Error 15401 using sp_grantlogin (not addressed by current KB articles)
      ... Restarting Windows 2000 resolved the problem for this particular account, ... confused when it sees a duplicate SID. ... > One way to get SQL Server to agree with the renamed NT ... > Preview (to ensure the script was created), ...
      (microsoft.public.sqlserver.security)
    • Re: SharePoint V3 Install Error
      ... But it our case it had to do with Group Policies that forbid the account of ... WSS FAQ:www.wssv3faq.com/wss.collutions.com ... Event Source: WindowsSharePointServices3Search ... whatever you are installing WSS as sufficient rights to the SQL Server ...
      (microsoft.public.sharepoint.windowsservices)
    • RE: Problems with WebParts
      ... to a database called aspnetdb. ... > The connection string specifies a local SQL Server Express instance using a ... > server account must have read and write access to the applications directory. ... > This is necessary because the web server account will automatically create ...
      (microsoft.public.dotnet.framework.aspnet)
    • Re: Cannot connect to Query Analyzer
      ... For Query Analyzer, I tried replacing the file as you suggested but had the ... same results (Enterprise Manager starts up fine, ... I created an account on my laptop and changed SQL ... Try replacing the MMC app for SQL Server from the original ...
      (microsoft.public.sqlserver.connect)
    • Re: Does anyone know how to fix this??
      ... > Inside the Active Directory Users and Computers in the folder of SYSTEM I ... Give the site's SMS Service account full control rights to the ... MP encountered an error when connecting to SQL Server. ...
      (microsoft.public.sms.setup)
    • Quantcast