Post reply

I cannot connect to my database engine because of T_sql that fails to execute.

  • June 21, 2013 at 8:38 am

    #147855

    I set a job to execute whenever the database engine is started but it has failed to connect whenever i try to connect it gives me an error, see attachment below.

  • June 21, 2013 at 9:49 am

    #1626389

    Need more information regarding the job, the procedure being run, what database it is running in.

  • June 21, 2013 at 12:04 pm

    #1626441

    It is running in the sql server 2008 R2...i was testing if i could schedule a job to run a querry when the engine is started.

  • June 21, 2013 at 12:50 pm

    #1626458

    Again you have not provided enough information.

    A startup job in sql agent would not prevent other clients from connecting to SQL because SQL Agent is just a client of SQL. You need to break down the information of what exactly you are trying to do with some code examples and a set of steps you are attempting. Without that we can't help you, as Lynn suggested.

    CEWII

  • June 21, 2013 at 4:18 pm

    #1626517

    Perhaps this may help:

    http://support.microsoft.com/kb/2640027

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply