odbc drivers are installed, as all other SQL libraries are running fine.
We got Active directory domain user Service account created for this new library and Database team updated details, now if we try to create library on Management console, tables are still not visible.
Then you must check the odbc.ini file.
Looks like you have Data Direct drivers. Please have a look in the documentation.
Prima facie SAS and the database are not able to communicate.
Typically it is the odbc configuration one has to look into.
Also please make sure you have updated the sasenv_local file with appropriate paths
Sorry to hear that inspite of so much effort you are not able to connect.
There is something wrong some where and that is going undetected.
I would recommend the following
1.From a desktop, using SQL Server Management Studio try to connect to the database using the same credentials that you are using in SAS.
2. If you are able to connect successfully, then use the same information (hostname, port number etc). in your odbc configuration. If sql server is connecting through a non default port, then port number may be needed.
Look for details in the vendor documentation
3.Try establishing a connection using libname statement and minimal set of options for example
LIBNAME mylibref ODBC DSN=server_name USER=myuser PASSWORD=mypassword SCHEMA=syourschema;
4.If you are able to connect in step(1) but not is step (3) then I would prefer to reinstall the driver.
Good.
If SQL team is able to connect to the SQL server database using SQL account, then use this account information in the libname statement and try creating a library..
Please make sure that hostname information is correct and if you are using a non default port then that information should be there in the odbc configuration.
If possible test your connection from the Linux command line line using isql .
If things don't work and you want help on this community please let us know your operating system and the odbc driver you are using
The "Connection Refused" error indicates that you might have a server firewall rule blocking SAS to database server traffic. Check with your IT network people to see if this is the problem.
The SAS Users Group for Administrators (SUGA) is open to all SAS administrators and architects who install, update, manage or maintain a SAS deployment.
SAS technical trainer Erin Winters shows you how to explore assets, create new data discovery agents, schedule data discovery agents, and much more.
Find more tutorials on the SAS Users YouTube channel.