SQLServerCentral / Discuss Content Posted by Jacob Sebastian / Article Discussions / Article Discussions by Author / Web Data Adminstrator / Latest Posts

RE: Web Data Adminstrator

Rudy Panigas — Wed, 17 Dec 2008 09:25:11 GMT

Thanks for all your time and efforts!Rudy

RE: Web Data Adminstrator

jacob sebastian — Wed, 17 Dec 2008 09:23:32 GMT

I did some search on internet to see there are any references to similar errors. The one given below looks interesting. http://social.msdn.microsoft.com/forums/en-US/sqlsmoanddmo/thread/94f476c9-6d22-44e2-ba15-0786c0dfffaa/It speaks about two downloads/feature-packs and probably they could help fixing the problem you are facing. Meanwhile, let me try to configure it on another computer and see if I can find some thing that can help you.regardsJacob

RE: Web Data Adminstrator

Rudy Panigas — Wed, 17 Dec 2008 08:54:00 GMT

It work just fine when I select a SQL 200 server but when I select a SQL 2005 the error produced is show below.Hopefully you or someone can figure this out.Thanks,Rudy------------------------------------------------------ERROR Exception of type 'System.Web.HttpUnhandledException' was thrown.at System.Web.UI.Page.HandleError(Exception e) at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) at System.Web.UI.Page.ProcessRequest(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) at System.Web.UI.Page.ProcessRequest() at System.Web.UI.Page.ProcessRequestWithNoAssert(HttpContext context) at System.Web.UI.Page.ProcessRequest(HttpContext context) at ASP.databases_aspx.ProcessRequest(HttpContext context) at System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)--------------------------------------------------------------------------------[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).at SqlAdmin.NativeMethods.ISqlServer.Connect(Object ServerName, Object Login, Object Password) at SqlAdmin.SqlServer.Connect() at SqlWebAdmin.databases.Page_Load(Object sender, EventArgs e) at System.Web.UI.Control.OnLoad(EventArgs e) at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)

RE: Web Data Adminstrator

jacob sebastian — Wed, 17 Dec 2008 08:27:25 GMT

So what is the problem you are facing? Did you get an error?

RE: Web Data Adminstrator

Rudy Panigas — Wed, 17 Dec 2008 06:58:05 GMT

I have a SQL 2008 Dev server setup for any testing I want. If I could just get this app working with SQL 2005 then I would test it fully on SQL 2008ThanksRudy

RE: Web Data Adminstrator

jacob sebastian — Tue, 16 Dec 2008 20:09:38 GMT

I had tested it on SQL Server 2005 while writing the article. Did not test on SQL Server 2008 yet. However, I would expect it to work on SQL Server 2008 as well.

RE: Web Data Adminstrator

Rudy Panigas — Tue, 16 Dec 2008 11:55:56 GMT

Anyone tried this with SQL 2005 or SQL 2008? I have and it doesn't work as SQL 2005+ does not use SQLDMO.

RE: Web Data Adminstrator

jacob sebastian — Wed, 18 Jul 2007 23:46:00 GMT

In the worst case, i can help you out by setting up a meeting at www.gotomeeting.com :-)

RE: Web Data Adminstrator

Brad Biagi — Wed, 18 Jul 2007 15:27:00 GMT

It wasnt on 2.0. After I made the changes I still see the content of the file. Thanks for you help. I will see if I can get some help from someone that is familiar with asp unless you have other ideas.

RE: Web Data Adminstrator

jacob sebastian — Sat, 30 Jun 2007 01:58:00 GMT

From your description "I tried opening default.aspx and no luck I get the text code", I guess that when you navigate to "default.aspx" from your browser, you see the content of the ASPX file.

It looks to me that ASP.NET is not configured on your machine. Look at the properties of your virtual directory. do you see the TAB "ASP.NET"? and if yes, do you see the version 2.0 there?

If not, you need to go to "C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727" and run "regiis.exe -i" to configure ASP.NET on your ISS.

Hope this helps.

RE: Web Data Adminstrator

Brad Biagi — Fri, 29 Jun 2007 11:29:00 GMT

I have installed this as a virtual directory and unzipped the files. Everything looks good. I tried opening default.aspx and no luck I get the text code. I am kind of new at this sql stuff sorry but can you please help. After making virt directory how do I run this? sorry for this uncalled question.

RE: Web Data Adminstrator

David Scotland-132255 — Thu, 28 Jun 2007 14:55:00 GMT

There is another open source web admin tool for sql server which looks just like the good old enterprise manager. I just gave a link to a blog since its got a nice screen shot on it the link for sourceforge is on the blog post.

http://weblogs.asp.net/rosherove/archive/2006/06/12/452008.aspx

Anyway I like it so i thought you might be interested as its also more functionla than the ms one on codeplex.

David

RE: Web Data Adminstrator

jacob sebastian — Wed, 27 Jun 2007 21:30:00 GMT

I have it installed on windows XP service. You can simply unzip the files and create a virtual directory pointing to the folder which contains the files.

RE: Web Data Adminstrator

hr_sn — Wed, 27 Jun 2007 20:13:00 GMT

This is just so cool! Thanks for sharing this information!

RE: Web Data Adminstrator

Brad Biagi — Wed, 27 Jun 2007 17:35:00 GMT

I just downloaded this and I would like to test it out on my computer dont want to install anything with out my bosses permision. Has anyone installed it on windows xp. I did see a note to install as application how do I do this?

RE: Web Data Adminstrator

jacob sebastian — Wed, 27 Jun 2007 07:34:00 GMT

It works with servers outside the local network. However, pay attention to the points mentioned by John a few posts above.

RE: Web Data Adminstrator

Mark Tierney — Wed, 27 Jun 2007 07:21:00 GMT

This is pretty neat. As advertised, it installs really quickly and I'd envision it to be a handy back pocket tool. One question: Has anyone used it to logon to servers other than the local one? I have a modest farm and would like to avoid installing it everywhere.

RE: Web Data Adminstrator

Vasant Raj — Wed, 27 Jun 2007 02:44:00 GMT

I have been using this tool for few months now. Only thing which impresed me was the response time compared to the Management Studio.

Note: You should be careful in deleting database objects using this web-tool. No confirmations are asked!!!

RE: Web Data Adminstrator

John Sinclair — Tue, 26 Jun 2007 22:42:00 GMT

Yep I've been using web data admin for years - very handy One thing tho - Be warned that if access this web app across the public internet, and use SQL authentication you really should use HTTPs, otherwise your SQL passwords are being sent unencrypted. Particuarly dodgy if you are using unsecured wifi at a coffee shop or anything.

Web Data Adminstrator

jacob sebastian — Tue, 22 May 2007 11:32:00 GMT

Comments posted here are about the content posted at http://www.sqlservercentral.com/columnists/jSebastian/3025.asp