SQL Server 2008 R2 Express Cannot Login

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

Other SQL Server 2008 Topics

SQL Server 2008 R2 Express Cannot Login

Author

Topic

goss
Starting Member

29 Posts

Posted - 2010-08-02 : 22:40:54

Hi all,

Downloaded and installed Microsoft SQL Server 2008 R2 Express.
Opened SQL Server Management Studio to try to login

Settings:
Server type: Database engine
Server name: MYPC\SQLEXPRESS
Authentication: SQL Server Authentication
Login: MYPC\goss <<-- username setup during installation
Password: bigfatguy <<--password setup during installation

Error message:
Cannot connect to MYPC\SQLEXPRESS

Login failed for user 'mypc\goss'. (Microsoft SQL Server, Error: 18456)

Any idea what I'm doing wrong?

Thanks.

Kind regards,
-winston

goss
Starting Member

29 Posts

Posted - 2010-08-03 : 13:50:48

I switched Authentication to Windows Authentication Mode and I was able to login to SQL Server Management Studio

Kind regards,
-winston

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources