| alucard001@gmail.com 2006-02-13, 7:23 am |
| Hi all.
This is a very simple but frustrated situation:
1. I am running WIN SBS 2k3 with SQL Server 2005, VS 2005 and MS SQL
server management studion express installed and working properly
2. Open VS2005, and create a new page for testing some ASP.NET code.
3. Open server explorer, and right click the data connections node,
choose "Add connections..."
4. A diaglog box appear, I choose "Microsoft SQL Server", with dropdown
list selecting the second one: ".NET....for SQL Server"
5. NOW CRUCIAL: Click continue, I can select my local computer server
under "Server Name:" DDL. When come to "Select or enter a database
name", I cannot select a database, which have already created and named
"MSTEST"
6. When I click "Test connection" with a self-typed DB name or leave it
empty, I got the following error:
An error has occured 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
connection. (Provider: Named Pipes Provider, error 40 - Could not
open a connection to SQL Server.
7. I followed what the above error msg advice and enable both TCP/IP
and Name Pipes connection. And I also change the setting to allow both
local and remote connection in both TCP/IP and NamePipes under SQL
Server Surface Area Configuration. But it still not work...
I can create and working with a self-created database successfully
using SSMS.
To give you more information, when I look at the server properties in
SSMS (right click the DB server and choose properties), in the
"Connections" node, I checked the box: "Allow remote connections to
this server"
Can anyone please give me some advice on how to solve this problem?
Thanks in advance for reading this.
|