sdc248
asked on
cannot connect using Enterprise Manager after moving tempdb
Hi:
I execute the following command to move tempdb to the other drive. After I was done, I rebooted the server but found I could not extend the server node in the Enterprise Manager although the green arrow indicates it is running. The status bar shows: "Establishing connection to SQL Server and checking Windows security...". In windows Task manager, SQL Server enterprise Manager's status is "Not Responding." Please help!!
USE master
go
ALTER DATABASE tempdb MODIFY FILE (NAME = tempdev, FILENAME = 'E:\tempdb.mdf')
go
ALTER DATABASE tempdb MODIFY FILE (NAME = templog, FILENAME = 'E:\templog.ldf')
go
I execute the following command to move tempdb to the other drive. After I was done, I rebooted the server but found I could not extend the server node in the Enterprise Manager although the green arrow indicates it is running. The status bar shows: "Establishing connection to SQL Server and checking Windows security...". In windows Task manager, SQL Server enterprise Manager's status is "Not Responding." Please help!!
USE master
go
ALTER DATABASE tempdb MODIFY FILE (NAME = tempdev, FILENAME = 'E:\tempdb.mdf')
go
ALTER DATABASE tempdb MODIFY FILE (NAME = templog, FILENAME = 'E:\templog.ldf')
go
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
got you!
ASKER
Somehow the problem disapeared now. The system probably need some time to change the setting?
I'll keep this thread alive for a while until I am sure everything is back to normal. Thanks.