Using SQL Server over Express

ewingf · May 12th, 2010, 10:52 AM

Hello All,

I'm sort of new to this, so please bare with me. I am working through the examples in Professional C# 4 and .NET 4 and have run into a snag in chapter 41, subtitle Sucurity. I am using SQL Server 2008 and the artical is using express. I bring up WebSite ASP.NET Configuration tool and mouse the Security tab. The error message that I get back is that it can not find the server. Is the fact that I am not using Express causing the problem and If it is, is there a book that you can recamend that can walk me through the security process using SQL Server?

Thanks for any help that you can provide.

ChristianNagel · September 30th, 2010, 05:25 PM

With SQL Server 2008 you first have to create the ASP.NET database and configure the connection string to reference this database:
1) in the directory of the .NET runtime you can find the tool aspnet_regsql. Starting this tool without options starts a wizard that you can use to create the ASP.NET database.
2) the database created in step 1 needs to be referenced from the membership and roles providers. You can change the LocalSqlServer connection string in the machine.config configuration file, so this change is active for all your applictations using a provider that makes use of this connection string. The default setting of LocalSqlServer makes use of a SQL Server Express database that is dynamicyally created if it doesn't exist.