Background:
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.
Issue:
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_addserver
and 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 localhost
.