New Sql server database problem

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2008 Forums

SQL Server Administration (2008)

New Sql server database problem

Author

Topic

marzy
Starting Member

2 Posts

Posted - 2011-06-25 : 13:09:22

Hi all,

I am not overly familiar with databass but I am having a strange problem.

I have recently migrated a database that was for a site running on dotnetnuke.

The database is quite large at around 4gb as the site has a lot of flash.

The site was running ok on the old windows server 2003 but now the stie keeps going down upto several times a day.

when I check the database in sql server management studio the databas has no plus sign next to it as if it is inaccessable. if i take the database offline and straight back online the sites comes staright back up.

I have been checking all over and cannot seem to figure out why this is happening and hope someone may be able to shed some light on the matter.

Really appreciate anyones help.

Thanks
Lee

lm

russell
Pyro-ma-ni-yak

5072 Posts

Posted - 2011-06-25 : 20:48:55

What messages are you seeing in the SQL Server Error Logs and in Event Viewer?

marzy
Starting Member

2 Posts

Posted - 2011-06-26 : 04:03:14

Hi Russell,

Thanks for the reply.

in the error log this is an example of one of the files.

2011-06-17 03:24:01 - ? [393] Waiting for SQL Server to recover databases...
2011-06-17 03:24:10 - ! [298] SQLServer Error: 15247, User does not have permission to perform this action. [SQLSTATE 42000] (DisableAgentXPs)
2011-06-17 03:24:11 - ! [298] SQLServer Error: 229, The EXECUTE permission was denied on the object 'sp_sqlagent_has_server_access', database 'msdb', schema 'dbo'. [SQLSTATE 42000] (ConnIsLoginSysAdmin)
2011-06-17 03:24:11 - ! [298] SQLServer Error: 229, The EXECUTE permission was denied on the object 'sp_sqlagent_get_startup_info', database 'msdb', schema 'dbo'. [SQLSTATE 42000]
2011-06-17 03:24:11 - ! [298] SQLServer Error: 229, The UPDATE permission was denied on the object 'sysalerts', database 'msdb', schema 'dbo'. [SQLSTATE 42000] (DumpAndCheckServerVersion)
2011-06-17 03:24:11 - ! [298] SQLServer Error: 229, The INSERT permission was denied on the object 'syssessions', database 'msdb', schema 'dbo'. [SQLSTATE 42000]
2011-06-17 03:24:11 - ! [000] Error creating a new session
2011-06-17 03:24:11 - ? [098] SQLServerAgent terminated (normally)

This is also taken from event viewer

Event code: 3005
Event message: An unhandled exception has occurred.
Event time: 25/06/2011 13:49:57
Event time (UTC): 25/06/2011 12:49:57
Event ID: 13e10df1db854b13912cd113fa83f686
Event sequence: 1917
Event occurrence: 140
Event detail code: 0

Application information:
Application domain: /LM/W3SVC/11/ROOT-1-129533867865612604
Trust level: Full
Application Virtual Path: /
Application Path: C:\Web\Sites\Dot Net Nuke\adrenaline_jungle\
Machine name: DS-01614

Process information:
Process ID: 3412
Process name: w3wp.exe
Account name: IIS APPPOOL\adrenalinjungle

Exception information:
Exception type: SqlException
Exception message: Cannot open database "THEJUNGLES" requested by the login. The login failed.
Login failed for user 'dotnetnuke441'.

Request information:
Request URL: http://www.adrenalinjungle.com/Default.aspx?TabID=837
Request path: /Default.aspx
User host address: 82.3.79.163
User:
Is authenticated: False
Authentication Type:
Thread account name: IIS APPPOOL\adrenalinjungle

Thread information:
Thread ID: 17
Thread account name: IIS APPPOOL\adrenalinjungle
Is impersonating: False
Stack trace: 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 Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters)
at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String connectionString, String spName, Object[] parameterValues)
at DotNetNuke.Services.Log.EventLog.DBLoggingProvider.Data.SqlDataProvider.AddLog(String LogGUID, String LogTypeKey, Int32 LogUserID, String LogUserName, Int32 LogPortalID, String LogPortalName, DateTime LogCreateDate, String LogServerName, String LogProperties, Int32 LogConfigID)
at DotNetNuke.Services.Log.EventLog.DBLoggingProvider.DBLoggingProvider.WriteLog(LogQueueItem objLogQueueItem)

Custom event details:

as well as this

Login failed for user 'dotnetnuke441'. Reason: Failed to open the explicitly specified database. [CLIENT:]

lm

russell
Pyro-ma-ni-yak

5072 Posts

Posted - 2011-06-27 : 09:07:39

Pretty clear no?

It's a permissions problem.

Need to make sure that all of your logins and users are valid after the migration.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources