000022624 - How to enable Mixed Mode in Microsoft SQL Server

Document created by RSA Customer Support Employee on Jun 16, 2016Last modified by RSA Customer Support Employee on Apr 21, 2017
Version 2Show Document
  • View in full screen mode

Article Content

Article Number000022624
Applies ToMicrosoft Windows Server 2003 SP1
RSA ClearTrust 5.5.3
Microsoft SQL Server 2000 SP4 - Enterprise Edition
IssueHow to enable Mixed Mode in Microsoft SQL Server
Problems starting RSA ClearTrust AServer and EServer when connecting to Microsoft SQL Server 2000

Full error message observed on Authorization Server:

[SQL Error : Failed Logon:com.jnetdirect.jsql.v: Login failed for user 'CT_ADMIN
'. Reason: Not associated with a trusted SQL Server connection. url:jdbc:JSQLConnect://ASTRACHAN04:1433/database=CT Code: (18452) State: (S0001)]
        at sirrus.da.util.ConnectionManager.getRetryNewConnection(ConnectionManager.java:355)
        at sirrus.da.util.ConnectionManager.createConnections(ConnectionManager.java:539)
        at sirrus.da.util.ConnectionManager.init(ConnectionManager.java:310)
        at sirrus.da.util.ConnectionManager.init(ConnectionManager.java:330)
        at sirrus.da.sql.util.SQLConnectionManager.<init>(SQLConnectionManager.java:63)
        at sirrus.da.sql.util.SQLConfiguration.loadConnectionData(SQLConfiguration.java:126)
        at sirrus.da.sql.util.SQLConfiguration.<init>(SQLConfiguration.java:80)
        at sirrus.da.sql.auth.factory.SQLFactory.<init>(SQLFactory.java:91)
        at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)

        at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
        at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
        at java.lang.reflect.Constructor.newInstance(Constructor.java:274)
        at sirrus.da.auth.AuthDA.<init>(AuthDA.java:95)
        at sirrus.da.auth.AuthDA.initialize(AuthDA.java:141)
        at sirrus.authserver.AuthorizationServer.initializeDataSource(AuthorizationServer.java:597)
        at sirrus.authserver.AuthorizationServer.<init>(AuthorizationServer.java:275)
        at sirrus.authserver.AuthorizationServer.main(AuthorizationServer.java:894)

ResolutionEnable mixed mode authentication in Microsoft SQL 2000 by using the following steps:

1. Start the SQL Server Enterprise Manager console

2. Expand Microsoft SQL Server then expand SQL Server Group within the tree-control

3. Right click the server name and click Properties

4. Click on the Security tab

5. Under Authentication, click the SQL Server and Windows radio button

6. Click OK then click Yes to stopping and restarting the SQL service

7. Start the CT Authorization Server
Legacy Article IDa31584

Attachments

    Outcomes