Sitecore Stack Exchange is a question and answer site for developers and end users of the Sitecore CMS and multichannel marketing software. It only takes a minute to sign up.
Sign up to join this community
I'm trying to do an XP0 install of version 10.2 using the SIA tool. I can't get past task 55. I get the following error every time.
Cannot open database "sc10_Xdb.Collection.ShardMapManager" requested by the login. The login failed.
Login failed for user 'sa'.
Should I try a manual install? I was really hoping to use the SIA tool.
Interestingly, I ran into the same problem last week. This is what I found and how I solved it.
This is simply saying that it is trying to create databases in SQL server and doesn't have permission. You can look in your log file for more detail too.
Your server instance name or the password for that sa is wrong. Check that and once you get the right SQL server instance and password. It will work. FYI, in my case the SQL server was a named instance. Instead of (local) I had it as MySC10. Not sure if that matters, since I had wrong password.
Hope this helps.
Firstly verify if the SQL server is configured in Mixed Mode authentication when you were installing, If the installation is in Mixed mode, then check for the password for the user "sa". the below screenshot is where the error is in either the Instance name is wrong or the Password.
These are the possible issues for the Login failed issue.
Hope this helps!
Thanks, Yamini
In my experience, it's better to use pure SIF to install Sitecore. SIA does not surface all configurations in the GUI, which won't work for all use cases. In those cases, you'll need to make manual changes to the underlying scripts anyway, so again you may as well take the time to get a good boilerplate config set up with SIF that you can easily modify and reuse later.
I'd start by doing a full uninstall and manually check that everything has been uninstalled:
It's also a good idea to restart your PC after you do this.
This could also be a problem with the underlying install scripts. Pay careful attention to the install logs and compare the successful database creates and authentications to this failed one. What exact connection string is being used to authenticate into sc10_Xdb.Collection.ShardMapManager? Does it match the same connection string as the other DBs?
