nstallation of SQLSERVER 2008R2 on Windows 200

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2008 Forums

SQL Server Administration (2008)

nstallation of SQLSERVER 2008R2 on Windows 200

Author

Topic

pennywise4berlin
Starting Member

2 Posts

Posted - 2013-02-24 : 16:22:44

Hi

I'm trying to install SQL Server 2008r2 on WIN Server 2008 R2.

When entering the User vor Service and Agent I'm running into an error (see below)
I'm connected as Domain Admin and the user for Serice is a domain user and has been granted the right to run as service.

[Error Message]
The specified credentials for the SQL Server service are not valid. To continue, provide a valid account and password for the SQL Server service.

In detail.txt it reads
[Details]
Microsoft.SqlServer.Configuration.SqlEngine.ValidationException: The specified credentials for the SQL Server service are not valid. To continue, provide a valid account and password for

the SQL Server service.
================================================================================

013-02-24 00:39:28 SQLEngine: --InputValidator: SqlCollation = Latin1_General_CI_AS
2013-02-24 00:39:28 SQLEngine: --InputValidator: SqlCollation 'Latin1_General_CI_AS' is valid.
2013-02-24 00:39:28 SQLEngine: --InputValidator: Engine : Validating Service Account
2013-02-24 00:39:28 SQLEngine: --InputValidator: Engine : Attempting to get account sid for account penny.net\sqluser
2013-02-24 00:39:28 Slp: Sco: Attempting to get account sid for user account penny.net\sqluser
2013-02-24 00:39:28 Slp: Sco: Attempting to get sid for user account penny.net\sqluser
2013-02-24 00:39:28 Slp: Sco: GetSidForAccount normalized accountName penny.net\sqluser parameter to penny.net\sqluser
2013-02-24 00:39:28 Slp: Sco: Attempting to get account from sid S-1-5-21-308707584-2278939684-3783992819-1105
2013-02-24 00:39:28 Slp: Sco: LookupAccountSid failed for SID S-1-5-21-308707584-2278939684-3783992819-1105
2013-02-24 00:39:28 SQLEngine: --InputValidator: Engine : Failed to get account sid for account penny.net\sqluser. Exception is Microsoft.SqlServer.Configuration.Sco.ScoException:

Zuordnungen von Kontennamen und Sicherheitskennungen wurden nicht durchgeführt.
---> System.ComponentModel.Win32Exception: Zuordnungen von Kontennamen und Sicherheitskennungen wurden nicht durchgeführt.

013-02-24 00:39:28 Slp: Sco: LookupAccountSid failed for SID S-1-5-21-308707584-2278939684-3783992819-1105
Doe's ths point to lack of rights (of Domain admin ?! Strange)
or is it a bug?

Thanks
Christian

prett
Posting Yak Master

212 Posts

Posted - 2013-02-24 : 23:51:15

Check this post: http://kashifnizam.wordpress.com/2012/05/28/the-specified-credentials-for-the-sql-server-service-are-not-valid-to-continue-provide-a-valid-account-and-password-for-the-sql-server-service/

pennywise4berlin
Starting Member

2 Posts

Posted - 2013-02-25 : 08:11:04

I checked that one.

Computer and user are on the same level.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources