I have installed SQL Server 2012 and LocalDB on my development machine, and am able to connect to LocalDB using both the SQL Server Management tool 2012 and from within my winform application using a newly modifed connection string Shown below:
Data Source=(LocalDB)\v11.0;AttachDbFilename=|DataDirectory|\MyDatabase.mdf;Integrated Security=True;Connect Timeout=60
The problem arises when I attempt to port my application onto a Windows 2008 Server which is running SQL Server 2008, (I know I could skip the LocalDB installation and just make use of SQL Server 2008, but I am just testing the installation of my application on this machine.. )
I have installed both SQL Server 2012 LocalDB and updated .net 4.01 to .net 4.02 using the kb article located at http://support.microsoft.com/kb/2544514
I keep getting getting an error when I attempt to connect to
(LocalDB)\v11.0 from both my application and from the SQL Server Management 2008 Tool, I have also manually started up
cmd->SQLLocalDB -s "v11.0" and then attempted to connect once again using the NP
When I use the named pipe everything connects fine, so I am assuming that as this works then the installation of LocalDB is also correct.
What do you suggest I do to resolve this situation?
I am also concerned as to the proper implementation moving forward with the deployment of my application, am I supposed to now include .Net 4.03 as a prerequisite? If so is there already a clickonce bootstrap manifest available for this or do I need to create one.. so that my app works correctly moving forward, I'm really concerned that LocalDB might break it.. as so far I'm not having much luck..
I guess if all else fails I can go back to using SQL Server Express 2008 as this implementation worked correctly before..