TCP Port Addresses With Multiple Names Instances.

Sep 20, 2007

I have several 64 bit SQL 2005 servers that up to 4 named instances residing on them. Before going into production I need to change the port addressing to use fixed TCP ports. I have SQL Browser running to enbale me to see the named instances.

What steps are required to change to using specific TCP port addresses and is there a particular range to use ?

View 1 Replies


ADVERTISEMENT

Setup And Upgrade :: Opening Port 1433 Between 2 Clustered Instances?

Nov 23, 2015

We have 2 clustered SQL instances (2 physical servers in each cluster). Instance2 needs to be setup as a linked server on Instance1.

At this time port 1433 between them is not open. I am referring to the port on the network switch, not in the Windows Firewall (ports in Windows Firewall are already open).

Is opening the port between virtual IP-s sufficient? Or does port need to be open between all physical source/destination IP-s as well?

View 12 Replies View Related

SQL Server Agent Notifications To Multiple (three-plus) Addresses Fail

Jul 20, 2005

We have SQL Server 2000 Standard and recently moved from Exchange 5.5to Exchange 2003. This problem occurred both before and after thee-mail change.We would like to send notifications of failed jobs to multiple peoplein case one person happens not to be in on the day there is a problem.Setting up an operator with an e-mail name that combines twoaddresses seems to work ok as long as we use a format like thefollowing:smith_john; jones_maryorJoin Bytes!; Join Bytes!However, when we add a third name, we start getting problems. Thefirst and third accounts listed get the message but the second onedoes not -- apparently because the address gets corrupted. Forexample (based on the message received at one of the good addresses),a message sent to:Join Bytes!; Join Bytes!;Join Bytes!goes to Smith and Jackson successfully but Jones' address is corruptedto:Join Bytes!omand, of course, fails.From some other testing, it appears that the last three characters ofthe first address always get appended to the end of the secondaddress.Has anyone else run across this? If so, is there a known fix? I hadhoped Exchange 2003 would fix the problem. Most likely, we will trysetting up a personal distribution list under the account from whichthe messages are sent. I just wanted to give one more shot to findingthe problem -- both because I would like to know and because beingable to string together addresses is a little easier than having to gothrough the person who can give us access to the account to set thePDL.Thanks.Jonathan LevyChicago Department of Public Health

View 1 Replies View Related

Could Not Get SQL Server Instances Names

Jun 10, 2008

Hello,

Here is my setup:

2 node active/passive Microsoft cluster running SQL 2005 Enterprise Ed w/ SP2. The SQL setup is configured as a named instance, servernameinstancename. When I tried to install SCOM 2007, I'm getting this error, "Could not get SQL server instances names."
What could be the cause of this error? Any help would be appreciated!!

View 3 Replies View Related

Recovery :: Always On Availability Listener With Multiple IP Addresses For SharePoint 2013

Apr 14, 2014

I think theres something I'm missing about AG listeners. My test config is 1 SharePoint WFE & 2 SQL servers configured in an AAG.WFE, SQL1 & SQL2 servers are all on the same subnet.On the WFE, I configured an alias called SP15 to be used for the SQL  servers. If I failover from SQL1 to SQL2 I just need to change where the alias is pointing on the WFE. So why do I need a listener? This works fine, albeit manually.I have read on some posts that an automatic failover process is possible. How can I add a 2nd IP address to the listener when both SQL servers are on the same subnet? The GUI doesn't seem to allow this.

View 5 Replies View Related

Load A Text File With Email Addresses And Compare Against A Database Table That Has Email Addresses And User_id

Jul 12, 2007

Hello ALL



what I want to achieve is to load a text file that has email addreses from disk and using the email addresses in the text file look it up against the email addresses in the database table then once matched delete all the users in the table whose email address were in the text file.



I also want to update some users using a different text file.



Please help me with the best way to do this



Thanks in advance

View 6 Replies View Related

DB Engine :: How To Check Names Of Running Instances Without Connecting To Server

Jul 3, 2015

When i have multiple sql server instances running on one server, how to check the names of that instances with out connecting to sql server management studio.

View 12 Replies View Related

Multiple Customers (with Multiple Sql Instances) On 1 Reporting Server

Dec 3, 2007



Hi,

I think this is a question for the specialists among us.

Can I use one general reporting server (installed on instance MAINREPORTING)
for multiple customers who all have their own sql instance (CUST1, CUST2, CUST3, ..)
I would use UserAuthenciation on the reportserver url to display the specific reports customers can use.


Is this possible, and what do i have to take care off concerning installation and/or configuration (especially on
the reporting side) ?

Greetings
Vinnie

View 3 Replies View Related

Multiple Sql Instances

Dec 1, 2007

