View Single Post
Old July 15th, 2006, 07:05 AM
arsaral arsaral is offline
Registered User
Join Date: Jul 2006
Location: ISTANBUL, , Turkey.
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via MSN to arsaral


I had the same problem I guess:

"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 was trying to move Scott's DB examples from EXPRESS to PRO.

1st of all SQL Configuration must be right. TCPIP, PIPEs etc. must be enabled.

2nd I guess PRO keeps the connections open when you change solutions.
Or sthg like that. So I deleted the connections and created a new one.

3rd and most important: DO NOT FORGET to click the ADVANCED button and set the DB type to EXPRESS. Because the default is MSSQLSERVER.


Ali Riza SARAL