Menu
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.
600
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.
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.
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.
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.
85
If the database is in your local machine, Just put a . (Dot) in Server Name and select the database.
33
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
