November 1, 2007 at 11:12 am
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_regsql -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/
November 1, 2007 at 5:59 pm
Try the below connection string
aspnet_regsql -S \SQLEXPRESS -E -A all -d
the -S option should be as . So pls use your servername before the instance name
Regards..Vidhya Sagar
SQL-Articles
November 2, 2007 at 4:55 am
Thank you!
Problem solved.
November 3, 2007 at 6:22 pm
Have tried everything, step by step, and I still get the
"SQL Server does not allow remote connections"
message. I hope I'm not imposing but I would appreciate any guidance. Thanks in advance for your help!
November 3, 2007 at 7:03 pm
can u log into Management studio using your SQL credentials using SQL server authentication?
November 3, 2007 at 7:09 pm
I can only log to the DABOSSES\SQLEXPRESS server with Windows authentication.
November 3, 2007 at 7:22 pm
Hi SQLServerCentral,
Have you enabled Remote connections under surface area configuration??? If not use the below link
How to enable remote connections in SQL2005
You can also check this blog SQL Server Express WebLog for portocol problem and sql server connectivity.
You have mentioned that you are able to connect with windows authentication, if you need both authentication check this How to: Change Server Authentication Mode.
Regards..Vidhya Sagar
SQL-Articles
November 3, 2007 at 10:35 pm
Thanks, vidhya! However, tried everything to no avail. Guess I'll use some other program, like MySQL. Best to you!
November 5, 2007 at 7:28 am
Don't give up so easily, post your error messages and the kind folks on this forum will help you out!
Have you enabled remote connections?
How are you trying to connect?
What error messages are you getting?
November 6, 2007 at 4:34 am
Hey, Jim. I am sure that the members of this forum will do their best to help. The problem is that I tried everything suggested by Microsoft, members here and others, and I kept getting the same error. Paraphrasing, no remote connections allowed. I even went as far as rebuilding my system to pre "express" installations and kept getting the same message. On the other hand, the same day I installed MySQL I was building databases. A shame because, I know SQL Server is a better program. In the end, I know I must have screwed up somewhere. If I had the time, I would look for that "screwup". Thanks, anyway. I'll be around. There is a lot to learn here!
January 3, 2008 at 10:23 am
For what it's worth, I also experienced severe challenges trying to get Named Pipes to work, following the 'best' MS advice. In the end, connecting from SS2k5 Standard Edition via the SSMgmtStudio using ONLY the IP address worked to connect with a remote SS2k5 Express database. I have no clue what failed initially, only that after I opened everything up, it worked for IP, but still fails for Named Pipes. Should I be worried about other land mines as I proceed down this path? I've been able to remotely back up the database using a job in the Standard Edition's MgmtStudio. I've also managed to publish/distribute the database from Express to the SE machine (my work station).
Referential links available upon request - mostly BOL and MS blogs.
Steve
Viewing 11 posts - 1 through 10 (of 10 total)
You must be logged in to reply to this topic. Login to reply