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

[rmiao]

Did you enter correct password?

[theresatan]

Yes, I tried many times.

Theresa

[rmiao]

Double checked sql instance and the loginis there? Which tool did you use to connect to sql?

[theresatan]

Finally I found the sa successful login was feigned, though instance name is 2005. But in fact it pointed to 2000 instance in the same server. Because both instances have the same sa pw, but new test user only exist in 2005 instance.

Anything I need to do to make a connection to remote SQL server in different domain?

I alreary enabled local and remote connections.

The network person told me that the 1433 port is open.

Thank you very much for your following up.

Theresa

[rmiao]

Each instance has its own port number, double check sql2k5 instance's port number in sql server configuration manager. To connect to named instance, have to reference it like host_name\instance_name.

[theresatan]

I use dynamic port - TCP/IP dynamic port = 0

Is it necessary use static TCP port ?

I did use host_name\instance_name.

Thanks!

Theresa

[rmiao]

You can find real port number in configuration manager, and can set static port number with it. If there is firewall, need open that port too.