344 reputation
216
bio website heavencore.co.uk
location England
age 28
visits member for 2 years, 3 months
seen Mar 29 at 13:09

Software Engineer & Database Administrator.

Cohens Chemist Group (UK)

HeavenCore - Personal Site

Cohens Chemist - Work Site


Mar
7
asked SQL Script to Drop old AD logins, Inactive SQL Logins and all related Users
Sep
26
awarded  Popular Question
May
28
accepted Working Linked Server Query fails in sp_send_dbmail
May
28
answered Working Linked Server Query fails in sp_send_dbmail
May
20
awarded  Caucus
May
20
awarded  Constituent
May
20
accepted How does “Be made using the login's current security context” pass the users password to remote server
May
20
answered How does “Be made using the login's current security context” pass the users password to remote server
May
17
revised Working Linked Server Query fails in sp_send_dbmail
Added update
May
3
comment Working Linked Server Query fails in sp_send_dbmail
We've ran a SQL trace on the remote server filtered to show all transactions where Application name is like DatabaseMail - it traced 100's working calls, but the calls from the linked server was nowhere to be seen, which would suggest the Linked Server is not connecting at all - We have logged a paid support request with Microsoft on this - wasting too much of our time ha-ha - will update when i know more.
May
3
revised Working Linked Server Query fails in sp_send_dbmail
added 202 characters in body
May
3
revised Working Linked Server Query fails in sp_send_dbmail
Added Similar Issues
May
3
asked Working Linked Server Query fails in sp_send_dbmail
Apr
29
awarded  Critic
Apr
29
comment How does “Be made using the login's current security context” pass the users password to remote server
You dont have to give a username & password of the remote server when setting up a linked server at all? thats the whole point of the @useself parameter on sp_addlinkedsrvlogin - hence my question :)
Apr
29
comment How does “Be made using the login's current security context” pass the users password to remote server
Hi Chris, both servers are using mixed mode authentication - but as stated in my question - this is in relation to a non-windows credential (i.e. a sql credential) connection - cheers
Apr
29
asked How does “Be made using the login's current security context” pass the users password to remote server
Apr
17
comment BUILTIN\Administrators allowing access via linked server but not locally
Agreed – to be clear, the Domain Admin issue was raised by management above me – just wanted to get my facts right before getting back to them – thank you for the information.
Apr
17
accepted BUILTIN\Administrators allowing access via linked server but not locally
Apr
17
comment BUILTIN\Administrators allowing access via linked server but not locally
Argh, so simple now i think about it - cheers. The reason this came up is that we realised our domain admins pretty much had full access to SQL via linked servers - is this something we should just accept and trust our Domain Admins? Everything ive read about removing the BUILTIN\Administrators group says that this can often be more trouble than it's worth?