Is this the right tool?

I think Service Broker is the right tool for what I want to do but need confirmation. Here is what I want to do.

Our company sells small business consulting services. When a client signs up with us, we put a server at their site that runs our app (using SQL Server 2005). Once the server is setup at their site and operational we constantly send certain information from that server to our central corporate server. There could be thousands of records every day being sent from each of these servers to our corporate server. We're using webservices now to transfer this data from each server but I'm afraid we're reaching a point where webservices will no longer work because of the volume of data.

1) I assume that Service Broker was created, in part at least, to address these types of situations?

2) If #1 is correct, is there any step by step examples/instruction that shows me how to use Service Broker to communicate between two SQL Server databases on two different servers?

Thanks very much.

Amos.

Yes, Service Broker is explicitly designed with these scenarios in mind. It provides a reliable loosely coupled infrastructure for the communication:
- message delivery is guaranteed to be Exactly Once In Order (no message duplicates, no messages out of order)
- the infrastructure can gracefully handle availability problems (lack of connectivity to the corporate server will be transparent to the operations site, applications will never notice it)
- durable, transactional semantics for message delivery (messages cannot be lost between sender and recipient, delivery correctness is guaranteed even in the event of a connection interrupt, application crash etc)
- message queuing for handling load spikes, service interrupts, operational upgrades etc
- loosely coupled, designed with separate administrative control between the conversing parties (sender/receiver can upgrade separately the service application, can have separate administrative and security control etc)
- integration of data and messages in the database, benefiting from the existing recoverability of the database (backup/restore), availability (failover clustering, database mirroring), programmability (T-SQL, ADO.Net), monitoring (integration with SQL Profiler), relational semantics (e.g. ability to run a SELECT over a queue to see the messages pending to be received) etc etc.

For examples and samples, I recommend you visit the team site at www.sqlservicebroker.com, read the articles mentioned on http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=516904&SiteID=1 and other articles about it that you can find. If you can get hold of Roger's book 'The rational guide to SQL Service Broker', it's a great read on the subject. The easiest way to set up communication between two machines is using the tool mentioned at http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=339850&SiteID=1

HTH,
~ Remus

Is this an up-to-date version of the service pack for SQL 7?

Hello,
I am trying to determine if of our SQL server is an up-to-date
version. It reports Microsoft SQL Server 7.00 - 7.00.1077 (Intel
X86). Can anyone advise? And if not, what should I load to keep it
up-to-date?
Regards.
HotjaxHI,
You are running on latest service pack for SQL Server 7.0. In addition,
you are running post service pack 4 hotfix build 1077 (build number for
service pack 4 is 7.00.1063)
Sincerely,
Yih-Yoon Lee [Microsoft]
Microsoft SQL Server Support
This posting is provided "AS IS" with no warranties, and confers no rights.
Subscribe to MSDN & use http://msdn.microsoft.com/newsgroups.sql

Is this a good scenario for a Service Broker application usage

Hi,

Please excuse me if I get some terms wrong - I am not a developer!!

I am working for a company who has a requirement to interface to a customer to query for work. The customer has an established Web Services that it uses for external interfacing, these services are passive at their end, in that it will be my clients who initiate all the communications using SOAP, receiving responses in XML.

There are, as I see it, seven conversations.

Receiving Datasets

1. Requests All new Jobs - This will be a post to a HTP with a list of job numbers sent back, These jobs will then need to be polled from the same webservice.

2. Job Changes - existing jobs that have changed definitions (costs etc..)- simular to above

3. Job Changes - Appointment Times

Sending Datasets

1. Completed Jobs - one at a time

2. Cancelled Jobs

3. Appointments (I believe this is responses to 1 and 3 above)

4. Subsequent Jobs - new work derived from initial Job.

I believe the sending datasets will be one way only (ie POST).

I have suggested using Service Broker for this application, with a custom App sitting inbetween ServiceBroker and the Web Service to deal with the HTTP POSTS and GETS, and communicating with the Service Broker, posting to queues and reading from them.

Is this viable?

Many Thaks

Lawrenso

We have found customers using Service Broker services to talk to webservices, a common scenario. If you build your apps as internally activated stored procedures (written using CLR), they will always run under the security context of the database engine service account and hence that principle will need access to the web from the machine on which the database engine is running. The other option is to use external applications (running as whatever user you want on whatever machine you choose) that connect to the database to RECEIVE messages from the queue and post requests to the web service. The second pattern does not have a built-in activation mechansim, but you could look at our External Activator sample (on GotDotNet codegallery and www.sqlservicebroker.com).

Rushi

Is this a bug?

i use AMO to connect MSAS2005. Seems everything is fine except i do like this:

I try to restart the Analysis Service, and then connect to the server. This will cause windows prompt msmdsrv.exe error or debug info sometimes. This comes with the Connect() methed, but the codes will continue running - that means the code doesn't throw exceptions and executed as usual. I tried to sleep the thread for a while(Like in code make 10 seconds sleeping) but cann't pass the test for every time. Coding as below:

ControlService("MSSQLServerOLAPService", ServicesAccess.ServiceAction.Restart) //using ServiceController class to restart the windows service
System.Threading.Thread.Sleep(10000); //Even sleep the process for 10 Seconds
Server server = new Server();
server.Connect("localhost");
... ...

