none
The specified module could not be found

    Question

  • I am using sql server 2008. Everything was working perfectly, but yesterday my sql server stopped working..I checked into configuration services and saw that the mssqlserver and sql server agent both were stopped..I tried to restart both of them but could not do so..I went into its properties and selected a sysadmin account and gave the correct password..but got the error "The specified network password is not correct[0x80070056]", so I again tried to switch back to  Built in account - network service, but then getting the error "The specified module could not be found [0x8007007e] " Can somebody please tell me how to overcome these issues..I am stuck here :(

    Thank you in advance

    Wednesday, April 04, 2012 8:05 AM

Answers

  • From the error message..it seemed like some problem with VIA protocol..so I just disabled it and services started to work now :)
    • Marked as answer by rockstar283 Wednesday, April 04, 2012 8:20 AM
    Wednesday, April 04, 2012 8:19 AM

All replies

  • Take look into ERROR.LOG, someone change an account/password ?

    Best Regards, Uri Dimant SQL Server MVP http://dimantdatabasesolutions.blogspot.com/ http://sqlblog.com/blogs/uri_dimant/

    Wednesday, April 04, 2012 8:10 AM
    Answerer
  • Here is the latest log:

    2012-04-04 01:12:57.48 Server      Microsoft SQL Server 2008 (RTM) - 10.0.1600.22 (X64) 
    Jul  9 2008 14:17:44 
    Copyright (c) 1988-2008 Microsoft Corporation
    Developer Edition (64-bit) on Windows NT 6.1 <X64> (Build 7601: Service Pack 1)


    2012-04-04 01:12:58.04 Server      (c) 2005 Microsoft Corporation.
    2012-04-04 01:12:58.04 Server      All rights reserved.
    2012-04-04 01:12:58.04 Server      Server process ID is 6720.
    2012-04-04 01:12:58.10 Server      System Manufacturer: 'Acer', System Model: 'Aspire 4820TG'.
    2012-04-04 01:12:58.17 Server      Authentication mode is WINDOWS-ONLY.
    2012-04-04 01:12:58.20 Server      Logging SQL Server messages in file 'C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\Log\ERRORLOG'.
    2012-04-04 01:12:58.40 Server      This instance of SQL Server last reported using a process ID of 4808 at 4/4/2012 1:05:20 AM (local) 4/4/2012 8:05:20 AM (UTC). This is an informational message only; no user action is required.
    2012-04-04 01:12:58.40 Server      Registry startup parameters: 
    -d C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA\master.mdf
    -e C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\Log\ERRORLOG
    -l C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA\mastlog.ldf
    2012-04-04 01:12:58.86 Server      SQL Server is starting at normal priority base (=7). This is an informational message only. No user action is required.
    2012-04-04 01:12:58.91 Server      Detected 4 CPUs. This is an informational message; no user action is required.
    2012-04-04 01:13:02.73 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-04 01:13:09.18 Server      Node configuration: node 0: CPU mask: 0x000000000000000f Active CPU mask: 0x000000000000000f. 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-04 01:13:10.55 spid7s      Starting up database 'master'.
    2012-04-04 01:13:13.54 spid7s      Recovery completed for database master (database ID 1) in 1 second(s) (analysis 708 ms, redo 54 ms, undo 486 ms.) This is an informational message only. No user action is required.
    2012-04-04 01:13:17.94 spid7s      Resource governor reconfiguration succeeded.
    2012-04-04 01:13:18.03 spid7s      SQL Server Audit is starting the audits. This is an informational message. No user action is required.
    2012-04-04 01:13:18.42 spid7s      SQL Server Audit has started the audits. This is an informational message. No user action is required.
    <{39B75A24-0837-4CEC-AFDF-B960027AE07E}>RsFxNso initialized. InstanceId = 00000001
    <{50080099-5EC4-4EAF-A2A2-63C3DA97F8EB}>FsAgent is initialized
    <{09C4480B-DBA4-49B7-956F-68A8B8B2445D}>FsAgent is up and running
    2012-04-04 01:13:19.24 spid7s      FILESTREAM: effective level = 2, configured level = 2, file system access share name = 'MSSQLSERVER'.
    2012-04-04 01:13:22.90 spid7s      SQL Trace ID 1 was started by login "sa".
    2012-04-04 01:13:23.45 spid7s      Starting up database 'mssqlsystemresource'.
    2012-04-04 01:13:23.58 spid7s      The resource database build version is 10.00.1600. This is an informational message only. No user action is required.
    2012-04-04 01:13:26.20 spid16s     Starting up database 'model'.
    2012-04-04 01:13:26.26 spid7s      Server name is 'AMEY-PC'. This is an informational message only. No user action is required.
    2012-04-04 01:13:27.55 spid16s     Clearing tempdb database.
    2012-04-04 01:13:28.43 Server      A self-generated certificate was successfully loaded for encryption.
    2012-04-04 01:13:28.45 Server      Error: 26055, Severity: 16, State: 1.
    2012-04-04 01:13:28.45 Server      The SQL Server failed to initialize VIA support library [QLVipl.dll]. This normally indicates the VIA support library does not exist or is corrupted. Please repair or disable the VIA network protocol. Error: 0x7e.
    2012-04-04 01:13:28.61 Server      Error: 17182, Severity: 16, State: 1.
    2012-04-04 01:13:28.61 Server      TDSSNIClient initialization failed with error 0x7e, status code 0x60. Reason: Unable to initialize the VIA listener. The specified module could not be found.


    2012-04-04 01:13:28.62 Server      Error: 17182, Severity: 16, State: 1.
    2012-04-04 01:13:28.62 Server      TDSSNIClient initialization failed with error 0x7e, status code 0x1. Reason: Initialization failed with an infrastructure error. Check for previous errors. The specified module could not be found.


    2012-04-04 01:13:28.62 Server      Error: 17826, Severity: 18, State: 3.
    2012-04-04 01:13:28.62 Server      Could not start the network library because of an internal error in the network library. To determine the cause, review the errors immediately preceding this one in the error log.
    2012-04-04 01:13:28.62 Server      Error: 17120, Severity: 16, State: 1.
    2012-04-04 01:13:28.62 Server      SQL Server could not spawn FRunCM thread. Check the SQL Server error log and the Windows event logs for information about possible related problems.


    • Edited by rockstar283 Wednesday, April 04, 2012 8:17 AM
    Wednesday, April 04, 2012 8:15 AM
  • http://msdn.microsoft.com/en-us/library/ms187109.aspx

    Best Regards, Uri Dimant SQL Server MVP http://dimantdatabasesolutions.blogspot.com/ http://sqlblog.com/blogs/uri_dimant/

    Wednesday, April 04, 2012 8:19 AM
    Answerer
  • From the error message..it seemed like some problem with VIA protocol..so I just disabled it and services started to work now :)
    • Marked as answer by rockstar283 Wednesday, April 04, 2012 8:20 AM
    Wednesday, April 04, 2012 8:19 AM