November 4, 2008 at 10:21 am
Schadenfreude-Mei (11/4/2008)
ahhh, ok scratch that last comment, hadnt seen you response.Sounds stupid and im grasping at straws now but are they both defined in the same way in services.
I have a similar issues on one of my desktop instances (which i havent had time to look into), where each time i restart the machine the agent fails to log in, BUT if i re-do the login section of services, it works until i restart.
When you say, "redo the login section of services", do you mean you go in and re-enter login and password?
November 4, 2008 at 10:23 am
When you say, "redo the login section of services", do you mean you go in and re-enter login and password?
Yeah. Strange huh!
Adam Zacks-------------------------------------------Be Nice, Or Leave
November 5, 2008 at 10:11 am
Schadenfreude-Mei (11/4/2008)
When you say, "redo the login section of services", do you mean you go in and re-enter login and password?
Yeah. Strange huh!
That is strange...sounds like some cache thing. I recall reading something about how the old passwords can get stuck somewhere ... but, I can't find the article...
November 5, 2008 at 10:12 am
I, along with a system admin here, opened a ticket with Microsoft yesterday. We were on the phone with them for 3.5 hours and still no luck. I will be sure to respond when we find the solution.
If anyone else has any ideas in the mean time - feel free to share. 🙂
November 5, 2008 at 11:43 am
There are a few posts out there to say that their .Net Framework was corrupt. I tested on our dev server, and going to Control Panels -- Add/Remove Program -- click on Microsoft .NET Framework 2.0 Service Pack 1 -- Click on "Click here for more support information" -- click Repair.
Does anyone know what all is affected if I repair the .NET Framework? Can I perform this while there are active connections? Any tips?
November 12, 2008 at 3:45 pm
I thought I would post an update. Sql Server Agent is still unable to start. I did not try the .NET Framework update as we are unsure of the consequences.
A couple other things to note:
1. I am not able to create a trace via SQL Profiler using a windows login - can only get through with a sql login. I have tried multiple windows logins - including domain admins.
TITLE: Connect to Server
------------------------------
Cannot connect to .
------------------------------
ADDITIONAL INFORMATION:
Login failed for user ''. The user is not associated with a trusted SQL Server connection.
(pfutil90)
============================================================
2. I am not able to view SQL Server Logs under Management on SSMS
TITLE: Microsoft SQL Server Management Studio
------------------------------
Failed to retrieve data for this request. (Microsoft.SqlServer.SmoEnum)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&LinkId=20476
------------------------------
ADDITIONAL INFORMATION:
An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)
------------------------------
A severe error occurred on the current command. The results, if any, should be discarded. (Microsoft SQL Server, Error: 0)
============================================================
March 13, 2009 at 2:38 pm
Hi Veteran!
Have you resulted your problem with the SQL Server Agent service? What was the problem?
Could you please share it?
Thanks,
Eugene
🙂
March 13, 2009 at 2:50 pm
cutedeveloper (3/13/2009)
Hi Veteran!Have you resulted your problem with the SQL Server Agent service? What was the problem?
Could you please share it?
Thanks,
Eugene
🙂
Sorry to report that we did not find a solution for this problem. We needed to upgrade our servers, so, this problem disappeared after upgrading and re-installing SQL Server.
March 16, 2009 at 7:31 am
Thanks. I have solved my problem. I was just a stupid misspell in the Agent connection properties (Alias Local Host Server)... 🙂
Viewing 9 posts - 16 through 23 (of 23 total)
You must be logged in to reply to this topic. Login to reply