Just Installed, Unable to Authenticate into SSMS

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2008 Forums

SQL Server Administration (2008)

Just Installed, Unable to Authenticate into SSMS

Author

Topic

agfreesafety
Starting Member

7 Posts

Posted - 2011-01-28 : 18:26:30

I'm really new to SQL, but decided to install the Eval Version of SQL 2008 to learn more about it.

I just completed the installation, so I'm attempting to log into Management Studio for the first time. At the login screen, when I choose SQL Authentication in the Authentication dropdown using the sa account I get:
Cannot connect to [computer name] Addional information: Login failed for user 'sa'. (Microsoft SQL Server, Error:18456).

For the password for the 'sa' account, I put in the password that I entered at the Server Configuration Page in the SQL Server 2008 Wizard. I wasn't sure what else I was supposed to put in here, as I don't recall setting up any other users or passwords during the install process.

When I switch to Windows Authentication, it pulls up my local username and when I click Connect I get the same error.

What's going on, and how can I get authenticated? I must admit that I don't remember what I entered in the Account Name column for the SQL Server Agent or Database Engine Services, might that be the issue?

I ran a repair of the install, but that didn't fix the issue. I noticed in Computer Management, that almost all of the SQL-related services have the 'NT AUTHORITY\NETWORK SERVICE' user noted in the 'Log On As' column.

Please help. I'm hoping that something I said above provides a clue for you. Thanks in advance.

Sachin.Nand

2937 Posts

Posted - 2011-01-29 : 14:53:39

Seems you haven't configured the server for mixed authentication mode.

PBUH