Multiple instances of sql server 2000, Computer Engineering

How do I connect to an SQL Server instance that is running on a machine with multiple instances of SQL Server 2000?

Ans) Every instance of MS SQL Server must be listening on a dissimilar port. So, you can use the port number in the properties that you pass to the getConnection() method or, in case of connection pools, you can state the port property in the following properties:

server=machineName

port=instancePort

To search the port number where every MS SQL Server instance is running, run the server network utility (in the Microsoft SQL Server program group), select the server instance, select TCP/IP, and click the properties button.

 

Posted Date: 4/2/2013 3:36:13 AM | Location : United States







Related Discussions:- Multiple instances of sql server 2000, Assignment Help, Ask Question on Multiple instances of sql server 2000, Get Answer, Expert's Help, Multiple instances of sql server 2000 Discussions

Write discussion on Multiple instances of sql server 2000
Your posts are moderated
Related Questions
What are Digital Signatures and its uses? A digital signature is an electronic quite than a written signature which can be used through someone to authenticate the identity of

Given the information provided in Table 1: Prepare an Activity on the Node (AON) Network Diagram ( I recommend you  use MS Project or any drawing tool); Prepare

State about the Three-dimensional digitizers Three-dimensional digitizers use sonic or electromagnetic transmissions to record positions. One electromagnet transmission method

Address phase timing: On the rising edge of clock 0, the initiator notes IRDY # and FRAME# both high, and GNT# low, so it drives the command, address and asserts FRAME# in tim

Discuss the CSMA/CD and CSMA/CA protocols. CSMA/CD: this is an access method used mainly with LANs configured in a bus topology. Along with CSMA/CD, any station (node) can se

Define the Half Duplex Transmission A half-duplex channel can receive andsend, but not at the same time. It's like a one-lane bridge where two-way traffic should give way in

For this assignment, fill out the following class:   class person { private:   string firstName;   string lastName;   int weight; public:   . . . }; You should provide cons

. NET is Compile Time OR RunTime Environment?   .Net's framework has CLS,CTS and CLR.CTS checks declaration of types at the time when u write code and CLS explains some rules a

What are the conditions that have to be met for a condition to be an invariant of the class? Ans) ? The condition should hold at the end of each constructor. ? The conditi

Q. Define General Purpose Register Architecture? General Purpose Register (GPR) Architecture: A register is a word of internal memory similar to the accumulator. GPR architec