Install path SQL Enterprise Manager

Hi,

We want to install SQL Enterprise Manager on a seperate server. Our provider for this server requires us to install SQL EM on a non-default drive/path, d:\programs. How can I achieve this?

TIA,

Wim

Run the setup.bat file from the SQL Server installation CD, and select Install Client components, and you can specify where you want the programs installed.|||

Looks like this works for 2005. However we want to use 2000. My mistake, should have mentioned this.

We already looked quite extensively on the CD but could not find any clues for resolving this. Does anyone have an idea?

It could be that Enterprise Manager 2000 is not meant to be installed seperately from SQL Server 2000. Can anyone say anything about this?

TIA,

Wim.

Install Path

I need to be able to look up the install path for sql from within a DTS
package. The registry reading stored procs have been deleted for 'security'
but I need to make sure that SQL Agent has full access to the directory for a
temp file. It would be ideal to get the install path and use that. This DTS
will be installed an mulitple instances so I would like to automate this.
Thom,
Maybe REGEDT32 and look for SQLPath?
HTH
Jerry
"Thom" <Thom@.discussions.microsoft.com> wrote in message
news:7A48EA99-65D1-4ECF-B996-84191EF2DA64@.microsoft.com...
>I need to be able to look up the install path for sql from within a DTS
> package. The registry reading stored procs have been deleted for
> 'security'
> but I need to make sure that SQL Agent has full access to the directory
> for a
> temp file. It would be ideal to get the install path and use that. This
> DTS
> will be installed an mulitple instances so I would like to automate this.

Install Path

I need to be able to look up the install path for sql from within a DTS
package. The registry reading stored procs have been deleted for 'security'
but I need to make sure that SQL Agent has full access to the directory for a
temp file. It would be ideal to get the install path and use that. This DTS
will be installed an mulitple instances so I would like to automate this.Thom,
Maybe REGEDT32 and look for SQLPath?
HTH
Jerry
"Thom" <Thom@.discussions.microsoft.com> wrote in message
news:7A48EA99-65D1-4ECF-B996-84191EF2DA64@.microsoft.com...
>I need to be able to look up the install path for sql from within a DTS
> package. The registry reading stored procs have been deleted for
> 'security'
> but I need to make sure that SQL Agent has full access to the directory
> for a
> temp file. It would be ideal to get the install path and use that. This
> DTS
> will be installed an mulitple instances so I would like to automate this.

Install Path

I need to be able to look up the install path for sql from within a DTS
package. The registry reading stored procs have been deleted for 'security'
but I need to make sure that SQL Agent has full access to the directory for
a
temp file. It would be ideal to get the install path and use that. This DT
S
will be installed an mulitple instances so I would like to automate this.Thom,
Maybe REGEDT32 and look for SQLPath?
HTH
Jerry
"Thom" <Thom@.discussions.microsoft.com> wrote in message
news:7A48EA99-65D1-4ECF-B996-84191EF2DA64@.microsoft.com...
>I need to be able to look up the install path for sql from within a DTS
> package. The registry reading stored procs have been deleted for
> 'security'
> but I need to make sure that SQL Agent has full access to the directory
> for a
> temp file. It would be ideal to get the install path and use that. This
> DTS
> will be installed an mulitple instances so I would like to automate this.sql

Install fails with a "..path specified...is invalid"

After running through all the pre-install questions, it begins by saying that
it is performing operations on the cluster nodes and then fails with the
message:
"The path specified in a command line argument is invalid:
\\<servername>\admin$\<servername>_MSSQLSERVER.iss "
Any thoughts?
Either the administrative shares have been disabled or you are running under
an account that does not have access to the administrative shares on all
nodes of the cluster.
Sincerely,
Anthony Thomas

"Isaac Story" <IsaacStory@.discussions.microsoft.com> wrote in message
news:7FCDAF81-7BCF-4E99-9A74-5F564D090E63@.microsoft.com...
> After running through all the pre-install questions, it begins by saying
that
> it is performing operations on the cluster nodes and then fails with the
> message:
> "The path specified in a command line argument is invalid:
> \\<servername>\admin$\<servername>_MSSQLSERVER.iss "
> Any thoughts?
|||Actually I found the problem in a KB article. I had Terminal Services
installed on two of the nodes. SQL Clustering cannot be installed on a node
or nodes that have terminal services installed. Just thought I would post
that for anyone else how might run across the same problem.
"Anthony Thomas" wrote:

> Either the administrative shares have been disabled or you are running under
> an account that does not have access to the administrative shares on all
> nodes of the cluster.
> Sincerely,
>
> Anthony Thomas
>
> --
> "Isaac Story" <IsaacStory@.discussions.microsoft.com> wrote in message
> news:7FCDAF81-7BCF-4E99-9A74-5F564D090E63@.microsoft.com...
> that
>
>

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

inserting video from sql into embedded media

Hi i have a video file path stored in my sql database and i have an embedded media player in my web page, how can i load up a different video file into the embedded media player based on movie id or movie name, this is the code i have written so far but im unsure if im in the right direction, thanks

sorry this is the code

<

formid="form1"runat="server"><palign="center"><OBJECTID="Player"

CLASSID

="CLSID:6BF52A52-394A-11d3-B153-00C04F79FAA6"

VIEWASTEXT

><PARAMname="autoStart"value="True"><PARAMname="URL"value="<%# Eval("MovieFile") %>"><PARAMname="rate"value="1"><PARAMname="balance"value="0"><PARAMname="enabled"value="true"><PARAMname="enabledContextMenu"value="true"><PARAMname="fullScreen"value="false"><PARAMname="playCount"value="1"><PARAMname="volume"value="100">

</

OBJECT></p>

|||

Hi Peter,

Naturally, you can pass the value from database to the url attribute of the object. And about the usage of ActiveX controls from Internet Explorer, you may refer the following kb article:

http://support.microsoft.com/kb/555687

If this does not help you,pls feel free to mark the post as Not Answered and reply.

Thanks.