What Is The SQL Server 2005 Dynamic Port Range?

Jan 26, 2007

Hi,

I'm setting up my SQL Server 2005 instances to use dynamic ports on one of my machines. What is the tcp port range used? I need to know the range so I can open the correct ports on my firewalls.



Thanks

Brian

View 4 Replies


ADVERTISEMENT

SQL Server 2012 :: Day Wise And Date Range Calculation With Looping Or Dynamic Data?

May 14, 2015

I am using Sql Server 2012.

This is how I calculate the ratio of failures in an order:

31 Days Table 1 query
sum(CASE
WHEN (datediff(dd,serDATE,'2015-01-21')) >= 31 THEN 31
WHEN (datediff(dd,serDATE,'2015-01-21')) < 0 THEN 0
ELSE (datediff(dd,serDATE,'2015-01-21'))END) as 31days1 .

How do i loop and pass dates dynamically in the Datediff?

31 Failures Table 2 query
SUM(Case when sometable.FAILUREDATE BETWEEN dateadd(DAY,-31,CONVERT(DATETIME, '2015-01-21 23:59:00.0', 102))
AND CONVERT(DATETIME, '2015-01-21 23:59:00.0', 102)Then 1 Else 0 END) As Failures31,31 Day Cal(Formula) combining both Table 1 and Table 2
((365*(Convert(decimal (8,1),T2.Failures31)/T1.31day))) [31dayCal]This works fine when done for a specific order.

I want a similar kind of calculation done for day wise and month wise.

2. what approach should I be using to achieve day wise and month wise calculation?

I do also have a table called Calender with the list of dates that i can use.

View 3 Replies View Related

SQL Server 2005 How To Check Port

Feb 11, 2008

How does one check which port SQL Server is listening to? How does one know if it is 1433 or 1434?

View 8 Replies View Related

Changing SQL Server 2005 Tcp/IP Port

Mar 14, 2007

When I change the tcp/ip port to anything other than 1433 my SSIS nor DTS packages run successfully. Does the tcp/ip port have to be on 1433 for the SSIS or DTS packages to run successfully?

View 3 Replies View Related

Finding Port Number In SQL Server 2005

Feb 13, 2008

I know the ..Program FilesMicrosoft SQL ServerMSSQL.1MSSQLLOGErrorLog on the server contains the information. But that needs I to RDP to the server or open the file remotely. Is there any other way to find out the port from my SSMS connection?

