June 18, 2008 at 10:08 am
Hi everybody,
First post here, so I hope you can help me out. I'm attempting to learn .NET web development using Visual Studio 2008 Pro and SQL Server 2005 Developer Edition. When I get to the part where I try and setup the security of my web site by clicking on the Security tab in the Web Site Administration Tool in VS 2008, I get the following message:
There is a problem with your selected data store. This can be caused by an invalid server name or credentials, or by insufficient permission. It can also be caused by the role manager feature not being enabled. Click the button below to be redirected to a page where you can choose a new data store.
The following message may help in diagnosing the problem: Unable to connect to SQL Server database.
When I click on "the button below", I am taken to the Web Site Administration Tool Provider page. I then click on "Select a single provider for all site management data" and am taken to a page where one provider is shown, and it is called AspNetSqlProvider. When I click on Test, I get the following message:
Could not establish a connection to the database.
If you have not yet created the SQL Server database, exit the Web Site Administration tool, use the aspnet_regsql command-line utility to create and configure the database, and then return to this tool to set the provider.
I used aspnet_regsql and successfully created the database, went back to the Provider page using the Web Site Administration Tool, and clicked Test, but I received the same message as before.
I know people who are running SQL Server 2005 Express with Visual Web Developer 2008 are not having any problems with the Web Site Administration Tool, so I'm wondering if SQL Server 2005 Developer Edition will work in its place. If anyone can help me with this, it would be greatly appreciated.
Thanks in advance for all your feedback.
Mac
June 18, 2008 at 2:41 pm
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply