Bug Fix | Ritesh's Blog for SQL-SERVER & .NET

Bug Fix – Msg 15118 Password validation failed

September 11, 2009 — riteshshah

When you are dealing with Database Master Key and provide encryption password, you have to give strong password there. It uses Windows Complexity Password policy if exist any. In you won’t provide password according to your Windows Complexity Password policy, it won’t accept it and you will greeted with following error.

Msg 15118, Level 16, State 1, Line 1

Password validation failed. The password does not meet Windows policy requirements because it is not complex enough.

Reference: Ritesh Shah
http://www.sqlhub.com
Note: Microsoft Books online is a default reference of all articles but examples and explanations prepared by Ritesh Shah, founder of http://www.SQLHub.com

Posted in Bug Fix, database master key, DMK, Microsoft, ms sql server 2008, Msg 15118, Password validation failed, Ritesh Shah. Leave a Comment »

Extreme-Advice.com

SQL Server 2016 Service Pack 1 November 18, 2016

I have started working with Microsoft SQL Server 7.0 in late 1999 and even today I become very excited with the new version of Microsoft SQL Server. SQL Server 2016 has been in market for quite some time but now finally Microsoft has released service pack 1 for SQL Server 2016 to download. This … Continue reading "SQL Server 2016 Service Pack 1" […]

Riteshshah

SQL Server 2014 CTP 1 available to download June 27, 2013

SQL Server 2014 CTP 1 available to download SQL Server 2014 is recently announced in TechED Europe. I am really very excited to download and knew more about it. You can download SQL Server 2014 CTP 1 from here. Each new version of software needs compatible hardware and software. Those are mandatory before you try … Continue reading "SQL Server 2014 CTP […]

Riteshshah

Dynamic filter in WHERE Clause with CASE_WHEN_THEN in SQL Server May 27, 2013

I have very often seen that people are so used to with traditional methods and hence never think in terms of set based programming, they used to write code with evergreen traditional method which people used to use in sequential language like C or many be ASP etc. Let us see this practically with an … Continue reading "Dynamic filter in WHERE Clause wit […]

Riteshshah

SQL Server Login permission to read queue message count of Service Broker April 10, 2013

SQL Server Login permission to read queue message count of Service Broker Few weeks back, I have written one article “Find Service Broker Queue Count in SQL Server”. One of the blog reader has created the UDF I have given in that article and tried to fetch value of that UDF from his web application … Continue reading "SQL Server Login permission to read […]

Riteshshah

Count active Thread for Service Broker Queue in SQL Server April 9, 2013

Count active Thread for Service Broker Queue in SQL Server Since we have big service broker setup, it is very important to know for us about thread running for target queue. Target queue is the queue which suppose to do the work of actual business logic and we used to give proper naming convention to … Continue reading "Count active Thread for Service B […]

Riteshshah

Error Fix – Replication subscriber does not exist on the server anymore April 8, 2013

Error Fix – Replication subscriber does not exist on the server anymore Recently one of my client has faced weird situation related to SQL Server Replication. Their main database goes down so they started running mirroring database as a primary database, removed subscriber and distributor. Once they have setup primary server back properly, they have … Contin […]

Riteshshah

Bug Fix – Show Result Pane not working in SQL Server 2012 with CTRL + R April 7, 2013

Bug Fix – Show Result Pane not working in SQL Server 2012 with CTRL + R Once you are addicted with some keyboard short keys then you hate to use mouse for those things for sure. SQL Developer/DBA are, mostly, addicted with “CTRL + R” short key which is being used to show/hide result panel … Continue reading "Bug Fix – Show Result Pane not working in SQL […]

Riteshshah

Find disabled job in SQL Server April 5, 2013

Find disabled job in SQL Server I, generally, don’t tend to keep disabled job in my server. I would always like to remove disabled job after generating the script and keep the backup of script and this is the reason whenever someone intentionally or unintentionally disabled the job, my monitoring application shows the server name … Continue reading "Fin […]

Riteshshah

Copy and archive SQL Server database backup April 4, 2013

Copy and archive SQL Server database backup Though you are working as SQL Server DBA, you have to think, at least sometime, beyond relational. We can schedule different types of backup, ie: full, differential, transaction etc., from within SQL Server but what if you want to set archiving policy also? There are so many different … Continue reading "Copy […]

Riteshshah

Error Fix Database Mail XPs error in SQL Server April 3, 2013

Error Fix Database Mail XPs error in SQL Server Today I have received one email from one of the blog reader since he was facing an issue in his .NET application which is related to SMTP email in SQL Server. Here is the error he was facing: SQL Server blocked access to procedure ‘dbo.sp_send_dbmail’ of … Continue reading "Error Fix Database Mail XPs erro […]

