SQLTeam.com | Weblogs | Forums

Application needs default instance


#1

Hi,

Can anyone please help me? I have an application that only works with sql server default instance. I only have named instance on all my servers. How will I resolve the issue?

Thanks in advance.


#2

I run into that now and again. I always assign a second IP address to that server and then have the named instance listen just on the IP address and port 1433. Then you can connect to that IP address (or static DNS entry) just like it was a stand-alone instance.


#3

Why not just use an alias name to connect to your named instance? The alias would be stored in the registry of wherever the application sits and will redirect it to the named instance.


#4

take a look at this link hope this will help you out: http://stackoverflow.com/questions/35026/sql-server-convert-a-named-instance-to-default-instance