I dont see Server Management Studio on the XP with the Standard version

I have installed SQL 2005 Standard Edition on my Window XP many times and I dont see Server Management Studio.

Did I do something wrong?

Thanks.

you need to have Windows XP professional edition with SP2........refer the link,

http://support.microsoft.com/kb/910228 and if you have the necessary system requirements just go to tools folder and manually run the sqlrun_tools..........it will get installed........

|||

I didnt have to run as a separate step when I install the SQL Developer on XP SP2.

I do have XP SP2 on my PC and when I run the SQL 2005 Standard Edition, I didnt see the Server Management Studio.

So it is a separate step after a normal install?

Is it Performance Tool? Or a tool folder on the SQL 2005 STD Edition CD?

|||

there will be a tool folder may be you can insert the disk 2 and check it.....generally there will 2 folders in sql 2005 one is server and other is tool.........

|||

The default install ONLY installs the Server and network connections support.

To install SSMS, you need to put the media in again, and this time choose 'Client Tools' from the installation menu.

|||Management studio is not a performance tool, its just an replacement for Enterprise Manger

I don't have Sql Server at home. Is a trial version the best alternative?

I don't have Sql Server yet. I'd like to learn it at home before I
apply to businesses that use it. I see that there is a trial version
of sql server 2005 that lasts 180 days. But are there any other ways
to learn it? I seem to remember something about Microsoft Access being
able to work with it, and that Microsoft had some other products that
you could get instead for home use, but I don't remember the details.
Thanks,
Dear Blackdog:
I think the best way to go about this (and to see SOME of the benefits of
SQL 2005) is to download and use the free version of SQL 2005 - SQL 2005
Express ...
You can view information about it and download it from here:
http://www.microsoft.com/sql/edition...s/default.mspx
Ryan

I don't have Sql Server at home. Is a trial version the best alternative?

