Find path to the SQLEngine and the databases

I unplugged one of my external drives where I have MS SQL Databases installed. When I plugged it back in the drive letter changed and now it can't find the MSSQL server or the databases.
I can open SSMS but it cannot connect to the server.
Is there a way to know which path its looking for ?  This way I can rename the drive letter to the original
LVL 1
AleksAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

slightwv (䄆 Netminder) Commented:
I'm not a SQL Server person but I would expect the registry to have the fold locations where it was installed:
https://docs.microsoft.com/en-us/sql/sql-server/install/file-locations-for-default-and-named-instances-of-sql-server?view=sql-server-2017
0
AleksAuthor Commented:
No. I changed the path for the engine and databases during installation.
0
slightwv (䄆 Netminder) Commented:
I understand you changed the paths on install.  I'm betting the registry has the location of something stored somewhere that will give you the drive letter.
0
Determine the Perfect Price for Your IT Services

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden with our free interactive tool and use it to determine the right price for your IT services. Download your free eBook now!

AleksAuthor Commented:
I imagine I need help for that
0
Paul JacksonSoftware EngineerCommented:
Open regedit.exe (Press windows key and r to open the run dialog box, type in regedit.exe and press enter)
Right-click the HKEY_LOCAL_MACHINE node in the left hand pane and select Find
In the dialog box type "Microsoft SQL Server" (don't actually put the quotes in
Click the Find Next button
After it has shown the first entry press F3 to go to the next.
You should quickly find an entry with the install file path.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
slightwv (䄆 Netminder) Commented:
Really?  You needed help on how to search the registry?

The link I provided had the PATH to local the SQL Server paths.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
SQL

From novice to tech pro — start learning today.