checked remote connections for the instance set on. It is enabled.
One down... :-)
Does each SQL Server listens on different port numbers?
for example: default on 1433 and named on something else ?
Yuppers, each instance gets its own port. First is 1433 everything else is random between 1024 and 5000, depending on what's open, runs under Winsock (or at least used to). 1434 is the browser (listener). couple of others are dedicated as well, like SQL Broker.
if we have two instances installed on a box , do we see two sql server browsers in sql server configuration manager ?
because i see only one SQL Server Browser service
Yeah, you're supposed to. You should see something like this:
If you do, make sure TCP/IP is ON for the instance.
If you don't, RDP to the server and get into the services. Make sure a service called: "SQL Server Browser" is started. If it isn't, fire it up or correct whatever issues it's having.
Generally, an overview and some help using the Browser:http://www.mssqltips.com/sqlservertip/1946/overview-of-the-sql-server-browser-service/
Let us know what you find from there, if anything.
- Craig Farrell
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake. For better assistance in answering your questions | Forum Netiquette
For index/tuning help, follow these directions. |Tally TablesTwitter: @AnyWayDBA