Failed to connect to SQL server 2005 instance

[theresatan]

Hi:

I have a SQL 2005 instance (standard edition with sp2 on windows 2003 server) located on different domain.

I can connect to it by using sa only. I need to use SQL login.

I created another user called 'test' and granted with sysadmin server role, but I got following error:

Login failed for user 'test'. (Microsoft SQL Server, Error: 18456)

I searched on the internet two days with no luck.

Any idea?

Thanks in advance.

Theresa

 

[mrdenny]

What's the rest of the error message say?

What authentication mode is the SQL Server setup with?

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com