Ensure your listening ports are opened on firewall and as already indicated, you have enabled the listening protocols.

Thank you,

Phillip Cox

The Log Writer is responsible for writing to the transaction log file.

Can you provide more details regarding the performance issue? What behavior are users experiencing?

Have you tried monitoring using...

Have you checked your error log? This normally indicates a possible path problem to the database files.

Please do the following and post results:

use master

select databaseproperty(‘db_name’,'isShutdown’)

Check if your database files...

Hi,

Did you manage to get a solution, as I am having a similar problem. In terms of your issue, this was down to user profile retaining IE proxy settings...

NikB (5/12/2009)

---

I have an HP environment with an MSA1000 running Windows 2003 Ent 64 bit & SQL 2005.

The MSA is full but I have the option to replace some disks...

Hi David,

Thanks for clarification!

You should see a performance improvement, as the database and query engines have been further improved upon from SQL Server 2005.

As with any performance related questions, I...

djones (4/7/2009)

---

We are considering an upgrade from 2000 to 2008. My question is, if we set the compatibility level to 80 so that all our existing T-SQL still works will...

MK Morris (4/6/2009)

---

Could someone suggest a best practice for hotfixes?

I'm fairly new to administration and I'm looking at the following list trying to decide what we should be...

I agree with Ed, you should never truncate your transaction logs unless an extreme emergency.

More importantly, you need to understand why you have queued replication commands outstanding, as the problem...

Hi,

I assume you are using log shipping?

Hope this helps!

Phillip Cox

Hi,

Have you made sure "Lock Pages in Memory" setting has been configured for correct service account?

Thanks,

Phillip Cox

Hi,

Do yo have any other applications installed on server?

Thanks,

Phillip Cox

SQL Server Consultant

MCITP - SQL Server 2008|DBAdmin

MCITP - SQL Server 2005|DBAdmin

MCTS  - SQL Server 2008

MCTS  - SQL Server 2005

MCP    - SQL Server 2000

Codezilla (2/13/2009)

---

The sql server is a standard 64 bit edition. We have about 21G left of the drive now. The error log specifies that it is about 32 %...

richard.schulman (2/13/2009)

---

In trying to set up an ODBC connect on windows xp sp3 computer with sqlsrv 2000 getting that error. I'm using windows authentication via an AD group. One user...

Codezilla (2/13/2009)

---

Gail thanks for your reply. It currently is telling me that it has 10 hours to recover. But I am not sure if we could wait untill then. Could...