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