Sql 2005 Instance; Dynamic Ports And Firewall Issue

Jan 27, 2008

We have an internal sql 2000 server that acts as the database backend for our
Internet presence. I believe that the sql server can be accessed because of a
firewall "exception" (?) that allows the external web server to talk to the
sql server using a specific IP address and port (namely that of the sql server.)


Now we need to install a sql 2005 instance on the same box which needs to act
as an Internet backend. The sql browser service will resolve all client
requests to the default or named instance. But I read that the sql browser service
assigns a "dynamic" port to the Instance! If that is the case, it's unlikely that,
unless the firewall has all ports open for outgoing traffic, that the sql instance will be
able to communicate with the web server.



My conclusion:

Leave the default instance (sql 2000) port at its current value;
assign the named instance an unused port;
Make sure the sql browser is running on the box!
Tell the firewall guys to make an exception for the new port.

Does this seems reasonable to you?


TIA,

barkingdog

View 4 Replies


ADVERTISEMENT

Dynamic Ports Value Changes

May 23, 2007

Hi,


Using SQL Configuration Manager, i have set my local instance to use TCP Dynamic Ports by setting the value under IPAll to be 0 (the value TCP Port is blank). However, when i start up the server this value gets set to a specific port. ie Before startup TCP Dynamic Ports = 0, After startup TCP Dynamic Ports = 2832. This value persists throughout SQL Server restarts.



Is this behaviour correct as I would have expected this value to stay 0?



I am using SQL Standard, SP2. SQL Browser is running.


Thanks in advance!

View 4 Replies View Related

DB Engine :: SSMS Connects To Different Instance With Same Hostname - If Ports Are Same

Jun 9, 2015

We have a 2 servers  with 2 default instances, 

Environment- SQL server 2012 SP2 | Windows Server 2008 R2

1server:
hostname-serverA , Instance-serverA and port-2040 Ip-192.164.1.1

2server:
hostname-serverB , Instance-serverB and port-2040 Ip-192.164.1.2

If i do a SSMS connection-the possible connections strings which can be used to connect to Instance "serverB" should be,

a.serverBserverB
b.serverB,2040
c.192.164.1.2,2040

Note: but even the connection string "serverBserverA,2040" also connects to Instance "serverB", when i try to connect from SSMS, In SSMS it shows the wrong instance name like, "serverBserverB", but it actually connects to  Instance "serverA"

i.what is the reason behind this?
ii.Is there any way to avoid this connection, by performing server property changes, if any ?

View 5 Replies View Related

SQL Server Admin 2014 :: Ports Firewalls And A New Named Instance

Nov 12, 2014

I have an existing 2012 default SQL Express. It's set up on a VPS managed by a third party. I have an administrator account on this 2012 Windows server. I'm not much of a sysadmin or a DBA but I get around. ;)

I've installed a new NAMED instance on this VPS and can not connect to it with client tools (SSMS). If I remote in, I can connect this way.

What steps might a seasoned DBA expect to make when getting a new named instance ready for the world.

Assign a port? Check the port?

Open the firewall for the port?

Will this new named instance listen on a different port than the previously installed SQL Express instance?

View 6 Replies View Related

Connecting To A Names Instance Through A Firewall.

Mar 12, 2007

Hi

I am really struggling with this problem.

I am connecting to several SQL 2000 servers on another LAN from my workstation and I have to go through a firewall.

I got the firewall people to open port 1433 and was then able to connect any server with a default instance using Query Anlyzer and the IP address of the Server.

When I try to connect from my workstation to a server with a named instance I am being blocked by the firewall before it gets to the server.

I went into Client Network Utility on my workstation and removed named pipes which only left Tcpip using port 1433.

Fire wall is now blocking “nbname UDP 137”.

Is there a setting somewhere on my workstation that I can force the traffic to the named instance to use Tcpip through port 1433.

Any Help would be great.

View 3 Replies View Related

SQL Tools :: Firewall Blocking Access To 2nd Instance Of Server

Jun 19, 2015

I have trying to access a 2nd SQL Server instances running on my WHS 2011 server from my Windows 8.1 Pro client.

