Anthony_B
asked on
System.Data.SqlClient.SqlException: Login failed for user 'INBOUND47\ASPNET'
I have installed a copy of SQL Server 2005 on my local machine temporarily so we can re-configure our SQL server machine from acratch. I am trying to get it to run from other machines, but I am having problems. if I run my page from Web Developer Express, it works fine, but when I try to access it from the standard web browser using my machine name, it gives me
My web.config file looks like this:
I did do as one user suggested and add aspnet to my users, but that did not work.
Any and all help is appreciated.
System.Data.SqlClient.SqlException: Login failed for user 'INBOUND47\ASPNET'
[SqlException (0x80131904): Login failed for user 'INBOUND47\ASPNET'.]
System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +5009598
System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning() +234
System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) +2275
System.Data.SqlClient.SqlInternalConnectionTds.CompleteLogin(Boolean enlistOK) +35
System.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfo serverInfo, String newPassword, Boolean ignoreSniOpenTimeout, TimeoutTimer timeout, SqlConnection owningObject) +183
System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(ServerInfo serverInfo, String newPassword, Boolean redirectedUserInstance, SqlConnection owningObject, SqlConnectionString connectionOptions, TimeoutTimer timeout) +239
System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, TimeoutTimer timeout, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance) +195
System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance) +232
System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection) +185
System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options) +33
System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject) +524
System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject) +66
System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) +479
System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) +108
System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) +126
System.Data.SqlClient.SqlConnection.Open() +125
My web.config file looks like this:
<configuration>
<!-- enable forms authentication -->
<connectionStrings>
<add name="AIMIntranetConnectionString" connectionString="Data Source=INBOUND47\AIMCCSWEB;Initial Catalog=AIMIntranet;Integrated Security=True;user ID=aspnet;password=sss"
providerName="System.Data.SqlClient" />
</connectionStrings>
<system.web>
<authentication mode="Forms">
<forms name="ASP101SampleAuth" loginUrl="login_db.aspx" />
</authentication>
</system.web>
<!-- set secure page to reject anonymous users -->
<location path="admin.aspx">
<system.web>
<authorization>
<deny users="?" />
</authorization>
</system.web>
</location>
</configuration>
I did do as one user suggested and add aspnet to my users, but that did not work.
Any and all help is appreciated.
can you connect to this db with these values from SSMS?
from SSCM, go to SQL Client 10.0 Config -> Client Protocols and enable some protocols and try again...
ASKER
all 4 protocols are enabled , shared memory, named pipes, tcp/ip and via.
go to ssms, login with windows authontication
go to security
do you see aspnet here? what is the default db?
check user mapping here and check the db AIMIntranet
go to security
do you see aspnet here? what is the default db?
check user mapping here and check the db AIMIntranet
ASKER
I do see aspnet here under Logins. Default DB is set to AIMIntranet, under user mapping, checked off everything in there, still the same issue.
can you connect to db from ssms with this user?
ASKER
at this time, yes. I had to make the DB owner aspnet, but I can open it now with SSMS
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.