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


Post New Web Links

SQL Server 2005 64bit Install - Missing Management Studio

Posted By:      Posted Date: October 18, 2010    Points: 0   Category :Sql Server
 

Good Afternoon,

 

I just installed SQL Server 2005 64bit on a fresh system with no other applications loaded on running on the new server.

 

The only other component that was installed with the SS2K5 database services is SSIS. The base installation and the SP2 patch went on perfect.

 

I went looking for the Management Studio thru the Start menu options and it is NOT under the Microsoft SQL Server 2005 group. The only options under the SS2K5 group are "Configuration Tools" and "Docs and Tutorials".

 

Here are file names that I downloaded from the MS website and installed.

 

   SW CD SQL Svr Enterprise Edtn 2005 64Bit X64 English #1 x64 MLF.x11-57796 (which is a zipped)

 

   SQLServer2005SP2-KB921896-x64-ENU

 

There was also another zipped file that I tried to install but it seems to be a duplicate of the zipped file above:

 

SW CD SQL Svr Enterprise Edtn 2005 64Bit X64 English #2 x64 MLF.x11-57797

 

Any help would be greatly appriciated.

 

Thanks ALL!

 

J Kusch




View Complete Post


More Related Resource Links

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 2005 Management Studio error and cannot re-install client tools too system.serviceModel e

  

Hi,

got some regular OS patches today and voila:

sql management studio error: appidpackage failed to open connection dialog

Have tried to re-install client tools:

F:\>start /wait \setup.exe /qb REINSTALL=SQL_Tools90 REINSTALLMODE=OMUS

Success
The following error occurred:
Configuration system failed to initialize

Error result: -2068774911
Result facility code: 1201
Result error code: 1

Please review the summary.txt log for further details
The following error occurred:
Configuration system failed to initialize

Error result: -2068774911
Result facility code: 1201
Result error code: 1

Please review the summary.txt log for further details

Unhandled Exception: Microsoft.SqlServer.Chainer.Infrastructure.ChainerInfrastru
ctureException: Configuration system failed to initialize ---> System.Configurat
ion.ConfigurationErrorsException: Configuration system failed to initialize --->
 System.Configuration.ConfigurationErrorsException: Unrecognized configuration s
ection system.serviceModel. (C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Confi
g\machine.config line 146)
   at System.Configuration.ConfigurationSchemaErrors.ThrowIfErrors(Boolean ignor
eLocal)
   at System.Configuration.BaseC

SQL Server 2005 Management Studio error and cannot re-install client tools too system.serviceModel e

  

Hi,

got some regular OS patches today and voila:

sql management studio error: appidpackage failed to open connection dialog

Have tried to re-install client tools:

F:\>start /wait \setup.exe /qb REINSTALL=SQL_Tools90 REINSTALLMODE=OMUS

Success
The following error occurred:
Configuration system failed to initialize

Error result: -2068774911
Result facility code: 1201
Result error code: 1

Please review the summary.txt log for further details
The following error occurred:
Configuration system failed to initialize

Error result: -2068774911
Result facility code: 1201
Result error code: 1

Please review the summary.txt log for further details

Unhandled Exception: Microsoft.SqlServer.Chainer.Infrastructure.ChainerInfrastru
ctureException: Configuration system failed to initialize ---> System.Configurat
ion.ConfigurationErrorsException: Configuration system failed to initialize --->
 System.Configuration.ConfigurationErrorsException: Unrecognized configuration s
ection system.serviceModel. (C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Confi
g\machine.config line 146)
   at System.Configuration.ConfigurationSchemaErrors.ThrowIfErrors(Boolean ignor
eLocal)
   at System.Configuration.BaseC

