116
votes
Accepted
Is there a way to reset Sitecore admin password from database level?
The accepted answer is valid for previous version of Sitecore, but it does not reset the password salt and doesn't in fact reset the password to 'b'. In order to do this, you need the following ...
61
votes
Is there a way to reset Sitecore admin password from database level?
Yes there is.
Switch to your core database and execute the SQL below to reset the password to b:
UPDATE [aspnet_Membership] SET Password='qOvF8m8F2IcWMvfOBjJYHmfLABc='
WHERE UserId IN (SELECT ...
31
votes
Accepted
How does the "Clean up databases" feature work?
In a Sitecore 8, this will:
Cleanup CyclicDependences (items that couldn't be removed by CleanupOrphans because they have a parent but are not in the item tree)
Cleanup InvalidLanguageData (remove ...
26
votes
Is there a way to reset Sitecore admin password from database level?
Unlock_Admin doesn't work when you will decide to change your password encryption from SHA1 into SHA512 (regarding to Sitecore recommendations).
It does NOT reset password for Sitecore admin - it just ...
22
votes
Accepted
How can I remove / delete Sitecore database log (*.ldf) files
A very large log file is symptomatic of the problem of no backups taking place. Under normal circumstances SQL log files get truncated on backup.
It is quite normal that a CI environment gets quite ...
17
votes
Accepted
Mongo vs SQL Server with Sitecore 9 Update 2
1) Infrastructure
MongoDB will introduce new element into infrastructure of your solution. This increases cost of servers, cost of maintenance and at the end complicates the overall solution ...
16
votes
Accepted
Setting up multiple publishing targets
Scenario
Let's say you need create a second publishing target called staging.
Steps
Publishing Target
You need to create an item for the new database in the content tree at the path /sitecore/...
15
votes
Accepted
Move users / roles / passwords to new core database
There are a few options to transfer Users and Roles from one instance to another.
Sitecore Packages
You can use the standard Package Designer application from the Development Tools menu in the ...
14
votes
How does the "Clean up databases" feature work?
Typically, a cleanup operation will remove data in invalid languages and items in orphaned trees. That means:
all invalid language data (i.e. data for which the language does not exist) will be ...
13
votes
Accepted
Sitecore Azure SQL database maintenance
Yes, you definitely still need to perform regular database maintenance. Especially on Sitecore DBs like Analytics that have a lot of activity and develop index fragmentation quickly. At least, if ...
12
votes
Publishing without SQL
Ok. Well. Would definitely be possible to set something up with Unicorn for this - albeit it a highly unusual configuration. Steps I would take would look something like this:
Set up Unicorn on the ...
12
votes
Accepted
'sqlcmd' is not recognized at CreateShardApplicationDatabaseServerLoginSqlCmd step
Right after post my question, realized that sqlcmd was not installed at the server - which is weird, because XP1 topology didn't require at all!
In my case, I had to download and install
Microsoft ...
9
votes
Accepted
What is the purpose of the Analytics DB in Sitecore 8.x?
The Analytics DB is used as a reporting database for xDB. MongoDB is the collection database and periodically this is aggregated and stored in the Analytics db (also called the reporting db).
If you ...
8
votes
Sitecore Logging (Log4Net) Log to Database as Well as Text Files
Yes. You need a new <appender>. First you need to set up a table to receive the logging information:
CREATE TABLE [dbo].[Log] (
[Id] [int] IDENTITY (1, 1) NOT NULL,
[Date] [datetime] NOT ...
8
votes
Sitecore CM/CD/SQL IOPS Guidelines
I am not aware any IOPS guidelines, but there is a Sitecore Experience Platform 8.2 Performance White Paper where they have made many test and the Premium Storage Account is only mentioned for MongoDB....
8
votes
Accepted
How to handle multiple Core Databases in a multi-datacenter setup on Azure PaaS
As you mentioned Replication is required for some Sitecore databases, but SQL Azure (PaaS) does not support SQL read-write geo-replication currently just read-only(https://docs.microsoft.com/en-us/...
7
votes
Accepted
Server Role for SQL Server Account?
You are right, you granted to much privileges. You don't have to assign any server roles, but you should should assign db_datawriter, dbreader and public role memberships for your user to the web and ...
7
votes
SQL wait times on EventQueue
To be honest, I'm not sure if what I describe below will fix the ASYNC_NETWORK_IO issue. Seeing NETWORK_IO lets me think that the issue is more network or server related than being a real Sitecore ...
7
votes
Accepted
When is it safe to remove an `EventQueue` record?
After having processed an event from the queue each instance updates the associated last processing timestamp (LPT) which is stored in the Properties table and has the key in the following format '...
7
votes
Is there a way to reset Sitecore admin password from database level?
To get this to work with my version of Sitecore (8.1u3) after switching hashing algorithms to SHA512, I needed to make the following small adjustment to Derek's answer.
USE [sitecorecmsSitecore_Core];...
7
votes
Which databases does Sitecore 9.0.2 need for CMS only mode?
That would be an XM environment.
You require: forms, core, web and master
https://doc.sitecore.net/sitecore_experience_platform/setting_up_and_maintaining/sitecore_on_azure/deploying/...
7
votes
msdeploy.exe : Error: .Net SqlClient Data Provider: Invalid object name 'Blobs'
I was facing same issue and found that it tries to update the Blobs and other tables in XP instance i.e. YourSitecoreXP_Master DB
So if the Sitecore prefix in the deploy script is wrong it tries to ...
6
votes
Is there a way to reset Sitecore admin password from database level?
It's not a SQL query, but this will work even when you switch HashingAlgorithms.
You can create a small console application to reset/change passwords. I based this console app on the one from Bas ...
6
votes
Accepted
What is Sitecore IDTable usage?
The Sitecore 6.6 scaling guide has this to say about the IDTable:
You can store persistent mappings of arbitrary keys to Sitecore IDs in the Sitecore IDTable.
By default, this is only used by ...
6
votes
How can I remove / delete Sitecore database log (*.ldf) files
It depends how you've set up your database. You can set the recovery model to simple to get rid of most of the log file content. Go to the database with SQL Management Studio, right click on the ...
6
votes
When is it safe to remove an `EventQueue` record?
In order to be 100% sure that a particular event was processed by all servers, you would need to write a rather complex query.
To illustrate, I've written a query to return all events processed by a ...
6
votes
Performance problems with the Sitecore SQL Session Provider
You've seen the "Optimize SQL Server Performance" section (Not Applicable to Azure SQL) at https://doc.sitecore.net/sitecore_experience_platform/setting_up__maintaining/xdb/session_state/...
6
votes
'sqlcmd' is not recognized at CreateShardApplicationDatabaseServerLoginSqlCmd step
Thank you, Vinicius. To add to the correct answer, after downloading the two utilities from your answer, my problem was not resolved.
I encountered into the same issue when running Sitecore ...
6
votes
Sitecore Custom Databases for user generated content
Yes
You can add as many databases as you like.
I have an admittedly very old tutorial that takes you through the steps. Having just skimmed through it, I would say it's probably still perfectly ...
6
votes
Accepted
Why Xdb.Collection.Shard0, Xdb.Collection.Shard1 and Xdb.Collection.ShardMapManager databases in Sitecore 9 are not Partially Contained?
xConnect uses a change tracking functionality which requires a SQL User so it can access multiple databases. For this reason, contained database authentication cannot be used on the xDB Collection ...
Only top scored, non community-wiki answers of a minimum length are eligible
Related Tags
sql-database × 140azure × 19
installation × 12
xdb × 9
xconnect × 8
publishing × 6
sitecore-install-framework × 6
session-state × 6
paas × 5
container × 5
sitecore-client × 4
sitecore-commerce × 4
configuration × 4
security × 4
upgrade × 4
docker × 4
sitecore-api × 3
content-editor × 3
content-management × 3
reporting × 3
scaling × 3
sim × 3
setup × 3
wffm × 2
exm × 2