Looks like it could be this issue:

http://support.microsoft.com/kb/954669

For those of us who cannot restart the sql service to make this happen here is how I got this done:

Detatch database

Move files to new folder which you will...

AndrewSQLDBA (9/9/2008)

---

Handle what?

That is not that odd. Sometime you have to have connection string accounts like that.

It is much better to use Active Directory account, but I like using SQL...

So I haven't done this, but I imagine you could set up a directories like these:

d:\SqlInstances\InstanceN\Data

d:\SqlInstances\InstanceN\Logs

d:\SqlInstances\InstanceN\System

d:\SqlInstances\InstanceN\Install

Then create mount points in each one that point to your actual san devices -...

http://support.microsoft.com/kb/280297

In the security tab, find your login and look at user mapping. Make sure you have rights for the database you are trying to get to.

Since it...

DB Mail needs these three pre requisites:

Enabled in sql SAC

Service borker enabled in the msdb

SQL Server service account needs access to SMTP if it requires auth

But you've probably checked all...

Do you need to enable anonymous access in IIS?

The job runs fine for YOU, but not for the account that is running the job. This should be whatever account is running sqlagent.

Sometimes I'll log on...

Maybe this helps?

http://chopeen.blogspot.com/2006/09/remote-query-timeout.html

It is not a good procedure to expose your SQL server to the internet. If you are doing so, it would be a good idea to have a firewall...

Chandu (8/27/2008)

---

I am doing an unattended installation of 3 instances (APP1, APP2, APP3) of SQL 2005. Each instance should be assigned a different collation value (say col1, col2, col3). How...

I logged into the server this morning, and everything seems to be running ok. In other words, SQL server queries are running fast, and RDC is running at normal speed...

7168MB / 1024 = 7GB

You should have at least 1GB for the OS. Gila...

You can have 2 different instances - but not 2008 I think.