I just got a new laptop for work, and our local IT/Hardware guy used
PCMover from Laplink to migrate the apps and settings from my old
machine to this new one. I was skeptical, but it's actually worked
quite well, the biggest issue that I'm having is getting SQL Server to
run on the new machine.
Using SQL Server 2000. Both laptops are Windows XP Pro SP2.
After the migration, I did have to recreate the services for the
server and agent (those services weren't migrated):
C:\Program Files\Microsoft SQL Server\80\Tools\Binn\scm.exe -action 5 -
service MSSQLServer -exepath "c:\Program Files\Microsoft SQL Server
\MSSQL\Binn\sqlservr.exe"
C:\Program Files\Microsoft SQL Server\80\Tools\Binn\scm.exe -action 5 -
service SQLSERVERAGENT -exepath "c:\Program Files\Microsoft SQL Server
\MSSQL\Binn\sqlagent.exe" -dependencies MSSQLServer
If I don't include the SQL Server dependency on the SQL Agent, then
the Agent starts just fine. When I try to start the SQL Server
service, it displays a dialog error:
The MSSQLServer service on Local Computer started and then stopped.
Some Services stop automatically if they have no work to do, for
example, the Performance Logs and Alerts service.
Here's the contents of the server log:
2007-02-08 10:38:58.14 server Microsoft SQL Server 2000 - 8.00.760
(Intel X86)
Dec 17 2002 14:22:05
Copyright (c) 1988-2003 Microsoft Corporation
Developer Edition on Windows NT 5.1 (Build 2600: Service Pack 2)
2007-02-08 10:38:58.14 server Copyright (C) 1988-2002 Microsoft
Corporation.
2007-02-08 10:38:58.14 server All rights reserved.
2007-02-08 10:38:58.14 server Server Process ID is 5860.
2007-02-08 10:38:58.14 server Logging SQL Server messages in file
'C:\Program Files\Microsoft SQL Server\MSSQL\log\ERRORLOG'.
2007-02-08 10:38:58.17 server SQL Server is starting at priority
class 'normal'(2 CPUs detected).
2007-02-08 10:38:58.84 server SQL Server configured for thread mode
processing.
2007-02-08 10:38:58.84 server Using dynamic lock allocation. [2500]
Lock Blocks, [5000] Lock Owner Blocks.
2007-02-08 10:38:58.87 server Attempting to initialize Distributed
Transaction Coordinator.
2007-02-08 10:38:58.89 server Failed to obtain
TransactionDispenserInterface: Result Code = 0x8004d01b
2007-02-08 10:38:58.89 server Unable to load any NETLIBs. Server
shutting down.
2007-02-08 10:38:58.89 spid4 Starting up database 'master'.
The failure to obtain TransactionDispenserInterface message was
occurring on the old machine, so I conclude that isn't part of the
issue.
The Server Network Utility does show TCP/IP as the only protocol
enabled. The Network Libraries tab does show the TCP/IP SSNETLIB.DLL
listed and that dll is residing in the expected location (C:\Program
Files\Microsoft SQL Server\MSSQL\Binn).
The service properties page page Log On tab shows the Local System
Account to be used for logon.
So, I'm figuring it can't find ssnetlib.dll. Short of uninstalling
and re-installing SQL Server, how can I get my SQL Server back up and
running?
Thanks in advance
Mark>I just got a new laptop for work, and our local IT/Hardware guy used
> PCMover from Laplink to migrate the apps and settings from my old
> machine to this new one. I was skeptical,
And you should have been. The errorlog clearly states that SQL Server cannot load any netlibs, so it
refuses to start. I.e., the installation isn't OK...
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
<mark.a.lemoine@.gmail.com> wrote in message
news:1170950095.972400.293760@.s48g2000cws.googlegroups.com...
>I just got a new laptop for work, and our local IT/Hardware guy used
> PCMover from Laplink to migrate the apps and settings from my old
> machine to this new one. I was skeptical, but it's actually worked
> quite well, the biggest issue that I'm having is getting SQL Server to
> run on the new machine.
> Using SQL Server 2000. Both laptops are Windows XP Pro SP2.
> After the migration, I did have to recreate the services for the
> server and agent (those services weren't migrated):
> C:\Program Files\Microsoft SQL Server\80\Tools\Binn\scm.exe -action 5 -
> service MSSQLServer -exepath "c:\Program Files\Microsoft SQL Server
> \MSSQL\Binn\sqlservr.exe"
> C:\Program Files\Microsoft SQL Server\80\Tools\Binn\scm.exe -action 5 -
> service SQLSERVERAGENT -exepath "c:\Program Files\Microsoft SQL Server
> \MSSQL\Binn\sqlagent.exe" -dependencies MSSQLServer
> If I don't include the SQL Server dependency on the SQL Agent, then
> the Agent starts just fine. When I try to start the SQL Server
> service, it displays a dialog error:
> The MSSQLServer service on Local Computer started and then stopped.
> Some Services stop automatically if they have no work to do, for
> example, the Performance Logs and Alerts service.
> Here's the contents of the server log:
> 2007-02-08 10:38:58.14 server Microsoft SQL Server 2000 - 8.00.760
> (Intel X86)
> Dec 17 2002 14:22:05
> Copyright (c) 1988-2003 Microsoft Corporation
> Developer Edition on Windows NT 5.1 (Build 2600: Service Pack 2)
> 2007-02-08 10:38:58.14 server Copyright (C) 1988-2002 Microsoft
> Corporation.
> 2007-02-08 10:38:58.14 server All rights reserved.
> 2007-02-08 10:38:58.14 server Server Process ID is 5860.
> 2007-02-08 10:38:58.14 server Logging SQL Server messages in file
> 'C:\Program Files\Microsoft SQL Server\MSSQL\log\ERRORLOG'.
> 2007-02-08 10:38:58.17 server SQL Server is starting at priority
> class 'normal'(2 CPUs detected).
> 2007-02-08 10:38:58.84 server SQL Server configured for thread mode
> processing.
> 2007-02-08 10:38:58.84 server Using dynamic lock allocation. [2500]
> Lock Blocks, [5000] Lock Owner Blocks.
> 2007-02-08 10:38:58.87 server Attempting to initialize Distributed
> Transaction Coordinator.
> 2007-02-08 10:38:58.89 server Failed to obtain
> TransactionDispenserInterface: Result Code = 0x8004d01b
> 2007-02-08 10:38:58.89 server Unable to load any NETLIBs. Server
> shutting down.
> 2007-02-08 10:38:58.89 spid4 Starting up database 'master'.
> The failure to obtain TransactionDispenserInterface message was
> occurring on the old machine, so I conclude that isn't part of the
> issue.
> The Server Network Utility does show TCP/IP as the only protocol
> enabled. The Network Libraries tab does show the TCP/IP SSNETLIB.DLL
> listed and that dll is residing in the expected location (C:\Program
> Files\Microsoft SQL Server\MSSQL\Binn).
> The service properties page page Log On tab shows the Local System
> Account to be used for logon.
> So, I'm figuring it can't find ssnetlib.dll. Short of uninstalling
> and re-installing SQL Server, how can I get my SQL Server back up and
> running?
> Thanks in advance
> Mark
>sql
Showing posts with label mssqlserver. Show all posts
Showing posts with label mssqlserver. Show all posts
Tuesday, March 27, 2012
Can't start the MSSQLServer Service
I just got a new laptop for work, and our local IT/Hardware guy used
PCMover from Laplink to migrate the apps and settings from my old
machine to this new one. I was skeptical, but it's actually worked
quite well, the biggest issue that I'm having is getting SQL Server to
run on the new machine.
Using SQL Server 2000. Both laptops are Windows XP Pro SP2.
After the migration, I did have to recreate the services for the
server and agent (those services weren't migrated):
C:\Program Files\Microsoft SQL Server\80\Tools\Binn\scm.exe -action 5 -
service MSSQLServer -exepath "c:\Program Files\Microsoft SQL Server
\MSSQL\Binn\sqlservr.exe"
C:\Program Files\Microsoft SQL Server\80\Tools\Binn\scm.exe -action 5 -
service SQLSERVERAGENT -exepath "c:\Program Files\Microsoft SQL Server
\MSSQL\Binn\sqlagent.exe" -dependencies MSSQLServer
If I don't include the SQL Server dependency on the SQL Agent, then
the Agent starts just fine. When I try to start the SQL Server
service, it displays a dialog error:
The MSSQLServer service on Local Computer started and then stopped.
Some Services stop automatically if they have no work to do, for
example, the Performance Logs and Alerts service.
Here's the contents of the server log:
2007-02-08 10:38:58.14 server Microsoft SQL Server 2000 - 8.00.760
(Intel X86)
Dec 17 2002 14:22:05
Copyright (c) 1988-2003 Microsoft Corporation
Developer Edition on Windows NT 5.1 (Build 2600: Service Pack 2)
2007-02-08 10:38:58.14 server Copyright (C) 1988-2002 Microsoft
Corporation.
2007-02-08 10:38:58.14 server All rights reserved.
2007-02-08 10:38:58.14 server Server Process ID is 5860.
2007-02-08 10:38:58.14 server Logging SQL Server messages in file
'C:\Program Files\Microsoft SQL Server\MSSQL\log\ERRORLOG'.
2007-02-08 10:38:58.17 server SQL Server is starting at priority
class 'normal'(2 CPUs detected).
2007-02-08 10:38:58.84 server SQL Server configured for thread mode
processing.
2007-02-08 10:38:58.84 server Using dynamic lock allocation. [2500]
Lock Blocks, [5000] Lock Owner Blocks.
2007-02-08 10:38:58.87 server Attempting to initialize Distributed
Transaction Coordinator.
2007-02-08 10:38:58.89 server Failed to obtain
TransactionDispenserInterface: Result Code = 0x8004d01b
2007-02-08 10:38:58.89 server Unable to load any NETLIBs. Server
shutting down.
2007-02-08 10:38:58.89 spid4 Starting up database 'master'.
The failure to obtain TransactionDispenserInterface message was
occurring on the old machine, so I conclude that isn't part of the
issue.
The Server Network Utility does show TCP/IP as the only protocol
enabled. The Network Libraries tab does show the TCP/IP SSNETLIB.DLL
listed and that dll is residing in the expected location (C:\Program
Files\Microsoft SQL Server\MSSQL\Binn).
The service properties page page Log On tab shows the Local System
Account to be used for logon.
So, I'm figuring it can't find ssnetlib.dll. Short of uninstalling
and re-installing SQL Server, how can I get my SQL Server back up and
running?
Thanks in advance
Mark>I just got a new laptop for work, and our local IT/Hardware guy used
> PCMover from Laplink to migrate the apps and settings from my old
> machine to this new one. I was skeptical,
And you should have been. The errorlog clearly states that SQL Server cannot
load any netlibs, so it
refuses to start. I.e., the installation isn't OK...
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
<mark.a.lemoine@.gmail.com> wrote in message
news:1170950095.972400.293760@.s48g2000cws.googlegroups.com...
>I just got a new laptop for work, and our local IT/Hardware guy used
> PCMover from Laplink to migrate the apps and settings from my old
> machine to this new one. I was skeptical, but it's actually worked
> quite well, the biggest issue that I'm having is getting SQL Server to
> run on the new machine.
> Using SQL Server 2000. Both laptops are Windows XP Pro SP2.
> After the migration, I did have to recreate the services for the
> server and agent (those services weren't migrated):
> C:\Program Files\Microsoft SQL Server\80\Tools\Binn\scm.exe -action 5 -
> service MSSQLServer -exepath "c:\Program Files\Microsoft SQL Server
> \MSSQL\Binn\sqlservr.exe"
> C:\Program Files\Microsoft SQL Server\80\Tools\Binn\scm.exe -action 5 -
> service SQLSERVERAGENT -exepath "c:\Program Files\Microsoft SQL Server
> \MSSQL\Binn\sqlagent.exe" -dependencies MSSQLServer
> If I don't include the SQL Server dependency on the SQL Agent, then
> the Agent starts just fine. When I try to start the SQL Server
> service, it displays a dialog error:
> The MSSQLServer service on Local Computer started and then stopped.
> Some Services stop automatically if they have no work to do, for
> example, the Performance Logs and Alerts service.
> Here's the contents of the server log:
> 2007-02-08 10:38:58.14 server Microsoft SQL Server 2000 - 8.00.760
> (Intel X86)
> Dec 17 2002 14:22:05
> Copyright (c) 1988-2003 Microsoft Corporation
> Developer Edition on Windows NT 5.1 (Build 2600: Service Pack 2)
> 2007-02-08 10:38:58.14 server Copyright (C) 1988-2002 Microsoft
> Corporation.
> 2007-02-08 10:38:58.14 server All rights reserved.
> 2007-02-08 10:38:58.14 server Server Process ID is 5860.
> 2007-02-08 10:38:58.14 server Logging SQL Server messages in file
> 'C:\Program Files\Microsoft SQL Server\MSSQL\log\ERRORLOG'.
> 2007-02-08 10:38:58.17 server SQL Server is starting at priority
> class 'normal'(2 CPUs detected).
> 2007-02-08 10:38:58.84 server SQL Server configured for thread mode
> processing.
> 2007-02-08 10:38:58.84 server Using dynamic lock allocation. [2500]
> Lock Blocks, [5000] Lock Owner Blocks.
> 2007-02-08 10:38:58.87 server Attempting to initialize Distributed
> Transaction Coordinator.
> 2007-02-08 10:38:58.89 server Failed to obtain
> TransactionDispenserInterface: Result Code = 0x8004d01b
> 2007-02-08 10:38:58.89 server Unable to load any NETLIBs. Server
> shutting down.
> 2007-02-08 10:38:58.89 spid4 Starting up database 'master'.
> The failure to obtain TransactionDispenserInterface message was
> occurring on the old machine, so I conclude that isn't part of the
> issue.
> The Server Network Utility does show TCP/IP as the only protocol
> enabled. The Network Libraries tab does show the TCP/IP SSNETLIB.DLL
> listed and that dll is residing in the expected location (C:\Program
> Files\Microsoft SQL Server\MSSQL\Binn).
> The service properties page page Log On tab shows the Local System
> Account to be used for logon.
> So, I'm figuring it can't find ssnetlib.dll. Short of uninstalling
> and re-installing SQL Server, how can I get my SQL Server back up and
> running?
> Thanks in advance
> Mark
>
PCMover from Laplink to migrate the apps and settings from my old
machine to this new one. I was skeptical, but it's actually worked
quite well, the biggest issue that I'm having is getting SQL Server to
run on the new machine.
Using SQL Server 2000. Both laptops are Windows XP Pro SP2.
After the migration, I did have to recreate the services for the
server and agent (those services weren't migrated):
C:\Program Files\Microsoft SQL Server\80\Tools\Binn\scm.exe -action 5 -
service MSSQLServer -exepath "c:\Program Files\Microsoft SQL Server
\MSSQL\Binn\sqlservr.exe"
C:\Program Files\Microsoft SQL Server\80\Tools\Binn\scm.exe -action 5 -
service SQLSERVERAGENT -exepath "c:\Program Files\Microsoft SQL Server
\MSSQL\Binn\sqlagent.exe" -dependencies MSSQLServer
If I don't include the SQL Server dependency on the SQL Agent, then
the Agent starts just fine. When I try to start the SQL Server
service, it displays a dialog error:
The MSSQLServer service on Local Computer started and then stopped.
Some Services stop automatically if they have no work to do, for
example, the Performance Logs and Alerts service.
Here's the contents of the server log:
2007-02-08 10:38:58.14 server Microsoft SQL Server 2000 - 8.00.760
(Intel X86)
Dec 17 2002 14:22:05
Copyright (c) 1988-2003 Microsoft Corporation
Developer Edition on Windows NT 5.1 (Build 2600: Service Pack 2)
2007-02-08 10:38:58.14 server Copyright (C) 1988-2002 Microsoft
Corporation.
2007-02-08 10:38:58.14 server All rights reserved.
2007-02-08 10:38:58.14 server Server Process ID is 5860.
2007-02-08 10:38:58.14 server Logging SQL Server messages in file
'C:\Program Files\Microsoft SQL Server\MSSQL\log\ERRORLOG'.
2007-02-08 10:38:58.17 server SQL Server is starting at priority
class 'normal'(2 CPUs detected).
2007-02-08 10:38:58.84 server SQL Server configured for thread mode
processing.
2007-02-08 10:38:58.84 server Using dynamic lock allocation. [2500]
Lock Blocks, [5000] Lock Owner Blocks.
2007-02-08 10:38:58.87 server Attempting to initialize Distributed
Transaction Coordinator.
2007-02-08 10:38:58.89 server Failed to obtain
TransactionDispenserInterface: Result Code = 0x8004d01b
2007-02-08 10:38:58.89 server Unable to load any NETLIBs. Server
shutting down.
2007-02-08 10:38:58.89 spid4 Starting up database 'master'.
The failure to obtain TransactionDispenserInterface message was
occurring on the old machine, so I conclude that isn't part of the
issue.
The Server Network Utility does show TCP/IP as the only protocol
enabled. The Network Libraries tab does show the TCP/IP SSNETLIB.DLL
listed and that dll is residing in the expected location (C:\Program
Files\Microsoft SQL Server\MSSQL\Binn).
The service properties page page Log On tab shows the Local System
Account to be used for logon.
So, I'm figuring it can't find ssnetlib.dll. Short of uninstalling
and re-installing SQL Server, how can I get my SQL Server back up and
running?
Thanks in advance
Mark>I just got a new laptop for work, and our local IT/Hardware guy used
> PCMover from Laplink to migrate the apps and settings from my old
> machine to this new one. I was skeptical,
And you should have been. The errorlog clearly states that SQL Server cannot
load any netlibs, so it
refuses to start. I.e., the installation isn't OK...
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
<mark.a.lemoine@.gmail.com> wrote in message
news:1170950095.972400.293760@.s48g2000cws.googlegroups.com...
>I just got a new laptop for work, and our local IT/Hardware guy used
> PCMover from Laplink to migrate the apps and settings from my old
> machine to this new one. I was skeptical, but it's actually worked
> quite well, the biggest issue that I'm having is getting SQL Server to
> run on the new machine.
> Using SQL Server 2000. Both laptops are Windows XP Pro SP2.
> After the migration, I did have to recreate the services for the
> server and agent (those services weren't migrated):
> C:\Program Files\Microsoft SQL Server\80\Tools\Binn\scm.exe -action 5 -
> service MSSQLServer -exepath "c:\Program Files\Microsoft SQL Server
> \MSSQL\Binn\sqlservr.exe"
> C:\Program Files\Microsoft SQL Server\80\Tools\Binn\scm.exe -action 5 -
> service SQLSERVERAGENT -exepath "c:\Program Files\Microsoft SQL Server
> \MSSQL\Binn\sqlagent.exe" -dependencies MSSQLServer
> If I don't include the SQL Server dependency on the SQL Agent, then
> the Agent starts just fine. When I try to start the SQL Server
> service, it displays a dialog error:
> The MSSQLServer service on Local Computer started and then stopped.
> Some Services stop automatically if they have no work to do, for
> example, the Performance Logs and Alerts service.
> Here's the contents of the server log:
> 2007-02-08 10:38:58.14 server Microsoft SQL Server 2000 - 8.00.760
> (Intel X86)
> Dec 17 2002 14:22:05
> Copyright (c) 1988-2003 Microsoft Corporation
> Developer Edition on Windows NT 5.1 (Build 2600: Service Pack 2)
> 2007-02-08 10:38:58.14 server Copyright (C) 1988-2002 Microsoft
> Corporation.
> 2007-02-08 10:38:58.14 server All rights reserved.
> 2007-02-08 10:38:58.14 server Server Process ID is 5860.
> 2007-02-08 10:38:58.14 server Logging SQL Server messages in file
> 'C:\Program Files\Microsoft SQL Server\MSSQL\log\ERRORLOG'.
> 2007-02-08 10:38:58.17 server SQL Server is starting at priority
> class 'normal'(2 CPUs detected).
> 2007-02-08 10:38:58.84 server SQL Server configured for thread mode
> processing.
> 2007-02-08 10:38:58.84 server Using dynamic lock allocation. [2500]
> Lock Blocks, [5000] Lock Owner Blocks.
> 2007-02-08 10:38:58.87 server Attempting to initialize Distributed
> Transaction Coordinator.
> 2007-02-08 10:38:58.89 server Failed to obtain
> TransactionDispenserInterface: Result Code = 0x8004d01b
> 2007-02-08 10:38:58.89 server Unable to load any NETLIBs. Server
> shutting down.
> 2007-02-08 10:38:58.89 spid4 Starting up database 'master'.
> The failure to obtain TransactionDispenserInterface message was
> occurring on the old machine, so I conclude that isn't part of the
> issue.
> The Server Network Utility does show TCP/IP as the only protocol
> enabled. The Network Libraries tab does show the TCP/IP SSNETLIB.DLL
> listed and that dll is residing in the expected location (C:\Program
> Files\Microsoft SQL Server\MSSQL\Binn).
> The service properties page page Log On tab shows the Local System
> Account to be used for logon.
> So, I'm figuring it can't find ssnetlib.dll. Short of uninstalling
> and re-installing SQL Server, how can I get my SQL Server back up and
> running?
> Thanks in advance
> Mark
>
Can't start the MSSQLServer
Sudenly my MSSQLServer stop initilizing.
Error 1069: Error initializing Session
|Any body knows what I can do?
From the command-prompt, NET HELPMSG 1069 returns 'The service did not start
due to a logon failure'. I suggest you validate that the SQL Server service
account and password are correct.
Hope this helps.
Dan Guzman
SQL Server MVP
"Lina Manjarres" <LinaManjarres@.discussions.microsoft.com> wrote in message
news:5F9DB90B-815E-4A35-B277-1FF84E6DF08C@.microsoft.com...
> Sudenly my MSSQLServer stop initilizing.
> Error 1069: Error initializing Session
> |Any body knows what I can do?
|||Thank you Dan.
What I did was to save again the SQL user password and it did work.
Later on, it happend on another machine, so I did the same procedure and it
worked.
Do you know how can I avoid that to happened again?
Thanks a lot!
Lina
"Dan Guzman" wrote:
> From the command-prompt, NET HELPMSG 1069 returns 'The service did not start
> due to a logon failure'. I suggest you validate that the SQL Server service
> account and password are correct.
> --
> Hope this helps.
> Dan Guzman
> SQL Server MVP
> "Lina Manjarres" <LinaManjarres@.discussions.microsoft.com> wrote in message
> news:5F9DB90B-815E-4A35-B277-1FF84E6DF08C@.microsoft.com...
>
>
|||> Do you know how can I avoid that to happened again?
I use an account dedicated for SQL Server services with 'password never
expires'.
Hope this helps.
Dan Guzman
SQL Server MVP
"Lina Manjarres" <Lina Manjarres@.discussions.microsoft.com> wrote in message
news:210D1BCD-BBBA-42B5-8446-5066C8BC1A75@.microsoft.com...[vbcol=seagreen]
> Thank you Dan.
> What I did was to save again the SQL user password and it did work.
> Later on, it happend on another machine, so I did the same procedure and
> it
> worked.
> Do you know how can I avoid that to happened again?
> Thanks a lot!
> Lina
> "Dan Guzman" wrote:
|||Make sure your AD Domain Administrators have designated a seperate SQL
Server OU. From this, you need to block any Group Policies that may be
affecting your service accounts: password resets, complexity rules, lockout
rules, lockout durations, etc. Service Accounts need a different
configuration.
Sincerely,
Anthony Thomas
"Dan Guzman" <guzmanda@.nospam-online.sbcglobal.net> wrote in message
news:OVyvQdk5EHA.1404@.TK2MSFTNGP11.phx.gbl...
> Do you know how can I avoid that to happened again?
I use an account dedicated for SQL Server services with 'password never
expires'.
Hope this helps.
Dan Guzman
SQL Server MVP
"Lina Manjarres" <Lina Manjarres@.discussions.microsoft.com> wrote in message
news:210D1BCD-BBBA-42B5-8446-5066C8BC1A75@.microsoft.com...[vbcol=seagreen]
> Thank you Dan.
> What I did was to save again the SQL user password and it did work.
> Later on, it happend on another machine, so I did the same procedure and
> it
> worked.
> Do you know how can I avoid that to happened again?
> Thanks a lot!
> Lina
> "Dan Guzman" wrote:
Error 1069: Error initializing Session
|Any body knows what I can do?
From the command-prompt, NET HELPMSG 1069 returns 'The service did not start
due to a logon failure'. I suggest you validate that the SQL Server service
account and password are correct.
Hope this helps.
Dan Guzman
SQL Server MVP
"Lina Manjarres" <LinaManjarres@.discussions.microsoft.com> wrote in message
news:5F9DB90B-815E-4A35-B277-1FF84E6DF08C@.microsoft.com...
> Sudenly my MSSQLServer stop initilizing.
> Error 1069: Error initializing Session
> |Any body knows what I can do?
|||Thank you Dan.
What I did was to save again the SQL user password and it did work.
Later on, it happend on another machine, so I did the same procedure and it
worked.
Do you know how can I avoid that to happened again?
Thanks a lot!
Lina
"Dan Guzman" wrote:
> From the command-prompt, NET HELPMSG 1069 returns 'The service did not start
> due to a logon failure'. I suggest you validate that the SQL Server service
> account and password are correct.
> --
> Hope this helps.
> Dan Guzman
> SQL Server MVP
> "Lina Manjarres" <LinaManjarres@.discussions.microsoft.com> wrote in message
> news:5F9DB90B-815E-4A35-B277-1FF84E6DF08C@.microsoft.com...
>
>
|||> Do you know how can I avoid that to happened again?
I use an account dedicated for SQL Server services with 'password never
expires'.
Hope this helps.
Dan Guzman
SQL Server MVP
"Lina Manjarres" <Lina Manjarres@.discussions.microsoft.com> wrote in message
news:210D1BCD-BBBA-42B5-8446-5066C8BC1A75@.microsoft.com...[vbcol=seagreen]
> Thank you Dan.
> What I did was to save again the SQL user password and it did work.
> Later on, it happend on another machine, so I did the same procedure and
> it
> worked.
> Do you know how can I avoid that to happened again?
> Thanks a lot!
> Lina
> "Dan Guzman" wrote:
|||Make sure your AD Domain Administrators have designated a seperate SQL
Server OU. From this, you need to block any Group Policies that may be
affecting your service accounts: password resets, complexity rules, lockout
rules, lockout durations, etc. Service Accounts need a different
configuration.
Sincerely,
Anthony Thomas
"Dan Guzman" <guzmanda@.nospam-online.sbcglobal.net> wrote in message
news:OVyvQdk5EHA.1404@.TK2MSFTNGP11.phx.gbl...
> Do you know how can I avoid that to happened again?
I use an account dedicated for SQL Server services with 'password never
expires'.
Hope this helps.
Dan Guzman
SQL Server MVP
"Lina Manjarres" <Lina Manjarres@.discussions.microsoft.com> wrote in message
news:210D1BCD-BBBA-42B5-8446-5066C8BC1A75@.microsoft.com...[vbcol=seagreen]
> Thank you Dan.
> What I did was to save again the SQL user password and it did work.
> Later on, it happend on another machine, so I did the same procedure and
> it
> worked.
> Do you know how can I avoid that to happened again?
> Thanks a lot!
> Lina
> "Dan Guzman" wrote:
Can't start the MSSQLServer
Sudenly my MSSQLServer stop initilizing.
Error 1069: Error initializing Session
|Any body knows what I can do?From the command-prompt, NET HELPMSG 1069 returns 'The service did not start
due to a logon failure'. I suggest you validate that the SQL Server service
account and password are correct.
--
Hope this helps.
Dan Guzman
SQL Server MVP
"Lina Manjarres" <LinaManjarres@.discussions.microsoft.com> wrote in message
news:5F9DB90B-815E-4A35-B277-1FF84E6DF08C@.microsoft.com...
> Sudenly my MSSQLServer stop initilizing.
> Error 1069: Error initializing Session
> |Any body knows what I can do?|||Thank you Dan.
What I did was to save again the SQL user password and it did work.
Later on, it happend on another machine, so I did the same procedure and it
worked.
Do you know how can I avoid that to happened again?
Thanks a lot!
Lina
"Dan Guzman" wrote:
> From the command-prompt, NET HELPMSG 1069 returns 'The service did not start
> due to a logon failure'. I suggest you validate that the SQL Server service
> account and password are correct.
> --
> Hope this helps.
> Dan Guzman
> SQL Server MVP
> "Lina Manjarres" <LinaManjarres@.discussions.microsoft.com> wrote in message
> news:5F9DB90B-815E-4A35-B277-1FF84E6DF08C@.microsoft.com...
> > Sudenly my MSSQLServer stop initilizing.
> > Error 1069: Error initializing Session
> > |Any body knows what I can do?
>
>|||> Do you know how can I avoid that to happened again?
I use an account dedicated for SQL Server services with 'password never
expires'.
--
Hope this helps.
Dan Guzman
SQL Server MVP
"Lina Manjarres" <Lina Manjarres@.discussions.microsoft.com> wrote in message
news:210D1BCD-BBBA-42B5-8446-5066C8BC1A75@.microsoft.com...
> Thank you Dan.
> What I did was to save again the SQL user password and it did work.
> Later on, it happend on another machine, so I did the same procedure and
> it
> worked.
> Do you know how can I avoid that to happened again?
> Thanks a lot!
> Lina
> "Dan Guzman" wrote:
>> From the command-prompt, NET HELPMSG 1069 returns 'The service did not
>> start
>> due to a logon failure'. I suggest you validate that the SQL Server
>> service
>> account and password are correct.
>> --
>> Hope this helps.
>> Dan Guzman
>> SQL Server MVP
>> "Lina Manjarres" <LinaManjarres@.discussions.microsoft.com> wrote in
>> message
>> news:5F9DB90B-815E-4A35-B277-1FF84E6DF08C@.microsoft.com...
>> > Sudenly my MSSQLServer stop initilizing.
>> > Error 1069: Error initializing Session
>> > |Any body knows what I can do?
>>|||Make sure your AD Domain Administrators have designated a seperate SQL
Server OU. From this, you need to block any Group Policies that may be
affecting your service accounts: password resets, complexity rules, lockout
rules, lockout durations, etc. Service Accounts need a different
configuration.
Sincerely,
Anthony Thomas
"Dan Guzman" <guzmanda@.nospam-online.sbcglobal.net> wrote in message
news:OVyvQdk5EHA.1404@.TK2MSFTNGP11.phx.gbl...
> Do you know how can I avoid that to happened again?
I use an account dedicated for SQL Server services with 'password never
expires'.
--
Hope this helps.
Dan Guzman
SQL Server MVP
"Lina Manjarres" <Lina Manjarres@.discussions.microsoft.com> wrote in message
news:210D1BCD-BBBA-42B5-8446-5066C8BC1A75@.microsoft.com...
> Thank you Dan.
> What I did was to save again the SQL user password and it did work.
> Later on, it happend on another machine, so I did the same procedure and
> it
> worked.
> Do you know how can I avoid that to happened again?
> Thanks a lot!
> Lina
> "Dan Guzman" wrote:
>> From the command-prompt, NET HELPMSG 1069 returns 'The service did not
>> start
>> due to a logon failure'. I suggest you validate that the SQL Server
>> service
>> account and password are correct.
>> --
>> Hope this helps.
>> Dan Guzman
>> SQL Server MVP
>> "Lina Manjarres" <LinaManjarres@.discussions.microsoft.com> wrote in
>> message
>> news:5F9DB90B-815E-4A35-B277-1FF84E6DF08C@.microsoft.com...
>> > Sudenly my MSSQLServer stop initilizing.
>> > Error 1069: Error initializing Session
>> > |Any body knows what I can do?
>>
Error 1069: Error initializing Session
|Any body knows what I can do?From the command-prompt, NET HELPMSG 1069 returns 'The service did not start
due to a logon failure'. I suggest you validate that the SQL Server service
account and password are correct.
--
Hope this helps.
Dan Guzman
SQL Server MVP
"Lina Manjarres" <LinaManjarres@.discussions.microsoft.com> wrote in message
news:5F9DB90B-815E-4A35-B277-1FF84E6DF08C@.microsoft.com...
> Sudenly my MSSQLServer stop initilizing.
> Error 1069: Error initializing Session
> |Any body knows what I can do?|||Thank you Dan.
What I did was to save again the SQL user password and it did work.
Later on, it happend on another machine, so I did the same procedure and it
worked.
Do you know how can I avoid that to happened again?
Thanks a lot!
Lina
"Dan Guzman" wrote:
> From the command-prompt, NET HELPMSG 1069 returns 'The service did not start
> due to a logon failure'. I suggest you validate that the SQL Server service
> account and password are correct.
> --
> Hope this helps.
> Dan Guzman
> SQL Server MVP
> "Lina Manjarres" <LinaManjarres@.discussions.microsoft.com> wrote in message
> news:5F9DB90B-815E-4A35-B277-1FF84E6DF08C@.microsoft.com...
> > Sudenly my MSSQLServer stop initilizing.
> > Error 1069: Error initializing Session
> > |Any body knows what I can do?
>
>|||> Do you know how can I avoid that to happened again?
I use an account dedicated for SQL Server services with 'password never
expires'.
--
Hope this helps.
Dan Guzman
SQL Server MVP
"Lina Manjarres" <Lina Manjarres@.discussions.microsoft.com> wrote in message
news:210D1BCD-BBBA-42B5-8446-5066C8BC1A75@.microsoft.com...
> Thank you Dan.
> What I did was to save again the SQL user password and it did work.
> Later on, it happend on another machine, so I did the same procedure and
> it
> worked.
> Do you know how can I avoid that to happened again?
> Thanks a lot!
> Lina
> "Dan Guzman" wrote:
>> From the command-prompt, NET HELPMSG 1069 returns 'The service did not
>> start
>> due to a logon failure'. I suggest you validate that the SQL Server
>> service
>> account and password are correct.
>> --
>> Hope this helps.
>> Dan Guzman
>> SQL Server MVP
>> "Lina Manjarres" <LinaManjarres@.discussions.microsoft.com> wrote in
>> message
>> news:5F9DB90B-815E-4A35-B277-1FF84E6DF08C@.microsoft.com...
>> > Sudenly my MSSQLServer stop initilizing.
>> > Error 1069: Error initializing Session
>> > |Any body knows what I can do?
>>|||Make sure your AD Domain Administrators have designated a seperate SQL
Server OU. From this, you need to block any Group Policies that may be
affecting your service accounts: password resets, complexity rules, lockout
rules, lockout durations, etc. Service Accounts need a different
configuration.
Sincerely,
Anthony Thomas
"Dan Guzman" <guzmanda@.nospam-online.sbcglobal.net> wrote in message
news:OVyvQdk5EHA.1404@.TK2MSFTNGP11.phx.gbl...
> Do you know how can I avoid that to happened again?
I use an account dedicated for SQL Server services with 'password never
expires'.
--
Hope this helps.
Dan Guzman
SQL Server MVP
"Lina Manjarres" <Lina Manjarres@.discussions.microsoft.com> wrote in message
news:210D1BCD-BBBA-42B5-8446-5066C8BC1A75@.microsoft.com...
> Thank you Dan.
> What I did was to save again the SQL user password and it did work.
> Later on, it happend on another machine, so I did the same procedure and
> it
> worked.
> Do you know how can I avoid that to happened again?
> Thanks a lot!
> Lina
> "Dan Guzman" wrote:
>> From the command-prompt, NET HELPMSG 1069 returns 'The service did not
>> start
>> due to a logon failure'. I suggest you validate that the SQL Server
>> service
>> account and password are correct.
>> --
>> Hope this helps.
>> Dan Guzman
>> SQL Server MVP
>> "Lina Manjarres" <LinaManjarres@.discussions.microsoft.com> wrote in
>> message
>> news:5F9DB90B-815E-4A35-B277-1FF84E6DF08C@.microsoft.com...
>> > Sudenly my MSSQLServer stop initilizing.
>> > Error 1069: Error initializing Session
>> > |Any body knows what I can do?
>>
Can't start SQL on 2005 Cluster
The SQL Server (MSSQLSERVER) service terminated with service-specific error
3417 (0xD59).
This is what I get on my 2005 Cluster when I try to start SQL on one of the
nodes. Another node is running fine, no problems what so ever.
Please help...Check out:
http://msdn2.microsoft.com/en-us/library/aa337262.aspx
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
.
"Leon Shargorodsky" <LeonShargorodsky@.discussions.microsoft.com> wrote in
message news:185F94E0-9E8E-4048-A25B-7311CCDC9D96@.microsoft.com...
The SQL Server (MSSQLSERVER) service terminated with service-specific error
3417 (0xD59).
This is what I get on my 2005 Cluster when I try to start SQL on one of the
nodes. Another node is running fine, no problems what so ever.
Please help...|||I've found that a good way to inadvertently generate this error is to compre
ss the files on the drive that your instance is running on - not to be recom
mended as a rule.
When you attempt to start the instance the System event log gives the servic
e specific error 3417 as you've seen.
The Application event log was a bit more useful for me - "The file "D:\Progr
am Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\master.mdf" is compressed b
ut does not reside in a read-only database or filegroup. The file must be de
compressed."
I decompressed the files and the service started fine - something to conside
r.
Mark
From http://www.developmentnow.com/g/118...>
-Cluster.htm
Posted via DevelopmentNow.com Groups
http://www.developmentnow.com
3417 (0xD59).
This is what I get on my 2005 Cluster when I try to start SQL on one of the
nodes. Another node is running fine, no problems what so ever.
Please help...Check out:
http://msdn2.microsoft.com/en-us/library/aa337262.aspx
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
.
"Leon Shargorodsky" <LeonShargorodsky@.discussions.microsoft.com> wrote in
message news:185F94E0-9E8E-4048-A25B-7311CCDC9D96@.microsoft.com...
The SQL Server (MSSQLSERVER) service terminated with service-specific error
3417 (0xD59).
This is what I get on my 2005 Cluster when I try to start SQL on one of the
nodes. Another node is running fine, no problems what so ever.
Please help...|||I've found that a good way to inadvertently generate this error is to compre
ss the files on the drive that your instance is running on - not to be recom
mended as a rule.
When you attempt to start the instance the System event log gives the servic
e specific error 3417 as you've seen.
The Application event log was a bit more useful for me - "The file "D:\Progr
am Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\master.mdf" is compressed b
ut does not reside in a read-only database or filegroup. The file must be de
compressed."
I decompressed the files and the service started fine - something to conside
r.
Mark
From http://www.developmentnow.com/g/118...>
-Cluster.htm
Posted via DevelopmentNow.com Groups
http://www.developmentnow.com
Can't start SQL on 2005 Cluster
The SQL Server (MSSQLSERVER) service terminated with service-specific error
3417 (0xD59).
This is what I get on my 2005 Cluster when I try to start SQL on one of the
nodes. Another node is running fine, no problems what so ever.
Please help...Check out:
http://msdn2.microsoft.com/en-us/library/aa337262.aspx
--
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
.
"Leon Shargorodsky" <LeonShargorodsky@.discussions.microsoft.com> wrote in
message news:185F94E0-9E8E-4048-A25B-7311CCDC9D96@.microsoft.com...
The SQL Server (MSSQLSERVER) service terminated with service-specific error
3417 (0xD59).
This is what I get on my 2005 Cluster when I try to start SQL on one of the
nodes. Another node is running fine, no problems what so ever.
Please help...|||I've found that a good way to inadvertently generate this error is to compress the files on the drive that your instance is running on - not to be recommended as a rule.
When you attempt to start the instance the System event log gives the service specific error 3417 as you've seen.
The Application event log was a bit more useful for me - "The file "D:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\master.mdf" is compressed but does not reside in a read-only database or filegroup. The file must be decompressed."
I decompressed the files and the service started fine - something to consider.
Mar
From http://www.developmentnow.com/g/118_2006_10_0_0_840331/Cant-start-SQL-on-2005-Cluster.ht
Posted via DevelopmentNow.com Group
http://www.developmentnow.com|||thanks for upstai
From http://www.developmentnow.com/g/118_2006_10_0_0_840331/Cant-start-SQL-on-2005-Cluster.ht
Posted via DevelopmentNow.com Group
http://www.developmentnow.com
3417 (0xD59).
This is what I get on my 2005 Cluster when I try to start SQL on one of the
nodes. Another node is running fine, no problems what so ever.
Please help...Check out:
http://msdn2.microsoft.com/en-us/library/aa337262.aspx
--
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
.
"Leon Shargorodsky" <LeonShargorodsky@.discussions.microsoft.com> wrote in
message news:185F94E0-9E8E-4048-A25B-7311CCDC9D96@.microsoft.com...
The SQL Server (MSSQLSERVER) service terminated with service-specific error
3417 (0xD59).
This is what I get on my 2005 Cluster when I try to start SQL on one of the
nodes. Another node is running fine, no problems what so ever.
Please help...|||I've found that a good way to inadvertently generate this error is to compress the files on the drive that your instance is running on - not to be recommended as a rule.
When you attempt to start the instance the System event log gives the service specific error 3417 as you've seen.
The Application event log was a bit more useful for me - "The file "D:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\master.mdf" is compressed but does not reside in a read-only database or filegroup. The file must be decompressed."
I decompressed the files and the service started fine - something to consider.
Mar
From http://www.developmentnow.com/g/118_2006_10_0_0_840331/Cant-start-SQL-on-2005-Cluster.ht
Posted via DevelopmentNow.com Group
http://www.developmentnow.com|||thanks for upstai
From http://www.developmentnow.com/g/118_2006_10_0_0_840331/Cant-start-SQL-on-2005-Cluster.ht
Posted via DevelopmentNow.com Group
http://www.developmentnow.com
Can't start MSSQLServer services.
Hi,
I am trying to start MSSQLServer then it came up with "The MSSQLSERVER
services on Local Computer started and then stopped. Some services stop
automatically if they have no work to do, for example, the Performance Logs
and Alerts services." message. The service is using local computer account
to start. Where should I start to trouble shooting this problem? I will be
appreciated your tips and information.
Thanks,
Johnny Chow
Johny,
Are you using EM, Control Panel - Services or the Sevices Applet to start
the service? Might try using the local system account as a test to ensure
the service can start then check the permissions of the local account you
are using. Are there any informational errors reported in the application
event log?
A couple of things to look at.
HTH
Jerry
"Johnny Chow" <jchow10@.gmail.com> wrote in message
news:ea%23gEb00FHA.2792@.tk2msftngp13.phx.gbl...
> Hi,
> I am trying to start MSSQLServer then it came up with "The MSSQLSERVER
> services on Local Computer started and then stopped. Some services stop
> automatically if they have no work to do, for example, the Performance
> Logs and Alerts services." message. The service is using local computer
> account to start. Where should I start to trouble shooting this problem?
> I will be appreciated your tips and information.
> Thanks,
> Johnny Chow
>
|||Hi,
I tried both of them. I check the application event log file and found out
the evaluation copy period is over. I am using KB 281574 to upgrade to the
retail. One question is how are we going to dinstinquish between eval and
retail version? I suspected we have a couple of server running evals.
Thank you in advance,
Johnny Chow
"Jerry Spivey" <jspivey@.vestas-awt.com> wrote in message
news:OhpoAf00FHA.404@.TK2MSFTNGP09.phx.gbl...
> Johny,
> Are you using EM, Control Panel - Services or the Sevices Applet to start
> the service? Might try using the local system account as a test to ensure
> the service can start then check the permissions of the local account you
> are using. Are there any informational errors reported in the application
> event log?
> A couple of things to look at.
> HTH
> Jerry
> "Johnny Chow" <jchow10@.gmail.com> wrote in message
> news:ea%23gEb00FHA.2792@.tk2msftngp13.phx.gbl...
>
|||Johnny,
Try:
SELECT SERVERPROPERTY('EDITION')
--OR
SELECT @.@.VERSION
HTH
Jerry
"Johnny Chow" <jchow10@.gmail.com> wrote in message
news:OH5MMx10FHA.3180@.TK2MSFTNGP14.phx.gbl...
> Hi,
> I tried both of them. I check the application event log file and found
> out the evaluation copy period is over. I am using KB 281574 to upgrade
> to the retail. One question is how are we going to dinstinquish between
> eval and retail version? I suspected we have a couple of server running
> evals.
> Thank you in advance,
> Johnny Chow
>
> "Jerry Spivey" <jspivey@.vestas-awt.com> wrote in message
> news:OhpoAf00FHA.404@.TK2MSFTNGP09.phx.gbl...
>
I am trying to start MSSQLServer then it came up with "The MSSQLSERVER
services on Local Computer started and then stopped. Some services stop
automatically if they have no work to do, for example, the Performance Logs
and Alerts services." message. The service is using local computer account
to start. Where should I start to trouble shooting this problem? I will be
appreciated your tips and information.
Thanks,
Johnny Chow
Johny,
Are you using EM, Control Panel - Services or the Sevices Applet to start
the service? Might try using the local system account as a test to ensure
the service can start then check the permissions of the local account you
are using. Are there any informational errors reported in the application
event log?
A couple of things to look at.
HTH
Jerry
"Johnny Chow" <jchow10@.gmail.com> wrote in message
news:ea%23gEb00FHA.2792@.tk2msftngp13.phx.gbl...
> Hi,
> I am trying to start MSSQLServer then it came up with "The MSSQLSERVER
> services on Local Computer started and then stopped. Some services stop
> automatically if they have no work to do, for example, the Performance
> Logs and Alerts services." message. The service is using local computer
> account to start. Where should I start to trouble shooting this problem?
> I will be appreciated your tips and information.
> Thanks,
> Johnny Chow
>
|||Hi,
I tried both of them. I check the application event log file and found out
the evaluation copy period is over. I am using KB 281574 to upgrade to the
retail. One question is how are we going to dinstinquish between eval and
retail version? I suspected we have a couple of server running evals.
Thank you in advance,
Johnny Chow
"Jerry Spivey" <jspivey@.vestas-awt.com> wrote in message
news:OhpoAf00FHA.404@.TK2MSFTNGP09.phx.gbl...
> Johny,
> Are you using EM, Control Panel - Services or the Sevices Applet to start
> the service? Might try using the local system account as a test to ensure
> the service can start then check the permissions of the local account you
> are using. Are there any informational errors reported in the application
> event log?
> A couple of things to look at.
> HTH
> Jerry
> "Johnny Chow" <jchow10@.gmail.com> wrote in message
> news:ea%23gEb00FHA.2792@.tk2msftngp13.phx.gbl...
>
|||Johnny,
Try:
SELECT SERVERPROPERTY('EDITION')
--OR
SELECT @.@.VERSION
HTH
Jerry
"Johnny Chow" <jchow10@.gmail.com> wrote in message
news:OH5MMx10FHA.3180@.TK2MSFTNGP14.phx.gbl...
> Hi,
> I tried both of them. I check the application event log file and found
> out the evaluation copy period is over. I am using KB 281574 to upgrade
> to the retail. One question is how are we going to dinstinquish between
> eval and retail version? I suspected we have a couple of server running
> evals.
> Thank you in advance,
> Johnny Chow
>
> "Jerry Spivey" <jspivey@.vestas-awt.com> wrote in message
> news:OhpoAf00FHA.404@.TK2MSFTNGP09.phx.gbl...
>
Can't start MSSQLServer services.
Hi,
I am trying to start MSSQLServer then it came up with "The MSSQLSERVER
services on Local Computer started and then stopped. Some services stop
automatically if they have no work to do, for example, the Performance Logs
and Alerts services." message. The service is using local computer account
to start. Where should I start to trouble shooting this problem? I will be
appreciated your tips and information.
Thanks,
Johnny ChowJohny,
Are you using EM, Control Panel - Services or the Sevices Applet to start
the service? Might try using the local system account as a test to ensure
the service can start then check the permissions of the local account you
are using. Are there any informational errors reported in the application
event log?
A couple of things to look at.
HTH
Jerry
"Johnny Chow" <jchow10@.gmail.com> wrote in message
news:ea%23gEb00FHA.2792@.tk2msftngp13.phx.gbl...
> Hi,
> I am trying to start MSSQLServer then it came up with "The MSSQLSERVER
> services on Local Computer started and then stopped. Some services stop
> automatically if they have no work to do, for example, the Performance
> Logs and Alerts services." message. The service is using local computer
> account to start. Where should I start to trouble shooting this problem?
> I will be appreciated your tips and information.
> Thanks,
> Johnny Chow
>|||Hi,
I tried both of them. I check the application event log file and found out
the evaluation copy period is over. I am using KB 281574 to upgrade to the
retail. One question is how are we going to dinstinquish between eval and
retail version? I suspected we have a couple of server running evals.
Thank you in advance,
Johnny Chow
"Jerry Spivey" <jspivey@.vestas-awt.com> wrote in message
news:OhpoAf00FHA.404@.TK2MSFTNGP09.phx.gbl...
> Johny,
> Are you using EM, Control Panel - Services or the Sevices Applet to start
> the service? Might try using the local system account as a test to ensure
> the service can start then check the permissions of the local account you
> are using. Are there any informational errors reported in the application
> event log?
> A couple of things to look at.
> HTH
> Jerry
> "Johnny Chow" <jchow10@.gmail.com> wrote in message
> news:ea%23gEb00FHA.2792@.tk2msftngp13.phx.gbl...
>|||Johnny,
Try:
SELECT SERVERPROPERTY('EDITION')
--OR
SELECT @.@.VERSION
HTH
Jerry
"Johnny Chow" <jchow10@.gmail.com> wrote in message
news:OH5MMx10FHA.3180@.TK2MSFTNGP14.phx.gbl...
> Hi,
> I tried both of them. I check the application event log file and found
> out the evaluation copy period is over. I am using KB 281574 to upgrade
> to the retail. One question is how are we going to dinstinquish between
> eval and retail version? I suspected we have a couple of server running
> evals.
> Thank you in advance,
> Johnny Chow
>
> "Jerry Spivey" <jspivey@.vestas-awt.com> wrote in message
> news:OhpoAf00FHA.404@.TK2MSFTNGP09.phx.gbl...
>
I am trying to start MSSQLServer then it came up with "The MSSQLSERVER
services on Local Computer started and then stopped. Some services stop
automatically if they have no work to do, for example, the Performance Logs
and Alerts services." message. The service is using local computer account
to start. Where should I start to trouble shooting this problem? I will be
appreciated your tips and information.
Thanks,
Johnny ChowJohny,
Are you using EM, Control Panel - Services or the Sevices Applet to start
the service? Might try using the local system account as a test to ensure
the service can start then check the permissions of the local account you
are using. Are there any informational errors reported in the application
event log?
A couple of things to look at.
HTH
Jerry
"Johnny Chow" <jchow10@.gmail.com> wrote in message
news:ea%23gEb00FHA.2792@.tk2msftngp13.phx.gbl...
> Hi,
> I am trying to start MSSQLServer then it came up with "The MSSQLSERVER
> services on Local Computer started and then stopped. Some services stop
> automatically if they have no work to do, for example, the Performance
> Logs and Alerts services." message. The service is using local computer
> account to start. Where should I start to trouble shooting this problem?
> I will be appreciated your tips and information.
> Thanks,
> Johnny Chow
>|||Hi,
I tried both of them. I check the application event log file and found out
the evaluation copy period is over. I am using KB 281574 to upgrade to the
retail. One question is how are we going to dinstinquish between eval and
retail version? I suspected we have a couple of server running evals.
Thank you in advance,
Johnny Chow
"Jerry Spivey" <jspivey@.vestas-awt.com> wrote in message
news:OhpoAf00FHA.404@.TK2MSFTNGP09.phx.gbl...
> Johny,
> Are you using EM, Control Panel - Services or the Sevices Applet to start
> the service? Might try using the local system account as a test to ensure
> the service can start then check the permissions of the local account you
> are using. Are there any informational errors reported in the application
> event log?
> A couple of things to look at.
> HTH
> Jerry
> "Johnny Chow" <jchow10@.gmail.com> wrote in message
> news:ea%23gEb00FHA.2792@.tk2msftngp13.phx.gbl...
>|||Johnny,
Try:
SELECT SERVERPROPERTY('EDITION')
--OR
SELECT @.@.VERSION
HTH
Jerry
"Johnny Chow" <jchow10@.gmail.com> wrote in message
news:OH5MMx10FHA.3180@.TK2MSFTNGP14.phx.gbl...
> Hi,
> I tried both of them. I check the application event log file and found
> out the evaluation copy period is over. I am using KB 281574 to upgrade
> to the retail. One question is how are we going to dinstinquish between
> eval and retail version? I suspected we have a couple of server running
> evals.
> Thank you in advance,
> Johnny Chow
>
> "Jerry Spivey" <jspivey@.vestas-awt.com> wrote in message
> news:OhpoAf00FHA.404@.TK2MSFTNGP09.phx.gbl...
>
Sunday, March 25, 2012
Can't start MSSQLServer services.
Hi,
I am trying to start MSSQLServer then it came up with "The MSSQLSERVER
services on Local Computer started and then stopped. Some services stop
automatically if they have no work to do, for example, the Performance Logs
and Alerts services." message. The service is using local computer account
to start. Where should I start to trouble shooting this problem? I will be
appreciated your tips and information.
Thanks,
Johnny ChowJohny,
Are you using EM, Control Panel - Services or the Sevices Applet to start
the service? Might try using the local system account as a test to ensure
the service can start then check the permissions of the local account you
are using. Are there any informational errors reported in the application
event log?
A couple of things to look at.
HTH
Jerry
"Johnny Chow" <jchow10@.gmail.com> wrote in message
news:ea%23gEb00FHA.2792@.tk2msftngp13.phx.gbl...
> Hi,
> I am trying to start MSSQLServer then it came up with "The MSSQLSERVER
> services on Local Computer started and then stopped. Some services stop
> automatically if they have no work to do, for example, the Performance
> Logs and Alerts services." message. The service is using local computer
> account to start. Where should I start to trouble shooting this problem?
> I will be appreciated your tips and information.
> Thanks,
> Johnny Chow
>|||Hi,
I tried both of them. I check the application event log file and found out
the evaluation copy period is over. I am using KB 281574 to upgrade to the
retail. One question is how are we going to dinstinquish between eval and
retail version? I suspected we have a couple of server running evals.
Thank you in advance,
Johnny Chow
"Jerry Spivey" <jspivey@.vestas-awt.com> wrote in message
news:OhpoAf00FHA.404@.TK2MSFTNGP09.phx.gbl...
> Johny,
> Are you using EM, Control Panel - Services or the Sevices Applet to start
> the service? Might try using the local system account as a test to ensure
> the service can start then check the permissions of the local account you
> are using. Are there any informational errors reported in the application
> event log?
> A couple of things to look at.
> HTH
> Jerry
> "Johnny Chow" <jchow10@.gmail.com> wrote in message
> news:ea%23gEb00FHA.2792@.tk2msftngp13.phx.gbl...
>> Hi,
>> I am trying to start MSSQLServer then it came up with "The MSSQLSERVER
>> services on Local Computer started and then stopped. Some services stop
>> automatically if they have no work to do, for example, the Performance
>> Logs and Alerts services." message. The service is using local computer
>> account to start. Where should I start to trouble shooting this problem?
>> I will be appreciated your tips and information.
>> Thanks,
>> Johnny Chow
>|||Johnny,
Try:
SELECT SERVERPROPERTY('EDITION')
--OR
SELECT @.@.VERSION
HTH
Jerry
"Johnny Chow" <jchow10@.gmail.com> wrote in message
news:OH5MMx10FHA.3180@.TK2MSFTNGP14.phx.gbl...
> Hi,
> I tried both of them. I check the application event log file and found
> out the evaluation copy period is over. I am using KB 281574 to upgrade
> to the retail. One question is how are we going to dinstinquish between
> eval and retail version? I suspected we have a couple of server running
> evals.
> Thank you in advance,
> Johnny Chow
>
> "Jerry Spivey" <jspivey@.vestas-awt.com> wrote in message
> news:OhpoAf00FHA.404@.TK2MSFTNGP09.phx.gbl...
>> Johny,
>> Are you using EM, Control Panel - Services or the Sevices Applet to start
>> the service? Might try using the local system account as a test to
>> ensure the service can start then check the permissions of the local
>> account you are using. Are there any informational errors reported in
>> the application event log?
>> A couple of things to look at.
>> HTH
>> Jerry
>> "Johnny Chow" <jchow10@.gmail.com> wrote in message
>> news:ea%23gEb00FHA.2792@.tk2msftngp13.phx.gbl...
>> Hi,
>> I am trying to start MSSQLServer then it came up with "The MSSQLSERVER
>> services on Local Computer started and then stopped. Some services stop
>> automatically if they have no work to do, for example, the Performance
>> Logs and Alerts services." message. The service is using local computer
>> account to start. Where should I start to trouble shooting this
>> problem? I will be appreciated your tips and information.
>> Thanks,
>> Johnny Chow
>>
>sql
I am trying to start MSSQLServer then it came up with "The MSSQLSERVER
services on Local Computer started and then stopped. Some services stop
automatically if they have no work to do, for example, the Performance Logs
and Alerts services." message. The service is using local computer account
to start. Where should I start to trouble shooting this problem? I will be
appreciated your tips and information.
Thanks,
Johnny ChowJohny,
Are you using EM, Control Panel - Services or the Sevices Applet to start
the service? Might try using the local system account as a test to ensure
the service can start then check the permissions of the local account you
are using. Are there any informational errors reported in the application
event log?
A couple of things to look at.
HTH
Jerry
"Johnny Chow" <jchow10@.gmail.com> wrote in message
news:ea%23gEb00FHA.2792@.tk2msftngp13.phx.gbl...
> Hi,
> I am trying to start MSSQLServer then it came up with "The MSSQLSERVER
> services on Local Computer started and then stopped. Some services stop
> automatically if they have no work to do, for example, the Performance
> Logs and Alerts services." message. The service is using local computer
> account to start. Where should I start to trouble shooting this problem?
> I will be appreciated your tips and information.
> Thanks,
> Johnny Chow
>|||Hi,
I tried both of them. I check the application event log file and found out
the evaluation copy period is over. I am using KB 281574 to upgrade to the
retail. One question is how are we going to dinstinquish between eval and
retail version? I suspected we have a couple of server running evals.
Thank you in advance,
Johnny Chow
"Jerry Spivey" <jspivey@.vestas-awt.com> wrote in message
news:OhpoAf00FHA.404@.TK2MSFTNGP09.phx.gbl...
> Johny,
> Are you using EM, Control Panel - Services or the Sevices Applet to start
> the service? Might try using the local system account as a test to ensure
> the service can start then check the permissions of the local account you
> are using. Are there any informational errors reported in the application
> event log?
> A couple of things to look at.
> HTH
> Jerry
> "Johnny Chow" <jchow10@.gmail.com> wrote in message
> news:ea%23gEb00FHA.2792@.tk2msftngp13.phx.gbl...
>> Hi,
>> I am trying to start MSSQLServer then it came up with "The MSSQLSERVER
>> services on Local Computer started and then stopped. Some services stop
>> automatically if they have no work to do, for example, the Performance
>> Logs and Alerts services." message. The service is using local computer
>> account to start. Where should I start to trouble shooting this problem?
>> I will be appreciated your tips and information.
>> Thanks,
>> Johnny Chow
>|||Johnny,
Try:
SELECT SERVERPROPERTY('EDITION')
--OR
SELECT @.@.VERSION
HTH
Jerry
"Johnny Chow" <jchow10@.gmail.com> wrote in message
news:OH5MMx10FHA.3180@.TK2MSFTNGP14.phx.gbl...
> Hi,
> I tried both of them. I check the application event log file and found
> out the evaluation copy period is over. I am using KB 281574 to upgrade
> to the retail. One question is how are we going to dinstinquish between
> eval and retail version? I suspected we have a couple of server running
> evals.
> Thank you in advance,
> Johnny Chow
>
> "Jerry Spivey" <jspivey@.vestas-awt.com> wrote in message
> news:OhpoAf00FHA.404@.TK2MSFTNGP09.phx.gbl...
>> Johny,
>> Are you using EM, Control Panel - Services or the Sevices Applet to start
>> the service? Might try using the local system account as a test to
>> ensure the service can start then check the permissions of the local
>> account you are using. Are there any informational errors reported in
>> the application event log?
>> A couple of things to look at.
>> HTH
>> Jerry
>> "Johnny Chow" <jchow10@.gmail.com> wrote in message
>> news:ea%23gEb00FHA.2792@.tk2msftngp13.phx.gbl...
>> Hi,
>> I am trying to start MSSQLServer then it came up with "The MSSQLSERVER
>> services on Local Computer started and then stopped. Some services stop
>> automatically if they have no work to do, for example, the Performance
>> Logs and Alerts services." message. The service is using local computer
>> account to start. Where should I start to trouble shooting this
>> problem? I will be appreciated your tips and information.
>> Thanks,
>> Johnny Chow
>>
>sql
can't start mssqlserver
I installed a copy of SQL server 2005 on a Win 2003 machine. I connected remotely from another machine and started Sql Server Configuration manager. The MSSQLServer is stopped. So, I click to start and it failed. The error it gave me was that it time out. I am new to SQL 2005 and I thought the next step after installing was to configure. Can anyone help me please.
Check in the SQL Server log file for any info. If SQL received the startup request, the log will show why the timeout occurred. Presumably there was a configuration problem that caused startup to fail.
Also check the network configuration. I believe local connections require shared memory to be enabled.
|||Hi, in addition to the aother post, try to make a snapshot of your event log if you can't figure out the problem and send the appropiate parts (like starting the service which breaks) to this forum again.HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
Subscribe to:
Posts (Atom)