Error during installation: “SQL Server does not exist or access denied”
I’ve followed the instructions (except for the PS script) from this post here: https://solidcp.com/forum/question/error-sql-server-does-not-exist-or-acces-denied/
I’ve enabled the browser service and set it to automatic, made sure it was running. I’ve restarted all the services, tried changing the authentication to mixed mode. Tried using Windows Authentication and the other option (putting my user/pass in) I’ve tried using “localhost\MSSQLSERVER”, tried using the IP/MSSQLSERVER and just the IP and just the MSSQL instance name. Nothing seems to work.
My best guess is that I missed something during the MSSQL 2016 installation but I installed ALL the options during the install.
Has anyone else run into this? Should I downgrade to a different version of MSSQL? Is there an updated PS Script to install SolidCP like in the link above?
Thanks!
J
Hello,
when you login to mssql management what server\instance does it show?
as MSSQLSERVER is generally servername default, which means if you picked that during setup you only require localhost, or servername, or ip (no \mssqlserver behind it).
2016 aswell as any previous version is confirmed working and supported so no need to downgrade.
Regards,
Marco
HYPER-V with the mssql version in quotes. The service name shows the instance of MSSQLSERVER.
Edit: I tried to use HYPER-V\MSSQLSERVER for the Sal server along with other variations of this.
So I left the installer open all night, and now after logging back in to try once more to generate the error log it magically worked. This could have been some weird latency between the MSSQLServer and browser letting them communicate with the software.
I guess this issue is resolved at this point.
Thank you all again for the assistance!
it’s very odd.
(also very little for me to write what has to be checked in addition).
Would it be possible for you to buy an hour of paid support so i can look my self? (if i can’t fix it the money is refunded with our no cure no pay guarantee)