Connecting to SQL using Excel

  • Hi there,

    I would like to know if there is a way to pick up when a user logs into a SQL server using Excel? For security reasons we need to stop it...

    Thanks in advance!!

     

     

     

  • Not via anything automated, no. You can query tables like sysprocesses, but you'd have to write a job to do so. Also, a knowledgeable user could connect from Excel using ODBC but spoof the application name so it looks like something else other than Excel, so it's not foolproof.

    I guess a better way to handle this is (a) why do you need to prevent users from coming in via Excel and (b) why do they have access to do this already (since they could use another avenue just as bad, such as Access)?

    K. Brian Kelley
    @kbriankelley

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

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