Difference between these two SQL Express

Anyone can tell me the difference between

Microsoft SQL Server 2005 Express Edition with Advanced Services

and

Microsoft SQL Server 2005 Express Edition Toolkit

I am wondering which one should i install

If you want to use all posisble features of express you should install both.

Difference between Reconnect and Reflesh

Hello people,

In Analysis Services 2005's cube browser, there are two buttons "Refconnect" and "Refresh", which is the difference between them? When should I use each one?

Thanks in advance.

Hernán.

Hi Hernán,

A short description of these options is also available at: http://msdn2.microsoft.com/en-us/library/ms188087(SQL.90).aspx. Basically, if the connection to the server has been lost, you need to "reconnect". If the connection is alive and you just want to see the data changes caused by a recent processing operation for example, you would use "refresh".

Hope this helps,

Artur

Difference between Matrix and Table

Hello.
I'm fairly new to Reporting Services, so my question might seem really
simple to you guys. But what is the difference between a matrix and a table?
When should I use what? Are there any articles on the web that explain this?
The best I've found is in this article:
http://www.ftponline.com/vsm/2004_09/magazine/columns/databasedesign/default_pf.aspx
[Quote]
The report type defines the structure, or data region, of the data returned
by your query. The Report Wizard lets you present this information as either
a table or a matrix, though you have more options outside the wizard. The
main difference between these two types of data regions is the number of
columns. A table has a fixed number of columns; a matrix has a variable
number determined by the query results.
[/quote]
- But I'd like to see a more practical explanation.
Any input appreciated!
Kaisa M. LindahlI use matrix when I have both row and column groupings. What I mean is if I
have row groupings as Dept, Group, User (drill down) and in the column I have
year, quarter, month drilldowns, u have to use a matrix. If you just have row
groupings I would suggest use the table, because a matrix is quite buggy when
it comes to exporting to excel.
Hope this helps
"Kaisa M. Lindahl" wrote:
> Hello.
> I'm fairly new to Reporting Services, so my question might seem really
> simple to you guys. But what is the difference between a matrix and a table?
> When should I use what? Are there any articles on the web that explain this?
> The best I've found is in this article:
> http://www.ftponline.com/vsm/2004_09/magazine/columns/databasedesign/default_pf.aspx
> [Quote]
> The report type defines the structure, or data region, of the data returned
> by your query. The Report Wizard lets you present this information as either
> a table or a matrix, though you have more options outside the wizard. The
> main difference between these two types of data regions is the number of
> columns. A table has a fixed number of columns; a matrix has a variable
> number determined by the query results.
> [/quote]
> - But I'd like to see a more practical explanation.
> Any input appreciated!
> Kaisa M. Lindahl
>
>

Difference between AMO and ADOMD.NET

What are the differences between these two way to query and manipulate an Analysis Services database? When should I choose one over the other?

AMO is the management object model, used to create, alter, delete, backup, restore objects.

ADOMD.NET is the query object model, used to run MDX queries, discover requests.

Adrian Dumitrascu

Diff. between using XML DOM and SQL Server 2000

Please Can I know the difference between using XML DOM(in any application language) and using the XML services of SQL Server 2000 to create XML data from SQL Server 2000 database?
The DOM is a specific API to access data that is already XML or has an XML
representation. It is useful in close-coupled programming environments and
where navigational access is more important than data storage and data
access cost.
SQL Server 2000 generates the XML in a streaming way that then can be
processed in a streaming pipeline or can be loaded into a DOM. The streaming
generation provides a more memory-efficient, more performant and scalable
way to generate XML than buffering all the data in a DOM and then passing
the DOM.
Best regards
Michael
"Rani Ponmathi" <ranibackup@.yahoo.com> wrote in message
news:0DC00FE5-67FB-4B08-BD83-84DF0809EE0D@.microsoft.com...
> Please Can I know the difference between using XML DOM(in any application
> language) and using the XML services of SQL Server 2000 to create XML
> data from SQL Server 2000 database?

Did MS change RS licensing in 2005?

