1
Vote

It doesn't work in Windows Server 2008

description

When I put it in Windows Server 2008 it gives me fallowing error:
 
Error Message:
Retrieving the COM class factory for component with CLSID {10020200-E260-11CF-AE68-00AA004A34D5} failed due to the following error: 80040154.
 
Stack Trace:
at SqlAdmin.SqlServer.Connect() in C:\SqlWebAdmin\SqlAdmin\SqlServer.cs:line 198
at SqlWebAdmin.databases.Page_Load(Object sender, EventArgs e) in c:\sqlwebadmin\www\Databases.aspx.cs:line 42
 
It works in server 2003

comments

kjustice wrote Jul 27, 2009 at 2:58 PM

Anyone have any solution on this? I just moved my webs to server 08 and have the exact same error.

highportal wrote Aug 21, 2009 at 12:48 PM

it is a security problem.
sqladmin must have access to registry .
you can change your iis anonymous user ( application pool and website) to administrator and change the application pool identity to (predefined:systemUser) Note: this is not good for your site security
then sql web data administrator work fine.
do not try to change registry primision. i do this and now i cant login to my windows .

highportal wrote Aug 21, 2009 at 6:30 PM

i forget this: you must download and install sqldmo from this url:
http://download.microsoft.com/download/3/1/6/316FADB2-E703-4351-8E9C-E0B36D9D697E/SQLServer2005_BC.msi

shalong wrote Jan 25, 2010 at 8:55 PM

I am also trying to connect to a SQL Server 2008 Database. When I try, I get the following error:

Error Message:
[Microsoft][ODBC SQL Server Driver][SQL Server]To connect to this server you must use SQL Server Management Studio or SQL Server Management Objects (SMO).

Stack Trace:
at SqlAdmin.NativeMethods.ISqlServer.Connect(Object ServerName, Object Login, Object Password)
at SqlAdmin.SqlServer.Connect() in C:\SqlWebAdmin\SqlAdmin\SqlServer.cs:line 202
at SqlWebAdmin.databases.Page_Load(Object sender, EventArgs e) in c:\websites\SqlWebAdmin\SqlWebAdmin\Databases.aspx.cs:line 42

I have downloaded the sqldmo and the 2005 backward compatibility patch with the same results. I have tried to connect to mutliple 2008 servers with no luck. I am able to connect to all of my sql 2000 servers just fine.

Thanks for your help!

martinpoon wrote Feb 11, 2010 at 12:53 PM

@kjustice, have you tried 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

zitjubiz wrote Apr 20, 2012 at 10:14 AM

just change app pool to let sqlwebadmin run at 32bit environment, test pass at windows2008 R2