meta user
network profile
| bio | website | heavencore.co.uk |
|---|---|---|
| location | England | |
| age | 28 | |
| visits | member for | 1 year, 4 months |
| seen | yesterday | |
| stats | profile views | 27 |
Lead Software Engineer & Database Administrator.
Cohens Chemist Group (UK)
HeavenCore - Personal Site
Cohens Chemists - Work Site
|
2d |
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? |
|
Apr 16 |
revised |
BUILTIN\Administrators allowing access via linked server but not locally Re-titled to more accurately reflect the problem based on recent findings |
|
Apr 16 |
revised |
BUILTIN\Administrators allowing access via linked server but not locally Added BUILTIN\Administrators discovery |
|
Apr 16 |
revised |
BUILTIN\Administrators allowing access via linked server but not locally Added Theory 1 |
|
Apr 16 |
asked | BUILTIN\Administrators allowing access via linked server but not locally |
|
Feb 16 |
accepted | SQL Server replication for off site copy |
|
Feb 14 |
asked | SQL Server replication for off site copy |
|
Feb 12 |
awarded | Yearling |
|
Feb 12 |
awarded | Commentator |
