11/11/2005, 21:07
|
| | | Fecha de Ingreso: marzo-2005
Mensajes: 1.418
Antigüedad: 19 años, 1 mes Puntos: 9 | |
| Monkyta: En la carpeta LOG de MS SQL SERVER, tengo generados varios archivos ErrorLog, por lo que dudo que este verificando en el archivo correcto. En total me generó 8.
Te comento bien como es la situación por lo que he podido razonar. Cuando entro al Enterprise Manager, se me actualiza uno de los archivos ErrorLog con nueva información. Esto sucede cada vez que entro al Enterprise Manager. Pero cuando intento conectarme a través de mi aplicación, no se me actualiza el fichero, por lo que me da a pensar que nunca se llega siquiera a intentar realizar una conexión con el servidor, de lo contrario, este fichero estaría actualizado.
Por eso pienso que es un problema con el puerto 1433, que por lo que leí, es el único mediante el cual se puede entablar esta conexión.
Te muestro que es lo que me genera cuando me conecto al Enterprise Manager:
2005-11-11 23:47:46.10 server Server Process ID is 208.
2005-11-11 23:47:46.10 server Logging SQL Server messages in file 'C:\Archivos de programa\Microsoft SQL Server\MSSQL\log\ERRORLOG'.
2005-11-11 23:47:46.28 server SQL Server is starting at priority class 'normal'(1 CPU detected).
2005-11-11 23:47:47.21 server SQL Server configured for thread mode processing.
2005-11-11 23:47:47.34 server Using dynamic lock allocation. [500] Lock Blocks, [1000] Lock Owner Blocks.
2005-11-11 23:47:47.56 spid3 Starting up database 'master'.
2005-11-11 23:47:48.42 server Using 'SSNETLIB.DLL' version '8.0.194'.
2005-11-11 23:47:48.42 spid5 Starting up database 'model'.
2005-11-11 23:47:48.53 spid3 Server name is 'MARIANO-E4E0962'.
2005-11-11 23:47:48.53 spid3 Skipping startup of clean database id 4
2005-11-11 23:47:48.53 spid3 Skipping startup of clean database id 5
2005-11-11 23:47:48.53 spid3 Skipping startup of clean database id 6
2005-11-11 23:47:48.53 spid3 Skipping startup of clean database id 7
2005-11-11 23:47:48.53 spid3 Skipping startup of clean database id 8
2005-11-11 23:47:48.53 spid3 Skipping startup of clean database id 9
2005-11-11 23:47:48.53 spid3 Skipping startup of clean database id 10
2005-11-11 23:47:48.63 server SQL server listening on Shared Memory, Named Pipes.
2005-11-11 23:47:48.63 server SQL Server is ready for client connections
2005-11-11 23:47:48.92 spid5 Clearing tempdb database.
2005-11-11 23:47:49.70 spid5 Starting up database 'tempdb'.
2005-11-11 23:47:49.92 spid3 Recovery complete.
2005-11-11 23:54:23.15 spid51 Starting up database 'MyBase'.
2005-11-11 23:54:24.29 spid51 Starting up database 'MyBase'.
2005-11-11 23:54:24.46 spid51 Starting up database 'MyBase'.
2005-11-11 23:56:25.31 spid52 Starting up database 'AdvertisingHomeBase'.
2005-11-11 23:56:25.51 spid52 Starting up database 'ChattingHomeBase'.
2005-11-11 23:56:25.67 spid52 Starting up database 'MailSenderHomeBase'.
2005-11-11 23:56:25.90 spid52 Starting up database 'msdb'.
2005-11-11 23:56:26.18 spid52 Starting up database 'Northwind'.
2005-11-11 23:56:26.43 spid52 Starting up database 'pubs'.
2005-11-11 23:59:42.85 spid52 Starting up database 'ChattingHomeBase'.
2005-11-11 23:59:43.00 spid52 Starting up database 'ChattingHomeBase'.
2005-11-11 23:59:43.15 spid52 Starting up database 'ChattingHomeBase'.
2005-11-11 23:59:44.67 spid52 Starting up database 'ChattingHomeBase'.
2005-11-12 00:00:04.14 spid53 Using 'xpstar.dll' version '2000.80.194' to execute extended stored procedure 'sp_MSgetversion'.
2005-11-12 00:00:07.17 spid53 Starting up database 'AdvertisingHomeBase'.
2005-11-12 00:00:07.32 spid53 Starting up database 'ChattingHomeBase'.
2005-11-12 00:00:07.48 spid53 Starting up database 'MailSenderHomeBase'.
2005-11-12 00:00:07.81 spid53 Starting up database 'AdvertisingHomeBase'.
2005-11-12 00:00:07.92 spid53 Starting up database 'ChattingHomeBase'.
2005-11-12 00:00:08.17 spid53 Starting up database 'MailSenderHomeBase'.
2005-11-12 00:00:08.37 spid53 Starting up database 'AdvertisingHomeBase'.
2005-11-12 00:00:08.50 spid53 Starting up database 'ChattingHomeBase'.
2005-11-12 00:00:08.64 spid53 Starting up database 'MailSenderHomeBase'.
2005-11-12 00:00:08.85 spid53 Starting up database 'AdvertisingHomeBase'.
2005-11-12 00:00:08.96 spid53 Starting up database 'ChattingHomeBase'.
2005-11-12 00:00:09.10 spid53 Starting up database 'MailSenderHomeBase'.
2005-11-12 00:00:09.32 spid53 Starting up database 'AdvertisingHomeBase'.
2005-11-12 00:00:09.46 spid53 Starting up database 'ChattingHomeBase'.
2005-11-12 00:00:09.60 spid53 Starting up database 'MailSenderHomeBase'.
2005-11-12 00:00:09.87 spid53 Starting up database 'AdvertisingHomeBase'.
2005-11-12 00:00:10.01 spid53 Starting up database 'ChattingHomeBase'.
2005-11-12 00:00:10.15 spid53 Starting up database 'MailSenderHomeBase'.
2005-11-12 00:00:10.35 spid53 Starting up database 'AdvertisingHomeBase'.
2005-11-12 00:00:10.50 spid53 Starting up database 'ChattingHomeBase'.
2005-11-12 00:00:10.67 spid53 Starting up database 'MailSenderHomeBase'.
2005-11-12 00:00:10.87 spid53 Starting up database 'AdvertisingHomeBase'.
2005-11-12 00:00:11.03 spid53 Starting up database 'ChattingHomeBase'.
2005-11-12 00:00:11.17 spid53 Starting up database 'MailSenderHomeBase'.
2005-11-12 00:00:11.37 spid53 Starting up database 'AdvertisingHomeBase'.
2005-11-12 00:00:11.49 spid53 Starting up database 'ChattingHomeBase'.
2005-11-12 00:00:11.67 spid53 Starting up database 'MailSenderHomeBase'.
2005-11-12 00:00:11.88 spid53 Starting up database 'AdvertisingHomeBase'.
2005-11-12 00:00:12.03 spid53 Starting up database 'ChattingHomeBase'.
2005-11-12 00:00:12.17 spid53 Starting up database 'MailSenderHomeBase'.
2005-11-12 00:00:12.37 spid53 Starting up database 'AdvertisingHomeBase'.
2005-11-12 00:00:12.49 spid53 Starting up database 'ChattingHomeBase'.
2005-11-12 00:00:12.65 spid53 Starting up database 'MailSenderHomeBase'.
2005-11-12 00:00:17.20 spid53 Starting up database 'AdvertisingHomeBase'.
2005-11-12 00:00:17.32 spid53 Starting up database 'AdvertisingHomeBase'.
2005-11-12 00:00:17.45 spid53 Starting up database 'AdvertisingHomeBase'.
2005-11-12 00:00:21.17 spid53 Starting up database 'ChattingHomeBase'.
2005-11-12 00:00:21.32 spid53 Starting up database 'ChattingHomeBase'.
2005-11-12 00:00:21.48 spid53 Starting up database 'ChattingHomeBase'.
2005-11-12 00:00:22.92 spid53 Starting up database 'AdvertisingHomeBase'.
2005-11-12 00:00:23.12 spid53 Starting up database 'ChattingHomeBase'.
2005-11-12 00:00:23.26 spid53 Starting up database 'MailSenderHomeBase'.
2005-11-12 00:00:23.67 spid53 Starting up database 'AdvertisingHomeBase'.
2005-11-12 00:00:23.79 spid53 Starting up database 'ChattingHomeBase'.
2005-11-12 00:00:23.93 spid53 Starting up database 'MailSenderHomeBase'.
2005-11-12 00:00:24.15 spid53 Starting up database 'ChattingHomeBase'.
2005-11-12 00:00:24.31 spid53 Starting up database 'ChattingHomeBase'.
2005-11-12 00:00:24.45 spid53 Starting up database 'ChattingHomeBase'.
2005-11-12 00:00:25.82 spid53 Starting up database 'ChattingHomeBase'.
2005-11-12 00:00:25.98 spid53 Starting up database 'ChattingHomeBase'.
2005-11-12 00:00:26.14 spid53 Starting up database 'ChattingHomeBase'.
2005-11-12 00:00:26.45 spid53 Starting up database 'ChattingHomeBase'.
2005-11-12 00:01:11.39 spid53 Starting up database 'AdvertisingHomeBase'.
2005-11-12 00:01:11.54 spid53 Starting up database 'AdvertisingHomeBase'.
2005-11-12 00:01:11.70 spid53 Starting up database 'AdvertisingHomeBase'.
2005-11-12 00:01:11.93 spid53 Starting up database 'AdvertisingHomeBase'.
2005-11-12 00:01:12.10 spid53 Starting up database 'AdvertisingHomeBase'.
2005-11-12 00:01:12.28 spid53 Starting up database 'AdvertisingHomeBase'.
2005-11-12 00:01:12.48 spid53 Starting up database 'AdvertisingHomeBase'.
2005-11-12 00:01:12.62 spid53 Starting up database 'ChattingHomeBase'.
2005-11-12 00:01:12.78 spid53 Starting up database 'ChattingHomeBase'.
2005-11-12 00:01:12.92 spid53 Starting up database 'ChattingHomeBase'.
2005-11-12 00:01:13.06 spid53 Starting up database 'ChattingHomeBase'.
2005-11-12 00:01:13.20 spid53 Starting up database 'ChattingHomeBase'.
2005-11-12 00:01:13.34 spid53 Starting up database 'ChattingHomeBase'.
2005-11-12 00:01:14.48 spid53 Starting up database 'ChattingHomeBase'.
2005-11-12 00:01:14.62 spid53 Starting up database 'MailSenderHomeBase'.
2005-11-12 00:01:14.84 spid53 Starting up database 'MailSenderHomeBase'.
2005-11-12 00:01:15.04 spid53 Starting up database 'MailSenderHomeBase'.
2005-11-12 00:01:15.29 spid53 Starting up database 'MailSenderHomeBase'.
2005-11-12 00:01:15.62 spid53 Starting up database 'MailSenderHomeBase'.
2005-11-12 00:01:16.29 spid53 Starting up database 'MailSenderHomeBase'.
2005-11-12 00:01:16.59 spid53 Starting up database 'MailSenderHomeBase'.
2005-11-12 00:01:16.95 spid53 Starting up database 'ChattingHomeBase'.
2005-11-12 00:02:14.90 spid53 Error: 15457, Severity: 0, State: 1
2005-11-12 00:02:14.90 spid53 Configuration option 'show advanced options' changed from 1 to 1. Run the RECONFIGURE statement to install..
2005-11-12 00:02:15.14 spid53 Using 'xplog70.dll' version '2000.80.194' to execute extended stored procedure 'xp_msver'.
Es este el fichero correcto? o estoy viendo en otro archivo?.
Agradezco mucho su ayuda.
Saludos!.
__________________
Add, never Remove
|