SQL Server Login Error while connecting from MPP.Please help

[Sreejith]

While connecting to the project server from Microsoft
Project (ie;client) it is throwing the error.The error is
as follows.

Connection failed
SQL state:'01000'
SQL Server error:1231
[Microsoft][ODBC SQL Server Driver][Named Pipes]Connection
Open(Create File()).
Connection Failed.
SQL State:'08001'
SQL Server Error 1231
[Microsoft][ODBC SQL Server Driver] Client unable to
establish Connection.

The above message is coming with an "OK" Button. While
clicking on the "OK" Button a second screen is coming for
SQL Login which contains the following.

Server:server name
Login ID :MSProjectUser
Password:***********

All the users who is facing this problem has permissions
to access the MPP's.But again they are getting the above
problem.

Can anybody help to solve this problem???

regards
Sreejith

 

[PD]

Go to the Start -> Programe -> MS Sql Server -> Client NW
Utility -> From General Tab enable TCP/IP and then press
APPLY. Should work. If not create an Alias ( in the
Project Server ) for the database server with the port
number SQL Server is using.