Connection error IIS10/SQL 2016

I try to transfer a classic-asp-application from Windows Server 2008R2/II7 to 2016/II10 and SQL 2008 to SQL 2016.
The application works fine with IIS10 and SQL 2008. Also with IIS7 and SQL 2016.
With IIS10 and SQL 2016 occurs an error:
-2147217843
Microsoft OLE DB Provider for SQL Server
Fehler bei der Anmeldung für den Benutzer username

The connectionstring is
PROVIDER=SQLOLEDB;DATA SOURCE=sqlserver;UID=username;PWD=password;DATABASE=database

The provider SQLNCLI11 results the same error.

Where is my mistake?

0 answers