RE: Restored to New server and cannot logon to STS_Config

John
what error do u get when u try to view the tables?
it may be worth changing the app pool from network service to root

Dave


"John McArthur" wrote:

> Thank you for your reply.
>
> I found the "companyweb" app pool is "root"
> The Application Pools user is "Network Services"
> I then went to SQL Enterprise manager and in the servername\SHAREPOINT
> server security logins object I select network services and get an error
> popup "One or more databases are inaccessible and will not be displayed in
> the database access tab.
>
> When I check the database access tab I found that the STS_config and the
> STS_servername_1 databases are not listed.
>
> I can access the table view of both the databases but cannot view the
> contents of a table.
>
> Thanks
>
> "dave nixon" wrote:
>
> > 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

  • Re: Ive about had it with WSS!
    ... Sharepoint went down on our main server, I fought with that for 2 days ... "Unable to connect to database. ... Make sure the account for the application pool has appropriate ...
    (microsoft.public.sharepoint.windowsservices)
  • Re: Access Databases & IIS 6.0
    ... PID to Application Pool." ... You don't need to reboot the server. ... I administer a Windows Server 2003 running IIS 6. ... Unable to establish connection to database. ...
    (microsoft.public.inetserver.iis.security)
  • Re: Sharepoint migration "IIS application pool username is invalid
    ... Just to test the user, you could try to create a new application pool, sets ... you'll know that its not related to a Sharepoint config. ... > I am able to create completely new databases on the remote server, ... >> you should also change the "Configuration Database Administration ...
    (microsoft.public.sharepoint.portalserver)
  • Re: Using RAC for 25+ small to medium sized database
    ... >each with buffer cache, large pool, shared pool, java pool, redo ... >buffers plus each of these instances would have up to 20 oracle ... >to each other from one blade server to another. ... >non-RAC database to RAC, 5 sets of archive/redo logs, 5 alert log files ...
    (comp.databases.oracle.server)
  • Re: 40% slowdown with dynamic /bin/sh
    ... My database loads ... ] FreeBSD makes an ideal Internet or Intranet server. ... ] network services under the heaviest loads and uses memory efficiently to ...
    (freebsd-current)