Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

SQL Server specify correct named instance

Posted on 2011-03-20
3
Medium Priority
?
349 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:Murray Brown
3 Comments
 
LVL 17

Accepted Solution

by:
dbaSQL earned 1000 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 1000 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:Murray Brown
ID: 35178929
thanks for the help
0

Featured Post

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

Question has a verified solution.

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

In this article I will describe the Detach & Attach 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.
How to leverage one TLS certificate to encrypt Microsoft SQL traffic and Remote Desktop Services, versus creating multiple tickets for the same server.
This Micro Tutorial will teach you how to add a cinematic look to any film or video out there. There are very few simple steps that you will follow to do so. This will be demonstrated using Adobe Premiere Pro CS6.
Loops Section Overview

571 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