June 10, 2009 at 3:52 am
Hi
i have installed Sqlserver 2005 dev edition(default instance) and Sqlserver 2000 Express edition (named instance)on my local system
Sqlserver 2000 is working fine
SQlserver 2005 two services
1) SqlServer(MSSQLSERVER)
2)SqlServer Agent(MSSQLSERVER)
are not running i tried to start manually then it is giving
error
for
1) SqlServer(MSSQLSERVER)
the Sqlserver(MSSQLSERVER)servicw 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
and
error for
1) SqlServerAgent(MSSQLSERVER)
Couldnot start the SQL Server Agent (MSSQLSERVER) service on local computer
Error 1068 : the dependency service or group failed to start
i could not conncet the sqlserver 2005
pls give the solution to fix the issue
urgent
Thanks in advance
June 10, 2009 at 4:02 am
Are you running sql services under any service account or using default local account
[font="Verdana"]Thanks
Chandra Mohan[/font]
June 10, 2009 at 4:25 am
running sql services under using default local account only
os : xp 2002 sp2
June 10, 2009 at 4:28 am
Did you check out the sql error log file. It will give you an idea why it is failing. Or you can post the error log here
[font="Verdana"]Thanks
Chandra Mohan[/font]
June 10, 2009 at 5:01 am
what is to be checked in error log file
in my system
default path C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG
here ERRORLOG.5 I OPENED THIS HERE WHERE AND WHAT I NEED TO CHECK
AND
IN THIS PATH
C:\Program Files\Microsoft SQL Server
80 FOLDER
90 FOLDER
MSSQL$FIRST(NAMED INSTANCE OF SQL2000)
MSSQL.1
MSSQL.2
MSSQL.3
are there
AND I WOULD LIKE TO KNOW MSSQL.x WHY THESE MANY ARE CREATED AND IF NOT USE HOW TO DELETE
June 10, 2009 at 5:28 am
Erro log will be in C:\Program Files\Microsoft SQL Server\MSSQL.n\MSSQL\LOG\ERRORLOG. Please post the errorlog here or you can attach it to the post. Dont delete the folders. It will effect other servers also.
Thanks
Chandra Mohan N
[font="Verdana"]Thanks
Chandra Mohan[/font]
June 10, 2009 at 5:55 am
Errorlog.5
2009-06-10 15:53:38.21 Server Microsoft SQL Server 2005 - 9.00.1399.06 (Intel X86)
Oct 14 2005 00:33:37
Copyright (c) 1988-2005 Microsoft Corporation
Developer Edition on Windows NT 5.1 (Build 2600: Service Pack 2)
2009-06-10 15:53:38.21 Server (c) 2005 Microsoft Corporation.
2009-06-10 15:53:38.21 Server All rights reserved.
2009-06-10 15:53:38.21 Server Server process ID is 2464.
2009-06-10 15:53:38.21 Server Logging SQL Server messages in file 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\ERRORLOG'.
2009-06-10 15:53:38.21 Server This instance of SQL Server last reported using a process ID of 592 at 6/10/2009 3:53:29 PM (local) 6/10/2009 10:23:29 AM (UTC). This is an informational message only; no user action is required.
2009-06-10 15:53:38.21 Server Registry startup parameters:
2009-06-10 15:53:38.21 Server -d C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\master.mdf
2009-06-10 15:53:38.21 Server -e C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\ERRORLOG
2009-06-10 15:53:38.21 Server -l C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\mastlog.ldf
2009-06-10 15:53:38.23 Server SQL Server is starting at normal priority base (=7). This is an informational message only. No user action is required.
2009-06-10 15:53:38.23 Server Detected 1 CPUs. This is an informational message; no user action is required.
2009-06-10 15:53:38.40 Server Using dynamic lock allocation. Initial allocation of 2500 Lock blocks and 5000 Lock Owner blocks per node. This is an informational message only. No user action is required.
2009-06-10 15:53:38.42 Server Attempting to initialize Microsoft Distributed Transaction Coordinator (MS DTC). This is an informational message only. No user action is required.
2009-06-10 15:53:38.42 Server The Microsoft Distributed Transaction Coordinator (MS DTC) service could not be contacted. If you would like distributed transaction functionality, please start this service.
2009-06-10 15:53:38.42 Server Database Mirroring Transport is disabled in the endpoint configuration.
2009-06-10 15:53:38.43 spid5s Starting up database 'master'.
2009-06-10 15:53:38.64 spid5s SQL Trace ID 1 was started by login "sa".
2009-06-10 15:53:38.70 spid5s Starting up database 'mssqlsystemresource'.
2009-06-10 15:53:38.96 spid5s Server name is 'KARANEXI'. This is an informational message only. No user action is required.
2009-06-10 15:53:39.20 Server A self-generated certificate was successfully loaded for encryption.
2009-06-10 15:53:39.20 Server Error: 26023, Severity: 16, State: 1.
2009-06-10 15:53:39.20 Server Server TCP provider failed to listen on [ 'any' 1433]. Tcp port is already in use.
2009-06-10 15:53:39.20 Server Error: 17182, Severity: 16, State: 1.
2009-06-10 15:53:39.20 Server TDSSNIClient initialization failed with error 0x2740, status code 0xa.
2009-06-10 15:53:39.20 Server Error: 17182, Severity: 16, State: 1.
2009-06-10 15:53:39.20 Server TDSSNIClient initialization failed with error 0x2740, status code 0x1.
2009-06-10 15:53:39.20 Server Error: 17826, Severity: 18, State: 3.
2009-06-10 15:53:39.20 Server Could not start the network library because of an internal error in the network library. To determine the cause, review the errors immediately preceding this one in the error log.
2009-06-10 15:53:39.20 Server Error: 17120, Severity: 16, State: 1.
2009-06-10 15:53:39.20 Server SQL Server could not spawn FRunCM thread. Check the SQL Server error log and the Windows event logs for information about possible related problems.
June 10, 2009 at 9:16 am
Hi,
Disable the VIA protocol in Client Network Utility and check it out.
Thanks
Chandra Mohan N
[font="Verdana"]Thanks
Chandra Mohan[/font]
June 10, 2009 at 10:36 pm
Hi,
Thanks for u r reply
it is already Disabled in the VIA protocol in Client Network Utility.
VIA Propertied :
Default NIc :0
Safault server 0 :1433
Enabled :No
Except Vial all protocals like
Shared Memory :Enabled
Tcp/ip :Enabled
Named Pipes :Enabled
Further help please
Thanks in advance
June 11, 2009 at 4:11 am
Hi experts update please
i stopped 2000 services(named) then started 2k5 services(default)(now the services are running
but if i restarted the system again same problem 2k5 services are stopping
June 11, 2009 at 7:19 am
To resolve the problem
1. Check whether sql browser service is running or not. If it is not running start the service and check out.
2. Stop 2000 and restart 2005 and check out on which port no sql 2005 is running (i.e. use xp_readerrorlog)
3. Stop 2005 and restart 2000 and checkout the port no
(There is a script on this site to find out on which port no and protocol sql server is using)
4. If both are using the same port no configure either 2005 or 2000 to use another port no other than 1433 or 1434. (Sometime frontend applications may require code change checkout with your development team). Refer http://support.microsoft.com/kb/823938 on how to configure
5. This should resolve this problem.
6. If it does not resolve your problem. Update the servers with the latest service packs and check out. And also please post the sp's of your sql servers and also the port no's and protocols the server is using
[font="Verdana"]Thanks
Chandra Mohan[/font]
June 11, 2009 at 11:03 pm
Experts
Update pls.
June 15, 2009 at 8:42 am
Did you try the above one?
[font="Verdana"]Thanks
Chandra Mohan[/font]
Viewing 13 posts - 1 through 12 (of 12 total)
You must be logged in to reply to this topic. Login to reply