I don't have Sql Server yet. I'd like to learn it at home before I
apply to businesses that use it. I see that there is a trial version
of sql server 2005 that lasts 180 days. But are there any other ways
to learn it? I seem to remember something about Microsoft Access being
able to work with it, and that Microsoft had some other products that
you could get instead for home use, but I don't remember the details.
Thanks,Dear Blackdog:
I think the best way to go about this (and to see SOME of the benefits of
SQL 2005) is to download and use the free version of SQL 2005 - SQL 2005
Express ...
You can view information about it and download it from here:
http://www.microsoft.com/sql/editions/express/default.mspx
Ryan|||BLACKDOG157@.LYCOS.COM wrote:
> I don't have Sql Server yet. I'd like to learn it at home before I
> apply to businesses that use it. I see that there is a trial version
> of sql server 2005 that lasts 180 days. But are there any other ways
> to learn it? I seem to remember something about Microsoft Access being
> able to work with it, and that Microsoft had some other products that
> you could get instead for home use, but I don't remember the details.
> Thanks,
You can also get Developer Edition for $49.95
http://www.microsoft.com/sql/editions/developer/default.mspx
--
David Portas
SQL Server MVP
--|||"David Portas" <REMOVE_BEFORE_REPLYING_dportas@.acm.org> wrote in message
news:1137019989.434894.33740@.g14g2000cwa.googlegroups.com...
> BLACKDOG157@.LYCOS.COM wrote:
> > I don't have Sql Server yet. I'd like to learn it at home before I
> > apply to businesses that use it. I see that there is a trial version
> > of sql server 2005 that lasts 180 days. But are there any other ways
> > to learn it? I seem to remember something about Microsoft Access being
> > able to work with it, and that Microsoft had some other products that
> > you could get instead for home use, but I don't remember the details.
> > Thanks,
> You can also get Developer Edition for $49.95
> http://www.microsoft.com/sql/editions/developer/default.mspx
David, I was just looking there earlier today, and can't find where it says
what the features of Developer Edition are, nor how much it costs. Could you
post the URLs to those pages, or else tell me where I missed seeing them?
Thanks,
John Saunders|||Everything you need is posted on the URL posted by David or a direct link
off said same URL.
Copied directly from the URL mentioned by David:
Developer Edition allows developers to build and test any type of
application on top of SQL Server on 32-bit and x64 platforms. It includes
all of the functionality of Enterprise Edition, but is licensed for use as a
development and test system, not as a production server. Developer Edition
can be upgraded to SQL Server Enterprise Edition for production use.
From the "How to Buy Page" a link right off the URL mentioned by David:
http://www.microsoft.com/sql/howtobuy/default.mspx
The retail price for SQL Server 2005 Developer Edition is $49.95.
Star Fleet Admiral Q @. your service!
Google is your friend!
http://www.google.com
"John Saunders" <jsaunders@.navimedix.com> wrote in message
news:uZtXYtwFGHA.3624@.TK2MSFTNGP09.phx.gbl...
> "David Portas" <REMOVE_BEFORE_REPLYING_dportas@.acm.org> wrote in message
> news:1137019989.434894.33740@.g14g2000cwa.googlegroups.com...
>> BLACKDOG157@.LYCOS.COM wrote:
>> > I don't have Sql Server yet. I'd like to learn it at home before I
>> > apply to businesses that use it. I see that there is a trial version
>> > of sql server 2005 that lasts 180 days. But are there any other ways
>> > to learn it? I seem to remember something about Microsoft Access being
>> > able to work with it, and that Microsoft had some other products that
>> > you could get instead for home use, but I don't remember the details.
>> > Thanks,
>> You can also get Developer Edition for $49.95
>> http://www.microsoft.com/sql/editions/developer/default.mspx
> David, I was just looking there earlier today, and can't find where it
> says
> what the features of Developer Edition are, nor how much it costs. Could
> you
> post the URLs to those pages, or else tell me where I missed seeing them?
> Thanks,
> John Saunders
>|||"Admiral Q" <Star_Fleet_Admiral_Q(No_Spam)@.(Spam_Not)hotmail.com> wrote in
message news:%230cCINxFGHA.1452@.TK2MSFTNGP11.phx.gbl...
> Everything you need is posted on the URL posted by David or a direct link
> off said same URL.
> Copied directly from the URL mentioned by David:
> Developer Edition allows developers to build and test any type of
> application on top of SQL Server on 32-bit and x64 platforms. It includes
> all of the functionality of Enterprise Edition, but is licensed for use as
a
> development and test system, not as a production server. Developer Edition
> can be upgraded to SQL Server Enterprise Edition for production use.
> From the "How to Buy Page" a link right off the URL mentioned by David:
> http://www.microsoft.com/sql/howtobuy/default.mspx
> The retail price for SQL Server 2005 Developer Edition is $49.95.
Thanks, I now see how I missed it. I was looking for a "Features" link, but
the features blurb was in text. The comparison grid didn't include the
Developer edition. Similarly, the $49.95 price is right under a pricing grid
which does not list Developer edition!
John

I don't have Sql Server at home. Is a trial version the best alternative?

I don't have Sql Server yet. I'd like to learn it at home before I
apply to businesses that use it. I see that there is a trial version
of sql server 2005 that lasts 180 days. But are there any other ways
to learn it? I seem to remember something about Microsoft Access being
able to work with it, and that Microsoft had some other products that
you could get instead for home use, but I don't remember the details.
Thanks,Dear Blackdog:
I think the best way to go about this (and to see SOME of the benefits of
SQL 2005) is to download and use the free version of SQL 2005 - SQL 2005
Express ...
You can view information about it and download it from here:
http://www.microsoft.com/sql/editio...ss/default.mspx
Ryan

I can't deploy a Cube

I have installed the client version of Sql Server 2005 on my machine and the server version is Installed on a server of my company (VALLEY).

I have created a Cube with the wizard to test Analysis Services 2005 and see the result after the deployment. The cube works with a database called ROI on the server VALLEY,

But, when I try to deploy the cube, I have this error message:

" the user XXXX don't have permission to modify the object or the object does not exist"

I don't know if I must configure some specific access.

Could you help me please, I search a solution since 2 days with any results.

Betty

Betty,

This is probably one of two things:

- Your impersonation information is not correct, for the AS server

