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