i have sql server 2005 express running. during install, i had issues with a system dll that i found answers online and resolved. i am still very green, but i know much more now than i did at the time. i believe that as a result of the partial then failed installs i have multiple instances either fully or partially installed.  when i am in the sql server mgmt express environment, it lists two sql engines.  i only ever use one, and would like to safely remove the second without damaging or corrupting anything done with the other instance.
my reasons for wanting to do this are twofold. first, i would like to free up the drive space taken up by the second instance. (i am a stickler for clean harddrive mgmt and maintenance). second, now that i have used the software and am somewhat more familiar with it, i would consider installing a second, intentional instance so that i may attempt to better customize some of the install-time settings and configurations.
can anybody give me any pointers/ guide me in the direction of information on how to SAFELY go about this?
thank you in advance for any help.

View 5 Replies View Related

Multiple Instances

Mar 6, 2003

I created a second SQL2000 instance on a Windows 2000 server. The strange thing is that I can create an ODBC connection to the default instance but cannot for the new named instance. If I try from a client that has SQL installed on it, I can see both instances. Any idea why this is happening?

Thanks,
Ken Nicholson

View 3 Replies View Related

Multiple Instances On A VM

Jun 9, 2014

We're trying to decide if we should use a single large instance of SQL Server or multiple instances on the same server. This is for a dev environment.Have to limit max RAM per instance so no instance grabs it all.There will be I/O contention and CPU contention between instances since the different instances won't coordinate with each other.It limits the available RAM for In-Memory tables..It sets lower limits to the amount of RAM available for any given query, causing artificial "contention" even when there's nothing else running at the time.

View 2 Replies View Related

Multiple Instances Of SQL

Mar 26, 2007

According to the Task Manager, on my SBS 2003 Server, I'm running multiple instances of SQL. How do I determine which instance(s) are required to maintain server stability, and which are not. My Server resource use continues to be a perennial problem. Please advise.

View 3 Replies View Related

Multiple Instances, One DB

Nov 9, 2007

SQL Server 2005 Enterprise


Is it possible to have multiple instances attach the same database?

I have a scenario where I want to have on one node, a clustered instance and a non clustered instance and both instances attach the same singular DB on a filer.

Is this possible?

View 1 Replies View Related

SSL With Multiple Instances

Dec 11, 2006

Can SQL Server be setup such that one instance on a server is using SSL and another instance is not? Or is SSL a server-wide all-or-nothing issue?




Dave

View 5 Replies View Related

Multiple Instances

Apr 6, 2006

Does SQL Server express support running multiple instances of database ?

View 1 Replies View Related

Multiple SQL2000 Instances

Dec 6, 2001

If I want to install 2 instances of SQL2000, will it install the SQL2K executable files (inn folder) onto 2 different folders, or all instances in one folder but the databases are in different folders.

Thanks

View 1 Replies View Related

SQL Server2000 Multiple Instances

Mar 2, 2001

Please Help me on this.
I installed the two instances SQL on one box. ONe is default instance called ACSQL1(actually machine name) and the other one is called ACSQL1/DEVELOPMENT. THrought the my client site of SQL 2000 I can access both instances. When I try to get connection from VB. I can access the default instance but I can not access the second instance. Any ideas about this???
Qun Lu

View 2 Replies View Related

Multiple Instances Of SQL Server 7 & 2K

May 22, 2001

I am running SQL 7.0 as the default instance and SQL 2K as a named instance. Each is using a different port....7.0 is using port 1433 and 2K is using 1024. Everything appears to be up and running fine on the server. However, I am not able to access the 2K instance from a client. I have tried to use both TCP IP and named pipes setting them up using the server network utility and the client network utility. No luck anywhere. I continue to get connection errors...check network documentation...

ANY IDEAS??????

View 3 Replies View Related

Creating Multiple Instances

Feb 18, 2004

Currently, I am running SQL Server 2000 with the default instance. I know SQL2K can run up to 16 instances simultaneously. I would like to add another instance but am unable to find documentation on how to add it. Books online tells me "about" multiple instances, but not how to set it up. I've obviously missed something somewhere. Can someone please direct me to a document that will help explain "how" to add another instance?

Thanks for your time and your help.

View 3 Replies View Related

Multiple Instances Of Job Running

Jun 20, 2002

We have a DTS package that is submitted every minute by a SQL Agent job (2000). We see instances where before the first job is completed, the second one starts running.

Has anyone encountered this type of behavior before?

View 3 Replies View Related

Multiple Instances Of Sql On A Cluster

May 7, 2008

I have a need to add a second Sql instance to an existing cluster. However I read in this article http://www.sql-server-performance.com/articles/clustering/clustering_best_practices_p1.aspx

that this is not recommended. Does anyone know why this is or what problems I may encounter?


Its is running Sql 2005 on a 64 bit windows Server 2003.

View 2 Replies View Related

SQL Server Multiple Instances

May 8, 2008

Is there any limit on SQL server Multiple Instances? if we require to run 60+ Instances on single machine what will be the minimum hardware requirements.