- The user, specified in the impersonation config, is not a member of the SQLSERVER2005MSOLAP... group.

Post back if this still does not fix the issue...

|||

Where can I add the user into the SQLSERVER2005MSOLAP group?

And can you confirm than the impersonation information corresponds to the login and password to connect to the database or not?

I have create a cube with the database of the tutorial and i can't deploy it too so I think it' not a problem with the impersonation information but if I'm wrong, say it.

Betty

|||

You can add the user to the group through the Local Users and Groups menu.

( right click "My computer" -> MANAGE -> expand Local Users and Groups -> click Groups )

The group should be named something like SQL2005OLAPUSERS$<Boxname>$mssqlserver depending on set up. This was OLAP Administrators in SQL 2000, I believe.

The impersonation credentials may or may not be be the same to connect to the DB, but I would recommend trying whatever username/password you are using to connect to Analysis Services through Visual Studio.

Tell me if that helps,

Tristan

|||

Sorry but all that don't resolve my problem

|||I got the same error. Connect to Analysis services. Right click on the analysis services server. Go to security and add yourself using the domain/user id.|||

i have installed the client version of Sql Server 2005 on my machine and the server version is Installed on a server of my company.

But, when I try to deploy the cube, I have this error message:

Error 1 The project could not be deployed to the "company server name" server because of the following connectivity problems : A connection cannot be made. Ensure that the server is running. To verify or update the name of the target server, right-click on the project in Solution Explorer, select Project Properties, click on the Deployment tab, and then enter the name of the server. 0 0

i dont know is it configaration mistake or the cube creation mistake

Could you help me please

I can't deploy a Cube

I have installed the client version of Sql Server 2005 on my machine and the server version is Installed on a server of my company (VALLEY).

I have created a Cube with the wizard to test Analysis Services 2005 and see the result after the deployment. The cube works with a database called ROI on the server VALLEY,

But, when I try to deploy the cube, I have this error message:

" the user XXXX don't have permission to modify the object or the object does not exist"

I don't know if I must configure some specific access.

Could you help me please, I search a solution since 2 days with any results.

Betty

Betty,

This is probably one of two things:

- Your impersonation information is not correct, for the AS server

- The user, specified in the impersonation config, is not a member of the SQLSERVER2005MSOLAP... group.

Post back if this still does not fix the issue...

|||

Where can I add the user into the SQLSERVER2005MSOLAP group?

And can you confirm than the impersonation information corresponds to the login and password to connect to the database or not?

I have create a cube with the database of the tutorial and i can't deploy it too so I think it' not a problem with the impersonation information but if I'm wrong, say it.

Betty

|||

You can add the user to the group through the Local Users and Groups menu.

( right click "My computer" -> MANAGE -> expand Local Users and Groups -> click Groups )

The group should be named something like SQL2005OLAPUSERS$<Boxname>$mssqlserver depending on set up. This was OLAP Administrators in SQL 2000, I believe.

The impersonation credentials may or may not be be the same to connect to the DB, but I would recommend trying whatever username/password you are using to connect to Analysis Services through Visual Studio.

Tell me if that helps,

Tristan

|||

Sorry but all that don't resolve my problem

|||I got the same error. Connect to Analysis services. Right click on the analysis services server. Go to security and add yourself using the domain/user id.|||

i have installed the client version of Sql Server 2005 on my machine and the server version is Installed on a server of my company.

But, when I try to deploy the cube, I have this error message:

Error 1 The project could not be deployed to the "company server name" server because of the following connectivity problems : A connection cannot be made. Ensure that the server is running. To verify or update the name of the target server, right-click on the project in Solution Explorer, select Project Properties, click on the Deployment tab, and then enter the name of the server. 0 0

i dont know is it configaration mistake or the cube creation mistake

Could you help me please

sql

I can't deploy a Cube

I have installed the client version of Sql Server 2005 on my machine and the server version is Installed on a server of my company (VALLEY).

I have created a Cube with the wizard to test Analysis Services 2005 and see the result after the deployment. The cube works with a database called ROI on the server VALLEY,

