Showing posts with label configuration. Show all posts
Showing posts with label configuration. Show all posts

Friday, March 23, 2012

Is it possible to disable a specific warning ?

Hi!

I'm running dtexec with the /WarnAsErrors flag, to be sure to detect any configuration warning (configuration errors are actually throwed as warning, which is not sufficient) or any other important warning.

I only get one warning (0x80047076, optimisation warning). Is there a way to disable this specific warning ?

thanks

Thibaut

You can't disable warnings in SSIS

Thanks,
Ovidiu

Friday, February 24, 2012

Is installation secure ?

We can find a lot of recommandations about how to secure a SQL*Server configuration.

Does anyone have scripts to do it ?
Any advices or links are welcomeHi

Have you checked out
http://www.microsoft.com/sql/techin...ity/default.asp

and the baseline security analyser
http://www.microsoft.com/technet/tr...ls/mbsahome.asp

John

"Kona" <kona_iron@.yahoo.fr> wrote in message
news:a1de658a.0402261821.4e275230@.posting.google.c om...
> We can find a lot of recommandations about how to secure a SQL*Server
configuration.
> Does anyone have scripts to do it ?
> Any advices or links are welcome|||kona_iron@.yahoo.fr (Kona) wrote in message news:<a1de658a.0402261821.4e275230@.posting.google.com>...
> We can find a lot of recommandations about how to secure a SQL*Server configuration.
> Does anyone have scripts to do it ?
> Any advices or links are welcome

You can download the Microsoft Security Baseline Analyzer, and the
Microsoft SQL Best Practices Analyzer - both will highlight common
security issues. You might also find this link helpful:

http://www.sqlsecurity.com/DesktopDefault.aspx

Simon