Wednesday, February 29, 2012

Lightswitch needs SQL Express 2008 but no sysadmin rights


The PC I am using for my current assignment was given to me by my predecessor, it runs on Windows 7. He had installed VS2008 with SQL Express 2005. I needed to create a lightswitch app and therefore I installed VS2010, and then VS Lightswitch 2011.

The VS2010 SQL express installation failed, maybe because a SQL Express 2005 had been installed by my predecessor.

Since the SQL Express 2005 was there, I tried to develop a Lightswitch app with security. To use the security features on my developer PC, VS Lightswitch wants to use SQLEXPRESS. when you debug the app and try to create Roles under the Administration tab, the roles cannot be saved. I tried to make it use a named Developer version of SQL 2008 that was also installed on this PC, but to no avail (how is for the next topic). When trying to save a role on the SQL Dev version, I got the error message 'The user instance login flag is not supported on this version of SQL Server. The connection will be closed'.

Lightswitch needs SQL Express 2008 on the developer pc and to create databases in SQLEXPRESS I need admin rights on the SQLEXPRESS instance.

Solution:
  • Download the SQL Express 2008 R2.
  • Uninstalling the SQL 2005 express failed. Install as an upgrade on the SQL 2005 express worked.
  • Run SQL server management studio to add my windows daomin account as sysadmin. Since my predecessor had done the initial installation, I did not have admin rights, so that did not work.
  • Final Solution: run SQL server Management studio as Administrator, then add my account as sysadmin, this worked.

Finally: tested my Lightswitch project, added a role and saved it. Problem solved

4 comments:

ninest123 said...

louis vuitton outlet, sac longchamp, ralph lauren pas cher, replica watches, louboutin outlet, louboutin shoes, christian louboutin outlet, prada outlet, ugg boots, longchamp pas cher, tiffany and co, louis vuitton, louboutin, air jordan pas cher, tory burch outlet, cheap oakley sunglasses, nike outlet, polo ralph lauren outlet, ray ban sunglasses, polo ralph lauren outlet, louis vuitton outlet, nike air max, replica watches, louis vuitton, air max, longchamp outlet, michael kors, oakley sunglasses, chanel handbags, nike free, nike roshe run, oakley sunglasses, burberry, tiffany jewelry, ray ban sunglasses, kate spade outlet, prada handbags, oakley sunglasses, nike air max, louis vuitton, louboutin pas cher, uggs on sale, ray ban sunglasses, oakley sunglasses, longchamp, jordan shoes, gucci outlet, ugg boots, nike free, longchamp outlet

ninest123 said...

vanessa bruno, coach outlet, nike free run uk, michael kors, michael kors outlet, coach outlet, replica handbags, new balance pas cher, michael kors outlet, hollister pas cher, michael kors, converse pas cher, nike air max, tn pas cher, ray ban pas cher, michael kors, abercrombie and fitch, lululemon, ralph lauren uk, vans pas cher, michael kors, michael kors outlet, mulberry, nike air max, kate spade handbags, nike air max, hermes, ugg boots, hollister, nike roshe, lacoste pas cher, oakley pas cher, nike blazer, ugg boots, true religion jeans, michael kors outlet, sac guess, air force, true religion outlet, hogan, ray ban uk, coach purses, timberland, north face, burberry, michael kors outlet, true religion jeans, burberry outlet online, north face, true religion jeans

ninest123 said...

lancel, celine handbags, jimmy choo shoes, bottega veneta, nike roshe, asics running shoes, gucci, giuseppe zanotti, nike huarache, mcm handbags, herve leger, hollister, hollister, new balance, ray ban, p90x workout, soccer shoes, babyliss, longchamp, mac cosmetics, nike trainers, chi flat iron, mont blanc, vans, vans shoes, ghd, iphone cases, nike air max, hollister, ferragamo shoes, ralph lauren, louboutin, nike air max, beats by dre, valentino shoes, converse outlet, lululemon, north face outlet, instyler, soccer jerseys, birkin bag, insanity workout, baseball bats, north face outlet, abercrombie and fitch, timberland boots, reebok shoes, nfl jerseys, oakley, wedding dresses

ninest123 said...

hollister, louis vuitton, canada goose outlet, moncler, pandora jewelry, swarovski, louis vuitton, bottes ugg, coach outlet, moncler, supra shoes, montre pas cher, moncler, ugg,uggs,uggs canada, ugg,ugg australia,ugg italia, canada goose, links of london, pandora jewelry, karen millen, doudoune canada goose, juicy couture outlet, moncler, pandora charms, marc jacobs, swarovski crystal, moncler, ugg pas cher, thomas sabo, louis vuitton, moncler outlet, moncler, canada goose, canada goose uk, canada goose outlet, ugg boots uk, juicy couture outlet, wedding dresses, moncler, canada goose, toms shoes, louis vuitton, replica watches, sac louis vuitton pas cher, pandora charms, canada goose