Setup Instructions

1. Create an IIS website (either a website or "Application" on an existing site). If you are installing this on Windows XP you will only be able to create an “Application”.

IISM-New.gif

2. Enter a description for your new site. This screen will not be presented if you are installing on Windows XP.

SiteWizDesc.JPG
SiteWizIP.JPG

3. Enter the full path and name of the "SqlWebAdmin" directory created from the download as the website home directory.

SiteWizHome.JPG

4. Make sure that the Application Pool's user has Read and Execute access to the directory.

SiteWizPerms.JPG

5. Click "Finish" button.

SiteWizFinish.JPG

6. Make sure the .NET 2.0 is the current ASP.NET runtime. In IIS console, right click the website just created, choose "Properties" option.

SSWTSiteProp.JPG

7. Run the website.

8. Browse the list of the files under the website, right click "default.aspx", and click "browse". That will start the web application.

Last edited Aug 7, 2007 at 4:23 AM by nuanw, version 3

Comments

kofoide Jul 19, 2013 at 7:09 PM 
I know there hasn't been much activity on this in quite some time, but I wanted to let anyone who tries to use this against a machine with only SQL Server 2012 installed on it how to get this working. It seems that SQL DMO has been discontinued with SQL Server 2012, but this project uses it. I was able to get this working after I installed "Microsoft SQL Server 2005 Backward Compatibility Components" from here: http://www.microsoft.com/en-us/download/details.aspx?id=6375. It also took a bit of figuring out how to configure using IIS 7, it seems that the default install of IIS 7 does not include Windows Authentitcation so I had to install that feature as well. I hope this helps anyone trying to use this against sql server 2012.

Chromebuster Jul 1, 2012 at 6:19 PM 
One thing that would help you guys immensely so that you don't have to browse the directory on IIS is to put default.aspx at the top that way that is the first file the server looks for. In fact, you shouldn't allow directory browsing at all accept on certain directories that contain downloadable content.

wmerritt Apr 13, 2011 at 2:01 AM 
My installation succeeded following the above steps, however after logging in to the web server I was presented with a com exception:
CLSID {10020200-E260-11CF-AE68-00AA004A34D5} error: 80040154, as mentioned above. I'm running a windows server 2003 OS with SQL 2008 Express edition.
To remedy the problem i installed the Microsoft SQL Server 2008 Feature Pack, August 2008. There are a number of executables in this pack, the sql server 2005 compatibility pack is the
specific pack that needs to be installed to make this work with SQL server 2008. Hope this helps.

The install files can be found here:
http://www.microsoft.com/downloads/en/details.aspx?FamilyId=C6C3E9EF-BA29-4A43-8D69-A2BED18FE73C&displaylang=en

justhost Jul 14, 2010 at 8:56 PM 
I get the following message when I try to browse? Does anyone have any idea?

Server Error in '/' Application.
--------------------------------------------------------------------------------

Configuration Error
Description: An error occurred during the processing of a configuration file required to service this request. Please review the specific error details below and modify your configuration file appropriately.

Parser Error Message: This configuration section cannot be used at this path. This happens when the site administrator has locked access to this section using <location allowOverride="false"> from an inherited configuration file.

Source Error:


Line 30: (unauthenticated) users.
Line 31: -->
Line 32: <identity impersonate="true"/>
Line 33: <authorization>
Line 34: <deny users="?"/>


Source File: C:\Inetpub\wwwroot\SqlWebAdmin\web.config Line: 32


--------------------------------------------------------------------------------
Version Information: Microsoft .NET Framework Version:2.0.50727.3603; ASP.NET Version:2.0.50727.3614

Biohazaaa May 28, 2010 at 5:44 PM 
hi.

Error Message:
Error al recuperar un generador de clases COM para el componente con CLSID {10020200-E260-11CF-AE68-00AA004A34D5} debido al siguiente error: 80040154.

Stack Trace:
en SqlAdmin.SqlServer.Connect() en C:\SqlWebAdmin\SqlAdmin\SqlServer.cs:línea 198
en SqlWebAdmin.databases.Page_Load(Object sender, EventArgs e) en c:\Users\hersonta\Documents\Visual Studio 2008\Projects\SqlWebAdmin\SqlWebAdmin\Databases.aspx.cs:línea 42

DrkAngell Feb 25, 2010 at 5:34 PM 
I am running MS Windows Server 2008 and had several of the problems listed above. To simplify and condense some of the responses, this is what I did:

Extract the sqlwebadmin subfolder to a folder in an existing web site.

Convert the folder to an application

Right-click on the folder / Manage Application / Advanced Settings - Change application pool to Classic .Net AppPool

Double-click on Authentication, click on Windows Authentication, click on Enable

[These next two steps you will need to adjust for your situation and security needs.]

In Active Directory Create a user called sqlWebAdmin

Create a SQL login for each person who will be accessing the databases

Now, when you go to the web administrator (yourdomain.com/sqlwebadmin) you will first get a login where you use the active directory sqlWebAdmin login. Then you will get a second login request where you specify the user and server to connect to using SQL authentication.

