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'.
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.
2 comments:
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
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
Post a Comment