Windows Forum

Ask something
Discussion Locked

Project Central SQL Server Connection

0 helpful
3 replies

by rick3000

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
I have MS Project Central set up and it works fine if Central and SQL7/SP2 are on the same NT4/SP4 server. However, when I have a Central server seperate from a SQL server, MS Project .mpp files to Central cannot be uploaded (all other functions work). Both NT servers are standalone and not in the same domain. Any ideas to fix this?

3 replies

by ratherbfishing

I am not very familiar with Central, but here is some basic stuff you may already know, but it will get everyone thinking.

If both servers are in separate domains, then make sure your trusts are setup correctly and that the permissions are correct for the account that is accessing the files.

If your servers are actually not in domains, then you have to setup accounts locally on each server for accessing the files.

by rick3000

Thanks you, but that was not the problem. I figured it out after I went to the server lab after I posted the question (isn't it always that way?). The SQL server was being accessed using "named pipes" which is default (which would have worked under NETBUIE), I had to change it to "TCP/IP", then it worked fine...

This discussion is closed to new replies.