Solved

SQLServer 2008 nameinstance

Posted on 2011-03-24
3
317 Views
Last Modified: 2012-05-11
Hello, I installed a new name instance on my sql server 2008 and moved a cm database to the new name instance.
I could not connect to the database on the new name instance. I finally looked at the port number and notice that it was dynamic.
I would like to know if the port number on a new name instance have to be set manually since the default instance is on port 1433.
0
Comment
Question by:vera2006
  • 2
3 Comments
 
LVL 14

Accepted Solution

by:
Daniel_PL earned 334 total points
ID: 35206300
Yes, indeed you need to set static port other than your default instace's port or use dynamic with sql browser service enabled.
0
 
LVL 14

Assisted Solution

by:Daniel_PL
Daniel_PL earned 334 total points
ID: 35206459
Additionally you need to take into account when using dynamic ports you might run into problems which ports to open on firewall ;)
0
 
LVL 8

Assisted Solution

by:EvilKnievel
EvilKnievel earned 166 total points
ID: 35206601
You should also check if protocols other than shared memory are enabled in the SQL configuration manager for that instance. The default setting for TCP and named pipes is off.
0

Featured Post

Best Practices: Disaster Recovery Testing

Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.

Question has a verified solution.

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

     When we have to pass multiple rows of data to SQL Server, the developers either have to send one row at a time or come up with other workarounds to meet requirements like using XML to pass data, which is complex and tedious to use. There is a …
In this article I will describe the Backup & Restore method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
Nobody understands Phishing better than an anti-spam company. That’s why we are providing Phishing Awareness Training to our customers. According to a report by Verizon, only 3% of targeted users report malicious emails to management. With compan…
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

773 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