The first SQL Server instance I installed is SQL Server 2014 Developer.  This has been in place for many months and access from my client pc is not a problem.  The Developer instance was installed using standard settings so uses TCP port 1433 and I have verified this by checking the firewall rules. This instance name is <SERVERNAME>

As I want to host a personal website on my server I installed SQL Server 2014 Express as a 2nd instance on my WHS 2011 box for website database purposes.  After this installation both instances are accessible via Management Console on the WHS 2011 box. 

The second instance is named as <SERVERNAME>SQLEXPRESS.

However, I am unable to access the SQLEXPRESS instance using Management Console on my client pc.  I know it is a firewall issue as when I turn off the firewall on the WHS 2011 box I can connect successfully.  The errors reported have resulted in my trying many things to resolve the problem but none have worked, e.g.

Use the default SQLEXPRESS instance to listen on all TCP ports (default installation option).  I checked the necessary firewall rules were set up correctly and they were, i.e. UDP ANY and TCP ANY for the SQLEXPRESS sqlservr.exe file.

Change the default SQLEXPRESS instance to list on a specific TCP port, e.g. 19344

Create an ALIAS for the SQLEXPRESS installation

The instance is definitely set up for Remote Access and is not Hidden.

Are there any other firewall rules I need to apply?

View 2 Replies View Related

Cannot Connect To A Default Instance Of SQL Server With Onecare Firewall Enabled -HELP!

Jun 8, 2007

Dim strCON As String = _

"workstation id=DJI-MAIN;packet size=4096;user id=sa;integrated security=SSPI;data source=DJI-MAIN;persist security info=False;initial catalog=RacingSystem"

Dim cnn1 As New SqlConnection(strCON)

cnn1.Open()



This is the code I have been using to connect to my default instance for 18 months. A recent upgrade to Windows Live onecare now prevents me connecting to the server from the same machine. The following error message is generated:-





Unhandled Exception: System.Data.SqlClient.SqlException: SQL Server does not exist or access denied.

at System.Data.SqlClient.ConnectionPool.GetConnection(Boolean& isInTransaction)

at System.Data.SqlClient.SqlConnectionPoolManager.GetPooledConnection(SqlConnectionString options, Boolean& isInTransaction)

at System.Data.SqlClient.SqlConnection.Open()

at TrainerReport001.Form1.Form1_Load(Object sender, EventArgs e) in F:#ProjectsStatsOwnerReport001Form1.vb:line 84

at System.Windows.Forms.Form.OnLoad(EventArgs e)

at System.Windows.Forms.Form.OnCreateControl()

at System.Windows.Forms.Control.CreateControl(Boolean fIgnoreVisible)

at System.Windows.Forms.Control.CreateControl()

at System.Windows.Forms.Control.WmShowWindow(Message& m)

at System.Windows.Forms.Control.WndProc(Message& m)

at System.Windows.Forms.ScrollableControl.WndProc(Message& m)

at System.Windows.Forms.ContainerControl.WndProc(Message& m)

at System.Windows.Forms.Form.WmShowWindow(Message& m)The program '[3336] TrainerReport001.exe' has exited with code 0 (0x0).

at System.Windows.Forms.Form.WndProc(Message& m)

at System.Windows.Forms.ControlNativeWindow.OnMessage(Message& m)

at System.Windows.Forms.ControlNativeWindow.WndProc(Message& m)

at System.Windows.Forms.NativeWindow.DebuggableCallback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)

at System.Windows.Forms.SafeNativeMethods.ShowWindow(HandleRef hWnd, Int32 nCmdShow)

at System.Windows.Forms.Control.SetVisibleCore(Boolean value)

at System.Windows.Forms.Form.SetVisibleCore(Boolean value)

at System.Windows.Forms.Control.set_Visible(Boolean value)

at System.Windows.Forms.ThreadContext.RunMessageLoopInner(Int32 reason, ApplicationContext context)

at System.Windows.Forms.ThreadContext.RunMessageLoop(Int32 reason, ApplicationContext context)

at System.Windows.Forms.Application.Run(Form mainForm)

