I have three locations: SQL1, SQL2 and SQL3. SQL1 is a Developers Edition on
my local workstation. SQL2 is out on the internet, remote from SQL3 which is
also out there on the internet. Currently, I have a DTS on SQL1 that copies
data from SQL3 over to SQL2. Problem: I would like to get this on a
schedule. I don't want to schedule it on my SQL1 machine and I'm not allowed
DTS packages on SQL2 and SQL3 because they are on shared plans. That leaves
me with scheduling SPs through the use of ASP pages.
Is it possible to transfer data between SQL2 and SQL3 in an SP?
thanks!shank
Have you looked at linked servers? For more details please refer to the BOL
"shank" <shank@.tampabay.rr.com> wrote in message
news:%230vAUpgIGHA.1124@.TK2MSFTNGP10.phx.gbl...
>I have three locations: SQL1, SQL2 and SQL3. SQL1 is a Developers Edition
>on my local workstation. SQL2 is out on the internet, remote from SQL3
>which is also out there on the internet. Currently, I have a DTS on SQL1
>that copies data from SQL3 over to SQL2. Problem: I would like to get this
>on a schedule. I don't want to schedule it on my SQL1 machine and I'm not
>allowed DTS packages on SQL2 and SQL3 because they are on shared plans.
>That leaves me with scheduling SPs through the use of ASP pages.
> Is it possible to transfer data between SQL2 and SQL3 in an SP?
> thanks!
>|||I have just been advised by our webhost that they do not allow Linked
Servers due to security issues.
Is there another way to connect through an SP?
In short, I need to automate transfer of data from SQL3 to SQL2 without
Linked Servers or DTS packages.
thanks!
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:uEltjujIGHA.3176@.TK2MSFTNGP12.phx.gbl...
> shank
> Have you looked at linked servers? For more details please refer to the
> BOL
> "shank" <shank@.tampabay.rr.com> wrote in message
> news:%230vAUpgIGHA.1124@.TK2MSFTNGP10.phx.gbl...
>
Showing posts with label developers. Show all posts
Showing posts with label developers. Show all posts
Thursday, 22 March 2012
Sunday, 19 February 2012
Configuring Users - best Practices
Hello All,
I need to find out the best practices approach for user configuration in SQL
Reporting Services. I have teams of developers, who would be using VS.NET
development and deploying using VS.NET. Whats the best approach I could take
for development...Ideally I would like each team of users to have a folder
and so that they could deploy the reports only to those folders. Also how do
I set VS.NET to deploy a specifc sub folder.
Any thoughts or suggestions would be of good help.
Thanks,
ChrisYou can't deploy to a SubFolder in RS2K. Deployment from VS takes your
project name and uses it when you deploy. Only get one level.
There is a My Report folder you can turn on using the Report Manager under
system settings, but not sure that'll help you solve the problem you've
described.
If you need more, most straight forward approach is to go into Report
Manager after you deploy and move things around. Either that or use Report
Manager to 1st create the directory structure (folders / subfolders)
desired, then as Content Manager use the Upload File button on the tool bar
from within the subfolder to upload your reports.
If you find this to be burdensome, perhaps consider creating a VB script
like the one at
http://msdn.microsoft.com/library/en-us/rsamples/htm/rss_sampleapps_v1_1apd.asp
to automate the deployment process. Note, you could also do this
programmatically using the RS2K SOAP API. Perhaps as a program or daemon
that traverses a directory structure looking for .rdl files and then creates
the equivalent folders in RS to upload the reports to.
--
-- "This posting is provided 'AS IS' with no warranties, and confers no
rights."
jhmiller@.online.microsoft.com
"Christopher Pragash" <chrispragash@.hotmail.com> wrote in message
news:uyCnuc6mEHA.1304@.TK2MSFTNGP09.phx.gbl...
> Hello All,
> I need to find out the best practices approach for user configuration in
> SQL
> Reporting Services. I have teams of developers, who would be using VS.NET
> development and deploying using VS.NET. Whats the best approach I could
> take
> for development...Ideally I would like each team of users to have a folder
> and so that they could deploy the reports only to those folders. Also how
> do
> I set VS.NET to deploy a specifc sub folder.
> Any thoughts or suggestions would be of good help.
> Thanks,
> Chris
>|||John H. Miller wrote:
> You can't deploy to a SubFolder in RS2K. Deployment from VS takes
> your project name and uses it when you deploy. Only get one level.
I don't think that's correct, John. I am able to deploy to any folder I
want in RS2K (SP1) by setting the TargetFolder property under Deployment in
the project's Property Pages.
I would think Chris could set up a separate folder for each developer and
set up permissions that allow a developer to publish only to his/her own
folder. Each developer would simply set the TargetFolder to the virtual
path to his/her folder.
--
Regards,
Jake Marx
MS MVP - Excel
www.longhead.com
[please keep replies in the newsgroup - email address unmonitored]|||Christopher Pragash wrote:
> Hello All,
> I need to find out the best practices approach for user configuration
in SQL
> Reporting Services. I have teams of developers, who would be using
VS.NET
> development and deploying using VS.NET. Whats the best approach I
could take
> for development...Ideally I would like each team of users to have a
folder
> and so that they could deploy the reports only to those folders.
you can:
* create separate security groups containing the various teams of
developers
* create the various target folders on the report server
* assign the pertinent security group to the 'Content Manager' role
(using Report Manager is the easiest way to do this)
the above assumes all users are in a single domain and that you have
the ability to create groups. if not, you can use report manager once
again to create the folders and then add each developer individually to
the content manager role.
> Also how do I set VS.NET to deploy a specifc sub folder.
once you have created a BI project in the VS designer, you right-click
the project and select properties. from there, you can figure the
appropriate subfolder to deploy to, as well as the target server.
hope this helps.
cheers,
~stuart|||John H. Miller:
> You can't deploy to a SubFolder in RS2K. Deployment from VS takes
> your project name and uses it when you deploy. Only get one level.
Jake Marx:
<< I don't think that's correct, John. I am able to deploy to any
folder I
want in RS2K (SP1) by setting the TargetFolder property under
Deployment in
the project's Property Pages. >>
Jake is correct. You can set the targetfolder property to be
arbitrarily deep. if the directory structure doesn't exist, it will be
created on the first deploy.
I need to find out the best practices approach for user configuration in SQL
Reporting Services. I have teams of developers, who would be using VS.NET
development and deploying using VS.NET. Whats the best approach I could take
for development...Ideally I would like each team of users to have a folder
and so that they could deploy the reports only to those folders. Also how do
I set VS.NET to deploy a specifc sub folder.
Any thoughts or suggestions would be of good help.
Thanks,
ChrisYou can't deploy to a SubFolder in RS2K. Deployment from VS takes your
project name and uses it when you deploy. Only get one level.
There is a My Report folder you can turn on using the Report Manager under
system settings, but not sure that'll help you solve the problem you've
described.
If you need more, most straight forward approach is to go into Report
Manager after you deploy and move things around. Either that or use Report
Manager to 1st create the directory structure (folders / subfolders)
desired, then as Content Manager use the Upload File button on the tool bar
from within the subfolder to upload your reports.
If you find this to be burdensome, perhaps consider creating a VB script
like the one at
http://msdn.microsoft.com/library/en-us/rsamples/htm/rss_sampleapps_v1_1apd.asp
to automate the deployment process. Note, you could also do this
programmatically using the RS2K SOAP API. Perhaps as a program or daemon
that traverses a directory structure looking for .rdl files and then creates
the equivalent folders in RS to upload the reports to.
--
-- "This posting is provided 'AS IS' with no warranties, and confers no
rights."
jhmiller@.online.microsoft.com
"Christopher Pragash" <chrispragash@.hotmail.com> wrote in message
news:uyCnuc6mEHA.1304@.TK2MSFTNGP09.phx.gbl...
> Hello All,
> I need to find out the best practices approach for user configuration in
> SQL
> Reporting Services. I have teams of developers, who would be using VS.NET
> development and deploying using VS.NET. Whats the best approach I could
> take
> for development...Ideally I would like each team of users to have a folder
> and so that they could deploy the reports only to those folders. Also how
> do
> I set VS.NET to deploy a specifc sub folder.
> Any thoughts or suggestions would be of good help.
> Thanks,
> Chris
>|||John H. Miller wrote:
> You can't deploy to a SubFolder in RS2K. Deployment from VS takes
> your project name and uses it when you deploy. Only get one level.
I don't think that's correct, John. I am able to deploy to any folder I
want in RS2K (SP1) by setting the TargetFolder property under Deployment in
the project's Property Pages.
I would think Chris could set up a separate folder for each developer and
set up permissions that allow a developer to publish only to his/her own
folder. Each developer would simply set the TargetFolder to the virtual
path to his/her folder.
--
Regards,
Jake Marx
MS MVP - Excel
www.longhead.com
[please keep replies in the newsgroup - email address unmonitored]|||Christopher Pragash wrote:
> Hello All,
> I need to find out the best practices approach for user configuration
in SQL
> Reporting Services. I have teams of developers, who would be using
VS.NET
> development and deploying using VS.NET. Whats the best approach I
could take
> for development...Ideally I would like each team of users to have a
folder
> and so that they could deploy the reports only to those folders.
you can:
* create separate security groups containing the various teams of
developers
* create the various target folders on the report server
* assign the pertinent security group to the 'Content Manager' role
(using Report Manager is the easiest way to do this)
the above assumes all users are in a single domain and that you have
the ability to create groups. if not, you can use report manager once
again to create the folders and then add each developer individually to
the content manager role.
> Also how do I set VS.NET to deploy a specifc sub folder.
once you have created a BI project in the VS designer, you right-click
the project and select properties. from there, you can figure the
appropriate subfolder to deploy to, as well as the target server.
hope this helps.
cheers,
~stuart|||John H. Miller:
> You can't deploy to a SubFolder in RS2K. Deployment from VS takes
> your project name and uses it when you deploy. Only get one level.
Jake Marx:
<< I don't think that's correct, John. I am able to deploy to any
folder I
want in RS2K (SP1) by setting the TargetFolder property under
Deployment in
the project's Property Pages. >>
Jake is correct. You can set the targetfolder property to be
arbitrarily deep. if the directory structure doesn't exist, it will be
created on the first deploy.
Friday, 10 February 2012
Configure Reporting Services
Specs
Server 2000, IIS5, .Net 2, .Net 1.1, SQL Server 2005 Developers Edition
Unable to set Web Service Identity
Web Service Identity is blank, have set
rsreportserver.config to include
<WebServiceAccount>ASPNET</WebServiceAccount>
Also tried
<WebServiceAccount>./ASPNET</WebServiceAccount>
but none seem to work?
The service is inistialized, but I cannont go to /reports or /reportmanager
when I apply on the blank entry in theReporting Services configration, I
receive this error:
ReportServicesConfigUI.WMIProvider.WMIProviderException: An unknown error
has occurred in the WMI Provider. Error Code 80070005
at
ReportServicesConfigUI.WMIProvider.RSReportServerAdmin.SetWebServiceIdentity(String applicationPool)
please helpFacing the same problem. I've the same configuration and got same error. any
luck?
"GregCrossan" wrote:
> Specs
> Server 2000, IIS5, .Net 2, .Net 1.1, SQL Server 2005 Developers Edition
> Unable to set Web Service Identity
> Web Service Identity is blank, have set
> rsreportserver.config to include
> <WebServiceAccount>ASPNET</WebServiceAccount>
> Also tried
> <WebServiceAccount>./ASPNET</WebServiceAccount>
> but none seem to work?
> The service is inistialized, but I cannont go to /reports or /reportmanager
> when I apply on the blank entry in theReporting Services configration, I
> receive this error:
> ReportServicesConfigUI.WMIProvider.WMIProviderException: An unknown error
> has occurred in the WMI Provider. Error Code 80070005
> at
> ReportServicesConfigUI.WMIProvider.RSReportServerAdmin.SetWebServiceIdentity(String applicationPool)
>
> please help|||Make that three of us.
I've tried:
uninstalling & reinstalling IIS,
reconfiguring Reporting Services,
re-registering asp.net
(C:\WINNT\Microsoft.NET\Framework\v2.0.50727\aspnet_regiis -i)
Any suggestions?
--
Clayton
"samjay" wrote:
> Facing the same problem. I've the same configuration and got same error. any
> luck?
> "GregCrossan" wrote:
> > Specs
> > Server 2000, IIS5, .Net 2, .Net 1.1, SQL Server 2005 Developers Edition
> >
> > Unable to set Web Service Identity
> >
> > Web Service Identity is blank, have set
> > rsreportserver.config to include
> > <WebServiceAccount>ASPNET</WebServiceAccount>
> > Also tried
> > <WebServiceAccount>./ASPNET</WebServiceAccount>
> >
> > but none seem to work?
> >
> > The service is inistialized, but I cannont go to /reports or /reportmanager
> >
> > when I apply on the blank entry in theReporting Services configration, I
> > receive this error:
> > ReportServicesConfigUI.WMIProvider.WMIProviderException: An unknown error
> > has occurred in the WMI Provider. Error Code 80070005
> > at
> > ReportServicesConfigUI.WMIProvider.RSReportServerAdmin.SetWebServiceIdentity(String applicationPool)
> >
> >
> >
> > please help|||Hey all, just curious if any of you got this figured out. We all seem
to have the same problem.
Chris
Server 2000, IIS5, .Net 2, .Net 1.1, SQL Server 2005 Developers Edition
Unable to set Web Service Identity
Web Service Identity is blank, have set
rsreportserver.config to include
<WebServiceAccount>ASPNET</WebServiceAccount>
Also tried
<WebServiceAccount>./ASPNET</WebServiceAccount>
but none seem to work?
The service is inistialized, but I cannont go to /reports or /reportmanager
when I apply on the blank entry in theReporting Services configration, I
receive this error:
ReportServicesConfigUI.WMIProvider.WMIProviderException: An unknown error
has occurred in the WMI Provider. Error Code 80070005
at
ReportServicesConfigUI.WMIProvider.RSReportServerAdmin.SetWebServiceIdentity(String applicationPool)
please helpFacing the same problem. I've the same configuration and got same error. any
luck?
"GregCrossan" wrote:
> Specs
> Server 2000, IIS5, .Net 2, .Net 1.1, SQL Server 2005 Developers Edition
> Unable to set Web Service Identity
> Web Service Identity is blank, have set
> rsreportserver.config to include
> <WebServiceAccount>ASPNET</WebServiceAccount>
> Also tried
> <WebServiceAccount>./ASPNET</WebServiceAccount>
> but none seem to work?
> The service is inistialized, but I cannont go to /reports or /reportmanager
> when I apply on the blank entry in theReporting Services configration, I
> receive this error:
> ReportServicesConfigUI.WMIProvider.WMIProviderException: An unknown error
> has occurred in the WMI Provider. Error Code 80070005
> at
> ReportServicesConfigUI.WMIProvider.RSReportServerAdmin.SetWebServiceIdentity(String applicationPool)
>
> please help|||Make that three of us.
I've tried:
uninstalling & reinstalling IIS,
reconfiguring Reporting Services,
re-registering asp.net
(C:\WINNT\Microsoft.NET\Framework\v2.0.50727\aspnet_regiis -i)
Any suggestions?
--
Clayton
"samjay" wrote:
> Facing the same problem. I've the same configuration and got same error. any
> luck?
> "GregCrossan" wrote:
> > Specs
> > Server 2000, IIS5, .Net 2, .Net 1.1, SQL Server 2005 Developers Edition
> >
> > Unable to set Web Service Identity
> >
> > Web Service Identity is blank, have set
> > rsreportserver.config to include
> > <WebServiceAccount>ASPNET</WebServiceAccount>
> > Also tried
> > <WebServiceAccount>./ASPNET</WebServiceAccount>
> >
> > but none seem to work?
> >
> > The service is inistialized, but I cannont go to /reports or /reportmanager
> >
> > when I apply on the blank entry in theReporting Services configration, I
> > receive this error:
> > ReportServicesConfigUI.WMIProvider.WMIProviderException: An unknown error
> > has occurred in the WMI Provider. Error Code 80070005
> > at
> > ReportServicesConfigUI.WMIProvider.RSReportServerAdmin.SetWebServiceIdentity(String applicationPool)
> >
> >
> >
> > please help|||Hey all, just curious if any of you got this figured out. We all seem
to have the same problem.
Chris
Configure Report Server - Web Service Identity
Windows 2000 Server / IIS 5 / SQL Server 2005 Developers Edition / .Net 2.0 and .Net 1.1
When I attempt to configure the Report Server, I cannot configure the Web Service Identity, the ASP.NET service account shows blank. I have attempted to edit the rsreportserver.config file, as follows:
<WebServiceAccount>.\ASPNET</WebServiceAccount>
This (stop / start of course). But this only causes the Report Server to not start. If I leave that sectopn blank, the service starts, but I cannot access /Reports...
If I attempt to apply with that sectikon left blank I receive this error:
ReportServicesConfigUI.WMIProvider.WMIProviderException: An unknown error has occurred in the WMI Provider. Error Code 80070005
at ReportServicesConfigUI.WMIProvider.RSReportServerAdmin.SetWebServiceIdentity(String applicationPool)
Please help
On Win2K, the actual ASP.NET account is read from machine.config file at /configuration/system.web/processModel/username. Do you have it set? If not run "aspnet_regiis -i -enable".|||the machine config section is as follows for our setup....
<system.web>
<processModel autoConfig="true"/>
<httpHandlers />
Thanks for your help.. feels like i am getting closer
Subscribe to:
Posts (Atom)