Everything bar the password it would appear. Gavin Wilby IT Support Engineer
From: [email protected] [mailto:[email protected]] On Behalf Of Ken Schaefer Sent: 28 October 2014 12:29 To: [email protected] Subject: RE: [NTSysADM] Pushing out ODBC connections The ODBC control panel just writes info to the registry. Can you capture those writes? From: [email protected]<mailto:[email protected]> [mailto:[email protected]] On Behalf Of Gavin Wilby Sent: Tuesday, 28 October 2014 9:00 PM To: '[email protected]' Subject: RE: [NTSysADM] Pushing out ODBC connections Lets pretend for the purpose of this that the credential issue isn't an issue. I still need to work out a way to but the connection with a credential as part of the roll out, but looking at it, I'm not sure it can be done with a system DSN to a SQL server in any case. Gavin Wilby IT Support Engineer From: [email protected]<mailto:[email protected]> [mailto:[email protected]] On Behalf Of Hank Arnold Sent: 28 October 2014 09:12 To: [email protected]<mailto:[email protected]> Subject: RE: [NTSysADM] Pushing out ODBC connections Bad, bad, bad (did I say "bad"?) idea. I'd push back as to why SA. That's the keys to the kingdom. there are plenty of options w.r.t. user accounts and access permissions. Regards, Hank Arnold [MVP Logo_Small] Consumer Security "There are 10 kinds of people in the world... Those who understand binary and those who don't." My Blog: http://it.toolbox.com/blogs/personal-pc-assistant/ Twitter: @Hank_PCDoc Facebook: https://www.facebook.com/hank.arnold.96 From: [email protected]<mailto:[email protected]> [mailto:[email protected]] On Behalf Of Gavin Wilby Sent: Monday, October 27, 2014 8:03 AM To: '[email protected]' Subject: [NTSysADM] Pushing out ODBC connections Hi, I have been asked by one of our Devs, to push out a ODBC connection to a database server. The issue is that is HAS to connect with the servers SA username and password... <sigh> I cant see how exactly how this can be pushed out by either a registry script or by GPP... anyone done this successfully? Gavin Wilby IT Support Engineer SMP Partners Ltd Clinch's House, Lord Street, Douglas, Isle of Man IM99 1RZ Tel +44 1624 682214 Mob +44 7624 480575 Skype: [email protected]<mailto:[email protected]> [email protected]<mailto:[email protected]> www.smppartners.com<http://www.smppartners.com/> A member of the SMP Partners Group of Companies SMP Partners Limited, SMP Trustees Limited and SMP Fund Services Limited are licensed by the Isle of Man Financial Supervision Commission. SMP Accounting & Tax Limited is a member of the ICAEW Practice Assurance Scheme. SMP Partners Limited registered in the Isle of Man, Company Registration No: 000908V Directors: M.W. Denton, M.J. Derbyshire, P.N. Eckersley, S.E McGowan, O. Peck, J.J. Scott, S.J. Turner SMP Trustees Limited registered in the Isle of Man, Company Registration No: 068396C Directors: A.C. Baggesen, M.W. Denton, O. Peck, J.J. Scott, J. Watterson, J. Cubbon SMP Fund Services Limited registered in the Isle of Man, Company Registration No: 120288C Directors: V. Campbell, M.W. Denton, P.N. Eckersley, D.A. Manser, S.E McGowan, O. Peck, J.J. Scott, R.K. Corkill SMP Accounting & Tax Limited registered in the Isle of Man, Company Registration No: 001316V Directors: I.F. Begley, A.J. Dowling, P. Duchars, P.N. Eckersley, J.J. Scott, S.J. Turner SMP Capital Markets Limited registered in the Isle of Man, Company Registration No: 002438V Directors: M.W. Denton, M.J. Derbyshire, D.F Hudson, S.E McGowan, O. Peck, J.J. Scott. SMP Partners Limited, SMP Trustees Limited, SMP Fund Services Limited, SMP Accounting & Tax Limited and SMP Capital Markets Limited are members of the SMP Partners Group of Companies. This email is confidential and is subject to disclaimers. Details can be found at: http://www.smppartners.com/disclaimer.html ______________________________________________________________________ This email has been scanned by the Symantec Email Security.cloud service. For more information please visit http://www.symanteccloud.com ______________________________________________________________________ ______________________________________________________________________ This email has been scanned by the Symantec Email Security.cloud service. For more information please visit http://www.symanteccloud.com ______________________________________________________________________ ______________________________________________________________________ This email has been scanned by the Symantec Email Security.cloud service. For more information please visit http://www.symanteccloud.com ______________________________________________________________________
