Hi,
we are making an interesting use of report services...we are actually
using it to generate programming specification for Informatica Mappings
from our mapping spreadsheets..LOL!!
Anyway, we have a couple of hundre mapping specifications and we want
to generate the couple of hundred PDFs associated with those
mappings...I recall reading in my hitchhikers guide how to do this but
that book is about 1,500 miles away from me at the moment.
Would anyone be kind enough to please share the command I need to enter
at the command line to run a report with specific parameters and spit
the output into a specific PDF file also specified as a parameter. I'd
be ever so grateful to not have to wait a few days to go home and read
my book!!
Thanks
Peter
www.peternolan.comHi All,
I got somewhere on this.....if I export and save I get this on the
address line of the browser...
http://ger-eutst/ReportServer?%2fIDW+Reports%2fMetadata%2fMIN0102A+-+Infa+Mappings+Detailed+Documentation&spreadsheet_name=StagingToODSMappingOAP&spreadsheet_version=V00.14&mapping_name=m_ODS_MTL_DEMAND&rs%3aCommand=Render&rs%3AFormat=PDF
So, surely there is some way to enter some kind of similar command via
a command line or via an vb.net program to capture a list of such
pdsf....
Anybody done this before?
Thanks
Peter
www.peternolan.com
Showing posts with label services. Show all posts
Showing posts with label services. Show all posts
Friday, March 30, 2012
running AS 2000 and AS 2005 on same hardware...
Is it possible to run analysis services 2000 and analysis services 2005
on the same computer?
I'm looking to migrate, but need to run production in both environments
concurrently until we're ready...eric.schleicher@.gmail.com wrote:
> Is it possible to run analysis services 2000 and analysis services 2005
> on the same computer?
> I'm looking to migrate, but need to run production in both environments
> concurrently until we're ready...
>
not tried it myself, but I believe not|||I found that you can run them concurrently, one just has to install the
AS2005 as a named instance (as AS2000 does not support "non default"
instances)
on the same computer?
I'm looking to migrate, but need to run production in both environments
concurrently until we're ready...eric.schleicher@.gmail.com wrote:
> Is it possible to run analysis services 2000 and analysis services 2005
> on the same computer?
> I'm looking to migrate, but need to run production in both environments
> concurrently until we're ready...
>
not tried it myself, but I believe not|||I found that you can run them concurrently, one just has to install the
AS2005 as a named instance (as AS2000 does not support "non default"
instances)
running AS 2000 and AS 2005 on same hardware...
Is it possible to run analysis services 2000 and analysis services 2005
on the same computer?
I'm looking to migrate, but need to run production in both environments
concurrently until we're ready...
eric.schleicher@.gmail.com wrote:
> Is it possible to run analysis services 2000 and analysis services 2005
> on the same computer?
> I'm looking to migrate, but need to run production in both environments
> concurrently until we're ready...
>
not tried it myself, but I believe not
|||I found that you can run them concurrently, one just has to install the
AS2005 as a named instance (as AS2000 does not support "non default"
instances)
on the same computer?
I'm looking to migrate, but need to run production in both environments
concurrently until we're ready...
eric.schleicher@.gmail.com wrote:
> Is it possible to run analysis services 2000 and analysis services 2005
> on the same computer?
> I'm looking to migrate, but need to run production in both environments
> concurrently until we're ready...
>
not tried it myself, but I believe not
|||I found that you can run them concurrently, one just has to install the
AS2005 as a named instance (as AS2000 does not support "non default"
instances)
running AS 2000 and AS 2005 on same hardware...
Is it possible to run analysis services 2000 and analysis services 2005
on the same computer?
I'm looking to migrate, but need to run production in both environments
concurrently until we're ready...eric.schleicher@.gmail.com wrote:
> Is it possible to run analysis services 2000 and analysis services 2005
> on the same computer?
> I'm looking to migrate, but need to run production in both environments
> concurrently until we're ready...
>
not tried it myself, but I believe not|||I found that you can run them concurrently, one just has to install the
AS2005 as a named instance (as AS2000 does not support "non default"
instances)sql
on the same computer?
I'm looking to migrate, but need to run production in both environments
concurrently until we're ready...eric.schleicher@.gmail.com wrote:
> Is it possible to run analysis services 2000 and analysis services 2005
> on the same computer?
> I'm looking to migrate, but need to run production in both environments
> concurrently until we're ready...
>
not tried it myself, but I believe not|||I found that you can run them concurrently, one just has to install the
AS2005 as a named instance (as AS2000 does not support "non default"
instances)sql
running and exporting report through code (C#)
Hello ,All
I am new to the reporting services and my question maybe stupid .
I created some report and published it on the server.
Now my question is : does it possible at all to run this report from my
client (in C# )and to export the result to CSV format also from client
Is there any web service that I can use which is calling for my report ?
Please ,help me to understand this .
Thanks a lot.
SmugliyYes, Reporting Services provide a set of Web Services API that you can call
to generate report. Form your client app project (Win Form App), set web
reference to the reporting services and look into its Render() methods. You
can also learn more aboubt this from SQL Server2005 Book on Line.
"Smugliy" <Smugliy@.discussions.microsoft.com> wrote in message
news:184E2D63-E618-4C35-A0C5-5F3A647B3803@.microsoft.com...
> Hello ,All
> I am new to the reporting services and my question maybe stupid .
> I created some report and published it on the server.
> Now my question is : does it possible at all to run this report from my
> client (in C# )and to export the result to CSV format also from client
> Is there any web service that I can use which is calling for my report
> ?
> Please ,help me to understand this .
> Thanks a lot.
> Smugliy
>
>|||Thanks a lot ,Norman
"Norman Yuan" wrote:
> Yes, Reporting Services provide a set of Web Services API that you can call
> to generate report. Form your client app project (Win Form App), set web
> reference to the reporting services and look into its Render() methods. You
> can also learn more aboubt this from SQL Server2005 Book on Line.
>
> "Smugliy" <Smugliy@.discussions.microsoft.com> wrote in message
> news:184E2D63-E618-4C35-A0C5-5F3A647B3803@.microsoft.com...
> > Hello ,All
> > I am new to the reporting services and my question maybe stupid .
> >
> > I created some report and published it on the server.
> > Now my question is : does it possible at all to run this report from my
> > client (in C# )and to export the result to CSV format also from client
> > Is there any web service that I can use which is calling for my report
> > ?
> > Please ,help me to understand this .
> > Thanks a lot.
> > Smugliy
> >
> >
> >
>|||Your other option is URL integration. It too will work. It allows you to
pick the rendering format. One point with either URL or web services. By
default CSV is in unicode format, if you don't want this then you can also
tell Reporting Services that you want it in ASCII format.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Smugliy" <Smugliy@.discussions.microsoft.com> wrote in message
news:184E2D63-E618-4C35-A0C5-5F3A647B3803@.microsoft.com...
> Hello ,All
> I am new to the reporting services and my question maybe stupid .
> I created some report and published it on the server.
> Now my question is : does it possible at all to run this report from my
> client (in C# )and to export the result to CSV format also from client
> Is there any web service that I can use which is calling for my report
> ?
> Please ,help me to understand this .
> Thanks a lot.
> Smugliy
>
>sql
I am new to the reporting services and my question maybe stupid .
I created some report and published it on the server.
Now my question is : does it possible at all to run this report from my
client (in C# )and to export the result to CSV format also from client
Is there any web service that I can use which is calling for my report ?
Please ,help me to understand this .
Thanks a lot.
SmugliyYes, Reporting Services provide a set of Web Services API that you can call
to generate report. Form your client app project (Win Form App), set web
reference to the reporting services and look into its Render() methods. You
can also learn more aboubt this from SQL Server2005 Book on Line.
"Smugliy" <Smugliy@.discussions.microsoft.com> wrote in message
news:184E2D63-E618-4C35-A0C5-5F3A647B3803@.microsoft.com...
> Hello ,All
> I am new to the reporting services and my question maybe stupid .
> I created some report and published it on the server.
> Now my question is : does it possible at all to run this report from my
> client (in C# )and to export the result to CSV format also from client
> Is there any web service that I can use which is calling for my report
> ?
> Please ,help me to understand this .
> Thanks a lot.
> Smugliy
>
>|||Thanks a lot ,Norman
"Norman Yuan" wrote:
> Yes, Reporting Services provide a set of Web Services API that you can call
> to generate report. Form your client app project (Win Form App), set web
> reference to the reporting services and look into its Render() methods. You
> can also learn more aboubt this from SQL Server2005 Book on Line.
>
> "Smugliy" <Smugliy@.discussions.microsoft.com> wrote in message
> news:184E2D63-E618-4C35-A0C5-5F3A647B3803@.microsoft.com...
> > Hello ,All
> > I am new to the reporting services and my question maybe stupid .
> >
> > I created some report and published it on the server.
> > Now my question is : does it possible at all to run this report from my
> > client (in C# )and to export the result to CSV format also from client
> > Is there any web service that I can use which is calling for my report
> > ?
> > Please ,help me to understand this .
> > Thanks a lot.
> > Smugliy
> >
> >
> >
>|||Your other option is URL integration. It too will work. It allows you to
pick the rendering format. One point with either URL or web services. By
default CSV is in unicode format, if you don't want this then you can also
tell Reporting Services that you want it in ASCII format.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Smugliy" <Smugliy@.discussions.microsoft.com> wrote in message
news:184E2D63-E618-4C35-A0C5-5F3A647B3803@.microsoft.com...
> Hello ,All
> I am new to the reporting services and my question maybe stupid .
> I created some report and published it on the server.
> Now my question is : does it possible at all to run this report from my
> client (in C# )and to export the result to CSV format also from client
> Is there any web service that I can use which is calling for my report
> ?
> Please ,help me to understand this .
> Thanks a lot.
> Smugliy
>
>sql
Running Analysis Services 2005 on a separate sever
My first question is can I run Analysis Services 2005 on a different server to where the databases are running
If yes, any pointers to some articles.
Hi justSomeone,
You can create an empty Analysis Services database within an instance of Analysis Services, by using either SQL Server Management Studio or Business Intelligence Development Studio, and then connect directly to that database using Business Intelligence Development Studio and create objects within it (rather than within a project). When working with an Analysis Services database in this manner, changes made to objects take effect in the database to which you are connecting when the changed object is saved.
You may find this article is useful to you:http://msdn2.microsoft.com/en-us/library/ms174953.aspx
Also, this one:http://msdn2.microsoft.com/en-us/library/ms174953.aspx gives you a step-by-step guidline on how to configure datasource in Microsoft SQL Server 2005 Analysis Services (SSAS).
Hope my suggestion helps
running an exe file SQL server agent
Hi ,
I have an exe program that i do not want to be part of
the services however , i do want it to auto-start when the
server is rebooted.
it is possble to configure it as part of SQL server
Agent job ?
thks & rdgs
maxzism,
Whilst it is possible, it may not necessarily be desirable. What exactly
are you trying to do? Using the Startup folder in windows, or using the
'at' command, or some other software may be a better option.
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
maxzsim wrote:
> Hi ,
>
> I have an exe program that i do not want to be part of
> the services however , i do want it to auto-start when the
> server is rebooted.
> it is possble to configure it as part of SQL server
> Agent job ?
>
> thks & rdgs
I have an exe program that i do not want to be part of
the services however , i do want it to auto-start when the
server is rebooted.
it is possble to configure it as part of SQL server
Agent job ?
thks & rdgs
maxzism,
Whilst it is possible, it may not necessarily be desirable. What exactly
are you trying to do? Using the Startup folder in windows, or using the
'at' command, or some other software may be a better option.
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
maxzsim wrote:
> Hi ,
>
> I have an exe program that i do not want to be part of
> the services however , i do want it to auto-start when the
> server is rebooted.
> it is possble to configure it as part of SQL server
> Agent job ?
>
> thks & rdgs
running an exe file SQL server agent
Hi ,
I have an exe program that i do not want to be part of
the services however , i do want it to auto-start when the
server is rebooted.
it is possble to configure it as part of SQL server
Agent job ?
thks & rdgsmaxzism,
Whilst it is possible, it may not necessarily be desirable. What exactly
are you trying to do? Using the Startup folder in windows, or using the
'at' command, or some other software may be a better option.
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
maxzsim wrote:
> Hi ,
>
> I have an exe program that i do not want to be part of
> the services however , i do want it to auto-start when the
> server is rebooted.
> it is possble to configure it as part of SQL server
> Agent job ?
>
> thks & rdgs
I have an exe program that i do not want to be part of
the services however , i do want it to auto-start when the
server is rebooted.
it is possble to configure it as part of SQL server
Agent job ?
thks & rdgsmaxzism,
Whilst it is possible, it may not necessarily be desirable. What exactly
are you trying to do? Using the Startup folder in windows, or using the
'at' command, or some other software may be a better option.
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
maxzsim wrote:
> Hi ,
>
> I have an exe program that i do not want to be part of
> the services however , i do want it to auto-start when the
> server is rebooted.
> it is possble to configure it as part of SQL server
> Agent job ?
>
> thks & rdgs
running an exe file SQL server agent
Hi ,
I have an exe program that i do not want to be part of
the services however , i do want it to auto-start when the
server is rebooted.
it is possble to configure it as part of SQL server
Agent job ?
thks & rdgsYes,
Look up the xp_cmdshell command, and the SQL Agent 'Start
up Automatically when SQL Agent Starts' in schedule.
Peter
>--Original Message--
>Hi ,
>
> I have an exe program that i do not want to be part of
>the services however , i do want it to auto-start when
the
>server is rebooted.
> it is possble to configure it as part of SQL server
>Agent job ?
>
>thks & rdgs
>.
>|||maxzism,
Whilst it is possible, it may not necessarily be desirable. What exactly
are you trying to do? Using the Startup folder in windows, or using the
'at' command, or some other software may be a better option.
--
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
maxzsim wrote:
> Hi ,
>
> I have an exe program that i do not want to be part of
> the services however , i do want it to auto-start when the
> server is rebooted.
> it is possble to configure it as part of SQL server
> Agent job ?
>
> thks & rdgs|||hi,
thks for ur info , i think it has solved my problem
rdgs
>--Original Message--
>Yes,
>Look up the xp_cmdshell command, and the SQL Agent 'Start
>up Automatically when SQL Agent Starts' in schedule.
>Peter
>>--Original Message--
>>Hi ,
>>
>> I have an exe program that i do not want to be part
of
>>the services however , i do want it to auto-start when
>the
>>server is rebooted.
>> it is possble to configure it as part of SQL server
>>Agent job ?
>>
>>thks & rdgs
>>.
>.
>
I have an exe program that i do not want to be part of
the services however , i do want it to auto-start when the
server is rebooted.
it is possble to configure it as part of SQL server
Agent job ?
thks & rdgsYes,
Look up the xp_cmdshell command, and the SQL Agent 'Start
up Automatically when SQL Agent Starts' in schedule.
Peter
>--Original Message--
>Hi ,
>
> I have an exe program that i do not want to be part of
>the services however , i do want it to auto-start when
the
>server is rebooted.
> it is possble to configure it as part of SQL server
>Agent job ?
>
>thks & rdgs
>.
>|||maxzism,
Whilst it is possible, it may not necessarily be desirable. What exactly
are you trying to do? Using the Startup folder in windows, or using the
'at' command, or some other software may be a better option.
--
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
maxzsim wrote:
> Hi ,
>
> I have an exe program that i do not want to be part of
> the services however , i do want it to auto-start when the
> server is rebooted.
> it is possble to configure it as part of SQL server
> Agent job ?
>
> thks & rdgs|||hi,
thks for ur info , i think it has solved my problem
rdgs
>--Original Message--
>Yes,
>Look up the xp_cmdshell command, and the SQL Agent 'Start
>up Automatically when SQL Agent Starts' in schedule.
>Peter
>>--Original Message--
>>Hi ,
>>
>> I have an exe program that i do not want to be part
of
>>the services however , i do want it to auto-start when
>the
>>server is rebooted.
>> it is possble to configure it as part of SQL server
>>Agent job ?
>>
>>thks & rdgs
>>.
>.
>
Friday, March 23, 2012
Running 2000 and 2005 Reporting services on a single server
I've got SQL server 2000 running on a W2003 server and I want to install SQL Server 2005 and reporting services. Is there a way to run both of then. I'd like to have access to both for development purposes.
Thanks,
Just be sure to install in a different instance.
I am running both on same server. SQL 2005 instance is referenced by localhost\SQL2005 & http://localhost/reportserver$sql2005/
Virtual PC is a good option for this too.
There's a section in Books On Line called Working with Multiple versions of SQL Server that could help.|||Thanks I'll give it a shot
Thanks,
Just be sure to install in a different instance.
I am running both on same server. SQL 2005 instance is referenced by localhost\SQL2005 & http://localhost/reportserver$sql2005/
Virtual PC is a good option for this too.
There's a section in Books On Line called Working with Multiple versions of SQL Server that could help.|||Thanks I'll give it a shot
Wednesday, March 21, 2012
Run SQL Server services with the lowest possible privileges.
I see the phrase "Run SQL Server services with the lowest possible privilege
s." but the exact lowest possible privileges are not exactly discussed anywh
ere. I am betting that the answer depends on exactly what you are doing wit
h SQL Server. Some guideli
nes and discussion of this would be helpful.Ken wrote:
> I see the phrase "Run SQL Server services with the lowest possible privileges." bu
t the exact lowest possible privileges are not exactly discussed anywhere. I am bet
ting that the answer depends on exactly what you are doing with SQL Server. Some gu
ide
lines and discussion of this would be helpful.
>
I wrote up a small article on this that can help point you in the right
direction.
http://blogs.sqladvice.com/aweiker/.../03/07/712.aspx
Aaron Weiker
http://blogs.sqladvice.com/aweiker
http://aaronweiker.com/|||from:
http://www.microsoft.com/technet/pr...n/sp3sec02.mspx
Services
SQL Server 2000 and SQL Server Agent run as Windows services. Each service
must be associated with a Windows account, from which it derives its
security context. SQL Server allows members of the sysadmin fixed server
role to access operating system features. These operating system calls are
made with the security context of the Windows account that owns the server
process. If the server is cracked, these operating system calls may be used
to extend the attack to any other resource to which the owning Windows
process (the SQL Server service account) has access. For this reason, it is
important to grant only necessary privileges to SQL Server services. The
following settings are recommended.
SQL Server Engine/MSSQLServer
This is the SQL Server database engine and is the only mandatory service.
Run as a Windows domain user account with regular user privileges. Do not
run as local system, local administrator, or domain administrator accounts.
If there are named instances, they will be named MSSQL$InstanceName.
SQL Server Agent Service/SQLServerAgent
This is a support service that allows you to schedule commands and notify
operators when errors occur. Disable if not required in your environment;
otherwise run as a Windows domain user account with regular user
privileges. Do not run as local system, local administrator, or domain
administrator accounts. If there are named instances, they will be named
SQLAgent$InstanceName.
Important: SQL Server Agent will need local Windows administrator
privileges if one of the following is true:
SQL Server Agent connects to SQL Server using SQL Server Authentication
(not recommended).
SQL Server Agent uses a multiserver administration master server (MSX)
account that connects using SQL Server Authentication.
SQL Server Agent runs Microsoft ActiveX script or CmdExec jobs owned by
users who are not members of the sysadmin fixed server role.
SQL Server Active Directory Helper/MSSQLServerADHelper
This service supports Active Directory integration, including database
instance registration. Disable if not required in your environment;
otherwise run as a Windows local system account.
Microsoft Search
This service provides full-text search capabilities. Disable if not
required in your environment; otherwise run under the local system account.
Microsoft DTC
This service coordinates the processing of transactions distributed across
two or more servers. Disable if not required in your environment.
If you need to change the account associated with a SQL Server service, use
SQL Server Enterprise Manager. Enterprise Manager will set appropriate
permissions on the files and registry keys used by SQL Server. Never use
the Services applet of Microsoft Management Console (in Control Panel) to
change these accounts, because this requires manual adjustment of dozens of
registry permissions, NTFS file system permissions, and Windows user rights
a process that is prone to error.
For more information, see 283811 "HOW TO: Change the SQL Server Service
Account Without Using SQL Enterprise Manager in SQL Server 2000,". Changes
to account information will take effect the next time the service is
started. If you need to change the account associated with SQL Server and
SQL Server Agent, you must apply the change to both services separately
using Enterprise Manager
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.|||Aaron,
I have followed your directions to the letter, and had also previously
attempted this with MS's article Q283811, but am coming up with a problem
when I attempt to make the change in Ent. Manager:
Error 22042: xp_SetSQLSecurity() returned error -2147024890, 'The Handle is
invalid.'
Should I be setting this up elsewhere? Has anybody else encountered this
before?
Derek
"Aaron Weiker" <msnews.SPAM@.aaronweiker.com> wrote in message
news:efQXgRcDEHA.3016@.TK2MSFTNGP11.phx.gbl...
> Ken wrote:
privileges." but the exact lowest possible privileges are not exactly
discussed anywhere. I am betting that the answer depends on exactly what
you are doing with SQL Server. Some guidelines and discussion of this would
be helpful.
> I wrote up a small article on this that can help point you in the right
> direction.
> http://blogs.sqladvice.com/aweiker/.../03/07/712.aspx
>
> --
> Aaron Weiker
> http://blogs.sqladvice.com/aweiker
> http://aaronweiker.com/
>|||Did you change the MSSQLServer service account from Control Panel Services,
or thru Enterprise Manager?
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.|||We have recently implemented this change on our SQL servers. One thing that
helped us with troubleshooting errors was to enable failed object access aud
iting in the local auditing policy and then to enabloe all auditng on failed
access attempts on HKLM\So
ftware and sub keys and on the root of every partition and subdirectories an
d files.
If a DBA or programmer creates a SQL job that tries to access something that
it shouldn't or something that is stored somewhere that it shouldn't be it
will show up in the security event log.
Our biggest issue was batch files and scripts that were called from SQL jobs
that used the admin shares or tried to write to the root of a partition rat
her than the directories that we had set aside for SQL use.
s." but the exact lowest possible privileges are not exactly discussed anywh
ere. I am betting that the answer depends on exactly what you are doing wit
h SQL Server. Some guideli
nes and discussion of this would be helpful.Ken wrote:
> I see the phrase "Run SQL Server services with the lowest possible privileges." bu
t the exact lowest possible privileges are not exactly discussed anywhere. I am bet
ting that the answer depends on exactly what you are doing with SQL Server. Some gu
ide
lines and discussion of this would be helpful.
>
I wrote up a small article on this that can help point you in the right
direction.
http://blogs.sqladvice.com/aweiker/.../03/07/712.aspx
Aaron Weiker
http://blogs.sqladvice.com/aweiker
http://aaronweiker.com/|||from:
http://www.microsoft.com/technet/pr...n/sp3sec02.mspx
Services
SQL Server 2000 and SQL Server Agent run as Windows services. Each service
must be associated with a Windows account, from which it derives its
security context. SQL Server allows members of the sysadmin fixed server
role to access operating system features. These operating system calls are
made with the security context of the Windows account that owns the server
process. If the server is cracked, these operating system calls may be used
to extend the attack to any other resource to which the owning Windows
process (the SQL Server service account) has access. For this reason, it is
important to grant only necessary privileges to SQL Server services. The
following settings are recommended.
SQL Server Engine/MSSQLServer
This is the SQL Server database engine and is the only mandatory service.
Run as a Windows domain user account with regular user privileges. Do not
run as local system, local administrator, or domain administrator accounts.
If there are named instances, they will be named MSSQL$InstanceName.
SQL Server Agent Service/SQLServerAgent
This is a support service that allows you to schedule commands and notify
operators when errors occur. Disable if not required in your environment;
otherwise run as a Windows domain user account with regular user
privileges. Do not run as local system, local administrator, or domain
administrator accounts. If there are named instances, they will be named
SQLAgent$InstanceName.
Important: SQL Server Agent will need local Windows administrator
privileges if one of the following is true:
SQL Server Agent connects to SQL Server using SQL Server Authentication
(not recommended).
SQL Server Agent uses a multiserver administration master server (MSX)
account that connects using SQL Server Authentication.
SQL Server Agent runs Microsoft ActiveX script or CmdExec jobs owned by
users who are not members of the sysadmin fixed server role.
SQL Server Active Directory Helper/MSSQLServerADHelper
This service supports Active Directory integration, including database
instance registration. Disable if not required in your environment;
otherwise run as a Windows local system account.
Microsoft Search
This service provides full-text search capabilities. Disable if not
required in your environment; otherwise run under the local system account.
Microsoft DTC
This service coordinates the processing of transactions distributed across
two or more servers. Disable if not required in your environment.
If you need to change the account associated with a SQL Server service, use
SQL Server Enterprise Manager. Enterprise Manager will set appropriate
permissions on the files and registry keys used by SQL Server. Never use
the Services applet of Microsoft Management Console (in Control Panel) to
change these accounts, because this requires manual adjustment of dozens of
registry permissions, NTFS file system permissions, and Windows user rights
a process that is prone to error.
For more information, see 283811 "HOW TO: Change the SQL Server Service
Account Without Using SQL Enterprise Manager in SQL Server 2000,". Changes
to account information will take effect the next time the service is
started. If you need to change the account associated with SQL Server and
SQL Server Agent, you must apply the change to both services separately
using Enterprise Manager
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.|||Aaron,
I have followed your directions to the letter, and had also previously
attempted this with MS's article Q283811, but am coming up with a problem
when I attempt to make the change in Ent. Manager:
Error 22042: xp_SetSQLSecurity() returned error -2147024890, 'The Handle is
invalid.'
Should I be setting this up elsewhere? Has anybody else encountered this
before?
Derek
"Aaron Weiker" <msnews.SPAM@.aaronweiker.com> wrote in message
news:efQXgRcDEHA.3016@.TK2MSFTNGP11.phx.gbl...
> Ken wrote:
privileges." but the exact lowest possible privileges are not exactly
discussed anywhere. I am betting that the answer depends on exactly what
you are doing with SQL Server. Some guidelines and discussion of this would
be helpful.
> I wrote up a small article on this that can help point you in the right
> direction.
> http://blogs.sqladvice.com/aweiker/.../03/07/712.aspx
>
> --
> Aaron Weiker
> http://blogs.sqladvice.com/aweiker
> http://aaronweiker.com/
>|||Did you change the MSSQLServer service account from Control Panel Services,
or thru Enterprise Manager?
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.|||We have recently implemented this change on our SQL servers. One thing that
helped us with troubleshooting errors was to enable failed object access aud
iting in the local auditing policy and then to enabloe all auditng on failed
access attempts on HKLM\So
ftware and sub keys and on the root of every partition and subdirectories an
d files.
If a DBA or programmer creates a SQL job that tries to access something that
it shouldn't or something that is stored somewhere that it shouldn't be it
will show up in the security event log.
Our biggest issue was batch files and scripts that were called from SQL jobs
that used the admin shares or tried to write to the root of a partition rat
her than the directories that we had set aside for SQL use.
Tuesday, March 20, 2012
Run RS Script file from SSIS package
Hi!
I have a Reporting Services script file used to publish my reports. Is there anyway I can run it from a SSIS package?
Thank you!
Run rs.exe from an execute process task.Run reports on SQL 2000 databases with RS 2005?
All our databases are running on SQL 2000, with no migration to SQL
2005 planned at this time.
We do not currently use Reporting Services. A deployment of Reporting
Services 2005 is in the pipeline.
My question is, will I need to install RS 2005 on a SQL 2000 server to
be able to report on my 2000 databases? Or will it work to install RS
2005 on SQL2005 and report on SQL 2000 databases?
Thanks for helping a neophyte.The box that run RS 2005 must have a SQL Server 2005 license. You can use
SQL 2000 as the object/metadata store or you can use SQL 2005. RS reports
off of many many different types of data (SQL Server 2000, 2005, Sybase,
Oracle, etc). The does not need to and in many cases does not reside on the
same box as RS.
Even when you install RS it does not have to have the database on the same
machine(it must have a database for its object/metadata store, it just does
not have to be on the same machine) However, even if the database resides
elsewhere you have to have a license on whatever box you install RS 2005.
My preference is to have SQL Server 2005 on the box with RS even if it is
only used for RS and all the data being reported off of is elsewhere.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"xr7" <ewilson@.tpna.com> wrote in message
news:1158165177.262203.310810@.d34g2000cwd.googlegroups.com...
> All our databases are running on SQL 2000, with no migration to SQL
> 2005 planned at this time.
> We do not currently use Reporting Services. A deployment of Reporting
> Services 2005 is in the pipeline.
> My question is, will I need to install RS 2005 on a SQL 2000 server to
> be able to report on my 2000 databases? Or will it work to install RS
> 2005 on SQL2005 and report on SQL 2000 databases?
> Thanks for helping a neophyte.
>|||Yes, this will work:
"Or will it work to install RS 2005 on SQL2005 and report on SQL 2000
databases?"
Steve MunLeeuw
"xr7" <ewilson@.tpna.com> wrote in message
news:1158165177.262203.310810@.d34g2000cwd.googlegroups.com...
> All our databases are running on SQL 2000, with no migration to SQL
> 2005 planned at this time.
> We do not currently use Reporting Services. A deployment of Reporting
> Services 2005 is in the pipeline.
> My question is, will I need to install RS 2005 on a SQL 2000 server to
> be able to report on my 2000 databases? Or will it work to install RS
> 2005 on SQL2005 and report on SQL 2000 databases?
> Thanks for helping a neophyte.
>
2005 planned at this time.
We do not currently use Reporting Services. A deployment of Reporting
Services 2005 is in the pipeline.
My question is, will I need to install RS 2005 on a SQL 2000 server to
be able to report on my 2000 databases? Or will it work to install RS
2005 on SQL2005 and report on SQL 2000 databases?
Thanks for helping a neophyte.The box that run RS 2005 must have a SQL Server 2005 license. You can use
SQL 2000 as the object/metadata store or you can use SQL 2005. RS reports
off of many many different types of data (SQL Server 2000, 2005, Sybase,
Oracle, etc). The does not need to and in many cases does not reside on the
same box as RS.
Even when you install RS it does not have to have the database on the same
machine(it must have a database for its object/metadata store, it just does
not have to be on the same machine) However, even if the database resides
elsewhere you have to have a license on whatever box you install RS 2005.
My preference is to have SQL Server 2005 on the box with RS even if it is
only used for RS and all the data being reported off of is elsewhere.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"xr7" <ewilson@.tpna.com> wrote in message
news:1158165177.262203.310810@.d34g2000cwd.googlegroups.com...
> All our databases are running on SQL 2000, with no migration to SQL
> 2005 planned at this time.
> We do not currently use Reporting Services. A deployment of Reporting
> Services 2005 is in the pipeline.
> My question is, will I need to install RS 2005 on a SQL 2000 server to
> be able to report on my 2000 databases? Or will it work to install RS
> 2005 on SQL2005 and report on SQL 2000 databases?
> Thanks for helping a neophyte.
>|||Yes, this will work:
"Or will it work to install RS 2005 on SQL2005 and report on SQL 2000
databases?"
Steve MunLeeuw
"xr7" <ewilson@.tpna.com> wrote in message
news:1158165177.262203.310810@.d34g2000cwd.googlegroups.com...
> All our databases are running on SQL 2000, with no migration to SQL
> 2005 planned at this time.
> We do not currently use Reporting Services. A deployment of Reporting
> Services 2005 is in the pipeline.
> My question is, will I need to install RS 2005 on a SQL 2000 server to
> be able to report on my 2000 databases? Or will it work to install RS
> 2005 on SQL2005 and report on SQL 2000 databases?
> Thanks for helping a neophyte.
>
Run Reporting services from a netwrok share
I have reporting services installed on server A. I want to have iis on server
B point to the report manager on server A. I created a netwrok share on
server A and have iis pointed to this share. When I try to browse the report
manger I get:
Description: An error occurred during the processing of a configuration file
required to service this request. Please review the specific error details
below and modify your configuration file appropriately.
Parser Error Message: Execution permission cannot be acquired
Is it possible to do what I am trying? Is there an easier way?No, you cannot do this. If you want to have report manager on a different
box than the database you can do that but you have to purchase an additional
license. If you want a web farm you can do that. You cannot use any network
file sharing to accomplish anything. The reason is, Report Manager is a
asp.net application. The reports do not exist as files, they are all stored
in the database (search for *.rdl on the server and you will not see any).
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"lykerd" <lykerd@.discussions.microsoft.com> wrote in message
news:775ED6F2-F21A-4DA1-A3AE-5C09A3FFA94B@.microsoft.com...
>I have reporting services installed on server A. I want to have iis on
>server
> B point to the report manager on server A. I created a netwrok share on
> server A and have iis pointed to this share. When I try to browse the
> report
> manger I get:
> Description: An error occurred during the processing of a configuration
> file
> required to service this request. Please review the specific error details
> below and modify your configuration file appropriately.
> Parser Error Message: Execution permission cannot be acquired
> Is it possible to do what I am trying? Is there an easier way?
B point to the report manager on server A. I created a netwrok share on
server A and have iis pointed to this share. When I try to browse the report
manger I get:
Description: An error occurred during the processing of a configuration file
required to service this request. Please review the specific error details
below and modify your configuration file appropriately.
Parser Error Message: Execution permission cannot be acquired
Is it possible to do what I am trying? Is there an easier way?No, you cannot do this. If you want to have report manager on a different
box than the database you can do that but you have to purchase an additional
license. If you want a web farm you can do that. You cannot use any network
file sharing to accomplish anything. The reason is, Report Manager is a
asp.net application. The reports do not exist as files, they are all stored
in the database (search for *.rdl on the server and you will not see any).
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"lykerd" <lykerd@.discussions.microsoft.com> wrote in message
news:775ED6F2-F21A-4DA1-A3AE-5C09A3FFA94B@.microsoft.com...
>I have reporting services installed on server A. I want to have iis on
>server
> B point to the report manager on server A. I created a netwrok share on
> server A and have iis pointed to this share. When I try to browse the
> report
> manger I get:
> Description: An error occurred during the processing of a configuration
> file
> required to service this request. Please review the specific error details
> below and modify your configuration file appropriately.
> Parser Error Message: Execution permission cannot be acquired
> Is it possible to do what I am trying? Is there an easier way?
Monday, March 12, 2012
Run Once Schedule
In SQL 2005 Reporting Services, on the page that you use to set a schedule
for a subscription, there is an option to run a report once. Is there a way
through the web service interface to invoke this specific schedule? Do you
use the NoRecurrence object?
(The options are: Hour, Day, Weekly, Monthly, Once)The quick answer is YES, everything that is done in the ReportManager
uses the web service interface. I would check the BOL for the specific
details.
"Steven Molen" <StevenMolen@.discussions.microsoft.com> wrote in message
news:7B87FBF2-5CE0-4298-8DD7-7FA9A586FD9D@.microsoft.com:
> In SQL 2005 Reporting Services, on the page that you use to set a schedule
> for a subscription, there is an option to run a report once. Is there a way
> through the web service interface to invoke this specific schedule? Do you
> use the NoRecurrence object?
> (The options are: Hour, Day, Weekly, Monthly, Once)
Bret Updegraff, MCAD,MCSD,MCDBA
Microsoft MVP - SQL Server
Crowe Chizek and Company LLC
President - Indianapolis Professional Association for SQL Server
Join our SQL Server Community http;//www.IndyPASS.org
317.208.2538 - FAX (317.706.2660) -BUpdegraff@.CroweChizek.com|||Excuse the ignorance. Whats the BOL? If you means sql books online then I
have already checked there and I couldn't find it...I wanted to look in the
source for the SubscriptionsProperties.aspx page but it is compiled and I
haven't bothered to run reflector against it.
"Bret Updegraff" wrote:
> The quick answer is YES, everything that is done in the ReportManager
> uses the web service interface. I would check the BOL for the specific
> details.
>
> "Steven Molen" <StevenMolen@.discussions.microsoft.com> wrote in message
> news:7B87FBF2-5CE0-4298-8DD7-7FA9A586FD9D@.microsoft.com:
> > In SQL 2005 Reporting Services, on the page that you use to set a schedule
> > for a subscription, there is an option to run a report once. Is there a way
> > through the web service interface to invoke this specific schedule? Do you
> > use the NoRecurrence object?
> >
> > (The options are: Hour, Day, Weekly, Monthly, Once)
>
> --
> Bret Updegraff, MCAD,MCSD,MCDBA
> Microsoft MVP - SQL Server
> Crowe Chizek and Company LLC
> President - Indianapolis Professional Association for SQL Server
> Join our SQL Server Community http;//www.IndyPASS.org
> 317.208.2538 - FAX (317.706.2660) -BUpdegraff@.CroweChizek.com
>|||OK. The answer wasn't in the BOL. Pfft. The SQL BOL is very light when it
comes to the web service and what it can and can't do.
I got "unlazy" and pulled out my reflector and deconstructed the
SubscriptionProperties page (All the report services pages are compiled
pages). Needless to say, my answer I was looking for wasn't on that page but
in a custom class that they were using to construct the schedule portion of
the subscription.
(Specifically Microsoft.ReportingServices.UI.ScheduleControl within the
ReportingServicesWebUserInterface.dll)
The method that most caught my interest was TaskToScheduleDefinition() since
I was using the scheduledefinition object inherently. The short answer is:
DO NOT set the Schedule.Item and to leave it null. Only set the
StartDateTime on the schedule object.
I tested this theory that I picked up from looking at the disassembled code
and my Subscriber object worked perfectly with the schedule object set as
described above.
Here is the code from the reporting services assembly if your interested.
This is from SQL 2005 of course and only has to do with setting the schedule
object and not the rest of the code needed to set up a full subscription:
internal static ScheduleDefinition TaskToScheduleDefinition(Task task)
{
ScheduleDefinition definition1 = new ScheduleDefinition();
definition1.StartDateTime = task.StartDateTime;
definition1.EndDate = task.EndDate;
definition1.EndDateSpecified = false;
if (task.EndDate != DateTime.MinValue)
{
definition1.EndDateSpecified = true;
}
switch (task.Trigger.RecurrenceType)
{
case RecurrenceType.Once:
{
return definition1;
}
case RecurrenceType.Minutes:
{
MinuteRecurrence recurrence1 = new MinuteRecurrence();
recurrence1.MinutesInterval = ((Minutes)
task.Trigger.TriggerData).MinutesInterval;
definition1.Item = recurrence1;
return definition1;
}
case RecurrenceType.Daily:
{
DailyRecurrence recurrence2 = new DailyRecurrence();
recurrence2.DaysInterval = (int) ((Daily)
task.Trigger.TriggerData).DaysInterval;
definition1.Item = recurrence2;
return definition1;
}
case RecurrenceType.Weekly:
{
WeeklyRecurrence recurrence3 = new WeeklyRecurrence();
Weekly weekly1 = (Weekly) task.Trigger.TriggerData;
recurrence3.DaysOfWeek =ScheduleControl.UintToDaysOfWeek(weekly1.DaysOfWeek);
recurrence3.WeeksInterval = (int) weekly1.WeeksInterval;
recurrence3.WeeksIntervalSpecified = true;
definition1.Item = recurrence3;
return definition1;
}
case RecurrenceType.MonthlyDate:
{
MonthlyRecurrence recurrence4 = new MonthlyRecurrence();
Monthly monthly1 = (Monthly) task.Trigger.TriggerData;
recurrence4.Days =Monthly.GetDayRange(monthly1.DaysOfMonth);
recurrence4.MonthsOfYear =ScheduleControl.UintToMonthsOfYear(monthly1.Months);
definition1.Item = recurrence4;
return definition1;
}
case RecurrenceType.MonthlyDOW:
{
MonthlyDOWRecurrence recurrence5 = new
MonthlyDOWRecurrence();
MonthlyDOW ydow1 = (MonthlyDOW) task.Trigger.TriggerData;
recurrence5.DaysOfWeek =ScheduleControl.UintToDaysOfWeek(ydow1.DaysOfWeek);
recurrence5.MonthsOfYear =ScheduleControl.UintToMonthsOfYear(ydow1.Months);
recurrence5.WhichWeek =ScheduleControl.UintToWhichWeek(ydow1.Week);
recurrence5.WhichWeekSpecified = true;
definition1.Item = recurrence5;
return definition1;
}
}
return definition1;
}
"Steven Molen" wrote:
> Excuse the ignorance. Whats the BOL? If you means sql books online then I
> have already checked there and I couldn't find it...I wanted to look in the
> source for the SubscriptionsProperties.aspx page but it is compiled and I
> haven't bothered to run reflector against it.
> "Bret Updegraff" wrote:
> > The quick answer is YES, everything that is done in the ReportManager
> > uses the web service interface. I would check the BOL for the specific
> > details.
> >
> >
> > "Steven Molen" <StevenMolen@.discussions.microsoft.com> wrote in message
> > news:7B87FBF2-5CE0-4298-8DD7-7FA9A586FD9D@.microsoft.com:
> >
> > > In SQL 2005 Reporting Services, on the page that you use to set a schedule
> > > for a subscription, there is an option to run a report once. Is there a way
> > > through the web service interface to invoke this specific schedule? Do you
> > > use the NoRecurrence object?
> > >
> > > (The options are: Hour, Day, Weekly, Monthly, Once)
> >
> >
> > --
> > Bret Updegraff, MCAD,MCSD,MCDBA
> > Microsoft MVP - SQL Server
> > Crowe Chizek and Company LLC
> > President - Indianapolis Professional Association for SQL Server
> > Join our SQL Server Community http;//www.IndyPASS.org
> > 317.208.2538 - FAX (317.706.2660) -BUpdegraff@.CroweChizek.com
> >
> >
for a subscription, there is an option to run a report once. Is there a way
through the web service interface to invoke this specific schedule? Do you
use the NoRecurrence object?
(The options are: Hour, Day, Weekly, Monthly, Once)The quick answer is YES, everything that is done in the ReportManager
uses the web service interface. I would check the BOL for the specific
details.
"Steven Molen" <StevenMolen@.discussions.microsoft.com> wrote in message
news:7B87FBF2-5CE0-4298-8DD7-7FA9A586FD9D@.microsoft.com:
> In SQL 2005 Reporting Services, on the page that you use to set a schedule
> for a subscription, there is an option to run a report once. Is there a way
> through the web service interface to invoke this specific schedule? Do you
> use the NoRecurrence object?
> (The options are: Hour, Day, Weekly, Monthly, Once)
Bret Updegraff, MCAD,MCSD,MCDBA
Microsoft MVP - SQL Server
Crowe Chizek and Company LLC
President - Indianapolis Professional Association for SQL Server
Join our SQL Server Community http;//www.IndyPASS.org
317.208.2538 - FAX (317.706.2660) -BUpdegraff@.CroweChizek.com|||Excuse the ignorance. Whats the BOL? If you means sql books online then I
have already checked there and I couldn't find it...I wanted to look in the
source for the SubscriptionsProperties.aspx page but it is compiled and I
haven't bothered to run reflector against it.
"Bret Updegraff" wrote:
> The quick answer is YES, everything that is done in the ReportManager
> uses the web service interface. I would check the BOL for the specific
> details.
>
> "Steven Molen" <StevenMolen@.discussions.microsoft.com> wrote in message
> news:7B87FBF2-5CE0-4298-8DD7-7FA9A586FD9D@.microsoft.com:
> > In SQL 2005 Reporting Services, on the page that you use to set a schedule
> > for a subscription, there is an option to run a report once. Is there a way
> > through the web service interface to invoke this specific schedule? Do you
> > use the NoRecurrence object?
> >
> > (The options are: Hour, Day, Weekly, Monthly, Once)
>
> --
> Bret Updegraff, MCAD,MCSD,MCDBA
> Microsoft MVP - SQL Server
> Crowe Chizek and Company LLC
> President - Indianapolis Professional Association for SQL Server
> Join our SQL Server Community http;//www.IndyPASS.org
> 317.208.2538 - FAX (317.706.2660) -BUpdegraff@.CroweChizek.com
>|||OK. The answer wasn't in the BOL. Pfft. The SQL BOL is very light when it
comes to the web service and what it can and can't do.
I got "unlazy" and pulled out my reflector and deconstructed the
SubscriptionProperties page (All the report services pages are compiled
pages). Needless to say, my answer I was looking for wasn't on that page but
in a custom class that they were using to construct the schedule portion of
the subscription.
(Specifically Microsoft.ReportingServices.UI.ScheduleControl within the
ReportingServicesWebUserInterface.dll)
The method that most caught my interest was TaskToScheduleDefinition() since
I was using the scheduledefinition object inherently. The short answer is:
DO NOT set the Schedule.Item and to leave it null. Only set the
StartDateTime on the schedule object.
I tested this theory that I picked up from looking at the disassembled code
and my Subscriber object worked perfectly with the schedule object set as
described above.
Here is the code from the reporting services assembly if your interested.
This is from SQL 2005 of course and only has to do with setting the schedule
object and not the rest of the code needed to set up a full subscription:
internal static ScheduleDefinition TaskToScheduleDefinition(Task task)
{
ScheduleDefinition definition1 = new ScheduleDefinition();
definition1.StartDateTime = task.StartDateTime;
definition1.EndDate = task.EndDate;
definition1.EndDateSpecified = false;
if (task.EndDate != DateTime.MinValue)
{
definition1.EndDateSpecified = true;
}
switch (task.Trigger.RecurrenceType)
{
case RecurrenceType.Once:
{
return definition1;
}
case RecurrenceType.Minutes:
{
MinuteRecurrence recurrence1 = new MinuteRecurrence();
recurrence1.MinutesInterval = ((Minutes)
task.Trigger.TriggerData).MinutesInterval;
definition1.Item = recurrence1;
return definition1;
}
case RecurrenceType.Daily:
{
DailyRecurrence recurrence2 = new DailyRecurrence();
recurrence2.DaysInterval = (int) ((Daily)
task.Trigger.TriggerData).DaysInterval;
definition1.Item = recurrence2;
return definition1;
}
case RecurrenceType.Weekly:
{
WeeklyRecurrence recurrence3 = new WeeklyRecurrence();
Weekly weekly1 = (Weekly) task.Trigger.TriggerData;
recurrence3.DaysOfWeek =ScheduleControl.UintToDaysOfWeek(weekly1.DaysOfWeek);
recurrence3.WeeksInterval = (int) weekly1.WeeksInterval;
recurrence3.WeeksIntervalSpecified = true;
definition1.Item = recurrence3;
return definition1;
}
case RecurrenceType.MonthlyDate:
{
MonthlyRecurrence recurrence4 = new MonthlyRecurrence();
Monthly monthly1 = (Monthly) task.Trigger.TriggerData;
recurrence4.Days =Monthly.GetDayRange(monthly1.DaysOfMonth);
recurrence4.MonthsOfYear =ScheduleControl.UintToMonthsOfYear(monthly1.Months);
definition1.Item = recurrence4;
return definition1;
}
case RecurrenceType.MonthlyDOW:
{
MonthlyDOWRecurrence recurrence5 = new
MonthlyDOWRecurrence();
MonthlyDOW ydow1 = (MonthlyDOW) task.Trigger.TriggerData;
recurrence5.DaysOfWeek =ScheduleControl.UintToDaysOfWeek(ydow1.DaysOfWeek);
recurrence5.MonthsOfYear =ScheduleControl.UintToMonthsOfYear(ydow1.Months);
recurrence5.WhichWeek =ScheduleControl.UintToWhichWeek(ydow1.Week);
recurrence5.WhichWeekSpecified = true;
definition1.Item = recurrence5;
return definition1;
}
}
return definition1;
}
"Steven Molen" wrote:
> Excuse the ignorance. Whats the BOL? If you means sql books online then I
> have already checked there and I couldn't find it...I wanted to look in the
> source for the SubscriptionsProperties.aspx page but it is compiled and I
> haven't bothered to run reflector against it.
> "Bret Updegraff" wrote:
> > The quick answer is YES, everything that is done in the ReportManager
> > uses the web service interface. I would check the BOL for the specific
> > details.
> >
> >
> > "Steven Molen" <StevenMolen@.discussions.microsoft.com> wrote in message
> > news:7B87FBF2-5CE0-4298-8DD7-7FA9A586FD9D@.microsoft.com:
> >
> > > In SQL 2005 Reporting Services, on the page that you use to set a schedule
> > > for a subscription, there is an option to run a report once. Is there a way
> > > through the web service interface to invoke this specific schedule? Do you
> > > use the NoRecurrence object?
> > >
> > > (The options are: Hour, Day, Weekly, Monthly, Once)
> >
> >
> > --
> > Bret Updegraff, MCAD,MCSD,MCDBA
> > Microsoft MVP - SQL Server
> > Crowe Chizek and Company LLC
> > President - Indianapolis Professional Association for SQL Server
> > Join our SQL Server Community http;//www.IndyPASS.org
> > 317.208.2538 - FAX (317.706.2660) -BUpdegraff@.CroweChizek.com
> >
> >
RUN NET START/STOP MSSQLSERVER FROM SSIS PACKAGE
HELLO,
I want to create a package which start and stop the SQL server's services... i know i can achive this via NET COMMAND.... but i coudnt find in which task (SSIS) I can place that command?..
I also came across that I can achieve this using Execute Process task but for this I have to define executable file.... actually i dont want ne thing outside from my SSIS package
CAN I ACHIEVE THIS WITH IN SSIS PACKAGE?
is there ne other alternative?
regards,
Anas
Execute "cmd.exe" and use the following arguments:"/C net send ..."
Try running from the command line to see what I'm talking about.
cmd.exe /C net send ...|||
Phil Brammer wrote:
Execute "cmd.exe" and use the following arguments: "/C net send ..."
Try running from the command line to see what I'm talking about.
cmd.exe /C net send ...
what do u mean by that? where shud i run that command? can u please explain it in more details...
regards,
Anas
|||In the execute process task. The executable is "cmd.exe" and the arguments are "/C net start..."
Add a WMI connection manager, named "WMI" with the following connection string, built dynamically as the case may be.
ServerName=\\localhost;Namespace=\root\cimv2:Win32_Service.Name="MSSQLSERVER";UseNtAuth=True;UserName=;
Use the connection manager in a task (custom or script) to invoke any management call (including service management). I left out handling of dependent services here (for example, SQL Agent is a dependent service), but this may suffice for the general concept.
Imports System
Imports System.Data
Imports System.Math
Imports Microsoft.SqlServer.Dts.Runtime
Imports System.Management ' Add reference to System.Management.dll
Public Class ScriptMain
Private wmiScope As ManagementScope
Private svc As ManagementObject
Public Sub Main()
Dts.TaskResult = Dts.Results.Success
Try
wmiScope = DirectCast(Dts.Connections("WMI").AcquireConnection(Nothing), _
ManagementScope)
wmiScope.Connect()
svc = New ManagementObject(wmiScope, wmiScope.Path, Nothing)
If CType(svc("State"), String) = "Running" Then
svc.InvokeMethod("StopService", Nothing)
End If
Catch ex As Exception
Dts.Events.FireError(1, ex.TargetSite.ToString(), ex.Message, _
String.Empty, 0)
Dts.TaskResult = Dts.Results.Failure
End Try
End Sub
End Class
|||
You can start and stop services using the WMI connection manager. The WMI connection manager's acquires a ManagementScope. Other connection manager's acquire SqlConnections, MessageQueues, and so on.
Add a WMI connection manager, named "WMI" with the following connection string, built dynamically as the case may be.
ServerName=\\localhost;Namespace=\root\cimv2:Win32_Service.Name="MSSQLSERVER";UseNtAuth=True;UserName=;Use the connection manager in a task (custom or script) to invoke any management call (including service management). I left out handling of dependent services here (for example, SQL Agent is a dependent service), but this may suffice for the general concept.
Imports System
Imports System.Data
Imports System.Math
Imports Microsoft.SqlServer.Dts.Runtime
Imports System.Management ' Add reference to System.Management.dll
Public Class ScriptMain
Private wmiScope As ManagementScope
Private svc As ManagementObject
Public Sub Main()
Dts.TaskResult = Dts.Results.Success
Try
wmiScope = DirectCast(Dts.Connections("WMI").AcquireConnection(Nothing), _
ManagementScope)
wmiScope.Connect()
svc = New ManagementObject(wmiScope, wmiScope.Path, Nothing)
If CType(svc("State"), String) = "Running" Then
svc.InvokeMethod("StopService", Nothing)
End If
Catch ex As Exception
Dts.Events.FireError(1, ex.TargetSite.ToString(), ex.Message, _
String.Empty, 0)
Dts.TaskResult = Dts.Results.Failure
End Try
End Sub
End Class
what do you means by "' Add reference to System.Management.dll"... actually i geting error on ManagementScope ((blue under line)
can u please tell me ?
thanx for ur support
regards,
Anas
|||There are about 4 ways to add an assembly reference in a given script task. There may be others for all I know.
1. Project Menu/Add reference ... to System.Management.dll
2. View menu/Project explorer. Right click (get context menu) on the project explorer References node. Chose assembly...
3. View menu/Object Browser. Browse to System.Management assembly. Click on the "+" toolbar strip icon.
4. View menu/Class view. Right click (get context menu) on References node. Choose assembly...
RUN NET START/STOP MSSQLSERVER FROM SSIS PACKAGE
HELLO,
I want to create a package which start and stop the SQL server's services... i know i can achive this via NET COMMAND.... but i coudnt find in which task (SSIS) I can place that command?..
I also came across that I can achieve this using Execute Process task but for this I have to define executable file.... actually i dont want ne thing outside from my SSIS package
CAN I ACHIEVE THIS WITH IN SSIS PACKAGE?
is there ne other alternative?
regards,
Anas
Execute "cmd.exe" and use the following arguments:
"/C net send ..."
Try running from the command line to see what I'm talking about.
cmd.exe /C net send ...|||
Execute "cmd.exe" and use the following arguments: "/C net send ..."
Try running from the command line to see what I'm talking about.
cmd.exe /C net send ...
what do u mean by that? where shud i run that command? can u please explain it in more details...
regards,
Anas
|||In the execute process task. The executable is "cmd.exe" and the arguments are "/C net start..."
Add a WMI connection manager, named "WMI" with the following connection string, built dynamically as the case may be.
ServerName=\\localhost;Namespace=\root\cimv2:Win32_Service.Name="MSSQLSERVER";UseNtAuth=True;UserName=;
Use the connection manager in a task (custom or script) to invoke any management call (including service management). I left out handling of dependent services here (for example, SQL Agent is a dependent service), but this may suffice for the general concept.
Imports System
Imports System.Data
Imports System.Math
Imports Microsoft.SqlServer.Dts.Runtime
Imports System.Management ' Add reference to System.Management.dll
Public Class ScriptMain
Private wmiScope As ManagementScope
Private svc As ManagementObject
Public Sub Main()
Dts.TaskResult = Dts.Results.Success
Try
wmiScope = DirectCast(Dts.Connections("WMI").AcquireConnection(Nothing), _
ManagementScope)
wmiScope.Connect()
svc = New ManagementObject(wmiScope, wmiScope.Path, Nothing)
If CType(svc("State"), String) = "Running" Then
svc.InvokeMethod("StopService", Nothing)
End If
Catch ex As Exception
Dts.Events.FireError(1, ex.TargetSite.ToString(), ex.Message, _
String.Empty, 0)
Dts.TaskResult = Dts.Results.Failure
End Try
End Sub
End Class
|||You can start and stop services using the WMI connection manager. The WMI connection manager's acquires a ManagementScope. Other connection manager's acquire SqlConnections, MessageQueues, and so on.
Add a WMI connection manager, named "WMI" with the following connection string, built dynamically as the case may be.
ServerName=\\localhost;Namespace=\root\cimv2:Win32_Service.Name="MSSQLSERVER";UseNtAuth=True;UserName=;Use the connection manager in a task (custom or script) to invoke any management call (including service management). I left out handling of dependent services here (for example, SQL Agent is a dependent service), but this may suffice for the general concept.
Imports System
Imports System.Data
Imports System.Math
Imports Microsoft.SqlServer.Dts.Runtime
Imports System.Management ' Add reference to System.Management.dll
Public Class ScriptMain
Private wmiScope As ManagementScope
Private svc As ManagementObject
Public Sub Main()
Dts.TaskResult = Dts.Results.Success
Try
wmiScope = DirectCast(Dts.Connections("WMI").AcquireConnection(Nothing), _
ManagementScope)
wmiScope.Connect()
svc = New ManagementObject(wmiScope, wmiScope.Path, Nothing)
If CType(svc("State"), String) = "Running" Then
svc.InvokeMethod("StopService", Nothing)
End If
Catch ex As Exception
Dts.Events.FireError(1, ex.TargetSite.ToString(), ex.Message, _
String.Empty, 0)
Dts.TaskResult = Dts.Results.Failure
End Try
End Sub
End Class
what do you means by "' Add reference to System.Management.dll"... actually i geting error on ManagementScope ((blue under line)
can u please tell me ?
thanx for ur support
regards,
Anas
|||There are about 4 ways to add an assembly reference in a given script task. There may be others for all I know.
1. Project Menu/Add reference ... to System.Management.dll
2. View menu/Project explorer. Right click (get context menu) on the project explorer References node. Chose assembly...
3. View menu/Object Browser. Browse to System.Management assembly. Click on the "+" toolbar strip icon.
4. View menu/Class view. Right click (get context menu) on References node. Choose assembly...
Saturday, February 25, 2012
RUN "Intergration Services Deployment Manifest" through Command Prompt
Hi, I want to run "Intergration Services Deployment Manifest" through the command prompt, passing the values .. which should basically go and install that Package either on File System or SQL Server. Does any one have any idea on how to do that ...
Thanks,
You can use the dtutil command prompt utility to copy a package to the Microsoft SQL Server database, the SSIS Package Store, or the file system.
However, the package must already exist in one of these three locations.
For more information, see "dtutil Utility" at http://msdn2.microsoft.com/en-us/library/ms162820.aspx.
|||Thanks alot for your reply ..RUN "Intergration Services Deployment Manifest" through Command Prompt
Hi, I want to run "Intergration Services Deployment Manifest" through the command prompt, passing the values .. which should basically go and install that Package either on File System or SQL Server. Does any one have any idea on how to do that ...
Thanks,
You can use the dtutil command prompt utility to copy a package to the Microsoft SQL Server database, the SSIS Package Store, or the file system.
However, the package must already exist in one of these three locations.
For more information, see "dtutil Utility" at http://msdn2.microsoft.com/en-us/library/ms162820.aspx.
|||Thanks alot for your reply ..RTM Integration Services Job
When I try to create a job step of type SQL Server Integration Services Package I get an error:
===================================
The specified module could not be found. (Exception from HRESULT: 0x8007007E) (SqlManagerUI)
Program Location:
at Microsoft.SqlServer.Management.SqlManagerUI.DTSJobSubSystemDefinition.Microsoft.SqlServer.Management.SqlManagerUI.IJobStepPropertiesControl.Load(JobStepData data)
at Microsoft.SqlServer.Management.SqlManagerUI.JobStepProperties.typeList_SelectedIndexChanged(Object sender, EventArgs e)
at System.Windows.Forms.ComboBox.OnSelectedIndexChanged(EventArgs e)
at System.Windows.Forms.ComboBox.WmReflectCommand(Message& m)
at System.Windows.Forms.ComboBox.WndProc(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)
And here's the version info:
Microsoft SQL Server Management Studio 9.00.1399.00
Microsoft Analysis Services Client Tools 2005.090.1399.00
Microsoft Data Access Components (MDAC) 2000.086.1830.00 (srv03_sp1_rtm.050324-1447)
Microsoft MSXML 2.6 3.0 4.0 5.0 6.0
Microsoft Internet Explorer 6.0.3790.1830
Microsoft .NET Framework 2.0.50727.42
Operating System 5.2.3790
As far as I can tell the Integration Services service is running and I installed all features for testing.
Any help is appreciated.
Larry
This might be due to an unclean uninstall of BETA 2005. I followed the directions for removing previous versions, but Reporting Services also wasn't working and the entire directory was missing. I did install to the D:\ but otherwise it was a fairly plain install.|||Ok, I uninstalled everything, deleted the orphaned directories and remaining 90 registry keys and reinstalled.Reporting Services was really funky. It didn't work, the configuration assistant wouldn't let me change anything. I whacked the virtual directories created at install from IIS and had to delete the databases created during install. Stopped the service and then could get through configuration down to Initialization at which point I had to start the service to proceed. It seems to be working finally.
For the original problem:
When I try to create a job step of type SQL Server Integration Services Package I get an error:
It is still happening. Any help would be appreciated.|||Interestingly, I created a database diagram, and a maintenance plan and suddenly the interface for Integration Services jobs started working. No idea why, but I'm not fond of magic interfaces, and yet mildly pleased that it's working.
Subscribe to:
Posts (Atom)