通过

Light weight SQL Server/MSDE administrator (by yag)

  • 项目

I realized I forgot to post this when we started the blog...

The SQL Server Web Data Administrator is available for free download. It's a light weight, web-based administration tool for SQL Server or MSDE databases. I've heard from many of you over the years that you'd like to use MSDE more, but a number of things hold you back. This was usually #1 or 2 on the hit parade. Check it out!

Update:

In answer to a few questions - yes, since this uses Cassini, you don't have to have IIS installed or anything else, for that matter - just put it on a machine and go!

Comments

  • Anonymous
    March 07, 2004
    Yag, sounds awesome especially if the answer to this dumb question is yes... since it runs on Cassini, that means I can put it on a client computer to access MSDE instead of using ACCESS to manage their MSDE database? There is no web anything going on there. And using Access as the management tool is a drag and very limiting. Thanks
  • Anonymous
    March 07, 2004
    Great news. I've being using a number of different MSDE Front-ends, but I'm not comfortable with anyone until now. Having the old Cassini available is nice, since one of the problems I found with others was the need for IIS.

    Thanks!
  • Anonymous
    March 09, 2004
    I am a user of your Codebook (even today). Thank you.

    I pay attention to what you and Ken do and recommend. I hope MS appreciates you both.
  • Anonymous
    March 09, 2004
    Thanks Alex - and don't worry - I love working here. Lots of freedom to do interesting things, and lots of smart people to do them with...
  • Anonymous
    March 09, 2004
    Many thanks for posting this! I installed MSDE and with no administration it's essentially sat, now let's see what we can do...

  • Anonymous
    March 09, 2004
    Thanks again, I don't have the .Net Framework and that had to be installed first. Am assuming that this installed the Cassini stuff. Don't if you can respond to queries, never the less. Any recommended links for getting started with SQL Server? (broad question huh?)
  • Anonymous
    March 10, 2004
    I'd look at www.microsoft.com/sql. That page includes a link of community sites you can check out also. Finally, http://msdn.microsoft.com/data has some good stuff.
  • Anonymous
    March 12, 2004
    One gotcha to remember when installing the SQL Server instance is to make sure you use only the SQL Server logins. Won't work against the Window's integrated approach. Otherwise it's very cool.

  • Anonymous
    June 21, 2004
    mohamed
  • Anonymous
    June 28, 2004
    Hey thats really neat!

    Like stated, light weight! Love it!
  • Anonymous
    June 28, 2004
    Only problem I can see with this product is that is allows every user that can access it the ability to run queries such as select * from sysdatabases which lists all the databases in the subsystem (or instance in SQL Server terms). How can you stop this? Obviously in a shared environmnet, don't want user x bring able to see that user y has a database called donthackme....
  • Anonymous
    May 31, 2009
    PingBack from http://outdoorceilingfansite.info/story.php?id=21037