SP to change to SQL Server authentication | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

SP to change to SQL Server authentication


If an instance of SQL Server 2005 has been installed as "Windows Only" authentication,
can it be changed to "Windows and SQL Server" authentication by using a Stored Procedure or Extended Stored Procedure instead of using the Enterprise Manager to change it?
Hi,
you may use * xp_instance_regread *, *xp_instance_regwrite* and *xp_regread* , *xp_regwrite* to change in registry for authentication the registry information to be change arehttp://support.microsoft.com/kb/285097
and here is another article FYI
http://msdn2.microsoft.com/en-us/library/ms188670.aspx Regards Hemantgiri S. Goswami
"Humans don’t have Caliber to PASS TIME , Time it self Pass or Fail Humans" – by Hemantgiri S. Goswami
————————
http://hemantgirisgoswami.blogspot.com
Does this applicable to all versions of SQL Server 2000? (EE in particular…) Thanks,
Ram "It is easy to write code for a spec and walk in water, provided, both are freezed…"
Yes, you can still use them in SQL 2000. IMHO you should always follow the docuemented method than using Extended SP as they behave odd sometimes. Satya SKJ
Microsoft SQL Server MVP
Contributing Editor & Forums Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing.
If you change do this you sa password will be null…
Make sure you change your sa password immediately without delay other wise you will trouble… Mohammed U.
]]>