.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

Can't connect to database after installing visual studio 2008 sp1

Posted By:      Posted Date: September 21, 2010    Points: 0   Category :Sql Server

Hi, it looks like visual studio 2008 sp1 broke something in katmai managment studio - now when i try conneect to my db server, i'm getting error message below(no problems though connecting to the same server with sql managment studio 2005):



Error connecting to 'XXX\SQL2005'.


Failed to retrieve data for this request. (Microsoft.SqlServer.Management.Sdk.Sfc.EnumeratorCore)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&LinkId=20476

Program Location:

   at Microsoft.SqlServer.Management.Sdk.Sfc.Enumerator.Process(Object connectionInfo, Request request)
   at Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.SupportedServers.GetSqlEngineEdition(SqlOlapConnectionInfoBase connectionInfo)
   at Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.SupportedServers.GetHierarchyBuilder(SqlOlapConnectionInfoBase connectionInfo)
   at Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.ObjectExplorer.GetObjec

View Complete Post

More Related Resource Links

SQL database display in visual studio 2008 express?

I jsut installed SQL server and management studio on my PC. For management studio, I created a database with tables. However, When I have data connection for SQL server in visual studio express, I couldn' t see the database I created. Any recommendations?   Xinguo  

Can not connect to user instance of SQL Server 2008 Express with Advance Services in Visual Studio 2

I used SQL Server 2008 Express with Advanced Services (not SQL Server 2008 Express) in Visual Studio 2010 because it is the fast and easy way to developed and managed data-driven applications with powerful built-in reporting and full-text search functionality. I received Sql Server 2008 Service Pack 1 with Windows Update. It's ok if I connect to instance of SQL Server 2008 Express with Advance Services (with SP1) through SQL Server Management, but if I try to attach a database in Server Explorer (Visual Studio 2010), I get the following error: "Failed to generate a user instance of SQL Server due to a failure in starting the process for the user instance. The connection will be closed." I'm stuck at this point. Is there a fix or a workaround? I've already tried deleting the 'C:\Users\Administrtor\AppData\Local\Microsoft\Microsoft SQL Server Data\SQLEXPRESS' directory as mentioned in other posts, with no luck. The error.log at 'C:\Users\Administrator\AppData\Local\Microsoft\Microsoft SQL Server Data\SQLEXPRESS\error.log' has the following relevant entries: 2010-09-01 14:44:10.47 Server      Error: 17156, Severity: 16, State: 1. 2010-09-01 14:44:10.47 Server      initeventlog: Could not initiate the EventLog Service for the key '3677F6D3-17C7-4F', last error code is 2. 2010-09-01 14:44:10.47 Server &

Problem installing SQL 2008 Tools with Visual Studio 2008 Team System Suite

I'm setting-up my development environment on a new laptop running Windows 7 Ultimate 64 bit. I installed Visual Studio Team System (MSDN disk 4405)  and then VS 2008 SP1. These installed without error.

Next I installed SQL Express 2008, but had a problem with running the standard install from www.microsoft.com/express/sql/download - message stating that SQL 2008 with Tools was incompatable with SQL 2005 (which was installed as part of the VSTS 2008 install - instance SQLEXPRESS). Therefore, I used the custom install link on this webpage to install SQL Express 2008 with SP1 - X64. I selected the 'New Standalone Instal or Add Features' and it completed without error - instance MSSQLSERVER2008. I selected the install with SP1 because this seemed to be required for a PC with VS 2008 installed (see other threads), hoping that it would be possible to install the tools later. However, when I came to install the SQL Express 2008 Tools (custom install page install SQL Express 2008 with Tools) I hit the following problems:

1. I got message stating that there was a compatability issue which required me to run SQL 2008 SP1 after the install - funny, I had just installed SQL 2008 SP1!

Ignoring the message, I proceeded with the install sel

Cannot connect Visual Studio 2008 to Sql Server 2005


I have Windows 7 and installed Visual Studio 2008 Pro and also installed SQL server developer addiotion that comes with VS. After creating a test database in SQL maangement studio and adding the standard asp.net membership provider tables with the aspnet_regsql tool, I created a web project and added a connection string to the web.config file to connect to the database.

No matter what, I cannot connect to the database.

I can create a connection through the server explorer in visual studio and when I drag a sqldatasource onto my page and configure it I can connect to the database etc. But no web.config connection.

This worked on my XP pro machine but not Windows 7.

Has anybody had this problem and what am I doing wrong.


