Login failed for user 'sa' (1 Viewer)

chemelli

Retired Team Member
  • Premium Supporter
  • September 28, 2006
    6,159
    2,264
    49
    Milano, Italy
    Home Country
    Italy Italy
    Hi Folks,

    When I use the 1-click install I get this error during MSSQLExpress.

    SQL Server Setup could not connect to the database service for server configuration. The error was:
    [Microsoft][SQL Native Client][SQL Server] Login failed for user 'sa'

    Anu clue?

    I guess you already have a SQLExpress installed by another application.
    This is why you cannot install a new one: it thinks about an upgrade and ask for the old install "sa" password.

    Simone
     

    dbgurudk

    MP Donator
  • Premium Supporter
  • April 9, 2008
    41
    0
    Hi Folks,

    When I use the 1-click install I get this error during MSSQLExpress.

    SQL Server Setup could not connect to the database service for server configuration. The error was:
    [Microsoft][SQL Native Client][SQL Server] Login failed for user 'sa'

    Anu clue?

    I guess you already have a SQLExpress installed by another application.
    This is why you cannot install a new one: it thinks about an upgrade and ask for the old install "sa" password.

    Simone

    Hi Simone,

    I know for sure there is no SQL installed....

    It is during the installation of the SQLExpress it fails.

    During the install of SQLExpress it Native something and the supportfiles.
    After this it's scanning the coputer donfig.
    Next.
    SQL Setyp Support Files
    Setup Fineshed​
    SQL Native Client
    Setup Finished​
    SQL VSS Writer
    Setup Finished​
    SQL Server Database Services
    Confiduring components​

    That's where it comes to a full stop with the message:
    TITLE: Microsoft SQL Server 2005 Setup
    ------------------------------

    SQL Server Setup could not connect to the database service for server configuration. The error was: [Microsoft][SQL Native Client][SQL Server]Login failed for user 'sa'. Refer to server error logs and setup logs for more information. For details on how to view setup logs, see "How to View Setup Log Files" in SQL Server Books Online.
     

    chemelli

    Retired Team Member
  • Premium Supporter
  • September 28, 2006
    6,159
    2,264
    49
    Milano, Italy
    Home Country
    Italy Italy
    There is no reason for failing installation. Please attach the setup logs to review your issue.

    Simone
     

    dbgurudk

    MP Donator
  • Premium Supporter
  • April 9, 2008
    41
    0
    Hi chemelli,

    I found out that I had to de-activate Bullguard firewall!!!!

    Do I have to pay attention to open any ports or anything else before I re-activate the firewall?

    Thanks in advance
     

    victor97

    Portal Member
    April 29, 2008
    19
    1
    Home Country
    Netherlands Netherlands
    I have the exect same problem, but I have no clue how to solve this.

    Can someone give me a hint? Thanks!
     

    MattyZee

    Portal Member
    November 23, 2007
    23
    0
    Adelaide
    Home Country
    I too get this error. But before that i get this error
    "Connection failed!
    A connection was successfully established with the server, but then an error ocured during the login process. (provider: Shared Memory Provider, error 0 -No process is on the other end of the pipe.)"
    I get this no matter what i type for the password, but only the first time i try and start the TV server config. Then i just get the "login failed for user 'sa' " error

    any ideas?
     

    DigitalFusio

    Portal Pro
    January 16, 2009
    84
    2
    Minnesota
    Home Country
    United States of America United States of America
    Ok, this is the same thing I get. I even have tried uninstalling everything mediaportal and SQL05. I still get this same message when I try to run the TV-server config tool.
     

    Users who are viewing this thread

    Top Bottom