SQL Server error when connecting from Project client.

A

akshah

Hi all,

I am having a strange problem trying to connect to a Project server 2003
using a Project Professional client.
The http connection works fine so i can select a list of projects on the
server that i want to work with. When i try to open a particular project i
see the following message
======================
Connection failed:
SQL State: '28000'
SQL Server Error: 18546
[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user
'MSProjectUser'.

Then it pops up the SQL Server login window 3 or 4 times after which it
opens the project fine. The same happens for every operation that i perform.
I can connect using this user via an odbc client and also query analyser
without any problems.

Any ideas or suggestions highly appreciated.
Thanks
 

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