Pinned topic CS 5.4 ODBC error
Answered question This question has been answered.
Unanswered question This question has not been answered yet.
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 270001F2CS1 Post
Re: CS 5.4 ODBC error2008-08-07T08:09:00ZThis is the accepted answer. This is the accepted answer.Hi , did you ran this script before installation,
exec sp_addlogin 'LIBRARYNAME', 'LIBRARYNAMEPWD'
exec sp_grantdbaccess 'LIBRARYNAME'
exec sp_changedbowner 'LIBRARYNAME'
exec sp_defaultdb 'LIBRARYNAME', 'LIBRARYNAME'
where LIBRARYNAME is the name of your CS database name