| Author |
Topic |
|
cbeganesh
Posting Yak Master
105 Posts |
 Posted - 2008-09-30 : 09:40:23
|
| we are runing a web application and one page when we want to reset a job, it gives error message. we are calling a stored procedure from the web application. i checked @@servername , it looks okay.Any help on this is appreciated."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)" |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-09-30 : 09:56:49
|
| Have you checked SQL Surface area configuration manager to see if remote connections are enabled? |
 |
|
|
cbeganesh
Posting Yak Master
105 Posts |
Posted - 2008-09-30 : 09:59:44
|
| we are having sql server 2000 and can you tell me where is checked sql surface area manager is? |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-09-30 : 10:05:28
|
quote:
Originally posted by cbeganesh
we are having sql server 2000 and can you tell me where is checked sql surface area manager is?
Nope from error message its clear that your db is SQL 2005. I think you're using SQL 2000 query analyser. Have you installed SQL 2005 client tools in your system? |
|
|
|
cbeganesh
Posting Yak Master
105 Posts |
Posted - 2008-09-30 : 10:08:37
|
| i used @@version and here is what i gotMicrosoft SQL Server 2000 - 8.00.760 (Intel X86) Dec 17 2002 14:22:05 Copyright (c) 1988-2003 Microsoft Corporation Standard Edition on Windows NT 5.2 (Build 3790: Service Pack 1) |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-09-30 : 10:15:05
|
quote:
Originally posted by cbeganesh
i used @@version and here is what i gotMicrosoft SQL Server 2000 - 8.00.760 (Intel X86) Dec 17 2002 14:22:05 Copyright (c) 1988-2003 Microsoft Corporation Standard Edition on Windows NT 5.2 (Build 3790: Service Pack 1)
then how will you get this error?"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)"b/w in your query are you trying to access some linked server tables? |
|
|
|
cbeganesh
Posting Yak Master
105 Posts |
Posted - 2008-09-30 : 10:24:38
|
| yes er are executing a procedure on a remote server |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-09-30 : 10:28:25
|
quote:
Originally posted by cbeganesh
yes er are executing a procedure on a remote server
then check if server you're trying to access remotely have the remote connection enabled in configuration manager. For this connect to server via remote desktop or netop and then goto Start->programs->SQLServer2005->ConfigurationTools->SQLSurfaceconfigurationManager |
|
|
|
cbeganesh
Posting Yak Master
105 Posts |
Posted - 2008-09-30 : 10:36:25
|
| we are having only sql server 2000 |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-09-30 : 11:12:08
|
quote:
Originally posted by cbeganesh
we are having only sql server 2000
I'm talking about server which you were trying to access via remote query. Its certainly sql 2005 as per the error. thats why i told to connect to server directly via remote desktop or netop if you can. |
|
|
|
cbeganesh
Posting Yak Master
105 Posts |
Posted - 2008-09-30 : 11:55:53
|
| ok, i remote desktop to the remote server and i see only sql server 2000. I dont know why the error has 2005, In my company we have only 2000 and wehave not upgraded to 2005 |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-09-30 : 12:48:45
|
quote:
Originally posted by cbeganesh
ok, i remote desktop to the remote server and i see only sql server 2000. I dont know why the error has 2005, In my company we have only 2000 and wehave not upgraded to 2005
i'm still not fully sure about it. unless you've atleast one 2005 server involved in your query, you wont get error posted. |
|
|
|
|
sql procedure failing