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

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

Visaul studio 2010 has problems with sql server 2008 R2 64bit

Posted By:      Posted Date: September 18, 2010    Points: 0   Category :ASP.Net
Visaul studio 2010 has problems with sql server 2008 R2 64bit or it's my idea?because icant create a new database in my asp.net web site  it says to  go and download it

View Complete Post

More Related Resource Links

SQL Server 2008 Development problems with Visual Studio 2010 Ultimate uninstall and VS2010 premium i


I installed VS2010 Ultimate to test it out but had license for the VS2010 premium only.  After uninstalling ultimate and reinstalling VS2010 premium, my SQL Server 2008 now refuses to connect to my databases stating: 

TITLE: Connect to Server

Cannot connect to Q9300\SQL200801.


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 

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

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...?



Help deploying Windows Service to 64bit Server usinf Visual Studio 2008 Setup Project?

I have a Windows Service I created a while back for our Win2003/2008 32bit Servers, written in Visual Studio 2008, deployed via a VS2k8 Setup Project.  Everything works great, installs fine, and runs as it should.  There is no platform dependent code, it's all straight-up .Net Framework stuff, so we thought it should deploy to a Win2008 64bit Server just fine.  But this seems not to be the case.

When I try to install the Service as is on the 64bit machine, the service and associated DLL's are installed to the "C:\Windows\SysWOW64" folder, but when you right click the Service itself and look at the properties, it is trying to find the .exe file in the "C:\Windows\System32" folder. This difference prevents the service from running, obviously.

If I change the Setup Project settings, set the Target Platform to "x64" and change in the File System screen to use the "System (64-bit) Folder" placing the files in there and re-run the setup.exe on the server.... now the files are correctly installed to the "C:\Windows\System32" folder, but the Service itself is not 'installed', that is it *does not* show up in the Services Manager.

Just for the giggles of it I tried to manually install the service using 'installutil.exe' in the .Net Fra

Visual Studio 2010 & SQL Server 2008 R2



I had created tables & insert data in SQL Server 2008 R2. And now I want to bind combo box in visual studio 2010 to the table I created. First, I need  to add data source in Visual Studio 2010. When I added data source and continue the following wizard, dataset was created at last. But I don't want it. As I remember used old version of visual studio, I can add whole SQL Server to data source in visual studio, I can even create table & insert data in it. But I don't know how to create it at Visual Studio 2010. Anyone know it? I am quite urgent of it.





I cannot get visual studio 2010, SQL Server 2008, and .NET Framework 3.5 or 4.0 to deploy a very sim


Creating [SqlClassLibrary]...

C:\Projects\SqlClassLibrary\bin\Debug\SqlClassLibrary.sql(39-39): Deploy error SQL01268: .Net SqlClient Data Provider: Msg 6218, Level 16, State 3, Line 1 CREATE ASSEMBLY for assembly 'SqlClassLibrary' failed because assembly 'SqlClassLibrary' failed verification. Check if the referenced assemblies are up-to-date and trusted (for external_access or unsafe) to execute in the database. CLR Verifier error messages if any will follow this message

An error occurred while the batch was being executed.


Time Elapsed 00:00:06.23

========== Build: 1 succeeded or up-to-date, 0 failed, 0 skipped ==========

========== Deploy: 0 succeeded, 1 failed, 0 skipped ==========

Visual Studio 2008 & 2010 can't see my SQL Server 2008 R2 instance in add conncetion dialog box


I have installed SQL Server 2008 R2, then I installed VS2008 and VS2010 and when I start VS and go to the Data menu to add a data source, dialog box appear and ask me to select SQL instance. When i scroll nothings there!!!

I don't see my SQL instance.  the instance is: AYDINROSE-PC\SQLSERVER. By the way my Server Agent is not starting is this may present the problem?

I need this because I need to work with data on windows forms, but this error is blocking me to finish my work. Can someone PLEASE help me with this topic.

Thanks in  advance...

CLR Deployment issue sql server 2008 r2 visual studio 2010



 i am getting the following error while deploying the clr project converted frm vs2008 to vs2010. Please help me


Compile complete -- 0 errors, 24 warnings

Bloomberg_WSDL -> D:\Projects\STP\Development\BBG-WSDL\SS-BBG-WSDL\bin\Release\Bloomberg_WSDL.dll

------ Deploy started: Project: Bloomberg_WSDL, Configuration: Release Any CPU ------

Build started 11/22/2010 7:07:50 PM.


Beginning deployment of assembly Bloomberg_WSDL.dll to server : stpQA01

C:\Program Files (x86)\MSBuild\Microsoft\VisualStudio\v10.0\TeamData\Microsoft.Data.Schema.SqlClr.targets(96,5): error : Could not connect to server stpQA01 : Login failed for user 'stpuser'.


Time Elapsed 00:00:00.07

========== Build: 1 succeeded or up-to-date, 0 failed, 0 skipped ==========

========== Deploy: 0 succeeded, 1 failed, 0 skipped ==========


Upgrading from VS 2008 to VS 2010 and problems with 64 bit server


I upgraded from VS2008 to vs2010. I converted my web project to vs2010.

I built my solution and was able to run it locally on my developmenet machine (32 bit). I publish it to my web server (Windows Server 2003 R2 Enterprise x 64 Edition). Then I got an error message that said -

Could not load file or assembly 'interop.adodb' or one of its dependencies. An attempt was made to load a program with an incorrect format.

I rebuilt my solution changing the target platform to x86. The error is then replaced with

Could not load file or assembly 'ProjectName'or one of its dependencies. An attempt was made to load a program with an incorrect format.

Assembly manager loaded from: C:\WINDOWS\Microsoft.NET\Framework64\v4.0.30319\clr.dll
Running under executable c:\windows\system32\inetsrv\w3wp.exe

It worked when it was 2.0 and it wouldn't use the framework64 folder but just framework.

How do I force my server to run a 32 bit application since I'm assuming I must have other 32 bit dlls resulting in the same error as the interop issue.


Referencing SQL Server 2008 R2 SMO from Visual Studio 2010


Hello.  We read a number of things about referencing SQL Server SMO from Visual Studio but still don't have the definite answers we need.  So, here it goes...

A number of years ago we created a C# application using Visual Studio 2005 and SQL Server 2005.  In that application, we added .NET references to a number of SQL Server SMO objects, and everything worked fine.  Those references were:

Microsoft.SqlServer.ConnectionInfo    GAC
Microsoft.SqlServer.Smo            GAC
Microsoft.SqlServer.SqlEnum        GAC

We have now migrated to Visual Studio 2010 and SQL Server 2008 R2.  However, when we try to reference those same SMO objects for SQL Server 2008 R2, they don't appear in the .NET references tab.  We're wanting to reference the SQL Server 2008 R2 version of those same SMO assemblies for our upgraded C# application.

On our development machines, we have SQL Server 2008 R2 Developer installed with all options, including the SDK such that the assemblies are found in C:\Program Files (x86)\Microsoft SQL Server\100\SDK\Assemblies.

So, my first questions are: Are we supposed to do file references to the SMO assemblies instead

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


VS Studio WorkFlow Failed on Start in MOSS 2007 ON Windows Server 2008 64 Bit


I have created a sequential sharepoint workflow in WSP Builder in my Sharepoint Server and Deployed it.

But the workflows says Failed on start and retrying ans stops there forever says couldn't start the workflow.

I repaired .NET Framework 3.5sp1 installed

 tried this

 1. I tried again, in C Prompt:  Lodctr "c:\Windows\Microsoft.Net\Framework\v3.0\Windows Workflow Foundation\perfcounters.ini"  it says initiation file cannot be found

2   i again tried this C prompt Lodctr /R "c:\Windows\Microsoft.Net\Framework\v3.0\Windows Workflow Foundation\perfcounters.ini"

it says reloaded  from the system restored

i am still getting the same error.

When i manually go to my  C:\Windows\Microsoft.NET\Framework\v3.0\Windows Workflow Foundation i can see a folder for SQL that's it nothing more than that..

I dont know what is happening i am trying it from 2 days and still no solution.

any ideas would be real great help for me.

My system is 64 bit , Window server 2008, MOSS SP2, Visual Studio 2008 Version 9.0.30729.

.Net Framework 3.5 sp1

and WSP builder the one from Codeplex for 64 bit machines

How to connect to local instance of SQL Server 2008 Management Studio Express ?


I just installed SQL Server 2008 Management studio Express on my Vista machine.

i tried connecting to local machine using :

.\sqlexpress, (local)\sqlexpress, or .\SQLExpress, MyPCNAME\SQLExpress

nothing is working, getting this error:

Cannot connect to PC-NAME\SQLEXPRESS. A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)

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