Connection Problem with WSS and ProjectServer

[Steve]

I have two servers, svreq1 and svreq2

Svreq1 is a SQL Server with SQL Analysis Services on it. Svreq2 is a Web Server with Project Server, WSS, and Reporting Services on it.

I'm unable to connect to the WSS instance from project server. The symptoms are as follows

On the homepage, I get the following under Risks and Issues
There is a problem establishing a connection with the Web server running Windows SharePoint Services. Contact your system administrator

If I try to provision a site, I get the following error
Error occured when creating site. Site does not seem to exis

When I try to save any of the settings in Manage Windows SharePoint Services > Connect to SharePoint server, I get the following error
The specified Windows account must be a valid user on the specified SharePoint server computer. Furthermore, the Windows account must be in the SharePoint Central Administrators group

I've run PSCOMPlus, with the following settings
MYDOMAIN\srolapadmi
ThisUsersPas

MYDOMAIN\srstsadmi
ThisUsersPas

I used this command to configure proxycfg
proxycfg.exe -d -p * "<local>;

Running proxycfg outputs the following

Current WinHTTP proxy settings unde

HKEY_LOCAL_MACHINE SOFTWARE\Microsoft\Windows\CurrentVersion\Internet Settings\Connections WinHttpSettings

Flags = PROXY_TYPE_DIRECT | PROXY_TYPE_PROX
Proxy Server = <local>
Bypass List = -not set

I've given SRSTSAdmin Security Administrator rights to the SQL server (srveq1) and given it db_datareader access to WSSConfig and STS_srveq2_1

I've reinstalled Sharepoint several times and reinstalled the entire EPM Solution once. I thought it might be because SQL Reporting Services is installed, but I uninstalled it when I uninstalled Project Server and haven't reinstalled it as of yet - the problem still exists, so I don't think it's that

I'm wondering if COM+ might be messed up somehow, but I'm thinking it's not because I can build the OLAP cube just fine

Please help me if you are able - I'm out of ideas and getting very frustrated

Thanks
Steve

 

[Gary L. Chefetz \(MVP\)]

Steve:

Your proxy config command line is incorrect which is very clear in the
output. Your proxy server isn't named <local> is it?

Try:

proxycfg.exe -d -p "fakeproxy" "<local>"



--

Gary L. Chefetz, MVP
"We wrote the book on Project Server
http://www.msprojectexperts

-

I have two servers, svreq1 and svreq2.

Svreq1 is a SQL Server with SQL Analysis Services on it. Svreq2 is a Web

Server with Project Server, WSS, and Reporting Services on it.

I'm unable to connect to the WSS instance from project server. The symptoms are as follows:

On the homepage, I get the following under Risks and Issues:
There is a problem establishing a connection with the Web server running

Windows SharePoint Services. Contact your system administrator.

If I try to provision a site, I get the following error:
Error occured when creating site. Site does not seem to exist

When I try to save any of the settings in Manage Windows SharePoint

Services > Connect to SharePoint server, I get the following error:

The specified Windows account must be a valid user on the specified

SharePoint server computer. Furthermore, the Windows account must be in the
SharePoint Central Administrators group.

I've run PSCOMPlus, with the following settings:
MYDOMAIN\srolapadmin
ThisUsersPass

MYDOMAIN\srstsadmin
ThisUsersPass

I used this command to configure proxycfg:
proxycfg.exe -d -p * "<local>;"

Running proxycfg outputs the following:

Current WinHTTP proxy settings under

HKEY_LOCAL_MACHINE SOFTWARE\Microsoft\Windows\CurrentVersion\Internet

Settings\Connections WinHttpSettings :

Flags = PROXY_TYPE_DIRECT | PROXY_TYPE_PROXY
Proxy Server = <local>;
Bypass List = -not set-

I've given SRSTSAdmin Security Administrator rights to the SQL server

(srveq1) and given it db_datareader access to WSSConfig and STS_srveq2_1.

I've reinstalled Sharepoint several times and reinstalled the entire EPM

Solution once. I thought it might be because SQL Reporting Services is
installed, but I uninstalled it when I uninstalled Project Server and
haven't reinstalled it as of yet - the problem still exists, so I don't
think it's that.

I'm wondering if COM+ might be messed up somehow, but I'm thinking it's

not because I can build the OLAP cube just fine.

 

[Gary L. Chefetz \(MVP\)]

Steve,

Did the output match the following?

Flags = PROXY_TYPE_DIRECT | PROXY_TYPE_PROXY
Proxy Server = Fakeproxy
Bypass List = Local


--

Gary L. Chefetz, MVP
"We wrote the book on Project Server
http://www.msprojectexperts

-

Gary,

I ran that proxycfg.exe -d -p "fakeproxy" "<local>" command, and ran

IISRESET, and am still experiencing the same problem. Any other
suggestions?

 

[Steve]

After running your command, my output matches this

Current WinHTTP proxy settings unde

HKEY_LOCAL_MACHINE SOFTWARE\Microsoft\Windows\CurrentVersion\Internet Settings\Connections WinHttpSettings

Flags = PROXY_TYPE_DIRECT | PROXY_TYPE_PROX
Proxy Server = fakeprox
Bypass List = <local>

 

[Steve]

Just FYI, I've also ran proxyconfig -d -p "fakeproxy" "local" to the same result.