Posted: 10/22/2011
Hi everyone,
I would like to apologies in advance as I am a Java guy, I've only ever worked with Linux servers and MySQL DBs so and my knowledge of Microsoft techs and languages is very limited/non existent so I thought I would ask the pro's. I have been given a website that was build in ASP.NET 4.0 that I need to get up and running on a dedicated 2008 r2 server. Unfortunately the person that wrote the code is no longer available to provide any help at all, so I have to try and figure this out myself (hopefully with somebody’s help).
My first question relates to the communication string used in a .NET application to connect to a MSSQL db. Currently the database will be on the same server as the main web application.
I have created a dummy db using the SQL server manager studio. Bellow is a screen shot of the 'connection properties'.
I have found what I assume to be the connection String used to make the connection inside a web.config file located in the root of the application:
<connectionStrings> <add name="WebsiteConnectionString" connectionString="Data Source=;Initial Catalog=;Integrated Security=True" providerName="System.Data.SqlClient"/>
</connectionStrings>
Assume that the database password is: 0123456789 and that the IP of the server is 00.00.00.00.
How would I configure the string to communicate with the db?
Not a problem I have solved the issue thanks