In the SQL server configuration tools, TCP/IP protocol is required to be enabled on the server as well. Also, the ConfigMgr Network Access Account needs a SQL login and granted db_datareader perms to the MDT database.
1E | Software Lifecycle Automation On Jul 5, 2016, at 1:05 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 ________________________________ Legal Notice: This email is intended only for the person(s) to whom it is addressed. If you are not an intended recipient and have received this message in error, please notify the sender immediately by replying to this email or calling +44(0) 2083269015 (UK) or +1 866 592 4214 (USA). This email and any attachments may be privileged and/or confidential. The unauthorized use, disclosure, copying or printing of any information it contains is strictly prohibited. The opinions expressed in this email are those of the author and do not necessarily represent the views of 1E Ltd. Nothing in this email will operate to bind 1E to any order or other contract.
