SQL Server 1012 LocalDB - Anyone using this?

[Amesville]

Hi Folks

I'm trying to set up an SQL Server database to run under LocalDB, a new runtime option for hosting a SQL Server (2012 Express) database useable by a locally installed Winforms project. I already have a database set up in SQL Server 2008 Express I want to transfer into it, and have gotten LocalDB let up in SSMS 2012 to the point where I can log into it as a public object. But it isn't running, which means I can't do anything with it. Any ideas on how I can get this running so I can copy my database into it? I don't currently have VS 2012 or 2010 which may be part of the problem, my App is written in VS 2008 (VB).

Any ideas?

Craig

 

[vbajock]

My guess is the SQL Server server service isn't running. Did you check Control Panel/Admin Tools/Services to see if SQL Express is running as a service? If it's there, set it to automatic if it is manual:

http://stackoverflow.com/questions/12774827/cant-connect-to-localhost-on-sql-server-express-2012

You may need to add some of this code to your project to start/stop the service from code:

http://accesstips.wordpress.com/200...ess-vba-uses-wmi-to-control-windows-services/