I'm a SQL noob. Im trying to create forms based authentication in Sharepoint. There are tons of blogs talking about how to do this, but each time I try - I fail.
Let's take for example this blog:
Check the first two screen shots for what I'm trying to accomplish.
In my case, I have a Windows 2008 SBS box with SQL Express 2005 on it. Below are three screen shots. In screen shot #1, you can see i have three instances. I try to follow the steps from the blog (see screen shot #2). But I get the errors you see in screen shot #3. I can see that it talks about permission errors about adding stuff to master - but why? I'm logged in as an administrator and it's a brand new database and I should have full access to the instance called sharepoint.
Sharepint is a brand new instance. I created it about 30 minutes ago by running the SQL Server Express 2005 install and telling it to create a brand new instance. Given what I should be seeing and what I should be doing (and it seems like I'm doing it) - what am I missing?