at TrainerReport001.Form1.Main() in F:#ProjectsStatsOwnerReport001Form1.vb:line 2







If I turn off the onecare firewall I can connect as normal, but this is not a desired option. I have tried enabling port 1433 on the firewall, this does not work either. Any help greatly appreciated, onecare support seems reluctant to help.



TIA

View 4 Replies View Related

Adding A Custom Named Instance To Windows Firewall Exception List

Aug 14, 2007

We install SQL Express 2005 with a custom named instance. Since a named instance uses dynamic ports, how can I add this named instance to the Windows Firewall exception list? Previously with MSDE 2000 we installed as default, then I added port 1433 to the Firewall exception list.

Is there a way to install SQL Express to a static port (programmatically)? Or, is there a better method, like adding the SQL custom named instance service to the firewall exception list?

View 1 Replies View Related

SQL 2005, SSL - Certificate Request, Ports

Nov 14, 2006

I would like to use SSL on SQL Server 2005.

With SSL, is all traffic from the client to the database on port 443 ? Or are other ports needed ?

With Windows Certificate Management Snap-in, a request for a certificate assumes that there is a local Certificate Authority. I don't have one and it is my understanding that I should buy a third party certificate to avoid a man in the middle attack. With IIS there is a certificate request process. Is there something similar I should use with SQL ?

Thank you.

View 6 Replies View Related

SQL 2005, Multiple Instances - What About Ports?

Apr 18, 2006

When multiple instances of SQL 2005 are installed on a cluster or standalone server, is it best to have each instance configured to listen on a different port or will one port for all do? We don't use port 1433 and the port we do use is blocked at the firewall. I'd like to standardize on one port for all instances but I'm not sure of the ramifications. Any thoughts?

Thanks.

View 10 Replies View Related

Connecting SQL 2005 Mgt STudio Through A Cisco Firewall

Dec 26, 2006

What ports do i need to open on my Cisco Firewall in order to allow someone outside my firewall access to SQL? They want to connect using MGT Studio.

Thanks

Bosco

View 4 Replies View Related

Linked Server From SQL 2000 To 2005 Through A Firewall

Oct 16, 2007

Can anyone tell me if there's a recommended way to link from a SQL 2000 SP4 DB through a firewall to SQL 2005? I have tried with SQLOLEDB but this uses NETBios which is not secure. Or is there a way to tell it not to use NETBios?
SET @provdetail = 'DRIVER={SQL SERVER};SERVER=<IP address>;Trusted_connection=Yes'
EXEC Master..sp_addlinkedserver
@server = ,'<IP address>',
@srvproduct = '',
@provider = 'SQLOLEDB',
@provstr = @provdetail ,
@catalog = 'TestDB',
@datasrc ='<IP address>DB1'

View 1 Replies View Related

SQL Server 2005 Express Remote Admin Firewall Issues

Mar 6, 2006

Hi,

I'm experiencing problems connecting remotely (through the Management Studio) to a named instance of SQL Server Express 2005.

After investigation I determined it was a firewall issue - turn off windows firewall and I can connect fine. I initially added ports 1433 and 1434 to windows firewall - still no joy. Then I added the binaries explicitly (sqlservr.exe and sqlbrowsr.exe - or whatever they are) - still no joy. So, I looked into the firewall log to see what was being dropped. I found that my IP was trying to connect via port 1047 (TCP)... I've searched for anything about this on google and cannot find any indication that the management studio should be using this port to connect.

If I add this port, the connection works fine. Has anyone else experienced this ? As there seems to be no way of modifying the management studio to connect via a specific port, I'm a bit concerned that something is just not right.

I would appreciate any advice you can give.

Thanks.

View 1 Replies View Related

Windows Firewall Port Needed For Reporting Services 2005

Jan 4, 2007

Leon writes "I am trying to connect to a W2K3 Server's 2005 Reporting Server through my laptop's (WXP Pro SP2) SQL Server Management Studio.

I turned Port 1433 on in the server's Windows Firewall and was able to connect to the server's database engine from my laptop, but I have to turn Windows Firewall on the server off completely to be able to connect to the Reporting Server.

