sql Database connection

[Sheena777]

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?
<connectionStri ngs>
<add name="OASIS_Con nectionString" connectionStrin g="Data Source=DCM01;In itial Catalog=Dev;Int egrated Security=True"
providerName="S ystem.Data.SqlC lient" />
</connectionStrin gs>

[mathewgk80]

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?
<connectionStri ngs>
<add name="OASIS_Con nectionString" connectionStrin g="Data Source=DCM01;In itial Catalog=Dev;Int egrated Security=True"
providerName="S ystem.Data.SqlC lient" />
</connectionStrin gs>

Check the statements given below with your's.....

<configuratio n>
<appSettings>
<add key="connection " value="Initial Catalog=Purchas e;Data Source=(local); Integrated Security=SSPI" />
</appSettings>
<connectionStri ngs>
<add name="PurchaseC onnectionString " connectionStrin g="Data Source=(local); Initial Catalog=Purchas e;Integrated Security=True"
providerName="S ystem.Data.SqlC lient" />
</connectionStrin gs>
<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.
-->
<authenticati on 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="RemoteOnl y" defaultRedirect ="GenericErrorP age.htm">
<error statusCode="403 " redirect="NoAcc ess.htm" />
<error statusCode="404 " redirect="FileN otFound.htm" />
</customErrors>
-->
</system.web>
</configuration>


Regards,
Mathew.