Posted on: 4/9/2015 10:24:50 AM | Views : 590

Hi.
Thanks in advance.
I currently have SQL 2008 Server R2 installed on my machine and its' working as expected.  With this via Mgmt Studio, I was unable to create a database on my local machine.  I kept getting permissions errors.  No matter what I did I could not do anything locally.
To alleviate this I installed SQL Server 2012 Express Mgmt. Studio on my local machine, for the sole purpose of being able to create a local database for testing and learning purposes.  During the install I was not prompted to configure the admin account or any other similar task so I could not set the sa password.  After the install was complete, when I launched 2012 express mgmt studio and selected my local machine as my server name (using Win authentication) and pressed the Connect button, I got:
"Login failure for user [domain\user].  (Microsoft SQL Server, Error:  18456].  This is the same error I was getting with my ...

Go to the complete details ...