Help needed with SQL Server.

Hi,
Whenever i try to connect to my localhost i get an error message telling me that it doesn't exist or access is denied ... This is strange because i had no problems with it up until yesterday ... I can't connect to my Localhost through SQL Server Service Manager ... When i go into Enteprise Manager i can't open localhost or view anything in it ... It just keeps telling me that it doesn't exist or access is denied ...
Thanks,
Jack.Try (local). Localhost is IIS|||I have tried local and that doesn't work . any ideas??

Help Needed in Calculating results

Hello everyone,
I have a table which has some values and strings, I want to calculate the
values but whenever I use the following in a textbox in a SSRS it gives me a
# Error
=Sum(iif(Fields!XNB.Value >= 8000,1,0))
Which is obvious as there is a string that the function cannot calculate the
string. IS there an alternative to calculating the results when String is
involved.
RegardsGot the answer Use the following and it worked :)
=Sum(iif(Val(Fields!XNB.Value) >= 8000,1,0))
"claton" wrote:
> Hello everyone,
> I have a table which has some values and strings, I want to calculate the
> values but whenever I use the following in a textbox in a SSRS it gives me a
> # Error
> =Sum(iif(Fields!XNB.Value >= 8000,1,0))
> Which is obvious as there is a string that the function cannot calculate the
> string. IS there an alternative to calculating the results when String is
> involved.
> Regards