I've installed SQL 2005SP2 on local drives. I've also installed snapdrive 6.0.1 and snapmanager for SQL 2.1.1. The goal is to migrate the SQL databases/logs to the Netapp snapdrive procured luns.
I've gone through the initial configuration wizard to map everything to the luns. When I get to the end and click finish I get an error:
SnapManager detected that the following databases are currently in use. Prior to relocating a SQL server database, the database must not have any users connected to it.
The environment I set up was for test purposes. The same box has SQL2005, snapdrive, snapmanager sql installed. There are no users connected. The application that is installed in Sharepoint server 2007, but nobody is using it - it's a test environment.
Why am I getting this error when clearly nobody is connected? I even rebooted the server and re-ran everything and got the same error.
How do I go into SQL and disconnect all users from the databases. I'm not a SQL person so please list exact steps.