Tag Archives: Configuration Manager

Cloning PeopleSoft Instance

Posted by on February 3, 2009 Comments Off on Cloning PeopleSoft Instance

Here are the steps to clone the PeopleSoft instance:

1. Backup the database (FSDEV) and restore it to another name (FSTST)
2. Clear the GUID field in the PSOPTIONS table in FSTST
3. Set up ODBC connection for FSTST
4. Map PS_HOME network drive and run Configuration Manager to set up shortcuts, PS/nVision path names
5. Create new application server domain for FSTST
6. Create new batch server for FSTST
7. Stop web server and setup new PIA for FSTST
8. Start application server, batch server, web server and log on to FSTST.

[amazon asin=0071664939&template=iframe image&chan=default]     [amazon asin=1430237074&template=iframe image&chan=default]     [amazon asin=0071787925&template=iframe image&chan=default]

Invalid User ID and Password Logging Into Application Designer

Posted by on January 17, 2009 No comments

Problem:

When logging on to Application Designer as a new (Windows) user, the user is unable to login and the following error appears:

Invalid User ID and Password Logging Into Application Designer

Solution:

In Configuration Manager, under Profile, edit the Default program and create new entries for Database and Application Server.

[amazon asin=0071664939&template=iframe image&chan=default]     [amazon asin=1430237074&template=iframe image&chan=default]     [amazon asin=0071787925&template=iframe image&chan=default]

Error has occurred while establishing a connection to the server

Posted by on January 3, 2009 No comments

When connecting to SQL Server database using SQL Server Management Studio, the following error appears:

TITLE: Microsoft SQL Server Management Studio
——————————

An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 – Could not open a connection to SQL Server) (Microsoft SQL Server, Error: 2)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=2&LinkId=20476

——————————
BUTTONS:

OK
——————————

Solution:

The SQL Server instance service (MSSQLSERVER) is not started. Start the service using the Control Panel Services panel, or use SQL Server Configuration Manager:

SQL Server Configuration Manager (Local) > SQL Server 2005 Services > SQL Server (MSSQLSERVER)