[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 257
  • Last Modified:

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.
0
tdbj
Asked:
tdbj
2 Solutions
 
Chris MangusDatabase 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
 
Kevin CrossChief 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
 
tdbjAuthor Commented:
Thanks
0

Featured Post

Microsoft Certification Exam 74-409

VeeamĀ® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now