Database

View All Threads First Prev Next

SQL Server windows authentication Zeyad Jalil28-Nov-12 23:49 Zeyad Jalil 28-Nov-12 23:49  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 Re: SQL Server windows authentication Garth J Lancaster28-Nov-12 23:59 Garth J Lancaster 28-Nov-12 23:59  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[^] Re: SQL Server windows authentication jschell29-Nov-12 8:09 jschell 29-Nov-12 8:09  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. Re: SQL Server windows authentication Chris Meech30-Nov-12 3:45 Chris Meech 30-Nov-12 3:45  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. 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]

Last Visit: 31-Dec-99 18:00     Last Update: 17-Apr-24 20:35 Refresh 1

General    News    Suggestion    Question    Bug    Answer    Joke    Praise    Rant    Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.