But, when I try to deploy the cube, I have this error message:

" the user XXXX don't have permission to modify the object or the object does not exist"

I don't know if I must configure some specific access.

Could you help me please, I search a solution since 2 days with any results.

Betty

Betty,

This is probably one of two things:

- Your impersonation information is not correct, for the AS server

- The user, specified in the impersonation config, is not a member of the SQLSERVER2005MSOLAP... group.

Post back if this still does not fix the issue...

|||

Where can I add the user into the SQLSERVER2005MSOLAP group?

And can you confirm than the impersonation information corresponds to the login and password to connect to the database or not?

I have create a cube with the database of the tutorial and i can't deploy it too so I think it' not a problem with the impersonation information but if I'm wrong, say it.

Betty

|||

You can add the user to the group through the Local Users and Groups menu.

( right click "My computer" -> MANAGE -> expand Local Users and Groups -> click Groups )

The group should be named something like SQL2005OLAPUSERS$<Boxname>$mssqlserver depending on set up. This was OLAP Administrators in SQL 2000, I believe.

The impersonation credentials may or may not be be the same to connect to the DB, but I would recommend trying whatever username/password you are using to connect to Analysis Services through Visual Studio.

Tell me if that helps,

Tristan

|||

Sorry but all that don't resolve my problem

|||I got the same error. Connect to Analysis services. Right click on the analysis services server. Go to security and add yourself using the domain/user id.|||

i have installed the client version of Sql Server 2005 on my machine and the server version is Installed on a server of my company.

But, when I try to deploy the cube, I have this error message:

Error 1 The project could not be deployed to the "company server name" server because of the following connectivity problems : A connection cannot be made. Ensure that the server is running. To verify or update the name of the target server, right-click on the project in Solution Explorer, select Project Properties, click on the Deployment tab, and then enter the name of the server. 0 0

i dont know is it configaration mistake or the cube creation mistake

Could you help me please

I can't deploy a Cube

I have installed the client version of Sql Server 2005 on my machine and the server version is Installed on a server of my company (VALLEY).

I have created a Cube with the wizard to test Analysis Services 2005 and see the result after the deployment. The cube works with a database called ROI on the server VALLEY,

But, when I try to deploy the cube, I have this error message:

" the user XXXX don't have permission to modify the object or the object does not exist"

I don't know if I must configure some specific access.

Could you help me please, I search a solution since 2 days with any results.

Betty

Betty,

This is probably one of two things:

- Your impersonation information is not correct, for the AS server

- The user, specified in the impersonation config, is not a member of the SQLSERVER2005MSOLAP... group.

Post back if this still does not fix the issue...

|||

Where can I add the user into the SQLSERVER2005MSOLAP group?

And can you confirm than the impersonation information corresponds to the login and password to connect to the database or not?

I have create a cube with the database of the tutorial and i can't deploy it too so I think it' not a problem with the impersonation information but if I'm wrong, say it.

Betty

|||

You can add the user to the group through the Local Users and Groups menu.

( right click "My computer" -> MANAGE -> expand Local Users and Groups -> click Groups )

The group should be named something like SQL2005OLAPUSERS$<Boxname>$mssqlserver depending on set up. This was OLAP Administrators in SQL 2000, I believe.

The impersonation credentials may or may not be be the same to connect to the DB, but I would recommend trying whatever username/password you are using to connect to Analysis Services through Visual Studio.

Tell me if that helps,

Tristan

|||

Sorry but all that don't resolve my problem

|||I got the same error. Connect to Analysis services. Right click on the analysis services server. Go to security and add yourself using the domain/user id.|||

i have installed the client version of Sql Server 2005 on my machine and the server version is Installed on a server of my company.

But, when I try to deploy the cube, I have this error message:

Error 1 The project could not be deployed to the "company server name" server because of the following connectivity problems : A connection cannot be made. Ensure that the server is running. To verify or update the name of the target server, right-click on the project in Solution Explorer, select Project Properties, click on the Deployment tab, and then enter the name of the server. 0 0

i dont know is it configaration mistake or the cube creation mistake

Could you help me please