// you’re reading...

Microsoft

SQL Server 2008 R2 on Windows 8: “” is not a valid login or you do not have permission

Got rid of Windows 7 and installed Windows 8 RTM on my laptop. To get back to work, went right ahead to install Visual Studio and SQL Server.

Installation of Visual Studio 2010 was a breeze but SQL Server 2008 R2 left me with a dreadful error saying – “” is not a valid login or you do not have permission. This showed up during the installation.

By ignoring this error, the installation proceeds but I was unable to login using SQL Server Management Studio.

When I popped up the installation of SQL Server, it did complain about compatibility issues. But I chose to ignore it. This is because the solution suggested that I should upgrade to Service Pack 1 post installation. Well, only if I could finish the installation without errors ;-)

Obviously, to start with,  I googled for any known issues with SQL Server 2008 R2 and Windows 8. I ended up wasting my time. I should have googled for the error message instead.

When I googled for the error message, many articles suggested that this happens when the computer name and the username are the same. This hinders the Windows Authentication for SQL Server. My username on Windows 8 was Shekhar\Shekhar !!!

But how come I never faced this issue before on Windows < 8 (like Windows 7, XP) ?

During the installation of Windows 8, I had set the computer name as Shekhar. The installation did not prompt me to create a user because Windows 8 uses the Microsoft Live ID for login. Windows < 8 allows to create a username during the installation and complains big time if the username and computer name are the same. The login or Email of my Live ID is shekhar at it4enterprise dot com. After installation of Windows 8, when I logged in using my Live ID, Windows 8 created a user called Shekhar.

During the installation of SQL Server, when I was prompted to select a user for Windows Authentication, I opted to click on “Add Current User” which was Shekhar/Shekhar. And hence the error.

The fix was as easy as going to Computer>Properties>Change Settings and changing the Computer Name by clicking on the Change button. I changed the Computer Name to Shekhar-Laptop.

Henceforth, I rebooted the computer, uninstalled SQL Server and reinstalled it. And this time no errors during the installation. I was also able to login using SQL Server Management Studio and got started with some real work! :-)

GD Star Rating
loading...
GD Star Rating
loading...
SQL Server 2008 R2 on Windows 8: "" is not a valid login or you do not have permission, 9.1 out of 10 based on 22 ratings
Share

Email This Post Email This Post Print This Post Print This Post Print This Post Post A Comment Tweet your comments/question to me @shekharg

Discussion

12 comments for “SQL Server 2008 R2 on Windows 8: “” is not a valid login or you do not have permission”

  1. But why in the world are you working on visual studio??

    Posted by Prateek Khanna | October 9, 2012, 4:49 am
  2. Hi Prateek!

    Just found your comment in the spam (let’s blame it on “visual studio” ;-)).

    But why in the world are you working on visual studio??

    Surprise: I happen to do .Net too, since 1.0

    Posted by Shekhar | October 22, 2012, 3:04 am
  3. Thanks, was a great help.

    Posted by rik prenen | May 30, 2013, 2:56 pm
  4. Hi Shekhar

    I am a complete novice at IT domain and and working on learning MS SQL on my own. I tried installing the MS 2008 Express Microsoft® SQL Server® 2008 R2 SP2 – Express Edition on my Windows 8 laptop, but on successful installation i am unable proceed further as to how to go about accessing SQL and actually getting to work on it. Would be great if you could help me out.

    P.S : Hoping this goes straight to your Inbox :)

    Regards
    Ramya

    Posted by Ramya | March 23, 2014, 6:06 pm
  5. Hi Ramya,

    but on successful installation i am unable proceed further as to how to go about accessing SQL and actually getting to work on it.

    The installation should have installed an application called SQL Server Management Studio. In Windows 8, press the Windows Key and the ‘C’ key simultaneously. Next, click on Search (on the left panel which shows up) and type in management studio.

    This will show SQL Server Management Studio. Click on that. When the application opens, select SQL Server authentication from the dropdown labelled as Authentication. Type in sa for username and the password that you had set during the installation.

    In case you haven’t set or don’t remember the password, try selecting Windows Authentication from the dropdown and click on Connect.

    The management studio will show you the databases, allow you to create new databases, tables and execute SQL queries.

    Please feel free to post any further queries.

    Posted by Shekhar | March 23, 2014, 7:15 pm
  6. All u said was 100% correct,so I am doing the same as u said..

    Posted by Subham saraogi | May 13, 2014, 9:34 pm
  7. I followed the process and crosse the first level of installation but now when my installation is completed a new msg is showing while conecting to server so what should I do???

    Posted by subham | May 13, 2014, 9:58 pm
  8. Hi subham,

    but now when my installation is completed a new msg is showing while conecting to server so what should I do???

    What is the msg?

    Posted by Shekhar | May 16, 2014, 10:56 am
  9. Posted by olia | May 26, 2014, 2:08 pm
  10. Hi olia

    Thank you, had the same issue as you did.

    Cool. Indeed a cryptic error without a hint to the problem ;)

    Posted by Shekhar | May 26, 2014, 4:07 pm
  11. i am not able to remember my password for log in

    Posted by kapil joshi | May 28, 2014, 10:33 am
  12. Hi kapil joshi,

    i am not able to remember my password for log in

    Please refer to this link http://www.wikihow.com/Reset-SA-Password-in-Sql-Server I have not tested these methods. Let me know if they work for you

    Posted by Shekhar | May 28, 2014, 3:40 pm

Post a comment