Upgrade to SQL Server 2012 Express causes Login failed error

nobody

SOLVED CLOSED ACTIVE ANSWERED
User: nobody
Posted: on Jul 31, 2012 04:45 AM
Forum: SQL Server
Replies: 10
Views: 8701

I have installed MS SQL Server 2012 Express with Advanced Services. I did not make any changes to my ASP.NET application, just restored a database from a backup. Before the SQL Express 2012 I was using SQL Express 2008 with no issues.

Since the SQL Express 2012 was installed, my application is not longer able to login to SQL. I use the same user and the same web.config setup. I receive "Login failed for user 'ASPNET_User'."

Any suggestions? Thank you.

Download FREE API for Word, Excel and PDF in ASP.Net

nobody

0 2

Reply
User: nobody
Replied: on Jul 31, 2012 06:08 AM
Modified: on Jul 31, 2012 07:33 AM
Report

<add name="EStoreConnectionString" connectionString="Data Source=RAPOPC\SQLEXPRESS;database=DobryCajCz;uid=ASPNET_User;pwd=xxxxxxxxx;" providerName="System.Data.SqlClient"/>

Tried also with localhost like this

<add name="EStoreConnectionString" connectionString="Data Source=localhost\SQLEXPRESS;database=DobryCajCz;uid=ASPNET_User;pwd=xxxxxxxxx ;" providerName="System.Data.SqlClient"/>

with no difference in behaviour.

I agree, here is the link: https://www.e-iceblue.com/Introduce/spire-office-for-net-free.html

Upgrade to SQL Server 2012 Express causes Login failed error

Company

Explore

Follow us

Contact Us