topic Re: Management Console 9.2 - Registering tables - What password does it want? in Administration and Deployment

Management Console 9.2 - Registering tables - What password does it want?

stuart_snap — Wed, 30 Aug 2017 16:55:20 GMT

Hi.

I am doing a new install of SAS on a new server and having a dilly of a time trying to register tables. It has been 5 years since I last installed SAS, so I am trying to copy what I did before.

I am trying to read ODBC tables. I have set up the connection on the server and tested it. I have set up the Server and connection in the the Server Manager. I have set up a SQL Server authorized domain (as all of the tutorials I have found do). I have set up the library in Data Library Manager. But, when I go to register table it asks for a username and password (Log On - SASApp). I have tried all the combo of user names and passwords that we used in the install, but in every case I get the "ERROR: CLI error trying to establish connection: [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'WHATEVERIENTER'" error. I thought it would be the username and pass used in the authorization domain.. but that doesnt seem to be in either.

Does anyone know what password it might be looking for? Any other suggestions? Thank you!!!

Stuart

Re: Management Console 9.2 - Registering tables - What password does it want?

nhvdwalt — Wed, 30 Aug 2017 17:14:13 GMT

Hi Stuart,

For this particular error, it would need to be a MS-SQL server account that has at least read access to the schema and tables you want to register. This MS-SQL account might be a local MS-SQL server account or a WIndows domain account, depending how your SQL is setup. The MS-SQL admins will be able to tell you which account to use.

All the best !

Re: Management Console 9.2 - Registering tables - What password does it want?

stuart_snap — Wed, 30 Aug 2017 18:29:41 GMT

Thank you! Yep, you are correct. there was a miscommunication between me and the off shore team and they had misspelled the new SQL authorization user. They changed it and we are good to go Thank you!

Stuart