Riteshshah

Deal with message queue conversation with state CD in Service Broker April 2, 2013

Deal with message queue conversation with state CD in Service Broker Each side of a Service Broker conversation is represented by a conversation endpoint and sys.conversation_endpoints catalog view contains a row per conversation endpoint in the database. Generally when service broker accept record in message queue, it used to process message and remove it a […]

Riteshshah

Keep watch on Service Broker Queue Delay in SQL Server April 1, 2013

Keep watch on Service Broker Queue Delay in SQL Server We have very large setup of Service Broker enabled in our live databases. Out of which, some of the nightly business processes create a huge target queue which we suppose to finish during the night time itself. If we can’t cleanup all these queue in … Continue reading "Keep watch on Service Broker Q […]

Riteshshah

Milestone of 500+ article March 29, 2013

Milestone of 500+ article This post is 504th post in my blog. I have started sharing my knowledge in form of blog article three years back. Initially I, just, wanted to keep my script collection online so that I can find it easily as and when I need it but later on my blog has … Continue reading "Milestone of 500+ article"

Riteshshah

Update XML attribute value based on condition with XQUERY March 28, 2013

Update XML attribute value based on condition with XQUERY Recently I had one article which shows how to update XML attribute value which doesn’t had any checking/condition while update. One of the reader asked me how can he update value based on condition. Here is the solution for it. [sourcecode language=”sql”] CREATE TABLE Orders ( … Continue reading […]

Riteshshah

Query to Find missing job in SQL Server March 27, 2013

Query to Find missing job in SQL Server While managing multiple instance of SQL Server, it is little bit difficult to keep watch on every jobs running in every SQL Server Instances we are managing. I have created one monitoring application which suppose to be watched by at least one DBA 24*7. I have one … Continue reading "Query to Find missing job in S […]

Riteshshah

Update XML attribute value with XQUERY in SQL Server March 26, 2013

Update XML attribute value with XQUERY in SQL Server Recently I have written article on Inserting attribute in existing XML Elements and Delete XML element. Today I am going to show how to update existing attribute value in XML elements. [sourcecode language=”sql”] CREATE TABLE Orders ( ID INT IDENTITY(1,1), ClientID VARCHAR(6), TestDetails XML, OrderDate DA […]

Riteshshah

XQuery in SQL Server to insert XML attribute in existing XML element March 25, 2013

XQuery in SQL Server to insert XML attribute in existing XML element Use of XML is being popular in SQL Server and it comes handy in many situation as I have explained in many of my past Xquery/XML related article. Today I come up with one more example which shows usage of XQuery to insert … Continue reading "XQuery in SQL Server to insert XML attribute […]

Riteshshah

XQuery in SQL Server to delete XML element March 22, 2013

XQuery in SQL Server to delete XML element Use of XML is being popular in SQL Server and it comes handy in many situation as I have explained in many of my past Xquery/XML related article. Today I come up with one more example which shows usage of XQuery to delete element from XML data … Continue reading "XQuery in SQL Server to delete XML element" […]

Riteshshah

WHERE clause on XML column in SQL Server table March 20, 2013

WHERE clause on XML column in SQL Server table Xquery is one of the wonderful feature I appreciate most in SQL Server. Due to lack of knowledge, people doesn’t tend to use it. I always prefer XML in case of I have to pass multiple values in one parameter of stored procedure. It is even … Continue reading "WHERE clause on XML column in SQL Server table […]

Riteshshah

Keep an eye on replication error in SQL Server March 18, 2013

Keep an eye on replication error in SQL Server Setting up replication is may be little easy but to keep a constant watch on the performance of the replication is one of the tough task to do. If setup of replication is proper and if you are having a proper hardware and infrastructure, you won’t … Continue reading "Keep an eye on replication error in SQL […]

Riteshshah

	Soumya Ranjan Samant… on Image store in SQL-Server 2005…
	Jeff Moden on Table statistics in SQL Server…
	Twitter on Read XLS or MDB file with Open…
	Kelli Dudley on LOG function in SQL Server and…
	Jason on DDL Trigger in SQL-Server 2005…
	Amit Kumar Gupta on DDL Trigger in SQL-Server 2005…
	riteshshah on Image store in SQL-Server 2005…
	Soumya Ranjan Samant… on Image store in SQL-Server 2005…
	BYRON on Read XLS or MDB file with Open…
	How to Remove Duplic… on Delete-Select-Duplicate-Record…

Ritesh's Blog for SQL-SERVER & .NET

About Author

My Book

Recent Comments

Archives

Categories

Bug Fix – Msg 15118 Password validation failed

Extreme-Advice.com