bool ControlService(string strServiceName, ServiceAction action)
{
try
{
oService = new ServiceController(strServiceName);

if (action == ServiceAction.Stop || action == ServiceAction.Restart)
{
if (!oService.Status.Equals(System.ServiceProcess.ServiceControllerStatus.Stopped) && oService.CanStop)
{
oService.Stop();
oService.WaitForStatus(System.ServiceProcess.ServiceControllerStatus.Stopped);
}
}

if (action == ServiceAction.Start || action == ServiceAction.Restart)
{
if (!oService.Status.Equals(System.ServiceProcess.ServiceControllerStatus.Running))
{
oService.Start();
oService.WaitForStatus(System.ServiceProcess.ServiceControllerStatus.Running);
}
}
}
catch (Exception e)
{
throw e;
}
return true;
}

Sometimes you need more than 10 sec for Analysis Server to start.

As for the rest. It is hard to say what is going on. If you are able to restart Analysis Server using service control manager (SCM) and then connect to it from your AMO application that would mean your ServiceControl code is not functioning correctly.

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.

|||

yes, this is the problem i tried to describe.

we don't know if the analysis service is ready to connect even we get its "running" status from the codes. And if we connect it at this time, it will tell us it's crashed.

Is there reporting service in Sql2005 express?

Hi,
Is there reporting service in Sql2005 express?
No. Standard Edition and up.
Regards
Mike
"ad" wrote:

> Hi,
> Is there reporting service in Sql2005 express?
>
>
|||If I develop my web application with VS2005, and my Web Application used
Reporting Service.
Can I bundle reporting service in the install package to my customer?
"Mike Epprecht (SQL MVP)" <mike@.epprecht.net> glsD
:DC032C75-697C-4D43-9059-31DF1195833E@.microsoft.com...[vbcol=seagreen]
> No. Standard Edition and up.
> Regards
> Mike
> "ad" wrote:
|||reporting services is an add-on and anyone having a valid SQL Server license
can use it without ptoblems. And for the case of bundling, you might need to
bundle the reports alone. If the customer has a valid SQL Server then they
can install RS and deploy your solution.
HTH,
Vinod Kumar
MCSE, DBA, MCAD, MCSD
http://www.extremeexperts.com
Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp
"ad" <ad@.wfes.tcc.edu.tw> wrote in message
news:eq$L2rPPFHA.508@.TK2MSFTNGP12.phx.gbl...
> If I develop my web application with VS2005, and my Web Application used
> Reporting Service.
> Can I bundle reporting service in the install package to my customer?
>
> "Mike Epprecht (SQL MVP)" <mike@.epprecht.net> glsD
> :DC032C75-697C-4D43-9059-31DF1195833E@.microsoft.com...
>
|||But if my customer have only the express version my Sql 2005,
Can they install RS in they web site?
"Vinod Kumar" <vinodk_sct@.NO_SPAM_hotmail.com> glsD
:uw$o6sQPFHA.2356@.TK2MSFTNGP14.phx.gbl...
> reporting services is an add-on and anyone having a valid SQL Server
license
> can use it without ptoblems. And for the case of bundling, you might need
to[vbcol=seagreen]
> bundle the reports alone. If the customer has a valid SQL Server then they
> can install RS and deploy your solution.
> --
> HTH,
> Vinod Kumar
> MCSE, DBA, MCAD, MCSD
> http://www.extremeexperts.com
> Books Online for SQL Server SP3 at
> http://www.microsoft.com/sql/techinf...2000/books.asp
> "ad" <ad@.wfes.tcc.edu.tw> wrote in message
> news:eq$L2rPPFHA.508@.TK2MSFTNGP12.phx.gbl...
used
>
|||Hi
No, Express is not enough to have a valid RS license. If you are using RS,
you have to use Standard Edition or better.
Regards
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"ad" <ad@.wfes.tcc.edu.tw> wrote in message
news:uCRRiuTPFHA.3408@.TK2MSFTNGP14.phx.gbl...
> But if my customer have only the express version my Sql 2005,
> Can they install RS in they web site?
> "Vinod Kumar" <vinodk_sct@.NO_SPAM_hotmail.com> glsD
> :uw$o6sQPFHA.2356@.TK2MSFTNGP14.phx.gbl...
> license
> to
> used
>
|||In the article http://www.microsoft.com/sql/spotlig...dsqlserver.asp
it say Express Edition replaces MSDE and provides a new set of capabilities
such as XCopy deployment, a very easy to understand licensing model, a
graphical management tool, and also SQL Server Reporting Services controls
so you can quickly build reports off your Express Edition data. Express
Edition also gives partners the ability to embed a database into their
applications at no cost to the partner. The Express Edition is free and
completely redistributable.
Is it meaning we can use Express edition with reporting service?
"Mike Epprecht (SQL MVP)" <mike@.epprecht.net> glsD
:uTPpBGUPFHA.2132@.TK2MSFTNGP14.phx.gbl...[vbcol=seagreen]
> Hi
> No, Express is not enough to have a valid RS license. If you are using RS,
> you have to use Standard Edition or better.
> Regards
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
> IM: mike@.epprecht.net
> MVP Program: http://www.microsoft.com/mvp
> Blog: http://www.msmvps.com/epprecht/
> "ad" <ad@.wfes.tcc.edu.tw> wrote in message
> news:uCRRiuTPFHA.3408@.TK2MSFTNGP14.phx.gbl...
need
>
|||See also my previous answers to you on
microsoft.public.sqlserver.reportingsvcs.
You can use SQL Express as a data source for Reporting Services.
You, or your customers, will still need a copy of SQL Server Standard
or Enterprise to hold the metadata Catalog for Reporting Services.
The bottom line is that Reporting Services 2005 is "free" only to
those with a licensed copy of SQL Server 2005 Standard or Enterprise.
Andrew Watt
MVP - InfoPath
On Sun, 10 Apr 2005 14:20:55 +0800, "ad" <ad@.wfes.tcc.edu.tw> wrote:

