Solved

SQL Server 2008

Posted on 2011-03-18
3
231 Views
Last Modified: 2012-05-11
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.
0
Comment
Question by:vera2006
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
3 Comments
 
LVL 3

Assisted Solution

by:exceter
exceter earned 250 total points
ID: 35163945
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
 
LVL 9

Expert Comment

by:mayank_joshi
ID: 35164129
is the sql server you want to connect running on local machine or remote machine?
0
 
LVL 28

Accepted Solution

by:
Ryan McCauley earned 250 total points
ID: 35174150
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

Featured Post

MS Dynamics Made Instantly Simpler

Make Your Microsoft Dynamics Investment Count  & Drastically Decrease Training Time by Providing Intuitive Step-By-Step WalkThru Tutorials.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

If you have heard of RFC822 date formats, they can be quite a challenge in SQL Server. RFC822 is an Internet standard format for email message headers, including all dates within those headers. The RFC822 protocols are available in detail at:   ht…
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
Come and listen to Percona CEO Peter Zaitsev discuss what’s new in Percona open source software, including Percona Server for MySQL (https://www.percona.com/software/mysql-database/percona-server) and MongoDB (https://www.percona.com/software/mongo-…
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …

705 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question