Re: Sharepoint migration "IIS application pool username is invalid

Thanks Pascal

Did what you have suggested but still without any luck.
The IIS server is part of the domain, and i have made the domain user local
administrator as well as network administrator for trouble shot. And i have
added the user in the Sharepoint administrator group.

I am able to create completely new databases on the remote server, so it
proves the domain account i am using has a trust relationship with the remote
SQL server. but when i tried to connnect the existing databases, still same
error message. getting a bit desperate here...


--
searching is everything


"Pascal G." wrote:

> Is your IIS server included as part of the domain?
> Is your domain account has enough rights on the IIS server? (I think it
> should be member of some groups (SPS_WPG, IIS_WPG, STS_WPG))
>
> Maybe you should change the application pool identity from the central
> administration page under "Configure Server Farm Account Settings". Maybe
> you should also change the "Configuration Database Administration Account"
> from the same page.
>
> Pascal.
>
> "jason" <jason@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
> news:863D3A33-B66D-4D76-97C9-28A3F66671AB@xxxxxxxxxxxxxxxx
> > Hi guys
> >
> > Thanks for just reading and paying attention, don't konw what i have done
> > wrong here. My goal is to seperate the sharepoint and its database, and
> > have
> > the existing content and config database migrate onto a remote SQL server.
> >
> > Here is my configuration:
> > - I have export my existing "Content" and "Configuration" database from
> > the
> > default WMSDE and imported onto a remote sql server, and have assigned a
> > domain users which sharepoint is going to used with full database admin
> > rights.
> >
> > - I then open "IIS manager" on the sharepoint server, right click on the
> > application pool which sharePoint Virtual server uses and changed the
> > Identity the application pool uses, to match the same domain user identity
> > which i assigned to the database in the SQL database.
> >
> > - Then on the SharePiont intranet server ->SharePoint Central
> > Administratioin page -> Configure Configuration database . I've tried to
> > connect to the remote database server using the sql server name, the
> > database
> > name (I have changed the database name from default to
> > "sharepointConfig" )
> > and the default "window authentication mode" and i am getting the
> > following
> > error message
> >
> > "IIS application pool username is invalid"
> >
> > I have tried many ways to debug it but with no luck at all. any ideas or
> > suggestion is greatly appreciated.
> >
> > Thanks
> >
> >
> > --
> > searching is everything
>
>
>
.

Relevant Pages

  • Re: SharePoint Portal search is not working after changing admin paasw
    ... Just a thought but it could be the access account to the actual SQL server. ... Query on SQL and see if it lets you in as the Administrator. ... > Verified Password for services on our Database Server ...
    (microsoft.public.sharepoint.portalserver)
  • Re: Cant create ADP database on MSDE using MS Access
    ... but no database is created and I ... > I've tried the SQL Server group but they can't solve it. ... > potential requirement for named pipes if Windows Authentication is to ... "Administrator" and "SA" are still 2 different ...
    (microsoft.public.access.setupconfig)
  • Create SharePoint Portal failed.
    ... One mentioned ensuring that SQL Server uses a case ... 13:55:40 Service database server is 'USDC-JOHRIV'. ... Update dbo.propertylist set DisplayName = N'Last name' ...
    (microsoft.public.sharepoint.portalserver)
  • TS users cannot set default printer
    ... I have set up a Windows 2003 server/terminal server combo. ... When I log on to the TS as 'Administrator', ... When I logon as any Domain User, ...
    (microsoft.public.win2000.termserv.clients)
  • Re: ADO Connection Timeout
    ... to the central server, but you are willing to live with periods where it ... i.e. a local database or even a text file. ... to function until the connection can be restored to the server. ...
    (microsoft.public.data.ado)
Loading