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


Top 5 Contributors of the Month
david stephan
Fauzul Azmi
Asad Ali
Post New Web Links

SQL Server Express 2008 and Visual Studio Express 2010

Posted By:      Posted Date: October 04, 2010    Points: 0   Category :ASP.Net
 

Hi,


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


Thanks


John






View Complete Post


More Related Resource Links

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

  

Hi,

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.

Thanks.

John.   


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 &

Failed to generate a user instance of SQL Server 2008 Express with Advance Services in Visual Studio

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


Visual Web Developer 2010 Express - installation on Windows Server 2008

  

Hi,

We are trying to install VWD 2010 on a windows 2008 server. We already have installed the 2008 version as well as SQL 2005, 2008 and 2008 R2. The Web Platform installer is not installing VWD 2010 however.

At first it notified us that the OS does not allow it, after running tons of updates on the OS (some of which failed) it is still not doing it, not even donwloading it. The latest message simply asked us to post the error on the forum.

Has anybody had similar experiences? If so, how was it solved?

Cheers,

D



creating a sql server express from visual studio 2010

  

Hi All,

I am trying to add a database using VS2010, I have VS2010 Professional and SQL server 2008 developer and sql server 2008 express and it seems impossible for me to create a database am being sent to the linkid=125883 to download an express edition even though i have it installed.

anyone has a solution.


Regards


SQL Server 2008 Express Management Studio fails to install because it thinks visual studio is instal

  

I tried to install SQL Server 2008 R1 Express with Tools on Windows Server 2008 R2. It installed, but the management studio failed to install because it said I already had Visual Studio installed and it needed Visual Studio service pack 1 before Management Studio could install.

Visual Studio is nowhere to be found in Programs and Features, and when I try to install Visual Studio SP1, it won't install, saying:

A compatible version of Visual Studio 2008 was not detected on the system. This update is designed for only the Microsoft Visual Studio 2008 (ENU) product family, and is not compatible with any Express editions.

Though I can't find any Express version of SP1 to try, and there is no SP1 in windows update.

 


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

CSS support in visual studio 2008 express edition

  

I have several css style sheets I want to work with.  I have copied them into the appropriate directory structure in my project.  The styles are applied correctly.

But the manage CSS styles tool bar on the left margin doesn't seem to work correctly.  At one point I had generated a style sheet and worked with it there, but now it not only can't find the one it generated, but the attach style sheet link doesn't respond at all, nor does anything in this bar.  Same deadness with the CSS Properties bar.  With or without a style sheet loaded in the editor -- a style sheet that is active in the project such that when I run it, the styles are applied.

VB version of studio, running on Vista home basic.


PS, the design mode works a lot better than the professional version I use in my day job on XP and server 2003.



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)
----------------------------


SQL 2008 Express with advanced services and Visual studios 2010

  
Hi could someone please help me. Im running the following software: SQL 2008 Express R2 with advanced services Visual Studios 2010 Ultimate   I am trying to using Sql in Visual studios to use full text indexing but I am attaching a database that already exists. My problem is that I can use the full text indexing? I had it working once but then when i tried to FREETEXT search through my table it said that I didn't have an index on that table when I know I do cause I went to make sure. I think that perhaps its referencing the wrong database because I cant seem to add the database into my project? I am so confused as to how SQL express instances work so not sure what I am doing wrong? PLEASE HELP? 

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  

Management Studio sql 2005 Express on Windows Server 2008 r2

  
Hi , i have install a application that use sql server express 2005 on a server with OS windows server 2008 r2. My question is how to make automatic backup of my database , because i cant install SQL Server 2005 Management Console on my server .   Please help me Thanks

how to make working WPF 2010 program make changes to SQL Server 2008 Express files

  
(1) I have a working WPF 2010 program that manipulates a table in SQL Server 2008 Express (2) the program does delete, update, select and insert correctly however in its own project file folder logbooklmk.mdf   logbooklmk_log.ldf (3) I want the actual SQL Server 2008 express files to be changed yes I know the issue is sharing and the copy option only applies to the local project files. I found this out by trying always copy, never copy and copy if newer. I probably have to change the .xsd folder to refer to the actual SQL Server 2008 Express file. Tried that once and it failed. Something about sharing not allowed.

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 

How to connect visual web developer 2008 express edition to SQL server 2008 ??

  
i know its a basic question guys! please help me . i have created a login.aspx file in visual web developer .now i want to connect the username and password details to SQL database ... How do i do it .....I can see some grt genius out there, i am sure some one is kind enough to help me with this question !!! thank you .....................................

Error code -2068578304 When Installing Express SP1 x64 as a Part of Visual Studio 2010 Installation

  
Howdy! I was installing the VS 2010 on my server running Windows Server 2008 R2 x64 and all of a sudden the setup finished with " Setup completed, however, there were failures reported installing optional components. " The final status is success. The left-hand pane of the finish page reads as: The following component failed to install: Microsoft SQL Server 2008 Express Service Pack 1 (x64).   Leaving alone the fact why setup executed the custom action that tried to install SQL Server Express Edition and Compact Edition when I just asked it to install SQL components (which presumably should be SQL SMO and DMO libraries), I would like to understand what had happed to Express install.   Inspecting the .\Logs\dd_error_vs_vstdcore_100.txt file gives the following record:   [09/16/10,16:06:51] Microsoft SQL Server 2008 Express Service Pack 1 (x64): [2] Error code -2068578304 for this component is not recognized. [09/16/10,16:06:51] Microsoft SQL Server 2008 Express Service Pack 1 (x64): [2] Component Microsoft SQL Server 2008 Express Service Pack 1 (x64) returned an unexpected value. ***EndOfSession***   Further inspection of the dd_install_vs_vstdcore_100.txt provides with the info:   [09/16/10,16:02:51] Microsoft SQL Server 2008 Express Service Pack 1 (x64): GenericComponent Action: CreateProcess launched with cmd line : x:\setup\..\wcu\sse\SQLE
Categories: 
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