SQL Server accepting logins?

  • hi,

    How can i check through

    1- SQL Server is running or not (i.e status of sql server)

    2- SQL Server is accepting new logins (i.e connection pool is not full, or there is no process blocking)

    Thanks,

    Usman

  • You can either download a tool to perform these checks or you can run queries from a remote machine to check on the status of SQL and whether logins are functioning.

    Check for scripts on this site.



    Shamless self promotion - read my blog http://sirsql.net

  • Nicholas Cain (12/12/2008)


    You can either download a tool to perform these checks or you can run queries from a remote machine to check on the status of SQL and whether logins are functioning.

    Check for scripts on this site.

    Thanks Nick, but i cannot see the website url, can you please repost it?

  • Are you saying how can you programmatically check?

    because trying to log in with SSMS is probably a good first place to start for most people.

    :hehe:

    ~BOT

  • usman.tanveer (12/12/2008)


    Nicholas Cain (12/12/2008)


    You can either download a tool to perform these checks or you can run queries from a remote machine to check on the status of SQL and whether logins are functioning.

    Check for scripts on this site.

    Thanks Nick, but i cannot see the website url, can you please repost it?

    Just hit the "Scripts" link on the left side of the page, near the top and perform a search. There's some great stuff out there that will do just what you require. 🙂



    Shamless self promotion - read my blog http://sirsql.net

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

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