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 |
|
rj8994
Starting Member
1 Post |
 Posted - 2012-04-23 : 10:36:32
|
| 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.260 Server Microsoft 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.350 Server (c) Microsoft Corporation.2012-04-23 08:52:26.350 Server All rights reserved.2012-04-23 08:52:26.350 Server Server process ID is 1864.2012-04-23 08:52:26.360 Server System Manufacturer: 'Hewlett-Packard', System Model: 'HP Compaq 6200 Pro SFF PC'.2012-04-23 08:52:26.370 Server Authentication mode is WINDOWS-ONLY.2012-04-23 08:52:26.380 Server Logging SQL Server messages in file 'c:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\Log\ERRORLOG'.2012-04-23 08:52:26.440 Server This 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.440 Server Registry 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.ldf2012-04-23 08:52:26.640 Server SQL 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.640 Server Detected 4 CPUs. This is an informational message; no user action is required.2012-04-23 08:52:27.280 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.2012-04-23 08:52:29.300 Server Node 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.970 spid6s Starting up database 'master'.2012-04-23 08:52:30.550 spid6s Recovery 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.370 spid6s FILESTREAM: effective level = 0, configured level = 0, file system access share name = 'MSSQLSERVER'.2012-04-23 08:52:32.090 spid6s SQL Trace ID 1 was started by login "sa".2012-04-23 08:52:32.240 spid6s Starting up database 'mssqlsystemresource'.2012-04-23 08:52:32.330 spid6s The 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.770 spid10s Starting up database 'model'.2012-04-23 08:52:32.780 spid6s Server name is 'ITFAPP01'. This is an informational message only. No user action is required.2012-04-23 08:52:32.820 spid6s Informational: No full-text supported languages found.2012-04-23 08:52:32.890 spid6s Starting up database 'msdb'.2012-04-23 08:52:33.090 spid10s Clearing tempdb database.2012-04-23 08:52:33.480 spid10s Starting up database 'tempdb'.2012-04-23 08:52:33.840 spid13s The Service Broker protocol transport is disabled or not configured.2012-04-23 08:52:33.850 spid13s The Database Mirroring protocol transport is disabled or not configured.2012-04-23 08:52:34.130 spid13s Service Broker manager has started.2012-04-23 08:52:34.130 spid6s Recovery is complete. This is an informational message only. No user action is required.2012-04-23 08:52:35.280 Server A self-generated certificate was successfully loaded for encryption.2012-04-23 08:52:35.300 Server Server local connection provider is ready to accept connection on [ \\.\pipe\SQLLocal\MSSQLSERVER ].2012-04-23 08:52:35.300 Server Server local connection provider is ready to accept connection on [ \\.\pipe\sql\query ].2012-04-23 08:52:35.300 Server Dedicated 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.850 Server The 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.850 Server SQL Server is now ready for client connections. This is an informational message; no user action is required.2012-04-23 12:05:40.330 Server Server 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.110 spid54 Attempting to load library 'xpstar.dll' into memory. This is an informational message only. No user action is required.2012-04-23 12:05:48.140 spid54 Using '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.CheersKarl |
|
|
opc.three
Starting Member
5 Posts |
Posted - 2012-04-24 : 17:31:54
|
| What protocols do you have enabled under network configuration?Make everything as simple as possible, but not simpler. -- Albert Einstein |
 |
|
|
|
|
|
|
|
SQL not listening on any port