Asp.net 2.0 Vista Sql Express Error

I am developing a web site in asp.net 2.0 using visual studio 2005 and SQL express.

I tried to add a new Sql database using right click on the App_Data folder and adding the DB.

I get an error that the VS could not find a sql Express installed.

I want to clarify that I have installed the SQL express SP2 for vista version and that I can connect to SQL express db using management studio.

I think it is a vista issue probably that UA.

What can I do?

pls do not recommend the next step I already tried itL

If I create the DB on XP and transfer the project to my vista machine the db is there but I cannot connect to it.

Hi,

There are many side-effects with Vista. SQL Server Express will be supported with SP2 (which is not RTM yet) for Vista and Visual Studio won′t be supported after applying SP1 and additional hotfixes, So I guess its hard to help you here, sorry. Using Vista in that case for testing purposes would be ok as of my opinion but using it for productional developing would be too early for me.

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de|||

Hi Itzik,

FYI - VS 2005 is not certified on Vista yet, so this may well be a VS issue.

When you installed SQL Express SP2 did you check the option to create yourself as an administrator? If you did not, you would not have permission to create a database from anywhere. Any user on the computer has the ability to connect to SQL Express, but not necesarily create objects. Have you confirmed if you can create database using Management Studio? If you can't, you don't have the right permissions set.

Information on getting Express SP2 working on Vista is avaliable here.

Mike

|||

OK GUYS

First of all thanks for trying to help.

I decided to fought with it until I solve it.

Yes I did check the administrator button (but even if I am not I could always add myself to the sysadmin group manually, but it is a blessing change in SP2).

This is what went wrong if anybody else asks:

1. I installed the Sql express SP2 as default. The visual studio when adding a file db using SQL express is looking for the instance SQLEXPRESS ([computer name]\Sqlexpress is the full name).

2. I went to Tools and changed the instance name to blank as they ask me to in case of default installation. But that did not work fully (I could create the DB file but couldn't access it through the asp .net configuration pages).

3. So on that point I uninstalled the SQL express and installed it again under the required Sqlexpress (Shooting in the dark assuming the default is not supported under vista or something like that).

Amazingly it worked great. (I also installed it under local system rather than Network service so maybe this helps too).

Hope I saved some lost souls

Itzik Katzav