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
Explain about CSMA/CD It is an access method used mainly with LANs configured in a bus topology. With CSMA/CD, any station (node) can transmit a message to any other  statio


Differentiate between Transport and Session layers of OSI model. OSI Model Transport Layer The transport layer utilizes the services provided through the network layer, as

Syntax and Semantics: Propositional logic is prohibited in its expressiveness: so just to represent true and false facts for the world. By a type of extending propositional lo

A ring counter consisting of five Flip-Flops will have ? Ans. A ring counter have 5 states while consisting of Five Flip-Flops.

Visibility. Controls should be clearly visible, so users can see the controls that are available to them. Visual feedback should also be clearly visible, so users can understand wh

What is Electronic Data Interchange? Electronic Data Interchange (EDI): It is used by organizations for transactions which arise on regular basis to a pre-found format.

explain the bock and pin diagram of 8259 micropocesser

Write a program to find the area under the curve y = f(x) between x = a and x = b, integrate y = f(x) between the limits of a and b. The area under a curve between two points can b

Determine the term- Files File maintenance is significant. Updating of files generally involves inserting, amending and deleting data. Example: A bank would amend data