Solved

SQL Server specify correct named instance

Posted on 2011-03-20
3
343 Views
Last Modified: 2012-05-11
In SQL Server 2008 how do I  make sure that I am specifying correct instance name and that instance name actually exists on target server and is running.

0
Comment
Question by:murbro
3 Comments
 
LVL 17

Accepted Solution

by:
dbaSQL earned 250 total points
ID: 35177951
In SSMS, you can double click your server to open the Object Explorer, then right click and select Propties, General Tab.  Here you will see the sql server instance name.

You can also do this with a query by executing the following:

SELECT @@SEVERNAME
0
 
LVL 9

Assisted Solution

by:kaminda
kaminda earned 250 total points
ID: 35178099
If this from your Application's perspective, you will get an error describing the situation of your server instance name, you can catch that. Also there are plenty of scripts on the web to get all the SQL instances available in your network,

This link will help you to do tihs
http://social.msdn.microsoft.com/forums/en-US/adodotnetdataproviders/thread/fda283ef-5a8b-424d-b549-074ccc19c8d7
0
 

Author Closing Comment

by:murbro
ID: 35178929
thanks for the help
0

Featured Post

Use Case: Protecting a Hybrid Cloud Infrastructure

Microsoft Azure is rapidly becoming the norm in dynamic IT environments. This document describes the challenges that organizations face when protecting data in a hybrid cloud IT environment and presents a use case to demonstrate how Acronis Backup protects all data.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this article I will describe the Backup & Restore method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
In this article I will describe the Copy Database Wizard method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

679 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question