Post reply

install SQL 05 on Windows 7

  • August 11, 2010 at 6:35 am

    #141380

    I installed SQL 2005 on Win 7 just like I did on many other pc's (windows xp, server, etc) and never had an install issue. Today, when I try to connect to my local SQL 05 instance using windows auth, I get and SQL Error

    Login failed for user 'domain\username' microsoft sql server error 18456).

    how can I get windows auth to work on my win 7 pc? I can login to via the sa account, but I would rather not do that

  • August 11, 2010 at 6:44 am

    #1205313

    in Win7 and Vista, security is a little tighter...you don't get added automatically to the instance you are installing. One of the steps during the install is to add yourself [domain login] as a SQL Administrator; if you breeze past that step, you have to use the 2005 Surface Area Configuration to add yourself:

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

  • August 11, 2010 at 6:53 am

    #1205320

    thanks, I have to say, the security on Win 7 is brutal.

    this helped, thanks alot.

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply