December 16, 2003 at 4:30 pm
Hello-
I am trying to start SQL Server using TCP/IP as the only protocol (I disabled Named Pipes and unchecked 'Shared Memory'), the server is still listening on Shared Memory. If I enable, 'Named Pipes' it listens on Shared Memory and Named pipes. Any ideas whatz going on here?
Thanks
December 16, 2003 at 8:08 pm
December 16, 2003 at 8:26 pm
Allen-
Thanks for your response. I tried this already. It did not change anything. I am running Windows 2003 and SQL Ent edition. SQL patched to 3a.
December 16, 2003 at 8:38 pm
Do you see any errors regarding to TCP/IP in SQL Server errorlog?
December 17, 2003 at 8:45 am
Allen-
I dont see any errors regarding TCP/IP in the error log.
This is how my log file looks.
2003-12-16 21:09:11.64 server Attempting to initialize Distributed Transaction Coordinator.
2003-12-16 21:09:11.66 server Failed to obtain TransactionDispenserInterface: Result Code = 0x8004d01b
2003-12-16 21:09:11.67 spid3 Starting up database 'master'.
2003-12-16 21:09:11.85 server Using 'SSNETLIB.DLL' version '8.0.194'.
2003-12-16 21:09:11.85 spid5 Starting up database 'model'.
2003-12-16 21:09:11.86 spid3 Server name is 'XXXX'.
2003-12-16 21:09:11.86 spid8 Starting up database 'msdb'.
2003-12-16 21:09:11.86 spid9 Starting up database 'pubs'.
2003-12-16 21:09:11.88 spid10 Starting up database 'Northwind'.
2003-12-16 21:09:11.88 spid11 Starting up database 'XXXXXX'.
2003-12-16 21:09:11.88 spid12 Starting up database 'YYYYY'.
2003-12-16 21:09:12.09 spid5 Clearing tempdb database.
2003-12-16 21:09:12.47 server SQL server listening on Shared Memory, Named Pipes.
2003-12-16 21:09:12.47 server SQL Server is ready for client connections
2003-12-16 21:09:13.17 spid5 Starting up database 'tempdb'.
2003-12-16 21:09:13.34 spid11 Recovery is checkpointing database 'XXXXX' (7)
2003-12-16 21:09:33.63 spid3 Recovery complete.
2003-12-17 07:15:16.45 spid60 Using 'xpstar.dll' version '2000.80.194' to execute extended stored procedure 'sp_MSgetversion'.
Thanks
December 17, 2003 at 9:05 am
quote:
2003-12-16 21:09:11.64 server Attempting to initialize Distributed Transaction Coordinator.2003-12-16 21:09:11.66 server Failed to obtain TransactionDispenserInterface: Result Code = 0x8004d01b
Makre sure MSDTC server is up and running. Check machine system/application logs.
quote:
2003-12-16 21:09:11.85 server Using 'SSNETLIB.DLL' version '8.0.194'.
You are not running sp3a. Run select @@version to verify that.
December 18, 2003 at 9:47 am
Allen-
You are right. I was not running SP3a. The Server checklist that was given to me said the server is patched up to 3a and I did not think about that being wrong. After looking at your reply, I realized that, patched it up and brought up the server and it is working fine now. Thanks for you time
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply