Topic
  • 1 reply
  • Latest Post - ‏2008-08-07T08:09:00Z by Nandkori
SystemAdmin
SystemAdmin
27 Posts

Pinned topic CS 5.4 ODBC error

‏2008-07-30T11:48:09Z |
We are trying to install CS 5.4 on a new server and run into an ODBC error. We ran the Content services 5.4 setup, requests the ODBC Source Name. We performed the ODBC setup and successfully tested, inputting this into the file net setup it failed and came up with a 'cannot connect to database server' error.
Updated on 2008-08-07T08:09:00Z at 2008-08-07T08:09:00Z by Nandkori
  • Nandkori
    Nandkori
    1 Post

    Re: CS 5.4 ODBC error

    ‏2008-08-07T08:09:00Z  
    Hi , did you ran this script before installation,

    use master
    exec sp_addlogin 'LIBRARYNAME', 'LIBRARYNAMEPWD'
    exec sp_grantdbaccess 'LIBRARYNAME'
    use LIBRARYNAME
    exec sp_changedbowner 'LIBRARYNAME'
    exec sp_defaultdb 'LIBRARYNAME', 'LIBRARYNAME'

    where LIBRARYNAME is the name of your CS database name