I just installed C# Express on my Vista machine, and it included SQL 2005 Express. I installed that as well and downloaded the SQL SP2, and all the other SQL updates available.

No matter what I do I can't access SQL Server. Every time I try to create a database or do anything inside Management Studio I get an error saying that permission is denied for user on master, or something similar. It doesn't make since because I'm not even trying to access the master database I'm trying to create a new database.

I tried giving myself permissions to create databases and modifiying and logging in on the sa user but no matter what I do I get the same error message.

I guess that SQL 2005 is not compatible with Vista, is the only thing I can think of.

I don't know how to do any configuration settings with SQL, so its just the standard install. If there is something I need to do to hack SQL/Vista, please let me know the steps so I can get back to creating my database.

I also tried installing the VS2005 Vista Patch or what ever it was I got from MS website, but when I tried to install that it gave me an error saying I don't have VS installed. That doesn't make any since either because C# express is up and running like it should be. I know its installed.

Thanks.