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 |
|
Danish kamran
Starting Member
4 Posts |
 Posted - 2009-01-12 : 03:41:39
|
| Hello,I'm new to SQL-server 2005. I'm using 180-days trail version( Evaluation) for learning purpose. Now a days I'm learning Services of SQL-Server 2005.I have configured services through services console in Windows XP.some servesis were already running like MSSQLServer services, while some other I start Manually.Now what happen is when I start SQL Server Agent Services (clicking on it and then press start button on service window) after some time it stops automatically. Is this normal behaviour or there is some thing wrong.I tried this to 3-4 time but same thing happens again and agian(i.e whenever I press start button after 8-10 seconds it stop).Please guide me in this matter I shall be thankfull.Regards,Danish Kamran |
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2009-01-12 : 06:16:07
|
Do it in SQL Server Configuration Manager and not in Windows Services Console.GreetingsWebfred
No, you're never too old to Yak'n'Roll if you're too young to die. |
 |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2009-01-12 : 08:55:25
|
quote:
Originally posted by webfred
Do it in SQL Server Configuration Manager and not in Windows Services Console.GreetingsWebfred
No, you're never too old to Yak'n'Roll if you're too young to die.
It is same whether you do it through Config or Services . |
|
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2009-01-12 : 15:09:28
|
Ok - it was just an idea because of this:http://msdn.microsoft.com/en-us/library/ms174212(SQL.90).aspx quote:
Always use SQL Server tools such as SQL Server Configuration Manager to change the account used by the SQL Server or SQL Server Agent services, or to change the password for the account. In addition to changing the account name, SQL Server Configuration Manager performs additional configuration such as setting permissions in the Windows Registry so that the new account can read the SQL Server settings. Other tools such as the Windows Services Control Manager can change the account name but do not change associated settings. If the service cannot access the SQL Server portion of the registry the service may not start properly.
So I thought: maybe in this case there is an unknown problem too when starting via Windows Service Console.GreetingsWebfred
No, you're never too old to Yak'n'Roll if you're too young to die. |
|
|
|
|
|
|
Question Regarding SQL Server 2005 Services