>In the article http://www.microsoft.com/sql/spotlig...dsqlserver.asp
>it say Express Edition replaces MSDE and provides a new set of capabilities
>such as XCopy deployment, a very easy to understand licensing model, a
>graphical management tool, and also SQL Server Reporting Services controls
>so you can quickly build reports off your Express Edition data. Express
>Edition also gives partners the ability to embed a database into their
>applications at no cost to the partner. The Express Edition is free and
>completely redistributable.
>Is it meaning we can use Express edition with reporting service?
>
>"Mike Epprecht (SQL MVP)" <mike@.epprecht.net> glsD
>:uTPpBGUPFHA.2132@.TK2MSFTNGP14.phx.gbl...
>need
>

Is there reporting service in Sql2005 express?

Hi,
Is there reporting service in Sql2005 express?No. Standard Edition and up.
Regards
Mike
"ad" wrote:

> Hi,
> Is there reporting service in Sql2005 express?
>
>|||If I develop my web application with VS2005, and my Web Application used
Reporting Service.
Can I bundle reporting service in the install package to my customer?
"Mike Epprecht (SQL MVP)" <mike@.epprecht.net> glsD
:DC032C75-697C-4D43-9059-31DF1195833E@.microsoft.com...[vbcol=seagreen]
> No. Standard Edition and up.
> Regards
> Mike
> "ad" wrote:
>|||reporting services is an add-on and anyone having a valid SQL Server license
can use it without ptoblems. And for the case of bundling, you might need to
bundle the reports alone. If the customer has a valid SQL Server then they
can install RS and deploy your solution.
HTH,
Vinod Kumar
MCSE, DBA, MCAD, MCSD
http://www.extremeexperts.com
Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp
"ad" <ad@.wfes.tcc.edu.tw> wrote in message
news:eq$L2rPPFHA.508@.TK2MSFTNGP12.phx.gbl...
> If I develop my web application with VS2005, and my Web Application used
> Reporting Service.
> Can I bundle reporting service in the install package to my customer?
>
> "Mike Epprecht (SQL MVP)" <mike@.epprecht.net> glsD
> :DC032C75-697C-4D43-9059-31DF1195833E@.microsoft.com...
>|||But if my customer have only the express version my Sql 2005,
Can they install RS in they web site?
"Vinod Kumar" <vinodk_sct@.NO_SPAM_hotmail.com> glsD
:uw$o6sQPFHA.2356@.TK2MSFTNGP14.phx.gbl...
> reporting services is an add-on and anyone having a valid SQL Server
license
> can use it without ptoblems. And for the case of bundling, you might need
to
> bundle the reports alone. If the customer has a valid SQL Server then they
> can install RS and deploy your solution.
> --
> HTH,
> Vinod Kumar
> MCSE, DBA, MCAD, MCSD
> http://www.extremeexperts.com
> Books Online for SQL Server SP3 at
> http://www.microsoft.com/sql/techin.../2000/books.asp
> "ad" <ad@.wfes.tcc.edu.tw> wrote in message
> news:eq$L2rPPFHA.508@.TK2MSFTNGP12.phx.gbl...
used[vbcol=seagreen]
>|||Hi
No, Express is not enough to have a valid RS license. If you are using RS,
you have to use Standard Edition or better.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"ad" <ad@.wfes.tcc.edu.tw> wrote in message
news:uCRRiuTPFHA.3408@.TK2MSFTNGP14.phx.gbl...
> But if my customer have only the express version my Sql 2005,
> Can they install RS in they web site?
> "Vinod Kumar" <vinodk_sct@.NO_SPAM_hotmail.com> glsD
> :uw$o6sQPFHA.2356@.TK2MSFTNGP14.phx.gbl...
> license
> to
> used
>|||In the article http://www.microsoft.com/sql/spotli...ndsqlserver.asp
it say Express Edition replaces MSDE and provides a new set of capabilities
such as XCopy deployment, a very easy to understand licensing model, a
graphical management tool, and also SQL Server Reporting Services controls
so you can quickly build reports off your Express Edition data. Express
Edition also gives partners the ability to embed a database into their
applications at no cost to the partner. The Express Edition is free and
completely redistributable.
Is it meaning we can use Express edition with reporting service?
"Mike Epprecht (SQL MVP)" <mike@.epprecht.net> glsD
:uTPpBGUPFHA.2132@.TK2MSFTNGP14.phx.gbl...
> Hi
> No, Express is not enough to have a valid RS license. If you are using RS,
> you have to use Standard Edition or better.
> Regards
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
> IM: mike@.epprecht.net
> MVP Program: http://www.microsoft.com/mvp
> Blog: http://www.msmvps.com/epprecht/
> "ad" <ad@.wfes.tcc.edu.tw> wrote in message
> news:uCRRiuTPFHA.3408@.TK2MSFTNGP14.phx.gbl...
need[vbcol=seagreen]
>|||See also my previous answers to you on
microsoft.public.sqlserver.reportingsvcs.
You can use SQL Express as a data source for Reporting Services.
You, or your customers, will still need a copy of SQL Server Standard
or Enterprise to hold the metadata Catalog for Reporting Services.
The bottom line is that Reporting Services 2005 is "free" only to
those with a licensed copy of SQL Server 2005 Standard or Enterprise.
Andrew Watt
MVP - InfoPath
On Sun, 10 Apr 2005 14:20:55 +0800, "ad" <ad@.wfes.tcc.edu.tw> wrote:

