1
Vote

Permission issue I belive

description

on local machine everything runs fine however on server get the following error. I think this is a permission issue with the .net framework folder just cant remember what I needed to do to fix. Running server 2000. net framework 2.0
 
 
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\SQLWebAdmin_Alex\Nuan_XSiteForgery\5try\SqlAdmin\SqlServer.cs:line 197
at SqlWebAdmin.databases.Page_Load(Object sender, EventArgs e) in c:\Inetpub\wwwroot\sqlwebadmin\Databases.aspx.cs:line 42

comments

nuanw wrote Dec 22, 2007 at 6:06 AM

Check and see if SQLDMO installed on your webserver. If not, please do the following:
  1. Copy the contents of "C:\Program Files\Microsoft SQL Server\80\Tools\Binn" from (where ever you can find it) into a folder on your server (For example, SqlWebAdmin/bin)
  2. Open a command window, cd to that binn folder, and then run "regsvr32 SQLDMO.dll", this installed SQLDMO.dll into the server's COM registry. It should give you a "installed successfully" message box.
  3. Logout and log back into your instance of SqlWebAdmin and see if it works.