a virtual machin on a cloud host my sitethe ms sql server is on the same windows serveri wrote this connection string to commubicate between the site and the sql server but its not workingData Source=.\;AttachDbFilename=|DataDirectory|\aa.MDF;Integrated Security=True;Trusted_Connection=Yes.\ - its the only sql server instance i have, and that the way I get to it with the management studioand because the host and the sql server are on the same os, I thought that should be the source.and it is in the data directory, and the name of the mdf file is aa.MDFwhere is my mistake?if there is a better place to post this question, I will be happy to know.thanks

a virtual machin on a cloud host my sitethe ms sql server is on the same windows serveri wrote this connection string to commubicate between the site and the sql server but its not workingData Source=.\;AttachDbFilename=|DataDirectory|\aa.MDF;Integrated Security=True;Trusted_Connection=Yes.\ - its the only sql server instance i have, and that the way I get to it with the management studioand because the host and the sql server are on the same os, I thought that should be the source.and it is in the data directory, and the name of the mdf file is aa.MDFwhere is my mistake?if there is a better place to post this question, I will be happy to know.thanks

The attachdbfilename is specific to sql express I think (not certain though). Are you using that?