Yes to both of those. [cid:[email protected]]
From: [email protected] [mailto:[email protected]] On Behalf Of Todd Hemsell Sent: Tuesday, July 5, 2016 6:46 PM To: [email protected] Subject: Re: [mssms] CS.ini SQL without NAMED PIPES This message originated outside of Unum. Use caution when opening attachments, clicking links or responding to requests for information. Are you specifying a SQLShare? Does the Database allow integrated authentication? On Tue, Jul 5, 2016 at 2:52 PM, Giroux, Eric J <[email protected]<mailto:[email protected]>> wrote: I need a bit of guidance to make SQL connection from CustomSettings.ini using NT Authentication (network access account) vs named pipes. Have always used named pipes successfully but DBAs are putting their foot down on dis-allowing use of named pipes. Adding Netlib=DBMSSOCN to my SQL section of my CS.ini is giving me a return of: ZTI error opening SQL Connection: Login failed for user ‘NT AUTHORITY\ANONYMOUS LOGON’. (-2147217843). I assumed by adding Netlib=DBMSSOCN it would authenticating using network access account credentials but this feels as though it is needing a SQL ID and pwd to make the connection, which I do not want to use. Is anyone using Netlib=DBMSSOCN successfully? Thanks, Eric Giroux Solutions Engineer Unum Group E-mail: [email protected]<mailto:[email protected]> | Office: (207) 575-2482 Mobile: (207) 239-5190 | Fax: (207) 575-2158
