MSSQL Dictionary Owner Connect String Not Working in CW

questions
1

I have the following entry in CW 11.1 dictionary Owner Name column:

easprdsqlrbhs.rad.rutgers.edu, aidsdata, NJPies, 9YMEqn9qFun*e2FeVDHbZe76L9cu-4e7

where

  • easprdsqlrbhs.rad.rutgers.edu is server
  • aidsdata is database
  • NJPies is username
  • 9YMEqn9qFun*e2FeVDHbZe76L9cu-4e7 is password

This never works in CW BUT it is accurate. It works from MS SQL Server Management Studio.

is there a password size limit entry in CW?
is there a way to get around this?

Raul

2

First, what is the actual error you are receiving?
A couple of things to try.
Add [easprdsqlrbhs.rad.rutgers.edu] around your server name.
Open management studio and connect to your server. Open the Management branch in the Object Explorer. Then open the server logs branch and open the most recent server log. You will see more detailed error information about the login attempt and what was actually wrong. SQL sends a generic login error message back to the application so it does not leak security info that might help a hacker.
If you do not see a login attempt error in the SQL logs, then your application is probably never even connecting to SQL to attempt to login.

3

not sure, but why do you have spaces? Try without it, like
easprdsqlrbhs.rad.rutgers.edu,aidsdata,NJPies,9YMEqn9qFun*e2FeVDHbZe76L9cu-4e7

3 Likes
4

I be damned!

It is the spaces.

Removed spaces after each comma and it works!!!

Thank you all a million!!

Raul

1 Like
5

great!! nice to know. Never had this kind of problems, but also never had spaces in conn string :slight_smile: