Keith Devens .com - Weblog: SQL server authentication on Vista, error 18456

Friday, July 25, 2008

SQL server authentication on Vista, error 18456

SQL SERVER 2005 - FIX Error: 18456 : VISTA Windows Authentication. I recently ran into this problem on Vista. Problem is, I never bothered setting up an sa user because I was just going to log in with Windows authentication, so I wasn't able to log into the server at all. Easiest way for me to get in was to uninstall and reinstall the whole thing.

So... make sure you always set up an sa user.

Permalink | Comments? | Tags: linkblog | id 8481

16:30 (utc-5)
edited: 16:31 (utc-5)

Comments

Feel free to post a comment below. Please see my comment policy.

Formatting Rules (No HTML):

**bold**, *italic*, _underlined_, --strikeout--
"text"="url" creates a link, and URLs are auto-highlighted
Blockquote: Like e-mail, begin paragraph with > (greater-than sign)
Lists: begin paragraph with *,-, or + (unordered), or # (ordered)
Code block: ?!code:language=perl|php|sql|javascript|etc.{\n}...{\n}?!/code

RSS feed RSS feed for Keith's Weblog
Atom feed Atom feed for Keith's Weblog
Weblog archive
Recent comments
on 2 posts