RE: Restored to New server and cannot logon to STS_Config

John,
First, you must first determine the application pool identity. To do this,
follow these steps: 1. Click Start, point to Programs, point to
Administrative Tools, and then click Internet Information Services (IIS)
Manager.
2. Double-click the Web Sites folder.
3. Right-click the virtual server that is running Windows SharePoint
Services, and then click Properties.
4. Click Home Directory.
5. Note the information that is in the Application name box (this is the
application pool name), and then click Cancel.
6. In the left pane, right-click Application Pools, and then click
Properties.
7. Click the Identity tab.
8. Note the information that is in the Application pool identitypane, and
then click Cancel.

Next, you must verify that this account has the required permission the SQL
Server database. To do this, follow these steps: 1. Click Start, point to
Programs, point to Microsoft SQL Server, and then click Enterprise Manager.
2. In the left pane, double-click Microsoft SQL Servers, and then
double-click your SQL server group.
3. Double-click your server.
4. Double-click Security.
5. In the left pane, click Logins.
6. In the right pane, double-click the user who you noted step 8 of the
previous procedure.
7. In the SQL Server Login Properties dialog box, click Server Roles.
8. Click to select both the Security Administrators and the Database
Creators check boxes, and then click Database Access.
9. Under the Permit column, click to select the Windows SharePoint Services
database.
10. Click OK.


"John McArthur" wrote:

> I am running SBS2003. We needed to change to a new physical server. We use
> sharepoint services to provide a "compayweb" site
>
> I have restored both the STS_Config and STS_servername_1 databases to a new
> server. When I try to either connect to or administer the site I get an
> error in opening the config database.
>
> in share point central administration under "Set Configuration Database
> Server" I attempt to set the configuration database to "STS_Config" using
> database server "servername\SharePoint" I get the following message:
>
> Cannot open database requested in login 'STS_Config'. Login fails. (Error
> code: 4060).
>
> I am at a loss on how to fix this.
>
> Please help! Thanks in advance.
>
>
>
.

Relevant Pages