Monday, March 12, 2012

VS 2008. Can't create database.

Hello,

I just installed VS 2008.

I opened the Server Explorer window and right clicked on Data
Connections and selected "Create New SQL Server Database".

Then I selected the Server Name and wrote the database name. I have
Windows Authentication selected.

When I click OK I get the error:

"An error has occurred while establishing a connection to the server.
When connection 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 Provides, error: 40 - Could not
open a connection to SQL Server)

Could someone, please, tell me what I am doing wrong?

Thanks,

MiguelYou need to configure SQL Server 2005 Express to accept remote connections.

See this KB : http://support.microsoft.com/kb/914277
Juan T. Llibre, asp.net MVP
asp.net faq : http://asp.net.do/faq/
foros de asp.net, en espaol : http://asp.net.do/foros/
======================================
"shapper" <mdmoura@.gmail.comwrote in message news:1192486496.767299.286530@.y27g2000pre.googlegr oups.com...

Quote:

Originally Posted by

Hello,
>
I just installed VS 2008.
>
I opened the Server Explorer window and right clicked on Data
Connections and selected "Create New SQL Server Database".
>
Then I selected the Server Name and wrote the database name. I have
Windows Authentication selected.
>
When I click OK I get the error:
>
"An error has occurred while establishing a connection to the server.
When connection 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 Provides, error: 40 - Could not
open a connection to SQL Server)
>
Could someone, please, tell me what I am doing wrong?
>
Thanks,
>
Miguel
>


On Oct 15, 11:38 pm, "Juan T. Llibre" <nomailrepl...@.nowhere.com>
wrote:

Quote:

Originally Posted by

You need to configure SQL Server 2005 Express to accept remote connections.
>
See this KB :http://support.microsoft.com/kb/914277
>
Juan T. Llibre, asp.net MVP
asp.net faq :http://asp.net.do/faq/
foros de asp.net, en espaol :http://asp.net.do/foros/
======================================
>
"shapper" <mdmo...@.gmail.comwrote in messagenews:1192486496.767299.286530@.y27g2000pre.g ooglegroups.com...

Quote:

Originally Posted by

Hello,


>

Quote:

Originally Posted by

I just installed VS 2008.


>

Quote:

Originally Posted by

I opened the Server Explorer window and right clicked on Data
Connections and selected "Create New SQL Server Database".


>

Quote:

Originally Posted by

Then I selected the Server Name and wrote the database name. I have
Windows Authentication selected.


>

Quote:

Originally Posted by

When I click OK I get the error:


>

Quote:

Originally Posted by

"An error has occurred while establishing a connection to the server.
When connection 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 Provides, error: 40 - Could not
open a connection to SQL Server)


>

Quote:

Originally Posted by

Could someone, please, tell me what I am doing wrong?


>

Quote:

Originally Posted by

Thanks,


>

Quote:

Originally Posted by

Miguel


Thanks!

Cheers,
Miguel

0 comments:

Post a Comment