Linked server creator

Hi,

I've noticed a new linked server on one of our databases and am trying to find out who created it.

Is there a way to determine the username of the creator?

Thanks.
tdbjAsked:
Who is Participating?
 
Kevin CrossConnect With a Mentor Chief Technology OfficerCommented:
Hi.

Unless you are auditing specific actions in SQL Server, I cannot think of a way to determine WHO created a specific Linked Server; however, here are some thoughts that may help.

First, if you have not explicitly granted separate permissions to individuals to create linked servers, the culprit is one of the DBAs you have entrusted with sysadmin privileges; therefore, read through http://www.sql-server-performance.com/2009/security-audit-server-level/ and you will find some scripts to determine which users are sysadmins and/or what permissions your users have specific to server-level access.

Second, you can use the System view sys.servers to at least get the last modified date of the Linked Server. Given there is not much to change after a Linked Server has been established, my experience is that the modified date is analogous to the creation date.
SELECT [name], [modify_date]
FROM sys.servers
;

Open in new window


If you are auditing logins, you can get the last login time of each user. Short of this, you can just match up the time frame with the sysadmin who was around at that time -- hopefully it filters the list.

Hope that helps!

Kevin
0
 
Chris MangusConnect With a Mentor Database AdministratorCommented:
As far as I know, linked server information is kept in sys.servers table and it does not record who created the linked server.
0
 
tdbjAuthor Commented:
Thanks
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.