Visual Studio 2008 Connection to SQL Server 2008

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.
Thanks
AlStoughtonAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Reza RadConsultant, TrainerCommented:
in menu:
data
show data sources
in data sources window
add new data source
set properties of MSSQLServer instance here
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
AlStoughtonAuthor Commented:
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.
0
13598Commented:
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.
0
AlStoughtonAuthor Commented:
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.
0
AlStoughtonAuthor Commented:
Not the complete solution but put me in the ball park.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
.NET Programming

From novice to tech pro — start learning today.