Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Unable to connect to Symposium DBS

Status
Not open for further replies.
BeWiser

BeWiser

IS-IT--Management
Oct 21, 2008
6
GB
Help!

I have been trying to connect to the Symposium Sybase DBS.

I have installed the standalone Sybase driver and used the DSEdit Utility to try and configure the source location.

Whilst when I go into ODBC and configure this and then test the connection, it looks OK, until it comes back with "Login failed, check for Valid user ID". This implies the obviouse, but I am using the standard webadmin user account or my own account, but neither work, despite being the top level users.

I am running CC6 and as such do not have a fat client admin user account, if this makes any difference.
 
Sort by date Sort by votes
you have to create a login ID and password on the server using server utility and use this to connect to the database.

MJ
 
Upvote 0 Downvote
Thank you for this advise.

I tried this and set up a new user on the server, but it comes back with exactly the same error!
 
Upvote 0 Downvote
make sure on the ODBC setup the data source name and the server name are exactly the same as what you created as the server name in the DSedit. The IP address in the DSedit should also contain port 5000. i.e TCP - 192.168.1.10,5000

the login ID you created using server utility is case sensitive.

Hope these help.

MJ
 
Upvote 0 Downvote
MJ I have done all of this and double checked it, but to no avail. If you have an email, I will send you a word doc with the screen shot, to see if you can see anything else I am doing wrong, as at the moment, I belive I am doing what the book and other users as have said I should do to make the ODBC connection and gain access to the Sybase DBS.

Thanks for your help
 
Upvote 0 Downvote
To connect to Sybase via ODBC, make sure you can log into the Server Utility on your CCMS server.

If you are able to log into your Server Utility Application on the CCMS, you will be able to log into ODBC.

To config ODBC, make sure you have CCMS IP:5000 specified in the ODBC config, then use the username sysadmin and the password you have defined for the sysadmin user. (this is the same user/pass that you used to log into the CCMS Server Utility).

Also make sure you are connecting to the blue database.
 
Upvote 0 Downvote
OK Guys,

I have double checked everything...created new users on the local server and tried a Symposium administrator user, but still get the login failure error.

I have now double checked my ODBC config with the config that is actually on the symposium server itself and this is all the same also. i.e. appears to be 100% correct.

Any further suggestions or ideas of what the damn username and password it will like could be? or any other thoughts very welcome.

Thanks for your help.

For Good quality Insurance call 0800 954 95 45
 
Upvote 0 Downvote
ODBC uses the sysadmin username/password. The exact same username and password required to get into the CCMS Server Utility.

If you can log into server utility, you should be able to ODBC to the blue db.

If you can not, you will most likely need Nortel to intervene.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

MoJHK
  • Locked
  • Question
Change the Nortel Symposium agent to a baic ACD agent
Replies
1
Views
124
Firebird Scrambler
Firebird Scrambler
telklass
  • Locked
  • Question
Avaya Symposium vs IE
Replies
1
Views
148
Utreg
Utreg
A
  • Question
The system could not retrieve any data from the server because either the server connection is down
Replies
2
Views
179
Allianzjack
A
Bucky101
  • Locked
  • Question
SQL lookup to AAAD Screenpop
Replies
0
Views
100
Bucky101
Bucky101
nortavaya
  • Locked
  • Question
How to sign CSR of AACC 7.0
Replies
1
Views
128
Bucky101
Bucky101

Part and Inventory Search

Sponsor

Back
Top