SQL express vs SQL developer

[simonZ]

I instal visual studio 2005 without express edition of SQL server. I had
instal developer edition before.

In the web.config it had this connection string:

<add name="LocalSqlS erver" connectionStrin g="Data
Source=.\SQLExp ress;Integrated Security=True;U ser
Instance=True;A ttachDBFilename =|DataDirectory |aspnetdb.mdf" />

Since my SQL Server 2005 Developer Edition instance is named SQL2005 I
changed this to:

<add name="LocalSqlS erver" connectionStrin g="Data
Source=.\SQL200 5;Integrated Security=True;U ser
Instance=True;A ttachDBFilename =|DataDirectory |aspnetdb.mdf" />
When trying to run the ASP.NET application, I got this exception:

[SqlException (0x80131904): The user instance login flag is not supported on
this version of SQL Server. The connection will be closed.]

And there is a lot of other problems because I don't have express edition of
SQL server.

What can I do to make things work? Any idea?

regards,S

[KBuser]

www.connectionstrings.com

Delete that string, I don't even think that first one is valid...

[simonZ]

Hi, KBuser,

thanks for your answer.

What you mean with: "delete this string" ?

ASP.NET I belive needs it's own database for web parts, data components,....
and I should create database mydbfile.mdf.

You can create this database with aspnet_regsql.e xe tool (by default it is
created if you install sqlexpress together with visual studio).

In www.connectionstrings.com there is only string for sql express:

"Server=.\SQLEx press;AttachDbF ilename=c:\asd\ qwe\mydbfile.md f;Database=dbna me;Database=dbn ame;Trusted_Con nection=Yes;"
- or -
"Server=.\SQLEx press;AttachDbF ilename=|DataDi rectory|mydbfil e.mdf;Database= dbname;Trusted_ Connection=Yes; "
(use |DataDirectory| when your database file resides in the data
directory)

I can't found it for sql developer edition.

If I just delete it from ASP.NET configuration file, will everything work?

Best regards from Slovenia,
Simon
"KBuser" <Ky********@gma il.com> wrote in message
news:11******** **************@ u72g2000cwu.goo glegroups.com.. .

www.connectionstrings.com

Delete that string, I don't even think that first one is valid...