Hi,

a couple of weeks I became the proud owner of the Beta experience DVD's filled with a lot of stuf. I got a new laptop from my new employer and wanted to try out the new stuff because we're working already with the beta 2 pieces on our current assignment (winforms 2.0 in that case :-) ).

I installed SQL server 2005 that shipped and after that vs.net 2005 without the SQL server 2005 Express edition. I created a new website and wanted to try out the new administration tool for setting up everything for my security because I wanted to play with the new login controls.

It gave me some timeout errors (after a very short period of time) and I read about the aspnet_regsql.exe tool. Did fire that one up and the tool installed a new database called aspnetdb. Now when I hit the security tab I get the following error:

There is a problem with your selected data store. This can be caused by an invalid server name or credentials, or by insufficent permission. It can also be caused by the role manager features not being enabled. Click the button below to be redirected to a page where you can choose a new datastore.

The following message may help in diagnosing the problem: Unable to connect to SQL Server datbase.


After clicking the redirect button I come on the Provider tab where I can see that my current provider is AspNetSqlProvider. I click the first link and it gives me a new page where I can test my provider. After clicking the link Test it gives me Timeout error after about 8 - 10 seconds.

Is there something I did wrong or forgot to install or is the current Beta 2 unable to work with SQL server 2005?

Grz, Kris.

Hey,

When I used the beta 2 administration tool, it only allowed me to connect to SQL Server express.  Beta 1 connected to Access, SQL Express, and another database through a custom connection, but I think there may have been problems with those connection types for the provider framework, and were thus not ready in time.  At least I hope.

Hi Brian,

thanks for the information. Before installing SQL server 2005 I had SQL server 2005 Express installed but didn't use the aspnet_regsql.exe tool but didn't have any luck with that too. Did you have to use that tool in order to get things to work?

Grz, Kris.

Hello,

I don't remember needing aspnet_regsql utility for installation purposes...  I installed in order of SQL, VS.NET, and that worked fine for me.  I did get SQL express to install, but now I'm having problems connecting to it, for some reason.  I think at first I left out SQL express, but went back to install it when only SQL express was the only option for the provider framework (at least through the wizard).

I've used it (indirectly; through the web admin tool) to setup the provider, but I haven't used it for setup purposes; are you having problems with SQL because it says that you can't install with other instances of SQL on?  I've had that before; the SQL install is very particular.  In fact, because of some problems with previous releases, I have a separate machine that I reformatted and put the software on.  So I've installed from a clean install.

I don't know if this helps.

I guess it's still Beta :-). I was hoping for some more feedback from the guys at Microsoft themselves although I really appreciate your help Brian. I hope they fix this issue quickly.

Grz, Kris.

I deïnstalled everything and reïnstalled vs.net 2005 with the option of SQL server 2005 Express edition. When I create a new project based on the personal web starter kit I get the errors like described here.

If anyone knows how to deal with this, please let me know.

Grz, Kris.

I had similar experience.  I started with VS2005 which installed Sql2005 Express and it seemed working OK connecting to DB from the web admin tool.  I was excited about the Sql 2005 Standard edition June CTP and decided to uninstall everything and started with SQL 2005 Std.  Then I never could set up the connection to DB even after running the aspnet_regsql.exe. 

I posted the question to the Installation Message board before I read your postings.

Hope someone can have answers on this issue.

zweng1 wrote:

I posted the question to the Installation Message board before I read your postings. Hope someone can have answers on this issue.

Hi,

please when you post somewhere that you had a similar question and put it somewhere, also provide the link to that question so someone else can quickly view it by following the link. This keeps the forums consistent and doesn't create overhead for others when they want to take a look at your particular question (it can take a certain amount of time when you have to search for a question that you don't have a title from or something else that can significantly increase the search speed.

Grz, Kris.