Login failed for user 'sa' (1 Viewer)

[chemelli]

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]

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]

There is no reason for failing installation. Please attach the setup logs to review your issue.

Simone

 

[dbgurudk]

There is no reason for failing installation. Please attach the setup logs to review your issue.

Simone

here you go...

 

[chemelli]

This is a M$ bug: FIX: Error message when you try to use a SQL Server authenticated login to log on to an instance of SQL Server 2005: "Logon error: 18456"

More info provided here: SQL Protocols : Understanding "login failed" (Error 18456) error messages in SQL Server 2005

Simone

 

[dbgurudk]

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

 

[chemelli]

Follow this link: TV-Server/config-firewall - MediaPortal Wiki Documentation

Simone

 

[victor97]

I have the exect same problem, but I have no clue how to solve this.

Can someone give me a hint? Thanks!

 

[MattyZee]

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]

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.