[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now


cannot connect using Enterprise Manager after moving tempdb

Posted on 2006-05-28
Medium Priority
Last Modified: 2013-12-03

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

ALTER DATABASE tempdb MODIFY FILE (NAME = tempdev, FILENAME = 'E:\tempdb.mdf')

ALTER DATABASE tempdb MODIFY FILE (NAME = templog, FILENAME = 'E:\templog.ldf')
Question by:sdc248
  • 2

Author Comment

ID: 16781112

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.
LVL 13

Accepted Solution

MikeWalsh earned 1000 total points
ID: 16781318
Sometimes you can have latency when trying to expand your servers in Enterprise Manager. You may need to attempt to connect multiple times depending on various issues with the network.

Author Comment

ID: 16792239
got you!

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I have a large data set and a SSIS package. How can I load this file in multi threading?
One of the most important things in an application is the query performance. This article intends to give you good tips to improve the performance of your queries.
Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.
Suggested Courses

873 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question