I've never seen it either. I did confirm beforehand though that all instances were started and running.

AHHH I figured it out.

I went into Config Manager and checked the TCP/IP port. All of my instances (included the 08) had dynamic ports except the third 05 instance. I...

I was able to figure this out on my own. The problem was that I should have taken out the TCP port (1433) and added in a dynamic port.

Works now.

Exactly the answer I was looking for. Thanks for explaining (and the fast reply). That helps a lot.

What if you have a DB that is in 2005 (90) compatibility level on a 2008 server?

Can you then back up the 2005 DB and restore it on a...

I am having the same problem as well. I can't find any resources on how to import usernames and passwords into that aspnet_membership table.

I recently became a DBA and the one thing I learned very quickly is to use forums (like this wonderful one). I spend a lot of my day reading, researching,...

How about your maintenance plans, how many days do they back up? Can you move some of your backups to another server?

How about creating and SSIS package to move some...

use this script to fix your orphaned users. It helped me so many times.

EXEC sp_change_users_login ‘Auto_Fix’, ‘UserName‘

Hello,

I recently was given the task as the 1st DBA at my company. It it one of those situations where I have the HUGE task of cleaning up after the...

As a new DBA, I think this article is great. Looking forward to the next section.