April 23, 2012 at 5:22 am
Hi,
I have a strange problem that I have been trying to fix for the last few days. When I run Xp_readerrorlog there is normally a couple of lines saying listening on Server is listening on [ 'any' <ipv4> XXXX] but there is no entry. It may be irrelevant but in another working instance I get 139 rows in the errorlog, but in the none working instance I get 39.
I have SQL 2005 working on there no problem but the SQL 2008 r2 is the one I want (need) to use. The system is win 7 (dont know if that is the issue), SQL 2008 R2. Its a new machine connected to the domain, but not a domain controller of course.
Thanks for your help (copy of error log below, couldn't see where to attach)
2012-04-23 08:52:26.260ServerMicrosoft SQL Server 2008 R2 (RTM) - 10.50.1600.1 (X64) Apr 2 2010 15:48:46 Copyright (c) Microsoft Corporation Express Edition with Advanced Services (64-bit) on Windows NT 6.1 <X64> (Build 7601: Service Pack 1)
2012-04-23 08:52:26.350Server(c) Microsoft Corporation.
2012-04-23 08:52:26.350ServerAll rights reserved.
2012-04-23 08:52:26.350ServerServer process ID is 1864.
2012-04-23 08:52:26.360ServerSystem Manufacturer: 'Hewlett-Packard', System Model: 'HP Compaq 6200 Pro SFF PC'.
2012-04-23 08:52:26.370ServerAuthentication mode is WINDOWS-ONLY.
2012-04-23 08:52:26.380ServerLogging SQL Server messages in file 'c:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\Log\ERRORLOG'.
2012-04-23 08:52:26.440ServerThis instance of SQL Server last reported using a process ID of 3628 at 20/04/2012 17:44:37 (local) 20/04/2012 16:44:37 (UTC). This is an informational message only; no user action is required.
2012-04-23 08:52:26.440ServerRegistry startup parameters: -d c:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\master.mdf -e c:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\Log\ERRORLOG -l c:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\mastlog.ldf
2012-04-23 08:52:26.640ServerSQL Server is starting at normal priority base (=7). This is an informational message only. No user action is required.
2012-04-23 08:52:26.640ServerDetected 4 CPUs. This is an informational message; no user action is required.
2012-04-23 08:52:27.280ServerUsing 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.
2012-04-23 08:52:29.300ServerNode configuration: node 0: CPU mask: 0x000000000000000f:0 Active CPU mask: 0x000000000000000f:0. This message provides a description of the NUMA configuration for this computer. This is an informational message only. No user action is required.
2012-04-23 08:52:29.970spid6sStarting up database 'master'.
2012-04-23 08:52:30.550spid6sRecovery is writing a checkpoint in database 'master' (1). This is an informational message only. No user action is required.
2012-04-23 08:52:31.370spid6sFILESTREAM: effective level = 0, configured level = 0, file system access share name = 'MSSQLSERVER'.
2012-04-23 08:52:32.090spid6sSQL Trace ID 1 was started by login "sa".
2012-04-23 08:52:32.240spid6sStarting up database 'mssqlsystemresource'.
2012-04-23 08:52:32.330spid6sThe resource database build version is 10.50.1600. This is an informational message only. No user action is required.
2012-04-23 08:52:32.770spid10sStarting up database 'model'.
2012-04-23 08:52:32.780spid6sServer name is 'ITFAPP01'. This is an informational message only. No user action is required.
2012-04-23 08:52:32.820spid6sInformational: No full-text supported languages found.
2012-04-23 08:52:32.890spid6sStarting up database 'msdb'.
2012-04-23 08:52:33.090spid10sClearing tempdb database.
2012-04-23 08:52:33.480spid10sStarting up database 'tempdb'.
2012-04-23 08:52:33.840spid13sThe Service Broker protocol transport is disabled or not configured.
2012-04-23 08:52:33.850spid13sThe Database Mirroring protocol transport is disabled or not configured.
2012-04-23 08:52:34.130spid13sService Broker manager has started.
2012-04-23 08:52:34.130spid6sRecovery is complete. This is an informational message only. No user action is required.
2012-04-23 08:52:35.280ServerA self-generated certificate was successfully loaded for encryption.
2012-04-23 08:52:35.300ServerServer local connection provider is ready to accept connection on [ \\.\pipe\SQLLocal\MSSQLSERVER ].
2012-04-23 08:52:35.300ServerServer local connection provider is ready to accept connection on [ \\.\pipe\sql\query ].
2012-04-23 08:52:35.300ServerDedicated administrator connection support was not started because it is disabled on this edition of SQL Server. If you want to use a dedicated administrator connection, restart SQL Server using the trace flag 7806. This is an informational message only. No user action is required.
2012-04-23 08:52:35.850ServerThe SQL Server Network Interface library successfully registered the Service Principal Name (SPN) [ MSSQLSvc/ITFAPP01.itfitz.lan ] for the SQL Server service.
2012-04-23 08:52:35.850ServerSQL Server is now ready for client connections. This is an informational message; no user action is required.
2012-04-23 12:05:40.330ServerServer resumed execution after being idle 9746 seconds: user activity awakened the server. This is an informational message only. No user action is required.
2012-04-23 12:05:48.110spid54Attempting to load library 'xpstar.dll' into memory. This is an informational message only. No user action is required.
2012-04-23 12:05:48.140spid54Using 'xpstar.dll' version '2009.100.1600' to execute extended stored procedure 'xp_instance_regread'. This is an informational message only; no user action is required.
Cheers
Karl
April 23, 2012 at 5:38 am
To which port SS2K5 says it is listening to?
To which port SS2K8R2 says it is listening to?
Is SS2K8R2 up?
Can you connect localy to it?
Can you connect remotely to it?
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.April 23, 2012 at 5:59 am
Hi,
SQL 2005 I think on 49886, I can connect from another machine to that no problem itfapp01\sqlexpress,49886 (even though the instance is called sqlexpress2005 I guess the port overrides it)
For SQL 2008 there is nothing in the error log. Where would I find it out netstat, there is a lot in there?
C:\Users\interprise>NETSTAT
Active Connections
Proto Local Address Foreign Address State
TCP 127.0.0.1:2002 ITFAPP01:56092 ESTABLISHED
TCP 127.0.0.1:56092 ITFAPP01:2002 ESTABLISHED
TCP 172.16.29.25:135 itfitzsbs:47873 ESTABLISHED
TCP 172.16.29.25:135 itfitzsbs:47874 ESTABLISHED
TCP 172.16.29.25:3389 itfitzsbs:44139 ESTABLISHED
TCP 172.16.29.25:49171 212.118.234.141:https ESTABLISHED
TCP 172.16.29.25:49886 itfitzsbs:47872 ESTABLISHED
TCP 172.16.29.25:58092 itfitzsbs:47879 ESTABLISHED
TCP [::1]:49224 ITFAPP01:49226 ESTABLISHED
TCP [::1]:49226 ITFAPP01:49224 ESTABLISHED
TCP [fe80::116c:758b:79e8:c050%13]:16992 ITFAPP01:58062 TIME_WAIT
TCP [fe80::116c:758b:79e8:c050%13]:16992 ITFAPP01:58064 TIME_WAIT
TCP [fe80::116c:758b:79e8:c050%13]:58047 ITFAPP01:16992 TIME_WAIT
TCP [fe80::116c:758b:79e8:c050%13]:58052 ITFAPP01:16992 TIME_WAIT
TCP [fe80::116c:758b:79e8:c050%13]:58053 ITFAPP01:16992 TIME_WAIT
TCP [fe80::116c:758b:79e8:c050%13]:58058 ITFAPP01:16992 TIME_WAIT
TCP [fe80::116c:758b:79e8:c050%13]:58059 ITFAPP01:16992 TIME_WAIT
TCP [fe80::116c:758b:79e8:c050%13]:58064 ITFAPP01:16992 TIME_WAIT
TCP [fe80::116c:758b:79e8:c050%13]:58065 ITFAPP01:16992 TIME_WAIT
TCP [fe80::116c:758b:79e8:c050%13]:58068 ITFAPP01:16992 TIME_WAIT
TCP [fe80::116c:758b:79e8:c050%13]:58070 ITFAPP01:16992 TIME_WAIT
TCP [fe80::116c:758b:79e8:c050%13]:58071 ITFAPP01:16992 TIME_WAIT
TCP [fe80::116c:758b:79e8:c050%13]:58077 ITFAPP01:16992 TIME_WAIT
TCP [fe80::116c:758b:79e8:c050%13]:58083 ITFAPP01:16992 TIME_WAIT
TCP [fe80::116c:758b:79e8:c050%13]:58089 ITFAPP01:16992 TIME_WAIT
TCP [fe80::116c:758b:79e8:c050%13]:58095 ITFAPP01:16992 TIME_WAIT
TCP [fe80::116c:758b:79e8:c050%13]:58097 ITFAPP01:16992 TIME_WAIT
TCP [fe80::116c:758b:79e8:c050%13]:58098 ITFAPP01:16992 TIME_WAIT
TCP [fe80::116c:758b:79e8:c050%13]:58104 ITFAPP01:16992 TIME_WAIT
TCP [fe80::116c:758b:79e8:c050%13]:58109 ITFAPP01:16992 TIME_WAIT
TCP [fe80::116c:758b:79e8:c050%13]:58110 ITFAPP01:16992 TIME_WAIT
TCP [fe80::116c:758b:79e8:c050%13]:58116 ITFAPP01:16992 TIME_WAIT
C:\Users\interprise>
Kind regards
Karl
April 23, 2012 at 1:38 pm
What protocols do you have enabled under network configuration?
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply