Answer 1:
Getting rid of
Integrated Security=true worked for me.Answer 2:If your SQL Server is on one domain controller and you are trying to connect to it from another domain controller then you will get this error when
IntegratedSecurity = true;
This will happen even if you include a valid SQL Server username and password in your connection string as they will automatically be over-written with your windows login and password. Integrated security means simply – use your windows credentials for login verification to SQL Server. So, if you are logged in to a different domain controller then it will fail. In the case where you are on two different domain controllers then you have no choice but to use
IntegratedSecurity = false;
Now, when Integrated security is false SQL Server will use the SQL Server login and password provided in your connection string. For this to work, the SQL Server instance has to have its authentication mode configured to mixed mode, being, SQL Server and Windows Authentication mode.
To verify or change this setting in SQL Server you can open the SQL Server Management Studio and right-click on your server name and then select Properties. On the pop-up that appears select Security and you will see where to alter this setting if you need to.
Modified as below:
<connectionStrings>
<add name=”DataAccess” providerName=”System.Data.SqlClient” connectionString=”database=Hotel;server=127.0.0.1,1433;UID=sa;PWD=123456;Current Language=English;Connection Timeout=120;” />
</connectionStrings>
Similar Posts:
- [Solved] No connection string named ‘TestEntities’ could be found in the application config file
- Solutions to database connection problems: “connections could not be acquired from the underlying database!”
- Use of wmic Intranet
- The use of libpqxx interface in Linux solves the error of PSQL: connections on UNIX domain socket “/TMP/.S.pgsql.5432”
- For the problem of establishing SSL connection in mysql, set usessl = false to explicitly disable SSL, or set usessl = true
- SQL Server 2019 opens the data file MDF with an error
- [Solved] ER_NOT_SUPPORTED_AUTH_Mode node connection database error
- [Solved] SSH connect error: permission denied, please try again
- [Solved] Error 1054 (42s22) unknown column ‘password’ in ‘field list’ when updating the password of mysql5.7 or above
- [How to Solve] nodejs mysql ER_NOT_SUPPORTED_AUTH_MODE