>In the article http://www.microsoft.com/sql/spotli...ndsqlserver.asp
>it say Express Edition replaces MSDE and provides a new set of capabilities
>such as XCopy deployment, a very easy to understand licensing model, a
>graphical management tool, and also SQL Server Reporting Services controls
>so you can quickly build reports off your Express Edition data. Express
>Edition also gives partners the ability to embed a database into their
>applications at no cost to the partner. The Express Edition is free and
>completely redistributable.
>Is it meaning we can use Express edition with reporting service?
>
>"Mike Epprecht (SQL MVP)" <mike@.epprecht.net> glsD
>:uTPpBGUPFHA.2132@.TK2MSFTNGP14.phx.gbl...
>need
>

Is there reporting service in Sql2005 express?

Hi,
Is there reporting service in Sql2005 express?No. Standard Edition and up.
Regards
Mike
"ad" wrote:
> Hi,
> Is there reporting service in Sql2005 express?
>
>|||If I develop my web application with VS2005, and my Web Application used
Reporting Service.
Can I bundle reporting service in the install package to my customer?
"Mike Epprecht (SQL MVP)" <mike@.epprecht.net> ¼¶¼g©ó¶l¥ó·s»D
:DC032C75-697C-4D43-9059-31DF1195833E@.microsoft.com...
> No. Standard Edition and up.
> Regards
> Mike
> "ad" wrote:
> > Hi,
> > Is there reporting service in Sql2005 express?
> >
> >
> >|||reporting services is an add-on and anyone having a valid SQL Server license
can use it without ptoblems. And for the case of bundling, you might need to
bundle the reports alone. If the customer has a valid SQL Server then they
can install RS and deploy your solution.
--
HTH,
Vinod Kumar
MCSE, DBA, MCAD, MCSD
http://www.extremeexperts.com
Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp
"ad" <ad@.wfes.tcc.edu.tw> wrote in message
news:eq$L2rPPFHA.508@.TK2MSFTNGP12.phx.gbl...
> If I develop my web application with VS2005, and my Web Application used
> Reporting Service.
> Can I bundle reporting service in the install package to my customer?
>
> "Mike Epprecht (SQL MVP)" <mike@.epprecht.net> ¼¶¼g©ó¶l¥ó·s»D
> :DC032C75-697C-4D43-9059-31DF1195833E@.microsoft.com...
> > No. Standard Edition and up.
> >
> > Regards
> > Mike
> >
> > "ad" wrote:
> >
> > > Hi,
> > > Is there reporting service in Sql2005 express?
> > >
> > >
> > >
>|||But if my customer have only the express version my Sql 2005,
Can they install RS in they web site?
"Vinod Kumar" <vinodk_sct@.NO_SPAM_hotmail.com> ¼¶¼g©ó¶l¥ó·s»D
:uw$o6sQPFHA.2356@.TK2MSFTNGP14.phx.gbl...
> reporting services is an add-on and anyone having a valid SQL Server
license
> can use it without ptoblems. And for the case of bundling, you might need
to
> bundle the reports alone. If the customer has a valid SQL Server then they
> can install RS and deploy your solution.
> --
> HTH,
> Vinod Kumar
> MCSE, DBA, MCAD, MCSD
> http://www.extremeexperts.com
> Books Online for SQL Server SP3 at
> http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp
> "ad" <ad@.wfes.tcc.edu.tw> wrote in message
> news:eq$L2rPPFHA.508@.TK2MSFTNGP12.phx.gbl...
> > If I develop my web application with VS2005, and my Web Application
used
> > Reporting Service.
> >
> > Can I bundle reporting service in the install package to my customer?
> >
> >
> > "Mike Epprecht (SQL MVP)" <mike@.epprecht.net> ¼¶¼g©ó¶l¥ó·s»D
> > :DC032C75-697C-4D43-9059-31DF1195833E@.microsoft.com...
> > > No. Standard Edition and up.
> > >
> > > Regards
> > > Mike
> > >
> > > "ad" wrote:
> > >
> > > > Hi,
> > > > Is there reporting service in Sql2005 express?
> > > >
> > > >
> > > >
> >
> >
>|||Hi
No, Express is not enough to have a valid RS license. If you are using RS,
you have to use Standard Edition or better.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"ad" <ad@.wfes.tcc.edu.tw> wrote in message
news:uCRRiuTPFHA.3408@.TK2MSFTNGP14.phx.gbl...
> But if my customer have only the express version my Sql 2005,
> Can they install RS in they web site?
> "Vinod Kumar" <vinodk_sct@.NO_SPAM_hotmail.com> ¼¶¼g©ó¶l¥ó·s»D
> :uw$o6sQPFHA.2356@.TK2MSFTNGP14.phx.gbl...
>> reporting services is an add-on and anyone having a valid SQL Server
> license
>> can use it without ptoblems. And for the case of bundling, you might need
> to
>> bundle the reports alone. If the customer has a valid SQL Server then
>> they
>> can install RS and deploy your solution.
>> --
>> HTH,
>> Vinod Kumar
>> MCSE, DBA, MCAD, MCSD
>> http://www.extremeexperts.com
>> Books Online for SQL Server SP3 at
>> http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp
>> "ad" <ad@.wfes.tcc.edu.tw> wrote in message
>> news:eq$L2rPPFHA.508@.TK2MSFTNGP12.phx.gbl...
>> > If I develop my web application with VS2005, and my Web Application
> used
>> > Reporting Service.
>> >
>> > Can I bundle reporting service in the install package to my customer?
>> >
>> >
>> > "Mike Epprecht (SQL MVP)" <mike@.epprecht.net> ¼¶¼g©ó¶l¥ó·s»D
>> > :DC032C75-697C-4D43-9059-31DF1195833E@.microsoft.com...
>> > > No. Standard Edition and up.
>> > >
>> > > Regards
>> > > Mike
>> > >
>> > > "ad" wrote:
>> > >
>> > > > Hi,
>> > > > Is there reporting service in Sql2005 express?
>> > > >
>> > > >
>> > > >
>> >
>> >
>>
>|||In the article http://www.microsoft.com/sql/spotlight/expandsqlserver.asp
it say Express Edition replaces MSDE and provides a new set of capabilities
such as XCopy deployment, a very easy to understand licensing model, a
graphical management tool, and also SQL Server Reporting Services controls
so you can quickly build reports off your Express Edition data. Express
Edition also gives partners the ability to embed a database into their
applications at no cost to the partner. The Express Edition is free and
completely redistributable.
Is it meaning we can use Express edition with reporting service?
"Mike Epprecht (SQL MVP)" <mike@.epprecht.net> ¼¶¼g©ó¶l¥ó·s»D
:uTPpBGUPFHA.2132@.TK2MSFTNGP14.phx.gbl...
> Hi
> No, Express is not enough to have a valid RS license. If you are using RS,
> you have to use Standard Edition or better.
> Regards
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
> IM: mike@.epprecht.net
> MVP Program: http://www.microsoft.com/mvp
> Blog: http://www.msmvps.com/epprecht/
> "ad" <ad@.wfes.tcc.edu.tw> wrote in message
> news:uCRRiuTPFHA.3408@.TK2MSFTNGP14.phx.gbl...
> > But if my customer have only the express version my Sql 2005,
> > Can they install RS in they web site?
> > "Vinod Kumar" <vinodk_sct@.NO_SPAM_hotmail.com> ¼¶¼g©ó¶l¥ó·s»D
> > :uw$o6sQPFHA.2356@.TK2MSFTNGP14.phx.gbl...
> >> reporting services is an add-on and anyone having a valid SQL Server
> > license
> >> can use it without ptoblems. And for the case of bundling, you might
need
> > to
> >> bundle the reports alone. If the customer has a valid SQL Server then
> >> they
> >> can install RS and deploy your solution.
> >>
> >> --
> >> HTH,
> >> Vinod Kumar
> >> MCSE, DBA, MCAD, MCSD
> >> http://www.extremeexperts.com
> >>
> >> Books Online for SQL Server SP3 at
> >> http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp
> >>
> >> "ad" <ad@.wfes.tcc.edu.tw> wrote in message
> >> news:eq$L2rPPFHA.508@.TK2MSFTNGP12.phx.gbl...
> >> > If I develop my web application with VS2005, and my Web Application
> > used
> >> > Reporting Service.
> >> >
> >> > Can I bundle reporting service in the install package to my customer?
> >> >
> >> >
> >> > "Mike Epprecht (SQL MVP)" <mike@.epprecht.net> ¼¶¼g©ó¶l¥ó·s»D
> >> > :DC032C75-697C-4D43-9059-31DF1195833E@.microsoft.com...
> >> > > No. Standard Edition and up.
> >> > >
> >> > > Regards
> >> > > Mike
> >> > >
> >> > > "ad" wrote:
> >> > >
> >> > > > Hi,
> >> > > > Is there reporting service in Sql2005 express?
> >> > > >
> >> > > >
> >> > > >
> >> >
> >> >
> >>
> >>
> >
> >
>|||See also my previous answers to you on
microsoft.public.sqlserver.reportingsvcs.
You can use SQL Express as a data source for Reporting Services.
You, or your customers, will still need a copy of SQL Server Standard
or Enterprise to hold the metadata Catalog for Reporting Services.
The bottom line is that Reporting Services 2005 is "free" only to
those with a licensed copy of SQL Server 2005 Standard or Enterprise.
Andrew Watt
MVP - InfoPath
On Sun, 10 Apr 2005 14:20:55 +0800, "ad" <ad@.wfes.tcc.edu.tw> wrote:
>In the article http://www.microsoft.com/sql/spotlight/expandsqlserver.asp
>it say Express Edition replaces MSDE and provides a new set of capabilities
>such as XCopy deployment, a very easy to understand licensing model, a
>graphical management tool, and also SQL Server Reporting Services controls
>so you can quickly build reports off your Express Edition data. Express
>Edition also gives partners the ability to embed a database into their
>applications at no cost to the partner. The Express Edition is free and
>completely redistributable.
>Is it meaning we can use Express edition with reporting service?
>
>"Mike Epprecht (SQL MVP)" <mike@.epprecht.net> ¼¶¼g©ó¶l¥ó·s»D
>:uTPpBGUPFHA.2132@.TK2MSFTNGP14.phx.gbl...
>> Hi
>> No, Express is not enough to have a valid RS license. If you are using RS,
>> you have to use Standard Edition or better.
>> Regards
>> --
>> Mike Epprecht, Microsoft SQL Server MVP
>> Zurich, Switzerland
>> IM: mike@.epprecht.net
>> MVP Program: http://www.microsoft.com/mvp
>> Blog: http://www.msmvps.com/epprecht/
>> "ad" <ad@.wfes.tcc.edu.tw> wrote in message
>> news:uCRRiuTPFHA.3408@.TK2MSFTNGP14.phx.gbl...
>> > But if my customer have only the express version my Sql 2005,
>> > Can they install RS in they web site?
>> > "Vinod Kumar" <vinodk_sct@.NO_SPAM_hotmail.com> ¼¶¼g©ó¶l¥ó·s»D
>> > :uw$o6sQPFHA.2356@.TK2MSFTNGP14.phx.gbl...
>> >> reporting services is an add-on and anyone having a valid SQL Server
>> > license
>> >> can use it without ptoblems. And for the case of bundling, you might
>need
>> > to
>> >> bundle the reports alone. If the customer has a valid SQL Server then
>> >> they
>> >> can install RS and deploy your solution.
>> >>
>> >> --
>> >> HTH,
>> >> Vinod Kumar
>> >> MCSE, DBA, MCAD, MCSD
>> >> http://www.extremeexperts.com
>> >>
>> >> Books Online for SQL Server SP3 at
>> >> http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp
>> >>
>> >> "ad" <ad@.wfes.tcc.edu.tw> wrote in message
>> >> news:eq$L2rPPFHA.508@.TK2MSFTNGP12.phx.gbl...
>> >> > If I develop my web application with VS2005, and my Web Application
>> > used
>> >> > Reporting Service.
>> >> >
>> >> > Can I bundle reporting service in the install package to my customer?
>> >> >
>> >> >
>> >> > "Mike Epprecht (SQL MVP)" <mike@.epprecht.net> ¼¶¼g©ó¶l¥ó·s»D
>> >> > :DC032C75-697C-4D43-9059-31DF1195833E@.microsoft.com...
>> >> > > No. Standard Edition and up.
>> >> > >
>> >> > > Regards
>> >> > > Mike
>> >> > >
>> >> > > "ad" wrote:
>> >> > >
>> >> > > > Hi,
>> >> > > > Is there reporting service in Sql2005 express?
>> >> > > >
>> >> > > >
>> >> > > >
>> >> >
>> >> >
>> >>
>> >>
>> >
>> >
>>
>

