Browse by Tags

Restrict Access to SQL Server using "Certificates"

Published 2 July 7 4:7 AM | SSQA.net

Within SQL Server 2005 you could take help of certificates to restrict the access from a particular client's machine. Few times (even me) confused with or get an impression that SSL encryption is same, for more information on SSL( Secure Sockets Layer...

Filed under: sql server, performance, databases, security, access, encryption, certificate

xp_cmdshell: a call to 'CreateProcess' failed with error code: '5'

Published 24 May 7 8:5 AM | SSQA.net

Problem: SQL Server 2005 error: xp_cmdshell: a call to 'CreateProcess' failed with error code: '5'. We get above error when trying to execute XP_CMDSHELL even though it has been enabled using Surface Area Configuration tool and the login...

Filed under: sql server, databases, access, permissions, xp_cmdshell