Re: SQLSAC command line parameters?
- From: "Dan Guzman" <guzmanda@xxxxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Wed, 18 Jan 2006 06:08:27 -0600
>I would like to disable named pipes & tcp/ip in sql 2005 in an automated
> fashion (either through sqlsac.exe, programatically, or some other silent
> fashion).
The command-line utility is SAC.EXE. You might try the 'in' or 'out'
positional parameter to import/export SAC settings. I haven't tried it
myself but it looks like that should address your requirements. The
parameters are described in the Books Online.
--
Hope this helps.
Dan Guzman
SQL Server MVP
"John Waters" <JohnWaters@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:79C62799-EFAC-4B88-A8DB-6BF392D249F2@xxxxxxxxxxxxxxxx
>I would like to disable named pipes & tcp/ip in sql 2005 in an automated
> fashion (either through sqlsac.exe, programatically, or some other silent
> fashion).
>
> It appears that the SQL Surface Area Configuration tool accepts some
> command
> line parameters; for example, if i run SQLSAC.exe ServerA, it will prompt
> me
> to configure the surface area for ServerA, instead of the local machine.
> I
> imagine that there are others, although I have not been able to find these
> in
> books online.
>
> In SQL 2000, I was able to do disable protocols by writing a null value to
> HKLM\SOFTWARE\Microsoft\MSSQLServer\MSSQLServer\SuperSocketNetLib ;
> however,
> if I do this in SQL 2005, I can no longer connect via SQLOLEDB until i
> recycle SQL & it re-writes the regkey.
>
> Any thoughts or suggestions would be appreciated.
.
- Prev by Date: Re: Remote SP debugging from VS 2003: error
- Next by Date: Re: Duplicating existing logins to a different domain
- Previous by thread: Re: Remote SP debugging from VS 2003: error
- Next by thread: Is it possible to sql inject this code?
- Index(es):
Relevant Pages
|
