Hi

I have a typical vs2005/sqlexpress2005/sqlserver2005 setup. I am using the
following connection string;

<add name="Membership" connectionString="Data Source=.\SQLEXPRESS;Integrated
Security=True;User
Instance=True;AttachDBFilename=|DataDirectory|aspnetdb.mdf"/>

with sqlexpress 2005 and it works fine. Now I have run the aspnet_regsql.exe
tool to create the aspnetdb db against the sql server 2005 (default
server?). When I switch the above the string to the following;

<add name="Membership" connectionString="Data Source=.\;Integrated
Security=True;User
Instance=True;AttachDBFilename=|DataDirectory|aspnetdb.mdf"/>

to connect to the sql server 2005 I get the following error;

System.Data.SqlClient.SqlException: The user instance login flag is not
supported on this version of SQL Server. The connection will be closed.

What is the problem and how can I fix it?

Thanks

Regards

Just leave the "\" from the data source.

HTH, jens Suessmeyer.

Using this now;

<add name="Membership" connectionString="Data Source=.;Integrated
Security=True;User
Instance=True;AttachDBFilename=|DataDirectory|aspnetdb.mdf"/>

Still getting the error;

System.Data.SqlClient.SqlException: The user instance login flag is not
supported on this version of SQL Server. The connection will be closed.

Show quoteHide quote

Funny Error
Session Question
start ASP net from very scratch
ConnectionStrings in ASP.NET 2.0?
help please on GridView commands + AutoEventWireUp, firing twice etc...