+ Post New Thread
Page 2 of 2 FirstFirst 12
Results 16 to 22 of 22
MIS Systems Thread, Error 0 in Technical; As far as I can tell, this can be a permissions issue - does the account that the SQL service ...
  1. #16

    localzuk's Avatar
    Join Date
    Dec 2006
    Location
    Minehead
    Posts
    17,631
    Thank Post
    514
    Thanked 2,442 Times in 1,890 Posts
    Blog Entries
    24
    Rep Power
    831
    As far as I can tell, this can be a permissions issue - does the account that the SQL service runs as have permissions to the folder where the database file is stored?

    Also, make sure you've not got drive compression enabled on the drive as this stops SQL working.

  2. #17

    matt40k's Avatar
    Join Date
    Jun 2008
    Location
    Ipswich
    Posts
    4,377
    Thank Post
    368
    Thanked 637 Times in 519 Posts
    Rep Power
    158
    My moneys on duff hdd.

  3. #18

    Join Date
    Jul 2010
    Posts
    557
    Thank Post
    65
    Thanked 21 Times in 18 Posts
    Rep Power
    13
    Cheers,
    Support Call think that MSSQL has badgered up.
    This is in a error log
    2014-03-18 11:04:17.49 spid7s Starting up database 'master'.
    2014-03-18 11:04:17.56 spid7s WARNING: did not see LOP_CKPT_END.
    2014-03-18 11:04:17.56 spid7s Error: 3414, Severity: 21, State: 2.
    2014-03-18 11:04:17.56 spid7s An error occurred during recovery, preventing the database 'master' (database ID 1) from restarting. Diagnose the recovery errors and fix them, or restore from a known good backup. If errors are not corrected or expected, contact Technical Support.
    2014-03-18 11:04:17.56 spid7s Cannot recover the master database. SQL Server is unable to run. Restore master from a full backup, repair it, or rebuild it. For more information about how to rebuild the master database, see SQL Server Books Online.
    For some reason now they cant remote into us with logmein123
    *sigh*

    Dunno what you mean about HDD as the computer is working

  4. #19

    matt40k's Avatar
    Join Date
    Jun 2008
    Location
    Ipswich
    Posts
    4,377
    Thank Post
    368
    Thanked 637 Times in 519 Posts
    Rep Power
    158
    So basically the MASTER database that SQL uses for it's meta data like SQL login\password is got corrupted. You know have to reinstall SQL.

    I would seriously be looking into Event Viewer for errors (I think it's the SYSTEM logs) for bad blocks, this basically means the hdd has problems and needs replacing. The MASTER database doesn't get corrupted for no reason, OK it could be you had a power failure, it could be the antivirus, but it could be a hdd is on it's way out. It's worth doing now as it's going to get worse if it is bad blocks and you don't want to reinstall SQL only for it to get worse then the whole drive fails. Might be worth checking your backups.

  5. #20
    mikkydoos's Avatar
    Join Date
    Jan 2009
    Location
    Birmingham
    Posts
    149
    Thank Post
    41
    Thanked 11 Times in 10 Posts
    Rep Power
    13
    Error 0 comes with h aving no default printer also

    - - - Updated - - -

    Error 0 comes with h aving no default printer also

  6. #21
    zag
    zag is offline
    zag's Avatar
    Join Date
    Mar 2007
    Posts
    3,762
    Thank Post
    897
    Thanked 416 Times in 350 Posts
    Blog Entries
    12
    Rep Power
    86
    Quote Originally Posted by MattDLEA View Post
    For some reason now they cant remote into us with logmein123
    *sigh*
    The latest logmein client has messed up connecting through proxies.

    Fix here

    http://www.edugeek.net/forums/smooth...onnecting.html

    - - - Updated - - -

    Quote Originally Posted by MattDLEA View Post
    For some reason now they cant remote into us with logmein123
    *sigh*
    The latest logmein client has messed up connecting through proxies.

    Fix here

    http://www.edugeek.net/forums/smoothwall-direct-support/133973-logmein-rescue-not-connecting.html

  7. #22

    Join Date
    Jul 2010
    Posts
    557
    Thank Post
    65
    Thanked 21 Times in 18 Posts
    Rep Power
    13
    Thanks for the replies.

    Their tech support came out and reinstalled SIMS, they would have had to anyways as they don't trust us with the password.
    Not tried that zag though I have passed it on to out NGFL to unblock them.

    I also got
    Have you tried holding down Ctrl + Alt + Shift before clicking the Connect to Technician button? Apparently this “forces the session into a relayed connection and resolves issues in peer to peer connections such as NAT not working properly on both ends”

    Also has this Note: “The customer should keep the Ctrl + Alt + Shift keys held down until a connection is formed”

    Then goes on to say: “If the connection continues to fail or an Invalid certificate message appears, there may be a security policy on the customer’s network preventing the connection. UDP communication and ActiveX must be allowed for Rescue connections to take place.

    Important: Please also ensure the date and time are correct on the customer’s computer"
    - - - Updated - - -

    Thanks for the replies.

    Their tech support came out and reinstalled SIMS, they would have had to anyways as they don't trust us with the password.
    Not tried that zag though I have passed it on to out NGFL to unblock them.

    I also got
    Have you tried holding down Ctrl + Alt + Shift before clicking the Connect to Technician button? Apparently this “forces the session into a relayed connection and resolves issues in peer to peer connections such as NAT not working properly on both ends”

    Also has this Note: “The customer should keep the Ctrl + Alt + Shift keys held down until a connection is formed”

    Then goes on to say: “If the connection continues to fail or an Invalid certificate message appears, there may be a security policy on the customer’s network preventing the connection. UDP communication and ActiveX must be allowed for Rescue connections to take place.

    Important: Please also ensure the date and time are correct on the customer’s computer"

SHARE:
+ Post New Thread
Page 2 of 2 FirstFirst 12

Similar Threads

  1. Administrators Nasty File Search errors.
    By Kyle in forum How do you do....it?
    Replies: 5
    Last Post: 24th January 2006, 09:53 PM
  2. Google Spyware error
    By ChrisH in forum Windows
    Replies: 10
    Last Post: 14th December 2005, 08:35 PM
  3. liberum and asp error message
    By russdev in forum Windows
    Replies: 2
    Last Post: 25th November 2005, 01:46 PM
  4. Adduser.conf parse errors
    By ChrisH in forum *nix
    Replies: 4
    Last Post: 18th November 2005, 11:10 AM
  5. Kerberos error - All policies disappeared
    By ajbritton in forum Windows
    Replies: 13
    Last Post: 2nd November 2005, 02:13 PM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

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