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


Top 5 Contributors of the Month
ffttt
Post New Web Links

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

Posted By:      Posted Date: November 16, 2010    Points: 0   Category :Sql Server
 

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.

 




View Complete Post


More Related Resource Links

Cannot install SQL Server 2008 Management Studio Express

  

I can't get the SQL Server Management Studio to install.  I'm running Windows 7 (32-bit), and have successfully installed the Sql Server 2008 R2 developer edition (from dreamspark.com).  Some of the SQL Server (SQLEXPRESS) advanced Properties are as follows:

File Version: 2007.100.4000.0

Instance ID: MSSQL10.SQLEXPRESS

64-bit OS: No

Service Pack Level: 2

Version 10.2.4000.0

I downloaded the x86 SSMS 2008 express from http://www.microsoft.com/downloads/en/details.aspx?FamilyID=08e52ac2-1d62-45f6-9a4a-4b76a8564a2b

When I execute the download, I get a compatibility issues message stating I must apply SQL Server 2008 SP1 or later before I run SS2008 on my version of windows.  When I run the program, it extracts all the files and then launches the SQL Server Installation Center.

I select the "Installation" option for a new SS stand-alone or add features, which then launches the Setup Support Rules (Passed: 7, Failed: 0, W:0 S:0).  I click OK, advancing to the Setup Support Files stage.  Clicking on install completes (P:10 F:0 W:1 (firewall) S:0), and then clicking on Next brings me to the Installation Type screen. I select the Add Features radio button & click Next, which then brings me to the Feature Selection screen.

It is here where I get stuck because I can't select any

How do you install SQL Server management studio express 2008?

  

Why do you make it so, so complicated?

I just want to install the piece of software that manages Azure databases. I've being downloading all kinds of files all day, getting incomprehensible error messages, and still am getting no where!

I'vw worked out that it's not this file: SQLManagementStudio_x86_ENU.exe

or this one: SQLEXPRWT_x86_ENU.exe

So please, which file is it, and where can I download it?


I installed SQL Server 2008 Express 64-bit, but I can't install SQL Server 2008 Management Studio E

  
I installed SQL Server 2008 Express 64-bit Runtime succesfully on my Windows Server 2008 Enterprise SP2 64-bit. However when I start the setup to install SQL Server 2008 Management Studio Express (SSMSE) 64-bit Edition, I get the following error message:

SQLManagementStudio_x64_ENU.exe is not a valid Win32 application. OK.

Conclusion: I can't install this Management Tool for SQL Express server. I don't understand the error message. All is 64-bit. Does the message mean that I have to install the 32-bit version? Why? That doesn't make sense, as everything is running in 64-bit.

Any resolution to this issue?

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

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


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 &

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

asp.net /Visual Studio 2008 Sql server studio management 2008

  
Hello,I am new to this developing on this platform and having problems at work and home but different problems.  At work when i try and view the aspx page it says unable to connect to the asp.net development server and also can't add the database to the app_data folder.  Are there problems with visual studio 2008 /Sql server 2008?set up at  work is belowL-06914  serverMicrosoft SQL Server Enterprise EditionMicrosoft Windows NT 5.1 (2600)At home, I was making a connection and almost bringing up the page  but had an error the next day could not connect inside of sql server 2008.  At home it is the same except for standard version server is my computer name Let me know if more information is needed. Thanks,  SB

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.   


sql server management studio express 2005 SP3 silent install

  
Hi, what are the commandline switches for sql server management studio express 2005 SP3 silent installation?

SQL Server Express 2008 and Visual Studio Express 2010

  

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




Trying to install SQL Management Studio Express 2008 64bit

  

I have VS2010 installed recently on a Windows 7 Home Premium laptop, SQL Express is running fine, but now i want to install Management Studio Express 2008 and it is not working.

I am using file: SQLManagementStudio_x64-ENU.exe

When I run it, it says it has "known compatibility issues". It says afterwards i need to install SQL Server SP1. I click Run Program, it extracts some files, then it come up with a window titled "SQL Server Installation Center"; but there is nothing having to do with Management Studio Express on any of the options. I have searched around the internet to know that this is a recurring problem, but i can not seem to find anyone that has an answer.

How do i get this to install?

Thanks


SteveS

SQL Server 2008 Management Studio Express and full version

  

We have SQL server 2008 installed in a virtual server and I just want to download tools for querying etc...om my pc. I downloaded the SQL Server 2008 Managemnt Express and installed the tools. My DBA is saying remove the express install and install the tools from the full version. Is he correct or could I have used the SSME install to query the full version?


Cannot Install SQL Server Management Studio after removing Express edition

  

I'm trying to upgrade my management studio to the full version, I uninstalled Express edition and started the install for the full version, but I get an error stating "you cannot install this component because it is already installed". I had a word with one of the guys in the office and he said the only way he's ever been able to get round this is by flattening the entire PC and starting again. Obviously I want to avoid that!


Management Studio Express Sql Server 2008 R2

  

Is it ok to use the RTM release of management studio express R2 in a production environment?

When will it be officially realeased? The engine was released on 9/29/2010....

 


SQL Server Management Studio (2005) and Visual Studio 2008

  

Help -

I had been using SQL Management Studio, from sql server 2005, reciently I installed Visual Studio 2008 on my machine.  I use it for VB coding.  I still use the same Management studio.  It all works fine except when I try and Export or Import a table in Management Studio using the wizard.  I get the following error:

TITLE: Microsoft SQL Server
------------------------------

This wizard will close because it encountered the following error:

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.3042.00&EvtSrc=Microsoft.SqlServer.Management.UI.WizardFrameworkErrorSR&EvtID=UncaughtException&LinkId=20476

------------------------------
ADDITIONAL INFORMATION:

Exception has been thrown by the target of an invocation. (mscorlib)

------------------------------

Specified method is not supported. (System.Data.SqlServerCe)

------------------------------
BUTTONS:

OK
------------------------------

Any help would be appreciated.

Thank you


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