I'm setting up a SharePoint 2010 development machine and hit a snag.
I installed SQL Server 2008 R2 with the default instance (devserv1\mssqlserver). That's configured for mixed mode authent and I can login using either Windows Auth or SA no worries. Note that it's just a local machine account and NOT a domain account (this
is an isolated VM with no domain)
I installed SharePoint 2010 on the machine. I don't recall changing any settings and during the install, it has created a new instance called devserv1\sharepoint. I can login to it using Windows Authentication, but I don't appear to have any permissions.
Also, the SA user is disabled, but I can't enable it, because I get a permissions error when using my windows account to do it...
One thing I noticed that is a bit weird is the version numbers of the 2 instances - the first/default instance is 10.5.0.* whereas the one created by SharePoint install is 10.0.0.2513 or thereabouts - i.e., it's SQL 2008 but not R2 which I don't reallty
Anyway, how can I enable the sa account on the sharepoint instance?
Thanks.weirdbeardmt, PhD, BSc. Silly name, but lots of letters.
View Complete Post