There are several options available once you get the issues resolved by performing the steps in the first half. You could create individual users in AD and give them permissions to the appropriate databases instead of using SQL Authentication.

vladja Feb 7, 2010 at 1:33 AM 
Hi,

When the Default.aspx page is started, as suggested in step 8, this error message is displayed:

Compiler Error Message: CS0246: The type or namespace name 'SqlAdmin' could not be found (are you missing a using directive or an assembly reference?)

Source Error:



Line 29: public partial class Login : System.Web.UI.Page
Line 30: {
Line 31: SqlAdmin.Security security = new SqlAdmin.Security();
Line 32:
Line 33: public Login()


Source File: c:\Inetpub\SqlWebAdmin\SqlWebAdmin\Default.aspx.cs Line: 31

Are there any additional steps that need to be taken? The SqlAdmin.dll is present in the project, but how should be registered/put to use?

Thanks in advance,
Vladja

hagen85 Oct 5, 2009 at 12:02 PM 
Hi all,

i get the error message(german winserver08) when opening the site in browser:
2009-10-05 08:38:38 fe80::d009:19bd:6e3b:7635%10 GET /error.aspx errormsg=Die+COM-Klassenfactory+f%c3%bcr+die+Komponente+mit+CLSID+%7b10020200-E260-11CF-AE68-00AA004A34D5%7d+konnte+aufgrund+des+folgenden+Fehlers+nicht+abgerufen+werden%3a+80040154.&stacktrace=+++bei+SqlAdmin.SqlServer.Connect()%0d%0a+++bei+SqlWebAdmin.export.Page_Load(Object+sender%2c+EventArgs+e)+in+c%3a%5cinetpub%5cwwwroot%5cSqlWebAdmin%5cExport.aspx.cs%3aZeile+35. 80 - fe80::10f0:f566:d218:84b4%10 Opera/9.80+(Windows+NT+6.1;+U;+de)+Presto/2.2.15+Version/10.00 401 5 0 12843

I have already tried to use regsvr32 to register the SqlAdmin.dll, but got annother error message.

Any further ideas?
Hagen

pcsql May 4, 2009 at 8:29 AM 
MichelleaW,

Thanks for the info. If I enable the Integrated Windows Authenticaton in the Directory Security of the virtual directory or File Security of the Default.aspx, I won't get the error.

MichelleaW May 3, 2009 at 11:10 PM 
pcsql,

The reason you get the error is that you need to enable the integrated authentication method under "Directory Security"

MichelleaW May 3, 2009 at 11:09 PM 
Hi,

I just downloaded the Web Administrator and I was wondering the following.

1. How is this different from the Web Administrator tool from Microsoft?
2. How secure is it on a production server?
3. Why is that I have to use the integrated authentication method to access the application?

pcsql May 2, 2009 at 10:09 AM 
I'm trying this in Windows XP. The only option available in IIS is to create a new Virtual Directory.
I did the followings:

1. Created a Virtual Directory named SQL Web Data Administrator
2. Entered the path of SqlWebAdmin folder as the path to the directory that contains the content
3. Checked the Read and Execute permissions
4. Made sure the .NET 2.0 is the current ASP.NET runtime for the virtual directory
5. Right clicked Default.aspx and clicked Browse

I got the following error:

Server Error in '/SQL Web Data Administrator' Application.
--------------------------------------------------------------------------------

Access is denied.
Description: An error occurred while accessing the resources required to serve this request. The server may not be configured for access to the requested URL.

Error message 401.2.: Unauthorized: Logon failed due to server configuration. Verify that you have permission to view this directory or page based on the credentials you supplied and the authentication methods enabled on the Web server. Contact the Web server's administrator for additional assistance.


--------------------------------------------------------------------------------
Version Information: Microsoft .NET Framework Version:2.0.50727.3053; ASP.NET Version:2.0.50727.3053

b181rs Dec 23, 2008 at 6:06 AM 
right click your sqlwebadmin properties and then create. choose script only at execute permission.

robcohen Jun 4, 2008 at 1:23 PM 
Couple of questions: My IIS doesn't look anythng like the shown here (it's Vista). I'm guessing Vista uses IIS7 and that's the difference. I can't find anything equivalent to the Properties dialog shown in this doc. When I try to browse the site, IE shows the site's files in browse; going to the SQLWebAdmin directory results in this error:
Server Error in '/SQL Web Data Administrator' Application.
--------------------------------------------------------------------------------

Configuration Error
Description: An error occurred during the processing of a configuration file required to service this request. Please review the specific error details below and modify your configuration file appropriately.

Parser Error Message: It is an error to use a section registered as allowDefinition='MachineToApplication' beyond application level. This error can be caused by a virtual directory not being configured as an application in IIS.

Source Error:


Line 24: "Forms", "Passport" and "None"
Line 25: -->
Line 26: <authentication mode="Windows"/>
Line 27: <!-- AUTHORIZATION
Line 28: This section sets the authorization policies of the application. You can allow or deny access


Source File: C:\inetpub\SqlWebAdmin\sqlwebadmin\web.config Line: 26

Any ideas?