Menu
I'm installing some software and I need to tell it to use the default instance of SQL Server, however the Installshield GUI insists that I enter in information for a named instance.
The target SQL Server is version 2008R2
I'm hoping there is a clean hack that I can use such as "." or "default" but I haven't guessed it yet. I've also tried MSSQLSERVER, and that didn't work either.
655
Go to the tab IP Address and look for the property TCP Dynamic Ports. This is the port to which the SQL browser will listen. It will determine which instance the client tries to reach. The Default Instance of SQL Server will always be listed under port 1433.
you can rename your instance but you can not change the named instance to default instance and vice versa. Save this answer. Show activity on this post.
A default instance is a type of instance that is used when installing a single instance of SQL server. In contrast, a named instance is a type of instance where the user specifies an instance name when installing the instance.
Run this query:
SELECT @@SERVERNAME + '\' + @@SERVICENAME AS InstanceName
and use the result as your instance name.
53
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
