473,394 Members | 1,774 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,394 software developers and data experts.

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,

Miguel

Oct 15 '07 #1
2 1686
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 español : http://asp.net.do/foros/
======================================
"shapper" <md*****@gmail.comwrote in message news:11**********************@y27g2000pre.googlegr oups.com...
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

Oct 15 '07 #2
On Oct 15, 11:38 pm, "Juan T. Llibre" <nomailrepl...@nowhere.com>
wrote:
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 español :http://asp.net.do/foros/
======================================

"shapper" <mdmo...@gmail.comwrote in messagenews:11**********************@y27g2000pre.g ooglegroups.com...
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
Thanks!

Cheers,
Miguel

Oct 16 '07 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
by: fiona | last post by:
Reading, Berkshire, UK 05 June 2007 - Crainiate Software make details available of the release of Objecto Framework 2.0, an upgrade to their enterprise business component framework, designed to...
1
by: Charles Turner | last post by:
Hi guys, Hope some of you SQL database experts out there can help me, 'cos at the moment I'm going mad! I want to use ACT! 2008 which uses MSSQL on 2 Laptops, (Vista & XP) one is my own...
5
by: Claudio M. E. Bastos Iorio | last post by:
Hi, anyone using VS2008 (final) on windows Vista? I have a problem. The ASP.NET web site administration tool on any site created by VS2008, running on Vista, is not working as it should. I can...
6
by: Martin Racette | last post by:
Hi, I have installed VB2008 Express a few months ago, and yesterday I was trying to create a new program and that program requires the use of a database, so I tried to create the SQL database,...
11
by: =?Utf-8?B?UGV0ZXIgSw==?= | last post by:
I am working with Visual Studio or alternately with Expression Web. I need to create about 50 aspx pages with about 1200 thumbnali images, typically arranged in three to four groups per page,...
1
by: MarcW | last post by:
I have a fresh install of VS2008, and when I drag a data grid on and try and bind it (create a new connection) I get an error. If I connect to a database in the database window and then try and...
2
by: =?Utf-8?B?U2FsYW1FbGlhcw==?= | last post by:
have a fresh new install of VS2008 on Vista 64Bit and SQL management studio. I manage to connect to the sql 2008 from within the management studio but when I am not able to create a database...
6
by: AAaron123 | last post by:
I need to move a database from sql server 2008 to sql express 2008. Will backing up the sql server 2008 database to a file and then using that file to restore to sql express 2008 work? I don't...
2
by: davood00 | last post by:
Hello experts, I have a very common question. Recently I've written a C# project and used SQLEXPRESS 2008 In it. Now, I need a simple and quick way to create an install file for it. This install...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.