
12/04/2010, 06:22
|
 | | | Fecha de Ingreso: noviembre-2003 Ubicación: Oslo
Mensajes: 230
Antigüedad: 21 años, 4 meses Puntos: 0 | |
Failed Conectionstring Login failed q tal, bueno hace un rato decidi hacer un sitio en mi pc y instale sql server 2008 y VS 2008 la cosa es que cuando trato de conectarlo de la misma forma q lo hago en el trabajo aparece login failed
adjunto conectionstring
Código:
<appSettings>
<add key="db.conn" value="server=WSOZA-PC;UID=wsoza-PC\wsoza;PWD="/>
</appSettings>
cuando le hago el debug me devuelve el error como Login failed
Código:
{System.Data.SqlClient.SqlException: Login failed for user 'wsoza-PC\wsoza'.
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlInternalConnectionTds.CompleteLogin(Boolean enlistOK)
at System.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfo serverInfo, String newPassword, Boolean ignoreSniOpenTimeout, Int64 timerExpire, SqlConnection owningObject)
at System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(String host, String newPassword, Boolean redirectedUserInstance, SqlConnection owningObject, SqlConnectionString connectionOptions, Int64 timerStart)
at System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance)
at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance)
at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection)
at System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options)
at System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject)
at System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject)
at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject)
at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)
at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
at System.Data.SqlClient.SqlConnection.Open()
at Data.Db.GetData(String sql) in C:\Users\wsoza\Documents\Visual Studio 2008\Projects\Contacts\Data\Db.cs:line 31}
en el SQL SERVER me logeo como
Server name WSOZA-PC
authentication Windows Authentication
user name wsoza-PC\wsoza
Última edición por jahman; 12/04/2010 a las 06:28 |