Tuesday, May 12, 2015

ASP.NET - Login failed for user 'DOMAIN\MACHINENAME$'

To avoid below error,
System.Data.SqlClient.SqlException: Login failed for user 'DOMAIN\MACHINENAME$'.

1. Try to prepare proper SQL connection string as

Initial Catalog=your_db_schema;
Integrated Security=False;
User ID=your_db_login; Password=??????" 
providerName="System.Data.SqlClient"/>

2. Remove Persist Security Info=True;

3. Other resolution:
In SQL Management Studio create an account for "DOMAIN\MACHINENAME" (do not browse for the account name, type it in manually) and then grant this account db_owner access to the SLAD database. After this, reinstall the product.

1 comment:

Venkat Shanthi said...



It is useful to learn how to set and reset a error.Thank you author for posting this kind of error.

http://www.wikitechy.com/fix-error/login-failed-for-user


Both are really good.
Cheers,
Venkat