cannot connect using Enterprise Manager after moving tempdb

Posted on 2006-05-28
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

    Author Comment


    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

    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

    got you!

    Featured Post

    IT, Stop Being Called Into Every Meeting

    Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

    Join & Write a Comment

    I recently came across an interesting Question In EE ( and was puzzled about how to achieve that using SSIS out of the box tasks, which was i…
    In this article—a derivative of my blog post (—I will explore a few different perspectives on which week today's date falls within using Microsoft SQL Server. First, to frame this stu…
    Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.
    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

    734 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

    Need Help in Real-Time?

    Connect with top rated Experts

    24 Experts available now in Live!

    Get 1:1 Help Now