Post reply

Problem accessing the sql from .net application using the Integrated Security=SSPI

  • June 7, 2011 at 5:00 am

    #240893

    I am using sql server 2005 running on Windows 2008 server

    I am getting this error in log

    Error : 18456, Severity : 14, State : 11

    Login failed for user 'NT AUTHORITY\NETWORK SERVICE'

    this error is generating in the front end .net application

    We ar using the Integrated Security=SSPI with an IIS/ASP

    application.The DB is assigned to NT AUTHORITY\SYSTEM login.

    I am able to login with Windows authentication with Window server credentials

    Please help

    with regards

    Dilip D

  • June 7, 2011 at 5:42 am

    #1334913

    the server is in SQL Server and Window Authentication Mode Since the DB is accesed by NT AUTHORITY\SYSTEM which is in built login...to check the connection i used Window authentication mode We are using this connection string

    <add key="ConnectionString" value="Initial Catalog=DBName;Data Source=ServerName\InstanceName;Integrated Security=SSPI;Trusted_Connection=true" />

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply