SQL Server Setup could not connect to the database service..

Where and how can I specify the password for sa?

"Aaron Bertrand [SQL Server MVP]" <ten.xoc.RemoveThis@dnartreb.noraa> wrote in message
news:B9C03A11-B746-49CC-9391-340B82EE0E45@microsoft.com...
> It sounds to me, based on the error message, that you are not using the
> correct password for sa.
>
>
>
>
> "Sachin" <SachinGp.RemoveThis@Email.com> wrote in message
> news:94F6A11E-9CCD-43F1-9CDF-186E6CF32478@microsoft.com...
>> 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+Ser...&ProdVe
>
 >> Stay informed about: SQL Server Setup could not connect to the database service.. 

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.TakeThisOut@Email.com> wrote in message
news:DF05F874-D6A5-450D-920F-F3646F5C76B6@microsoft.com...
> Where and how can I specify the password for sa?
>
> "Aaron Bertrand [SQL Server MVP]" <ten.xoc.TakeThisOut@dnartreb.noraa> wrote in
> message news:B9C03A11-B746-49CC-9391-340B82EE0E45@microsoft.com...
>> It sounds to me, based on the error message, that you are not using the
>> correct password for sa.
>>
>>
>>
>>
>> "Sachin" <SachinGp.TakeThisOut@Email.com> wrote in message
>> news:94F6A11E-9CCD-43F1-9CDF-186E6CF32478@microsoft.com...
>>> 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+Ser...&ProdVe
>>
>
 >> Stay informed about: SQL Server Setup could not connect to the database service.. 

> 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.

I think you are thinking of a different error, "SQL Server does not exist or
access denied." Which is definitely intentionally obscure. Invalid
password for sa, however, clearly indicates that the server has been
reached, that SQL authentication is being used, but that the credentials for
the user 'sa' have been rejected.

A
 >> Stay informed about: SQL Server Setup could not connect to the database service.. 

It's probably because of the password, however I believe it's better to
check then keep guessing. Also, this advice teaches to the OP about solving
problems by himself\herself.

Besides, thanks for sharing your thought with me.

--
Ekrem Önsoy



"Aaron Bertrand [SQL Server MVP]" <ten.xoc DeleteThis @dnartreb.noraa> wrote in message
news:3D93AF80-E075-4BE3-992D-1112CDB38A4C@microsoft.com...
>> 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.
>
> I think you are thinking of a different error, "SQL Server does not exist
> or access denied." Which is definitely intentionally obscure. Invalid
> password for sa, however, clearly indicates that the server has been
> reached, that SQL authentication is being used, but that the credentials
> for the user 'sa' have been rejected.
>
> A
 >> Stay informed about: SQL Server Setup could not connect to the database service..