Solved

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

Posted on 2010-08-27
3
382 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
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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Update in Sql 7 30
Determine log file requirements 7 35
Upgrading SQL Server Management Tools 7 36
Sql Query Datatype 2 19
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…
Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
In this video I am going to show you how to back up and restore Office 365 mailboxes using CodeTwo Backup for Office 365. Learn more about the tool used in this video here: http://www.codetwo.com/backup-for-office-365/ (http://www.codetwo.com/ba…
Internet Business Fax to Email Made Easy - With  eFax Corporate (http://www.enterprise.efax.com), you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, f…

895 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

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now