Solved

Configuring MS SQL Server to listen on a specific port and IP Address

Posted on 2012-04-11
3
315 Views
Last Modified: 2012-04-22
Hi Experts,

I've two instances on DB Server and I want to configure each instance with a specific IP address and port. Can anybody direct to me a good link or solution? Below is the example

InstA      IP:X.X.X.45
InstB      IP:X.X.X.46

I've already check SQL Server configuration utility and under SQL Network settings for TCP/IP protocol IP Address I've IP1,2,3,4,5,6 and IP All and I need to know which one I need to configure. (The loop back address 127.0.0.1 is on IPv4)

Thanks.
0
Comment
Question by:Samoin
[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
  • 2
3 Comments
 
LVL 40

Accepted Solution

by:
lcohan earned 450 total points
ID: 37834015
0
 
LVL 40

Assisted Solution

by:lcohan
lcohan earned 450 total points
ID: 37834022
And this for an instance:

"How to configure an instance of SQL Server to listen on a specific TCP port or dynamic port"
http://support.microsoft.com/kb/823938
0
 
LVL 15

Assisted Solution

by:Deepak Chauhan
Deepak Chauhan earned 50 total points
ID: 37834386
Create another tcp endpoint  using this sample script.

CREATE ENDPOINT sql_endpoint
    STATE = STARTED
AS TCP (LISTENER_PORT = 1500, LISTENER_IP = ALL)
      FOR TSQL ()

grant permission to public role >>

grant CONNECT ON ENDPOINT::[sql_endpoint] to [public]

add port in tcpip protocol in ipall section like tcp port=1433,1500

stop sql browser service

now your configured instance listen only on  port 1500 because default tcp ip endpoint  permission will automatically revoke from user when you grant permission on newer endpoint.

for detailed information u can throughout the above links
0

Featured Post

What Is Transaction Monitoring and who needs it?

Synthetic Transaction Monitoring that you need for the day to day, which ensures your business website keeps running optimally, and that there is no downtime to impact your customer experience.

Question has a verified solution.

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

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…
For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.

696 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