Setup SQL Server for asp.NET 1

[jcsawyer]

Hi. I've recently set up a Small Business Server 2008 machine for my home network which is running websites for my business. I have reached a problem however.
I need to use a SQL database for data storage, obviously, on my websites. I assume I need to create a SQL server? Because when I go to add a new data connection within Visual Studio, there are no servers avaliable to choose from. On the server, there is SBSMONITORING, but I don't really want to use that, or do I?
Any help would be much appreciated!

Thanks,
Joseph Sawyer.

 

[ShackDaddy]

You could set up additional databases within the SBSMONITORING instance. Remember that since it uses SQL 2005, you may be limited to a 4gb database. But I've done this before: I've even used the SBSMONITORING instance for the Blackberry Enterprise Server database location before without any issues.

Dave Shackelford
ThirdTier.net
TrainSignal.com

 

[jcsawyer]

But I cannot find the SQL server in the server list on Visual Studio's server explorer? Am I doing something wrong?

 

[ShackDaddy]

The SQL Browser service needs to be running. And that assumes that the proper protocols have been set with Surface Configuration tool.

If you download the SQL 2012 Management Studio you can manage any prior version of SQL.

Dave Shackelford
ThirdTier.net
TrainSignal.com

 

[jcsawyer]

That did it, thanks!
But now when I use aspnet_regsql to create a new database it says something about permissions to create a database.

 

[ShackDaddy]

At this point I would use SQL Management Studio to add rights for whatever account needs to have admin access on that SQL instance.

Dave Shackelford
ThirdTier.net
TrainSignal.com