When I install the reporting service on serverA, and use the database on serverB,

What special admission I need to add for the database or the installation process will automatically add...

No body can connect to it.

It caused the server hang.

I wonder if this is windows problem or others.

But once I cannot connect to reporting service then the whole server...

The problem I can no longer connect to the reporting server on the local machine.

And I can no longer connect to the database server either on the local server.

Yes, we have iis installed on the server.

Thanks a lot

I cannot find error message in the sql error log.

I can only see it in the event viewer.

The error is in the previous message

Thank you.

I'm glad it can still be backed up on F drive. But still I feel strange why the administrators cannot access E:\program files\microsoft sql server\MsSql.1\mssql\backup

I thought administor account should...

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.