After Install of Visual Studio 2010 SQLServer 2008 cannot Connect


SQL Server 2008 was working fine. I have Visual C# 2008 Express Installed.

I just installed Visual Studio 2010 Professional and now I cannot connect to SQL Server 2008.

One of the forums said to install SP1, VS studio 2010 comes with SP1.

Can't connect to SQL Express 2008 from Visual Studio, but can connect from SQL Server Management St



I've been struggling with the following issue for 3 days:  I can access and use my SQL Express 2008R2 database flawlessly from SQL Server Management Studio.  But I can only intermittently access it from Visual Studio (ultimate edition with TF Server).  Sometimes it works, sometimes it doesn't.  I mostly see the error when I try to "Update Model from Database" within my Entity framework model, or when I try to access the database from within Server Explorer.


Here is the error I see when I try to update my Entities form the Database: An error occurred while connecting to the database.  The database might be unavailable.  An exception of type 'System.Data.SqlClient.SqlException' occurred.  The error message is: 'Cannot open user default database. Login failed.  Login failed for user 'Tim-PC\Tim'.'


I think the connection string is fine as I am able to connect

Visual Studio 2008 Memory problems


My memory in task manager reaches about 900,000K  and I don't know why it does this. Definately slows everything down, especially when I rebuild my tableAdapters, takes about 30 seconds sometimes to rebuild the project.

is it possible to convert whole visual studio 2008 web site project to visual studio 2010 web site p


is it possible to convert whole visual studio 2008 web site project to visual studio 2010 web site project


my current project references




i have a very annoying iis problem

iis server stops working until app pool is recycled


i am hoping that new visual studio (net framework 4.0) may solve this very annoying unsolveable problem


Business Intelligence Reports Project in Visual studio 2008 ?



I wonder how to add a project template called  Intelligence Reports, something like that, to Visual studio 2008. I have SQL 2008 installed. Do I need to install some updates to get Intelligence Reports template to Visual studio 2008 ?

Thank you..

Visual Studio Web Deployment Project for VS 2008


What is the latest version of Visual Studio web deployment project which I can use with  VS 2008 ?

Can I use VS 2010 Web Deployment Project with  VS 2008 ?


crystal report -visual studio 2008 dual axis chart (bar & line)


dear all, 

i use crystal report integrated with  vs.2008, and i want to make chart with dual axis (bar & line).

i have used bar chart and input the data with 2 values..

then in chart options > template, i activated the dual axis..

my question is, how i can change the 2nd value with line chart not bar chart??

i'd tried to find the right settings in "chart options" but still can't find the solution.

for information in "chart options" there are 4 sub menu : template, general,titles,grid..

i read in a tutorial there's more sub menu called "series" in crystal report (stand alone version)..

is it possible doing it in Crystal Report VS. 2008?

please,, i need your advice and solution..

Thanx before..


Toolbox: Database and OR/M Tools, Oren Eini and Custom Visual Studio Tabs


This month we look at tools for enhancing the LINQ to SQL and Entity Framework designers, Oren Eini's .NET development blog, Visual Studio tab customization, and more.

Scott Mitchell

MSDN Magazine December 2009

VSTO 3.0: Developing Office Business Apps with Visual Studio 2008


With custom form regions in Outlook you can pull in data from designated data sources and truly customize your users' Outlook 2007 experience.

Steve Fox

MSDN Magazine Launch 2008

Foundations: What's New for WCF in Visual Studio 2008


Visual Studio 2008 and the .NET Framework 3.5 provide new tools and support that extends Windows Communication Foundation (WCF). Visual Studio 2008 also automates a number of manual WCF tasks for the developer as well.

Juval Lowy

MSDN Magazine February 2008

Data Joins The Team: Introducing Visual Studio 2005 Team Edition for Database Professionals


Here Brian Randell presents everything you need to know to get started with Visual Studio 2005 Team Edition for Database Professionals.

Brian A. Randell

MSDN Magazine February 2007

Speed Up Visual Studio 2008

The article Speed Up Visual Studio 2008 was added by tmorton on Monday, August 09, 2010.

1- Disable toolbox populate from the mainmenu open Tools->Options Select the general tab under Windows Forms Designer Set AutoToolBoxPopulate to false. Although the setting is under Windows Forms Designer, it is just as effective for ASP.Net developers

Login database with visual studio 2010 asp website template


Has anyone deployed a website using the login database in the visual studio 2010 asp website template? I was wondering if I could look at someone's example to see how the integrated this into their website.

ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend