none
File share problem on Homegroup

    Question

  • Remote computer "sees" file stored on server which is an ACT database, but responds "The SQL database instance is unavailable" when attempting to open it.  Checking "Services" under "Adminstrative" shows the SQL (ACT7) to be enabled and started. However, SQL Server agent (ACT7) reports "Service on local computer started and then stopped. Some services stop automatically if they are not in use by other services or programs"  Can anyone help resolve this?
    Friday, May 18, 2012 5:23 PM

All replies

  • This Agent error is typically the result of the Agent service not having access to the log drive to write the SQLAGENT.OUT log file.  Can you take a look at this thread with assistance?

    http://social.msdn.microsoft.com/Forums/en-US/sqldatabaseengine/thread/24a9d481-7251-425a-ac02-2ef627ef6738/

    Thanks,
    Sam Lester (MSFT)


    This posting is provided "AS IS" with no warranties, and confers no rights. Please remember to click "Mark as Answer" and "Vote as Helpful" on posts that help you. This can be beneficial to other community members reading the thread.

    Friday, May 18, 2012 6:39 PM
  • Samuel,

    Thanks for prompt response.

    To my untutored eye, it seems likely that you have proposed solutions that should work.

    However, I need literal keystroke by keystroke directions to implement them.

    Is this asking too much?

    Lewis


    Lewis Barnes

    Friday, May 18, 2012 7:09 PM