Thursday, March 8, 2012

2008 Management Studio?

Hi all... I installed the 2008 CTP, and am trying to figure out where
Management Studio is.
I want to play around with the new auditing features and stuff... but can't
find any way to use it.
I tried searching "add features" in the BOL, but find nothing of any use.
Thanks in advance,
Arhur Dent.
Do you have SQL Server 2005 installed on the server on which you also
install SQL Server 2008?
Because if there is SQL Server 2005' s Management Studio is installed then
SQL Server 2008' s SSMS (Client Tools) will not be installed. You'll need to
uninstall SQL Server 2005' s Client Tools to be able to install SQL Server
2008's Client Tools.
If this is not your situation, then you may be missed to choose Client Tools
in SQL Server 2008 Setup\ Feature Selection\Shared Features?
Ekrem nsoy
"Arthur Dent" <hitchhikersguideto-news@.yahoo.com> wrote in message
news:7C16DA22-0BB1-484E-B9F6-39D593D5510F@.microsoft.com...
> Hi all... I installed the 2008 CTP, and am trying to figure out where
> Management Studio is.
> I want to play around with the new auditing features and stuff... but
> can't find any way to use it.
> I tried searching "add features" in the BOL, but find nothing of any use.
> Thanks in advance,
> Arhur Dent.
|||Also, if it's the Express Edition of SQL Server 2008 CTP, there is no
SSMS\SSMSE with it. There is SSMS of SQL Server 2008 only in the Developer
Edition CTP for now.
Ekrem nsoy
"Arthur Dent" <hitchhikersguideto-news@.yahoo.com> wrote in message
news:7C16DA22-0BB1-484E-B9F6-39D593D5510F@.microsoft.com...
> Hi all... I installed the 2008 CTP, and am trying to figure out where
> Management Studio is.
> I want to play around with the new auditing features and stuff... but
> can't find any way to use it.
> I tried searching "add features" in the BOL, but find nothing of any use.
> Thanks in advance,
> Arhur Dent.
|||Huh? I get what you say, but why the heck? That seems really odd,
considering they install in separate folders and hence, should be able to
coexists, and you can't even connect to the 2008 db anyway with the 2005
tools. It complains and says they can only be used to connect to 2000 or
2005 servers.
Someone at MS must've been a little distracted when they wrote that
installer. :-S
"Ekrem nsoy" <ekrem@.compecta.com> wrote in message
news:886968BD-CBB4-4143-B6A1-A887E106DA01@.microsoft.com...
> Do you have SQL Server 2005 installed on the server on which you also
> install SQL Server 2008?
> Because if there is SQL Server 2005' s Management Studio is installed then
> SQL Server 2008' s SSMS (Client Tools) will not be installed. You'll need
> to uninstall SQL Server 2005' s Client Tools to be able to install SQL
> Server 2008's Client Tools.
> If this is not your situation, then you may be missed to choose Client
> Tools in SQL Server 2008 Setup\ Feature Selection\Shared Features?
> --
> Ekrem nsoy
>
> "Arthur Dent" <hitchhikersguideto-news@.yahoo.com> wrote in message
> news:7C16DA22-0BB1-484E-B9F6-39D593D5510F@.microsoft.com...
>
|||Arthur Dent (hitchhikersguideto-news@.yahoo.com) writes:
> Huh? I get what you say, but why the heck? That seems really odd,
> considering they install in separate folders and hence, should be able to
> coexists, and you can't even connect to the 2008 db anyway with the 2005
> tools. It complains and says they can only be used to connect to 2000 or
> 2005 servers.
> Someone at MS must've been a little distracted when they wrote that
> installer. :-S
If you have Mgmt Studio 2005 Express installed on a machine and install
Mgmt Studio 2005, this does not work out. You cannot run both versions
of Mgmt Studio on the same machine. I guess it's something similar here,
except that the installer prevents it from even happening.
There is a fix for connecting to SQL 2008 from SQL 2005 Mgmt Studio,
available in Cumultative Update 5: http://support.microsoft.com/kb/943656.
But I get a little worried when you say you install SQL 2008 on a machine
on which you already have SQL 2005. Not that that in itself is wrong, but
I hope this is not your day-to-day machine. I definitely recommend against
installing beta software on machines you don't want to reinstall. Not that
I know that the SQL 2008 CTP will wreck your machine, but it's not a game
of change I'm prepared to play myself. Personally, I install all betas on
virtual machines.
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
|||I'd strongly recommend that you install any CTPs on a Virtual machine. VPC
is free.
-Paul
"Arthur Dent" <hitchhikersguideto-news@.yahoo.com> wrote in message
news:4B78B7D6-9027-408B-A211-B0213D8E823A@.microsoft.com...[vbcol=seagreen]
> Huh? I get what you say, but why the heck? That seems really odd,
> considering they install in separate folders and hence, should be able to
> coexists, and you can't even connect to the 2008 db anyway with the 2005
> tools. It complains and says they can only be used to connect to 2000 or
> 2005 servers.
> Someone at MS must've been a little distracted when they wrote that
> installer. :-S
>
> "Ekrem nsoy" <ekrem@.compecta.com> wrote in message
> news:886968BD-CBB4-4143-B6A1-A887E106DA01@.microsoft.com...
|||Yes, I know all the usual disclaimers and such about beta software, but
thank you for the suggestions.
the only problem with VPC is that while IT is free, it is NOT free to put a
copy of Windows in there. (AFAIK) you are supposed to buy another license of
windows just to run the VPC machine. :-S Rather a disincentive there.
:-\
"Paul Nielsen (SQL)" <pauln@.sqlserverbible.com> wrote in message
news:36931E74-AE48-41D6-BDAA-225AA2417A5C@.microsoft.com...
> I'd strongly recommend that you install any CTPs on a Virtual machine. VPC
> is free.
> -Paul
>
> "Arthur Dent" <hitchhikersguideto-news@.yahoo.com> wrote in message
> news:4B78B7D6-9027-408B-A211-B0213D8E823A@.microsoft.com...
>
|||Arthur Dent (hitchhikersguideto-news@.yahoo.com) writes:
> Yes, I know all the usual disclaimers and such about beta software, but
> thank you for the suggestions.
> the only problem with VPC is that while IT is free, it is NOT free to
> put a copy of Windows in there. (AFAIK) you are supposed to buy another
> license of windows just to run the VPC machine. :-S Rather a
> disincentive there.
>:-\
You can even download a preconfigured virtual machine from
http://www.microsoft.com/downloads/details.aspx?FamilyID=6a39affa-db6e-48a9-
82e4-4efd6705f4a6&DisplayLang=en
This requires Virtual Server, but according to the page, Virtual Server is
free.
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
|||yes, virtual server is available here for free:
http://technet.microsoft.com/en-us/bb738033.aspx
The virtual machine that Erland posted the link to works with this no
problem.
http://elsasoft.org
"Erland Sommarskog" <esquel@.sommarskog.se> wrote in message
news:Xns9A1D8393BF992Yazorman@.127.0.0.1...
> Arthur Dent (hitchhikersguideto-news@.yahoo.com) writes:
> You can even download a preconfigured virtual machine from
> http://www.microsoft.com/downloads/details.aspx?FamilyID=6a39affa-db6e-48a9-
> 82e4-4efd6705f4a6&DisplayLang=en
> This requires Virtual Server, but according to the page, Virtual Server is
> free.
>
> --
> Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
> Books Online for SQL Server 2005 at
> http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
> Books Online for SQL Server 2000 at
> http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
|||What version of 2008 is in the VHD? It doesn't seem to say on the page.
Is it Express or the full Developer version with all the management tools?
"Erland Sommarskog" <esquel@.sommarskog.se> wrote in message
news:Xns9A1D8393BF992Yazorman@.127.0.0.1...
> Arthur Dent (hitchhikersguideto-news@.yahoo.com) writes:
> You can even download a preconfigured virtual machine from
> http://www.microsoft.com/downloads/details.aspx?FamilyID=6a39affa-db6e-48a9-
> 82e4-4efd6705f4a6&DisplayLang=en
> This requires Virtual Server, but according to the page, Virtual Server is
> free.
>
> --
> Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
> Books Online for SQL Server 2005 at
> http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
> Books Online for SQL Server 2000 at
> http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

No comments:

Post a Comment