.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

After Install of Visual Studio 2010 SQLServer 2008 cannot Connect

Posted By:      Posted Date: April 10, 2011    Points: 0   Category :

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.

View Complete Post

More Related Resource Links

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


WPF Designer (in VS 2008 and VS 2010) crashes with Visual Studio

Good day all. I have the following question: WPF designer in both VS 2008 and VS 2010 crashes with Visual Studio when I try to edit UI form. Moreover, it crashes even when I try to save .xaml.cs file. Meanwhile, Winforms and Dataset UI editors work as usual. Are there other people met this issue? And how could I fix up this problem? Deleting the .suo file, uninstalling silverlight, repairing visual studio, and further googling did not help me. Thanks in advance.

Visual Studio 2010 - SQL 2008 or SQL 2008 R2

I have just rebuilt my development platform i.e. I ran the Windows 7 Ultimate setup app on an X86 platform followed by a fresh install of Visual Studio 2010 Prof. Using VS I opened up a solution created before the rebuild which includes a connection to an .mdf file. On attempting to connect to this file I Got an error message of the  follwing type. The database '.../XXX.MDF' cannot be opened because it is version 661. This server supports version 655 and earlier. A downgrade path is not supported. Referring to this link http://social.msdn.microsoft.com/Forums/en-US/sqlgetstarted/thread/0a4082a2-793e-42c3-9f68-95041002b4de, leads me to believe that VS2010 uses SQL Express 2008 for database access and that I had been using(unknowingly) SQL Express 2008 R2 during my previous development activities. If that is the case two questions arise :- Why does VS2010 install package install the four 2008 R2 components when I presume that these would also be incompatible with SQL Server Express 2008? Is there a version of SQL Server 2008 R2 - since I assume that R2 is the latest and greatest version - that I can install on my machine and if so how do I tell VS to use 2008 R2 rather than plain old 2008? I hope these questions do not seem like the meanderings of a raddled brain, but any light you can throw on them, would help me gain a better understanding of the relationship bet

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 &

Visual Studio 2010 Lab Environment for Student to deploy to a IIS 7.5 web server with SQL 2008

Currently the environment I am trying to create is a teaching lab for Visual Studio 2010 and ASP.NET website development. The intent is to setup an environment where students can create a website with an attached database written with the assistance of Visual Studio 2010. When the website is completed they need to use one of the Visual Studio deploy technologies to upload the website to a locally run server (Windows 2008 R2 with IIS 7.5 running and SQL Server 2008.) I am responsible for setting up the correct deploy technology in Visual Studio as well as setting up the IIS 7.5 deployment server that is running the right version of SQL Server. I have already started this process and figured out how to configure a deployment package in visual studio and have it published on our local server. I am trying to get a very streamlined environment that does not require students have to configure a lot of SQL strings and IIS settings because this is not really what the teaching lab is all about. Just to let you know, we have had  this exact setup using Visual Studio 2008, Server 2003 with front page server extensions on IIS 6.0 and SQL Server Compact edition running on the server. My issue is that since it is now time to update everything there does not seem to be something comparable. Any help would be greatly appreciated. If someone has an idea of the 

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


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

Windows XP, Visual Studio Express 2010 and SQL Server 2008 Express - How can I save modified columns



I am using c# in VS 2010 Express. I have a MDF database that I connect to through "Database Explorer". Database Explorer will not let me SAVE columns that I have modified. As I know in SQL Server 2008 full edition you can change the setting "Prevent saving changes that require table recreation" in Management Console to prevent this. I haven't got Management Console and can't see it in install.

How do I change this setting if I haven't got management console? Is it in Registry or Config File.



SQL Server 2008 R2 Developer with Visual Studio 2010 Pro always defaults using SQLEXPRESS


I had un-installed SQL Server 2008 Express that came with the Visual Studio 2010 Pro.

I had installed SQL Server 2008 R2 Developer, and Im able to connect through the Management Studio and Visual Studio itself.

The problem is: whenever I create a new ASP.NET Web Application, the web.config always defaults using SQLEXPRESS.

How can I change this within Visual Studio 2010 so that the web.config defaults to the new database SQL Server 2008 R2 Developer that I installed?

Can not establish a connection to SQL Server 2008 R2 via Visual Studio 2010 Framework 4.0


Hello All, I would appreciate any help with this.

I believe my problem exists within the web.config which already had code in it to connect to SQL Server Express 2008.

I uninstalled the SQL Server Express that came with Visual Studio 2010.

I installed SQL Server 2010 R2 Developer, and I'm able to connect via Management Studio and through Visual Studio's Server Explorer's Data Connections I am connected.

I did run aspnet_regsql.exe within the 4.0 folder in order to create the database with Microsoft Service Providers.

Here is the ServerName: USER-5529234649 

Here is the name of the DataBase:  StepByStepChapter9

Here is the name of the Connection within Visual Studio's Server Explorer's Data Connections:  user-5529234649.StepByStepChapter9.dbo

Here is the code I changed in the web.config:

      <!--<add name="ApplicationServices"
            connectionString="data source=.\SQLEXPRESS;Integrated   Security=SSPI;AttachDBFilename=|DataDirectory|\aspnetdb.mdf;User Instance=true"
            providerName="System.Data.SqlClient" />-->
      <add name="ApplicationServices" connectionString="data source=user-5529234649\Step

