SQL Exception

Repeated in my log I have:

Exception: Cannot open database requested in login 'SharedServices1_DB'. Login fails. Login failed foruser 'ES\NAD2DS01$'. 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.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirec...
01/25/2007 11:48:39.66* w3wp.exe (0x1148) 0x12BC 484 880i High ...tedUserInstance) 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.Provider...
01/25/2007 11:48:39.66* w3wp.exe (0x1148) 0x12BC 484 880i High ...Base.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 Microsoft.Office.Server.Data.SqlSession.OpenConnection()

That database is alive and well, but I can't find where to specify a different/legal user id. Where is it getting that user from?

[2271 byte] By [DaveyBob] at [2008-2-15]
# 1

hai

I do faced the issue with SQL login.Kindly help us.........

sarashare at 2007-9-4 > top of Msdn Tech,SharePoint Products and Technologies,SharePoint - Setup, Upgrade, Administration and Operation...
# 2
Hi sarashare,

I think I figured out what was going on. Maybe this will help. I took a look at the SharePoint services that were running on the SharePoint box, and found that some of them were running as the "network service" user. So that may explain what I was seeing in my logs (a user name that matched the machine name, with a $ on the end). So I changed those to use my login id (and supplied my password) since I know that I have a valid login in SQL Server using that id. Most of the other services use that ID as well.

Since then, I can configure workflow and it seems to do the right things.

Hope that helps!

DaveyBob at 2007-9-4 > top of Msdn Tech,SharePoint Products and Technologies,SharePoint - Setup, Upgrade, Administration and Operation...

SharePoint Products and Technologies

Site Classified