• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 903
  • Last Modified:

Not able to create new Web Application and Content database in SharePoint 2007.

Hi, I am failed to create new web application through central administration site. During creation it gives unexpected error and also not able to create new content database in existing web application.
Bur I am can create new site collection in exiting web application in existing content database.
Kindly resolve the issue ASAP.
0
Minesh Shah
Asked:
Minesh Shah
  • 3
  • 3
1 Solution
 
Rainer JeschorCommented:
Hi,
to be able to help you we would need the exact error message.
Please verify / check both:
- Windows Event Log
- SharePoint ULS Log (if not configured then the default path is
C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\12\Logs

What I can think of might be, that the account which you have configured in the content database section of creating the web app, has not the propper permissions in SQL server.

Thanks and HTH
Rainer
0
 
sp_adminCommented:
Hi,
Firstly check if the System Account in use has not been modified as if its password has not been reset.
Please check if the account you are using has appropriate rights on the SQL box of not.
To add a new content database to an existing Web application, try creating directly on the SQL box and use stsadm -o addcontentdb command to attach it to existing Site Collection. Further try creating a Web application via command prompt - stsadm -o extendvs .
hope this helps.
0
 
Minesh ShahSharePoint & all about itAuthor Commented:
Hi, recently I have changed the password of admin account and followed the below steps to update password in SharePoint.

--->How to change service accounts and service account passwords in SharePoint Server 2007<----
This section describes how to change the passwords for service accounts in Microsoft Office SharePoint Server 2007 and in Microsoft Windows SharePoint Services 3.0.To change the passwords for service accounts in SharePoint Server 2007 and in Windows SharePoint Services 3.0, follow these steps.

Note If the SQL Server service uses a domain account, and the password for that domain account is either expired or invalid, make sure that you update the password for the domain account before you perform this procedure.
1.      Update the password for the account that is used by the Central Administration application pool. To do this, follow these steps: a. On all servers in the server farm, open a command prompt, type the following line, and then press ENTER:
cd %commonprogramfiles%\Microsoft Shared\Web server extensions\12\Bin

 b. On the server that hosts the Central Administration Web site, type the following line at the command prompt, and then press ENTER:
stsadm -o updatefarmcredentials -userlogin DomainName\UserName -password NewPassword

c. On all other servers in the server farm, type the following line at the command prompt, and then press ENTER:
stsadm -o updatefarmcredentials -userlogin DomainName\UserName -password NewPassword -local
d. Restart Microsoft Internet Information Services (IIS) 6.0. To do this, type “iisreset /noforce” at the command prompt, and then press ENTER
2.      Verify that the Administration Application Pool Credential Deployment job definition is no longer displayed on the Timer Job Definitions page of SharePoint 3.0 Central Administration. To do this, follow these steps: a. Open SharePoint 3.0 Central Administration, click Operations, and then click Timer job definitions under Global Configuration.
b. Verify that the Administration Application Pool Credential Deployment job definition is no longer displayed in the list.

Note If the Administration Application Pool Credential Deployment job definition is displayed in the list, wait until it disappears from the list.
3.      Update the password for the application pool account that is used by Web applications on the server farm. To do this, type the following line at a command prompt on every server on the server farm, and then press ENTER:
stsadm -o updateaccountpassword -userlogin DomainName\UserName -password NewPassword -noadmin
4.      Update the password for the account that is used to run the Windows SharePoint Services Help Search service. To do this, type the following line at a command prompt on every server on the server farm, and then press ENTER:
stsadm.exe -o spsearch -farmserviceaccount DomainName\UserName -farmservicepassword NewPassword
5.      Update the password for the default content access account that is used by the Windows SharePoint Services Help Search service. To do this, type the following line at a command prompt on every server on the server farm, and then press ENTER:
stsadm.exe -o spsearch -farmcontentaccessaccount DomainName\UserName -farmcontentaccesspassword NewPassword
6.      If you are running SharePoint Server 2007, you must also follow these steps:
a. Update the password for the account that is used by every Shared Services Provider (SSP) on the server farm. To do this, type the following line at a command prompt on every server on the server farm, and then press ENTER:
stsadm.exe -o editssp -title SharedServicesProviderName -ssplogin DomainName\UserName -ssppassword NewPassword

b. Update the password for the account that is used to run the Office SharePoint Server Search service. To do this, type the following line at the command prompt, and then press ENTER:
stsadm.exe -o osearch -farmserviceaccount DomainName\UserName -farmservicepassword NewPassword

c. If the server farm is configured to use single sign-on, update the password for the account that is used by the Microsoft Single Sign-On Service. To do this, follow these steps:
1.      Click Operations in SharePoint 3.0 Central Administration, and then click Service accounts under Security Configuration.
2.      Under Windows service, click Single Sign-On Service.
3.      Under Configurable, specify the password, and then click OK.

d. Update the password for the default content access account that is used by the Office SharePoint Server Search service. To do this, follow these steps:
1.      Open SharePoint 3.0 Central Administration, and then click the link to the SSP Web application under Shared Services Administration.
2.      Under Search, click Search settings, and then click Default content access account.
3.      Specify the password to use for the content access account, and then click OK.

---------------------------------------------------------------------------------------------------
But still getting the same error not able to create web application
Pl guide me.
0
Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

 
Rainer JeschorCommented:
Hi,
have you reviewed the ULS logs? In there you would find a detailed error message which would help us to provide you a working answer instead of guessing.
When you create your new web application,  do you create a new app pool or do you use an existing one? When creating a new app pool - which account do you use?
Do you use Windows or SQL authentication for the content database?

Thanks.
KR
Rainer
0
 
Minesh ShahSharePoint & all about itAuthor Commented:
Hi, in Windows Event Log below error is displaying:
Event Id: 5586: Unknown SQL Exception 208 occured. Additional error information from SQL Server is included below.
Invalid object name 'master.dbo.spt_values'.
-------------------------------------
I am attaching SharePoint Log also. SharePoint-Log.txt
-----------------------------------
During creation of new web app i am creating a new app pool and using the same account means the account (SharePoint and WSS service even SSP also using the same domain Id and SQL Server 2005 also using the same domain id.)
And using Windows authentication for the content database.
0
 
Rainer JeschorCommented:
Hi,
as far as I can read from the log, there is an issue with the SQL Server master database (invalid object).
Could you please verify the steps mentioned here:
http://blogs.msdn.com/b/suhde/archive/2009/04/05/invalid-object-name-master-dbo-spt-values-microsoft-sql-server-error-208.aspx

HTH
Rainer
0
 
Minesh ShahSharePoint & all about itAuthor Commented:
Dear RainerJ, thanks for the solution, it's working for me.
thanks a lot.
Regards,
0

Featured Post

Upgrade your Question Security!

Add Premium security features to your question to ensure its privacy or anonymity. Learn more about your ability to control Question Security today.

  • 3
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now