Hi,
With SQL Server 2000 and Reporting Services, I'd have to have an additional
SQL Server license if I wanted to run Reporting Services on a server other
the database server. I don't want to run Reporting Services on the same
machine as SQL Server as I'm not so crazy about running IIS and SQL Server on
the same machine.
My question is did MS change licensing for Reporting Services in the new
version that will be released w/ SQL Server 2005? Or will I still need an
additional license for Reporting Services if I wanted to run it on a
different machine?
--
Thanks,
SamAs far as I know this has not changed.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Sam" <Sam@.discussions.microsoft.com> wrote in message
news:AC7D944B-258E-4394-AF42-493E1E1E190E@.microsoft.com...
> Hi,
> With SQL Server 2000 and Reporting Services, I'd have to have an
> additional
> SQL Server license if I wanted to run Reporting Services on a server other
> the database server. I don't want to run Reporting Services on the same
> machine as SQL Server as I'm not so crazy about running IIS and SQL Server
> on
> the same machine.
> My question is did MS change licensing for Reporting Services in the new
> version that will be released w/ SQL Server 2005? Or will I still need an
> additional license for Reporting Services if I wanted to run it on a
> different machine?
> --
> Thanks,
> Sam

Dialog Security questions

Hi Remus

Thank you for the email reply.

However i am still not 100% clear, dialog security with certificates when there are hundreds of remote services seems a bit complicated.

I have a few more questions.

1. you said "When sending the first message (any direction), we look up the 'best' certificate for each user"

My inititor sevice is owned by dbo, i have created certificates only for named users not dbo, how would this work?

2. I am going to try settin gup this again, but at the central service i will create a seprate user for each remote service, authorize the remote certificate for this user and use this user in the remote service binding for that remote service, is this correct or am i still doing somehting wrong?

3. How does all of this relate to the endpoint security, i ahve the same scenario, 1 pricipal id with all remote certificates authorized for it for the endpoint? I have no idea how i would have to setup different user for each remote servcie as far as the endpoint goes as there is no remote service binding to dictate which user to use ?

I will keep try and experimenting maybe i will get it right sooner or later.

Thank You

Dietz wrote:

1. you said "When sending the first message (any direction), we look up the 'best' certificate for each user". My inititor sevice is owned by dbo, i have created certificates only for named users not dbo, how would this work?

If 'dbo' is the owner of the service, then dbo must have a certificate. I'm not a fan of having dbo own the services, but there isn't anything to prevent this from working.

Dietz wrote:

2. I am going to try settin gup this again, but at the central service i will create a seprate user for each remote service, authorize the remote certificate for this user and use this user in the remote service binding for that remote service, is this correct or am i still doing somehting wrong?

Yes, you will need a separate user for each service you are trying to address.

Dietz wrote:

3. How does all of this relate to the endpoint security, i ahve the same scenario, 1 pricipal id with all remote certificates authorized for it for the endpoint? I have no idea how i would have to setup different user for each remote servcie as far as the endpoint goes as there is no remote service binding to dictate which user to use ?

Dialog messages may hop multiple hosts (forwarders) and may be stored by intermediaries for a long time. This loosely coupled patern of dialogs prevents them from being able to do a handshake before exchanging messages. If the initiator is up from 6 am to 6 pm and the target is up from 6 pm to 6 am, a handshake involving 3 messages (quite typical in world of security: a request, a chalenge and a response to the challenge) would mean that any new dialog would first have to wait more than 24 hours for the handshake to complete. W/o the luxury of a handshake, dialogs must choose upfront the appropiate certificate to use. This is why dialog security needs a concept like a 'remote service binding', that binds the remote service name to a certificate to be used before sending the first message.

