Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Fake the default instance with a named instance?

Is there a way with the SQL Server (2008 or newer) to fake a connection to a named instance so that it appears to look like the default instance to applications?

I have an application that has many connection strings hard coded to a default instance, and I would like to run it on a named instance.

Thanks in advance for any help on this.

like image 930
Steve Stedman Avatar asked Jun 17 '26 01:06

Steve Stedman


1 Answers

You can do this using an alias to create a common name for clients that can point to different instances:

Create or Delete a Server Alias for Use by a Client

like image 178
Mitch Wheat Avatar answered Jun 19 '26 15:06

Mitch Wheat



Donate For Us

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!