A very good point nhvdwalt, yes our mid-tire has been and entier servers are setup for a heavy use.   Thanks to all of replies.     Best ... View more

Thank you SASKiwi, very good article.  In general I am trying to find out how other admins & other companies use these tools.  For example for a 500 users, I though SAS Studio is much easier to deploy than go around and try to push and install 500 computers with EG!   Best ... View more

Hello everyone and thanks for your help and posts.  After reading most of the links I was able to do the following.  I would love and very much appreciated to know your thoughts and help on this:  Steps I took: Created a domain service account called SASSQLCONNECT. This service account has access to SQL Server. Logged in into the SAS OA server with this user (only once to setup the ODBC driver) and did setup ODBC connection to SQL Server. I followed this blog http://blogs.sas.com/content/sgf/2013/02/13/registering-dbms-data-in-sas-management-console/ and as the result created an entry under [Server Manager] called [SQL Server: SQLDevDB] and also a Library under [Data Library Manager] called [SQL Server: SQLDevDB Library].   Here are my question: I go and select and right click on [SQL Server: SQLDevDB Library] in Libraries and select Register Tables > Next > there is a log on windows pops up for SASAppOA, What user ID I need to log-in with? (at this time I just login with my own userID) and after I do this I get another log-on windows for [SQL Server: SQLDevDB Library] and again I use my own login (I am sure this is not correct) Then I see the list of my tables from database, I select one and Location is set to /Shared Data > Next> Finish I am assuming now I have registered the table in MetaData server. Now I want to load the data into LASR table, how should I do that? I can go and open SAS Enterprise Guide and under Servers SASAppOA and Explore the data. I use SAS Enterprise Guide to Upload to LASR by finding the registered table but I get an error on a popup window for Upload to LASR saying “Unable to locate any LASR libraries. This task requires a LASR library”   Again thank you for your feedback Regads ... View more

Hi Anand_V, the link to the blog was great.  I was able to go through it and it helped very much.  Now when I right click and select Display LIBNAME Statement I get the following but the problem is that it is using my userID for user.  What I want to do is use a service account I have created to be used for user=myserviceacct   LIBNAME LibMyLibName ODBC  DATAsrc=SASSQL  SCHEMA=DBO  USER=MyID  PASSWORD="{???}123456789012345678890" ;   I logged into the SAS Management console as sasadm and when I run the above statement it passes my userID but I want to use the fix service account.   Best and thanks ... View more

Thank you Anand-V and SASKiwi for your replies.  SASKiwi -  SAS did our installation and it looks like they used DSN for connection not sure why.  Also I looked at the link you provided and if I do it that way then I need to place the username and password into the string and I am not sure who will be able to see that!  I forgot to mention in my first but yes I want to register the tables in MetaData first but my issue is finding the steps to do it.  I have looked and searched but they are mostly talking about importing data from Excel...   Here what I think I should be doing (if using the DSN). 1- I logged in into the server as a server admin user (who has access to the SQL Server) and created the ODBC connection in DSN. 2- Now what I need to do is to register tables into metadata (I am assuming when I do this it will create the library with the list of tables in it) 3- Load the data into LASR   Stpes two and three and perhaps for all of the above steps I need some guide and help. Again thanks so much to both of you for your help   Regards ... View more

Hi Andrew - the $SASCONFIG/Lev1/Documents was very helpful.  It looks like on our OA server I have only one set a log files for SAS Metadata Server and on our VA the Stored Process Server, Workspcace Server, SAS Data Step Batch Server, SAS Apawners, ... all are creating a log file under the same directory. Now just going to create some poweshell scripts to do the archiveing for me.  Thanks again for your help and info.     Best ... View more

Thank you Andrew, will give it a try and will let you know. ... View more

Thank you ArtC for your reply and info.  I did go ahead and downloaded LogConfigSweeper utility in our development environment. Here is the issue I am encountering with:   I have two servers OA and VA. On the OA I have the following directories under SASConfig (Certificates, Meta and OA).   It looks like the LogConfigSweeper.bat file is looking for level_env.bat file and that file does exists on our OA server but in two different folders and they are: \SAS\SASConfig\Meta\Lev1 AND \SAS\SASConfig\OA\Lev1   Now, I went ahead and place LogConfigSweeper into \SAS\SASConfig\OA\Lev1\Web\Utilities folder and did run \SAS\SASConfig\OA\Lev1\Web\Utilities>logconfigsweeper.bat objectspawner -output c:\tooloutput but results are some .xml files and couple of .bat files and no log files.  If I run it with -all command then I get lots of subfolders with mix of log and other files!   At the beginning of the LogConfigSweeper.bat there is a call to level_env.bat, I was wondering if I need to change that to match the location where my level_env.bat files are located. setlocal call "%~dp0..\..\level_env.bat"   Again your input much appreciated.   Best, Iman ... View more

Thank you for your info and feedback @JuanS_OCS ... View more

Thank you @JuanS_OCS for your reply and info.  I am assuming since we have installed the OA, VA, MT and MD components I should start with VA and OA "Administrating a Non-distributed Deployment on Windows" and perhas latter take the Platform Admin Fast Track class! I just want to make sure to start on a class that it can be useful to manage security, groups...  I have also need to start looking at bringing data from our data-warehouse (SQL) to SAS LASR tables...  The problem is that I can't find any class-room courses for VA and OA, mostly are web based.  In past, we had many bad experienced taking web based courses!   Again, thanks for any info that I can get.   ... View more

Hello all, I am on the same boat as @nandanosho. I have the privilege of taking advantage of class-room courses but I need to be sure I start the process in correct manner.  Does anyone here took any of the class-room courses, where and your overall experience and if you recommend it?   Thanks again ... View more