dbTalk Databases Forums  

SQL Server 2005 client tools

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap


Discuss SQL Server 2005 client tools in the microsoft.public.sqlserver.olap forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Robert Neptune
 
Posts: n/a

Default SQL Server 2005 client tools - 10-10-2006 , 08:25 PM







Easy question.

I've installed SQL Server 2005 Express edition, including Client components
during installation. I expected I will get somethign like Analysis Manager in
AS 2000, but I cannot see anythignlike it. How do I manege my
cubes/databases, etc..?

Thank you,

Reply With Quote
  #2  
Old   
Jeje
 
Posts: n/a

Default Re: SQL Server 2005 client tools - 10-10-2006 , 08:40 PM






the express edition don't provides any admin interface.
take a look at the express edition with advanced features to have some
little interfaces.
else, you can access SQL server using Visual Studio Express edition, but you
can't really manage your server here, just manage your database not the
server.

the express edition as no interface to manage SSAS and can't be used to
access Analysis Services.
in fact SSAS is in the standard, enterprise and dev edition of SQL Server,
so you must have one of these editions to have SSAS and the admin
interfaces.
(its the same case with SQL 2000).


"Robert Neptune" <RobertNeptune (AT) discussions (DOT) microsoft.com> wrote

Quote:
Easy question.

I've installed SQL Server 2005 Express edition, including Client
components
during installation. I expected I will get somethign like Analysis Manager
in
AS 2000, but I cannot see anythignlike it. How do I manege my
cubes/databases, etc..?

Thank you,



Reply With Quote
  #3  
Old   
Robert Neptune
 
Posts: n/a

Default Re: SQL Server 2005 client tools - 10-10-2006 , 08:55 PM




Thanks Jeje.

I'm still not sure if I get the idea. I wanted to use Express Edition to
evaluate/test SQL Server 2005 AS features etc.
Are you saying I have the enginge, but need to worry now about gettign tools
to create DB/few cubes and load them with sample data - that's all I wanted.

Would the version with Advanced features allow me to do that?
Or should I arrange Trial edition?

Thanks again,

"Jeje" wrote:

Quote:
the express edition don't provides any admin interface.
take a look at the express edition with advanced features to have some
little interfaces.
else, you can access SQL server using Visual Studio Express edition, but you
can't really manage your server here, just manage your database not the
server.

the express edition as no interface to manage SSAS and can't be used to
access Analysis Services.
in fact SSAS is in the standard, enterprise and dev edition of SQL Server,
so you must have one of these editions to have SSAS and the admin
interfaces.
(its the same case with SQL 2000).


"Robert Neptune" <RobertNeptune (AT) discussions (DOT) microsoft.com> wrote in message
news:5688C789-6E47-4011-9CE1-2CE61CB4F381 (AT) microsoft (DOT) com...

Easy question.

I've installed SQL Server 2005 Express edition, including Client
components
during installation. I expected I will get somethign like Analysis Manager
in
AS 2000, but I cannot see anythignlike it. How do I manege my
cubes/databases, etc..?

Thank you,




Reply With Quote
  #4  
Old   
Jeje
 
Posts: n/a

Default Re: SQL Server 2005 client tools - 10-10-2006 , 09:04 PM



in the express edition you don't have the SSAS server and you don't have
Reporting Services too.
You need the standard , enterprise or dev edition.

for evaluation purpose take the evaluation CD ;-)

but the Developper edition costs only 50$...


"Robert Neptune" <RobertNeptune (AT) discussions (DOT) microsoft.com> wrote

Quote:
Thanks Jeje.

I'm still not sure if I get the idea. I wanted to use Express Edition to
evaluate/test SQL Server 2005 AS features etc.
Are you saying I have the enginge, but need to worry now about gettign
tools
to create DB/few cubes and load them with sample data - that's all I
wanted.

Would the version with Advanced features allow me to do that?
Or should I arrange Trial edition?

Thanks again,

"Jeje" wrote:

the express edition don't provides any admin interface.
take a look at the express edition with advanced features to have some
little interfaces.
else, you can access SQL server using Visual Studio Express edition, but
you
can't really manage your server here, just manage your database not the
server.

the express edition as no interface to manage SSAS and can't be used to
access Analysis Services.
in fact SSAS is in the standard, enterprise and dev edition of SQL
Server,
so you must have one of these editions to have SSAS and the admin
interfaces.
(its the same case with SQL 2000).


"Robert Neptune" <RobertNeptune (AT) discussions (DOT) microsoft.com> wrote in
message
news:5688C789-6E47-4011-9CE1-2CE61CB4F381 (AT) microsoft (DOT) com...

Easy question.

I've installed SQL Server 2005 Express edition, including Client
components
during installation. I expected I will get somethign like Analysis
Manager
in
AS 2000, but I cannot see anythignlike it. How do I manege my
cubes/databases, etc..?

Thank you,






Reply With Quote
  #5  
Old   
Robert Neptune
 
Posts: n/a

Default Re: SQL Server 2005 client tools - 10-10-2006 , 09:29 PM




That's a good one. I indeed was not sure about this, and could not find MS
web page that would give me clear answer.
well, thank you

"Jeje" wrote:

Quote:
in the express edition you don't have the SSAS server and you don't have
Reporting Services too.

Reply With Quote
  #6  
Old   
Jeje
 
Posts: n/a

Default Re: SQL Server 2005 client tools - 10-10-2006 , 09:34 PM



http://www.microsoft.com/sql/prodinf...-features.mspx

"Robert Neptune" <RobertNeptune (AT) discussions (DOT) microsoft.com> wrote

Quote:
That's a good one. I indeed was not sure about this, and could not find MS
web page that would give me clear answer.
well, thank you

"Jeje" wrote:

in the express edition you don't have the SSAS server and you don't have
Reporting Services too.



Reply With Quote
  #7  
Old   
Arnie Rowland
 
Posts: n/a

Default Re: SQL Server 2005 client tools - 10-11-2006 , 02:31 AM



I suggest that you download the 'Evaluation' version of SQL Server 2005. You
then can test all features and better decide which features you require.

--
Arnie Rowland, Ph.D.
Westwood Consulting, Inc

Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous


"Robert Neptune" <RobertNeptune (AT) discussions (DOT) microsoft.com> wrote

Quote:
That's a good one. I indeed was not sure about this, and could not find MS
web page that would give me clear answer.
well, thank you

"Jeje" wrote:

in the express edition you don't have the SSAS server and you don't have
Reporting Services too.



Reply With Quote
  #8  
Old   
Marco
 
Posts: n/a

Default Re: SQL Server 2005 client tools - 10-11-2006 , 04:11 AM



Hi Robert,

Go to : http://www.reportportal.com/download.asp

And click on the Microsoft SQL Server 2005 URL and if you like download
also the ReportPortal Trial to publish and see SSAS 2005 OLAP Cubes +
SSAS2005 KPIs live on your intranet

Regards,
Marco
www.gmsbv.nl


Robert Neptune schreef:

Quote:
That's a good one. I indeed was not sure about this, and could not find MS
web page that would give me clear answer.
well, thank you

"Jeje" wrote:

in the express edition you don't have the SSAS server and you don't have
Reporting Services too.


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.