Trouble with MSDE and VS.NET

Hello all,

I'm just starting out with VS.net after a long break, and trying to create a new SQL Server database with it while using MSDE on my machine.

The server explorer shows my MSDE engine fine, I right click on the server in the server explorer, select New Database, up pops the box, I select use Windows NT Authentication, give it a name, and I get:

ADO Error: '

Could not obtain exclusive lock on database 'MODEL'. Retry the operation later.

CREATE DATABASE failed. Some file names listed could not be created. Check previous errors.'


I'll admit, when I installed MSDE, I was unsure if I was doing it right, but the SQL Service Manager shows up when I boot up, and lists the "TEST1" server I created.

Anyone got a clue what I am doing wrong?

Thanks in advance.

There could be a couple reasons for this:

This error can occur if there is a user in the model database. Run sp_who to determine what connections are using model, then close the connections. Restart and see if this helps.