Skip to main content
D
Donnytheinvisible
Participant
July 12, 2007
Question

MS SQL

  • July 12, 2007
  • 1 reply
  • 427 views
I have an MS SQL problem,

I have set up Adobe Enterprise with a MS SQL 2005 database. Although ‘Connect’ recognised the SQL data source on install it now refuses to connect. The SQL log shows that a connection is being attempted every time the System Administrator username and password details are entered into the ‘Connect’ configuration, so details such as host, data source etc are right.

I assume this must be an authentication problem but how do I either reset the SQL system admin details or access the database outside of the SQL management software to verify that the login details I am putting into Connect are in fact right.

Any help please….
    This topic has been closed for replies.

    1 reply

    D
    diddon
    Participant
    July 13, 2007
    Thanks to everyone who replied.

    For your information I think I may have sorted this. It is an MS SQL 2005 issue. By switching to Mixed Mode authentication (SQL authentication) rather than Windows Authentication (which is automatic and the default) it is possible to login from the Connect Config screen. You must also make sure "user desktop notification" is switched on for Adobe Breeze in the windows admin setting.

    If this is done there may well be a problem if the system fails i.e. errors will only appear on the server, I am also unsure of any extra security issues that may prove a problem by switching to mixed mode.

    So, it works but if anyone has any better ideas or advice please let me know.

    Thanks
    Terms & ConditionsAccessibility statement
    Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices