Connecting to SQLServer

I apologize if this is in the wrong place, I don't know where this
question would be appropriate.
We are doing a class project with ASP .Net and SQL Server. For this
exercise, we had to create tables and then connect to the tables from
a web form.
I have Visual Studio 2005, SQL Server Management Studio (Express) and
SQLServer Express. I can use Server Management studio and run SQL
against my database.
When I try to connect to the database from Visual Studio's Connection
Explorer, I get a long delay and then an error message pops us saying:
"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)"
Is there something I need to configure or can anyone give me some
advice on what I need to do to connect?
Thanks
Mike
I'm so relieved, I got this fixed. It was the Server Browser that
wasn't started. I found this post that helped me locate the problem:
http://blogs.msdn.com/sqlexpress/archive/2004/07/23/192044.aspx
Just posting it here in case someone else come searching for the
answer...
On Feb 26, 4:39 pm, "MikeB" <MPBr...@.gmail.com> wrote:
> I apologize if this is in the wrong place, I don't know where this
> question would be appropriate.
> We are doing a class project with ASP .Net and SQL Server. For this
> exercise, we had to create tables and then connect to the tables from
> a web form.
> I have Visual Studio 2005, SQL Server Management Studio (Express) and
> SQLServer Express. I can use Server Management studio and run SQL
> against my database.
> When I try to connect to the database from Visual Studio's Connection
> Explorer, I get a long delay and then an error message pops us saying:
> "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)"
> Is there something I need to configure or can anyone give me some
> advice on what I need to do to connect?
> Thanks
> Mike