|
|
|
| I have SQL Server 2000 but discovered it doesn't install on
Server 2003 Web Edition, so I installed MSDE 2000 revision
A. Now I've googled up the wazoo, searched the SQL 2000
CD and searched the MS website but I can't figure out where
to get the tools to actually manage MSDE and set up a db and
what not. Any pointers appreciated. Thanks!
| |
| burt_king 2005-11-29, 9:24 am |
| MSDE doesn't come with any tools. If you have enterprise manager in your
environment you can use that but it's not something you can purchase seperate
from the SQL 2000 server license.
Use the command prompt to administer the MSDE. osql is the default
"Manager" and requires a pretty good knowledge of SQL Server to get around.
--
burt_king@yahoo.com
"RobR" wrote:
> I have SQL Server 2000 but discovered it doesn't install on
> Server 2003 Web Edition, so I installed MSDE 2000 revision
> A. Now I've googled up the wazoo, searched the SQL 2000
> CD and searched the MS website but I can't figure out where
> to get the tools to actually manage MSDE and set up a db and
> what not. Any pointers appreciated. Thanks!
>
>
>
| |
|
| Problem solved, as I mentioned I do have the actual SQL server 2000 CD.
I just couldnt use it on 2003 Web Edition so resorted to MSDE.
I figured out that you have to go through the motions as though
you were actually going to install SQL server. i didn't expect
this to work since I was running on XP Pro. I finally found
the info on installing the client tools in the help file on the CD.
"burt_king" <burt_king@yahoo.com> wrote in message
news:2A73C903-5A83-45C0-AE30- C00889C85766@microso
ft.com...[color=darkred]
> MSDE doesn't come with any tools. If you have enterprise manager in your
> environment you can use that but it's not something you can purchase
> seperate
> from the SQL 2000 server license.
>
> Use the command prompt to administer the MSDE. osql is the default
> "Manager" and requires a pretty good knowledge of SQL Server to get
> around.
>
>
> --
> burt_king@yahoo.com
>
>
> "RobR" wrote:
>
| |
| burt_king 2005-11-29, 11:23 am |
| Bear in mind that Licensing requirements must still be met for SQL 2000 even
though you're using Enterprise Manager against an MSDE.
--
burt_king@yahoo.com
"RobR" wrote:
> Problem solved, as I mentioned I do have the actual SQL server 2000 CD.
> I just couldnt use it on 2003 Web Edition so resorted to MSDE.
>
> I figured out that you have to go through the motions as though
> you were actually going to install SQL server. i didn't expect
> this to work since I was running on XP Pro. I finally found
> the info on installing the client tools in the help file on the CD.
>
> "burt_king" <burt_king@yahoo.com> wrote in message
> news:2A73C903-5A83-45C0-AE30- C00889C85766@microso
ft.com...
>
>
>
|
|
|
|