xp_cmdshell no longer allowing remote access

> We can no longer execute this command remotely.

What error message are you getting?

Linchi

"Jeff D" wrote:

> Howdy
>
> We have a SQL 2005 database on Windows Server 2003 being accessed through
> IIS.
>
> We execute a script using the "Exec xp_cmdshell TheScript" command from a
> web page.
>
> We can no longer execute this command remotely.
>
> I am aware of the new setting for SQL 2005 that must be turned on before
> able to execute xp_cmdshell and
> this value is still turned on.
>
> Does anyone know of a windows update that may have changed this ?
>
> Thanks
>
>
>
>
 >> Stay informed about: xp_cmdshell no longer allowing remote access 

Just so everyone knows the status of this.

It was found that someone changed the user rights on SQL Server for the user
being used. Something simple. But no one was acknowledging they had made
a change. And this occurred on a dedicated hosted server! Why someone
who is hosting the service would make a change like this is beyond me.
But never the less, it can happen and did.

Problem solved.


"Jeff D" wrote in message

> Howdy
>
> We have a SQL 2005 database on Windows Server 2003 being accessed through
> IIS.
>
> We execute a script using the "Exec xp_cmdshell TheScript" command from a
> web page.
>
> We can no longer execute this command remotely.
>
> I am aware of the new setting for SQL 2005 that must be turned on before
> able to execute xp_cmdshell and
> this value is still turned on.
>
> Does anyone know of a windows update that may have changed this ?
>
> Thanks
>
>
>
 >> Stay informed about: xp_cmdshell no longer allowing remote access