Database 'msdb' Cannot Be Opened
Jun 6, 2006
Anyone help?
I opened SQL Server management studio and tried to connect with the local database and received the error message:
Database 'msdb' cannot be opened. It has been marked suspect.....
I have pasted the only error from the event log I could find below, but it doesn't mean much to me.
In the event I can't find what the problem is, and not being a database administrator, can anyone tell me what I can do to get back in working order without messing up all the databases in my SQL Server 2005. I'm afraid I only have a MASTER backup from several months ago, and am afraid if I use this, I will loose the latest data. I'm a novice, and do not understand the relationship of the master/msdb/model databases to my core custom databases. Can I do some sort of master rebuild without affecting the other databases I have?
I have tried sp_resetstatus but this didn't fix the problem, but it did enable me to actually connect to the SQL server instance so I could access all the other databases.
Many thanks
Gerard
Event log error detail:
The log scan number (152:284:1) passed to log scan in database 'msdb' is not valid. This error may indicate data corruption or that the log file (.ldf) does not match the data file (.mdf). If this error occurred during replication, re-create the publication. Otherwise, restore from backup if the problem results in a failure during startup.
View 19 Replies
ADVERTISEMENT
Jun 21, 2007
I'am doing functionality test on DTS packages and saving my DTS packages to meta data services instead of saving them as local packages. We would like to see what information would be provided by saving them this way, but when we try to open the meta data browser (the 3rd icon under DTS) we get the following error:
An error occurred while trying to access the database information. The msdb database could not be opened.
View 3 Replies
View Related
May 26, 2006
Hello anyone / everyone,
If you are having trouble accessing Meta Data Services on W2k3 and SQL 2000 and get the error that the "msdb database could not be opened" I found that hot fix 912812 on the operating system is the culprit. Remove it and Meta Data goes back to working, although I am being asked to approve the ActiveX control every time the page refreshes.
Hope this helps somebody, to took me long enough to track it down.
If anyone has a resolution to the ActiveX question I'd love to know the answer.
Thank you,
Uncle Davy
View 5 Replies
View Related
Feb 7, 2012
I'm working on a SQL Server 2005 mirroring database test.The idea is to stop main DB server and activate the standby being mirrored (pretendng that principal DB Server is down)
Mirror works fine.
But for the test I do the following:
- Stop the principal SQLSERVER
- Connect to the standby server and execute the followng:
sqlcmd -S <IP> -d master -U opmirror -P xxxxx -Q "ALTER DATABASE DB_NAME SET PARTNER FORCE_SERVICE_ALLOW_DATA_LOSS;"
And it returns this error:
"Database 'DB_NAME' cannot be opened. It is in the middle of a restore"
Why can't the standby database be opened?
View 3 Replies
View Related
Apr 1, 2007
i have curputed mdf and ldf file for ms sql 2005
i have tried to put the db in standby mode and when i try to run dbcc checkdb or any other command i get this message
Database 'dbname' cannot be opened because its version (611) is later than the current server version (539).
but without standby mode i get this error
TITLE: Microsoft SQL Server Management Studio
------------------------------
Failed to retrieve data for this request. (Microsoft.SqlServer.SmoEnum)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&LinkId=20476
------------------------------
ADDITIONAL INFORMATION:
Could not find row in sysindexes for database ID 40, object ID 1, index ID 1. Run DBCC CHECKTABLE on sysindexes. (Microsoft SQL Server, Error: 602)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=602&LinkId=20476
------------------------------
BUTTONS:
OK
------------------------------
View 2 Replies
View Related
Jun 12, 2006
Hello,Could you explain me please the following error:"Database 'DemoDotNET' cannot be opened due to inaccessible files orinsufficient memory or disk space. (Microsoft SQL Server, Error: 945)"I have checked: free disk space is large enough, I have much enoughmemory, other files in the directory are accessible.Here is tail of ERRORLOG:2006-06-12 21:19:55.68 Logon Error: 18456, Severity: 14, State:16.2006-06-12 21:19:55.68 Logon Login failed for user 'PCRobert'.[CLIENT: <local machine>]2006-06-12 21:20:43.39 Server Server resumed execution afterbeing idle 1 seconds: user activity awakened the server. This is aninformational message only. No user action is required.Please help to solve this.Thank you./RAM/
View 3 Replies
View Related
Jul 23, 2007
When I try the open the report file, I got the following error message. Database 'ReportServer$SQLExpressTempDB' cannot be opened due to inaccessible files or insufficient memory or disk space. See the SQL Server errorlog for details. Anyony have ideas to fix this error?
View 3 Replies
View Related
Dec 15, 2014
I have a view saved on server - mhsvi-datawarehousedatawarehouse.This view, in it's TSQL connects to a databasethat is set up as a linked server. That server is mhsvi-sql2008ainstance1.When I try to add the view to Excel in order to automatically refresh for users as a report - I get the following error - (I get it as well)
The query did not run, or the database table could not be opened.Check the database server or contact your database administrator. Make sure the external database is available and hasn't been moved or reorganized, then try the operation again.I have access to the database where the view is saved and the database that the TSQL calls.
View 6 Replies
View Related
Dec 4, 2007
Hi All:
Can anyone point out what's wrong with the following script? I wanted to print all the LOGFILE names in all databases which are not in SIMPLE recovery model. Thanks in advance.
Jim
USE masterDECLARE @db_name nvarchar(100), @log_name nvarchar(100);DECLARE DB_Cursor CURSOR FORselect name from msdb.sys.databases where recovery_model_desc <> 'SIMPLE';OPEN DB_Cursor FETCH NEXT FROM DB_Cursor INTO @db_name WHILE @@FETCH_STATUS = 0 BEGIN USE @db_name -- Can I do this? GO select @log_name = name from sys.database_files where type_desc ='LOG'; print @log_name; ENDCLOSE DB_CursorDEALLOCATE DB_CursorI got the following error:Msg 102, Level 15, State 1, Line 13Incorrect syntax near '@db_name'.Msg 137, Level 15, State 1, Line 1Must declare the scalar variable "@log_name".Msg 137, Level 15, State 2, Line 2Must declare the scalar variable "@log_name".
View 3 Replies
View Related
Sep 2, 2007
Greetings, I have just arrived back into the country (NZ) and back into ASP.NET.
I am having trouble with the following:An attempt to attach an auto-named database for file (file location).../Database.mdf failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share.
It has only begun since i decided i wanted to use IIS, I realise VWD comes with its own localhost, but since it is only temporary, i wanted a permanent shortcut on my desktop to link to my intranet page.
Anyone have any ideas why i am getting the above error? have searched many places on the internet and not getting any closer.
Cheers ~ J
View 3 Replies
View Related
Dec 5, 2006
Hello everyone,
I have been playing with a Standard Version of VS 2005 and SSE 2005 and I just cannot get these two to interact together well. I am sure it is a noob problem but I have seen this error addressed on this forum and I am just not getting it. Here is exactly what I am doing.
I want to create a database within SSE using the Management Studio. Then, I want to connect to it with VS2005. Both SSE and VS2005 are local. I just cant seem to get this to work.
I always seem to get this error "An attempt to attach an auto-named database for file C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLDataSecond.mdf failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share."
One thing... I create the website with Location: HTTP. I don't even know anymore why I do this.. I think because I like to be able to pull up a browser and get to my app. Other than that I am doing nothing special. However, I get the above error when I hit F5 to run the app inside VS2005.
Is there someplace where a complete noob can find a thorough and simple covering of this? Again, I have read through some of the previous posts on this and I don't understand too many of them and it seems as if there are at least 13 causes of which I don't know which one I have. Help!
Thanks.
View 30 Replies
View Related
Mar 3, 2008
Hi all,
I'm using VS2005 + SQL Compact 3.1 and Enterprise Library 3.1 May 2007
I can successfully create a db using pull method, when I try to push back data I got the following SQLCE error:
"Another user has opened the database with different instance-level initialization properties. [ 32 ]"
Before calling the push method I did
SqlCeDatabase eCE = Helper.GetDB() as SqlCeDatabase;
eCE.CloseSharedConnection();
SqlCeConnectionPool.CloseSharedConnections();
SqlCeRemoteDataAccess rda = new SqlCeRemoteDataAccess();
rda.InternetUrl = webSynchronizationUrl;
rda.InternetLogin = webuser;
rda.InternetPassword = webpass;
rda.LocalConnectionString = eCE.ConnectionStringWithoutCredentials;
but after the assignment the LocalConnectionString is different from ConnectionStringWithoutCredentials, there are much more ssce parameters.
What I don't understand is:
why I'm getting this error even after closing the connection ?
Since the error report [32] the ssce conflicting parameters shoud be AUTO_SHRINK_THRESHOLD, FLUSH_INTERVAL and MAX_DATABASE_SIZE
I tried to cut & paste the same values from LocalConnectionString into app.config connection string, at first It seemed to work, but now I got the same error.
Any help will be greatly appreciated
Thanks
View 3 Replies
View Related
Aug 4, 2015
How to fix this SQL error event logg 17204 and 17207 ?
View 8 Replies
View Related
Nov 21, 2005
Whenever I start my SQL Express 2005 database, I get the following in the logs :
View 10 Replies
View Related
Mar 11, 2006
Hi,
I have tried to attatch a database ,created by SQL server Express within a C# application , in SQL server 2005 Enterprise edition, but the following error message appears:
-----------------------------
TITLE: Microsoft SQL Server Management Studio
------------------------------
Attach database failed for Server 'MEDO'. (Microsoft.SqlServer.Smo)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft SQL Server&ProdVer=9.00.1187.00&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Attach database+Server&LinkId=20476
------------------------------
ADDITIONAL INFORMATION:
An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)
------------------------------
The database 'E:X.MDF' cannot be opened because it is version 611. This server supports version 607 and earlier. A downgrade path is not supported.
Could not open new database 'E:X.MDF'. CREATE DATABASE is aborted. (Microsoft SQL Server, Error: 948)
------------------------------
so , how can I solve this problem , I need to reed the data resides in the tables of 'X' database , how can I do it?? please help me.
Thanks in advance for any help.
Aya.
View 7 Replies
View Related
May 2, 2001
I have a new server setup running sql2000 as default instance. I wanted
to move all the jobs and dts packages from another server which is running
multiple instances of sql server. I backed up and restored the msdb database
to the new server and now I can't edit any jobs. I get this error?
can't edit or delete the job that originated from MSX server.
How do I fix this problem. Any help will be appreciated.
View 1 Replies
View Related
May 31, 2000
1) How do I reinstall a fresh copy of the MSDB database (since my current
one is corrupt). Is there any script available?
2) What is the purpose of the MSDB database? Backups and jobs/ Wizards?
Thanks for your help.
Ziggy
View 2 Replies
View Related
Mar 14, 2000
Hi Everyone,
Couple of days back my server was down because of hardware problem and it was rectefied and sql server 6.5 started yesterday afternoon and the backup schedules was run in demand yesterday but it failed, and some of the schedules which are suppose to take backup in the night also failed today, it was also not showing anything in the schedule history, and when I run the schedule on demand today again it failed, so I created a newdevice and scheduled a newtask and I run in demand and the history shows that:-
schedule history (Could not insert a backup or restore history/detail record in msdb.dbo.sysbackuphistory or sysrestorehistory. This may indicate a problem with the MSDB database. DUMP/LOAD was still successful. (Message 3009)).
I checked the sysbackuphistory it shows three days back history, can any body give me the solution, what are the things to be checked, please give me the solution.
waiting for the immediate reply.
Thanks,
Madhu
View 1 Replies
View Related
Jul 28, 2005
I have to rename some Originating_Server fields in the msdb database. I'm pretty sure I have to run a script that makes the msdb database editable but I can't find it anywhere. Am I wrong?
View 3 Replies
View Related
Jun 19, 2008
Friends -
I am not able to connect to MSDB database under SQL Server 2005 Integration services. i am getting the following error.
TITLE: Microsoft SQL Server Management Studio
------------------------------
Failed to retrieve data for this request. (Microsoft.SqlServer.SmoEnum)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&LinkId=20476
------------------------------
ADDITIONAL INFORMATION:
The SQL server specified in SSIS service configuration is not present or is not available. This might occur when there is no default instance of SQL Server on the computer. For more information, see the topic "Configuring the Integration Services Service" in Server 2005 Books Online.
Login timeout expired
An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections.
Named Pipes Provider: Could not open a connection to SQL Server [2]. (MsDtsSrvr)
------------------------------
Login timeout expired
An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections.
Named Pipes Provider: Could not open a connection to SQL Server [2]. (Microsoft SQL Native Client)
------------------------------
BUTTONS:
OK
Please advise on this.
cheers :)
Satish
View 4 Replies
View Related
Aug 17, 2006
Hi all
when i try to restore a database called ddaa, i am getting the following message after the restore is completed.. and the database icon in the enterprize manager is having ddaa(loading).now i am not able to access that database..
the message i am getting is..
database msdb cannot be opened due to anaccessible files or insufficient memory or disk space. could not insert a backup/restore history detail record in the msdb database.this may indicate a problem with the msdb database.
how to resolve this issue..
Thanks in advance.
View 3 Replies
View Related
Dec 14, 2007
Dear Experts,
in one of our servers, the MSDB database is in suspect mode, and i've used the command sp_resetstatus
and i restarted the service also but still it is in suspect mode.
how can i change that to normal state?
it is asking to check the errorlog.
Vinod
Even you learn 1%, Learn it with 100% confidence.
View 6 Replies
View Related
Jul 23, 2005
My msdb database is marked as suspect. This means that my maintenance plandoesn't work. I'm a novice when it comes to sql server so now I'm wonderingif anyone could give a hint on how to fix the suspect msdb database? Doesthis database contain any vital information? What could be the reason thatthis database become suspect?Appreciate any suggestions in this matter.Thanks!--mvhHallgeir
View 2 Replies
View Related
Jul 9, 2007
A client improperly shutdown a PC running MSDE and it corrupted the MSDB database which contained several DTS packages. I have tried fixing the problem on my own but have exhausted all the simple options like restarting SQL Server.
I googled the problem and found the following SQL script:
USE MasterGO-- Determine the original database statusSELECT [Name], DBID, StatusFROM master.dbo.sysdatabasesGO-- Enable system changessp_configure 'allow updates',1GORECONFIGURE WITH OVERRIDEGO-- Update the database statusUPDATE master.dbo.sysdatabasesSET Status = 24WHERE [Name] = 'msdb'GO-- Disable system changessp_configure 'allow updates',0GORECONFIGURE WITH OVERRIDEGO-- Determine the final database statusSELECT [Name], DBID, StatusFROM master.dbo.sysdatabasesGO
I ran it and and it generated the log file below. I restarted MS SQL but the database was still marked as suspect (as I would expect from the log file).
Any help in interpreting and recovering from this problem would be greatly appreciated.
Thank,
MickeyBob
Log file:
2007-07-09 15:47:39.39 server Microsoft SQL Server 2000 - 8.00.760 (Intel X86) Dec 17 2002 14:22:05 Copyright (c) 1988-2003 Microsoft Corporation Desktop Engine on Windows NT 5.1 (Build 2600: Service Pack 2)2007-07-09 15:47:39.39 server Copyright (C) 1988-2002 Microsoft Corporation.2007-07-09 15:47:39.39 server All rights reserved.2007-07-09 15:47:39.39 server Server Process ID is 2324.2007-07-09 15:47:39.39 server Logging SQL Server messages in file 'C:Program FilesMicrosoft SQL ServerMSSQLLOGERRORLOG'.2007-07-09 15:47:39.40 server SQL Server is starting at priority class 'normal'(2 CPUs detected).2007-07-09 15:47:39.84 server SQL Server configured for thread mode processing.2007-07-09 15:47:39.84 server Using dynamic lock allocation. [500] Lock Blocks, [1000] Lock Owner Blocks.2007-07-09 15:47:39.89 spid3 Starting up database 'master'.2007-07-09 15:47:40.01 server Using 'SSNETLIB.DLL' version '8.0.766'.2007-07-09 15:47:40.01 spid5 Starting up database 'model'.2007-07-09 15:47:40.01 server SQL server listening on Shared Memory.2007-07-09 15:47:40.01 server SQL Server is ready for client connections2007-07-09 15:47:40.04 spid3 Server name is 'BALEHANDLING'.2007-07-09 15:47:40.04 spid3 Skipping startup of clean database id 52007-07-09 15:47:40.04 spid3 Skipping startup of clean database id 62007-07-09 15:47:40.04 spid3 Starting up database 'msdb'.2007-07-09 15:47:40.23 spid5 Clearing tempdb database.2007-07-09 15:47:41.18 spid5 Starting up database 'tempdb'.2007-07-09 15:47:55.56 spid51 Using 'xpstar.dll' version '2000.80.760' to execute extended stored procedure 'sp_MSgetversion'.2007-07-09 15:48:01.60 spid3 Analysis of database 'msdb' (4) is 100% complete (approximately 0 more seconds)2007-07-09 15:48:01.62 spid3 Recovery of database 'msdb' (4) is 0% complete (approximately 9 more seconds) (Phase 2 of 3).2007-07-09 15:48:43.95 spid3 Recovery of database 'msdb' (4) is 40% complete (approximately 5 more seconds) (Phase 2 of 3).2007-07-09 15:48:43.96 spid3 7678 transactions rolled forward in database 'msdb' (4).2007-07-09 15:48:43.96 spid3 Recovery of database 'msdb' (4) is 40% complete (approximately 5 more seconds) (Phase 3 of 3).2007-07-09 15:48:44.01 spid3 Using 'dbghelp.dll' version '4.0.5'*Dump thread - spid = 3, PSS = 0x42c2c098, EC = 0x42c2c3c0*Stack Dump being sent to C:Program FilesMicrosoft SQL ServerMSSQLlogSQLDump0030.txt* ********************************************************************************* BEGIN STACK DUMP:* 07/09/07 15:48:44 spid 3** ** ** MODULE BASE END SIZE* sqlservr 00400000 00B2CFFF 0072d000* ntdll 7C900000 7C9AFFFF 000b0000* kernel32 7C800000 7C8F3FFF 000f4000* ADVAPI32 77DD0000 77E6AFFF 0009b000* RPCRT4 77E70000 77F00FFF 00091000* USER32 77D40000 77DCFFFF 00090000* GDI32 77F10000 77F56FFF 00047000* OPENDS60 41060000 41065FFF 00006000* MSVCRT 77C10000 77C67FFF 00058000* UMS 41070000 4107CFFF 0000d000* SQLSORT 42AE0000 42B6FFFF 00090000* MSVCIRT 002A0000 002B0FFF 00011000* sqlevn70 41080000 41086FFF 00007000* NETAPI32 024F0000 02543FFF 00054000* SSNETLIB 00DC0000 00DD4FFF 00015000* WSOCK32 00DF0000 00DF8FFF 00009000* WS2_32 00E00000 00E16FFF 00017000* WS2HELP 00E20000 00E27FFF 00008000* SSNMPN70 02CD0000 02CD5FFF 00006000* security 02FD0000 02FD3FFF 00004000* SECUR32 02FE0000 02FF0FFF 00011000* VERSION 030C0000 030C7FFF 00008000* SSmsLPCn 03000000 03006FFF 00007000* ntdsapi 030A0000 030B2FFF 00013000* DNSAPI 030D0000 030F6FFF 00027000* WLDAP32 03100000 0312BFFF 0002c000* msv1_0 03330000 03352FFF 00023000* iphlpapi 03360000 03378FFF 00019000* OLE32 03390000 034CBFFF 0013c000* xpsp2res 034D0000 03794FFF 002c5000* CLBCATQ 037A0000 0381EFFF 0007f000* OLEAUT32 03820000 038ABFFF 0008c000* COMRes 038B0000 03974FFF 000c5000* sqloledb 03990000 03A10FFF 00081000* MSDART 03A20000 03A44FFF 00025000* COMCTL32 03A50000 03AE9FFF 0009a000* comdlg32 03AF0000 03B38FFF 00049000* SHLWAPI 03B40000 03BB5FFF 00076000* SHELL32 03BC0000 043D4FFF 00815000* MSDATL3 043E0000 043F6FFF 00017000* comctl32 044C0000 045C2FFF 00103000* oledb32 04810000 04886FFF 00077000* OLEDB32R 04480000 04490FFF 00011000* xpstar 04890000 048D6FFF 00047000* SQLRESLD 04420000 04426FFF 00007000* SQLSVC 048E0000 048F6FFF 00017000* ODBC32 04900000 0493CFFF 0003d000* odbcbcp 044A0000 044A5FFF 00006000* W95SCM 04940000 0494BFFF 0000c000* SQLUNIRL 04950000 0497CFFF 0002d000* WINSPOOL 04980000 049A5FFF 00026000* SHFOLDER 049B0000 049B8FFF 00009000* odbcint 04B00000 04B16FFF 00017000* clusapi 04B20000 04B30FFF 00011000* resutils 04B40000 04B51FFF 00012000* USERENV 04B60000 04C12FFF 000b3000* NDDEAPI 04C30000 04C37FFF 00008000* SQLSVC 04C40000 04C45FFF 00006000* xpstar 04C50000 04C58FFF 00009000* dbghelp 04CA0000 04D54FFF 000b5000** Edi: 42C2C3C0: 42C2C098 42C2CB30 42C2CB30 42C2CD20 42C2CD20 42C2C030 * Esi: 00000000: * Eax: 00000000: * Ebx: 42C2C098: 01000003 00000000 00000000 00000000 00000000 00000000 * Ecx: 0294B43C: 00000000 0001003F 00000000 00000000 00000000 00000000 * Edx: 7C90EB94: 24A48DC3 00000000 0024648D 90909090 24548D90 C32ECD08 * Eip: 0087A90E: 4D830088 75FFFFFC 0875FF0C E8E04D8B 0000002D 64F04D8B * Ebp: 0294B420: 0294BC40 0087C41F 42C2C098 0294BDA4 0294C016 77C3F931 * SegCs: 0000001B: * EFlags: 00010246: 006C0069 00730065 0053005C 00650069 0065006D 0073006E * Esp: 0294B3F4: 42C2C3C0 00000000 42C2C098 0294B43C 42C2C000 0294B3F4 * SegSs: 00000023: * ******************************************************************************** -------------------------------------------------------------------------------* Short Stack Dump* 0087A90E Module(sqlservr+0047A90E) (GetOSErrString+00003BDB)* 0087C41F Module(sqlservr+0047C41F) (GetOSErrString+000056EC)* 00931097 Module(sqlservr+00531097) (CDStream:umpBytesHex+000A9840)* 007FC8A6 Module(sqlservr+003FC8A6) (CDStream:perator=+00005B0E)* 00403B44 Module(sqlservr+00003B44)* 004416A7 Module(sqlservr+000416A7)* 0040F1E5 Module(sqlservr+0000F1E5)* 0040FF2B Module(sqlservr+0000FF2B)* 0040FE45 Module(sqlservr+0000FE45)* 00436DD6 Module(sqlservr+00036DD6)* 0043683C Module(sqlservr+0003683C)* 0040FD6F Module(sqlservr+0000FD6F)* 0040FB39 Module(sqlservr+0000FB39)* 008607CA Module(sqlservr+004607CA) (CDStream:perator=+00069A32)* 0086C203 Module(sqlservr+0046C203) (CDStream:perator=+0007546B)* 004401D7 Module(sqlservr+000401D7)* 0085EA07 Module(sqlservr+0045EA07) (CDStream:perator=+00067C6F)* 0050C003 Module(sqlservr+0010C003)* 005100FF Module(sqlservr+001100FF)* 0050F152 Module(sqlservr+0010F152)* 00519C2D Module(sqlservr+00119C2D)* 00829863 Module(sqlservr+00429863) (CDStream:perator=+00032ACB)* 005196A1 Module(sqlservr+001196A1)* 00518066 Module(sqlservr+00118066)* 41074698 Module(UMS+00004698) (UmsThreadScheduler::~UmsThreadScheduler+00000198)* 542868FF Module(UNKNOWN+00000000)* -------------------------------------------------------------------------------2007-07-09 15:48:44.06 spid3 SQL Server Assertion: File: <recbase.cpp>, line=1378 Failed Assertion = 'm_offBeginVar < m_SizeRec'.2007-07-09 15:48:44.06 spid3 Location: recbase.cpp:1378Expression: m_offBeginVar < m_SizeRecSPID: 3Process ID: 23242007-07-09 15:48:44.06 spid3 Error: 3624, Severity: 20, State: 1.2007-07-09 15:48:44.06 spid3 Error: 3314, Severity: 21, State: 32007-07-09 15:48:44.06 spid3 Error while undoing logged operation in database 'msdb'. Error at log record ID (97997:269:86)..2007-07-09 15:48:44.09 spid3 Using 'dbghelp.dll' version '4.0.5'*Dump thread - spid = 3, PSS = 0x42c2c098, EC = 0x42c2c3c0*Stack Dump being sent to C:Program FilesMicrosoft SQL ServerMSSQLlogSQLDump0031.txt* ********************************************************************************* BEGIN STACK DUMP:* 07/09/07 15:48:44 spid 3** ** ** MODULE BASE END SIZE* sqlservr 00400000 00B2CFFF 0072d000* ntdll 7C900000 7C9AFFFF 000b0000* kernel32 7C800000 7C8F3FFF 000f4000* ADVAPI32 77DD0000 77E6AFFF 0009b000* RPCRT4 77E70000 77F00FFF 00091000* USER32 77D40000 77DCFFFF 00090000* GDI32 77F10000 77F56FFF 00047000* OPENDS60 41060000 41065FFF 00006000* MSVCRT 77C10000 77C67FFF 00058000* UMS 41070000 4107CFFF 0000d000* SQLSORT 42AE0000 42B6FFFF 00090000* MSVCIRT 002A0000 002B0FFF 00011000* sqlevn70 41080000 41086FFF 00007000* NETAPI32 024F0000 02543FFF 00054000* SSNETLIB 00DC0000 00DD4FFF 00015000* WSOCK32 00DF0000 00DF8FFF 00009000* WS2_32 00E00000 00E16FFF 00017000* WS2HELP 00E20000 00E27FFF 00008000* SSNMPN70 02CD0000 02CD5FFF 00006000* security 02FD0000 02FD3FFF 00004000* SECUR32 02FE0000 02FF0FFF 00011000* VERSION 030C0000 030C7FFF 00008000* SSmsLPCn 03000000 03006FFF 00007000* ntdsapi 030A0000 030B2FFF 00013000* DNSAPI 030D0000 030F6FFF 00027000* WLDAP32 03100000 0312BFFF 0002c000* msv1_0 03330000 03352FFF 00023000* iphlpapi 03360000 03378FFF 00019000* OLE32 03390000 034CBFFF 0013c000* xpsp2res 034D0000 03794FFF 002c5000* CLBCATQ 037A0000 0381EFFF 0007f000* OLEAUT32 03820000 038ABFFF 0008c000* COMRes 038B0000 03974FFF 000c5000* sqloledb 03990000 03A10FFF 00081000* MSDART 03A20000 03A44FFF 00025000* COMCTL32 03A50000 03AE9FFF 0009a000* comdlg32 03AF0000 03B38FFF 00049000* SHLWAPI 03B40000 03BB5FFF 00076000* SHELL32 03BC0000 043D4FFF 00815000* MSDATL3 043E0000 043F6FFF 00017000* comctl32 044C0000 045C2FFF 00103000* oledb32 04810000 04886FFF 00077000* OLEDB32R 04480000 04490FFF 00011000* xpstar 04890000 048D6FFF 00047000* SQLRESLD 04420000 04426FFF 00007000* SQLSVC 048E0000 048F6FFF 00017000* ODBC32 04900000 0493CFFF 0003d000* odbcbcp 044A0000 044A5FFF 00006000* W95SCM 04940000 0494BFFF 0000c000* SQLUNIRL 04950000 0497CFFF 0002d000* WINSPOOL 04980000 049A5FFF 00026000* SHFOLDER 049B0000 049B8FFF 00009000* odbcint 04B00000 04B16FFF 00017000* clusapi 04B20000 04B30FFF 00011000* resutils 04B40000 04B51FFF 00012000* USERENV 04B60000 04C12FFF 000b3000* NDDEAPI 04C30000 04C37FFF 00008000* SQLSVC 04C40000 04C45FFF 00006000* xpstar 04C50000 04C58FFF 00009000* dbghelp 04CA0000 04D54FFF 000b5000** Edi: 42C2C3C0: 42C2C098 42C2C3C4 42C2C3C4 42C2CD20 42C2CB30 42C2C030 * Esi: 00000000: * Eax: 00000000: * Ebx: 42C2C098: 01000003 00000000 00000000 00000000 00000000 00000000 * Ecx: 02946B44: 00000000 0001003F 00000000 00000000 00000000 00000000 * Edx: 7C90EB94: 24A48DC3 00000000 0024648D 90909090 24548D90 C32ECD08 * Eip: 0087A90E: 4D830088 75FFFFFC 0875FF0C E8E04D8B 0000002D 64F04D8B * Ebp: 02946B28: 02947348 0087C41F 42C2C098 029474AC 02947735 77C3F931 * SegCs: 0000001B: * EFlags: 00010246: 006C0069 00730065 0053005C 00650069 0065006D 0073006E * Esp: 02946AFC: 42C2C3C0 00000000 42C2C098 02946B44 42C2C000 02946AFC * SegSs: 00000023: * ******************************************************************************** -------------------------------------------------------------------------------* Short Stack Dump* 0087A90E Module(sqlservr+0047A90E) (GetOSErrString+00003BDB)* 0087C41F Module(sqlservr+0047C41F) (GetOSErrString+000056EC)* 00931097 Module(sqlservr+00531097) (CDStream:umpBytesHex+000A9840)* 0085C09D Module(sqlservr+0045C09D) (CDStream:perator=+00065305)* 0050A016 Module(sqlservr+0010A016)* 008D048F Module(sqlservr+004D048F) (CDStream:umpBytesHex+00048C38)* 0085D84B Module(sqlservr+0045D84B) (CDStream:perator=+00066AB3)* 005100FF Module(sqlservr+001100FF)* 0050F152 Module(sqlservr+0010F152)* 00519C2D Module(sqlservr+00119C2D)* 00829863 Module(sqlservr+00429863) (CDStream:perator=+00032ACB)* 005196A1 Module(sqlservr+001196A1)* 00518066 Module(sqlservr+00118066)* 41074698 Module(UMS+00004698) (UmsThreadScheduler::~UmsThreadScheduler+00000198)* 542868FF Module(UNKNOWN+00000000)* -------------------------------------------------------------------------------2007-07-09 15:48:44.14 spid3 SQL Server Assertion: File: <logscan.cpp>, line=3063 Failed Assertion = '(m_lastLSN == NullLSN) || (m_lastLSN > m_curLSN)'.2007-07-09 15:48:44.14 spid3 Location: logscan.cpp:3063Expression: (m_lastLSN == NullLSN) || (m_lastLSN > m_curLSN)SPID: 3Process ID: 23242007-07-09 15:48:44.14 spid3 Using 'dbghelp.dll' version '4.0.5'*Dump thread - spid = 3, PSS = 0x42c2c098, EC = 0x42c2c3c0*Stack Dump being sent to C:Program FilesMicrosoft SQL ServerMSSQLlogSQLDump0032.txt* ********************************************************************************* BEGIN STACK DUMP:* 07/09/07 15:48:44 spid 3** ** ** MODULE BASE END SIZE* sqlservr 00400000 00B2CFFF 0072d000* ntdll 7C900000 7C9AFFFF 000b0000* kernel32 7C800000 7C8F3FFF 000f4000* ADVAPI32 77DD0000 77E6AFFF 0009b000* RPCRT4 77E70000 77F00FFF 00091000* USER32 77D40000 77DCFFFF 00090000* GDI32 77F10000 77F56FFF 00047000* OPENDS60 41060000 41065FFF 00006000* MSVCRT 77C10000 77C67FFF 00058000* UMS 41070000 4107CFFF 0000d000* SQLSORT 42AE0000 42B6FFFF 00090000* MSVCIRT 002A0000 002B0FFF 00011000* sqlevn70 41080000 41086FFF 00007000* NETAPI32 024F0000 02543FFF 00054000* SSNETLIB 00DC0000 00DD4FFF 00015000* WSOCK32 00DF0000 00DF8FFF 00009000* WS2_32 00E00000 00E16FFF 00017000* WS2HELP 00E20000 00E27FFF 00008000* SSNMPN70 02CD0000 02CD5FFF 00006000* security 02FD0000 02FD3FFF 00004000* SECUR32 02FE0000 02FF0FFF 00011000* VERSION 030C0000 030C7FFF 00008000* SSmsLPCn 03000000 03006FFF 00007000* ntdsapi 030A0000 030B2FFF 00013000* DNSAPI 030D0000 030F6FFF 00027000* WLDAP32 03100000 0312BFFF 0002c000* msv1_0 03330000 03352FFF 00023000* iphlpapi 03360000 03378FFF 00019000* OLE32 03390000 034CBFFF 0013c000* xpsp2res 034D0000 03794FFF 002c5000* CLBCATQ 037A0000 0381EFFF 0007f000* OLEAUT32 03820000 038ABFFF 0008c000* COMRes 038B0000 03974FFF 000c5000* sqloledb 03990000 03A10FFF 00081000* MSDART 03A20000 03A44FFF 00025000* COMCTL32 03A50000 03AE9FFF 0009a000* comdlg32 03AF0000 03B38FFF 00049000* SHLWAPI 03B40000 03BB5FFF 00076000* SHELL32 03BC0000 043D4FFF 00815000* MSDATL3 043E0000 043F6FFF 00017000* comctl32 044C0000 045C2FFF 00103000* oledb32 04810000 04886FFF 00077000* OLEDB32R 04480000 04490FFF 00011000* xpstar 04890000 048D6FFF 00047000* SQLRESLD 04420000 04426FFF 00007000* SQLSVC 048E0000 048F6FFF 00017000* ODBC32 04900000 0493CFFF 0003d000* odbcbcp 044A0000 044A5FFF 00006000* W95SCM 04940000 0494BFFF 0000c000* SQLUNIRL 04950000 0497CFFF 0002d000* WINSPOOL 04980000 049A5FFF 00026000* SHFOLDER 049B0000 049B8FFF 00009000* odbcint 04B00000 04B16FFF 00017000* clusapi 04B20000 04B30FFF 00011000* resutils 04B40000 04B51FFF 00012000* USERENV 04B60000 04C12FFF 000b3000* NDDEAPI 04C30000 04C37FFF 00008000* SQLSVC 04C40000 04C45FFF 00006000* xpstar 04C50000 04C58FFF 00009000* dbghelp 04CA0000 04D54FFF 000b5000** Edi: 42C2C3C0: 42C2C098 42C2C3C4 42C2C3C4 42C2CD20 42C2CB30 42C2C030 * Esi: 00000000: * Eax: 00000000: * Ebx: 42C2C098: 01000003 00000000 00000000 00000000 00000000 00000000 * Ecx: 029468EC: 00000000 0001003F 00000000 00000000 00000000 00000000 * Edx: 7C90EB94: 24A48DC3 00000000 0024648D 90909090 24548D90 C32ECD08 * Eip: 0087A90E: 4D830088 75FFFFFC 0875FF0C E8E04D8B 0000002D 64F04D8B * Ebp: 029468D0: 029470F0 0087C41F 42C2C098 02947254 029474D9 77C3F931 * SegCs: 0000001B: * EFlags: 00010246: 006C0069 00730065 0053005C 00650069 0065006D 0073006E * Esp: 029468A4: 42C2C3C0 00000000 42C2C098 029468EC 42C2C000 029468A4 * SegSs: 00000023: * ******************************************************************************** -------------------------------------------------------------------------------* Short Stack Dump* 0087A90E Module(sqlservr+0047A90E) (GetOSErrString+00003BDB)* 0087C41F Module(sqlservr+0047C41F) (GetOSErrString+000056EC)* 00931097 Module(sqlservr+00531097) (CDStream:umpBytesHex+000A9840)* 0085C2C1 Module(sqlservr+0045C2C1) (CDStream:perator=+00065529)* 0050A17A Module(sqlservr+0010A17A)* 0050A0BF Module(sqlservr+0010A0BF)* 0050A016 Module(sqlservr+0010A016)* 008D048F Module(sqlservr+004D048F) (CDStream:umpBytesHex+00048C38)* 0085D84B Module(sqlservr+0045D84B) (CDStream:perator=+00066AB3)* 005100FF Module(sqlservr+001100FF)* 0050F152 Module(sqlservr+0010F152)* 00519C2D Module(sqlservr+00119C2D)* 00829863 Module(sqlservr+00429863) (CDStream:perator=+00032ACB)* 005196A1 Module(sqlservr+001196A1)* 00518066 Module(sqlservr+00118066)* 41074698 Module(UMS+00004698) (UmsThreadScheduler::~UmsThreadScheduler+00000198)* 542868FF Module(UNKNOWN+00000000)* -------------------------------------------------------------------------------2007-07-09 15:48:44.17 spid3 SQL Server Assertion: File: <logscan.cpp>, line=3282 Failed Assertion = 'm_lastLSN == NullLSN || startLSN < m_lastLSN'.2007-07-09 15:48:44.17 spid3 Location: logscan.cpp:3282Expression: m_lastLSN == NullLSN || startLSN < m_lastLSNSPID: 3Process ID: 23242007-07-09 15:48:44.20 spid3 Error: 9004, Severity: 23, State: 72007-07-09 15:48:44.20 spid3 An error occurred while processing the log for database 'msdb'..2007-07-09 15:48:44.20 spid3 Error: 3414, Severity: 21, State: 12007-07-09 15:48:44.20 spid3 Database 'msdb' (database ID 4) could not recover. Contact Technical Support..2007-07-09 15:48:44.20 spid3 Recovery complete.2007-07-09 15:48:44.20 spid3 SQL global counter collection task is created.2007-07-09 15:49:21.09 spid51 Starting up database 'Baling'.2007-07-09 15:49:21.18 spid51 Starting up database 'WWAlmDb'.2007-07-09 15:49:21.29 spid51 Starting up database 'Baling'.2007-07-09 15:49:21.39 spid51 Starting up database 'WWAlmDb'.2007-07-09 15:51:11.90 spid53 Starting up database 'Baling'.2007-07-09 15:51:11.96 spid53 Starting up database 'WWAlmDb'.2007-07-09 15:51:33.82 spid52 Error: 15457, Severity: 0, State: 12007-07-09 15:51:33.82 spid52 Configuration option 'allow updates' changed from 0 to 1. Run the RECONFIGURE statement to install..2007-07-09 15:51:33.89 spid52 Error: 15457, Severity: 0, State: 12007-07-09 15:51:33.89 spid52 Configuration option 'allow updates' changed from 1 to 0. Run the RECONFIGURE statement to install..
View 7 Replies
View Related
Sep 21, 2007
Dear Experts,
I'm using sql server 2005, and now i'm trying to restore with one backup. then i'm getting error saying that MSDB database in suspect mode.
how to make the DB to the normal mode....
please help me in this regard
Vinod
Even you learn 1%, Learn it with 100% confidence.
View 1 Replies
View Related
Jul 20, 2005
HiI have a problem creating a backup in SQL Server 6.5. Although, thebackup produced does restore ok, I want to stop this error messageappearing everytime I make a backup. The error message is:"[SQL Server ]Can't allocate space for object 'sysbackupdetail' indatabase 'msdb' because the 'default' segment is full. If you ran outof space in Syslogs, dump the transaction log. Otherwise, use ALTERDATABASE or sp_extendsegment to increase the size of the segment."this articles appears to describe the problem and the solution:http://support.microsoft.com/defaul...kb;EN-US;152354It recommends creating a stored procedure to delete old entries. Thestored procedure cannot be created due tro a memory problem. What Iwas wondering, although the article doesn't mention it, can a newdevice be created and added to the msdb database. This should fix theproblem or is there problems doing this ?Thanks in advance
View 1 Replies
View Related
Jul 26, 2007
When I try to delete a job from Enterprise Manager Console I get the following error:
Erro 644: Could not find the index entry for RID '163bd10000010000' in index page (1:553), index ID 0 database 'msdb'
Oh and this is on MSDE.
Here is my complete output of DBCC CHECKDB
DBCC results for 'msdb'.
DBCC results for 'sysobjects'.
There are 280 rows in 6 pages for object 'sysobjects'.
DBCC results for 'sysindexes'.
There are 143 rows in 6 pages for object 'sysindexes'.
DBCC results for 'syscolumns'.
There are 1567 rows in 26 pages for object 'syscolumns'.
DBCC results for 'systypes'.
There are 26 rows in 1 pages for object 'systypes'.
DBCC results for 'syscomments'.
There are 357 rows in 108 pages for object 'syscomments'.
DBCC results for 'sysfiles1'.
There are 2 rows in 1 pages for object 'sysfiles1'.
DBCC results for 'syspermissions'.
There are 116 rows in 1 pages for object 'syspermissions'.
DBCC results for 'sysusers'.
There are 13 rows in 1 pages for object 'sysusers'.
DBCC results for 'sysproperties'.
There are 0 rows in 0 pages for object 'sysproperties'.
DBCC results for 'sysdepends'.
There are 1635 rows in 8 pages for object 'sysdepends'.
DBCC results for 'sysreferences'.
There are 12 rows in 1 pages for object 'sysreferences'.
DBCC results for 'sysfulltextcatalogs'.
There are 0 rows in 0 pages for object 'sysfulltextcatalogs'.
DBCC results for 'sysfulltextnotify'.
There are 0 rows in 0 pages for object 'sysfulltextnotify'.
DBCC results for 'sysfilegroups'.
There are 1 rows in 1 pages for object 'sysfilegroups'.
DBCC results for 'backupset'.
There are 1045 rows in 44 pages for object 'backupset'.
DBCC results for 'sysjobschedules'.
There are 7 rows in 1 pages for object 'sysjobschedules'.
DBCC results for 'syscategories'.
There are 19 rows in 1 pages for object 'syscategories'.
DBCC results for 'systargetservers'.
There are 0 rows in 0 pages for object 'systargetservers'.
DBCC results for 'backupfile'.
There are 1451 rows in 24 pages for object 'backupfile'.
DBCC results for 'systargetservergroups'.
There are 0 rows in 0 pages for object 'systargetservergroups'.
DBCC results for 'systargetservergroupmembers'.
There are 0 rows in 0 pages for object 'systargetservergroupmembers'.
DBCC results for 'restorehistory'.
There are 1 rows in 1 pages for object 'restorehistory'.
DBCC results for 'sysalerts'.
There are 9 rows in 1 pages for object 'sysalerts'.
DBCC results for 'sysoperators'.
There are 0 rows in 0 pages for object 'sysoperators'.
DBCC results for 'sysnotifications'.
There are 0 rows in 0 pages for object 'sysnotifications'.
DBCC results for 'restorefile'.
There are 2 rows in 1 pages for object 'restorefile'.
DBCC results for 'systaskids'.
There are 0 rows in 0 pages for object 'systaskids'.
DBCC results for 'syscachedcredentials'.
There are 0 rows in 0 pages for object 'syscachedcredentials'.
DBCC results for 'restorefilegroup'.
There are 1 rows in 1 pages for object 'restorefilegroup'.
DBCC results for 'logmarkhistory'.
There are 0 rows in 0 pages for object 'logmarkhistory'.
DBCC results for 'sysdtscategories'.
There are 3 rows in 1 pages for object 'sysdtscategories'.
DBCC results for 'sysdtspackages'.
There are 0 rows in 0 pages for object 'sysdtspackages'.
DBCC results for 'sysdtspackagelog'.
There are 0 rows in 0 pages for object 'sysdtspackagelog'.
DBCC results for 'sysdtssteplog'.
Server: Msg 8935, Level 16, State 1, Line 1
Table error: Object ID 2073058421, index ID 1. The previous link (1:343) on page (1:371) does not match the previous page (1:382) that the parent (1:300), slot 32 expects for this page.
Server: Msg 8978, Level 16, State 1, Line 1
Table error: Object ID 2073058421, index ID 1. Page (1:371) is missing a reference from previous page (1:343). Possible chain linkage problem.
There are 0 rows in 0 pages for object 'sysdtssteplog'.
DBCC results for 'sysdtstasklog'.
There are 0 rows in 0 pages for object 'sysdtstasklog'.
DBCC results for 'sysdbmaintplans'.
There are 4 rows in 1 pages for object 'sysdbmaintplans'.
DBCC results for 'sysdbmaintplan_jobs'.
There are 4 rows in 1 pages for object 'sysdbmaintplan_jobs'.
DBCC results for 'sysdbmaintplan_databases'.
There are 12 rows in 1 pages for object 'sysdbmaintplan_databases'.
DBCC results for 'sysdbmaintplan_history'.
There are 724 rows in 23 pages for object 'sysdbmaintplan_history'.
DBCC results for 'log_shipping_primaries'.
There are 0 rows in 0 pages for object 'log_shipping_primaries'.
DBCC results for 'log_shipping_secondaries'.
There are 0 rows in 0 pages for object 'log_shipping_secondaries'.
DBCC results for 'mswebtasks'.
There are 0 rows in 0 pages for object 'mswebtasks'.
DBCC results for 'sqlagent_info'.
There are 0 rows in 0 pages for object 'sqlagent_info'.
DBCC results for 'sysdownloadlist'.
There are 0 rows in 0 pages for object 'sysdownloadlist'.
DBCC results for 'backupmediaset'.
There are 1045 rows in 11 pages for object 'backupmediaset'.
DBCC results for 'sysjobhistory'.
Server: Msg 8935, Level 16, State 1, Line 1
Table error: Object ID 2073058421, index ID 1. The previous link (1:382) on page (1:564) does not match the previous page (1:371) that the parent (1:300), slot 33 expects for this page.
There are 626 rows in 208 pages for object 'sysjobhistory'.
CHECKDB found 0 allocation errors and 3 consistency errors in table 'sysjobhistory' (object ID 2073058421).
DBCC results for 'sysjobs'.
There are 7 rows in 1 pages for object 'sysjobs'.
DBCC results for 'backupmediafamily'.
There are 1045 rows in 20 pages for object 'backupmediafamily'.
DBCC results for 'sysjobservers'.
There are 7 rows in 1 pages for object 'sysjobservers'.
DBCC results for 'sysjobsteps'.
There are 9 rows in 1 pages for object 'sysjobsteps'.
CHECKDB found 0 allocation errors and 3 consistency errors in database 'msdb'.
repair_rebuild is the minimum repair level for the errors found by DBCC CHECKDB (msdb ).
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
View 1 Replies
View Related
Oct 20, 2006
We are running SQL Server 2000, SP4. I recently noticed that my DTS packages were missing from the local server. Since I had saved them as Structure Storage Files, I imported them back into DTS Local Packages. That was yesterday. Today I opened the Meta Data browser to see what was in it. (We don't use Meta Data Services.) It displayed a message:"An error occurred while trying to access the database information. The msdb database could not be opened." These (restore of DTS pkgs and Meta Data error) may not be related, but I need to know why I am getting this error, because I am about to upgrade to SQL Server 2005 for Workgroups.
1. Does anyone know what causes this error message?
2. Are local DTS packages stored in the MSDB database?
View 1 Replies
View Related
Mar 18, 2008
How to move master , model and msdb database to some other location. Can we overwrite the master, model and msdb files
View 8 Replies
View Related
Aug 7, 2002
Any idea what this error is?
error 911: could not locate entry in sysdatabases for database 'msdb'. No entry found with that name
Thanks.
Sa
View 1 Replies
View Related
May 21, 2001
While checking the SQL server error logs, I notice that the pubs and msdb database are automatically being backed up, even though no job is set up to do so....in addition, its backing up to a directory that I cannot find on our network.....does anybody have an idea of whats going on ?
the path its backingup to is:
(FILE=1, TYPE=PIPE: {'.pipedbasql70dbagent0s0'}).
Thank you in advance
View 1 Replies
View Related
May 31, 2007
Hi All,
I'm just upgrading my business database to SQL 2005 and hit a problem when executing a stored procedure in the msdb database. Error message reading "EXECUTE permission denied on object 'sp_delete_job'".
Obviously this message tells me that I do not have permissions to execute stored procedures in the MSDB database.
In SQL 2000 I never had to mess around with permissions on this database as the security was already pre-configured.
I'm still familiarising myself with SQL 2005 so rather than making a finger in the air guess I'd like to understand how SQL 2000 was configured and the best solution for resolving this in SQL2005.
I'm really after some advice/suggestions!
View 5 Replies
View Related
Jul 10, 2015
I've just imported some SSIS packages onto my instance but my users aren't able to run the jobs for these packages (if thats the write terminology) it keeps failing with this error: Non-SysAdmins have been denied permission to run DTS Execution job steps without a proxy account. The step failed.
I've been looking around and I've been told I can assign the logins to the database roles in msdb but when I look for the roles in msdb they don't exist. SSIS is definitely installed on the server. How do I go about getting these added?
View 2 Replies
View Related
