April 7, 2008 at 2:06 pm
Im not sure if this has anything to do with sql server express or not however i get an error while trying to connect to the ASPNETDB.MDF DB when I copy the project over to the server.
A little background on the project. Its a simple asp login control that uses roles and uses the asp.net configuration tool to manage users. The application works flawlessly on my local machine but when i copy it over to the server and goto login.aspx the page displays and i enter my creidentals and then hit login, and im greeted by a nasy error saying:
"An error has occurred 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 connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) "
i've checked my local web.conf file and global web.conf nothing seems out of the ordinary. any ideas as to why this would be happening? any input is greatly appreciated.
Thanks!!!!
April 7, 2008 at 2:51 pm
You need to go to the Sql Server Configuration Manager-> Sql Server Netowork Configuration -> Protocols and set the SQL Server to allow remote connections via at least TCP/IP. By default SQL Server only allows connections from the local machine so as soon as you try to access it across a network you get the error you are getting.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
April 7, 2008 at 3:36 pm
thanks for your very quick response!!! i was mid jump (so excited like a kid in a candy store) when i realized that that and name pipes are both already enabled 🙁 any other reasons for this?
April 7, 2008 at 4:38 pm
Can you post your connection string (minus any private data)?
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
April 7, 2008 at 4:57 pm
as stupid as a response as mine is about to be, thats the whole issue i believe. I can't seem to find where the connection string for this db is in any of my source files, aspx and code behinds and/or my applications web.conf. where should it be and where should i be lookin? sorry for the newb reply :hehe: be gentle please
April 7, 2008 at 7:28 pm
I believe that it is in machine.config, but I actually am not sure and I do not have access to a web server at this moment.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
Viewing 6 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply