SQLServerScribbles.COM

SQL Server, SQL, Replication, SQL Server memory, SQL Server performance, SQL Server architecture, SQL Server cluster, SQL Server 2008, SQL Server 2012

Menu

Skip to content
  • Home
  • Disclaimer

The specified credentials for the SQL Server service are not valid. To continue

February 7, 2013 by Karthick P.K

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

When you install SQL 2008/SQL 2008R2/SQLServer2012 “The specified credentials for the SQL Server service are not valid. To continue, provide a valid account and password for the SQL Server service.” Even when you specify correct user name and password

You will see errors similar to one below in details.txt

 

Slp: Sco.User.LookupADEntry – Attempting to find user account Child-dc\accountname

Slp: Sco: Attempting to check if container ‘WinNT://child-dc’ of user account exists
Slp: UserSecurity.ValidateCredentials — Exception caught and ignored, exception is The RPC server is unavailable.

Slp: UserSecurity.ValidateCredentials — user validation failed

 

1. This issue happens when we have multiple domains (child and parent) and you use a account created in parent domain as startup account for SQL Server in setup screen. You can add DNS suffix in network properties and override this issue.

2. Also if the user who is running the SQL Server setup doesn’t have Read permission for BUILTIN Folder in the ACTIVE DIRECTORY USERS AND COMPUTERS we will end with above error

If none of the above fixes the error collect Netmon trace and identify which DNS query is failing and fix it.

Advertisement
Posted in SQLServer setup | Tagged General access denied error, provide a valid account and password for the SQL Server service, Slp: UserSecurity.ValidateCredentials -- user validation failed, The specified credentials for the SQL Server service are not valid. To continue | Leave a comment

Search

Authors

  • Karthick P.K
  • Pradeepa

Enter your email address to follow this blog and receive notifications of new posts by email.

Join 848 other subscribers

RSS MSSQLWIKI.COM

  • Running 1 Million databases on Azure SQL October 11, 2020
  • Top SQL Server blogs from MSSQLWIKI January 11, 2014
  • SQL Server connectivity, Kerberos authentication and SQL Server SPN (Service Principal Name for SQL Server) December 9, 2013
  • Transactional Replication Part -2 November 22, 2013
  • Transactional Replication Part -1 November 22, 2013
  • Tempdb latch contention September 17, 2013
  • Troubleshooting Transactional replication Latency using Agent Statistics September 13, 2013
  • The connection to the primary replica is not active. The command cannot be processed June 20, 2013
  • False warning “A significant part of sql server process memory has been paged out” June 13, 2013
  • What does MemoryUtilization in sys.dm_os_ring_buffers and Memory_utilization_percentage in sys.dm_os_process_memory represents? June 2, 2013
  • SQL Server monitor May 11, 2013
  • Max server memory – Do I need to configure? April 22, 2013
  • SQL Server and VMware ballooning March 31, 2013
  • Inside sys.dm_os_ring_buffers March 29, 2013
  • SQL Server lock pages in memory March 26, 2013
  • SQL Server -g March 5, 2013
  • SQL Server Operating system (SOS) – Series 3 February 11, 2013
  • SQL Server Operating system (SOS) – Series 2 January 13, 2013
  • SQL Server Operating system (SOS) – Series 1 January 10, 2013
  • SQL Server fails to start with error "Failed allocate pages: FAIL_PAGE_ALLOCATION 1" During startup January 6, 2013

Other scribbles

  • Integration Services server cannot be configured because there are active operations. Wait until there are no active operations, and then try to configure the server again
  • SQL Server setup fails with “Failed to retrieve data for this request”
  • The selected Subscriber does not satisfy the minimum version compatibility level of the selected publication.
  • Sp_rename fails : Either the parameter @objname is ambiguous or the claimed @objtype (object) is wrong.
  • SSIS package fails with out of memory errors
  • Cannot bring the Windows Server Failover Clustering (WSFC) resource (ID ‘ ‘) online (Error code 5018).
  • SQL Server cluster installation checklist
  • PREEMPTIVE_OS_AUTHORIZATIONOPS waits in SQL Server
  • SQL Server Backup compression
  • Types of isolation levels in SQL Server
  • SQL Server database snapshot
  • How to create table with filestream column and Insert data
  • How to enable and configure Filestream in SQL SERVER 2008 / 2012
  • How to import/Export data in SQL Server
  • Create script for all objects in database with data
  • Steps to enable Alwayson in SQL Server 2012
  • How to create database mirroring
  • How to create log shipping in SQL Server
  • HOW TO INSTALL SQL Server CLUSTER IN HYPER-V
  • How to create merge replication in SQL Server
  • A SQL product other than SQL Server 2014 CTP1 is detected. You cannot install this release until the existing instances of SQL products are uninstalled
  • How to start replication agent in command prompt.
  • How to create transactional replication in SQL Server
  • How to configure distribution for replication
  • How to add node to SQL Server cluster
  • SQL Server Error while enabling Windows feature : NetFx3, Error Code : -2146498298
  • HOW TO CREATE CLUSTER USING HYPER-V
  • windows cluster freezes at “waiting for notification that node ‘‘ is a fully functional member of the cluster”
  • How to install cluster in windows 2008 and windows 2012
  • How to create shared disk using iSCSI Software Target
  • NON CLUSTERED COLUMNSTORE INDEX
  • How to create clustered and non-clustered index
  • Bulk insert fails with error 4861 Cannot bulk load because the file could not be opened
  • How to create SQL Server Agent Jobs
  • How to create backups using database maintenance plan
  • How to set Max degree of parallelism (MAXDOP)
  • SQL Server Database tuning advisor
  • How to configure maximum server memory
  • CryptAcquireContext and CryptReleaseContext example
  • Criticalsection example
  • CreateProcess example
  • CreateFileMapping or MapViewOfFileEx example
  • Capture context switches from dm_os_ring_buffers
  • SSIS package fails when executed as job using proxy account
  • How to stimulate a SQL Server resource failure in cluster
  • Error 601 : Could not continue scan with NOLOCK due to data movement.
  • SQL Server monitoring
  • Removing database mirroring
  • SQLServer LooksAlive and IsAlive Check
  • Builtin\Administrators cannot login in to SQL Server
wordpress counter

Follow me on Twitter

My Tweets
Create a free website or blog at WordPress.com.
Privacy & Cookies: This site uses cookies. By continuing to use this website, you agree to their use.
To find out more, including how to control cookies, see here: Cookie Policy
  • Follow Following
    • SQLServerScribbles.COM
    • Join 69 other followers
    • Already have a WordPress.com account? Log in now.
    • SQLServerScribbles.COM
    • Customize
    • Follow Following
    • Sign up
    • Log in
    • Report this content
    • View site in Reader
    • Manage subscriptions
    • Collapse this bar