Aleks
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
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
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.
ASKER
I imagine I need help for that
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Really? You needed help on how to search the registry?
The link I provided had the PATH to local the SQL Server paths.
The link I provided had the PATH to local the SQL Server paths.
https://docs.microsoft.com/en-us/sql/sql-server/install/file-locations-for-default-and-named-instances-of-sql-server?view=sql-server-2017