A
AJS_ISG
I get a SQL Server error (on more than one client machine) when reading from,
or writing to, a project published in Project Server 2003. The error is
followed by a SQL Login dialog box that lists (local) and the name of the SQL
Server. Using the name of the SQL Server works and I can read and write the
project on the server.
How do I change the configuration so Project looks for the PS SQL Server
first?
I've checked the versions of the MDAC as suggested in the KB for a similar
error and checked the settings in cliconfg.exe on the clients and the server
and they all appear to be fine. Since the problem is occuring with more than
one client, this looks like it could be a server configuration issue.
The SQL Server error itself says it can't make a shared memory pool
connection, but since it's trying the wrong machine that's not surprising.
Any suggestions would be appreciated. I've hunted through the docs and the
KB without finding anything directly relevant. This is a new implementation
of Project Server, so we're still getting up to speed.
or writing to, a project published in Project Server 2003. The error is
followed by a SQL Login dialog box that lists (local) and the name of the SQL
Server. Using the name of the SQL Server works and I can read and write the
project on the server.
How do I change the configuration so Project looks for the PS SQL Server
first?
I've checked the versions of the MDAC as suggested in the KB for a similar
error and checked the settings in cliconfg.exe on the clients and the server
and they all appear to be fine. Since the problem is occuring with more than
one client, this looks like it could be a server configuration issue.
The SQL Server error itself says it can't make a shared memory pool
connection, but since it's trying the wrong machine that's not surprising.
Any suggestions would be appreciated. I've hunted through the docs and the
KB without finding anything directly relevant. This is a new implementation
of Project Server, so we're still getting up to speed.