MOSS Forum

Ask Question   UnAnswered
Home » Forum » MOSS       RSS Feeds

Server Admin Templates as STP Files

  Asked By: Madeline    Date: Nov 18    Category: MOSS    Views: 1152

I have SPS 2007 authentication issues. I see an error in the event viewer as
"SQL DAtabase 'wss_content' on sql server instance 'machine name' not found.
Cannot open database requested in login 'wss_content'. login fails.

Can someone help me resolve this asap. i need to complete this in the next
one hour.

I have a small server farm scenario set up..I have sql server running on a
different machine



4 Answers Found

Answer #1    Answered By: Angarika Shroff     Answered On: Nov 18

First try to ping your SQL server  from the portal server....Also just
make sure that the SQL Server is running.....

I faced the same issue and the only error was that my SQL was

Answer #2    Answered By: Eliza Hutchinson     Answered On: Nov 18

I see that WSS has some permission problems. This is SPS
2007. that's the error i see often in event viewer.

Answer #3    Answered By: Lesley Tate     Answered On: Nov 18

This often occurs when the application pool, or its identity, is changed
after the fact. You might also verify the app pool user account hasn't
expired or the password wasn't changed.

Answer #4    Answered By: Vinay Thakur     Answered On: Nov 18

Presuming a working network, a working SharePoint, and a running SQL

'wss_content' is the default name of the content database created when
the first Web Application is created. Sounds like the application pool
account has: the wrong credentials and cannot login, doesn't have
permission to the database, or cannot route to the database. I presume
that you are using a domain account for the application pool rather than
a local account since your SQL Server is on a different machine.

Too many other variables could be contributing to make other assertions.

Didn't find what you were looking for? Find more on Server Admin Templates as STP Files Or get search suggestion and latest updates.