sql server new users: SQL Msg: 18456 -- sql server new users

SQL Msg: 18456

Paul
6/29/2005 1:33:04 AM

sql server new users:

Hei!
I am getting this SQL error when i tried to use SQL Query Analyzer,
Unable to connect to server AxpServer1
Server: Msg 18456, level 16, state 1
Microsoft ODBC SQL Server Driver SQL Server Login failed for user 'sa'

On the EM SQL Server Properties (Configure) on the Security tab
Authentication is SQL Server and Windows based.
What is problem , i am trying to use other username and password but getting
same error on the Query Analyzer. If i use Connect using: Windows
authentication then it is OK.
Many thanks
--

Re: SQL Msg: 18456

Kevin3NF
6/30/2005 8:21:41 AM

Looks like you are using the wrong password for sa....have you tried
resetting it after you log in as yourself?

--
Kevin Hill
President
3NF Consulting

www.3nf-inc.com/NewsGroups.htm

www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs.

www.experts-exchange.com - experts compete for points to answer your
questions

[quoted text, click to view]