Installing SQL 2005 install in progress sertup error :
"Microsoft SQL Server 2005 Setup The cabinet file 'Sql.cab' required for this installation is
corrupt and cannot be used"I get the same error. Anyone have any idea what causes this?
Thanks.
Marcus
"Diamondas" wrote:
> Installing SQL 2005 install in progress sertup error :
> "Microsoft SQL Server 2005 Setup The cabinet file 'Sql.cab' required for this installation is
> corrupt and cannot be used"
>
>sql
Showing posts with label setup. Show all posts
Showing posts with label setup. Show all posts
Friday, March 30, 2012
Microsoft SQL Server 2005 Setup Problem
i keep getting this message whenever i double click the setup for sql server 2005. i previously installed the sql server 2005 beta 2 and have since deleted it. i've followed the readme on uninstalling some of the beta components and tried running some program i got from microsoft.com which would uninstal the pre release- the program doesn't detect any pre-release component. i however continue to get this message and need help resolving it.
TITLE: Microsoft SQL Server 2005 Setup
SQL Server 2005 Setup has detected incompatible components from beta versions of Visual Studio, .NET Framework, or SQL Server 2005. Use Add or Remove Programs to remove these components, and then run SQL Server 2005 Setup again. For detailed instructions on uninstalling SQL Server 2005, see the SQL Server 2005 Readme.
For help, click: http://go.microsoft.com/fwlink?LinkID=20476&ProdName=Microsoft+SQL+Server&ProdVer=9.00.2047.00&EvtSrc=setup.rll&EvtID=50000&EvtType=setup%5csqlsetupactions.cpp%40PerformSCCAction2%40sqls%3a%3aPerformSCCAction%3a%3aperform%400x11190
BUTTONS:
OK
Here are several references. Check the ones you haven't previously explored.
Remove -Error message when you install SQL Server 2005: "Beta components detected"
http://support.microsoft.com/?kbid=919394
Remove -How do I remove previous versions of SQL Server 2005 / Whidbey?
http://www.aspfaq.com/sql2005/show.asp?id=15
Remove -How to uninstall an instance of SQL Server 2005 manually
http://support.microsoft.com/?kbid=909967
Remove -How to Uninstall MSDE
http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q290991
Remove -How to Uninstall SQL Server 2005 Beta
http://go.microsoft.com/?linkid=1396133
Remove -How to uninstall SQL Server Management Studio
http://support.microsoft.com/default.aspx?scid=kb;EN-US;909953
Remove -How to use the Add or Remove Programs item in Control Panel to add
or remove components for stand-alone installations and clustered
installations of SQL Server 2005 (KB: 922670)
http://support.microsoft.com/default.aspx?scid=kb;EN-US;922670
Remove -How to: Uninstall SQL Server Express
http://msdn2.microsoft.com/en-us/library/ms143505.aspx
Remove -The error is: Fatal error during installation"
http://support.microsoft.com/?kbid=919945
Remove -Uninstall Applications NOT in Install/Remove Programs List
http://blogs.msdn.com/astebner/archive/2005/10/30/487096.aspx
Try the Windows Installer clean up tool first.
http://download.microsoft.com/download/E/9/D/E9D80355-7AB4-45B8-80E8-983A48D5E1BD/msicuu2.exe
THE INSTALLER WORKED FOR ME - -THANKS
Microsoft SQL Server 2005 Setup
i keep getting this message whenever i double click the setup for sql server 2005. i previously installed the sql server 2005 beta 2 and have since deleted it. i've followed the readme on uninstalling some of the beta components and tried running some program i got from microsoft.com which would uninstal the pre release- the program doesn't detect any pre-release component. i however continue to get this message and need help resolving it.
TITLE: Microsoft SQL Server 2005 Setup
SQL Server 2005 Setup has detected incompatible components from beta versions of Visual Studio, .NET Framework, or SQL Server 2005. Use Add or Remove Programs to remove these components, and then run SQL Server 2005 Setup again. For detailed instructions on uninstalling SQL Server 2005, see the SQL Server 2005 Readme.
For help, click: http://go.microsoft.com/fwlink?LinkID=20476&ProdName=Microsoft+SQL+Server&ProdVer=9.00.2047.00&EvtSrc=setup.rll&EvtID=50000&EvtType=setup%5csqlsetupactions.cpp%40PerformSCCAction2%40sqls%3a%3aPerformSCCAction%3a%3aperform%400x11190
BUTTONS:
OK
Here are several references. Check the ones you haven't previously explored.
Remove -Error message when you install SQL Server 2005: "Beta components detected"
http://support.microsoft.com/?kbid=919394
Remove -How do I remove previous versions of SQL Server 2005 / Whidbey?
http://www.aspfaq.com/sql2005/show.asp?id=15
Remove -How to uninstall an instance of SQL Server 2005 manually
http://support.microsoft.com/?kbid=909967
Remove -How to Uninstall MSDE
http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q290991
Remove -How to Uninstall SQL Server 2005 Beta
http://go.microsoft.com/?linkid=1396133
Remove -How to uninstall SQL Server Management Studio
http://support.microsoft.com/default.aspx?scid=kb;EN-US;909953
Remove -How to use the Add or Remove Programs item in Control Panel to add
or remove components for stand-alone installations and clustered
installations of SQL Server 2005 (KB: 922670)
http://support.microsoft.com/default.aspx?scid=kb;EN-US;922670
Remove -How to: Uninstall SQL Server Express
http://msdn2.microsoft.com/en-us/library/ms143505.aspx
Remove -The error is: Fatal error during installation"
http://support.microsoft.com/?kbid=919945
Remove -Uninstall Applications NOT in Install/Remove Programs List
http://blogs.msdn.com/astebner/archive/2005/10/30/487096.aspx
Try the Windows Installer clean up tool first.
http://download.microsoft.com/download/E/9/D/E9D80355-7AB4-45B8-80E8-983A48D5E1BD/msicuu2.exe
THE INSTALLER WORKED FOR ME - -THANKS
Microsoft SQL Server 2005 install problem.........
when i install the SQL server 2005, it occured the follow message:
Product: Microsoft SQL Server 2005 CTP -- Error 29628. The setup has
encountered an unexpected error in datastore. The action is
PrepareUpgradeDialog. The error is :Failed to find property "langId"
{"SetupStateScope", "", ""} in cache
No collector registered for scope: "SetupStateScope"
--
Posted using the http://www.dbforumz.com interface, at author's request
Articles individually checked for conformance to usenet standards
Topic URL: http://www.dbforumz.com/General-Dis...pict248148.html
Visit Topic URL to contact author (reg. req'd). Report abuse: http://www.dbforumz.com/eform.php?p=859943pinos (UseLinkToEmail@.dbForumz.com) writes:
> when i install the SQL server 2005, it occured the follow message:
> Product: Microsoft SQL Server 2005 CTP -- Error 29628. The setup has
> encountered an unexpected error in datastore. The action is
> PrepareUpgradeDialog. The error is :Failed to find property "langId"
> {"SetupStateScope", "", ""} in cache
> No collector registered for scope: "SetupStateScope"
Please post SQL 2005 questions in the SQL 2005 newsgroups, as these are
monitored by Microsoft staff. Access info here:
http://go.microsoft.com/fwlink/?linkid=31765.
Please also make sure that you have the latest build:
http://www.microsoft.com/sql/2005/productinfo/ctp.mspx.
For setup issues, it might even be better to file bugs at
http://lab.msdn.microsoft.com/ProductFeedback/, since the MS presence
in the setup groups have been spotty lately. However, you need to include
much more information. You get a hold bunch of logs with the SQL setup,
although I don't remember exactly where they are located. At a minimum,
you should include in which phase of the installtion this happens.
--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp
Microsoft SQL Server 2005 CTP Setup - Could not open a connection to SQL Server [2]
Hi,
Here is the error that I get during install. Does anyone have an idea how to solve this?
/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\
In the log file I can see the folowing information at the bottom:
Here is the error that I get during install. Does anyone have an idea how to solve this?
/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\
TITLE: Microsoft SQL Server 2005 CTP Setup
-
SQL Server Setup could not connect to the database service for server configuration. The error was: [Microsoft][SQL Native Client]Named Pipes Provider: Could not open a connection to SQL Server [2]. Refer to server error logs and setup logs for more information. For details on how to view setup logs, see "How to View Setup Log Files" in SQL Server Books Online.
For help, click: http://go.microsoft.com/fwlink?LinkID=20476&ProdName=Microsoft%20SQL%20Server&ProdVer=9.00.1116&EvtSrc=setup.rll&EvtID=29545&EvtType=lib%5Codbc_connection.cpp@.Do_sqlScript@.OdbcConnection::connect@.x80070002
-
BUTTONS:
&Retry
Cancel
-
In the log file I can see the folowing information at the bottom:
Doing Action: Do_sqlScript
PerfTime Start: Do_sqlScript : Thu Jun 16 08:15:46 2005
Service MSSQLSERVER with parameters '-m -Q -qSQL_Latin1_General_CP1_CI_AS -T4022 -T3659 -T3610 -T4010' is being started at Thu Jun 16 08:15:46 2005
SQL service MSSQLSERVER started successfully waiting for SQL service to accept client connections
Service MSSQLSERVER started at Thu Jun 16 08:16:10 2005
Loaded DLL:
C:\WINDOWS\system32\Odbc32.dll
Version:
3.525.1117.0
SQL_ERROR (-1) in OdbcConnection::connect
sqlstate=08001, level=-1, state=-1, native_error=2, msg=[Microsoft][SQL Native Client]Named Pipes Provider: Could not open a connection to SQL Server [2].
sqlstate=08001, level=-1, state=-1, native_error=2, msg=[Microsoft][SQL Native Client]Client unable to establish connection
sqlstate=HYT00, level=-1, state=-1, native_error=0, msg=[Microsoft][SQL Native Client]Login timeout expired
Error Code: 0x80070002 (2)
Windows Error Text: The system cannot find the file specified.
Source File Name: lib\odbc_connection.cpp
Compiler Timestamp: Fri Mar 18 08:21:13 2005
Function Name: OdbcConnection::connect
Source Line Number: 140
- Context --
Connecting to SQL Server
ExecuteSqlCommands
Originial error was 80070002 (2)
lScript
SqlScriptHlpr
Error Code: 2
MSI (s) (DC!54) [08:16:43:920]: Product: Microsoft SQL Server 2005 CTP -- Error 29545. SQL Server Setup could not connect to the database service for server configuration. The error was: [Microsoft][SQL Native Client]Named Pipes Provider: Could not open a connection to SQL Server [2]. Refer to server error logs and setup logs for more information. For details on how to view setup logs, see "How to View Setup Log Files" in SQL Server Books Online.
Error 29545. SQL Server Setup could not connect to the database service for server configuration. The error was: [Microsoft][SQL Native Client]Named Pipes Provider: Could not open a connection to SQL Server [2]. Refer to server error logs and setup logs for more information. For details on how to view setup logs, see "How to View Setup Log Files" in SQL Server Books Online.
<Func Name='GetCAContext'>
<EndFunc Name='GetCAContext' Return='T' GetLastError='203'>
Doing Action: Do_sqlScript
PerfTime Start: Do_sqlScript : Thu Jun 16 08:16:43 2005
Service MSSQLSERVER with parameters '-m -Q -qSQL_Latin1_General_CP1_CI_AS -T4022 -T3659 -T3610 -T4010' is being started at Thu Jun 16 08:16:43 2005
Attempt to start service when it is already running
SQL service MSSQLSERVER started successfully waiting for SQL service to accept client connections
Service MSSQLSERVER started at Thu Jun 16 08:16:43 2005
Loaded DLL:
C:\WINDOWS\system32\Odbc32.dll
Version:
3.525.1117.0
SQL_ERROR (-1) in OdbcConnection::connect
sqlstate=08001, level=-1, state=-1, native_error=2, msg=[Microsoft][SQL Native Client]Named Pipes Provider: Could not open a connection to SQL Server [2].
sqlstate=08001, level=-1, state=-1, native_error=2, msg=[Microsoft][SQL Native Client]Client unable to establish connection
sqlstate=HYT00, level=-1, state=-1, native_error=0, msg=[Microsoft][SQL Native Client]Login timeout expired
Error Code: 0x80070002 (2)
Windows Error Text: The system cannot find the file specified.
Source File Name: lib\odbc_connection.cpp
Compiler Timestamp: Fri Mar 18 08:21:13 2005
Function Name: OdbcConnection::connect
Source Line Number: 140
- Context --
Connecting to SQL Server
ExecuteSqlCommands
Originial error was 80070002 (2)
Do_sqlScript
SqlScriptHlpr
Error Code: 2
Probably better to ask this in the Setup/Upgrade group...
However, do you have SQL 2000 installed? If so are named pipes enabled in cli config? If not enable them and re-run setup.
-Euan|||Hey Edwin.
I just had this very same problem.
The way that I got around it was to run the SQL server install, and when it came up with this error I went into my services MMC snapin and restarted the SQL Server (MSSQLSERVER) service.
Then I pressed retry in the install window and it worked.
See if that helps
Cheers
Beric Holt
e-Media Ltd
Dunedin
New Zealand|||Hi Beric
work around suggested by you worked for me as well.thanks.|||
I had the similar issues, and this has been resolved by running command Setup\sqlncli.msi REINSTALL=ALL REINSTALLMODE=omus /qb.
More informations is available on link :http://download.microsoft.com/download/E/1/1/E1196B19-DE92-4AB2-BAFD-5B5AD26E67B4/AprilCTPNotes.mht
Thanks!
Wednesday, March 28, 2012
Microsoft SQL Express 2005 Installation Failure
I can get SQL SERVER 2005 to install it goes through the extracting files then gives me an error message that says "SQL Server Setup unexpectedly failed. for more information, review the setup summery log file " . I don't think i have any beta versons of Visual Studio or SQL I do have Accouting Express with has something with SQL I don't know if that will stop my installation. I really need SQL to work for my business.
Please Help ME!!!
Heres a copy of my log file:[SQLSetup0017_DSTRETCH_Core]
Microsoft SQL Server 2005 Setup beginning at Wed Apr 18 19:28:35 2007
Process ID : 5244
c:\84d9dbbedcbb7eee6c8eeabf58\setup.exe Version: 2005.90.3042.0
Running: LoadResourcesAction at: 2007/3/18 19:28:35
Complete: LoadResourcesAction at: 2007/3/18 19:28:35, returned true
Running: ParseBootstrapOptionsAction at: 2007/3/18 19:28:35
Loaded DLL:c:\84d9dbbedcbb7eee6c8eeabf58\xmlrw.dll Version:2.0.3609.0
Complete: ParseBootstrapOptionsAction at: 2007/3/18 19:28:35, returned false
Error: Action "ParseBootstrapOptionsAction" failed during execution. Error information reported during run:
Could not parse command line due to datastore exception.
Source File Name: utillib\persisthelpers.cpp
Compiler Timestamp: Wed Jun 14 16:30:14 2006
Function Name: writeEncryptedString
Source Line Number: 124
-
writeEncryptedString() failed
Source File Name: utillib\persisthelpers.cpp
Compiler Timestamp: Wed Jun 14 16:30:14 2006
Function Name: writeEncryptedString
Source Line Number: 123
-
Error Code: 0x80070002 (2)
Windows Error Text: The system cannot find the file specified.
Source File Name: cryptohelper\cryptsameusersamemachine.cpp
Compiler Timestamp: Wed Jun 14 16:28:04 2006
Function Name: sqls::CryptSameUserSameMachine:
Source Line Number: 50
2
Could not skip Component update due to datastore exception.
Source File Name: datastore\cachedpropertycollection.cpp
Compiler Timestamp: Wed Jun 14 16:27:59 2006
Function Name: CachedPropertyCollection::findProperty
Source Line Number: 130
-
Failed to find property "InstallMediaPath" {"SetupBootstrapOptionsScope", "", "5244"} in cache
Source File Name: datastore\propertycollection.cpp
Compiler Timestamp: Wed Jun 14 16:28:01 2006
Function Name: SetupBootstrapOptionsScope.InstallMediaPath
Source Line Number: 44
-
No collector registered for scope: "SetupBootstrapOptionsScope"
Running: ValidateWinNTAction at: 2007/3/18 19:28:35
Complete: ValidateWinNTAction at: 2007/3/18 19:28:35, returned true
Running: ValidateMinOSAction at: 2007/3/18 19:28:35
Complete: ValidateMinOSAction at: 2007/3/18 19:28:35, returned true
Running: PerformSCCAction at: 2007/3/18 19:28:35
Complete: PerformSCCAction at: 2007/3/18 19:28:35, returned true
Running: ActivateLoggingAction at: 2007/3/18 19:28:35
Error: Action "ActivateLoggingAction" threw an exception during execution. Error information reported during run:
Datastore exception while trying to write logging properties.
Source File Name: datastore\cachedpropertycollection.cpp
Compiler Timestamp: Wed Jun 14 16:27:59 2006
Function Name: CachedPropertyCollection::findProperty
Source Line Number: 130
-
Failed to find property "primaryLogFiles" {"SetupStateScope", "", ""} in cache
Source File Name: datastore\propertycollection.cpp
Compiler Timestamp: Wed Jun 14 16:28:01 2006
Function Name: SetupStateScope.primaryLogFiles
Source Line Number: 44
-
No collector registered for scope: "SetupStateScope"
02E7CFC0Unable to proceed with setup, there was a command line parsing error. : 2
Error Code: 0x80070002 (2)
Windows Error Text: The system cannot find the file specified.
Source File Name: datastore\propertycollection.cpp
Compiler Timestamp: Wed Jun 14 16:28:01 2006
Function Name: SetupBootstrapOptionsScope.InstallMediaPath
Source Line Number: 44
Class not registered.
Failed to create CAB file due to datastore exception
Source File Name: datastore\cachedpropertycollection.cpp
Compiler Timestamp: Wed Jun 14 16:27:59 2006
Function Name: CachedPropertyCollection::findProperty
Source Line Number: 130
-
Failed to find property "HostSetup" {"SetupBootstrapOptionsScope", "", "5244"} in cache
Source File Name: datastore\propertycollection.cpp
Compiler Timestamp: Wed Jun 14 16:28:01 2006
Function Name: SetupBootstrapOptionsScope.HostSetup
Source Line Number: 44
-
No collector registered for scope: "SetupBootstrapOptionsScope"
Message pump returning: 2
Can you search through your SQL install log directory for the text string "value 3" and post the 10 or so lines above that? It may give a more descriptive error message.
Thanks,
Sam Lester (MSFT)
Ah, I think it may be this issue. Can you read through this post and see if it applies to your situation.
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1117117&SiteID=1
Thanks,
Sam
Microsoft SQL Express 2005 Installation Failure
I can get SQL SERVER 2005 to install it goes through the extracting files then gives me an error message that says "SQL Server Setup unexpectedly failed. for more information, review the setup summery log file " . I don't think i have any beta versons of Visual Studio or SQL I do have Accouting Express with has something with SQL I don't know if that will stop my installation. I really need SQL to work for my business.
Please Help ME!!!
Heres a copy of my log file:[SQLSetup0017_DSTRETCH_Core]
Microsoft SQL Server 2005 Setup beginning at Wed Apr 18 19:28:35 2007
Process ID : 5244
c:\84d9dbbedcbb7eee6c8eeabf58\setup.exe Version: 2005.90.3042.0
Running: LoadResourcesAction at: 2007/3/18 19:28:35
Complete: LoadResourcesAction at: 2007/3/18 19:28:35, returned true
Running: ParseBootstrapOptionsAction at: 2007/3/18 19:28:35
Loaded DLL:c:\84d9dbbedcbb7eee6c8eeabf58\xmlrw.dll Version:2.0.3609.0
Complete: ParseBootstrapOptionsAction at: 2007/3/18 19:28:35, returned false
Error: Action "ParseBootstrapOptionsAction" failed during execution. Error information reported during run:
Could not parse command line due to datastore exception.
Source File Name: utillib\persisthelpers.cpp
Compiler Timestamp: Wed Jun 14 16:30:14 2006
Function Name: writeEncryptedString
Source Line Number: 124
-
writeEncryptedString() failed
Source File Name: utillib\persisthelpers.cpp
Compiler Timestamp: Wed Jun 14 16:30:14 2006
Function Name: writeEncryptedString
Source Line Number: 123
-
Error Code: 0x80070002 (2)
Windows Error Text: The system cannot find the file specified.
Source File Name: cryptohelper\cryptsameusersamemachine.cpp
Compiler Timestamp: Wed Jun 14 16:28:04 2006
Function Name: sqls::CryptSameUserSameMachine:
Source Line Number: 50
2
Could not skip Component update due to datastore exception.
Source File Name: datastore\cachedpropertycollection.cpp
Compiler Timestamp: Wed Jun 14 16:27:59 2006
Function Name: CachedPropertyCollection::findProperty
Source Line Number: 130
-
Failed to find property "InstallMediaPath" {"SetupBootstrapOptionsScope", "", "5244"} in cache
Source File Name: datastore\propertycollection.cpp
Compiler Timestamp: Wed Jun 14 16:28:01 2006
Function Name: SetupBootstrapOptionsScope.InstallMediaPath
Source Line Number: 44
-
No collector registered for scope: "SetupBootstrapOptionsScope"
Running: ValidateWinNTAction at: 2007/3/18 19:28:35
Complete: ValidateWinNTAction at: 2007/3/18 19:28:35, returned true
Running: ValidateMinOSAction at: 2007/3/18 19:28:35
Complete: ValidateMinOSAction at: 2007/3/18 19:28:35, returned true
Running: PerformSCCAction at: 2007/3/18 19:28:35
Complete: PerformSCCAction at: 2007/3/18 19:28:35, returned true
Running: ActivateLoggingAction at: 2007/3/18 19:28:35
Error: Action "ActivateLoggingAction" threw an exception during execution. Error information reported during run:
Datastore exception while trying to write logging properties.
Source File Name: datastore\cachedpropertycollection.cpp
Compiler Timestamp: Wed Jun 14 16:27:59 2006
Function Name: CachedPropertyCollection::findProperty
Source Line Number: 130
-
Failed to find property "primaryLogFiles" {"SetupStateScope", "", ""} in cache
Source File Name: datastore\propertycollection.cpp
Compiler Timestamp: Wed Jun 14 16:28:01 2006
Function Name: SetupStateScope.primaryLogFiles
Source Line Number: 44
-
No collector registered for scope: "SetupStateScope"
02E7CFC0Unable to proceed with setup, there was a command line parsing error. : 2
Error Code: 0x80070002 (2)
Windows Error Text: The system cannot find the file specified.
Source File Name: datastore\propertycollection.cpp
Compiler Timestamp: Wed Jun 14 16:28:01 2006
Function Name: SetupBootstrapOptionsScope.InstallMediaPath
Source Line Number: 44
Class not registered.
Failed to create CAB file due to datastore exception
Source File Name: datastore\cachedpropertycollection.cpp
Compiler Timestamp: Wed Jun 14 16:27:59 2006
Function Name: CachedPropertyCollection::findProperty
Source Line Number: 130
-
Failed to find property "HostSetup" {"SetupBootstrapOptionsScope", "", "5244"} in cache
Source File Name: datastore\propertycollection.cpp
Compiler Timestamp: Wed Jun 14 16:28:01 2006
Function Name: SetupBootstrapOptionsScope.HostSetup
Source Line Number: 44
-
No collector registered for scope: "SetupBootstrapOptionsScope"
Message pump returning: 2
Can you search through your SQL install log directory for the text string "value 3" and post the 10 or so lines above that? It may give a more descriptive error message.
Thanks,
Sam Lester (MSFT)
Ah, I think it may be this issue. Can you read through this post and see if it applies to your situation.
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1117117&SiteID=1
Thanks,
Sam
Saturday, February 25, 2012
Messages stopped appearing in Queue!
I recently restored my database from a backup and it seems that something in my service broker setup has stopped working, no messages now appear.
I checked that the broker was enabled (it wasnt and i had to use NEW_BROKER because of the 'same id' message)
The database is still set to trustyworthy.
There are also no messages in sys.transmission_queue
I used profiler with all the broker events enabled and the result was as follows:
Broker:Conversation Group
Broker:Conversation STARTED_OUTBOUND
Broker:Conversation CONVERSING
Broker:Message Classify
Broker:Conversation CLOSED
Broker:Conversation Group
Broker:Message Classify
But i'm not sure whether this highlights a problem or not? Any help gratefully appreciated!!
Thanks,
Andy
Hi,
I had the complete conversation - including the end of the conversation - in a stored procedure.
This was the reason i wasn't getting anything in sys.transmission_queue - i didnt end the conversation and the error appeared.
It turned out to be a permissions thing as when i'd restored the database it had set the owner to [SA]
Sorry for wasting your time if you'd bothered to read my problem!
Cheers,
Andy
Messages stopped appearing in Queue!
I recently restored my database from a backup and it seems that something in my service broker setup has stopped working, no messages now appear.
I checked that the broker was enabled (it wasnt and i had to use NEW_BROKER because of the 'same id' message)
The database is still set to trustyworthy.
There are also no messages in sys.transmission_queue
I used profiler with all the broker events enabled and the result was as follows:
Broker:Conversation Group
Broker:Conversation STARTED_OUTBOUND
Broker:Conversation CONVERSING
Broker:Message Classify
Broker:Conversation CLOSED
Broker:Conversation Group
Broker:Message Classify
But i'm not sure whether this highlights a problem or not? Any help gratefully appreciated!!
Thanks,
Andy
Hi,
I had the complete conversation - including the end of the conversation - in a stored procedure.
This was the reason i wasn't getting anything in sys.transmission_queue - i didnt end the conversation and the error appeared.
It turned out to be a permissions thing as when i'd restored the database it had set the owner to [SA]
Sorry for wasting your time if you'd bothered to read my problem!
Cheers,
Andy
Subscribe to:
Posts (Atom)