Don't your users log into the domain ? Don't your users computers use WINS and DNS as opposed to 'raw' IP addresses ? So the argument of not having a...

This is a "double post" ... http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=92&messageid=221521

Sent a private message. One question though 'hawg' ... does the binary translate to octal or hex ? (I want to know if I'm decoding it properly).

Yelena and SQLBill, you're both right (although it seems contradictory). The contradiction is in how your individual networks are configured to handle ICMP traffic (ping).

Since you are on Advanced Server I'm assuming you're on a cluster. But that might not be true. This is important since if you are clustered then the SQL Server...

I had to implement this fix on only 1 of 22 servers.

... 'religion' is still the answer ...

Just to clarify the ports ... TCP 1433 & UDP 1434 are needed at a minimum for SQL authentication. If you are going to use Windows Authentication with (ughh ...)...

Here's a couple of links about the trace flags:

http://support.microsoft.com/kb/315447

http://support.microsoft.com/default.aspx?scid=kb;en-us;906121&sd=rss&spid=2852

Both the SQL Server and SQL Agent startup accounts need to be domain user accounts with the proper 'rights'. I state this becaause I do not know what user context...

Be cautious of "niladic" functions (like db_name(), user_name(), object_name(), etc.) if they  being used in a stored procedures. They are "context" specific. In other words some of these functions will return...

Why would you not want to join the domain ?

I'd first talk to the network ?gods? about 'firewalls' and 'ports' before anything like trusted domains. If you're using SQL authentication then 'trusts' are just a wste of time and resources.

Noeld, we've actually had to perform a conversion in this manner just recently. A third party product chose by the user community (with no IS input at all !) caused...

Try updating MDAC (if you can afford the server reboot) to SP2. If that does not fix the issue than I'd take Yelenas advice to use profiler.