Msg 18456 - login failure - sql server

Hell,

My ISP has just given me the username and passwords to connect to my sql server site.

However after setting up the ip and tcp and 1433 in the client network utility and trying to connect to the site via the query analyzer (and later EM) I am getting this wierd message:

Msg 18456, level 16...Login failure Sql Server not found...

Not I am almost absolutely sure the login username and password is correct; I have tcp/ip enabled and I am not behind a firewall.

Anyone got some ideas?

Much appreciated. If you have the silver answer could you please email me at jason@.silverscape.co.za - awesome.

JasonHow are you connecting to the server, with a name (ie ISP_Server) or with and IP address (ie. 111.111.111.111)?
[list=a]
Using the SQL Server Client Netwrork Utility verify that TCP/IP is enabled
If connecting with a name, can you PING the name from DOS? If not can you ping the IP address?
If you can ping the IP address, but not the name, add an alias using SQL Client Network Utility
[/list=a]|||Hi... thanks for quick reply and advice...

Okay:

1. The ISP provided me with an alias/name rather than a IP.
2. I tried pinging the name and had no problem...
3. I copied the IP address from the ping and replaced the name in the Client Network Utility...
4. I made sure TCP/IP was enabled...
5. Tried connecting through the SQL Query analzyer...

But got the same damn error message: "Unable to connect to server...Msg 18456, Level 16, State 1...Login failure

Got anymore ideas. The address is pingable; TCP/IP is enabled; I appear to have the right login details....what now?

Very wierd..
Jason - Cape Town

MSDTC - The Microsoft Clustering Service failed restore a registry

Cluster active-active.
The node B was reinstalled after a hardware failure.
Now the node B is ok. The failover is ok, except because I receive the
message"The Microsoft Clustering Service failed restore a registry key for
resource SQL Server " when I move the Instance B from Node A to Node B.
How can I install MSDTC without affect the Node A (without unistall msdtc
from this node) ?
Node A - Instance A (msdtc resource is online)
thanks for your help.
You don't install DTC, it is already on the machine. It is part of the OS.
You just configure the resource into the cluster. All you should have to do
is edit the properties of the DTC resource and add NodeB as a possible
owner.
Mike
http://www.solidqualitylearning.com
Disclaimer: This communication is an original work and represents my sole
views on the subject. It does not represent the views of any other person
or entity either by inference or direct reference.
"Shima" <Shima@.discussions.microsoft.com> wrote in message
news:F5B0FAB8-C20C-4009-96A9-98AB79D5D965@.microsoft.com...
> Cluster active-active.
> The node B was reinstalled after a hardware failure.
> Now the node B is ok. The failover is ok, except because I receive the
> message"The Microsoft Clustering Service failed restore a registry key for
> resource SQL Server " when I move the Instance B from Node A to Node B.
> How can I install MSDTC without affect the Node A (without unistall msdtc
> from this node) ?
> Node A - Instance A (msdtc resource is online)
> thanks for your help.