Showing posts with label manager. Show all posts
Showing posts with label manager. Show all posts

Monday, February 20, 2012

Quetions about Sql server 2005 CPT April installation -- can not find "Sql server manager s

I suceeded in installing sql server 2005 CPT (April), and no any error appeared. But when I pressed Start -- All programs -- Miscrosoft Sql server 2005 CPT, just one "Configuration Tools" appeared. No "Sql server manager studio", "Sql server books online" and other items appear. I can not find them. I don't know how to find them, either.

I also go to the Administrative tools -- Services, and the Analysis Server, Report server, Sql Server, sql server agent have been started.

So, can any body help me out? Thanks.I'm guessing you either already had SQL Server Express installed (possibly through VS) or you didn't select the tools from the feature tree.

There is a known issue with the interaction of Tools installed with Developer (Beta/CTP) Edition and Express. If you edinstall Express first the only way you can install the tools with Developer is to first uninstall the tools Express installed - note that if you install Express through VS it does a full Express installation.

Working around the Tools.msi issues with SQL Server Express:

Scenario 1: Install VS w/ Express First

1) Install VS with Express

2) Go to Add/Remove Programs and remove "SQL Server Tools Express"

3) Install SQL Server Beta SKU with Tools

Scenario 2: Install SQL Server Beta First

1) Install SQL Server Beta w/o Tools

2) Install VS with Express

3) Go to Add/Remove Programs and remove "SQL Server Tools Express"

4) Rerun SQL Server Beta setup and select tools

This is something we'll have cleaned up before we ship. I hope this helps.

Dan

Questions: MSDE 2000

Currently using MSDE 7 with SQL Enterprise Manager. Our company is
contemplating upgrading to MSDE 2000.
1. Do I have to download a new SQL Enterprise Manager to work with MSDE
2000?
2. Can SQL Enterprise Manager access BOTH MSDE 7 AND MSDE 2000 databases?
Thanks.Hi,
SQL7 enterprise manager cannot connect to a SQL2000 database.You need to
upgrade.
--
Dinesh.
SQL Server FAQ at
http://www.tkdinesh.com
"VB Programmer" <growNO-SPAM@.go-intech.com> wrote in message
news:%23DSqxRaZDHA.656@.tk2msftngp13.phx.gbl...
> Currently using MSDE 7 with SQL Enterprise Manager. Our company is
> contemplating upgrading to MSDE 2000.
> 1. Do I have to download a new SQL Enterprise Manager to work with MSDE
> 2000?
> 2. Can SQL Enterprise Manager access BOTH MSDE 7 AND MSDE 2000 databases?
> Thanks.
>|||Upgrade to what? SQL 2000? All I want to use is the FREE MSDE 2000 database.
As I remember I didn't have to purchase SQL 7 Enterprise Manager. It came
with Visual Studio or something. Do you have a link where I can download
both MSDE2000 and the newest Enterprise Manager to use with it?
"Dinesh.T.K" <tkdinesh@.nospam.mail.tkdinesh.com> wrote in message
news:uL1TybaZDHA.2284@.TK2MSFTNGP10.phx.gbl...
> Hi,
> SQL7 enterprise manager cannot connect to a SQL2000 database.You need to
> upgrade.
> --
> Dinesh.
> SQL Server FAQ at
> http://www.tkdinesh.com
> "VB Programmer" <growNO-SPAM@.go-intech.com> wrote in message
> news:%23DSqxRaZDHA.656@.tk2msftngp13.phx.gbl...
> > Currently using MSDE 7 with SQL Enterprise Manager. Our company is
> > contemplating upgrading to MSDE 2000.
> >
> > 1. Do I have to download a new SQL Enterprise Manager to work with MSDE
> > 2000?
> > 2. Can SQL Enterprise Manager access BOTH MSDE 7 AND MSDE 2000
databases?
> >
> > Thanks.
> >
> >
>|||> both MSDE2000 and the newest Enterprise Manager to use with it?
You can't download Enterprise Manager, unless you want the evaluation
version with a timebomb (which, by licensing, would, I think, be illegal to
use for managing MSDE, unless you are truly evaluating it...).
Some other options: http://www.aspfaq.com/2442|||> Part of the "deal" with the MSDE is that it's choked down to only 5
> connections
That's not true. There is a query governor that kicks in after there are
already 5 *concurrent workloads*... much different from *connections*
> and 1 database
Not true either (32,767, IIRC).
For a more concise list of MSDE limitations/features, see
http://www.aspfaq.com/2343 and http://www.aspfaq.com/2345|||Great response. Is it legal to buy SQL 2000 Server Developer Edition JUST to
use the tools (ie Enterprise Manager, etc...) on MSDE databases that I
distributed to my customers?
"J O Holloway" <jholloway@.pinncorp.com> wrote in message
news:eFjfPAdZDHA.1940@.TK2MSFTNGP10.phx.gbl...
> You can use the SQL Server 2000 Enterprise Manager to access both MSDE 1.0
> and MSDE 2000.
> I realize that that doesn't help you right now, since apparently you only
> have the SQL Server 7 EM.
> Part of the "deal" with the MSDE is that it's choked down to only 5
> connections and 1 database and 2 GB and NO GUI TOOLS.
> A full license for SQL Server 2000 Developer is now under $50, including
> shipping. Here's one site:
> http://www.pcconnection.com/scripts/productdetail.asp?product_id=213218
> There are others. For that kind of low cost, you might be better served
to
> just buy the Developer Edition.
> There are a few other GUIs for the MSDE, and you might find a free one.
For
> the money, I was glad to buy my own copy of SQL Server Developer. If
you're
> jammed for time, you can still interact with the MSDE via the oSQL
utility.
> You can find links for downloading the MSDE (and service patches) on the
MS
> site.
> Best of luck.
>
> "VB Programmer" <growNO-SPAM@.go-intech.com> wrote in message
> news:#DSqxRaZDHA.656@.tk2msftngp13.phx.gbl...
> > Currently using MSDE 7 with SQL Enterprise Manager. Our company is
> > contemplating upgrading to MSDE 2000.
> >
> > 1. Do I have to download a new SQL Enterprise Manager to work with MSDE
> > 2000?
> > 2. Can SQL Enterprise Manager access BOTH MSDE 7 AND MSDE 2000
databases?
> >
> > Thanks.
> >
> >
>|||Thanks for the clarifications.
"Aaron Bertrand - MVP" <aaron@.TRASHaspfaq.com> wrote in message
news:OrFdNQdZDHA.1832@.TK2MSFTNGP10.phx.gbl...
> > Part of the "deal" with the MSDE is that it's choked down to only 5
> > connections
> That's not true. There is a query governor that kicks in after there are
> already 5 *concurrent workloads*... much different from *connections*
> > and 1 database
> Not true either (32,767, IIRC).
> For a more concise list of MSDE limitations/features, see
> http://www.aspfaq.com/2343 and http://www.aspfaq.com/2345
>