I have tried all the ports listed for SQL Server in the Microsoft documentation (TCP and UDP), but they seem to have no effect.

Can anyone tell me which port or ports I need to turn on in the server's firewall so that I can access Reporting Services through my laptop's SSMS?

Thanks in advance.

LGR"

View 1 Replies View Related

SSRS 2005 - Email Report On Execution To Dynamic List With Dynamic Parameters = No Schedule

Nov 23, 2007

Hi,
I have a need to display on screen AND email a pdf report to email addresses specified at run time, executing the report with a parameter specified by the user. I have looked into data driven subscriptions, but it seems this is based on scheduling. Unfortunately for the majority of the project I will only have access to SQL 2005 Standard Edition (Production system is Enterprise), so I cannot investigate thoroughly.

So, is this possible using data driven subscriptions? Scenario is:

1. User enters parameter used for query, as well as email addresses.
2. Report is generated and displayed on screen.
3. Report is emailed to addresses specified by user.

Any tips on how to get this working?

Thanks

Mark Smith

View 3 Replies View Related

Connection String For Default Instance Of SQL Server 2005, On A Box Also Running A Named Instance Of SQL Server 2000

Nov 15, 2007

The box I am trying to connect to is running two instances of SQL Server.
There is a SQL Server 2005 instance which is the default. There is a SQL Server 2000 instance which is named 'SQLSERVER'.
 I can connect to the SQL Server 2000 instance no problem:<add key="ConnectionString" value="server=MYPCSQLSERVER;database=mydatabase;user id=****;password=****" />
However,  I am having trouble connecting to the Default SQL Server 2005 instance. I have tried:
<add key="ConnectionString" value="server=MYPC;database=mydatabase;user id=****;password=****" />
 but it doesn't work. I have tried explicitly setting SQL Server 2005 to use port 1434 (as SQL Server 2000 is running on port 1433), and then used:
<add key="ConnectionString" value="server=MYPC,1434;database=mydatabase;user id=****;password=****" />
but this doesn't work either.
 
Am I mssing something here? Any help much appreciated
Thanks...
 

View 2 Replies View Related

Ports?

Aug 11, 2000

What ports does SQLMail use to access MS Exchange Server?? We have SQL 7 running on a seperate non-trusted domain(within the same DMZ) from where Exchange Server exists. The only trust we want between the 2 domains is the SQLMail functionality for the DBA's and Administrators to use. I am aware that MS Exchange uses 110 port for POP3 and port 25 for SMTP. Does this apply to SQLMail as well? Thanks in advance for your support.

View 1 Replies View Related

Ports

Jul 24, 2007

hi every on am searching for a file which contains information about
the instance in my sql server and the ports that this instances are running on ,am sure that there is a file like this but i cant find it please if u know it answer me ,,, and thanks alot for ur time//

MobashA

View 8 Replies View Related

PORTS USED

May 23, 2007

Hey all

I am using Transactional replication with updatebale subscriptions

What network ports are used for SQL server 2005 replication

This is for firewall config.

Thanx

View 3 Replies View Related

SQL Server Ports

Sep 11, 1998

Does anyone know what ports are required to be open (non-NT). We are placing the SQL-Server behind a UNIX firewall, and want to minimize the ports open.

View 1 Replies View Related

Ports And Protocols

Sep 9, 2004

Hi Folks ,

Got one for you .....

By default what ports and protocols do the following sql tools use....?

Enterprise Manager
SQL Query Analyser
SQL Profiler

And if anybody knows :

Performance Monitor
Mapping drives
Event Viewer
User/Server Manager

Any help would be greatly appreciated .....

View 1 Replies View Related

SQL Instances Ports

Jul 23, 2005

Hello,How to determine, which ports do MS SQL Server instances listen to?I want to conect to sql server using PHP and I need to know exact portnumber. I suspect that my SQL (msde) server instances don't listen ondefault 1433 :]--Stefan

View 1 Replies View Related

Regarding Ports For Db Mirroring

Aug 7, 2006

