a virtual machin on a cloud host my site the ms sql server is on the same windows server i wrote this connection string to commubicate between the site and the sql server but its not working Data 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 studio and 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.MDF where 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 site the ms sql server is on the same windows server i wrote this connection string to commubicate between the site and the sql server but its not working Data 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 studio and 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.MDF where 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?