Installation directories

I have noticed that the directory path to the "executables" for reporting
services is different on different computers.
on one computer it is
C:\program files\Microsoft SQL Server\MSSQL.3\Reporting
Services\ReportServer\bin
and on another it is
C:\program files\Microsoft SQL Server\MSSQL.2\Reporting
Services\ReportServer\bin
So. one is under "MSSQL.2" and the other is under "MSSQL.3"
Why would this be the case?
I want to setup a vbscript to deploy my own assemblies and I need to copy
them to the appropriate location
How do I determine the location where they should be copied to?
Thanks
BobOn Mar 27, 6:21 pm, "Bob" <some...@.microsoft.com> wrote:
> I have noticed that the directory path to the "executables" for reporting
> services is different on different computers.
> on one computer it is
> C:\program files\Microsoft SQL Server\MSSQL.3\Reporting
> Services\ReportServer\bin
> and on another it is
> C:\program files\Microsoft SQL Server\MSSQL.2\Reporting
> Services\ReportServer\bin
> So. one is under "MSSQL.2" and the other is under "MSSQL.3"
> Why would this be the case?
> I want to setup a vbscript to deploy my own assemblies and I need to copy
> them to the appropriate location
> How do I determine the location where they should be copied to?
> Thanks
> Bob
Don't quote me on this; but, I believe it's based on how many SQL
Server services you install on your system. So if you install Analysis
Services, etc your MSSQL folder might be a different one for SSRS,
etc.
Regards,
Enrique Martinez
Sr. Software Consultant|||"EMartinez" <emartinez.pr1@.gmail.com> wrote in message
news:1175049750.874707.272910@.n76g2000hsh.googlegroups.com...
> On Mar 27, 6:21 pm, "Bob" <some...@.microsoft.com> wrote:
>> I have noticed that the directory path to the "executables" for reporting
>> services is different on different computers.
>> on one computer it is
>> C:\program files\Microsoft SQL Server\MSSQL.3\Reporting
>> Services\ReportServer\bin
>> and on another it is
>> C:\program files\Microsoft SQL Server\MSSQL.2\Reporting
>> Services\ReportServer\bin
>> So. one is under "MSSQL.2" and the other is under "MSSQL.3"
>> Why would this be the case?
>> I want to setup a vbscript to deploy my own assemblies and I need to copy
>> them to the appropriate location
>> How do I determine the location where they should be copied to?
>> Thanks
>> Bob
>
> Don't quote me on this; but, I believe it's based on how many SQL
> Server services you install on your system. So if you install Analysis
> Services, etc your MSSQL folder might be a different one for SSRS,
> etc.
> Regards,
> Enrique Martinez
> Sr. Software Consultant
>
Thanks Enrique,
I sort of guessed that. This particualr server had the SQL database
instaled on it, and then several weeks later I installed Reporting Services.
If I now install OLAP services I suspect that I will get the ".3" directory.
If all services had been installed at one time then the direcories would be
.1 = SQL databse
.2 = OLAP
.3 = Reporting Services
but instead I have
.1 = SQL Database
.2 = reporting Services
.3 = would be OLAP
My question really is "how do I detect (using a script) which directory
contains Reporting Services" ?
Cheers|||On Mar 27, 10:17 pm, "Bob" <some...@.microsoft.com> wrote:
> "EMartinez" <emartinez...@.gmail.com> wrote in message
> news:1175049750.874707.272910@.n76g2000hsh.googlegroups.com...
>
> > On Mar 27, 6:21 pm, "Bob" <some...@.microsoft.com> wrote:
> >> I have noticed that the directory path to the "executables" for reporting
> >> services is different on different computers.
> >> on one computer it is
> >> C:\program files\Microsoft SQL Server\MSSQL.3\Reporting
> >> Services\ReportServer\bin
> >> and on another it is
> >> C:\program files\Microsoft SQL Server\MSSQL.2\Reporting
> >> Services\ReportServer\bin
> >> So. one is under "MSSQL.2" and the other is under "MSSQL.3"
> >> Why would this be the case?
> >> I want to setup a vbscript to deploy my own assemblies and I need to copy
> >> them to the appropriate location
> >> How do I determine the location where they should be copied to?
> >> Thanks
> >> Bob
> > Don't quote me on this; but, I believe it's based on how many SQL
> > Server services you install on your system. So if you install Analysis
> > Services, etc your MSSQL folder might be a different one for SSRS,
> > etc.
> > Regards,
> > Enrique Martinez
> > Sr. Software Consultant
> Thanks Enrique,
> I sort of guessed that. This particualr server had the SQL database
> instaled on it, and then several weeks later I installed Reporting Services.
> If I now install OLAP services I suspect that I will get the ".3" directory.
> If all services had been installed at one time then the direcories would be
> .1 = SQL databse
> .2 = OLAP
> .3 = Reporting Services
> but instead I have
> .1 = SQL Database
> .2 = reporting Services
> .3 = would be OLAP
> My question really is "how do I detect (using a script) which directory
> contains Reporting Services" ?
> Cheers
You might want to loop through the folders at the dos command (via
OSQL or xp_cmdshell) and try to find a folder like ReportingServices.
Hope this helps.
Regards,
Enrique Martinez
Sr. Software Consultant|||"EMartinez" <emartinez.pr1@.gmail.com> wrote in message
news:1175054192.210026.261520@.p15g2000hsd.googlegroups.com...
> On Mar 27, 10:17 pm, "Bob" <some...@.microsoft.com> wrote:
>> "EMartinez" <emartinez...@.gmail.com> wrote in message
>> news:1175049750.874707.272910@.n76g2000hsh.googlegroups.com...
>>
>> > On Mar 27, 6:21 pm, "Bob" <some...@.microsoft.com> wrote:
>> >> I have noticed that the directory path to the "executables" for
>> >> reporting
>> >> services is different on different computers.
>> >> on one computer it is
>> >> C:\program files\Microsoft SQL Server\MSSQL.3\Reporting
>> >> Services\ReportServer\bin
>> >> and on another it is
>> >> C:\program files\Microsoft SQL Server\MSSQL.2\Reporting
>> >> Services\ReportServer\bin
>> >> So. one is under "MSSQL.2" and the other is under "MSSQL.3"
>> >> Why would this be the case?
>> >> I want to setup a vbscript to deploy my own assemblies and I need to
>> >> copy
>> >> them to the appropriate location
>> >> How do I determine the location where they should be copied to?
>> >> Thanks
>> >> Bob
>> > Don't quote me on this; but, I believe it's based on how many SQL
>> > Server services you install on your system. So if you install Analysis
>> > Services, etc your MSSQL folder might be a different one for SSRS,
>> > etc.
>> > Regards,
>> > Enrique Martinez
>> > Sr. Software Consultant
>> Thanks Enrique,
>> I sort of guessed that. This particualr server had the SQL database
>> instaled on it, and then several weeks later I installed Reporting
>> Services.
>> If I now install OLAP services I suspect that I will get the ".3"
>> directory.
>> If all services had been installed at one time then the direcories would
>> be
>> .1 = SQL databse
>> .2 = OLAP
>> .3 = Reporting Services
>> but instead I have
>> .1 = SQL Database
>> .2 = reporting Services
>> .3 = would be OLAP
>> My question really is "how do I detect (using a script) which directory
>> contains Reporting Services" ?
>> Cheers
> You might want to loop through the folders at the dos command (via
> OSQL or xp_cmdshell) and try to find a folder like ReportingServices.
> Hope this helps.
> Regards,
> Enrique Martinez
> Sr. Software Consultant
>
Enrique,
I have written a vbs file to do just this, but then I got to thinking "How
does SSRS know where to find its binaries and how does the Service Pack
process know where to update them?"
Cheers
Bob