Microsoft Project was unable to establish a connection with SQL Server

[Cynthia]

The following post was posted in December on one of the dbforum discussion groups. It is the same problem I have. Has anyone solved this problem? All of the solutions listed on this site have not been successful.

Thanks
Cynthi

We are using a combination of SQL server and Sharepoint
and Enteprise MSProject, so our team can all see the
project schedule on the web. Administrators can not only
see the project on the web, but can edit the MSProject
data in MSproject. We have a problem when certain users go
to edit the data in MSproject (an option when you are
looking at the project on the web via sharepoint). It
seems to be if the user ID is in the domain that the SQL
server is in, it works, if they are not it doesn't work

I have a document with screen snapshots of this failing, I
can send this if needed

Steps to reproduce the problem

1) Bring up Microsoft Project Web Acces

2) Go to the project center and highlight the project to
edi

3) Hit "Open in Microsoft Project

4) A screen splashes by. The title is "Microsoft Project
Server Security Login" and the text says "Please enter
your login information for the server
http://servername/projectserver

5) And then the failure dialog occurs. The title
is "Microsoft SQl Server Login" and the text says
Connection failed
SQLState: '01000
SQL Server Error:5
[Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpe
(Connect())
Connection Failed
SQLState: '0800
SQL Server Error: 1
[Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL server
does not exist or access denied

6)Then we get this Dialogin MS project

Server: Server IP/servernam
An unchecked check-box that says Use Trusted Connectio
Login ID: MSProjectUser000
Password: ******************

7) Hit OK to log in, and get the last dialog

Cannot connect

hThis coudl be
caused by a loss of netowrk connectivity, invalid username
or password, lack of an enterprise global template,
problems with the Microsoft Project Server or database, or
your Microsoft Project Server may not have enterprise
features enabled


If any user locally (in the same domain as the SQL server)
tries this, it all works perfect every time. We have had
two different users from other domains try this, and they
both get the same error

 

[Lars Hammarberg]

When accessing data on the sqlserver from ProjectPro (and not using named
pipes in the same domain) you're probably going to talk to the server
through tcp port 1433 (unless the default port has been changed by the
sqlserver admin)
If this connectivity has to take place through routers/firewalls with closed
ports you're out of luck unless someone opens up a port for you to use. One
way of testing this is to create an ODBC dsn on the client using the
MSProjectUser0000 uid and the appropriate password (found in clear text in
the registry on the projectserver machine if you're running PS2002 -
otherwise you'll have to check your documentation from the installation) and
see if you can access the sqlserver that way without involving project at
all.

--

/Lars Hammarberg
www.camako.se
MSProject Premier Partner

The following post was posted in December on one of the dbforum discussion

groups. It is the same problem I have. Has anyone solved this problem?
All of the solutions listed on this site have not been successful.

Thanks,
Cynthia


We are using a combination of SQL server and Sharepoint
and Enteprise MSProject, so our team can all see the
project schedule on the web. Administrators can not only
see the project on the web, but can edit the MSProject
data in MSproject. We have a problem when certain users go
to edit the data in MSproject (an option when you are
looking at the project on the web via sharepoint). It
seems to be if the user ID is in the domain that the SQL
server is in, it works, if they are not it doesn't work.

I have a document with screen snapshots of this failing, I
can send this if needed.


Steps to reproduce the problem:

1) Bring up Microsoft Project Web Access

2) Go to the project center and highlight the project to
edit

3) Hit "Open in Microsoft Project'

4) A screen splashes by. The title is "Microsoft Project
Server Security Login" and the text says "Please enter
your login information for the server
http://servername/projectserver:

5) And then the failure dialog occurs. The title
is "Microsoft SQl Server Login" and the text says:
Connection failed:
SQLState: '01000'
SQL Server Error:53
[Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen
(Connect()).
Connection Failed:
SQLState: '08001
SQL Server Error: 17
[Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL server
does not exist or access denied.

6)Then we get this Dialogin MS project:

Server: Server IP/servername
An unchecked check-box that says Use Trusted Connection
Login ID: MSProjectUser0000
Password: *******************

7) Hit OK to log in, and get the last dialog:

Cannot connect.

hThis coudl be
caused by a loss of netowrk connectivity, invalid username
or password, lack of an enterprise global template,
problems with the Microsoft Project Server or database, or
your Microsoft Project Server may not have enterprise
features enabled.




If any user locally (in the same domain as the SQL server)
tries this, it all works perfect every time. We have had
two different users from other domains try this, and they
both get the same error.