Is there reporting service in Sql2005 express?

Dear Sir,
Is there reporting service in Sql2005 express?On Sat, 9 Apr 2005 18:05:48 +0800, "ad" <ad@.wfes.tcc.edu.tw> wrote:
>Dear Sir,
>Is there reporting service in Sql2005 express?
>
Hi,
I answered your question on
microsoft.private.sqlserver2005.reportingsvcs.
The answer is "No".
Andrew Watt
MVP - InfoPath|||But
In the article http://www.microsoft.com/sql/spotlight/expandsqlserver.asp
It say that there is SQL Server Reporting Services controls in Express
Edition.
"Andrew Watt [MVP - InfoPath]" <SVGDeveloper@.aol.com>
'?:9meg51td7sf0ni35islj8nb0ob2al098i2@.4ax.com...
> On Sat, 9 Apr 2005 18:05:48 +0800, "ad" <ad@.wfes.tcc.edu.tw> wrote:
> >Dear Sir,
> >Is there reporting service in Sql2005 express?
> >
> Hi,
> I answered your question on
> microsoft.private.sqlserver2005.reportingsvcs.
> The answer is "No".
> Andrew Watt
> MVP - InfoPath|||Hi,
Your question was whether there was a reporting service in SQL Server
2005 Express. The answer I gave you is correct.
I can see the graphic you are referring to and it does mention
reporting services controls. The controls referred to are found in
Visual Studio (see, for example, "Create Reports Faster" on
http://www.microsoft.com/sql/express/).
The wizard and controls coming from Visual Studio is also made clear
in http://www.microsoft.com/sql/2005/productinfo/sql2005features.asp.
I hope that helps.
Andrew Watt
MVP - InfoPath
On Sun, 10 Apr 2005 14:14:18 +0800, "ad" <ad@.wfes.tcc.edu.tw> wrote:
>But
>In the article http://www.microsoft.com/sql/spotlight/expandsqlserver.asp
>It say that there is SQL Server Reporting Services controls in Express
>Edition.
>
>
>"Andrew Watt [MVP - InfoPath]" <SVGDeveloper@.aol.com>
>'?:9meg51td7sf0ni35islj8nb0ob2al098i2@.4ax.com...
>> On Sat, 9 Apr 2005 18:05:48 +0800, "ad" <ad@.wfes.tcc.edu.tw> wrote:
>> >Dear Sir,
>> >Is there reporting service in Sql2005 express?
>> >
>> Hi,
>> I answered your question on
>> microsoft.private.sqlserver2005.reportingsvcs.
>> The answer is "No".
>> Andrew Watt
>> MVP - InfoPath
>|||Thank,
But I still a little confuse.
Dose it mean that if I use VS 2005, I can use report controls with Sql 2005
express?
"Andrew Watt [MVP - InfoPath]" <SVGDeveloper@.aol.com>
'?:tfkh515gh1lujll3ovacs7b1blhnp0egs5@.4ax.com...
> Hi,
> Your question was whether there was a reporting service in SQL Server
> 2005 Express. The answer I gave you is correct.
> I can see the graphic you are referring to and it does mention
> reporting services controls. The controls referred to are found in
> Visual Studio (see, for example, "Create Reports Faster" on
> http://www.microsoft.com/sql/express/).
> The wizard and controls coming from Visual Studio is also made clear
> in http://www.microsoft.com/sql/2005/productinfo/sql2005features.asp.
> I hope that helps.
> Andrew Watt
> MVP - InfoPath
> On Sun, 10 Apr 2005 14:14:18 +0800, "ad" <ad@.wfes.tcc.edu.tw> wrote:
> >But
> >
> >In the article http://www.microsoft.com/sql/spotlight/expandsqlserver.asp
> >
> >It say that there is SQL Server Reporting Services controls in Express
> >Edition.
> >
> >
> >
> >
> >
> >"Andrew Watt [MVP - InfoPath]" <SVGDeveloper@.aol.com>
> >'?:9meg51td7sf0ni35islj8nb0ob2al098i2@.4ax.com...
> >> On Sat, 9 Apr 2005 18:05:48 +0800, "ad" <ad@.wfes.tcc.edu.tw> wrote:
> >>
> >> >Dear Sir,
> >> >Is there reporting service in Sql2005 express?
> >> >
> >> Hi,
> >>
> >> I answered your question on
> >> microsoft.private.sqlserver2005.reportingsvcs.
> >>
> >> The answer is "No".
> >>
> >> Andrew Watt
> >> MVP - InfoPath
> >
>|||The new report controls (should be available with Beta 2 of Widbey (VS
2005)) can work both with and without Reporting Services Server. What this
means is that you can create a report and show it in your asp.net web page
or with a winform control without any server piece. If Reporting Services
Server is there it will use it.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"ad" <ad@.wfes.tcc.edu.tw> wrote in message
news:%23tTcTNbPFHA.1392@.TK2MSFTNGP10.phx.gbl...
> Thank,
> But I still a little confuse.
> Dose it mean that if I use VS 2005, I can use report controls with Sql
> 2005
> express?
> "Andrew Watt [MVP - InfoPath]" <SVGDeveloper@.aol.com>
> '?:tfkh515gh1lujll3ovacs7b1blhnp0egs5@.4ax.com...
>> Hi,
>> Your question was whether there was a reporting service in SQL Server
>> 2005 Express. The answer I gave you is correct.
>> I can see the graphic you are referring to and it does mention
>> reporting services controls. The controls referred to are found in
>> Visual Studio (see, for example, "Create Reports Faster" on
>> http://www.microsoft.com/sql/express/).
>> The wizard and controls coming from Visual Studio is also made clear
>> in http://www.microsoft.com/sql/2005/productinfo/sql2005features.asp.
>> I hope that helps.
>> Andrew Watt
>> MVP - InfoPath
>> On Sun, 10 Apr 2005 14:14:18 +0800, "ad" <ad@.wfes.tcc.edu.tw> wrote:
>> >But
>> >
>> >In the article
>> >http://www.microsoft.com/sql/spotlight/expandsqlserver.asp
>> >
>> >It say that there is SQL Server Reporting Services controls in Express
>> >Edition.
>> >
>> >
>> >
>> >
>> >
>> >"Andrew Watt [MVP - InfoPath]" <SVGDeveloper@.aol.com>
>> >'?:9meg51td7sf0ni35islj8nb0ob2al098i2@.4ax.com...
>> >> On Sat, 9 Apr 2005 18:05:48 +0800, "ad" <ad@.wfes.tcc.edu.tw> wrote:
>> >>
>> >> >Dear Sir,
>> >> >Is there reporting service in Sql2005 express?
>> >> >
>> >> Hi,
>> >>
>> >> I answered your question on
>> >> microsoft.private.sqlserver2005.reportingsvcs.
>> >>
>> >> The answer is "No".
>> >>
>> >> Andrew Watt
>> >> MVP - InfoPath
>> >
>

Is there any way to track LOGIN ID which stops the SQL Service?

Hello All,

I am running SQL Server 2000 Standard Edition on Windows 2000 Server... I believe Windows 2000 does not have an audit enabled by default like the one in Windows 2003 servers to capture the login ID's that is stopping the SQL Server...

I am getting N/A in user column in SQL Service Stop Event in Application Log... We need to track this event badly.. Is there any way to do this? Your Help on this is highly appreciated...

--Rajesh

What about

http://techrepublic.com.com/5208-11184-0.html?forumID=39&threadID=170891

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de

Is there any requirement to install the client component of RS?

Hi all,
I only install the client component of reporting service,
at the beginning, when it is install the support file, it
always failed with only an 'error' message. No other
messages.
I check the log file. There is
Internet Information Services 5.0 (IIS) or later is either
not installed, or it is configured in a way that is
incompatible with a Reporting Services installation.
ASP.NET version 1.1 is not installed or is not registered
with your Web server. ASP.Net is required for the Report
Server and the Report Manager components.
and in the stlog file, I notice
<Prerequisite Name="IsIISInstalled" Checked="Metabase"
Item="/" Found="Can not open metabase" Expected="No error"
Result="Fail" />
To only install the client component, should I install IIS
and ASP1.1 and how do I check that every thing is OK to
install it.
Thanks.
Lindayou need Visual studio.Net 2003 and .Net framework 1.1
IIS is not required
"YUKON2005" <anonymous@.discussions.microsoft.com> a écrit dans le message de
news:38d201c471e9$c199d760$a501280a@.phx.gbl...
> Hi all,
> I only install the client component of reporting service,
> at the beginning, when it is install the support file, it
> always failed with only an 'error' message. No other
> messages.
> I check the log file. There is
> Internet Information Services 5.0 (IIS) or later is either
> not installed, or it is configured in a way that is
> incompatible with a Reporting Services installation.
> ASP.NET version 1.1 is not installed or is not registered
> with your Web server. ASP.Net is required for the Report
> Server and the Report Manager components.
> and in the stlog file, I notice
> <Prerequisite Name="IsIISInstalled" Checked="Metabase"
> Item="/" Found="Can not open metabase" Expected="No error"
> Result="Fail" />
> To only install the client component, should I install IIS
> and ASP1.1 and how do I check that every thing is OK to
> install it.
> Thanks.
> Linda
>|||Thank you!
I will check it.
:)

Is there any known issue with Service Broker on Vista

When I run the ServiceBroker Hello, World sample on SQL Server Standard SP2
or SQL Server Express on Vista, I observe that no message is ever entered in
any queue. When I run the same sample on Windows Server 2008 Enterprise, the
sample behaves as it should.
So, is there any known issue with Service Broker on Vista, or does Service
Broker have some dependency on services or O/S settings that I have missed.
Answering my own question:
Vista proved not to be the significant variable in the problem. The
troubleshooting documentation led me to this query:
select * from sys.transmission_queue
... which yielded this result:
An exception occurred while enqueueing a message in the target queue. Error:
15517, State: 1. Cannot execute as the database principal because the
principal "dbo" does not exist, this type of principal cannot be
impersonated, or you do not have permission.
... which is an error fixed by executing:
EXEC sp_changedbowner 'sa'
"Craig McMurtry" wrote:

> When I run the ServiceBroker Hello, World sample on SQL Server Standard SP2
> or SQL Server Express on Vista, I observe that no message is ever entered in
> any queue. When I run the same sample on Windows Server 2008 Enterprise, the
> sample behaves as it should.
> So, is there any known issue with Service Broker on Vista, or does Service
> Broker have some dependency on services or O/S settings that I have missed.

Is there any known issue with Service Broker on Vista

When I run the ServiceBroker Hello, World sample on SQL Server Standard SP2
or SQL Server Express on Vista, I observe that no message is ever entered in
any queue. When I run the same sample on Windows Server 2008 Enterprise, the
sample behaves as it should.
So, is there any known issue with Service Broker on Vista, or does Service
Broker have some dependency on services or O/S settings that I have missed.Answering my own question:
Vista proved not to be the significant variable in the problem. The
troubleshooting documentation led me to this query:
select * from sys.transmission_queue
... which yielded this result:
An exception occurred while enqueueing a message in the target queue. Error:
15517, State: 1. Cannot execute as the database principal because the
principal "dbo" does not exist, this type of principal cannot be
impersonated, or you do not have permission.
... which is an error fixed by executing:
EXEC sp_changedbowner 'sa'
"Craig McMurtry" wrote:
> When I run the ServiceBroker Hello, World sample on SQL Server Standard SP2
> or SQL Server Express on Vista, I observe that no message is ever entered in
> any queue. When I run the same sample on Windows Server 2008 Enterprise, the
> sample behaves as it should.
> So, is there any known issue with Service Broker on Vista, or does Service
> Broker have some dependency on services or O/S settings that I have missed.