Enterprise Manager?

I have a new windows 2003 SBS server installation and an
application that requires SQL server. How do I get to the
Enterprise Manager to configure SQL?Is SQL Server installed? It should be in Programs > Micorsoft SQL Server >
Enterprise Manager
--
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/
"Vince" <anonymous@.discussions.microsoft.com> wrote in message
news:03aa01c3b849$9258ea90$a101280a@.phx.gbl...
> I have a new windows 2003 SBS server installation and an
> application that requires SQL server. How do I get to the
> Enterprise Manager to configure SQL?|||NO SQL server is not installed. How is it installed?
>--Original Message--
>Is SQL Server installed? It should be in Programs >
Micorsoft SQL Server >
>Enterprise Manager
>--
>Aaron Bertrand
>SQL Server MVP
>http://www.aspfaq.com/
>
>
>"Vince" <anonymous@.discussions.microsoft.com> wrote in
message
>news:03aa01c3b849$9258ea90$a101280a@.phx.gbl...
>> I have a new windows 2003 SBS server installation and an
>> application that requires SQL server. How do I get to
the
>> Enterprise Manager to configure SQL?
>
>.
>|||> NO SQL server is not installed. How is it installed?
setup.exe, from the installation CD?
--
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/

Enterprise Manager for MSDE

Howdy All,
How do I open Enterprise Manager for MSDE SP3?
I have installed MSDE as part of ACT! installation and have found references
to Enterprise Manager, but don't know how to get into it.
Thanks,
Brian
Enterprise Manager doesnt ship with MSDE, thats one of the limitations in
there. There are other free tools out there to use with the MSDE for
administering. For Queries there is QALite, which I think is a really good
one.
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
"Brian" <treddderx@.yahoo.com> schrieb im Newsbeitrag
news:uCgVoBiWFHA.3280@.TK2MSFTNGP09.phx.gbl...
> Howdy All,
> How do I open Enterprise Manager for MSDE SP3?
> I have installed MSDE as part of ACT! installation and have found
> references to Enterprise Manager, but don't know how to get into it.
> Thanks,
> Brian
>
|||Hi,
Microsoft is giving a free tool named "SQL Server Web data Administrator" to
manager and administrator the SQl server. This will be more useful to
MSDE users. Download the free tool from below site.
http://www.microsoft.com/downloads/d...displaylang=en
Thanks
Hari
SQL Server MVP
"Brian" <treddderx@.yahoo.com> wrote in message
news:uCgVoBiWFHA.3280@.TK2MSFTNGP09.phx.gbl...
> Howdy All,
> How do I open Enterprise Manager for MSDE SP3?
> I have installed MSDE as part of ACT! installation and have found
> references to Enterprise Manager, but don't know how to get into it.
> Thanks,
> Brian
>
|||Thanks for the help!
Very useful.
"Hari Prasad" <hari_prasad_k@.hotmail.com> wrote in message
news:ulsS4ylWFHA.2288@.TK2MSFTNGP14.phx.gbl...
> Hi,
> Microsoft is giving a free tool named "SQL Server Web data Administrator"
> to manager and administrator the SQl server. This will be more useful to
> MSDE users. Download the free tool from below site.
>
> http://www.microsoft.com/downloads/d...displaylang=en
>
> Thanks
> Hari
> SQL Server MVP
> "Brian" <treddderx@.yahoo.com> wrote in message
> news:uCgVoBiWFHA.3280@.TK2MSFTNGP09.phx.gbl...
>

Enterprise Manager Cannot Display Table Records or Run Query

I have a new installation of SQL Server 2000 Dev Edition on a Win2K3 Standard Edition Server that I used for development. I just set this machine up in th last week and installed all Win2K3 patches and then installed SQL2K and SP3a. I have a single named instance. I just noticed today that I cannot view table data or use the Query part of EM. When I right click a table and select Open Table->Return All Rows it gives me an error dialog "An unexpected error happened during this operation". While the EM is diplaying this dialog the EM screen looks like Internet Explorer and says "Action Canceled - You might not have permission to view this directory or page using the credentials you supplied." I believe that this is a EM issue as I cannot view table content on other remote server. ANy ideas? Might this be an IE security patch disallowing some connectivity ?

--Frank

--
Message posted via http://www.sqlmonster.com"Frank Rizzo via SQLMonster.com" <forum@.SQLMonster.com> wrote in message
news:08f32b66479d4ddcbe5ab7a876ff377d@.SQLMonster.c om...
>I have a new installation of SQL Server 2000 Dev Edition on a Win2K3
>Standard Edition Server that I used for development. I just set this
>machine up in th last week and installed all Win2K3 patches and then
>installed SQL2K and SP3a. I have a single named instance. I just noticed
>today that I cannot view table data or use the Query part of EM. When I
>right click a table and select Open Table->Return All Rows it gives me an
>error dialog "An unexpected error happened during this operation". While
>the EM is diplaying this dialog the EM screen looks like Internet Explorer
>and says "Action Canceled - You might not have permission to view this
>directory or page using the credentials you supplied." I believe that this
>is a EM issue as I cannot view table content on other remote server. ANy
>ideas? Might this be an IE security patch disallowing some connectivity ?
> --Frank
> --
> Message posted via http://www.sqlmonster.com

A number of people seem to have had similar issues - if you Google the
newsgroups, you'll see that the usual response is to reinstall either the
MSSQL client tools (including SP3a) and/or the latest MDAC version.
Unfortunately, it doesn't always seem to solve the problem.

Simon