Error on login

Aug 28, 2009 at 6:10 PM

Hello,

 

When I try to login against my test server (an sql2008 express x32) I got following error:

 

 

Server Error in '/SqlWebAdmin' Application.

Retrieving the COM class factory for component with CLSID {10020200-E260-11CF-AE68-00AA004A34D5} failed due to the following error: 80040154.

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Runtime.InteropServices.COMException: Retrieving the COM class factory for component with CLSID {10020200-E260-11CF-AE68-00AA004A34D5} failed due to the following error: 80040154.

Source Error:

Line 171:		public void Connect() {
Line 172:
Line 173:			dmoServer = (NativeMethods.ISqlServer)new NativeMethods.SqlServer();
Line 174:			dmoServer.Bogus_LoginSecure2(this.IntegratedSecurity);
Line 175:			if(this.IntegratedSecurity == false) {


Source File: C:\Users\laurentiu\Downloads\smsweb-26743\Trunk\SqlAdmin\SqlServer.cs    Line: 173

Coordinator
Aug 31, 2009 at 12:16 PM

From Author: Thanks for testing in SQL 2008. I don't have SQL 2008 express installed in my machine yet. I will download and install one. Hopefully we can solve this issue together.

Aug 31, 2009 at 1:13 PM

I think that is related to some assembly(es) that maybe are different between 2005 and 2008. I don't have time this day(s) but I will test it in weekend angainst my production server that is not express but 2008 developer edition (x64).

 

Coordinator
Sep 2, 2009 at 2:12 PM
Edited Sep 2, 2009 at 2:19 PM

From Author: It took me a long day to download and install SQL Express 2008. I tested this program and have no problem.

Please check the components you installed.

Since I am using Visual Studio 2008, here is the list of files I installed.

Windows Installer 4,5

Visual Studio 2008 SP1

PowerShell

SQL Express 2008 Advance x86 32bit

Here is the screenshot.

[image:http://dev1.ichineserestaurant.org/sharedImages/SqlExpress2008Support.jpg]
The possible reason for the error you got is:
Your computer is 64bit.  
you try to run SQL Express 32 bit on a 64 bit computer.
Nov 23, 2009 at 5:28 PM

Hello:

I'm getting the same error when running on a Win7 x64 against a SQL Server 2008 (also x64)... I read somewhere about registering SQLDMO.dll, but that did not work. Any ideas? Have you tested this against x64?

Thank you very much!

Feb 11, 2010 at 11:50 AM

Try this...

Go to Microsoft SQL Server 2008 Feature Pack
(April 2009) at http://www.microsoft.com/downloads/details.aspx?FamilyID=b33d2c78-1059-4ce2-b80d-2343c099bcb4&displaylang=en

Download and install *** Microsoft SQL Server 2005 Backward Compatibility Components ***

You may need to update SQLDMO.dll under the folder /SqlWebAdmin/bin

Sep 17, 2010 at 12:54 AM
MartinPOON wrote:

Try this...

Go to Microsoft SQL Server 2008 Feature Pack
(April 2009) at http://www.microsoft.com/downloads/details.aspx?FamilyID=b33d2c78-1059-4ce2-b80d-2343c099bcb4&displaylang=en

Download and install *** Microsoft SQL Server 2005 Backward Compatibility Components ***

You may need to update SQLDMO.dll under the folder /SqlWebAdmin/bin

Downloading the SQLDMO.dll under the Backward Compatibility Components fixed the issue I had on iis 7.0, sql 2008, 32 bit Windows 7 machine.

Apr 27, 2011 at 11:55 AM
Edited Apr 27, 2011 at 11:58 AM
Line 40: 			SqlServer server = SqlServer.CurrentServer;
Line 41: 
Line 42: 			server.Connect();
Line 43:             SqlDatabaseCollection databases = server.Databases;
Line 44:             server.Disconnect();
 
Source File: c:\inetpub\SqlWebAdmin\Databases.aspx.cs    Line: 42 
Error: 80040154

I'm getting this error when you try to log on.

Windows Server 2008 R2 SP1

Microsoft SQL Server 2008 R2 Express