Visual Studio 2008 Connection to SQL Server 2008

Posted on 2010-04-04
Medium Priority
Last Modified: 2013-11-26
Using Visual Studio 2008 Server Explorer I don't see SQL Server 2008 instance when I try to Add a New Data Source connection.  I see a SQL Express instance but not the MSSQLServer instance.  I can see and access databases using SQL Management Studio -- no problem.  Visual Studio Add Connection wizard doesn's show it and I have tried Refresh.  [Whu does ot see SQL Express if that servce is stopped.]
Visual Studio 2008 was installed first (after Microsoft Office 2007) and then SQL Server 2008 installation was successful.  I assume SQL Express instance was added by Visual Studio.  SQLExpress service is stopped; MSSQLServer and SQL Browser are both Started.
Beginning to expect my installation order was wrong but I didn't see any errors or problems.
Question by:AlStoughton
  • 3
LVL 30

Accepted Solution

Reza Rad earned 1500 total points
ID: 29755189
in menu:
show data sources
in data sources window
add new data source
set properties of MSSQLServer instance here

Author Comment

ID: 29785373
No go.  Seems that there is no explicit Daat menu item in VS 2008 -- i wprking on a Report Project.  But when I right-click Reports in Solution Explorer to add a new data source, I end up with the saem Connection Properties dialog and I'm back at the same problem.  Only rhe SQLExpress instance is listed.  

Thanks for the suggestion but still no solution.

I'm eally puzzled because I can see the instance and the database in SQL Management Studio.  This seems to be something weird between Visual Studio 2008 and SQL Server.  I;m wodering if it's because I installed SQL Server 2008 after VS.  During the SQL Installation, it installed NET Framework SP1.  Wonder if that had any effect on VS.
LVL 16

Expert Comment

ID: 29790461
You mentioned you are working on a report project, are you trying to use reporting services? If so, did you install BI (Business Intelligence) when you installed SQL?
If not, run the SQL install and select BI.

Author Comment

ID: 29790642
Problem solved (but not really sure how or why).  I re-installed VS SP1 and then in IN VS Connection Properties dialog I manually entered the SAL Server instance name as displayed in Managment Studio.  That led to a successful connection.

Author Closing Comment

ID: 31710733
Not the complete solution but put me in the ball park.

Featured Post

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
Simulator games are perfect for generating sample realistic data streams, especially for learning data analysis. It is even useful for demoing offerings such as Azure stream analytics, PowerBI etc.
SQL Database Recovery Software repairs the MDF & NDF Files, corrupted due to hardware related issues or software related errors. Provides preview of recovered database objects and allows saving in either MSSQL, CSV, HTML or XLS format. Ensures recov…
Stellar Phoenix SQL Database Repair software easily fixes the suspect mode issue of SQL Server database. It is a simple process to bring the database from suspect mode to normal mode. Check out the video and fix the SQL database suspect mode problem.

624 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