Are you using the default instance of SQL or a named instance? What port number? Post your [DB_WIAT] section pls. can remove the values of server name and such, unless it has instance. Then replace the server name with SERVER and the instance name with INSTANCE. Leave the rest as is.
On Tue, Jul 5, 2016 at 6:28 PM, Giroux, Eric J <egir...@unum.com> wrote: > Yes to both of those. > > > > > > *From:* listsad...@lists.myitforum.com [mailto: > listsad...@lists.myitforum.com] *On Behalf Of *Todd Hemsell > *Sent:* Tuesday, July 5, 2016 6:46 PM > *To:* mssms@lists.myitforum.com > *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 <egir...@unum.com> 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: egir...@unum.com | Office: (207) 575-2482 > > Mobile: (207) 239-5190 | Fax: (207) 575-2158 > > > > > > > > > >
