I am trying to connnect to a sql data base but I keep getting an error stating that the login has faild. I am setting the connection to the data base within a web config file and the connection work before deployment but not after the web application has been deployed.
This is my connection string is there somthing missing from this statement?
<connectionStrings>
<add name="OASIS_ConnectionString" connectionString="Data Source=DCM01;Initial Catalog=Dev;Integrated Security=True"
providerName="System.Data.SqlClient" />
</connectionStrings>
Check the statements given below with your's.....
<configuration>
<appSettings>
<add key="connection" value="Initial Catalog=Purchase;Data Source=(local);Integrated Security=SSPI" />
</appSettings>
<connectionStrings>
<add name="PurchaseConnectionString" connectionString="Data Source=(local);Initial Catalog=Purchase;Integrated Security=True"
providerName="System.Data.SqlClient" />
</connectionStrings>
<system.web>
<!--
Set compilation debug="true" to insert debugging
symbols into the compiled page. Because this
affects performance, set this value to true only
during development.
-->
<compilation debug="true"/>
<!--
The <authentication> section enables configuration
of the security authentication mode used by
ASP.NET to identify an incoming user.
-->
<authentication mode="Windows"/>
<!--
The <customErrors> section enables configuration
of what to do if/when an unhandled error occurs
during the execution of a request. Specifically,
it enables developers to configure html error pages
to be displayed in place of a error stack trace.
<customErrors mode="RemoteOnly" defaultRedirect="GenericErrorPage.htm">
<error statusCode="403" redirect="NoAccess.htm" />
<error statusCode="404" redirect="FileNotFound.htm" />
</customErrors>
-->
</system.web>
</configuration>
Regards,
Mathew.