May 12, 2003 at 12:49 am
Cannot change security to SQL Server and Windows. I am trying to change the mode by going to SQL Server configuration properties > Security and change mode from windows only to Sql server and windows. But if I Sql server configuration properties after hitting ok, the mode is set back to windows only. I need to change the mode for my website, can someone help
May 12, 2003 at 6:38 am
Does it shows any error while trying to change the authentication mode?
May 12, 2003 at 8:30 am
Does your user account have the appropriate rights to modify the registry key? That's where the value that determines the startup mode is actually recorded.
K. Brian Kelley
http://www.truthsolutions.com/
Author: Start to Finish Guide to SQL Server Performance Monitoring
http://www.netimpress.com/shop/product.asp?ProductID=NI-SQL1
K. Brian Kelley
@kbriankelley
May 12, 2003 at 9:06 am
No it does not show any error message. Yes, I am logged in using the windows system account and it has all privilages to change this setting. Maybe you can tell how to directly change it in registry because I am not able to do it using enterprise manager security tab.
May 12, 2003 at 9:15 am
Default instance:
HKLM\Software\Microsoft\MSSQLServer\MSSQLServer\LoginMode
Named instance:
HKLM\Software\Microsoft\Microsoft SQL Server\<Instance Name>\MSSQLServer\LoginMode
Values:
0x00000002 = Mixed
0x00000001 = Windows only
K. Brian Kelley
http://www.truthsolutions.com/
Author: Start to Finish Guide to SQL Server Performance Monitoring
http://www.netimpress.com/shop/product.asp?ProductID=NI-SQL1
K. Brian Kelley
@kbriankelley
May 12, 2003 at 10:06 am
Thanks,
I managed to change the security authentication using registry.
But still get this error on my asp page
Microsoft OLE DB Provider for ODBC Drivers error '80040e4d'
[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'bell'. Reason: Not associated with a trusted SQL Server connection.
What could be the reason?
May 12, 2003 at 11:08 am
After making the registry change, you stopped and restarted SQL Server?
K. Brian Kelley
http://www.truthsolutions.com/
Author: Start to Finish Guide to SQL Server Performance Monitoring
http://www.netimpress.com/shop/product.asp?ProductID=NI-SQL1
K. Brian Kelley
@kbriankelley
May 12, 2003 at 11:13 am
Thankyou very much,
It worked after restrating SQL Server.
May 12, 2003 at 1:48 pm
Is there a way I can change the object owner. I want to change the stored procedure owner.
Viewing 9 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply