Running out of disk space

As this whole thing is actually meant for testing WSS (Windows Sharepoint Services) was installed with default settings. Never figured if I would use it longer, but after seeing decided it should replace the previous portal. However a default installation dumps the database files onto the system volume with all the consequences that go with it. In my case the system volume is tiny and as such I normally move data quite fast towards the data drive in order to protect the amount of diskspace on the system volume, however this program didn’t give an option to install the databases somewhere else. If you start looking on the web you see a lot of stories that will tell you how to do it, most of them being run through a command prompt application. If those would work I would have used them but for some reason or another they all ended in an error and as such that rendered them useless. In the end the move was very simple with only downloading one tool which was SQL Server Management Studio Express. After installing this tool you can connect to the database with the same servername as the command line tools did: \\.\pipe\mssql$microsoft##ssee\sql\query and then you can simply detach the databases, move them towards another drive and attach them again. Job was done in ten minutes. What more do you want? Do not use the default selections for this tool, you will end up with the same error as the command line tools did. This error says something like : An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 – Error Locating Server/Instance Specified) (Microsoft SQL Server, Error: -1). Good luck with the solution above anyway…