SQL Server windows authentication
-
Hi All, We want to disable the windows authentication mode in the sql server, because we use the sql authentication and we don't want the user to login from the management studio using windows authentication. so we need a sql script to disable the windows authentication from our windows application, what is the script please. Thanks all
-
Hi All, We want to disable the windows authentication mode in the sql server, because we use the sql authentication and we don't want the user to login from the management studio using windows authentication. so we need a sql script to disable the windows authentication from our windows application, what is the script please. Thanks all
not sure if it can be done with t-sql or such - but this may help http://sqlblog.com/blogs/allen_white/archive/2011/05/19/change-sql-servers-authentication-mode-with-powershell.aspx[^]
-
Hi All, We want to disable the windows authentication mode in the sql server, because we use the sql authentication and we don't want the user to login from the management studio using windows authentication. so we need a sql script to disable the windows authentication from our windows application, what is the script please. Thanks all
Rather certain that isn't possible nor logically advisable. SQL Server supports Windows authentication and as an option SQL identification. The later is an option the former isn't. Additionally you seem to think that you can disallow access to SQL server completely. Which suggests that you think that there will never be problems that need investigation. Which is unlikely to be true. If you don't trust your users then either address that at the management level or the contract level. And don't try to solve it with technology.
-
Rather certain that isn't possible nor logically advisable. SQL Server supports Windows authentication and as an option SQL identification. The later is an option the former isn't. Additionally you seem to think that you can disallow access to SQL server completely. Which suggests that you think that there will never be problems that need investigation. Which is unlikely to be true. If you don't trust your users then either address that at the management level or the contract level. And don't try to solve it with technology.
jschell wrote:
If you don't trust your users then either address that at the management level or the contract level. And don't try to solve it with technology.
:thumbsup::thumbsup::thumbsup::thumbsup::thumbsup: That's got my five.
Chris Meech I am Canadian. [heard in a local bar] In theory there is no difference between theory and practice. In practice there is. [Yogi Berra] posting about Crystal Reports here is like discussing gay marriage on a catholic church’s website.[Nishant Sivakumar]