Today I needed to connect to a remote SQL Server as a co-worker was getting an error when she tried to connect with SSMS to our databases on that server. As she was using RDC to connect to the server and using the local SSMS to attempt to connect to the databases, I tried using SSMS from my local system to connect directly to the SQL Server 2008 R2 on the Windows 2008 Server. I got the following error.
The problem ended up being a lack of space of the C:\ drive on the actual server. No where did we see that space was an issue. However, in the future, when I get an error like the above I will go back and check the space no the server.
This blog is a collection of hints, issues, and notes that I have encountered on my journey as a software developer. As I've now transitioned into that "Dinosaur" phase as a software developer (40+) I find I need to write things down or refer to things way more often than I used to. This site is my ad-hoc collection of database (Oracle/SQL Server) and application development (.NET, PL/SQL, TSQL) topics. Hopefully it will help someone find a solution to something their working on.
Thursday, December 19, 2013
Could NOT open SSMS to connect to SQL Server - Problem was a lack of space on server
Subscribe to:
Post Comments (Atom)

No comments:
Post a Comment