I remember in SQL Server 2000 you could find the information by choosing Properties of a connection in EM and click on the Network Configuration button. (I know it works when you are ON THE SERVER! But when I tried from my desktop, pressing the button didn't do anything)


Canada DBA

View 2 Replies View Related

Port Data From AS400 To SQL Server 2005

Jan 24, 2007

Is there a good way to port data from an AS400 over to SQL server 2005? If anyone has any experience with this, can you tell me where to go to get info?

View 3 Replies View Related

Changing The Default Port On A Clustered 2005 Server.

Feb 7, 2007

I am unclear as to which Ip address to change the standard port on. When setting up a cluster you have multiple IP address's including the nic that is used for the heartbeat. I have not found any documention on how to change both nodes to listen on a port other than 1433..


Any help would be greatly appreciated.

View 1 Replies View Related

Can Not Run SQL Server 2005 Upgrade Advisor On Server That Does Not Use The Standard Port

Jun 7, 2007

I tried creating an alias to the server to get it to connect to analyze the server but it will not recognize the SQL 2000 server as a valid server to analyze. I can use the alias to connect in EM or SSMS. Any ideas? The server is not clustered and is at SP4. I've connected to several others in my environment but this one is causing me grief!



Thanks,

Linda

View 1 Replies View Related

Dynamic Range Of Data?

Jan 29, 2008

Hi,

I'm trying to group data by date range, but each row of data could have a different date range based on a variable.

I want to say "look at the date range the paste five orders were placed" for each row individually. As an example, think of the rows as keywords in a Search Marketing program. Keyword X had 5 orders placed in the last week, Keyword Y had 5 orders placed in the last 2 weeks. I want each keyword to display its average impressions over the course of its respective date range.

Is this possible?

Thanks in advance!

View 10 Replies View Related

SQL Server 2005 Performance - Where Clause Range Retriaval

Sep 28, 2007

Everything is flowing smoothly for the SQL Server Database I have, except one type of retrieval and that is when the where clause has a range of data values to do the retrieval then the performance is terrible. I cannot anticipate every range. There are indexes on the table to try to help; however, nothing seems to help. Has anyone had a similiar problem? Any suggestions to improve performance?

Thanks, Mary

View 2 Replies View Related

Port Sql 2000 To Sql 2005

Apr 17, 2007

Need url on good kb or article on converting sql 2000 to sql 2005 (full version not express)
Thanks,
Michael Oard

View 4 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

Setting The Port For The Database Connection In Vs 2005 And Also In Web.xml

Feb 15, 2006

I've mapped a sqlserver machine within vs2005, but when I attempt to set the database connection, I dont see place to stick the port number (even in the advanced area)... it continues to fail when I test the connection.. I can telnet into the machine on the sql server port, so I know its open to me...
Also - when I publish this to an IIS server, what is the syntax for placing the connection and port number in web.config?  I've tried various settings, cant get it to work. <appSettings><add key="con" value="Server=12.123.123.123;PORT=1234;UID=*****;PWD=*****;database=mydb" /></appSettings>
 
Thanks in advance for the help,
Todd

View 3 Replies View Related

SQL 2005 Unattended Install TCP Port Number

Oct 19, 2007

Hi All,

I am having an issue with SQL 2005 unattended install, I cannot see where in the template.ini file you can specify the TCP port number for SQL 2005 to listen to I want to change it to a specific port number, I know you can do this in an unattended install on SQL 2000.

Also in an unattended install of SQL 2000 and 2005 is there any way you can specify the database and transaction logs location for new databases to be installed on another drive then the system databases. I know you can change this later in SQL server properties but I wanted this to be done during the install or is there a T-SQL script which can do this after?

Any help on this will be great.

Cheers

Raxso

View 3 Replies View Related

SSRS 2005 + MOSS 2007 Port Conflict

Apr 12, 2007

hello

we have Reporting services and Office Sharepoint on the same server, but the reporting services website is on default website and won't start because MOSS is already using the port.
can i just change SSRS website port ?

thanks

View 3 Replies View Related

SQL Server 2008 :: Query To Select Date Range From Two Tables With Same Date Range

Apr 6, 2015

I have 2 tables, one is table A which stores Resources Assign to work for a certain period. The structure is as below

Name StartDate EndDate
Tan 2015-04-01 08:30:00.000 2015-04-01 16:30:00.000
Max 2015-04-01 08:30:00.000 2015-04-01 16:30:00.000
Alan 2015-04-01 16:30:00.000 2015-04-02 00:30:00.000

The table B stores the item process time. The structure is as below

Item ProcessStartDate ProcessEndDate
V 2015-04-01 09:30:10.000 2015-04-01 09:34:45.000
Q 2015-04-01 10:39:01.000 2015-04-01 10:41:11.000
W 2015-04-01 11:44:00.000 2015-04-01 11:46:25.000
A 2015-04-01 16:40:10.000 2015-04-01 16:42:45.000
B 2015-04-01 16:43:01.000 2015-04-01 16:45:11.000
C 2015-04-01 16:47:00.000 2015-04-01 16:49:25.000

I need to select the item which process in 2015-04-01 16:40:00 and 2015-04-01 17:30:00. Beside that I need to know how many resource is assigned to process the item in that period of time. I only has the start date is 2015-04-01 16:40:00 and end date is 2015-04-01 17:30:00. How I can select the data from both tables. There is no need for JOIN, just seperate selections.

Another item process time is in 2015-04-01 10:00:00 and 2015-04-04 11:50:59.

The result expected is

Table A

Name StartDate EndDate
Alan 2015-04-01 16:30:00.000 2015-04-02 00:30:00.000

Table B

Item ProcessStartDate ProcessEndDate
A 2015-04-01 16:30:10.000 2015-04-01 16:32:45.000
B 2015-04-01 16:33:01.000 2015-04-01 16:35:11.000
C 2015-04-01 16:37:00.000 2015-04-02 16:39:25.000

Scenario 2 expected result

Table A

Name StartDate EndDate
Tan 2015-04-01 08:30:00.000 2015-04-01 16:30:00.000
Max 2015-04-01 08:30:00.000 2015-04-01 16:30:00.000

Table B

Item ProcessStartDate ProcessEndDate
Q 2015-04-01 10:39:01.000 2015-04-01 10:41:11.000
W 2015-04-01 11:44:00.000 2015-04-01 11:46:25.000

View 8 Replies View Related

SQL Server 2005 Dynamic Pivots

Aug 20, 2007

I'm trying to create a dynamic pivot table, with changing column headers eg. dates!!? how can this be done when you have to define the headers names in the query!

More info availible if any one can help!!

thanks for your time

View 2 Replies View Related

Best Practice To Pull Data From Sql Server 2000 To Sql Server 2005 With Dynamic Queries

May 3, 2007

Hi There,

I need to pull data using input from one table in sql server 2005. I have to query against the sql server 2000 database and pull data into sql server 2005. I have a list of ids that I have to pass to a query to get the desired data. What is the best practice for this. Can I use SSIS or do I need to build an app in C#? Can somebody please reply back?

Thanks a lot!!

View 4 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

Can't Change TCP Port Using Configuration Manager For X64 SQL 2005 SP1 Virtual Instance

Feb 27, 2007

Hi, I hope someone can help me!   I changed the TCP port that the default instance of SQL 2005 x64 SP1 is listening on and now SQL server won't start as the port is being used - no problem I say to myself, I'll just change it again, however I can't!  

My problem is that I can not change the TCP Port back again using Configuration Manager - no matter what values I put in, after a restart of the instance it comes up with this in the IP Addresses tab for TCP/IP Properties and SQL Server won't start:

IP1
Active   Yes
Enabled   No
IP Address  aaa.bbb.ccc.111
TCP Dynamic Ports
TCP Port  0

IP2
Active   Yes
Enabled   No
IP Address  aaa.bbb.ccc.222
TCP Dynamic Ports
TCP Port  0

IP3
Active   Yes
Enabled   No
IP Address  aaa.bbb.ccc.333
TCP Dynamic Ports
TCP Port  0

IP4
Active   Yes
Enabled   No
IP Address  10.1.1.1
TCP Dynamic Ports
TCP Port  0

IP5
Active   Yes
Enabled   No
IP Address  127.0.0.1
TCP Dynamic Ports
TCP Port  0

IPALL
TCP Dynamic Ports 2020
TCP Port  2020

Interestingly, the ip address that the server is listening on aaa.bbb.ccc.444 is not reported in the list of IP addresses in the configuration manager for this instance, yet it is when I view the available IP addresses for the other two instances - is this significant?

I have tried failing to the other node, changing it there, changing it at the console and also while logged onto the the virtual machine remote desktop, rebooting both nodes, etc, etc.   There are two other instances on this cluster that are still working fine but I hvae not attempted to change the TCP ports they listen on.

I used the same method to change this default instance as I did for a named instance on a similarly configured cluster and it worked fine.   How to fix this?

Regards, Mike

2007-02-27 12:03:17.69 Server      Server is listening on [ aaa.bbb.ccc.444<ipv4> 2020].
2007-02-27 12:03:17.71 spid9s      Starting up database 'tempdb'.
2007-02-27 12:03:17.72 Server      Error: 26023, Severity: 16, State: 1.
2007-02-27 12:03:17.72 Server      Server TCP provider failed to listen on [ aaa.bbb.ccc.444<ipv4> 2020]. Tcp port is already in use.
2007-02-27 12:03:17.75 Server      Error: 17182, Severity: 16, State: 1.
2007-02-27 12:03:17.75 Server      TDSSNIClient initialization failed with error 0x2740, status code 0xa.
2007-02-27 12:03:17.75 Server      Error: 17182, Severity: 16, State: 1.
2007-02-27 12:03:17.75 Server      TDSSNIClient initialization failed with error 0x2740, status code 0x1.
2007-02-27 12:03:17.75 Server      Error: 17826, Severity: 18, State: 3.
2007-02-27 12:03:17.75 Server      Could not start the network library because of an internal error in the network library. To determine the cause, review the errors immediately preceding this one in the error log.
2007-02-27 12:03:17.77 Server      Error: 17120, Severity: 16, State: 1.
2007-02-27 12:03:17.77 Server      SQL Server could not spawn FRunCM thread. Check the SQL Server error log and the Windows event logs for information about possible related problems.

View 11 Replies View Related

While Using SQL Server 2005 .Net Integration Are Dynamic Web References Allowed?

Apr 26, 2006

This is my problem: I have a dynamic web reference for a SQL Server UDF coded in C#, but I am unsure of where URL for the webservice is being read from.

I am working with SQL Server 2005 to create a User Defined Function, however I need to have a web reference to the SQLReportingService2005 web service. I will be distributing this function to my customers so I need this web reference to be dynamic.

Although the webservice says it is dynamic, I do not see a app.config file to place the changing URL. Does anyone know where a dynamic web service pulls the URL from in this case?



Thanks in advance,

Sean

View 1 Replies View Related

Need A Way To Port From Informix To Sql Server

Jan 5, 2001

Hi,

Could anyone tell me how the data can be ported from informix to sql server ?

Is there a way to run the informix query from sql server ?

Thanks,
Vijay.

View 1 Replies View Related

Finding The SQL Server Port

Feb 17, 2005

Hello. I'm a novice with SQL Server. I set up a SQL Server instance using Enterprise Manager and I want to find out what port that instance is listening to, because it's not listening to the default.

Is there a way I can specify a port for the server to listen to?

View 2 Replies View Related

Finding The SQL Server Port

Feb 21, 2005

Hello. I'm a novice with SQL Server. I set up a SQL Server instance using Enterprise Manager and I want to find out what port that instance is listening to, because it's not listening to the default.

Everything is on my local machine, this is a development database.

Is there a way I can specify a port for the server to listen to?

View 7 Replies View Related

How To Port SQL Server Data?

Jan 27, 2004

Hello!

I have an SQL Server 2000 database at home PC that has several tables and plenty of data in it...also stored procedures.

I want to port all that data so that I can use it at another PC that has SQL Server installed in college.

How to do this?

Thanks in advance!


Lala the don

View 6 Replies View Related

SQL Server Port.... (Named

Jul 12, 2006

I have access to the default instance of a SQL Server ..... I have access to the QA only .. by reading the registry through the QA I get to knw that there are additional 4 more instances on the Server ..... is is possible to get the port on which they are listening using the QA ....

I knw that we can go to the servers network utility & see it there in the TCP /IP ... but i dont have access to that , neither do i have access to the error logs that tell me , on which port is SQL Server listening to

Can someone help

View 1 Replies View Related

SQL Server Port Change

Jan 30, 2008



Hello All,

We have default instance "MSSQLSERVER" with Port number 1433. We Installed another Instance "MGMT" on the same windows server, it came as same Port number "1433".

We decided to Change the Port number for Instance "MGMT".

1. We changed the port number for "MGMT" to like "1234"

2. After the change we did telnet to "MGMT" Instance with "1433", it worked.

3. Then we changed the Port number for Instance "MSSQLSERVER" also to like "4321".

4. After change of these setting and followed with rules framed in link as said: http://www.databasejournal.com/features/mssql/article.php/3689846


5. Now we did telnet with changed port number, it works fine.

6. We can not do telnet with Port number 1433 for both Instances "MSSQLSERVER" and "MGMT".. This is fine, what we want, and what we intent to do...

Question to MVP OR SQL Gurus:

A) If you want to change port number to Second Instance, shall we need to change for Default Instance?

B) How the port numbers will be configured? please advice.

