Thanks very much folks for your warm-heartedness!

GilaMonster (1/14/2010)

---

I don't think that can be done at all. When restoring filegroups, the primary filegroup must match the primary where the backup was taken from (ie they must be...

Thanks very much, guys!

Hello guys

Till now, I almost give up. I've tried probably everything that I can, using IP address directly for connection, make sure that my domain admin account is also in...

Hello Animal Magic

I did try services.msc and connect it to the server and all start, stop and restart options are there for MSSQLSERVER service.

And the windows account I used for...

I really don't want this thread sink in vain like all others that I can find from Google.

I used the 'sa' account and SQL Server authentication to connection from my...

'sa' is used for sql authentication. I assume this should have the highest privilege of all.

Yes, I do want the grayed out function to be available again.

Bru Medishetty (11/26/2009)

---

I have seen this when working with SSMS and connecting to SQL 2000 Servers mostly, with other...

The workstation I used to connection to the SQL Server is in the same LAN in the same domain. I actually tried both windows account and the 'sa' account, either...

SQL Server Browser service is running.

I've tried to disconnect and connect object explore and restart the SSMS several times already, nothing works.

Thanks very much for your advice, Carolyn.

I've just located the cause of the problem, it is that in SQL Server Configuration Manager, TCP/IP protocol for SQL Server Network Configuration...

Just did the sp_configure, it is set to 1.

remote access(name)0(minimum)1(maximum)1(config_value)1(run_value)

GilaMonster (9/3/2009)

---

Was the server restarted?

Typically this happens when the server is shut down suddenly, SQL doesn't have time to close the databases cleanly so they have to go through restart-recovery...

george sibbald (9/2/2009)

---

xnleiden (9/2/2009)

---

I just had a...