Solved

How do I find out IP and Protocol of MS SQL server

Posted on 2010-08-27
3
420 Views
Last Modified: 2012-05-10
Hello,
I've beend developing a n-tier vb.net/MS SQL server application and it's now getting close to deployment.  I'm new to vb.net and MS SQL server and so I've been teaching myself as I go along - (Talk about diving in the deep-end).  At any rate, the IT department wants me to provide the IP of the MS Sql server and the protocol in order to create an exception in the firewall  to external parties trying to access it.  Basically, the server is sitting behind the firewall.  This is a test-server,  the production server will be sitting outside the firewall in a DMZ. Thanks again
0
Comment
Question by:chtullu135
[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 9

Accepted Solution

by:
Gianpiero Rossi earned 500 total points
ID: 33542056
the default port is the tcp 1433.
you just have to open this port  for the ip of the sql server on your firewall.
0
 
LVL 18

Expert Comment

by:sventhan
ID: 33542223
This may help you...

Run it from SSMS (t-sql)

master..xp_cmdshell 'ipconfig'
0
 
LVL 16

Expert Comment

by:carsRST
ID: 33542268
1433 is the default - but you do not have to use it.  The port can be changed.

To validate which port you're using, view this link as a guide.

http://sqlserverpedia.com/blog/sql-server-tutorial/how-do-i-change-a-sql-port-number/
0

Featured Post

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

Question has a verified solution.

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

Introduction: When running hybrid database environments, you often need to query some data from a remote db of any type, while being connected to your MS SQL Server database. Problems start when you try to combine that with some "user input" pass…
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
Michael from AdRem Software outlines event notifications and Automatic Corrective Actions in network monitoring. Automatic Corrective Actions are scripts, which can automatically run upon discovery of a certain undesirable condition in your network.…
If you’ve ever visited a web page and noticed a cool font that you really liked the look of, but couldn’t figure out which font it was so that you could use it for your own work, then this video is for you! In this Micro Tutorial, you'll learn yo…

617 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