Re: Sharepoint migration "IIS application pool username is invalid



Thanks so much mate, I have been following instruction from another technet
post
http://www.microsoft.com/resources/documentation/wss/2/all/adminguide/en-us/stsf12.mspx
which one is the ideal method?

But for the strangest reason, I can now connect the the configuration
database from the remote SQL server. After connection is processed and
successful, it displays the webserver name of the source server. so I went on
to change the default content database server to the remote SQL server via
"Server configuration->Set Default Content database server" and then tried to
point to the remote content database via options under the "Configure virtual
server settings->Manage content databases".

However SharePoint refuse to connect, and prompts an error message of
"A database with the given name already exists on the specified database
server."

Sorry about my messy description.
--
searching is everything


"Pascal G." wrote:

> have you looked at this documentation from MS site?
>
> http://www.microsoft.com/technet/prodtechnol/windowsserver2003/technologies/sharepoint/movewsdb.mspx
>
> Just to test the user, you could try to create a new application pool, sets
> its identity to the same as the one for sharepoint. Create a new IIS
> website and try to naviage on a simple html page. If its not working than
> you'll know that its not related to a Sharepoint config.
>
> Pascal.
>
> "jason" <jason@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
> news:ADB3878E-25A0-4584-9AC4-108A9EE6B90D@xxxxxxxxxxxxxxxx
> > 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

  • 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)
  • 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)
  • Web Developers - Happy Hearts And HDTV! - Lockergnome
    ... Certificate on your MSIIS Web server. ... getting data from a database is only half the problem. ... Zend recently started a series about building rock solid code in PHP. ... which provides bulk database conversion. ...
    (freebsd-questions)
  • Re: TNS could not resolve the connect identifier
    ... This database resides on Machine A. ... The Web server is running on Machine B. ... Using tnsping is not as good as using a real connection such as via ... client (note that this is terminology that appears in the 10g R2 ...
    (comp.databases.oracle.server)
  • Config for OLTP system
    ... extrenal disks fo the 60GByte database server. ... IBM Informix Dynamic Server Configuration Parameters ... # BUFFSIZE - OnLine no longer supports this configuration parameter. ...
    (comp.databases.informix)

Loading