problem with iis7 and SQL

Question

problem with iis7 and SQL

amon 68987

SSC Rookie

Points: 27
More actions
January 3, 2010 at 1:57 pm

#143862

hi
i build a web application with local sql database and linq to sql in visual studio 2008.
i configure my application in my iis 7 with windows 7 and SQL 2005.
the problem is when the application run, the first page is authentication page with the database, when i entered my user name and password
i getting an error message "Generating user instances in SQL Server is disabled. Use sp_configure 'user instances enabled' to generate user instances."
someone can please help me?

Viewing 10 posts - 1 through 10 (of 10 total)

You must be logged in to reply to this topic. Login to reply

Gift Peddie SSC Guru Points: 73570 More actions · Answer 1

amon 68987 (1/3/2010)
hi
i build a web application with local sql database and linq to sql in visual studio 2008.
i configure my application in my iis 7 with windows 7 and SQL 2005.
the problem is when the application run, the first page is authentication page with the database, when i entered my user name and password
i getting an error message "Generating user instances in SQL Server is disabled. Use sp_configure 'user instances enabled' to generate user instances."
someone can please help me?

Windows 7 is IIS 7.5 not IIS 7 in IIS 7.5 click on features view of your application and click on connection string you may see two connection strings remove SQL Server Express connection string added by VS2008. and refresh. If you are a web developer you need to spend time with applicationhost.config file in system 32.

Kind regards,
Gift Peddie

amon 68987 SSC Rookie Points: 27 More actions · Answer 2

hi, thanks alot for the reply

you right, there are two DB and i remove the SQL from the list and i left my web application DB, i refresh and i still recieve the same messege.

there is another thing that you can suggest me?

Gift Peddie SSC Guru Points: 73570 More actions · Answer 3

amon 68987 (1/3/2010)
hi, thanks alot for the reply
you right, there are two DB and i remove the SQL from the list and i left my web application DB, i refresh and i still recieve the same messege.
there is another thing that you can suggest me?

Then you need to check your Web.Config to make sure your database definition and Connection String is not pointing to SQL Server Express and UserInstance because you can only use userInstance in SQL Server Express.

Kind regards,
Gift Peddie

amon 68987 SSC Rookie Points: 27 More actions · Answer 4

hi, my database name that i created with visual studio is "MsnDB", and this is my connection string in web.config:

<add name="MsnDBConnectionString" connectionString="Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\MsnDB.mdf;Integrated Security=True;User Instance=True"

providerName="System.Data.SqlClient" />

</connectionStrings>

now, what exacly i should do?

appriciated your help

Gift Peddie SSC Guru Points: 73570 More actions · Answer 5

amon 68987 (1/4/2010)
hi, my database name that i created with visual studio is "MsnDB", and this is my connection string in web.config:
<connectionStrings>
<remove name="LocalSqlServer"/>
<add name="MsnDBConnectionString" connectionString="Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\MsnDB.mdf;Integrated Security=True;User Instance=True"
providerName="System.Data.SqlClient" />
</connectionStrings>
now, what exacly i should do?
appriciated your help

The question is why? the reason the above is a valid connection string for SQL Server Express with UserInstance if you are not running SQL Server Express post again so I can give you a valid connection string. The other option you could create one at the top of VS2008 create a connection and copy the connection string that is the connection to your database.

Kind regards,
Gift Peddie

amon 68987 SSC Rookie Points: 27 More actions · Answer 6

no i don't, i installed the SQL server only for solution but i gonna uninstall the SQL.

so now i onlt with my visual studio and iis.

Gift Peddie SSC Guru Points: 73570 More actions · Answer 7

amon 68987 (1/4/2010)
no i don't, i installed the SQL server only for solution but i gonna uninstall the SQL.
so now i onlt with my visual studio and iis.

Please explain because Visual Studio generally adds SQL Server Express during installation there is no reason to remove it just remove the connection string and add the one you manually created.

Kind regards,
Gift Peddie

amon 68987 SSC Rookie Points: 27 More actions · Answer 8

ok, i mean that in additional to visual studio installation, i install SQL server express 2005 because i wanted to resolve my problem.

now, i uninstalled SQL server express 2005 and there's only the components that install with visual studio.

i hope that i was clear anough

Gift Peddie SSC Guru Points: 73570 More actions · Answer 9

amon 68987 (1/4/2010)
ok, i mean that in additional to visual studio installation, i install SQL server express 2005 because i wanted to resolve my problem.
now, i uninstalled SQL server express 2005 and there's only the components that install with visual studio.
i hope that i was clear anough

So what version edition of SQL Server 2005 are you connecting to in your application?

Kind regards,
Gift Peddie