SQL Server 2008

Hi, I have a sql server 2008 up and running, I installed name instance afterward and move a database to the new name instance but it seems that I cannot connect to the database on the new name instance. If I move the same database to the default instance I am able to connect to it.
Is there anything special that I should consider when I create a name instance on the same server after the first installation.
vera2006Asked:
Who is Participating?
 
Ryan McCauleyConnect With a Mentor Data and Analytics ManagerCommented:
If you can't connect to the named instance at all, check to make sure the "SQL Browser" service is running - it's what allows clients to resolve an instance name (like MYSERVER\INSTANCE1) to a physical port (MYSERVER:7823, for example). If the browser isn't running (or isn't functioning properly), it can prevent you from connecting to your named instance, but still let you connect to your default instance without any issues.
0
 
exceterConnect With a Mentor Commented:
From where you are not able to connect to instanced DB?
if from Application, then you should change the connection string - dbname=localhost TO dbname=localhost/instanceName
0
 
mayank_joshiCommented:
is the sql server you want to connect running on local machine or remote machine?
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.