Desktop productivity for business analysts and programmers

Add MS SQL database to SAS Environment as new library

Reply
N/A
Posts: 1

Add MS SQL database to SAS Environment as new library

I am using SAS EG 9.1.
When I am connecting new library, that is MS SQL 2000 database via ODBC, I cant see tables in data window. I can connect to it via proc sql, but I cant see it on the library tree list like in other sources.
Only when I put dbo (database owner) login and password I see the tables in the list. What kind of rules in MS SQL I should give to my new, special user for SAS connection? I need to mention that when I put the db_owner role it also not working correctly. Any ideas?
Ask a Question
Discussion stats
  • 0 replies
  • 78 views
  • 0 likes
  • 1 in conversation