Thanks, Jay

View 1 Replies View Related

(RDA)Accessing Server Via A Port..

Jun 14, 2007

Hello,



I connect to the SQL Server with RDA method. there was no problem until I had to use a port to access the virtual path of RDA.

it connects when

rda.InternetUrl = http://ip/rdadir/sqlcesa30.dll ,

but no when

rda.InternetUrl = http://ip:81/rdadir/sqlcesa30.dll .



May someone help,please?



Thanks.

View 4 Replies View Related

Connecting To SQL Server On A Different Port

Nov 27, 2006

I have a server running SQL Server 2005 Dev behind a firewall that blocks the default SQL Server port. So, I changed the port that SQL server uses to another port. How do I connect to the database instance with SQL Server Management Studio. I have tried:

xxx.xxx.xxx.xxxMSSQLSERVER
xxx.xxx.xxx.xxx:portMSSQLSERVER

name.of.machineMSSQLSERVER

On all of these, I get an error 25 - Connection string is not valid. I have the surface area configured correctly (i.e. named pipes and TCP/IP are both turned on), and the sql server browser is running. I can ping the server just fine, and when I go to GRC.com and do a shields up report it lists my port of choice as being open.

What am I missing?

I also set the native client configuration's default port to the port I want to connect to, and it appears that that didn't work either.

