active x control

My computer said; your current security settings prohibit
running active x controls on this page. As a result this
page my not show right. Thank YouThis is a SQL Server newsgroup so it's not really the best
place to post this message. If you are using Internet
Explorer, you may want to post ot the newsgroups for
Internet Explorer issues.
It's not clear what exactly your question is but in Internet
Explorer, the settings for this can be accessed by right
clicking on Internet Explorer, select properties. Go to the
Security tab, select the security zone context you are
operating in when receiving the message and then select
Custom Level.
-Sue
On Fri, 28 May 2004 11:28:32 -0700, "Vicki"
<anonymous@.discussions.microsoft.com> wrote:

>My computer said; your current security settings prohibit
>running active x controls on this page. As a result this
>page my not show right. Thank You

Active directory Update

Hi!
I want to write a trigger that add a new computer account in my active directory when I do an Insert in my MSSQL table.

I know how to use SELECTstatements using LDAP but I want to do a INSERT statement. Is that even possible?
Can you write vb code directly in SP i mssql 2000?

What I think I have to do is to have a vbscript that does the adding then call the script using exetended SP cmd execute passing the name to the script.

If someone has a another solutions please let me know!

Regards..I've written simple ActiveX out-of-process OLE servers using VB. This is not hard to do. But I think you're going from the wrong direction. I'd rather add a computer account using LDAP from my VB code and then fire a stored procedure to update whatever you want to update. The other way around is possible too, but it doesn't make it easier, not does it make it right either.

accing to shered volumes

Roy Goldhammer wrote:
> Hello there
> I have local hard drive, which i can easy run xp_cmdshell 'dir c:'
> On the same computer i have shered Z: volume which is hard drive on anothe
r
> server
> How can i get list of all files on z by using xp_cmdshell 'dir z:' ?
>
xp_cmdshell '\\servername\sharename'
The mapping to drive Z: only exists under your login, not under the
login that the SQL Server service runs under. You also need to make
sure that the SQL Server service account has access to the share.Hello there
I have local hard drive, which i can easy run xp_cmdshell 'dir c:\'
On the same computer i have shered Z: volume which is hard drive on another
server
How can i get list of all files on z by using xp_cmdshell 'dir z:' ?|||Roy Goldhammer wrote:
> Hello there
> I have local hard drive, which i can easy run xp_cmdshell 'dir c:'
> On the same computer i have shered Z: volume which is hard drive on anothe
r
> server
> How can i get list of all files on z by using xp_cmdshell 'dir z:' ?
>
xp_cmdshell '\\servername\sharename'
The mapping to drive Z: only exists under your login, not under the
login that the SQL Server service runs under. You also need to make
sure that the SQL Server service account has access to the share.

accing to shered volumes

Hello there
I have local hard drive, which i can easy run xp_cmdshell 'dir c:\'
On the same computer i have shered Z: volume which is hard drive on another
server
How can i get list of all files on z by using xp_cmdshell 'dir z:' ?Roy Goldhammer wrote:
> Hello there
> I have local hard drive, which i can easy run xp_cmdshell 'dir c:\'
> On the same computer i have shered Z: volume which is hard drive on another
> server
> How can i get list of all files on z by using xp_cmdshell 'dir z:' ?
>
xp_cmdshell '\\servername\sharename'
The mapping to drive Z: only exists under your login, not under the
login that the SQL Server service runs under. You also need to make
sure that the SQL Server service account has access to the share.

accing shered volume

Hello there
I have local hard drive, which i can easy run xp_cmdshell 'dir c:\'
On the same computer i have shered Z: volume which is hard drive on another
server
How can i get list of all files on z by using xp_cmdshell 'dir z:' ?What account is SQL Server running as? It must have permissions to the Z:\
(typically this means you must set up SQLServer to run as a Domain\User as
opposed to a local user or built-in account).
"Roy Goldhammer" <roy@.hotmail.com> wrote in message
news:eXbwFn7kGHA.3816@.TK2MSFTNGP02.phx.gbl...
> Hello there
> I have local hard drive, which i can easy run xp_cmdshell 'dir c:'
> On the same computer i have shered Z: volume which is hard drive on
> another
> server
> How can i get list of all files on z by using xp_cmdshell 'dir z:' ?
>
>

Accessing Reports through Internet

Hi,
is it possible to put a Report Server on a computer inside a DMZ and the
SQL-Server 2005 in the secure area?
For simplicity we want to use two or three local windows-system accounts to
log in through a web browser to the Report Manager (authentication via IIS
on the computer with the ReportServer). Then we want the reports to use
datasources behind the firewall with stored
credentials. Is this scenario possible? Are there any drawbacks?Did you able to make this architecture work? I am also having the same
situation.
"Ralph Watermann" wrote:
> Hi,
> is it possible to put a Report Server on a computer inside a DMZ and the
> SQL-Server 2005 in the secure area?
> For simplicity we want to use two or three local windows-system accounts to
> log in through a web browser to the Report Manager (authentication via IIS
> on the computer with the ReportServer). Then we want the reports to use
> datasources behind the firewall with stored
> credentials. Is this scenario possible? Are there any drawbacks?
>
>
>|||Hi,
As indicated by MS, this should works. But practical speaking, you'll face
at least 2 no go issues:
1. Your window credential will not be authenticated as the RS server in DMZ,
which means RS server and user are not in same domain and they don't trusted
each other.
2. The RS server can't be setup. RS server in DMZ, and SQL in secure zone
means they're in different domain. They will not trust each other thus not
way you can run the setup.
regards,
Joe
"Nanda Sundaresan" wrote:
> Did you able to make this architecture work? I am also having the same
> situation.
> "Ralph Watermann" wrote:
> > Hi,
> >
> > is it possible to put a Report Server on a computer inside a DMZ and the
> > SQL-Server 2005 in the secure area?
> >
> > For simplicity we want to use two or three local windows-system accounts to
> > log in through a web browser to the Report Manager (authentication via IIS
> > on the computer with the ReportServer). Then we want the reports to use
> > datasources behind the firewall with stored
> > credentials. Is this scenario possible? Are there any drawbacks?
> >
> >
> >
> >
> >