all groups > sql server new users > november 2007 >
You're in the

sql server new users

group:

"SQL Server does not allow for remote connections"


"SQL Server does not allow for remote connections" R.A.M.
11/1/2007 7:44:36 AM
sql server new users:
Hello,
Please help in the following problem:
I cannot create database beacuse of error: SQL Server does not allow for
remote connections.

In fact, I use .NET utility program:
aspnet_reqsql -S SQLEXPRESS -E -A all -d
"D:\MIM-Magazyn\App_Data\aspnetdb"
and I receive the following message (I translate from Polish):
An error occured during stablishing a connection to SQL Server 2005. The
reason of this error may be a fact that according to default settings SQL
Server does not allow for remote connections. (provider: Named pipes
provider, error: 40 - Connection to SQL Server cannot to established).

My SQL Server 2005 Express Edition with Advanced Services runs on localhost
and I have switched on "Local and remote connections / Using both TCP/IP and
named pipes" in SQL Server 2005 Surface Area Configuration. SQL Server
Management Studio Express connects to my SQL Server (SQLEXPRESS) with no
problems.

Please help. I have little experience. Thanks in advance.
/RAM/

AddThis Social Bookmark Button