Good morning everyone, apologize if these seem like simple questions, but I was curious to see if anyone could give me some advice. We're setting up our first SAS server at my company and my team is responsible for setting up the server with a multitude of libraries for multiple departments and with multiple oracle / SQL databases. Even with my limited SAS experience (and with a little help from users at this community) I was able to setup multiple user accounts / groups that are able to connect to the server w/o issue. With that said, libraries seem a different beast all together (particularly with regards to database connections). For starters, I have found some guides online that detail the necessary steps to create a database library for users to use. I have followed the steps in creating a user group for the database connection, a database server, and a database library. With that said, we initially had an issue where we were missing an oracle driver on the server (which is resolved), but are now faced with an entirely different issue. When trying to connect, its registering the LIBNAME, PATH, and SCHEMA I setup appropriately, but it wouldn't take the ID / password I used for the database connection (though I tested this in the ODBC connection manager w/o issue). It seemed like SAS Management Console needed a username / password that had access to the SASApp server (which in this case is an administrative account we use). I put in those credentials and the libname now displays with a user ID and password, but with the user ID and password I used to perform the configuration on the library itself (the server admin account / password). I didn't think this was necessarily a big deal, but I can't change it. I tried deleting and recreating the library, and the only username / password that gets used is by that account, it doesn't even prompt me for any credentials. I need to wipe this USER ID and Password so that I can test it with the database user ID and password, but I'm simply not sure how. Any advice or guidance would be greatly appreciated.
... View more