It turns out the firewall on the windows server is turned on.

We turn it off, now it works.

I checked earlier for the windows firewall is says the service is not...

Thank you very much.

It turns out the firewall is turned on. Now we turn it off, it works now.

I checked that before it said the service was not running.

But for...

Thank you very much.

It turns out the firewall is turned on. Now we turn it off, it works now.

I checked that before it said the service was not running.

But for...

By typing the command, I can see

there are lines like this:

our ip address:1433 Establlished.

I tried Ip address and also fully qualified name, I got the same error message.

How can I check if the port open or not?

I checked in sql log, I cannot...

I can see from surface area configuration. the locall and remote connections and using tcp/IP only is selected.

I can ping the sql server.

When I say in previous message I cannot connect to the sql server remotely, I mean from Sql Management studio to connect to the...

Thank you.

I can see in the original server we only have one ldf file for that database, it is called mydb.ldf. we never deleted or added before.

But on the new...

It's not logical name.

What I mean is the physical file name.

Thanks a lot. The information you provided is very helpful.

I was desparated, and ended up searching all the sql server registry key and removed them.

Then did another install, it works...

Thank you.

I see there is a key folder called legacy_report server, which include the devicedesc subkey with value something like ms sql reporting service mssqlserver. This key cannot be deleted.

Is...

That sounds very complicated.

Is there a registry key I can remove for report server that stores the instance name?