Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
fmardani
Constraint Violating Yak Guru
433 Posts |
 Posted - 2005-12-28 : 18:23:22
|
| Do you know how I can solve this error please?An error has occurred while establishing a connection to the server. When connecting to SQL Server2005, this failure may be caused by the fact that under the default settings SQL Server does notallow remote connections. (provider: SQL Network Interfaces, error: 26 - Error LocatingServer/Instance Specified) |
|
|
axelangeli
Starting Member
1 Post |
Posted - 2005-12-31 : 16:03:07
|
| The remote connectivity is disabled by default. You can activate it using the SQL Server 2005 Surface Area Configuration SQLSAC.EXE.RegardsAxel |
 |
|
|
codeman43
Starting Member
2 Posts |
Posted - 2006-01-08 : 14:22:52
|
Hello,I have the same error but I am not trying to remotely connect. I created a program with SQL server database and deployed it. However, when it is on the deployed machine the same error message is displayed. It works fine on my computer but delivers the error on other computers after installation and trying to launch the program. Perhaps there is something in the configuration that I must reset and then redeploy. I tried the SQL configuration manager to reset the "build-in account" to local system. I thought this would take care of that problem but it seems not to.Any help on this issue would be most appreciative.====I want to be a programmer!  |
|
|
|
mtalcott
Starting Member
1 Post |
Posted - 2006-01-08 : 23:22:52
|
| If you were unable to correct this with by allowing remote connections, then the issue is probably related to your machine.config or web.config not correctly specifying the database that you are trying to connect to. You can find a complete walk through of the fix at [url]http://www.aquesthosting.com/HowTo/Sql2005/SQLError26.aspx[/url]Marc Talcott<a href="http://www.aquesthosting.com">ASP.Net Web Hosting</a> |
|
|
|
|
|
|
connection