Subject: SQL server MS project 2000 integration

M

Marcel

Im opening MS project plans from an access DB. Access and Project are both
running form MS SL server "not a project server" MS project clients are set
up to use an ODBC connection. The SQL server in using the sa account for the
clients to authenticate onto the server. So far so good BUT every time a
user connects to a project plan the it requires the user to inout the
Username and Password, this is gererating complaints. The Question

How do I pass the UserName and Password from VBA so as to authenticate the
user onto the SQL server?

Im using the shell command
params = """<" & Recordset("PROJ_DATA_SOURCE") & ">" &
Recordset("PROJ_NAME") & """"


WindowID = Shell("C:\Program Files\Microsoft Office\Office\WINPROJ.EXE " &
params, 1)

I've seen a few ways of connecting using /u Username /p Password but they
dont seem to work as the syntax hasnt been documented very clearly

can anyone please help me


regards

Marcel
 
R

Rod Gill

Hi,

In security terms, what you are doing breaks all the rules and is highly
likely to compromise all other databases in SQL Server. If you are saving
projects in SQL server, then use NT authentication. Add the users to SQL
Server and assign appropriate roles. When opening a schedule from SQL server
using NT authentication, users won't get prompted for user names and
passwords.

I strongly recommend NEVER writing a plain text copy of the sa account (read
full admin access to all databases on SQL server) with its password
anywhere!

You also say you are using Access for saving your plans so I don't
understand exactly what scenario you work from. If you are using Access, put
the database in a folder on the network that only the people you want to can
have read/write access. No need then for a user name and password as you are
using Network security.
 
M

Marcel

Ok after some mucking around here is the solution

WINPROJ.EXE
"<TheNameofTheODBCConnection;uid=theusername;pwd=thepassword>\theProjectname"


so if the ODBC connection is called Projects and the SQL server username is
sa and the password is qwerty and the project plan you wanted to open is
called CoolProject, the shell connection would look like:

WINPROJ.EXE "<Projects;uid=sa;pwd=qwerty>\CoolProject"

regards

Marcel
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top