Erro com webservice
12/08/2008
0
System.Data.SqlClient.SqlException: Login failed for user ´ALEXEI\IUSR_ALEXEI´.
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 PocketTableAdapters.CLIENTETableAdapter.Insert(String CLI_NOME, String CLI_ENDERECO, String CLI_CIDADE) in c:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET Files\website\92deab70\f27760e2\App_Code.pfxi2bch.1.cs:line 891
at ClienteIn.InserirCliente(String nome, String endereco, String cidade) in c:\Inetpub\wwwroot\WebSite\App_Code\ClienteIn.cs:line 25
Agradeço qualquer ajuda, creio que seja algo com relação ao usuário do IIS...
Lex.
Buenolex
Posts
13/08/2008
Lucyanocm
13/08/2008
Buenolex
Grato pela atenção,
Lex.
13/08/2008
Lucyanocm
Coloque na sua string de conexão do seu objeto sqlconnection assim:
Data Source=NOME_SERVIDOR_SQLSERVER(OU IP);Initial Catalog=BANCO_DE_DADOS;Persist Security Info=True;User ID=USUARIO_DO_SQLSERVER;Password=SENHA_DO_USUARIO
Substituindo os valores pelos correspondentes a realidade da sua aplicação.
Espero ter ajudado.
Clique aqui para fazer login e interagir na Comunidade :)