Web Data Adminstrator

Question

Web Data Adminstrator

jacob sebastian

SSChampion

Points: 11822
More actions
May 22, 2007 at 11:32 am

#117293

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

Viewing 15 posts - 1 through 15 (of 19 total)

You must be logged in to reply to this topic. Login to reply

John Sinclair Mr or Mrs. 500 Points: 518 More actions · Answer 1

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.

Vasant Raj SSCommitted Points: 1835 More actions · Answer 2

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!!!

Mark Tierney SSC Enthusiast Points: 170 More actions · Answer 3

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.

Best Regards,

Mark Tierney

jacob sebastian SSChampion Points: 11822 More actions · Answer 4

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

.

Brad Biagi Valued Member Points: 69 More actions · Answer 5

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?

hr_sn Ten Centuries Points: 1092 More actions · Answer 6

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

jacob sebastian SSChampion Points: 11822 More actions · Answer 7

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.

.

David Scotland-132255 SSCertifiable Points: 5599 More actions · Answer 8

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

Brad Biagi Valued Member Points: 69 More actions · Answer 9

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.

jacob sebastian SSChampion Points: 11822 More actions · Answer 10

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.

.

Brad Biagi Valued Member Points: 69 More actions · Answer 11

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.

jacob sebastian SSChampion Points: 11822 More actions · Answer 12

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

.

Rudy Panigas SSChampion Points: 10702 More actions · Answer 13

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

Rudy

jacob sebastian SSChampion Points: 11822 More actions · Answer 14

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.

.