Re: Strong SA Password

From: Kevin McDonnell [MSFT] (kevmc_at_online.microsoft.com)
Date: 12/21/04

  • Next message: Chris Geier: "Re: IIS, SQL DMZ question" 
    Date: Tue, 21 Dec 2004 01:17:50 GMT

    Hi Chuck,
        If you're using OSQL to connect /run queries then you should type the
    password . Eg.
    OSQL -SmyServer -PmyPassword

    Depending on how MSDE was installed with what Netlibs, your choices may be
    limited. By default,
    only Shared memory is used.

    Things to verify:
    1. Service is actually running. Check the Services applet for
    MSSQL$Instance
    2. Try stopping and re-starting the service. Check the NT Application
    event logs for errors.
    3. Try using a test ODBC DSN to connect to the server. This will give you
    a better error message than OSQL.

    Passwords.
    During setup should have supplied a password for the 'sa' account. It
    should never be blank or easy to guess like 'password'

    setup SAPWD="AStrongSAPwd"

    The same rules apply to SQL as they would for choosing a password policy
    for your Windows domain.

    http://www.microsoft.com/smallbusiness/gtm/securityguidance/articles/enforce
    _strong_passwords.mspx

    Thanks,

    Kevin McDonnell
    Microsoft Corporation

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

  • Next message: Chris Geier: "Re: IIS, SQL DMZ question"

    Relevant Pages

    • Problem with MSDE 2000 Rel A.
      ... But if i use osql -Sservername\MSDE -E and it's work. ... instead of server name on MSDE 2000. ... to register the new SQL Server and got the same error message 'SQL Server ...
      (microsoft.public.sqlserver.msde)
    • MSDE Automatic script at each night
      ... Can you setup within MSDE a script to be run automatically at 12:01 each ... The script is very simple... ... now is run this script vi osql and a schedule batch job. ...
      (microsoft.public.sqlserver.msde)
    • Re: MSDE 2000 Release A: Windows Authentication Mode or Mixed Mode
      ... should do to solve the error message you received: ... You should run setup from the command line as ... > install the MSDE 2003 Release A in my PC. ...
      (microsoft.public.access.modulesdaovba)
    • How to Replicate using OSQL?
      ... I've installed a MSDE 2000 in a remote Computer. ... and set subscriber from OSQL? ... how can I use Enterprise Manager ... from another computer to configure Replication Scenario's ...
      (microsoft.public.sqlserver.msde)
    • Re: Tools for Sql Server Desktop Engine
      ... i want to import access database into MSDE using osql. ... See the command-line switches to be used by typing in osql ... > "Tarundeep Singh Kalra" wrote in message ... >>> There are a number of products out there and one of them is MSDE ...
      (microsoft.public.dotnet.faqs)