Endpoints/transport security on the other hand is always between two instances that can open a direct connection, so they can afford the luxury of a handshake. So there is no need to choose a certificate upfront, a handshake can exchange and then validate the certificates used (there's nothing new here, this is how SSL and TLS were working for years). As a result, there is no need for a concept like a 'remote endpoint binding'. This also implies that you can have one user own all the endpoint certificates from all the peers.

Thanks,
~ Remus

P.S. I've split your original post because I don't like 2 page threads, I have to scroll down all the time to get to the second page.

|||

Hi Remus

Thank you very much for all your help, i guess i am just going to have to keeping messing around until i truely understand it.

Thank you for all the assistance, i have this working now with a user for each remote service, i still dont understand how to properly create a non dbo certified user on both sides, and i cannot find any examples, i will just keep messing around i guess that is the best wat to learn.

Thanx

|||

"If 'dbo' is the owner of the service, then dbo must have a certificate. I'm not a fan of having dbo own the services, but there isn't anything to prevent this from working."

I would love to not use dbo, however i cannot find a good code examples with the proper steps and explanations on how to do this? Only good example i have uses dbo. Only other example i have found not using dbo is too simple for my solution with hundreds of possible initiators, and i am not sure how to implement properly. No offense but BOL sucks, and i cannot find any decent examples and the webcasts on service broker are very high level. Bottom line is that finding good Service broker resources on this type of scenario is virutally impossible.

But i do really do appreciate your feedback, Thanx

|||

You should use either the AUTHORIZATION clause of the CREATE statement, either the ALTER AUTHORIZATION statement. Here is an example:

-- when starting from scratch

create user [InitiatorServiceUser] without login;

create certificate [InitiatorServiceCertificate]

authorization [InitiatorServiceUser]

with subject = 'InitiatorService';

create service [InitiatorService]

authorization [InitiatorServiceUser]

on queue q;

-- when changing an existing 'dbo' owned service and certificate

create user [InitiatorServiceUser] without login;

alter authorization on certificate::[InitiatorServiceCertificate] to [InitiatorServiceUser];

alter authorization on service::[InitiatorService] to [InitiatorServiceUser];

HTH,
~ Remus

|||

Thanx Remus

This is also the section in Roger Wolter's book under dialog securoty that i did nto understand since i never did it and everything worked.

Does dbo automatically have any certificate cereated in the database, if not i dont really understand how it works without running this. But thanx for the answer i will do this in future Thanx

Diagram Pane Add/Remove Tables Problem

Hi,

I am doing the AdventureworksDW Analysis Services Tutorial.

I am a the following place.

Analysis Services Tutorials > SQL Server 2005 Analysis Services Tutorial > Lesson 5: Defining Relationships Between Dimensions and Measure Groups >

I am at the following spot.

Adding Tables and Defining the Sales Quotas Measure Group

To add tables and define the Sales Quotas measure group

Switch to Data Source View Designer for the Adventure Works DW data source view.

Right-click anywhere in the Diagram Organizer pane, click New Diagram, and then specify Sales Quotas as the name for the new diagram. For more information, see Working with Diagrams in a Data Source View (Analysis Services).

Drag the Employee, Sales Territory, and Time tables from the Tables pane to the Diagram pane.

Add the FactSalesQuota table to the Diagram pane by right-clicking anywhere in the Diagram pane and selecting Add/Remove Tables.

I can do 1, 2, and 3.

When I try to do four, I bring up the dialog. On the right side of the dialog I see INCLUDED OBJECTS.

I select (highlight/make blue) FactSalesQuota and press O.K.

Nothing happens. What else do I need to do?

The link just below shows a screenshot.

AddRemoveTableProblem

Thanks,

Andre Mikulec

AIM

AIMDBA

Andre_Mikulec@.Hotmail.com

FactSalesQuota is included in your diagram already, but it has been given the friendly name "SalesQuotas". In your picture you can see it in the background in the list of tables as the fourth table up from the bottom.|||

Thanks,

I have been working 18 hours per day on an alternate project for a month.

I am finally getting some time to get back to this tutorial.

Andre Mikulec

AIM

AIMDBA

Andre_Mikulec@.Hotmail.com

Diagram Pane Add/Remove Tables Problem

Hi,

I am doing the AdventureworksDW Analysis Services Tutorial.

I am a the following place.

Analysis Services Tutorials > SQL Server 2005 Analysis Services Tutorial > Lesson 5: Defining Relationships Between Dimensions and Measure Groups >

I am at the following spot.

Adding Tables and Defining the Sales Quotas Measure Group

To add tables and define the Sales Quotas measure group

Switch to Data Source View Designer for the Adventure Works DW data source view.

Right-click anywhere in the Diagram Organizer pane, click New Diagram, and then specify Sales Quotas as the name for the new diagram. For more information, see Working with Diagrams in a Data Source View (Analysis Services).

Drag the Employee, Sales Territory, and Time tables from the Tables pane to the Diagram pane.

Add the FactSalesQuota table to the Diagram pane by right-clicking anywhere in the Diagram pane and selecting Add/Remove Tables.

I can do 1, 2, and 3.

When I try to do four, I bring up the dialog. On the right side of the dialog I see INCLUDED OBJECTS.

I select (highlight/make blue) FactSalesQuota and press O.K.

Nothing happens. What else do I need to do?

The link just below shows a screenshot.

AddRemoveTableProblem

Thanks,

Andre Mikulec

AIM

AIMDBA

Andre_Mikulec@.Hotmail.com

FactSalesQuota is included in your diagram already, but it has been given the friendly name "SalesQuotas". In your picture you can see it in the background in the list of tables as the fourth table up from the bottom.|||

Thanks,

I have been working 18 hours per day on an alternate project for a month.

I am finally getting some time to get back to this tutorial.

Andre Mikulec

AIM

AIMDBA

Andre_Mikulec@.Hotmail.com

Development Tools

Are there any tools (other than Visual Studio.NET) that will allow me to
build SQL Reporting Services Reports? I just want to build some simple
reports and don't need (or want) to install the Visual Studio.NET.SQL Server 2005 will include a new tool called "Report Builder" that is
intended for end-users. It doesn't depend on VS.
--
Rajeev Karunakaran [MSFT]
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"John" <John@.discussions.microsoft.com> wrote in message
news:43A3C15E-9042-4204-BB90-CFA8A0BE86EA@.microsoft.com...
> Are there any tools (other than Visual Studio.NET) that will allow me to
> build SQL Reporting Services Reports? I just want to build some simple
> reports and don't need (or want) to install the Visual Studio.NET.

Development server vs Live server deployment

How do you guys handle this? I want to create and develop our reports on our
development report services server with its own SQL server 2005 server...
then later when they are tested and working deploy them to our live server
with a completly different instance of SQL Server 2005 (enterprise edition)
and have them run there on its report services server with its data source
as itself... how would you go about doing this? thanks! Also is there a way
to change the database and database server at runtime (say in a VB.NET
application?) thanks!Smokey,
Check this page :
http://msdn2.microsoft.com/en-us/library/ms160854.aspx
for "PublishSampleReports.rss"
This should answer your "how would you go about doing this" part of the
question...
Andrei.
"Smokey Grindle" <nospam@.dontspamme.com> wrote in message
news:%23fQIZjOOHHA.1248@.TK2MSFTNGP03.phx.gbl...
> How do you guys handle this? I want to create and develop our reports on
> our development report services server with its own SQL server 2005
> server... then later when they are tested and working deploy them to our
> live server with a completly different instance of SQL Server 2005
> (enterprise edition) and have them run there on its report services server
> with its data source as itself... how would you go about doing this?
> thanks! Also is there a way to change the database and database server at
> runtime (say in a VB.NET application?) thanks!
>|||any idea how you would change the dataset's database and database server at
runtime of a report?
"Andrei" <andrei.toma@.era-environmental.com> wrote in message
news:O4ukonOOHHA.2236@.TK2MSFTNGP02.phx.gbl...
> Smokey,
> Check this page :
> http://msdn2.microsoft.com/en-us/library/ms160854.aspx
> for "PublishSampleReports.rss"
> This should answer your "how would you go about doing this" part of the
> question...
> Andrei.
> "Smokey Grindle" <nospam@.dontspamme.com> wrote in message
> news:%23fQIZjOOHHA.1248@.TK2MSFTNGP03.phx.gbl...
>> How do you guys handle this? I want to create and develop our reports on
>> our development report services server with its own SQL server 2005
>> server... then later when they are tested and working deploy them to our
>> live server with a completly different instance of SQL Server 2005
>> (enterprise edition) and have them run there on its report services
>> server with its data source as itself... how would you go about doing
>> this? thanks! Also is there a way to change the database and database
>> server at runtime (say in a VB.NET application?) thanks!
>|||Are you supporting multiple databases with the same structure or is this
just going from development to production? If you use shared datasources
then you configure it once on each server and after that you are good to go.
The reports go against the shared datasource which defaults to not being
overwritten so when you deploy it is left alone.
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Smokey Grindle" <nospam@.dontspamme.com> wrote in message
news:eRK0myOOHHA.3212@.TK2MSFTNGP02.phx.gbl...
> any idea how you would change the dataset's database and database server
> at runtime of a report?
> "Andrei" <andrei.toma@.era-environmental.com> wrote in message
> news:O4ukonOOHHA.2236@.TK2MSFTNGP02.phx.gbl...
>> Smokey,
>> Check this page :
>> http://msdn2.microsoft.com/en-us/library/ms160854.aspx
>> for "PublishSampleReports.rss"
>> This should answer your "how would you go about doing this" part of the
>> question...
>> Andrei.
>> "Smokey Grindle" <nospam@.dontspamme.com> wrote in message
>> news:%23fQIZjOOHHA.1248@.TK2MSFTNGP03.phx.gbl...
>> How do you guys handle this? I want to create and develop our reports on
>> our development report services server with its own SQL server 2005
>> server... then later when they are tested and working deploy them to our
>> live server with a completly different instance of SQL Server 2005
>> (enterprise edition) and have them run there on its report services
>> server with its data source as itself... how would you go about doing
>> this? thanks! Also is there a way to change the database and database
>> server at runtime (say in a VB.NET application?) thanks!
>>
>|||multiple databases, We have this structure in our application...
Our Live server can have multiple databases with the same exact schema (we
have a Live system with real time data, and a testing system with weekly
data from the live system for testing out stuff) when we log into our
application you select the server and which database you are going to work
with... in crystal reports we manually changed the mappings in the report to
get it to work with the different databases on the server then ran the
report, just wondering how you can do something similar in reporting server.
90% of the time the reports are ran in the live system, but we still have to
support the other 10% and dont want to make copies of reports for each
database, because techincally, someone could make another database at any
point in time with the same schema
"Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
news:uiAgLBSOHHA.4848@.TK2MSFTNGP04.phx.gbl...
> Are you supporting multiple databases with the same structure or is this
> just going from development to production? If you use shared datasources
> then you configure it once on each server and after that you are good to
> go. The reports go against the shared datasource which defaults to not
> being overwritten so when you deploy it is left alone.
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Smokey Grindle" <nospam@.dontspamme.com> wrote in message
> news:eRK0myOOHHA.3212@.TK2MSFTNGP02.phx.gbl...
>> any idea how you would change the dataset's database and database server
>> at runtime of a report?
>> "Andrei" <andrei.toma@.era-environmental.com> wrote in message
>> news:O4ukonOOHHA.2236@.TK2MSFTNGP02.phx.gbl...
>> Smokey,
>> Check this page :
>> http://msdn2.microsoft.com/en-us/library/ms160854.aspx
>> for "PublishSampleReports.rss"
>> This should answer your "how would you go about doing this" part of the
>> question...
>> Andrei.
>> "Smokey Grindle" <nospam@.dontspamme.com> wrote in message
>> news:%23fQIZjOOHHA.1248@.TK2MSFTNGP03.phx.gbl...
>> How do you guys handle this? I want to create and develop our reports
>> on our development report services server with its own SQL server 2005
>> server... then later when they are tested and working deploy them to
>> our live server with a completly different instance of SQL Server 2005
>> (enterprise edition) and have them run there on its report services
>> server with its data source as itself... how would you go about doing
>> this? thanks! Also is there a way to change the database and database
>> server at runtime (say in a VB.NET application?) thanks!
>>
>>
>

Developing WAP using ASP.NET and Web Services

Hi all,

I would like to develop WAP using ASP.NET which can connect to the Database( MS SQL Server ). Is it possible to do it? I try to find the tutorial but I cannot find it.

Another thing I want to ask is can I connect the WAP to the web services that I create using ASP.NET, anyone can tell me how to do it.

Thanks, Regards.

REDWAP is something that is sent to and displayed on the client. ASP.NET and Web Services are server side technologies. You can certainly have your ASP.NET application call out to a Web service, and then send the results to your WAP device.

developing reports for Exchange 2003

Has anyone had experience with developing reports based off items in
Exchange 2003? Is it possible to use reporting services to connect to
Exchange to report on types of emails or does another type of connection
have to made? Any insight would be much appreciated. Thanks.
--
****************************************
Andy S.
andymcdba1@.NOMORESPAM.yahoo.com
Please remove NOMORESPAM before replying.
****************************************You might want to download the new "SQL Server 2000 Report Pack for
Microsoft Exchange":
http://www.microsoft.com/downloads/details.aspx?FamilyId=108C2B01-2CC9-4A84-A669-EB22533FA5E2&displaylang=en
It is a set of 13 Microsoft Exchange-based reports with a sample database
that lets you easily visualize and author managed reports for e-mail
administration.
--
Robert M. Bruckner
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Andy S." <andymcdba1@.NOMORESPAM.yahoo.com> wrote in message
news:eMSHKeipEHA.2764@.TK2MSFTNGP11.phx.gbl...
> Has anyone had experience with developing reports based off items in
> Exchange 2003? Is it possible to use reporting services to connect to
> Exchange to report on types of emails or does another type of connection
> have to made? Any insight would be much appreciated. Thanks.
> --
> ****************************************
> Andy S.
> andymcdba1@.NOMORESPAM.yahoo.com
> Please remove NOMORESPAM before replying.
> ****************************************
>
>|||Thanks, I saw that. However, if you notice, this SQL Server Report Pack is
for a 3rd party app developed by Super Software for their tool that exports
Exchange code.
What I really need to figure out is how to create a reporting service
connection to Exchange instead of having to figure out how to create a .NET
application that uses a CDO type connection. I keep seeing something about
an Exchange OLE DB Provider but no instructions on how to add it to the
available providers in reporting services or how to access the store in
Exchange with it.
"Robert Bruckner [MSFT]" <robruc@.online.microsoft.com> wrote in message
news:uPxFW2jpEHA.1992@.TK2MSFTNGP09.phx.gbl...
> You might want to download the new "SQL Server 2000 Report Pack for
> Microsoft Exchange":
>
http://www.microsoft.com/downloads/details.aspx?FamilyId=108C2B01-2CC9-4A84-A669-EB22533FA5E2&displaylang=en
> It is a set of 13 Microsoft Exchange-based reports with a sample database
> that lets you easily visualize and author managed reports for e-mail
> administration.
> --
> Robert M. Bruckner
> Microsoft SQL Server Reporting Services
> This posting is provided "AS IS" with no warranties, and confers no
rights.
> "Andy S." <andymcdba1@.NOMORESPAM.yahoo.com> wrote in message
> news:eMSHKeipEHA.2764@.TK2MSFTNGP11.phx.gbl...
> > Has anyone had experience with developing reports based off items in
> > Exchange 2003? Is it possible to use reporting services to connect to
> > Exchange to report on types of emails or does another type of connection
> > have to made? Any insight would be much appreciated. Thanks.
> >
> > --
> > ****************************************
> > Andy S.
> > andymcdba1@.NOMORESPAM.yahoo.com
> >
> > Please remove NOMORESPAM before replying.
> >
> > ****************************************
> >
> >
> >
> >
>|||The Exchange OLEDB provider only works on the Exchange Server itself so you
would have to run Reporting Services on your Exchange Server. Your other
option is to find a WebDAV OLEDB provider (I believe there are some freeware
ones) and you could use that as well from Reporting Services.
--
Looking for a good book on programming Exchange, Outlook, ADSI and
SharePoint? Check out http://www.microsoft.com/MSPress/books/5517.asp
"Andy S." <andymcdba1@.NOMORESPAM.yahoo.com> wrote in message
news:e%23d2CUmpEHA.1296@.TK2MSFTNGP12.phx.gbl...
> Thanks, I saw that. However, if you notice, this SQL Server Report Pack
> is
> for a 3rd party app developed by Super Software for their tool that
> exports
> Exchange code.
> What I really need to figure out is how to create a reporting service
> connection to Exchange instead of having to figure out how to create a
> .NET
> application that uses a CDO type connection. I keep seeing something
> about
> an Exchange OLE DB Provider but no instructions on how to add it to the
> available providers in reporting services or how to access the store in
> Exchange with it.
> "Robert Bruckner [MSFT]" <robruc@.online.microsoft.com> wrote in message
> news:uPxFW2jpEHA.1992@.TK2MSFTNGP09.phx.gbl...
>> You might want to download the new "SQL Server 2000 Report Pack for
>> Microsoft Exchange":
> http://www.microsoft.com/downloads/details.aspx?FamilyId=108C2B01-2CC9-4A84-A669-EB22533FA5E2&displaylang=en
>> It is a set of 13 Microsoft Exchange-based reports with a sample database
>> that lets you easily visualize and author managed reports for e-mail
>> administration.
>> --
>> Robert M. Bruckner
>> Microsoft SQL Server Reporting Services
>> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>> "Andy S." <andymcdba1@.NOMORESPAM.yahoo.com> wrote in message
>> news:eMSHKeipEHA.2764@.TK2MSFTNGP11.phx.gbl...
>> > Has anyone had experience with developing reports based off items in
>> > Exchange 2003? Is it possible to use reporting services to connect to
>> > Exchange to report on types of emails or does another type of
>> > connection
>> > have to made? Any insight would be much appreciated. Thanks.
>> >
>> > --
>> > ****************************************
>> > Andy S.
>> > andymcdba1@.NOMORESPAM.yahoo.com
>> >
>> > Please remove NOMORESPAM before replying.
>> >
>> > ****************************************
>> >
>> >
>> >
>> >
>>
>

Developing a report with Reporting Services in SQL Express

Hi,

I'm trying to use reporting services in teh VS2003 but the Option to I create the project does not appear, i've already installed SP3 and no success, any idea ?

Thanks

Which reporting service? I don't believe SQL 2000 Reporting Services is supported on MSDE. You should probably be asking this question in a Visual Studio forum rather than a SQL forum.

Mike

|||

Ok, then

Thanks... And do you Know if SQL 2005 Express has this service ?

Thanks

|||

Yes, SQL Express with Advanced Services includes Reporting Services. The tool to create reports, BIDS, is available in the SQL Express Toolkit. Both can be downloaded from http://msdn.microsoft.com/vstudio/express/sql/download.

Regards,

Mike Wachal
SQL Express team

|||

Nice....

Another thing, I have an application that is currently using MSDE, I use some stored procedures and functions.... Is it all compatible with SQL Express 2005 do I need to change anything in my application ?

Thanks

|||

Hi, question regarding developing a report using SQL Express with advanced/reporting services. I have all packages installed correctly (I think) but am unable to start the BI report developer tool because the Start menu shortcut for the business intelligence development studio points to an executable that is not there. It points to: "C:\Program Files\Microsoft Visual Studio 8\Common7\IDE\devenv.exe"

FYI, I am running Windows XP SP2 and do not have Visual Studio installed, although I do have Visual C# Express installed. There is a VCSExpress.exe in that directory, if that helps.

I can access the web based links for the reporting services manager at http://localhost/Reports$SQLExpress with no problems.

Any idea on how to use the report developer tool?

Thanks,

Todd

Developers on Other Machines (formerly: Problem installing SQL Server Reporting Services )

Bruce:
Sorry for the misposting.
I don't understand what you mean by "you haven't setup your roles for
the developers on other machines." Once a user role (developer or
otherwise) is set up on the server, shouldn't it be in effect no
matter where a user logs in from?
Jody
"Bruce Loehle-Conger (bruce_lcNOSPAM@.hotmail.com)" wrote:
> Your problem seems different. He was having a problem installing. Your
> problem seems to be accessing it. It looks to me like you haven't setup your
> roles for the developers on other machines.
Bruce L-C
>"JodyT" <datagal@.msn.com> wrote in message
>news:f9d864c3.0408111251.61c4d16f@.posting.google.com...
>> I'm having a similar problem...
>>
>> Enterprise and Developer set up on one server machine, Developer on
2
>> other desktops. If you access Report Manager from the Server
machine,
>> everything looks fine. But Report Manager accessed from the
>> non-server machines shows the top banner only... No tabs, no
folders,
>> nothing below the line, so a developer can't upload without
switching
>> over to the server, and even then there are often errors.
>>
>> Is there some configuration subtlety we missed?
>>
>> Otherwise this thing is giving me problems with OutOfMemory errors
on
>> local debugs that I know aren't too big.
>>
>> Ideas?
>> Jody
>>I suspect one of two things are happening. You have anonymous access on
which ends up treating everyone as the same regardless of how they are
logged in and they end up not having the permissions you wish them to have.
Or, the developers are either not assigned to a role, or are assigned to a
role that does not have the correct rights, or are assigned to a role with
the correct rights but that role has not been applied to the appropriate
part of the website. Unless you override it, any folder/report inherits the
role assignments from further up the tree. So if you assign the role from
above
My guess is when they are on the server they are not logged in as themselves
but are logged in as the admin for the local machine.
If they log into the server as themselves and the website does not look the
same as when they try to access it from their computers then my reasoning
falls apart.
So, check the the following.
1. Do you have anonymous access turned on?
2. What happens if you log into the server as one of the developers that are
having difficulties.
Bruce L-C
"JodyT" <datagal@.msn.com> wrote in message
news:f9d864c3.0408120929.8a3b6d7@.posting.google.com...
> Bruce:
> Sorry for the misposting.
> I don't understand what you mean by "you haven't setup your roles for
> the developers on other machines." Once a user role (developer or
> otherwise) is set up on the server, shouldn't it be in effect no
> matter where a user logs in from?
> Jody
> "Bruce Loehle-Conger (bruce_lcNOSPAM@.hotmail.com)" wrote:
> > Your problem seems different. He was having a problem installing. Your
> > problem seems to be accessing it. It looks to me like you haven't setup
your
> > roles for the developers on other machines.
> Bruce L-C
> >"JodyT" <datagal@.msn.com> wrote in message
> >news:f9d864c3.0408111251.61c4d16f@.posting.google.com...
> >> I'm having a similar problem...
> >>
> >> Enterprise and Developer set up on one server machine, Developer on
> 2
> >> other desktops. If you access Report Manager from the Server
> machine,
> >> everything looks fine. But Report Manager accessed from the
> >> non-server machines shows the top banner only... No tabs, no
> folders,
> >> nothing below the line, so a developer can't upload without
> switching
> >> over to the server, and even then there are often errors.
> >>
> >> Is there some configuration subtlety we missed?
> >>
> >> Otherwise this thing is giving me problems with OutOfMemory errors
> on
> >> local debugs that I know aren't too big.
> >>
> >> Ideas?
> >> Jody
> >>|||Actually I am the developer, with very minimal network learnin'. I
finally got the guy who installed to look at the research I've been
doing and he ended up reinstalling "paying closer attention to the
configuration options". He did have to do some monkeying around with
the anonymous thing, but he seems to have it working now. We'll see
how it goes if we ever put some actual users on it.
Thanks all for the input. It was a big help.
Jody
"Bruce Loehle-Conger" <bruce_lcNOSPAM@.hotmail.com> wrote in message news:<ur$lBPJgEHA.556@.tk2msftngp13.phx.gbl>...
> I suspect one of two things are happening. You have anonymous access on
> which ends up treating everyone as the same regardless of how they are
> logged in and they end up not having the permissions you wish them to have.
> Or, the developers are either not assigned to a role, or are assigned to a
> role that does not have the correct rights, or are assigned to a role with
> the correct rights but that role has not been applied to the appropriate
> part of the website. Unless you override it, any folder/report inherits the
> role assignments from further up the tree. So if you assign the role from
> above
> My guess is when they are on the server they are not logged in as themselves
> but are logged in as the admin for the local machine.
> If they log into the server as themselves and the website does not look the
> same as when they try to access it from their computers then my reasoning
> falls apart.
> So, check the the following.
> 1. Do you have anonymous access turned on?
> 2. What happens if you log into the server as one of the developers that are
> having difficulties.
> Bruce L-C
> "JodyT" <datagal@.msn.com> wrote in message
> news:f9d864c3.0408120929.8a3b6d7@.posting.google.com...
> > Bruce:
> >
> > Sorry for the misposting.
> >
> > I don't understand what you mean by "you haven't setup your roles for
> > the developers on other machines." Once a user role (developer or
> > otherwise) is set up on the server, shouldn't it be in effect no
> > matter where a user logs in from?
> >
> > Jody
> >
> > "Bruce Loehle-Conger (bruce_lcNOSPAM@.hotmail.com)" wrote:
> > > Your problem seems different. He was having a problem installing. Your
> > > problem seems to be accessing it. It looks to me like you haven't setup
> your
> > > roles for the developers on other machines.
> >
> > Bruce L-C
> >
> > >"JodyT" <datagal@.msn.com> wrote in message
> > >news:f9d864c3.0408111251.61c4d16f@.posting.google.com...
> > >> I'm having a similar problem...
> > >>
> > >> Enterprise and Developer set up on one server machine, Developer on
> 2
> > >> other desktops. If you access Report Manager from the Server
> machine,
> > >> everything looks fine. But Report Manager accessed from the
> > >> non-server machines shows the top banner only... No tabs, no
> folders,
> > >> nothing below the line, so a developer can't upload without
> switching
> > >> over to the server, and even then there are often errors.
> > >>
> > >> Is there some configuration subtlety we missed?
> > >>
> > >> Otherwise this thing is giving me problems with OutOfMemory errors
> on
> > >> local debugs that I know aren't too big.
> > >>
> > >> Ideas?
> > >> Jody
> > >>

