Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'. Microsoft OLE DB Provider for SQL Server error '80040e4d' Given proper rights to the local user on the cockpit database.īut when we try to connect to the database using above given connection string, we are getting following error: We followed following step to set-up the application:Ĭreated a local user for using it as an anonymous user (IUSR_COCKPIT) on the machine hosting IIS.Ĭreated local user with same name and password on the machine hosting SQL server.
Now we have a set-up where IIS 6.0 and SQL Server 2000 are running on different physical machines. This change worked fine when we were testing it on the environment where both IIS 6.0 and SQL Server 2000 were running on the same box (Windows Server 2003). We used IIS anonymous user (IUSR_Machinename) to connect to database. StrConn = strConn & "Integrated Security=SSPI Trusted_Connection=yes" StrConn = "Provider=SQLOLEDB Data Source=HEODEV07 Initial Catalog=Cockpit " Following is the connection string that we are using:
It was using SQL Server 7.0 and connection to the database was through SQL Server authentication (SQL Server was set-up with mixed authentication mode).Ĭurrently due to the change in the SQL Server authentication method from 'SQL Server authentication' to 'Windows NT authentication' we had to change the connection string that we use to connect to the database. The application was developed and deployed on IIS 4.0 running Windows NT. Following is the issue that we are facing currently in setting up our application.
0 kommentar(er)
