Cannot connect to the configuration database.

I am running Windoes 2003 Small Business. When trying to connect to my
company website I get the following error "Cannot connect to the
configuration database. For tips on troubleshooting this error, search for
article 823287 in the Microsoft Knowledge Base at
http://support.microsoft.com." This article propmts me (in method 1) to chec
k
that MSSQLSERVER or MSSQL$SHAREPOINT services are running.
Niether of these are listed in my services. Sure could use some help here.
Martin TaylorMartin:
Did you cross-post this in the SBS section? This sounds more like a
SharePoint issue than SQL Server issues. Did you install the SharePoint
options when you installed SBS? I'm guessing not if you don't see those two
services on the server.
HTH
--
Todd C
[If this response was helpful, please indicate by clicking the appropria
te
answer at the bottom]
"Martin Taylor" wrote:

> I am running Windoes 2003 Small Business. When trying to connect to my
> company website I get the following error "Cannot connect to the
> configuration database. For tips on troubleshooting this error, search for
> article 823287 in the Microsoft Knowledge Base at
> http://support.microsoft.com." This article propmts me (in method 1) to ch
eck
> that MSSQLSERVER or MSSQL$SHAREPOINT services are running.
> Niether of these are listed in my services. Sure could use some help here
.
> Martin Taylor|||Both SQL and Sharepoint services are running.
"Todd C" wrote:
[vbcol=seagreen]
> Martin:
> Did you cross-post this in the SBS section? This sounds more like a
> SharePoint issue than SQL Server issues. Did you install the SharePoint
> options when you installed SBS? I'm guessing not if you don't see those tw
o
> services on the server.
> HTH
> --
> Todd C
> [If this response was helpful, please indicate by clicking the appropr
iate
> answer at the bottom]
>
> "Martin Taylor" wrote:
>|||Then what did you mean by "Niether of these are listed in my services."?
Todd C
"Martin Taylor" wrote:
[vbcol=seagreen]
> Both SQL and Sharepoint services are running.
> "Todd C" wrote:
>|||I have just learned that niether ar listed as MSSQLSERVER or MSSQL$SHAREPOIN
T
any longer but instead are simply listed as SQLSERVER and SHAREPOINT SEVICES
.
Martin
"Todd C" wrote:
[vbcol=seagreen]
> Then what did you mean by "Niether of these are listed in my services."?
>
> --
> Todd C
>
> "Martin Taylor" wrote:
>|||OK. So the SQL Service and SharePoint services are installed and running.
To see if SharePoint's config database is there and accepting connections:
Open a command prompt. Type: sqlcmd <enter> (or osql <enter> )
If you get 1> as a return, then type the following:
1> select name from sys.databases
2>go
Look for a database name with 'config' in the name. My guess is that you
will have a bunch with <cCompany Name> followed by _PROF, _SERV, _SITE, and
_Config.
Still in your SQLCMD prompt, type this:
1> use <config database name>
2> go
Return should be "Changed database context to '<config database name>'. "
Now type:
1> select name from sys.tables
2> go
If you don't get error messages, then the config database is up and running
and accepting connections. Therefore, the problem would lie eslewhere.
(to get out of the SQLCMD, type EXIT)
Let me know how it goes.
Todd C
[If this response was helpful, please indicate by clicking the appropria
te
answer at the bottom]