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  General SQL Server Forums  New to SQL Server Programming  MS SQL 2005 Express Authentication

Author  Topic  Tokajac Starting Member 5 Posts Posted - 2009-05-14 : 06:37:17 Hello! I have trouble with Authentication. In SQL Server Configuration Manager I clicked on Properties; There are 3 tabs: Log On, Service, Advanced Under Log On there are: Built-account This account At "This account" I'm able to set only Windows credentials which are used for logging on to system, also. This is done. From Microsoft Server Management Studio Express I choose SQL Server Authentication, type Windows credentials; I get Error message which shows that Login and Password are incorrect. Suddenly, when I chose Windows authentication -login is successful. How can I log on via SQL Server Authentication (Login, Pass)? Regards P.S. SQL Server Authentication is necessary