SQL Server and Permissions
I am new to this whole world of .Net and have what I am sure is a very basic question. I installed Visual Studio.net 2003 on my machine hosting the sql server locally. When I installed it the id on the machine I used had administrator permissions. In server explorer it seems that there was no default sql server setup so I registered an sql server instance which added the name under the sql servers in the tree. When I right clicked on the server name to add a new database I got the error Sql server does not exist or access denied. What am I doing wrong? Basically I want to have a server locally on this machine where I can have an sql database which will be accessed by my asp.net. Do I have to add permissions somewhere?
Any and all help is appreciated.