Deploying SSRS Reports from Visual Studio 2010 to Report Manager 2008


Our Report server is using Report Manager 2008. Previously I would load reports to it that I created via BIDS. Now I have to use VS 2010. I see that I can build and deploy reports there. Can I send it from VS 2010 to the REport manager 2008 on the other machine? I should add that now i have to develop on laptop only before i was on the server.

If not what are my options? I recall that vs 2005 objects were not taken in Report manager 2008.

Install of Tools block by Visual Studio 2008


Attempting to install SQL Server 2008 R2 x64 EE Slipstream Tools - Complete on W2K8R2x64 EE.

Blocked by another version of Visual Studio 2008. See below.

However, attempted to install Visual Studio 2008 SP1 (VS90sp1-kb945140-ENU.exe) but received error:

 A compatible version of Visual Studio 2008 was not detected on the system.

2010-09-28 09:25:58 Slp: Another version of Microsoft Visual Studio 2008 has been detected on this system that must be updated to SP1.  Please update all Visual Studio 2008 installations to SP1 level, by visiting Microsoft Update.
2010-09-28 09:26:01 Slp: Watson bucket for Msi based failure has been created
2010-09-28 09:26:01 Slp: InstallPackage: MsiInstallProduct returned the result code 1603.
2010-09-28 09:26:01 Slp: No retry-able MSI return code detected.
2010-09-28 09:26:01 Slp: Checkpoint: INSTALL_TRIN_AIDE_CPU32_ACTION
2010-09-28 09:26:01 Slp: Error: Action "Install_trin_aide_Cpu32_Action" failed during execution.
2010-09-28 09:26:01 Slp: Completed Action: Install_trin_aide_Cpu32_Action, returned False

Server also has FAST Search installed

Microsoft Visual C++ 2008 SP1 Redistributable - x64 9.0.30729.17 is installed

Microsoft Primary Interoperability Assemblies 2005 9.0.21022 is insta

After Visual Studio 2010 conversion from 2008 pages won't display in browser correctly


I just upgraded to 2010 and converted my VS 2008 ASP.NET web application. There were no conversion errors and everything displays in the Design mode correctly but when I try to View in Browser or debug the site won't display. I just get a blank page untitled page displayed.

Can anyone help me out with this problem?


SQL Server Express 2008 and Visual Studio Express 2010



A few months ago I upgraded to VS2010 - at the same time I thought it would be good to upgrade to SQL Express 2008 R2.

It turned out that there was some compatibility issues between the two - "...cannot be opened because it is version 661. This server supports version 655 and earlier. A downgrade path is not supported."  After much trouble I restored the database and have done most of the stuff I need through VS itself.

Now I need to use SQL itself and am positively scared to death of what it could do to my database again.  Can anyone offer any advice - it is a service pack update or something...?



Visual studio 2010 and SQL Express 2008 with advanced series


Hi I recently found out that you can only do full text indexing with the advanced series of SQL Express and I managed to download and install it on my machine.

My question is how do I integrate it with Visual studios 2010 so that I can do the full text indexing ?

When I installed SQL Express with advanced series 2008, it created an instance of SQL Server management studio so im wondering if I have to do it there and then move the database into my project or if I can do the full text indexing from inside my project

Anyone's help would be much appreciated

Windows Application Migration - Visual Studio 2008 to 2010 - The "GenerateResource" task failed unex


I hav a windows forms application built using VS 2008 which I am trying to migrate to VS 2010 & .net 4.0.

I got this nasty bug and found that it is due to the embedded images in the resource file.

<!-- [if gte mso 10]> <mce:style>

The "GenerateResource" task failed unexpectedly. System.InvalidOperationException: The security state of an AppDomain was modified by an AppDomainManager configured with the NoSecurityChanges flag.

I tried the following solutions suggested in various forums.

I added the < NetFx40_LegacySecurityPolicy enabled

Can not add assembly reference and using .dll file from Visual studio 2008 and 2010 Type 'LibraryN


Hi all,

Please tell me the way to solved my problem to looking for a long time.

My System Info:

OS: Windows 7 - Ultimate - 64bit

VS: Visual Studio 2008 - Professional (and problem with my VS2010 installed)


I have a small project and build it to library .dll file with some function util.

From an other website (with diffirence solution). I added reference the .dll before to website.

In website, I declaration to using the function in library (dll file before). But I found error:  Error 1 Type 'LibraryName' is not defined.

And in VS2010 the problem is same.

But, run website on an other computer, it work normally.

Thanks and Best regards.

visual studio 2010 and 2008 ide on windows 7 64 bit seems to be blocked from reading the registry


I am using:
1. visual studio 2008 and visual studio 2010
2. windows 7 ultimate
3. 64 bit gateway
4. I am using a third party control that has been registered using regsvr32
5. its wrapper was created with 64 bit aximp
6. The code runs but  in design mode nothing shows:
Warning 1 Class not registered (Exception from HRESULT: 0x80040154 (REGDB_E_CLASSNOTREG))  0 0 

7.I used regedit and tried to give all the user's permission to read the registry entry for the item - didn't work.

8. The same code and situation works fine in windows vista home: which means  visual studio cannot read the registry on the windows 7 pc

What do I need to do

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