| Author |
Topic |
|
bogey
Posting Yak Master
166 Posts |
 Posted - 2007-05-14 : 15:16:24
|
| Straight from the sqlagent error file: (the username and login I'm providing is correct. for testing purposes only its and admin account and works on another instance)2007-05-14 15:12:07 - ! [298] SQLServer Error: 10061, TCP Provider: No connection could be made because the target machine actively refused it. [SQLSTATE 08001] 2007-05-14 15:12:07 - ! [165] ODBC Error: 0, Login timeout expired [SQLSTATE HYT00] 2007-05-14 15:12:07 - ! [298] SQLServer Error: 10061, 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. [SQLSTATE 08001] 2007-05-14 15:12:07 - ! [000] Unable to connect to server '(local)'; SQLServerAgent cannot start2007-05-14 15:12:38 - ! [298] SQLServer Error: 10061, TCP Provider: No connection could be made because the target machine actively refused it. [SQLSTATE 08001] 2007-05-14 15:12:38 - ! [165] ODBC Error: 0, Login timeout expired [SQLSTATE HYT00] 2007-05-14 15:12:38 - ! [298] SQLServer Error: 10061, 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. [SQLSTATE 08001] 2007-05-14 15:12:38 - ! [382] Logon to server '(local)' failed (DisableAgentXPs)2007-05-14 15:12:39 - ? [098] SQLServerAgent terminated (normally) |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-05-14 : 23:03:02
|
| Is sql server browser service running? Any message in windows app event log? |
 |
|
|
jezemine
Master Smack Fu Yak Hacker
2886 Posts |
Posted - 2007-05-14 : 23:44:09
|
is the sql server service running? the error you are seeing means that agent couldn't even attempt to authenticate - the sql server service did not respond.
www.elsasoft.org |
|
|
|
bogey
Posting Yak Master
166 Posts |
Posted - 2007-05-15 : 08:15:05
|
| I thought if I installed the sp2 onto sql2005 it may take care of these problems but I'm now getting Login Failed: HResult 0x274D, Level 16, State TCP Provider: No connection could be made because the target machine actively refused it. Qqlcmd: Error: Microsoft SQL Native Client: An error has cccurred |
|
|
|
jezemine
Master Smack Fu Yak Hacker
2886 Posts |
Posted - 2007-05-15 : 11:01:32
|
are you able to connect to the sql server instance by any method at all? SSMS, sqlcmd.exe, etc?
www.elsasoft.org |
|
|
|
bogey
Posting Yak Master
166 Posts |
Posted - 2007-05-15 : 13:08:23
|
Got the agent to run. Needed to alter my registry settings and point hte ServerHost entry to 127.0.0.1 for my default instance. NOW I cannot upgrade my default instance to sp2. My named instance has no problems and they both run with the same accounts. @!?@@Any ideas. Our next step is wipe the machine. I've done about 6 install, uninstalls so far and nothing is working.quote:
Originally posted by jezemine
are you able to connect to the sql server instance by any method at all? SSMS, sqlcmd.exe, etc?
www.elsasoft.org
|
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-05-15 : 13:20:06
|
| Check sql server log of your default instance to see what's real ip address it's listening on. |
|
|
|
bogey
Posting Yak Master
166 Posts |
Posted - 2007-05-15 : 14:46:06
|
| Here is my log file. I trying to figure why I must change my reg file to start the agent but cannot get the sp2 to install?? A self-generated certificate was successfully loaded for encryption.2007-05-15 14:43:06.60 Server Server is listening on [ 127.0.0.1 <ipv4> 1433].2007-05-15 14:43:06.62 Server Server is listening on [ xxx.xx.203.22 <ipv4> 1433].2007-05-15 14:43:06.62 Server Server local connection provider is ready to accept connection on [ \\.\pipe\SQLLocal\MSSQLSERVER ].2007-05-15 14:43:06.62 Server Server local connection provider is ready to accept connection on [ \\.\pipe\sql\query ].2007-05-15 14:43:06.62 Server Server is listening on [ 127.0.0.1 <ipv4> 1434].2007-05-15 14:43:06.62 Server Dedicated admin connection support was established for listening locally on port 1434.2007-05-15 14:43:06.62 Server SQL Server is now ready for client connections. This is an informational message; no user action is required.2007-05-15 14:43:06.65 spid5s Starting up database 'msdb'.2007-05-15 14:43:06.68 spid5s Recovery of any in-doubt distributed transactions involving Microsoft Distributed Transaction Coordinator (MS DTC) has completed. This is an informational message only. No user action is required.2007-05-15 14:43:06.68 spid5s Recovery is complete. This is an informational message only. No user action is required.2007-05-15 14:43:24.62 spid12s Service Broker manager has shut down.2007-05-15 14:43:24.64 spid5s SQL Server is terminating in response to a 'stop' request from Service Control Manager. This is an informational message only. No user action is required.2007-05-15 14:43:24.64 spid5s SQL Trace was stopped due to server shutdown. Trace ID = '1'. This is an informational message only; no user action is required. |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-05-15 : 15:07:41
|
| Shouldn't change registry, double check ip addresses in sql server configuration manager. |
|
|
|
bogey
Posting Yak Master
166 Posts |
Posted - 2007-05-15 : 16:22:46
|
I've looked everywhere. We were running 2 ip's on this machine and removed one of them. I think we need to do fresh install of the OS. Bad way to try and solve the problem but it seems like thats our only option.quote:
Originally posted by rmiao
Shouldn't change registry, double check ip addresses in sql server configuration manager.
|
|
|
|
Invalid_User
Starting Member
1 Post |
|
|
|
Cannot start MSSQLSERVER Agent