ASP .NET and SQL server connection Error

[Jmshastri]

I am having Error while connecting to the SQL server database in ASP .NET application. The database server is on a remote pc. the code snipet that has error is shown below: Line 42: Dim cmd As New SqlClient.SqlCommand Line 43: con.ConnectionString = cstrg Line 44: con.Open() Line 45: cmd.Connection = con The Error Msg is: "SQL Server does not exist or Access Denied " Please tell me that what content of Web.Config file should I specify to connect successfully if the database server is named as BHAVIK and Database is named as ASP The portion of current web.config file is shown below:

Please help me out in this problem. Jwalant

[Colin Angus Mackay]

The web.config snippet is not showing up because it is treating the XML tags as HTML and the browser cannot render those. You need to escape the angle brackets < == < Also, it would be useful to know what the connection string is. You don't show that - unless it was in the web.config and we just can't see it. ColinMackay.net Scottish Developers are looking for speakers for user group sessions over the next few months. Do you want to know more?

[Jmshastri]

the connectionstring is: "Server=BHAVIK;Database=ASPDB;Integrated Security Info=SSPI" This is the connectionstring that I apply in the web.config file. the portion of web config file is shown below: <?xml version="1.0" encoding="utf-8" ?> <configuration> <appSettings> <add key="cs" value="Server=BHAVIK;Database=ASPDB;Integrated Security Info=SSPI" /> </appSettings> Do i need to change it or not?

[lavanya thadde]

Also include Username and Password and then try sdfsdfsdfsdf

[Ista]

If your using SSPI you dont need user name & password Navigate inside server explorer to a table inside your database and drag that onto your web form. Then go inside your code and copy the connection string that was built and paste it inside your web.config file It will work then 1 line of code equals many bugs. So don't write any!!