Okay... That makes sense... The following question is inevitable, how do I get the login back?

Or do I have no choice but to reinstall the server?

It is running on Windows 2000, SP4. No changes have been made to the server. It was working fine till this sudden change.

First window of Query Analyzer asked for sql server. I put in IP address, checked Start SQL Server if it is stopped, and through windows authentication I got the message:

Unable...

How do I check the credentials?

If I try to edit the SQL registration properties I get a response saying that it couldn't connect.

Where do I look to see if it's...

Moreno,

Being a complete newbie I don't know how to register the server in EM with FQDN.

I did ping the server with IP address and with its name and in both...

The server is local, and I've restarted the server a few times with no difference in the situation.

I only try and connect to it via its IP address, I am...

Thank you

Is there a list of available default values for every data type, which I can look up? And also the convert function...

Thank you!

May I trouble you again and ask what default values I can use for TIME?

I have two columns, one for the current date and the other for the current...

I realized that the problem isn't update and insert but that the display message for ALL errors is the same message.

So my next question is, what changes do I do...

I have changed the permissions to the tables I am using, allowing select, insert, update, delete.

What recommended changes do you think I should try in IIS to try and fix the problem?

I...