Last post Apr 10, 2008 09:57 AM by ashmetry
Apr 10, 2008 06:35 AM|number7|LINK
The starter kit looks great but i want to change it to use full blown sql 2005.
I have changed the web config file,and also allowed remote connections but i am still not getting a connection
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)
Any Ideas ?
Apr 10, 2008 07:21 AM|vik20000in|LINK
Try Connecting to the sql server from any other applictaion and see if you can connect to the database. If the connection works use the same in this application
Apr 10, 2008 08:40 AM|manorfarm|LINK
if working locally your connection string in your web.config should look like this
if you still have a user instance in the string try removing first
If you are getting the error when working locally - go to sql configuration manager > network config > protocols sqlexpress and disable everything except shared memory for now and see if this works
If you are working remotely your connection string should look like this
<remove name="LocalSqlServer" />
<add name="LocalSqlServer" connectionString="Data Source=xxx;Initial Catalog=xxx;UID=xxx;pwd=xxx"
<add name="classifiedsConnection" connectionString="Data Source=xxx;Initial Catalog=xxx;UID=xxx;pwd=xxx"
Apr 10, 2008 09:57 AM|ashmetry|LINK
Missing the user instance is a very common mistake in connection strings...
Another trick to test connectivity to a sql server is to
1. Create a text file on your computer with a .udl extension...
2. double click that file and you should get a wizard that can guide you in the connection...
after sucessfully enstablishing the connection and save it, you can open the udl file in a text editor and view the created connection string.... If nothing you will be able to get the necessary information to enter it in your web.config.