SQL Web Data Administrator

New Post: Remote Log in fail

murtuz — Tue, 15 Jul 2008 05:31:30 GMT

I have installed SQL web admin on dedicated webserver and want to manage all sql server on my sites , i have 4 sql server on diffrent server. From webserver where i installed SQLwebadmin tool when i browse web site i can manage all sql database. but from client pc when i access websqlwebsite i got below error " Invalid username and/or password, you are using a windows login that is not your own, or server does not exist."

Can someone please share whats wrong ?

NEW POST: Enable debug

stefannielsen — Fri, 30 May 2008 14:09:12 GMT

Hi,

I'm not quite that good a developer, I need some guidance on how to enable the debugger? I read these posts:

http://www.codeplex.com/SqlWebAdmin/Thread/View.aspx?ThreadId=14251
http://www.codeplex.com/SqlWebAdmin/Thread/View.aspx?ThreadId=13730

Bbut still don't understand how to enable debug? Could you get a little bit more specific on how to print error messages instead of just redirecting to an error page? The SQL Web Data Administrator isn't working for me when installing on a remote server but i can login to the sql database with sql studio from the remote server so something else is wrong. Help will be much appreciated.

Stefan Nielsen

NEW POST: User can see system DB

DarthObiwan — Tue, 06 May 2008 13:01:02 GMT

the quick way is to put a big if around the add line.

for (int i = 0; i < databases.Count; i++)
{
SqlDatabase database = databasesi;
if(!database.Name.ToLower().Equals("master") && !database.Name.ToLower().Equals("master"))
{
ds.Tables0.Rows.Add(new object[] { Server.HtmlEncode(database.Name), Server.UrlEncode(database.Name), database.Size == -1 ? "Unknown" : String.Format("{0}MB", database.Size) });
}
}

I haven't looked but the database object probably has a property that tells you if it's a system db or not.

NEW POST: User can see system DB

jeidson — Tue, 15 Apr 2008 05:03:17 GMT

Hi, I am not fluent in C#, but I am setting this application up for our developers. Can you possibly provide a more detailed example of how I would re-write this code to hide the system databases in SQL 2005? Thank you very much.

CREATED ISSUE: ServerLogins.aspx Throw Exception

jcluna — Sat, 29 Mar 2008 05:54:54 GMT

When I want to view logins on SQL Server 2000, the form throw an exception. The reason is a missing validation in the string properties of the class SqlLogin. I fix it replacing null string with String.Empty value.

NEW POST: to change Datas in the tables

meo — Tue, 18 Mar 2008 17:35:16 GMT

i have some poweruser - they need to administer the datas in the tables for olap generation
so it would be very fine to make a side where i select the table and then change the digits.

NEW POST: DotNetPanel Application Pack

nuanw — Tue, 04 Mar 2008 18:06:39 GMT

I wonder what the result is for Management Studio.

chammock wrote:
I can connect without issue using ASP.NET Enterprise Manager web based tool. But I wanted to try SQL Web Admin to see if it had a better feature set.

So I know that I can connect with this other tool. Does that offer any clues as to what the issue might be?

I don't have access right now to Management Studio. Will check that tomorrow.

NEW POST: DotNetPanel Application Pack

chammock — Tue, 26 Feb 2008 02:01:57 GMT

I can connect without issue using ASP.NET Enterprise Manager web based tool. But I wanted to try SQL Web Admin to see if it had a better feature set.

So I know that I can connect with this other tool. Does that offer any clues as to what the issue might be?

I don't have access right now to Management Studio. Will check that tomorrow.

NEW POST: DotNetPanel Application Pack

nuanw — Mon, 25 Feb 2008 23:11:15 GMT

There is no special permissions are required on this application. I suggest you try to use "Sql Server Management Studio" and see if it will allow you to access the db. If you get the same results, then it is not the app itself but something with your setting.

chammock wrote:
I did a remote desktop into the server and found that I was also prompted there with a windows login, but when I tried to login with administrator account, I was able to get to the SQL Web admin login. From there I was able to use a SQL Login to get to the correct db.

So now it looks like there is some sort of permission issue on the folder, which is why I am being prompted with the windows login.

Can someone let me know what permissions are required on this application?

Thanks so much!

Cliff

NEW POST: DotNetPanel Application Pack

chammock — Thu, 21 Feb 2008 12:47:49 GMT

I did a remote desktop into the server and found that I was also prompted there with a windows login, but when I tried to login with administrator account, I was able to get to the SQL Web admin login. From there I was able to use a SQL Login to get to the correct db.

So now it looks like there is some sort of permission issue on the folder, which is why I am being prompted with the windows login.

Can someone let me know what permissions are required on this application?

Thanks so much!

Cliff

NEW POST: Integrate into web site

nuanw — Thu, 21 Feb 2008 03:27:54 GMT

For the web.config, what is the error you got? Is that possible to integrate the web.config into the global web.config to solve the problem?

apostold wrote:
I would like to integrate this tool in an existing web site and I was wondering what is the best way to go about it. I got it to work locally by creating a separate virtual directory for C:\Inetpub\SQLWebServer.

Once that worked I copied SqlWebServer as is to the base web site directory. In IIS I made it an application. The problem is that when I tried to access SQLWebServer/SqlWebAdmin/default.aspx it is reading the global web.config and throwing an error. Ideally I would also like to change the look and feel for the tool so that it looks consistent with the rest of the web site.

Thank you!

NEW POST: DotNetPanel Application Pack

nuanw — Thu, 21 Feb 2008 03:25:04 GMT

Could you debug the source code and find which line is failing?

chammock wrote:
I use DotNetPanel control panel for webhosting. SQL Web Data Administrator is included as an application pack that I can install.
I installed it but when I try to login remotely I get a windows prompt to login with username and password.
I try the admin account and it just hangs.

If I remote desktop into the server and do the same thing I get the windows login prompt but my admin account gets me to the website and I can then use SQL Authentication to get to the right database.

So apparently there are some permissions not being set correctly by the one-click application pack install in DotNetPanel.

Can someone let me know the specific permissions that are required. I don't mind having the windows login prompt as that seems like a good layer of security.
But it does not work remotely.

Any ideas would be appreciated.

Cliff

NEW POST: Speed up

nuanw — Thu, 21 Feb 2008 02:48:30 GMT

To find out why it takes long time to get lists of DBs or tables, I recommend you debug the code and find out exactly which step takes lengthy time.

To reduce certain functionalities such as removing buttons is relatively easy to do. Just go to the corresponding .aspx page's design mode and delete the unwanted buttons, and then go to the corresponding source code file (.aspx.cs) and delete the functions.

Please let us know if this is clear to you. If not, I can pick a scenario and make the changes as an example.

apostold wrote:
I really like the tool, but for some reason it takes a really long time to get the list of databases or list of tables for a particular db. Queries are ok, the rest is prohibitively slow, however. In reality, I only need a limited part of the application. I need the user to have read access to select databases (there is such a SQL user already) and to be able to query select tables, Just "select" queries. I don't want them to be able to import, export, insert/update, etc. and I want to remove the buttons for those funcitons, it will make it less confusing for the users. What would you advise in terms of making it faster and customizing the application so that it has only the bare bones functionality.

NEW POST: Retrieving the COM class factory for component with CLSID {10020200-E260-11CF-AE68-00AA004A34D5} ...

nuanw — Thu, 21 Feb 2008 02:04:11 GMT

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.

mirzasa wrote:
I am getting the following error message after I login. Is anybody know how do I resolve this or if it is previously been addressed on this forum? It works fine on my local machine with the local database. But failed when I copied the same code on our remote webserver to access a remote database.

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)

NEW POST: User can see system DB

nuanw — Thu, 21 Feb 2008 01:46:28 GMT

What you can do is to hide these system DBs. You can do that by modifying the following code in the Page_Load function in source file Databases.aspx.cs. Just don't add the system DBs in this "for" loop.

for (int i = 0; i < databases.Count; i++)
{
SqlDatabase database = databasesi;
ds.Tables0.Rows.Add(new object[] { Server.HtmlEncode(database.Name), Server.UrlEncode(database.Name), database.Size == -1 ? "Unknown" : String.Format("{0}MB", database.Size) });
}

Kirill wrote:
Hello,

I have installed Web Data administrator on my server.
Under all accounts I can see system DB (master, msdb etc.). Can you explain how I can deny view system DB?

Thank you

NEW POST: DotNetPanel Application Pack

chammock — Fri, 15 Feb 2008 21:46:53 GMT

I use DotNetPanel control panel for webhosting. SQL Web Data Administrator is included as an application pack that I can install.
I installed it but when I try to login remotely I get a windows prompt to login with username and password.
I try the admin account and it just hangs.

If I remote desktop into the server and do the same thing I get the windows login prompt but my admin account gets me to the website and I can then use SQL Authentication to get to the right database.

So apparently there are some permissions not being set correctly by the one-click application pack install in DotNetPanel.

Can someone let me know the specific permissions that are required. I don't mind having the windows login prompt as that seems like a good layer of security.
But it does not work remotely.

Any ideas would be appreciated.

Cliff

NEW POST: User can see system DB

Kirill — Thu, 07 Feb 2008 21:18:21 GMT

Hello,

I have installed Web Data administrator on my server.
Under all accounts I can see system DB (master, msdb etc.). Can you explain how I can deny view system DB?

Thank you

NEW POST: Retrieving the COM class factory for component with CLSID {10020200-E260-11CF-AE68-00AA004A34D5} ...

mirzasa — Sat, 02 Feb 2008 05:02:28 GMT

I am getting the following error message after I login. Is anybody know how do I resolve this or if it is previously been addressed on this forum? It works fine on my local machine with the local database. But failed when I copied the same code on our remote webserver to access a remote database.

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)

NEW POST: Speed up

apostold — Tue, 22 Jan 2008 17:58:37 GMT

I really like the tool, but for some reason it takes a really long time to get the list of databases or list of tables for a particular db. Queries are ok, the rest is prohibitively slow, however. In reality, I only need a limited part of the application. I need the user to have read access to select databases (there is such a SQL user already) and to be able to query select tables, Just "select" queries. I don't want them to be able to import, export, insert/update, etc. and I want to remove the buttons for those funcitons, it will make it less confusing for the users. What would you advise in terms of making it faster and customizing the application so that it has only the bare bones functionality.

NEW POST: Integrate into web site

apostold — Tue, 22 Jan 2008 16:59:29 GMT

I would like to integrate this tool in an existing web site and I was wondering what is the best way to go about it. I got it to work locally by creating a separate virtual directory for C:\Inetpub\SQLWebServer.

Once that worked I copied SqlWebServer as is to the base web site directory. In IIS I made it an application. The problem is that when I tried to access SQLWebServer/SqlWebAdmin/default.aspx it is reading the global web.config and throwing an error. Ideally I would also like to change the look and feel for the tool so that it looks consistent with the rest of the web site.

Thank you!