View 3 Replies View Related

SQL 2005 Multiple Instances 2.8 GB RAM

Dec 12, 2007

Has anyone run SQL 2005 Standard Edition, 2 or more instances on one server... where you got the extended memory up to 2.8 GB on EACH instance of SQL Server? I've done the 2.8GB game on boxes with ONE instance, but don't think I tried it on a multi-instance box, to get the 2.8GB RAM each. Thanks, Bruce

View 2 Replies View Related

Multiple Sql Instances In A Cluster

May 7, 2008

I have a need to add a second Sql instance to an existing cluster. However I read in this article http://www.sql-server-performance.com/articles/clustering/clustering_best_practices_p1.aspx

that this is not recommended. Does anyone know why this is or what problems I may encounter?


Its is running Sql 2005 on a 64 bit windows Server 2003.

View 18 Replies View Related

Upgrading Multiple Msde Instances

Nov 4, 2005

Himy first post in the data access forums, I really hope, someone can enlighten me here...I have a windows server 2003 running with 15 MSDE instances. No I would like to upgrade to SQL Server 2000 without crashing the existing instances... My perfect scenario woudl be- install sql server as new instance- move existing databases via detach / attach to the new instanceWill that work?

View 2 Replies View Related

Sql 2000 Enterprise And Sql 7- Multiple Instances

Jan 5, 2001

I need to put sql server 2000 enterprise and sql server 7 on the same box. For multiple instancing is it better to run with Win 2k Pro Server or Advanced Server. Please Elaborate.

Thanks in advance

Gunnar

View 1 Replies View Related

Multiple Instances Is It Safe And Secure ?

Feb 6, 2002

Hi everybody.
One of department want to place db application from one server somewhere else on corparation network for 3 month period.
Problem is they want to keep it with max security.
Company does not want set up another server , so we want to create another
Instance and place database on it.
1. Is safe to keep 2 instances on same server ?
2. How remove access to this instance from members of local and domain admin role(If we deny acces to BuildInAdministrators how it is going to affect security?)
Thank you

View 1 Replies View Related

Multiple Instances Cluster Setup

Mar 21, 2002

Hi,

I have 2 W2K box's and want to install 4 SQL servers on each box & each different character set and want to setup clustering (Active - passive).

Do any one of you setup this type environment ?, Pl. let me know if you have any suggestions ..


Regards,

Madhu

View 1 Replies View Related

Install AS On Multiple SQL Server Instances?

May 12, 2002

Dear Listers,

1.) Is it possible to install Analysis Services on multiple SQL Server 2000 instances? If it is, then can you instruct me as to how to perform the install. If it is not possible, then does one restrict access to cube data via the Database Role Manager?

ie. The host box is - DOILAB30 with Analysis Services & SP2
Instance - DOILAB30/DOILAB30_FIN (Can AS be installed here?)

Do I severely restrict the membership of OLAP Admins?

2). Re. AS maintenance. - How do I backup and restore OLAP dbs/cubes etc. Following a restore, what issues, such as cube users/permissions should I be aware of? (if any).

TIA

John

View 1 Replies View Related

Will Multiple Instances Affect Performance?

Mar 27, 2006

I have two instances installed on my server. I have one database on the default instance and two very large reporting databases on the other instance.

Will having the default instance running affect the performance of the non-default instance where my reporting databases are?

View 1 Replies View Related

SQL 2012 :: Monitoring Multiple Instances

Oct 22, 2015

I am using sql2012 with partitiondb custom installation over 6 dbs on 4 servers, ~200GB per db. I am looking for the perfect graphic tool (similar to Perfmon+Activity Monitor) where I can monitor a wide-scope SQL environment. I am interested in data / log / table / index growth, buffer cache hit ratio, average wait time, physical/logical reads/writes and such. I am interested in real-time / time-range metrics. I know I can issue immediate queries against dm_os_performance_counters / dm_os_buffer_descriptors / dm_exec_query_stats and get some of the relevant data, but is this the only way?Also, for your opinnion, what are the most crucial metrics to monitor when dealing with multiple dbs?

View 1 Replies View Related

Multiple MSDE Instances In WinXP SP2

Mar 17, 2007

I have installed two mssql 2000 MSDE sp4 instances on WinXP SP2.
I can connect both instances from local machine.
But when I try from remote PC, I can only connect to one with default instance name and can't connect to another one ComputerNameInstanceName.

I set the windows firewall off in WinXPSP2. But still can't connect.

I also try with mssql2000 MSDE sp3 instances. It is same ask sp4.
Please help!!!!!!

View 1 Replies View Related

RDA Access To Multiple SQL Server Instances

May 31, 2007

Hello,



There are several instances in SQL Server. I use RDA method to access SQL Server from mobile devices. But RDA method only gets the server IP,not the instance name. So, how can I define RDA to access to the instance that I need?

View 3 Replies View Related







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