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 |
|
BendJoe
Posting Yak Master
128 Posts |
 Posted - 2008-09-05 : 00:14:21
|
| Hi,I recently upgraded my Windows XP home to Professional. I had SQL Server 2005 installed on my machine. Now I am not able to connect to the local sql server instance. But I am able to connect to my office SQL server using Sql authentication.This is the error message I am gettingAn 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) (.Net SqlClient Data Provider)Please help. |
|
|
BendJoe
Posting Yak Master
128 Posts |
Posted - 2008-09-05 : 00:24:52
|
| I got it to work . I used the SQL Server Configuration manager. The service was stopped I restarted it and it looks fine now. |
 |
|
|
|
|
|
Connection Issue