I'll ask this in a simpler way-How end users (PMs) can run macrosthat connect to a database?

[andy.novak]

So far I've had one of my PMs test two different macros that simply
connect to a database via a connect string and close. For both the
Reporting Database and Draft database, their login fails.

Is everyone outside of the Project Server Administrator locked out of
running scripts that access an EPM database with a connect string?

What is the general solution to this? I'd much rather have a script
populate combo boxes from EPM and have folks make choices than to have
to write a script for each group. Furthermore, when it comes to
utilities that would automatically add new Team Members to all their
projects, the Draft_Database would have to be updated via the API.

Any and all help would be greatly appreciated.

Thanks,
Andy

 

[Rod Gill]

There is no default access to SQL Server. You need to manually add users to
the database and then select which Views etc they can read (SELECT) or
update.

--

Rod Gill
Microsoft MVP for Project

Author of the only book on Project VBA, see:
http://www.projectvbabook.com