Monday, February 20, 2012

Registered Servers are unavailable

So I've had some issues upgrading to SQL Server Mgmt Studio Dev from Express. I finally got everything upgraded / installed and I see the instances that I was using with Express in my Registered Servers window but I can't connect to any of them. After looking in my Microsoft SQL Server directory I noticed that there are no MSSQL.# folders. How can I recreate these or create a new instance on my local machine?

Hi,

Do you mean that you want to import the SQLExpress database intoSQL Server management Stuido Expresswhich provides a graphical management tool for SQL Server 2005 Express Edition (SQL Server Express).? If so, you can use "aspnet_regsql" tool and try again, the tool exists in DiskRoot:\WINDOWS\Microsoft.NET\Framework\versionEdtion\.

Thanks.

No comments:

Post a Comment