The keyword 'integrated security' is not supported on this platform.

[wklm]

Hi, I follow steps in readme to run the project on ubuntu 14.04. Unfortunatelly by step VIIIb (dotnet ef database update) there's following error message:

wojtek@dell:~/aspnet5-angular2-typescript/src/PhotoGallery$ dotnet ef database update Project PhotoGallery (.NETCoreApp,Version=v1.0) will be compiled because Input items added from last build Compiling PhotoGallery for .NETCoreApp,Version=v1.0 Compilation succeeded. 0 Warning(s) 0 Error(s) Time elapsed 00:00:07.9432541

System.NotSupportedException: The keyword 'integrated security' is not supported on this platform. at System.Data.SqlClient.SqlConnectionString..ctor(String connectionString) at System.Data.SqlClient.SqlConnectionFactory.CreateConnectionOptions(String connectionString, DbConnectionOptions previous) at System.Data.ProviderBase.DbConnectionFactory.GetConnectionPoolGroup(DbConnectionPoolKey key, DbConnectionPoolGroupOptions poolOptions, DbConnectionOptions& userConnectionOptions) at System.Data.SqlClient.SqlConnection.ConnectionString_Set(DbConnectionPoolKey key) at System.Data.SqlClient.SqlConnection.set_ConnectionString(String value) at Microsoft.EntityFrameworkCore.Storage.Internal.SqlServerConnection.CreateDbConnection() at Microsoft.EntityFrameworkCore.Internal.LazyRef`1.get_Value() at Microsoft.EntityFrameworkCore.Migrations.Internal.Migrator.Migrate(String targetMigration) at Microsoft.EntityFrameworkCore.Design.MigrationsOperations.UpdateDatabase(String targetMigration, String contextType) at Microsoft.EntityFrameworkCore.Tools.Cli.DatabaseUpdateCommand.<>c__DisplayClass0_0.<Configure>b__0() at Microsoft.Extensions.CommandLineUtils.CommandLineApplication.Execute(String[] args) at Microsoft.EntityFrameworkCore.Tools.Cli.Program.Main(String[] args) The keyword 'integrated security' is not supported on this platform.

How can I fix it? Cheers, Wojtek

[chsakell]

Not an expert on that platform but a fellow had created a pull request which removes the MS SQL Server dependency . You might find it helpful. View the pull request here

[gacostab]

I just checked that project. I think there are differences between his project and yours. He is using the DNX CLI libraries to compile the project.

Meanwhile you are using the dotnet libraries from

I think there is an impact in the portability between both libraries. I tried yours and works fine, meanwhile the other port have issues with the dependencies in v5.0.

Look the following lines.

error: Package Ix-Async 1.2.5 is not compatible with dnxcore50 (DNXCore,Version=v5.0). Package Ix-Async 1.2.5 supports: error: - net40 (.NETFramework,Version=v4.0) error: - net45 (.NETFramework,Version=v4.5) error: - portable-net45+win8+wp8 (.NETPortable,Version=v0.0,Profile=Profile78) error: Package Remotion.Linq 2.0.1 is not compatible with dnxcore50 (DNXCore,Version=v5.0). Package Remotion.Linq 2.0.1 supports: error: - net35 (.NETFramework,Version=v3.5) error: - net40 (.NETFramework,Version=v4.0) error: - net45 (.NETFramework,Version=v4.5) error: - portable-net45+win8+wp8+wpa81 (.NETPortable,Version=v0.0,Profile=Profile259) error: Package Microsoft.CodeAnalysis.CSharp 1.1.0-rc1-20151109-01 is not compatible with dnxcore50 (DNXCore,Version=v5.0). Package Microsoft.CodeAnalysis.CSharp 1.1.0-rc1-20151109-01 supports: error: - net45 (.NETFramework,Version=v4.5) error: - portable-net45+win8 (.NETPortable,Version=v0.0,Profile=Profile7) error: Package Microsoft.CodeAnalysis.Common 1.1.0-rc1-20151109-01 is not compatible with dnxcore50 (DNXCore,Version=v5.0). Package Microsoft.CodeAnalysis.Common 1.1.0-rc1-20151109-01 supports: error: - net45 (.NETFramework,Version=v4.5) error: - portable-net45+win8 (.NETPortable,Version=v0.0,Profile=Profile7) error: One or more packages are incompatible with DNXCore,Version=v5.0. info : Committing restore... log : Writing lock file to disk. Path: /home/juan/deployTest/pgApp2/PhotoGallery/project.lock.json log : /home/juan/deployTest/pgApp2/PhotoGallery/project.json log : Restore failed in 62881ms.

Errors in /home/juan/deployTest/pgApp2/PhotoGallery/project.json Package Ix-Async 1.2.5 is not compatible with dnxcore50 (DNXCore,Version=v5.0). Package Ix-Async 1.2.5 supports: - net40 (.NETFramework,Version=v4.0) - net45 (.NETFramework,Version=v4.5) - portable-net45+win8+wp8 (.NETPortable,Version=v0.0,Profile=Profile78) Package Remotion.Linq 2.0.1 is not compatible with dnxcore50 (DNXCore,Version=v5.0). Package Remotion.Linq 2.0.1 supports: - net35 (.NETFramework,Version=v3.5) - net40 (.NETFramework,Version=v4.0) - net45 (.NETFramework,Version=v4.5) - portable-net45+win8+wp8+wpa81 (.NETPortable,Version=v0.0,Profile=Profile259) Package Microsoft.CodeAnalysis.CSharp 1.1.0-rc1-20151109-01 is not compatible with dnxcore50 (DNXCore,Version=v5.0). Package Microsoft.CodeAnalysis.CSharp 1.1.0-rc1-20151109-01 supports: - net45 (.NETFramework,Version=v4.5) - portable-net45+win8 (.NETPortable,Version=v0.0,Profile=Profile7) Package Microsoft.CodeAnalysis.Common 1.1.0-rc1-20151109-01 is not compatible with dnxcore50 (DNXCore,Version=v5.0). Package Microsoft.CodeAnalysis.Common 1.1.0-rc1-20151109-01 supports: - net45 (.NETFramework,Version=v4.5) - portable-net45+win8 (.NETPortable,Version=v0.0,Profile=Profile7) One or more packages are incompatible with DNXCore,Version=v5.0.

I'm not quite sure which one is the best framework. I'm still confused with this different versions.

[italojs]

do you set Trusted_Connection=true in your connectionString? if yes, remove it

[Saurab-1010]

{ //Change the Connection string to below if you are on vs 2022.
"ConnectionStrings": { "EmployeeAppCon": "Server=.; Database=EmployeeDB; Trusted_Connection=True;" }, "Logging": { "LogLevel": { "Default": "Information", "Microsoft.AspNetCore": "Warning" } }, "AllowedHosts": "*"

}