Logo Questions Linux Laravel Mysql Ubuntu Git Menu
HTML CSS JAVASCRIPT SQL PYTHON PHP BOOTSTRAP JAVA JQUERY R React Kotlin
 

Visual Studio not showing server name when adding connection

Tags:

c#

database

sql-server

visual-studio-2010

I'm using Visual Studio 2010 and SQL Server 2012. When I try to connect to SQL Server through Visual Studio, I don't get my server name on Add connection drop down menu.

like image 600
user3786234 Avatar asked Oct 25 '14 06:10

user3786234

People also ask

How do I add a server to Visual Studio?

Add a connection in Server Explorer To create a connection to the database, click the Add Connection icon in Server Explorer, or right-click in Server Explorer on the Data Connections node and select Add Connection.

How do I find the SQL Server name in Visual Studio?

Open up SQL Server Configuration Manager (search for it in the Start menu). Click on SQL Server Services . The instance name of SQL Server is in parenthesis inline with SQL Server service. If it says MSSQLSERVER, then it's the default instance.

How do I add a connection string in Visual Studio?

In Solution Explorer, double-click the My Project icon (Visual Basic) or Properties icon (C#) to open the Project Designer. Select the Settings tab. Enter a Name for the connection string. Refer to this name when accessing the connection string in code.

2 Answers

Go to SQL Server Management Studio to look for the correct Server Name and copy the value. Make all the configurations by yourself at the end just click Test connection button. If the connection is test successfully proceed with your work.

like image 85
mybirthname Avatar answered Oct 07 '22 00:10

mybirthname

If the database is in your local machine, Just put a . (Dot) in Server Name and select the database.

Add connection dialogue

like image 33
Venkataraghavan Yanamandram Avatar answered Oct 07 '22 01:10

Venkataraghavan Yanamandram
Sign in to Comment

Related questions

How to create in memory XML document and get string out of it
Non-Nullable String Initializes as Null
OnNavigatedTo vs Load event
What is the purpose of the "get" and "set" properties in C#
Iterating through a list with out using ForEach loop
Using selenium to save images from page
C# .Net 4.5 PropertyGrid: how to hide Properties
Why can I not return a List<Foo> if asked for a List<IFoo>? [duplicate]
Yield keyword value added?
Why lock(<integer var>) is not allowed, but Monitor.Enter(<integer var>) allowed?
Auto size the controls in winform
C# Priority Queue
Get all sub directories that only contain files
How to call the method in thread with arguments and return some value
Rx - unsubscribing from events
in c#, how can i build up array from A to ZZ that is similar to the way that excel orders columns
htmlAttributes not merging with tag builder in my extension
C# WinForms DragEnter never fires
Type or namespace name 'Properties' does not exist
How can I refactor out the required else clause?

Donate For Us

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!