Results 1 to 3 of 3
  1. #1
    Join Date
    May 2011
    Posts
    12

    Unanswered: Helppp!!!!! What should i do?

    2011-06-14 19:09:40.37 server Copyright (C) 1988-2002 Microsoft Corporation.
    2011-06-14 19:09:40.37 server All rights reserved.
    2011-06-14 19:09:40.37 server Server Process ID is 768.
    2011-06-14 19:09:40.37 server Logging SQL Server messages in file 'C:\Program Files\Microsoft SQL Server\MSSQL\log\ERRORLOG'.
    2011-06-14 19:09:40.39 server SQL Server is starting at priority class 'normal'(2 CPUs detected).
    2011-06-14 19:09:40.79 server SQL Server configured for thread mode processing.
    2011-06-14 19:09:40.79 server Using dynamic lock allocation. [2500] Lock Blocks, [5000] Lock Owner Blocks.
    2011-06-14 19:09:40.82 server Attempting to initialize Distributed Transaction Coordinator.
    2011-06-14 19:09:40.82 server Failed to obtain TransactionDispenserInterface: XACT_E_TMNOTAVAILABLE
    2011-06-14 19:09:40.82 spid4 Starting up database 'master'.
    2011-06-14 19:09:40.95 spid4 Server name is 'SD-PC'.
    2011-06-14 19:09:40.95 spid5 Starting up database 'msdb'.
    2011-06-14 19:09:40.95 server Using 'SSNETLIB.DLL' version '8.0.2039'.
    2011-06-14 19:09:40.95 spid6 Starting up database 'model'.
    2011-06-14 19:09:40.95 server SQL server listening on 192.168.1.58: 1433.
    2011-06-14 19:09:40.95 server SQL server listening on 127.0.0.1: 1433.
    2011-06-14 19:09:40.96 spid8 Starting up database 'pubs'.
    2011-06-14 19:09:40.96 spid10 Starting up database 'Northwind'.
    2011-06-14 19:09:40.96 server SQL server listening on TCP, Shared Memory, Named Pipes.
    2011-06-14 19:09:40.96 server SQL Server is ready for client connections
    2011-06-14 19:09:40.98 spid11 Starting up database 'InfinityMasterModel'.
    2011-06-14 19:09:40.98 spid12 Starting up database 'InfinityModel'.
    2011-06-14 19:09:41.01 spid13 Starting up database 'InfinityMaster'.
    2011-06-14 19:09:41.01 spid14 Starting up database 'monolo'.
    2011-06-14 19:09:41.06 spid15 Starting up database 'sadepths'.
    2011-06-14 19:09:42.28 spid6 Clearing tempdb database.
    2011-06-14 19:09:43.39 spid51 Using 'xpstar.dll' version '2000.80.2039' to execute extended stored procedure 'sp_MSgetversion'.
    2011-06-14 19:09:45.59 spid6 Starting up database 'tempdb'.
    2011-06-14 19:09:46.99 spid4 Recovery complete.
    2011-06-14 19:09:46.99 spid4 SQL global counter collection task is created.
    2011-06-14 19:09:46.99 spid4 Launched startup procedure 'sp_notifyClients'
    2011-06-14 19:09:47.20 spid52 Using 'ClientSocket.dll' version 'UNKNOWN' to execute extended stored procedure 'setclientsockets'.
    2011-06-14 19:17:14.45 spid51 Error: 15457, Severity: 0, State: 1
    2011-06-14 19:17:14.45 spid51 Configuration option 'show advanced options' changed from 1 to 1. Run the RECONFIGURE statement to install..
    2011-06-14 19:17:14.53 spid51 Using 'xplog70.dll' version '2000.80.2039' to execute extended stored procedure 'xp_msver'.
    2011-06-14 19:17:20.76 spid51 Error: 15457, Severity: 0, State: 1
    2011-06-14 19:17:20.76 spid51 Configuration option 'user connections' changed from 0 to 15. Run the RECONFIGURE statement to install..


    what is this error and how can i fix this....plz provide me with a fix for this error ...plzzzzz

  2. #2
    Join Date
    Jan 2003
    Location
    Massachusetts
    Posts
    5,799
    Provided Answers: 11
    It is severity 0, so it is actually an informational message, rather than an actual error. Looks like someone set the max number of user connections to a startlingly low value. You can reset this by running
    Code:
    exec sp_configure 'user connections', 0
    go
    reconfigure with override
    if the user connections are set so low that you can not make a connection even with sqlcmd, then you will probably need to start up SQL Server using the -f parameter.

  3. #3
    Join Date
    May 2011
    Posts
    12

    Thank you macrowley

    Thanks for your help macrowley,i really appreciate it......I did change the user connections to a low value and later i changed it back to 0 aand the
    "server Failed to obtain TransactionDispenserInterface: XACT_E_TMNOTAVAILABLE" error was gone. Actually i dint use the syntax u gave me....i just changed the user connections in the GUI nd it worked. Thanks a lot man

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •