Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I installed Windows 8 on my laptop and I'm going through installing my software. I just installed SQL Server 2008 R2, but none of the logon information I supplied will allow me to logon. I'm not sure what the problem is. I tried using Windows authentication and SQL Authentication. I didn't have this problem installing on Windows 7. Has anyone else gone through this?

share|improve this question

migrated from Sep 17 '11 at 21:56

This question came from our site for professional and enthusiast programmers.

Did you set it up for windows auth or mixed mode? – billinkc Sep 17 '11 at 13:32
Thanks for the input. The problem was, I was trying to connect to the instance name. I needed to connect to .[Instance Name]. You provided good information I will likely need in the future. – PaulJBeaton Sep 17 '11 at 14:35
How exactly were you able to install it?! I keep on getting an error telling me I'm installing a copy of SQL Server with a language that is different from the OS language! the only problem is, the OS default language is English, and the installer I am using is English ... SO I don't know what is I'm doing wrong ... – user95145 Sep 19 '11 at 12:57
I would suggest you post this to the board. Since this question was already answered, I'm not sure anyone will look at this anymore. – PaulJBeaton Sep 28 '11 at 15:29
up vote 1 down vote accepted

Assuming you are an admin on your machine, you can start it in single user mode and then it's a simple matter of fixing it - Connecting to SQL Server When System Administrators Are Locked Out

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.