Problem Logging into Project Portfolio 2007

[sbendigo]

I have followed the doument to a T, but still cannot login. I have used the
user I am logged in with to install Portfolio Server, I have tried the SQL
account and every other account that I had created. Is there a place to look
and see what account it is looking for. Why does this seem to be such a hard
step for so many?
I have uninstalled and reinstalled Portfolio server about 6 times now and
still cannot login.
What can I try now?

Configuration:
Server1 = MS Project Server 2007, MS Project Portfolio Server 2007, MS
Sharepoint Portal 2007
Server2 = MS SQL Server 2005


Thanks,
Scott

 

[Jim Erwin]

I believe it is using windows authentication for a local admin on the
server, but I couldn't get anyone to verify this...

 

[Gaurav Wason]

Go to SQL DB > Create a New Query

Assuming the Database name for Accounts info is PPSAccountData. This will
give you name of all the users in server.

*********************************
Use PPSAccountData
select [Name], [DisplayName] from sfUSERS

*********************************

 

[sbendigo]

Thank you Gaurav,
I tried to use the account that the query returned but it still tells me
"You have entered an incorrect username/password combination"
I even tried resetting the password for the user. Does the user have to be a
member of any particular group or have an permissions on the SQL db?
The user I am logged in with is a local admin with no domain or sql
permissions.

TIA,
Scott

Go to SQL DB > Create a New Query

Assuming the Database name for Accounts info is PPSAccountData. This will
give you name of all the users in server.

*********************************
Use PPSAccountData
select [Name], [DisplayName] from sfUSERS

*********************************
--
Gaurav Wason
(e-mail address removed), MCP - Project Server
Project Made Easy (Project Server Archive Tool) and (Project Owner Tool)
http://projectmadeeasy.com

I have followed the doument to a T, but still cannot login. I have used the
user I am logged in with to install Portfolio Server, I have tried the SQL
account and every other account that I had created. Is there a place to look
and see what account it is looking for. Why does this seem to be such a hard
step for so many?
I have uninstalled and reinstalled Portfolio server about 6 times now and
still cannot login.
What can I try now?

Configuration:
Server1 = MS Project Server 2007, MS Project Portfolio Server 2007, MS
Sharepoint Portal 2007
Server2 = MS SQL Server 2005


Thanks,
Scott

 

[sbendigo]

I just reinstalled with a domain admin user.. no joy. same error. Does this
user need any permissions on the SQL db?

Go to SQL DB > Create a New Query

Assuming the Database name for Accounts info is PPSAccountData. This will
give you name of all the users in server.

*********************************
Use PPSAccountData
select [Name], [DisplayName] from sfUSERS

*********************************
--
Gaurav Wason
(e-mail address removed), MCP - Project Server
Project Made Easy (Project Server Archive Tool) and (Project Owner Tool)
http://projectmadeeasy.com

I have followed the doument to a T, but still cannot login. I have used the
user I am logged in with to install Portfolio Server, I have tried the SQL
account and every other account that I had created. Is there a place to look
and see what account it is looking for. Why does this seem to be such a hard
step for so many?
I have uninstalled and reinstalled Portfolio server about 6 times now and
still cannot login.
What can I try now?

Configuration:
Server1 = MS Project Server 2007, MS Project Portfolio Server 2007, MS
Sharepoint Portal 2007
Server2 = MS SQL Server 2005


Thanks,
Scott

 

[Gaurav Wason]

Try installing it on different port than default 80. Let me know if this
resolves the issue.
--
Gaurav Wason
(e-mail address removed), MCP - Project Server
Project Made Easy (Project Server Archive Tool) and (Project Owner Tool)
http://projectmadeeasy.com

I just reinstalled with a domain admin user.. no joy. same error. Does this
user need any permissions on the SQL db?

Go to SQL DB > Create a New Query

Assuming the Database name for Accounts info is PPSAccountData. This will
give you name of all the users in server.

*********************************
Use PPSAccountData
select [Name], [DisplayName] from sfUSERS

*********************************
--
Gaurav Wason
(e-mail address removed), MCP - Project Server
Project Made Easy (Project Server Archive Tool) and (Project Owner Tool)
http://projectmadeeasy.com

I have followed the doument to a T, but still cannot login. I have used the
user I am logged in with to install Portfolio Server, I have tried the SQL
account and every other account that I had created. Is there a place to look
and see what account it is looking for. Why does this seem to be such a hard
step for so many?
I have uninstalled and reinstalled Portfolio server about 6 times now and
still cannot login.
What can I try now?

Configuration:
Server1 = MS Project Server 2007, MS Project Portfolio Server 2007, MS
Sharepoint Portal 2007
Server2 = MS SQL Server 2005


Thanks,
Scott

 

[sbendigo]

I've been installing it on port 81.

Thanks for your help. Gotta any other ideas?

Try installing it on different port than default 80. Let me know if this
resolves the issue.
--
Gaurav Wason
(e-mail address removed), MCP - Project Server
Project Made Easy (Project Server Archive Tool) and (Project Owner Tool)
http://projectmadeeasy.com

I just reinstalled with a domain admin user.. no joy. same error. Does this
user need any permissions on the SQL db?

Go to SQL DB > Create a New Query

Assuming the Database name for Accounts info is PPSAccountData. This will
give you name of all the users in server.

*********************************
Use PPSAccountData
select [Name], [DisplayName] from sfUSERS

*********************************
--
Gaurav Wason
(e-mail address removed), MCP - Project Server
Project Made Easy (Project Server Archive Tool) and (Project Owner Tool)
http://projectmadeeasy.com



:

I have followed the doument to a T, but still cannot login. I have used the
user I am logged in with to install Portfolio Server, I have tried the SQL
account and every other account that I had created. Is there a place to look
and see what account it is looking for. Why does this seem to be such a hard
step for so many?
I have uninstalled and reinstalled Portfolio server about 6 times now and
still cannot login.
What can I try now?

Configuration:
Server1 = MS Project Server 2007, MS Project Portfolio Server 2007, MS
Sharepoint Portal 2007
Server2 = MS SQL Server 2005


Thanks,
Scott

 

[sbendigo]

Funny thing is, nothing shows up in the event logs. are there other logs i
can be looking at?

Try installing it on different port than default 80. Let me know if this
resolves the issue.
--
Gaurav Wason
(e-mail address removed), MCP - Project Server
Project Made Easy (Project Server Archive Tool) and (Project Owner Tool)
http://projectmadeeasy.com

I just reinstalled with a domain admin user.. no joy. same error. Does this
user need any permissions on the SQL db?

Go to SQL DB > Create a New Query

Assuming the Database name for Accounts info is PPSAccountData. This will
give you name of all the users in server.

*********************************
Use PPSAccountData
select [Name], [DisplayName] from sfUSERS

*********************************
--
Gaurav Wason
(e-mail address removed), MCP - Project Server
Project Made Easy (Project Server Archive Tool) and (Project Owner Tool)
http://projectmadeeasy.com



:

I have followed the doument to a T, but still cannot login. I have used the
user I am logged in with to install Portfolio Server, I have tried the SQL
account and every other account that I had created. Is there a place to look
and see what account it is looking for. Why does this seem to be such a hard
step for so many?
I have uninstalled and reinstalled Portfolio server about 6 times now and
still cannot login.
What can I try now?

Configuration:
Server1 = MS Project Server 2007, MS Project Portfolio Server 2007, MS
Sharepoint Portal 2007
Server2 = MS SQL Server 2005


Thanks,
Scott