Re: SQL Server Setup could not connect to the database service for server configuration

You can open SSMS and go to Security\Logins from the Object Browser to go to properties of "sa" Login and change it's password.

However, you better ensure about the problem. I'd go to SQL Error Logs and see a more detailed message about the error. SSMS Interface does not inform the user in more detail because of security. So, you can use SQL Error Logs to see more detailed info.

You can find the SQL Error Logs by openning SSMS (if it's not opened yet) and expanding Management\SQL Server Logs from the Object Browser and there you'll see the logs.

--
Ekrem Önsoy



"Sachin" <SachinGp@xxxxxxxxx> wrote in message news:DF05F874-D6A5-450D-920F-F3646F5C76B6@xxxxxxxxxxxxxxxx
Where and how can I specify the password for sa?

"Aaron Bertrand [SQL Server MVP]" <ten.xoc@xxxxxxxxxxxxxx> wrote in message news:B9C03A11-B746-49CC-9391-340B82EE0E45@xxxxxxxxxxxxxxxx
It sounds to me, based on the error message, that you are not using the correct password for sa.




"Sachin" <SachinGp@xxxxxxxxx> wrote in message news:94F6A11E-9CCD-43F1-9CDF-186E6CF32478@xxxxxxxxxxxxxxxx
Hi All,

I am getting following error while trying to install SQL Server 2005.
Any pointer?

Thanks in advance.


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.

For help, click: http://go.microsoft.com/fwlink?LinkID=20476&ProdName=Microsoft+SQL+Server&ProdVer=9.00.3042.00&EvtSrc=setup.rll&EvtID=29515&EvtType=lib%5codbc_connection.cpp%40Do_sqlScript%40OdbcConnection%3a%3aconnect%40connect%40x4818



.

Relevant Pages

  • Re: Error re-installing SQL Server 2005
    ... i actually was able to export the reg entries from my ... SQL Server Setup could not connect to the database service for server ... Refer to server error logs and setup logs for ... For details on how to view setup logs, ...
    (microsoft.public.sqlserver.setup)
  • Re: Error re-installing SQL Server 2005
    ... SQL Server Setup could not connect to the database service for server ... Refer to server error logs and setup logs for more ... For details on how to view setup logs, ... Kevin Struckhoff ...
    (microsoft.public.sqlserver.setup)
  • Re: Error re-installing SQL Server 2005
    ... Kevin Struckhoff ... > decided to try out sql server 2008 rc0. ... Refer to server error logs and setup logs for ... For details on how to view setup logs, ...
    (microsoft.public.sqlserver.setup)
  • RE: 400 MB log folders
    ... I understand that you would like to know if the SQL Server 2005 setup logs ... setup issues of SQL Server 2005 installation and service packs ...
    (microsoft.public.sqlserver.setup)
  • Re: Cluster will not fail over.
    ... Could not recover the master database! ... If you intend to stay on SP3 (for SQL Server), you should at least apply the ... >> From SQL server logs ...
    (microsoft.public.sqlserver.clustering)