![]() There are two common ways to create a connection string in. This makes it easy to work with multiple people on the same project (unlike other competing solutions). If you want to use MARS youll need to enable it in the connection string. ![]() The account to add in SQL Server is "IIS AppPool" (here "IIS AppPool\DefaultAppPool"):ĬodeFluent Entities provides several ways to define a connection string ( see documentation ). You must add the account of the AppPool:įirst thing: look at the pool application used by the site (here "DefaultAppPool"): The account displayed corresponds to the name of the machine followed by the "$" sign, but it is not this account that must be authorized in SQL Server. Unfortunately, the error message, although accurate, is not as explicit as it could be. .![]() This error occurs when the account running the website can not connect to the database. In many cases, you can use different names in the connection string to configure the same setting for example, the following two connection strings are equivalent: XML. In case of error, a complete error message is displayed: $conn.ConnectionString = "Server=(local) Database=Sample Integrated Security=True " $conn.Open()
0 Comments
Leave a Reply. |