There is a custom java application specified to connect localhost database
User-PC\MSSQL to work with. This machine need to be replaced with another new PC with better hardware.
As the custom java application is created by someone long time ago, I cannot track back who is the developer and ask him to update the database path. I installed SQL Server 2005 on the new PC, renamed the machine name to
User-PC then use
sp_dropserver to rename the SQL server name to
MSSQL (Reference link for the sp_addserver and sp_dropserver tutorial that I followed). However, I still cannot the database by connecting to
User-PC\MSSQL via SQL server management studio or HeidiSQL or the custom java application. I can still only connect the new PC database by