Any free tools for accessing and managing ISP SQL account?

Hi:
Very new to MS SQL, but our ISP provides us with a SQL account which we want
to use.
But the question is we don't know if there is any free tools (e.g. DbaMgr
2K) that we can use to access and/or administrate to our SQL account as
DbaMgr 2K, which we can see the DB information and/or to change the design
and data.
Thanks in advance.
xfile wrote:
> Hi:
> Very new to MS SQL, but our ISP provides us with a SQL account which
> we want to use.
> But the question is we don't know if there is any free tools (e.g.
> DbaMgr 2K) that we can use to access and/or administrate to our SQL
> account as DbaMgr 2K, which we can see the DB information and/or to
> change the design and data.
> Thanks in advance.
Web Data Administrator from Microsoft. It's free and designed for what
you need it for.
http://www.microsoft.com/downloads/d...displaylang=en
David Gugick
Imceda Software
www.imceda.com
|||Hi:
Thanks so much, and I am currently studying the page and will test the tool.
I have posted many places, but you are the first and only one replies.
Thanks so much.
We were thinking to change ISP and maybe move to mySQL platform if we cannot
find such a tool.
Many thanks again.
"David Gugick" <davidg-nospam@.imceda.com>
??:%23xr4mDe$EHA.3700@.tk2msftngp13.phx.gbl...
> xfile wrote:
> Web Data Administrator from Microsoft. It's free and designed for what you
> need it for.
> http://www.microsoft.com/downloads/d...displaylang=en
>
> --
> David Gugick
> Imceda Software
> www.imceda.com
|||xfile wrote:
> Hi:
> Thanks so much, and I am currently studying the page and will test
> the tool.
> I have posted many places, but you are the first and only one replies.
> Thanks so much.
> We were thinking to change ISP and maybe move to mySQL platform if we
> cannot find such a tool.
>
There are a number of tools, both free and retail. We offer Speed IDE
Pro, Microsoft has the free Web Data Administrator, but there are
others. You may get a lot of responses with options.
David Gugick
Imceda Software
www.imceda.com
|||The Web Data Administrator is good. You can also get the
free version of Toad for SQL Server from:
http://www.toadsoft.com/toadsqlserve..._sqlserver.htm
You can also find a list of third party products at:
http://www.aspfaq.com/show.asp?id=2442
-Sue
On Wed, 19 Jan 2005 13:09:37 +0800, "xfile"
<cou-cou@.remove.nospam.com> wrote:

>Hi:
>Thanks so much, and I am currently studying the page and will test the tool.
>I have posted many places, but you are the first and only one replies.
>Thanks so much.
>We were thinking to change ISP and maybe move to mySQL platform if we cannot
>find such a tool.
>Many thanks again.
>
>"David Gugick" <davidg-nospam@.imceda.com>
>??:%23xr4mDe$EHA.3700@.tk2msftngp13.phx.gbl.. .
>
|||Hi:
Thanks for all the information.
Maybe I am too new to this thing, but where exactly shall I install Web Data
Administrator to?
I assume it will be under Program Files, but maybe not.
According to this article,
http://www.databasejournal.com/featu...e.php/3330301, the
installation will take care of itself and all I have to do is to type:
http://<webserver>/webadmin/default.aspx and it will show up the page.
Well, I typed localhost or the default server name of my local machine, and
it gives me an error message for files cannot be found.
On previous tries, I put the Web folders under the IIS www and give it a
name called sqlwebAdmin and made it a FP 2002 web, but then I got another
error message for the incorrect security using Windows as authentication and
needed to modify configuration file which I don't know how to.
I could not find many articles on the web talking about how to install and
configure it. Seems no one but me have the problem.
Thanks again for your information, and I will look into those
"Sue Hoegemeier" <Sue_H@.nomail.please>
??:3n0tu01pit72b5j3fa27g39jng7s6792lk@.4ax.com ...
> The Web Data Administrator is good. You can also get the
> free version of Toad for SQL Server from:
> http://www.toadsoft.com/toadsqlserve..._sqlserver.htm
> You can also find a list of third party products at:
> http://www.aspfaq.com/show.asp?id=2442
> -Sue
> On Wed, 19 Jan 2005 13:09:37 +0800, "xfile"
> <cou-cou@.remove.nospam.com> wrote:
>