Developers edition

Have developers edition of SQL Server - is there anywhere I can download
developers edition of reporting services ?Hi
Not downloadable unless you are a MSDN subscriber.
http://www.microsoft.com/sql/report...buy/default.asp
For media to be shipped to you:
http://www.microsoft.com/sql/report...fulfillment.asp
Regards
Mike
"Michael Vardinghus" wrote:

> Have developers edition of SQL Server - is there anywhere I can download
> developers edition of reporting services ?
>
>

Developers edition

Have developers edition of SQL Server - is there anywhere I can download
developers edition of reporting services ?
Hi
Not downloadable unless you are a MSDN subscriber.
http://www.microsoft.com/sql/reporti...uy/default.asp
For media to be shipped to you:
http://www.microsoft.com/sql/reporti...ulfillment.asp
Regards
Mike
"Michael Vardinghus" wrote:

> Have developers edition of SQL Server - is there anywhere I can download
> developers edition of reporting services ?
>
>

Developers edition

Have developers edition of SQL Server - is there anywhere I can download
developers edition of reporting services ?Hi
Not downloadable unless you are a MSDN subscriber.
http://www.microsoft.com/sql/reporting/howtobuy/default.asp
For media to be shipped to you:
http://www.microsoft.com/sql/reporting/howtobuy/retailfulfillment.asp
Regards
Mike
"Michael Vardinghus" wrote:
> Have developers edition of SQL Server - is there anywhere I can download
> developers edition of reporting services ?
>
>