Can't connect to SQL 2005 Enterprise using Management Studio with Server Name (only (local) works

  
This is a test system, everything running locally & no domains. Win 2003 Ent. Server & SQL Server 2005 Enterprise. I can't log into SQL Server Management Studio using the server name & using either Windows Authentication or SQL login. If I change the name of the server in the drop-down list to "(local)", I connect just fine (both Windows & SQL security modes). Shared Memory, Named Pipes & TCP/IP enabled in both server & client. Remote connections allowed. I have IP adresses (both 127.0.0.1 & external IP) in my hosts file pointing to the server name. Does SQL require a DNS server? This wouldn't be a problem except for the fact that I can't install SQL 2005 SP3 due to authentication failure since there's no way to enter (local) as the server name. SQL tools (management studio, SP install) seem to see the SQL server running but won't authenticate the user through any means other than setting server name to (local). This is driving me crazy!!!

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

PS2007/MSSQL2008: Cannot install Microsoft SQL Server 2005 Management Objects Collection (sqlserver2

  
Hi folks, about 1,5 months ago I have set up a - 1 server - development environment for PS2007. I had installed all components on one Windows 2008 box. Everything worked fine, now I receive an error. •MOSS 2007 •SQL 2008 SP1 •MOPS 2007 SP2 I have done the additional installation for the cube building part according to this page http://technet.microsoft.com/en-us/library/dd285466(office.12).aspx Microsoft SQL Server Native Client (sqlncli.msi) Microsoft SQL Server 2005 Management Objects Collection (sqlserver2005_xmo.msi) Microsoft SQL Server 2005 Backwards Compatibility Components (SQLServer2005_BC.msi) Everything worked fine. Cubes were able to be built.. everything was good. In order to have Reports built I added SSRS 2008 Reporting Services Addin for MOSS (rsSharePoint_x64) Business Intelligence Development Studio (=Visual Studio for MSSQL) No CUs have been added to this box. NOW, Cube creation fails with the error: ULS LOG: [CBS] ProjectServerOlapCubeGenerator status: Analysis Services session failed with the following error: Failed to connect to the Analysis Services server <IPADDRESS>. Error: ActiveX component can't create object 08efbc13-299a-4abe-9021-c46887ca6915 Eventlog says: SSP Name: SharedServices1 PSError: CBSASConnectionFailure (17003) Cube build failed to connect to the Analysis Services server. Verify the data source connection i

Installing SQL Server 2005 management studio express with Windows 7

  
I have bought a new laptop with windows 7 premium and i cannot install sql server management studio express. I have downloaded sp3 and i still reveive an error message that it is not compatible with the os. please help

how to connect my hosting database from my pc using sql server management studio 2005

  

Hi..

I have one asp.net hosting account with some service provider.. 

They have given me some xxx.xxxxxx.com to access sql server from my desktop... 

I enter xxx.xxxxx.com in server name and username and password but it will not connect.. 

so please let me know what are the steps i have to do to access my hosting database...

they have given sql server 2008 im using in local sql server 2005 management studio so let me know how to connect

thanks in advance


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

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!


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?


Management Studio for SQL Server 2005 Standard

  
I'm new to SQL Server and am just getting started with it. I received a copy of SQL Server 2005 Standard edition from the Launch Party here in Ottawa and successfully installed it on my server yesterday. I've look around the Internet, as well as the DVD for SQL Server Management Studio, but I have been unable to find it. The only thing that I have been able to find the the Management Studio Express which targets SQL Server 2005 Express. Can someone direct me to the Management Studio that targets the Standard edition?

Thank you.

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


SQL Server Management Studio 2005 forgets password?

  

I have a strange problem, every month the Connect to Server dialog in SQL Server 2005 Mgmt Studio will forget my passwords to all the servers I connect (yes I do have the Remember Password checked) to.

 

Anyone have this problem?

 

There is no "reset" or password clearing function I'm aware of?

 

This is a pain in to keep re-entering them as they are 40+ cryptic characters long.  Doing  a Google and I see this problem appears to be pretty common:

 

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1500433&SiteID=1

 

http://vaultofthoughts.net/MicrosoftSQLServerManagementStudioRememberPassword2.aspx

 

Rob


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.

 


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