Link to home
Start Free TrialLog in
Avatar of Aleks
AleksFlag for United States of America

asked on

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
Avatar of slightwv (䄆 Netminder)
slightwv (䄆 Netminder)

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
Avatar of Aleks

ASKER

No. I changed the path for the engine and databases during installation.
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.
Avatar of Aleks

ASKER

I imagine I need help for that
ASKER CERTIFIED SOLUTION
Avatar of Paul Jackson
Paul Jackson
Flag of United Kingdom of Great Britain and Northern Ireland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Really?  You needed help on how to search the registry?

The link I provided had the PATH to local the SQL Server paths.