I have a Sitecore 9.3 instance. I installed on my local machine. After install, I moved my SQL databases to a server. I updated the connection strings and Sitecore itself is working fine. XConnect seems to work on a surface level - that is, I can go to my XConnect URL and get a timestamp. But, in my logs and my Event Viewer I am getting tons of:

Login failed for user 'myuser'. Reason: Failed to open the explicitly specified database 'MYDATABASE_Xdb.Collection.Shard0'. 

I do not have an explicit connection string for these databases (The Shard databases). The user is set as a db_owner for the shard databases, so I dont think thats the problem?

How do I control access to these databases?


Its definitely still trying to connect to those databases in the old location (Saw in SQL log). How do I get XConnect to see the new dbs? Or rather, get the contained databases to see the new location?

1 Answer 1


The Xdb.Collection.ShardMapManager database defines the shards settings for each shard map in the __ShardManagement.ShardsGlobal table.

enter image description here

You will need to update the ServerName field in each record with the name of the SQL Server where you migrated your Xdb collection shards databases.

If you also renamed the databases, you will need to update the DatabaseName field in each record as well.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.