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 check
that MSSQLSERVER or MSSQL$SHAREPOINT services are running.
Niether of these are listed in my services. Sure could use some help here.
Martin Taylor
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 two
services on the server.
HTH
Todd C
[If this response was helpful, please indicate by clicking the appropriate
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 check
> 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 two
> services on the server.
> HTH
> --
> Todd C
> [If this response was helpful, please indicate by clicking the appropriate
> 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$SHAREPOINT
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 appropriate
answer at the bottom]

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]

Cannot connect to SQL Server 2005 DB from ASP.NET Configuration Tool

Hello,

I am trying to connect to a DB, which is hosted on an SQL Server 2005 by a provider, using ASP.NET Configuration Tool. The result is the following error when I click on the Security Tab:

--
There is a problem with your selected data store. This can be caused by an invalid server name or credentials, or by insufficient permission. It can also be caused by the role manager feature not being enabled. Click the button below to be redirected to a page where you can choose a new data store.

The following message may help in diagnosing the problem: An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)
--

The hosting provider checked that my connection string is correct. They do not know why I get the error, though. Here is a relevant snippet from my web.config:

<connectionStrings>

<removename="LocalSqlServer" />

<addname="LocalSqlServer"

connectionString="Data Source=ABC;Integrated Security=false;Initial Catalog=ABC;User ID=ABC;Password=ABC"

providerName="System.Data.SqlClient" />

</connectionStrings>

ABC is a mock :)

Could anyone pls help? It is much appreciated.

Can you ping the servername successully? Try to use IP address instead of servername as Data Source. Also make sure no firewall is blocking the TCP/IP port used by the SQL Server service (check the port in SQL Server Configuration Manager->SQL Server 2005 Network Configuration)|||

Iori_Jay:

Can you ping the servername successully? Try to use IP address instead of servername as Data Source. Also make sure no firewall is blocking the TCP/IP port used by the SQL Server service (check the port in SQL Server Configuration Manager->SQL Server 2005 Network Configuration)

I can ping the server name successfully. The VWD Express can also connect to the server just fine. So, the firewall does not block the port. But ASP.NET Configuration tool cannot connect to the server. Why? Any ideas are much appreciated.

|||

It did not help to replace the server name by IP address either...

|||

I solved the problem. The process WebDev.WebServer.exe was not allowed to access the internet by the Zone Alarm Firewall. This is a default Zone Alarm setting, which has to be changed manually.

Cannot connect to sql database using Config app tool.

hi AllI'm new comer , the first time to work with Ent lib , I try to use modify sql connection string using configuration application tool integrated in Visual Studio against sql server 200 , I got this error .

_http://imagesshared.com/images/jdv1192388741v.JPG

I don't know how to solve my problem , someone please help me to overcome this problem .Thanks in advance .sorry for my poor English , I'm a Vietnamese student .

The problem is that you're trying to connect to a Sql server express user instance, but you're in fact using Sql Server 2000. You can modify your connection string to work with sql server 2000, or you can download and install sql server express - this is a free download from here:http://msdn2.microsoft.com/en-us/sql/Aa336346.aspx .

|||

DO the following modification in the Connection String of the App.Config / Web.config ...

Remove the AttributeUser Instance =true from the connection string that should solve the issue

|||

Thanks Svante , skurocks for replying

Then I solved my problem , thanks skurocks|||

Hi All

I got this error when I try to display whole record of customers table into GridView .

_http://imagesshared.com/images/opt1192519086n.JPG

This is the first time I work with Ent Lib 3.1 .

Here is my source code , please help me and explain to me why this error occur .

_http://www.4shared.com/file/26591127/38feb983/WebSite1.html?dirPwdVerified=814e49b

Thanks in advance for your time .

.........

Regards

Cannot connect to locally SQL Server in C#.net 2005 Express

I am trying to do the Chapter 1 project of Getting Started with ADO.net 2.0 Step by Step (microsoft press)...

I enter the data source configuration wizard and select database, and press next.

I then press the new connection button, and the Choose data source screen appears.

In the List are only 2 options:

Microsoft Access Database File

Microsoft SQL Server Database File.

The option they want me to choose does not appear in the list.

Microsoft SQL Server sqlclient

I tried following the instructions in this thread [http://forums.microsoft.com/msdn/showpost.aspx?postid=85686&siteid=1] where a user had a similar problem, but had no success.

I have reinstalled C#, reinstalled SQL Server Express 2005 with Advanced Tools, but neither helped.

Any help would be greatly appriciated.

sao123

This seems like a difference between Express and Pro edtions of these products. The connections between VS and SQL are slightly different in the Express Edtions of VS. I've read parts of this book and you have to modify the connection instruction when you're using an Express Edition, the book assumes you're using VS Pro.

I found you could either must make a copy of the database into each project and change the connections to be User Instance based, our you could manually Attach the database to the SQL Express Parent and then modify the connection strings manually an not follow the instructions in the book.

Mike

Cannot connect to locally SQL Server in C#.net 2005 Express

I am trying to do the Chapter 1 project of Getting Started with ADO.net 2.0 Step by Step (microsoft press)...

I enter the data source configuration wizard and select database, and press next.

I then press the new connection button, and the Choose data source screen appears.

In the List are only 2 options:

Microsoft Access Database File

Microsoft SQL Server Database File.

The option they want me to choose does not appear in the list.

Microsoft SQL Server sqlclient

I tried following the instructions in this thread [http://forums.microsoft.com/msdn/showpost.aspx?postid=85686&siteid=1] where a user had a similar problem, but had no success.

I have reinstalled C#, reinstalled SQL Server Express 2005 with Advanced Tools, but neither helped.

Any help would be greatly appriciated.

sao123

This seems like a difference between Express and Pro edtions of these products. The connections between VS and SQL are slightly different in the Express Edtions of VS. I've read parts of this book and you have to modify the connection instruction when you're using an Express Edition, the book assumes you're using VS Pro.

I found you could either must make a copy of the database into each project and change the connections to be User Instance based, our you could manually Attach the database to the SQL Express Parent and then modify the connection strings manually an not follow the instructions in the book.

Mike