CODEWITHSUNDEEP
asp.netsql-servervb.netvisual-studio-2010
Emad-ud-deen
Emad-ud-deen

Reputation: 4864

Server Error in '/' Application

I'm learning ASP.Net and attempted to create a default ASP.Net project in VS2010 for the first time using VB.Net for the programming language.

After running the ASP.Net project, a default web page was displayed in a browser window. I tried to click on the LogIn link on the displayed web page and this error is displayed:

The user instance login flag is not supported on this version of SQL Server

We are using SQL Server 2012 Enterprise. We also have IIS7 installed in Window7. We have SQL Server, Visual Studio 2010 and IIS7 installed on the same computer.

I'm assuming a new database needs to be created but I don't know the details on what this database looks like or if there is a script that can be run that creates it.

All help will be appreciated.

Upvotes: 0

Views: 238

Answers (2)

Emad-ud-deen
Emad-ud-deen

Reputation: 4864

Found out how to do it.

I changed the connection string to look like this:

connectionString="data source=.\SQLSERVER; Initial Catalog=aspnetdb;Integrated Security=True;"

The problem was being caused by:

AttachDBFilename=

It threw me off because I was assuming VS2010 would create the correct connection string.

Upvotes: 1

vcsjones
vcsjones

Reputation: 141588

The connection string for that application probably has User Instance=true set, which is only valid for SQL Server Express. You should remove that part from the connection string.

SQL Server 2012 no longer has user instances, instead opting for LocalDB.

Upvotes: 1

Related Questions