I'll have about 5 db's from an instance(server1instance1) mirrored to another server(server2/instance1). Do all of these db's have to have endpoints configured with different ports? I hope I'm clear on my question. Do I have to create a different endpoint for every db or can use the same endpoint? Thank you



Tej

View 1 Replies View Related

Required Ports

Mar 26, 2008

Hopefully someone can answer this as I am yet to find any definitive information.

User access reports by default on port 80.

Report Manager and Report Viewer are on machine A. Catalog database is on SQL Server machine B along with the database being reported on.

What ports are required to be open between machine A and machine B? Does it use standard SQL port 1433, are there any other ports used?

Thanks

View 1 Replies View Related

Opening Ports On The Server

Dec 31, 2002

How would i open up ports on the server? Are they all open or do i have to specify which ones i want open? thanks

View 7 Replies View Related

Changeing Remote Ports

May 30, 2007

I have two instances of SQl 2005 running on a server. One I'm going to allow outside remote access to. But I don't want to do it on the default port. though I have it allowing remote and that seems to be working. I can seem to find where to change the default listening port.

and I scimmed the help and topics I saw. But didn't see one relevant to this question.

View 1 Replies View Related

Ports Used By ReportViewer Web Controls

Jan 15, 2007

When a ReportViewer control is used to access a report on a remote SQL Server database, on what ports does the communcation occur? Does the control communicate on on the SQL Server ports of 1433 and 1434 or does it communcate as a web service on port 80 (or 443 for HTPPS)?

View 1 Replies View Related

TCP/UDP Ports Used For Index Server OpenQuery

Nov 4, 2005

If I am doing an Index Server query from SQL, such as:SELECTQ.*FROMOPENQUERY(FTIndexPM, ''SELECT path, characterization, rank, hitcountFROM SCOPE('DEEP TRAVERSAL OF .....can anyone tell me which TCP/UDP ports will be used between the SQLServer and the Index server if the Index Server is on another machine?I'm doing the query from SQL so that I can join the results with atable in the database and am not interested in doing the Index queryfrom the app server. I haven't been able to find any info on the netfor which firewall ports are used for this.

View 5 Replies View Related

SQL Server Ports - Net-Library Encryption

Jul 20, 2005

I was reading that Net-Library Encryption is an SSL utility. Does thatmean the traffic uses TCP port 443 or does it still use TCP 1433?Thanks.http://msdn.microsoft.com/library/d..._ar_cs_6fu6.asp

View 1 Replies View Related

Tis Has More Than Likely Been Asked Before But, How Do I IIS Without Opening External Ports On My Pc?

Apr 26, 2007

Hi Everyone,



I am new to the forum and would like to have a question answered. I want to to install Sql Server Express with advanced services but also want to have IIS installed as well. My question is, how do I install IIS without it opening Port 45? When I installed it, it would not let me finish installation without letting it act as a server. Is there any work around to solve this problem that any of you have managed to use?

View 1 Replies View Related

Workaround To Connect To SQL Server When Ports Blocked?

Jan 11, 2006

My SQL Server is a shared account at MaximumASP.com a client just deployed my .NET application on GoDaddy.com and they have all there ports blocked and my app cannot connect to the SQL Server. Using "Network Library =dbmssocn" in the connection string did not help and GoDaddy will not help.  MY QUESTION IS: how can I get my .NET app to connect to the SQL Server? web service? This is the first time I have run into this problem. There seems like there has to be some way. THANKS IN ADVANCE!

View 2 Replies View Related

SQL 2K Instance On SQL 2005?

Apr 13, 2007

I created a SQL 2K instance on my SQL 2005 machine. I can see the instance in my 2005 Management Studio, but I cannot see it in SQL 2K Enterprise Manager. How can I accomplish this?



Thanks,



Gerald

View 6 Replies View Related

Firewall Again

May 30, 2001

Hi guys.

We have an external webserver/sqlbox not on domain network and internal on domain.

I need to register both servers or need to do a linked server between two.

There is something i found in Multi protocol. Will somebody explain the whole process.


If i need to change the port settings in SQL, is that just the Client neetwork utility I should change or should i run the setup.

Any input appreciated.....
:-)
-MAK

View 1 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved