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|aspn etdb.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|aspn etdb.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