ASP.NET wont work with otherdatabase than SQLSERVER EXPRESS 2005

I have SQL 2005 developer eedition of SQL server and have a lot of problems because of that.
A lot of features won't work, for example, if I choose App_data folder - add new item and select sqlDatabase I get the following error:

Connections to SQL Server files (*.mdf) require SQL Server Express 2005 to function properly. Please verify the instalation of the component or download
from the URL:http://go.microsoft.com/fwlink/?LinkId=49251

The reason is that LocalSqlServer is defined in machine config file and also on some other places as sql express 2005. How can I change that?

I tried everything but with no success.

Does anybody know how to work with ASP.NET 2.0 and SQL developer version 2005 instead of express edition?

Thanks,S

Follow the steps in this thread and post again if you still need help.

http://forums.asp.net/1231958/ShowPost.aspx

|||

Hello. I have the exact same problem, and I can't solve it doing what you sugested on the other thread...

What do you mean by adding a blank Database? Just create a new database with any name, and leave it there?

And what do you mean by "To connect go to VS and click to datalink property and you should be able to connect."? Where is this datalink property? Thanks in advance :)

|||

Yes create a database and the datalink property is at the top of VS2003/5 or you can just use Northwind or Pubs the sample databases in SQL Server. Hope this helps.

|||

It won't work.

The procedure is:

first open aspnet_regsql tool and database with the name:aspnetdb will be created automatically on the server which you sprecify. For now, everything is ok. This database is needed by asp.net for profiles, web parts,... and account which asp.net is running at, should be the owner of that database(I think).

Then you must change the localSqlServer connection string which is defined in ASP.Net configuration settings. Default is:

data source=.\SQLEXPRESS;Integrated Security=SSPI;AttachDBFilename=|DataDirectory|aspnetdb.mdf;User Instance=true

I change it to:

Data Source=./NL-SI-1049;Initial Catalog=aspnetdb;Integrated Security=SSPI;

Now I get the following error message:

An error has occurred while establishing a connectiontothe server. When connectingto SQL Server 2005, this failure may be caused bythe fact that underthe default settings SQL Serverdoesnot allow remote connections. (provider: Named Pipes Provider, error: 40 - Couldnot open a connectionto SQL Server)

Well, my setting allowsremote connections, so that can't be the reason. I have enabled it on both TCP/IP and named pipes and I also restart server after enabling them.

I belive, that this has something to do with "User Instance=true" but not shure.

Anybody know how to set ASP.NET2.0 to work with other server than sqlexpress?
It drives me crazy. I'm looking everywhere but I can't find the solution.

I have already installed sql2000 desktop edition and sql2005 developer edition and I don't want't to install also SQL2005 express just because of ASP.NET2.0. It's nonsense.

Regards,S

|||When I got the remote error it was related to SQL Server service in SQL Server 2000 off, so check all your SQL Server service. And I don't think you need SQL Server Express when you are running the developer edition. Hope this helps.