Wednesday, March 28, 2012
Report Designer - deploying to a specific directory
specify the directory on the RS server that each SPECIFIC report is to be
deployed to? I know that the report project has a "Deployment Folder"
property but that is project-wide. We want to do it for each specific
report. Do I need separate projects for multiple folders?
thanksUnfortunately, you can only designate one folder per solution currently. A
possible alternative is to use an rs script to publish them to desired
folders. See
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rsamples/htm/rss_sampleapps_v1_1apd.asp
for an example.
--
-- "This posting is provided 'AS IS' with no warranties, and confers no
rights."
jhmiller@.online.microsoft.com
"ISGADMIN" <isgadmin@.newsgroup.nospam> wrote in message
news:BB9F0755-7F44-4507-B86F-B8691615BE59@.microsoft.com...
> Hi - When creating a report without using the report wizard, how does one
> specify the directory on the RS server that each SPECIFIC report is to be
> deployed to? I know that the report project has a "Deployment Folder"
> property but that is project-wide. We want to do it for each specific
> report. Do I need separate projects for multiple folders?
> thanks|||Just a slight correction, you specify per project, not per solution.
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"John H. Miller" <jhmiller@.online.microsoft.com> wrote in message
news:41813be2$1@.news.microsoft.com...
> Unfortunately, you can only designate one folder per solution currently.
A
> possible alternative is to use an rs script to publish them to desired
> folders. See
>
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rsamples/htm/rss_sampleapps_v1_1apd.asp
> for an example.
> --
> -- "This posting is provided 'AS IS' with no warranties, and confers no
> rights."
> jhmiller@.online.microsoft.com
> "ISGADMIN" <isgadmin@.newsgroup.nospam> wrote in message
> news:BB9F0755-7F44-4507-B86F-B8691615BE59@.microsoft.com...
> > Hi - When creating a report without using the report wizard, how does
one
> > specify the directory on the RS server that each SPECIFIC report is to
be
> > deployed to? I know that the report project has a "Deployment Folder"
> > property but that is project-wide. We want to do it for each specific
> > report. Do I need separate projects for multiple folders?
> >
> > thanks
>|||Yes - thanks Bruce! It is per project.
--
-- "This posting is provided 'AS IS' with no warranties, and confers no
rights."
jhmiller@.online.microsoft.com
"Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
news:usX7J6RvEHA.1984@.TK2MSFTNGP14.phx.gbl...
> Just a slight correction, you specify per project, not per solution.
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "John H. Miller" <jhmiller@.online.microsoft.com> wrote in message
> news:41813be2$1@.news.microsoft.com...
>> Unfortunately, you can only designate one folder per solution currently.
> A
>> possible alternative is to use an rs script to publish them to desired
>> folders. See
> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rsamples/htm/rss_sampleapps_v1_1apd.asp
>> for an example.
>> --
>> -- "This posting is provided 'AS IS' with no warranties, and confers
>> no
>> rights."
>> jhmiller@.online.microsoft.com
>> "ISGADMIN" <isgadmin@.newsgroup.nospam> wrote in message
>> news:BB9F0755-7F44-4507-B86F-B8691615BE59@.microsoft.com...
>> > Hi - When creating a report without using the report wizard, how does
> one
>> > specify the directory on the RS server that each SPECIFIC report is to
> be
>> > deployed to? I know that the report project has a "Deployment Folder"
>> > property but that is project-wide. We want to do it for each specific
>> > report. Do I need separate projects for multiple folders?
>> >
>> > thanks
>>
>|||Hi John, thanks much for the info.
Matt
"John H. Miller" wrote:
> Unfortunately, you can only designate one folder per solution currently. A
> possible alternative is to use an rs script to publish them to desired
> folders. See
> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rsamples/htm/rss_sampleapps_v1_1apd.asp
> for an example.
> --
> -- "This posting is provided 'AS IS' with no warranties, and confers no
> rights."
> jhmiller@.online.microsoft.com
> "ISGADMIN" <isgadmin@.newsgroup.nospam> wrote in message
> news:BB9F0755-7F44-4507-B86F-B8691615BE59@.microsoft.com...
> > Hi - When creating a report without using the report wizard, how does one
> > specify the directory on the RS server that each SPECIFIC report is to be
> > deployed to? I know that the report project has a "Deployment Folder"
> > property but that is project-wide. We want to do it for each specific
> > report. Do I need separate projects for multiple folders?
> >
> > thanks
>
>
Monday, March 26, 2012
Report Delivery -- HELP
Tuesday, February 21, 2012
reply
I am not using the SA account when I log in using windows authentication it seems to pick up my domain and active directory ID which is "us\app1dxd" it appears greyed out as well as the password on the login screen so you can't change it.
If you go into the management studio and right click on the server name in the left hand pane go to properties security the radio button for sql server and Windows authentication mode is selected.
It is normal because the BOL says if you install SQL Server with Windows Authentication the sa account gets disabled, the account remains disabled even when you change to mixed authentication you have to enable the account after changing to mixed authentication.
http://msdn2.microsoft.com/en-us/library/ms144284.aspx