I just installed SQL Express 2014. Did not ask for any loging options during the install process. It seemed to proceed on its own. But after the installation was completed when I connect using SQL Server Management Studio, I am defaulted to the windows login
and password.
Once I am connected I tried to create a new database, but I get the following error.
"CREATE DATABASE Permission denied in database 'master'. (Microsoft SQL Server , Error: 262)
(My Windows login has Admin rights on the computer that I am working on)
So I tried to enable the "sa" account , Again I get an error.
"Cannot alter the login 'sa', because it does not exist or you do not have permission. (Microsoft SQL Server, Error: 15151).
How to solve this issue. All I want is to be able to create new Database.
Go to the complete details ...