i have a vb.net project, i used ms sql server 2014, created a db in it then connected to visual studio 2013
(conn = "Data Source=.\sqlexpress;Initial Catalog=sdb;Integrated Security=True")
it is not .mdf nor sdf i read in many pages that i may have to install ms sql server on the target machine or use MSI through installshield and what have you, but nothing is clear to me, now i have to deploy the project and i can make a setup file (exe) and normally install ms sql server on other machines, im sure it will work but that is not what i seek, about five users will be using this application, nothing shared over a network i just wanna put the thing in a cd and hand it to whoever needs that app. but they will not know (let alone not need to know) how to install sql server i want it to just do the whole thing on its own, even if it has to install sql server but without giving the user headaches.
my question is taht is there a way to do this without installing the whole sql server (it just does not seem right) and by the way this mdf db thing just does not work for me, it always gives me errors (error while trying to attach to an auto-named database, it may be already existing bla bla..) i did post questions about the latter issue but nothing.
any help or tips please,