Ideas? I would like to get this running ASAP.

Thanks in advance!

View 3 Replies View Related

Query Info Between Time Range & Date Range

Aug 16, 2006

I am attempting to write a SQL query that retrieves info processed between two times (ie. 2:00 pm to 6:00 pm) during a date range (ie. 8/1/06 to 8/14/06)... I am new to SQL and am perplexed... I have referenced several texts, but have not found a solution. Even being pointed in the right direction would be greatly appreciated!!

View 6 Replies View Related

How To Change The Sql-server Port Number?

Aug 7, 2007

Hi there,
I want to change the default sql-server port number 1433 to a new one. Can i do that? If yes, how?
Also, i have noticed that there is no port number option in the sql server 2005 management studio login window. So, what if the server has changed its port number?
Any suggestions would be appreciated. thanks

View 4 Replies View Related

Sql Server Default Port Not Enabled

Mar 17, 2004

I am unable to access the default port 1433 on my SQL 2003 server. There is no firewall. I run telnet <ip> <port> and get "Connection failed" which explains my inability to connect to the server for weeks. I have being unable to connect to the server after I uninstalled sql 2000 and reinstalled it on my 2003 server. Some of the things I have checked is Network Configuration in EM. Named Pipes and TCP/IP is installed with port set to 1433. HKLMSoftwareMicrosoftMSSQLServerClientSuperSocketNetLibTcpDefaultPort port is set to 1433. Is there anything I need to configure on the server side to have the default sql server port enabled.

Thanks

View 2 Replies View Related

How Can I Get The Port Of A Named Instance Of SQL Server

Sep 14, 2004

Thanks for Microsoft's Windows XP Service Pack 2 and Windows Server 2003 that make the security much stronger. However, besides the invisible benefit so far, I have become the victim of this security policy.

I have several named instances of SQL 7/2000 installed in my machine. They are not visible out of the Microsoft new fire wall. I need to access the instances from outside the fire wall, but I don't know which port I should open for the instances.

From SQL online, the default instance of SQL server is connected through TCP/IP by default port 1433. I could successful open that port and made the default instance visible to outside. However, the port 1433 doesn't work for the named instances. SQL online said, the port for named instance is dynamically (by default) chosen the first time the instance is started. So, actually, I have no way to know the port.

Is there anyway that I can check the database or somewhere to get the port that is used by the named instance?

Thanks for any input and recommendation.

View 4 Replies View Related







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