Still Error In Service Listing Manager....
Sep 20, 2006
Hi Remus:
I am using latest ServiceListingManager v1.1.3 and still getting this error....
Msg 6522, Level 16, State 1, Procedure ssb_create_certificate_from_blob, Line 0
A .NET Framework error occurred during execution of user defined routine or aggregate 'ssb_create_certificate_from_blob':
System.Data.SqlClient.SqlException: A certificate with name 'CMA_sbuser' already exists or this certificate already has been added to the database.System.Data.SqlClient.SqlException: at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.SqlInternalConnectionSmi.EventSink.ProcessMessagesAndThrow(Boolean ignoreNonFatalMessages)
at Microsoft.SqlServer.Server.SmiEventSink_Default.ProcessMessagesAndThrow(Boolean ignoreNonFatalMessages)
at System.Data.SqlClient.SqlCommand.RunExecuteNonQuerySmi(Boolean sendToPipe)
at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at Microsoft.SqlServiceBroker.Samples.CertificatesBlob.CertificatesBlob.ssb_create_certificate_from_blob(SqlString databaseName, SqlString certificateName, SqlString authorizationUser, SqlBinary certificateBody)
Help is greatly appreciated....
Thanks,
Pramod
View 4 Replies
ADVERTISEMENT
Aug 21, 2006
Hi Remus - Thank you for your Service Listing utility. I am very new to S.B. I had an intern working for us do some research work into S.B. and I gave him your utility to use for the work I gave him to do. Here is what I am trying to do. Very simply, I want to setup a remote (target) server that many other source (initiator) servers will send messages to via S.B. I had the intern learn how to have a single initiator server send messages to the remote server. He used your utility to create the SQL script that needs to be run on both servers to get things set up, and it works correctly.
The script below is what your utility created to be run on the remote server. The reference to 'SDDev2' below is a reference to the initiator (source) server my intern was working against. Not knowing much about S.B., my concern by looking at the T-SQL below is that when creating the required objects on the remote server, we are hard-coding a reference to a single initiator server ('SDDev2'). However, I need to be able to support messages coming from hundreds of initiator servers. What, if anything, do I need to do or change to support this?
Thanks very much - Amos
The TSQL script from your utility is below:
USE [master];
GO
CREATE LOGIN [SDDEV2] WITH PASSWORD = '6p}J4saGX=*b9Z';
ALTER LOGIN [SDDEV2] DISABLE;
CREATE USER [SDDEV2] FROM LOGIN [SDDEV2];
GO
declare @dbname sysname;
select @dbname = DB_NAME();
exec msdb.dbo.ssb_create_certificate_from_blob @dbname, 'SDDEV2','SDDEV2',0x308201BF30820128A003020102021089C68EF17EAA289B42BB56454CA195D7300D06092A864886F70D0101050500301E311C301A06035504031313506572736F6E4164647265737353656E646572301E170D3036303831343030303030305A170D3037303831353030303030305A301E311C301A06035504031313506572736F6E4164647265737353656E64657230819F300D06092A864886F70D010101050003818D0030818902818100BCFD0F7BEE09988F08B0AED98A750795755CB35207C2DA7A2F69618ECD8118CE885E7EBFE644263EE397B72ABB14DFA67E2C4518D6C37B021D1CDDBC1E9E7B8C33AA622FA2DE3474B3529A2F165ED791DFC31E930D6C7E65EB49B4F3162A2CD94B43D6BE4DBE792D11A4F7FFA7DE5DC82329CE683D18D90C6A8108F50D601BE10203010001300D06092A864886F70D01010505000381810041ED85516EF68F21CE0538F4A6D5F6BDF8AF76BFF509FE84FEC173D7EB19AA310E383285C501BDFF1F1A7AD69F404C6F8F7A9653B191062249ADAE85AD5F2ED073F197E4FB06DEA5B19BD80577F85518924640A40F0FE1481292C6E4F4F9ED5A52AB960A41A47D5501EC512BEF71135A1AA05BD29151466D29B41B921575B865;
GO
GRANT CONNECT ON ENDPOINT::[BROKER] TO [SDDEV2];
GO
USE [AdventureWorks_Tim];
GO
IF NOT EXISTS (SELECT * FROM sys.certificates WHERE thumbprint = 0xF6FD43253A7DD7AB1562FAA3F8BD03C0532E45EE)
BEGIN
CREATE USER [Proxy::PersonAddressSender] WITHOUT LOGIN;
declare @dbname sysname;
select @dbname = DB_NAME();
exec msdb.dbo.ssb_create_certificate_from_blob @dbname, 'CN=PersonAddressSender::7DD56F1CFAB41F9C4A46DA13368EB879','Proxy::PersonAddressSender',0x308201BF30820128A00302010202107DD56F1CFAB41F9C4A46DA13368EB879300D06092A864886F70D0101050500301E311C301A06035504031313506572736F6E4164647265737353656E646572301E170D3036303831363030303030305A170D3037303831373030303030305A301E311C301A06035504031313506572736F6E4164647265737353656E64657230819F300D06092A864886F70D010101050003818D0030818902818100B31EC8E14AF32003FBCEE27C201A8BAC9F34797DB1D6AB1405DEBE73807BEBB9A5536009B5A1A4A28D4461D51B488FBD7AF4D2F8C8A956F4186F05CA50C541B90B243C6CF4826A5DCE3A22E9FAC263D7407611E537031E67EC8318A90FE3789783C5F87179294E17CDE2C3DBED3F95353B089BA4FBC098FF36F2177F3627AE530203010001300D06092A864886F70D01010505000381810092C058712A17533D8A8C44D53863121D4108B982AE456093A1C95CDD37BE446122B117662785B5F151C21F70C948F686CB3CC5895000AE5D107EF0371373F9ED8EC43A227ECAFF79C57F740981D726E6511C3377BFE7B4CEE94CEF30EEDC4ACA43BCAD56A626A563F1B733666CB74A4122B7084C853E9F8D5EA0DBB224DC2DD3;
END
GO
DECLARE @certificateOwner sysname;
DECLARE @sql nvarchar(4000);
SELECT @certificateOwner = p.name
FROM sys.database_principals p
JOIN sys.certificates c ON c.principal_id = p.principal_id
WHERE c.thumbprint = 0xF6FD43253A7DD7AB1562FAA3F8BD03C0532E45EE;
SELECT @sql = N'GRANT SEND ON SERVICE::[PersonAddressReceiver] TO ' + QUOTENAME(@certificateOwner);
EXEC sp_executesql @sql;
GO
CREATE ROUTE [Route::PersonAddressSender,C73507DF-0914-4DF5-8074-14A8A00060D3] WITH
SERVICE_NAME = 'PersonAddressSender',
BROKER_INSTANCE = 'C73507DF-0914-4DF5-8074-14A8A00060D3',
ADDRESS = 'tcp://SDDEV2:4022';
GO
View 9 Replies
View Related
Oct 26, 2007
I have installed the SQL Standard Client install on my laptop which has windows xpp using the following batch file.
Start /wait setup.exe /qn ADDLOCAL=SQL_DTS,Client_Components,Connectivity,SQL_Tools90,SDK,SQL_WarehouseDevWorkbench,SQLXML,Tools_Legacy,SQL_Documentation,SQL_BooksOnline
I am yet to connect to any datasource on my SSIS package. But when I right click on the connection Managers box in my SSIS project and select €œNew OLE DB Connection€? (or any other connection type), I get an Error as below. Please Help to resolve this error.
The new connection manager could not be created.
Additional information:
The service System.Windows.Forms.Design.IUIService could not be located.
(Microsoft.DataTransforamtionServices.Design).
View 4 Replies
View Related
Apr 27, 2006
SSIS doesn`t start after applying SQL Server 2005 SP1
I get an error Message in event log
event id 7000 source: Service Control Manager Type: Error
Message:
The SQL Server Integration Services service failed to start due to the following error:
The service did not respond to the start or control request in a timely fashion.
For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
regards
Lothar Belle
View 4 Replies
View Related
Jul 20, 2005
On one of our machines, all of the SQL Server 2000components except for the main Server component (SQL Servercore) itself were installed (Management tools, etc) a while agoand everything was running fine. Now I go and add/install theServer component and then Service Pack 3a.It seems that Service Manager won't start up (I get an hourglass cursor)and now I find that Enterprise Manager won't run as well. No errormessages appeared and I don't think I saw anything unusual inthe log file.However, I can use Enterprise Manager on a differentmachine and connect to the database (so the databaseitself seems to be running).Any suggestions as to what the problem might be and how tofix it? I like to see if I can repair this without havingto do a reinstall.Thanks.PF
View 2 Replies
View Related
Dec 6, 2006
IF someone can assist me. Everytime I load up enterprise manager the service manager turns off. And the enterprise manager can't connect to the local database. But everytime i turn it back on and try to connect again it shuts it off and around and around we go. Help would be appreciated. Thanks.
View 2 Replies
View Related
Jun 9, 2005
Is there a list of all the SSIS Error codes and what they
View 15 Replies
View Related
Dec 27, 2007
Hi,
I am working on SQL Server 2005 (x64) with Windows Server 2003 (x64) operating system. I am having a major issue in SSIS. Here is the detailed explanation of the issue :
I have an EXCEL file in 2003 / 2007 version. It contains some data. I want to import the data using SSIS into SQL Server 2005 (x64) database table. I have taken "EXCEL FILE SOURCE" and "SQL Server DESTINATION". It was failed on importing data. Surprisingly it works fine in SQL Server 2005 (x32). Can you please explain why it is NOT woking on (x64) ?
Here is the error code i am getting:
[Excel Source [1]] Error: The AcquireConnection method call to the connection manager "Excel Connection Manager" failed with error code 0xC0202009.
Appreciate your time and patience !!
Thanks
View 3 Replies
View Related
May 28, 2008
I'm having a hard time locating a listing of potential error codes and the meanings for the Execute Process Task component...can someone assist?
Thanks
View 1 Replies
View Related
May 29, 2007
I have an SQL DB that resides on a server in my office, but when I try to connect a workstation to the DB with SQL Service Manager, I can't. The server is listed, but the drop down menu for the services is blank. If I click on the Start button, I get an error that a service has to be selected. Any ideas?
View 1 Replies
View Related
Jul 18, 2006
I opened up Terminal Service Manager on my SQL Server to close out someghost connections. Then I minimized the application. After working onsome other issues. I right clicked on the minimized icon of TerminalService Manager on my tool bar and closed it. Now when I go toStart/Admin Tools/Terminal Service Manager, it opens up minimized and Ican't get it to maximize to close out ghost connections. The only wayI can close it is to go to the task manager and kill it from there.I've rebooted my server and I still have this problem when I openTerminal Service Manager. Does anyone have a solution for this?
View 2 Replies
View Related
Oct 22, 2007
Where is the icon for the SQL Server Service Manager? I'm reading the Access 2003 Bible and I want to test accessing SQL Server, and I'm not sure where it installs that. Thanks!
View 8 Replies
View Related
May 24, 2007
I give up, how do you start the Analysis Manager? SSAS is installed and running, but I just can't seem to find the button/shortcut/whatever to start the manager.
View 6 Replies
View Related
Feb 19, 2006
When I open up the SQL Server Service Manager I see 3 Servers in the drop down list box.
The third one does not exist. How can I remove it from the drop down list box?
Thanks
View 1 Replies
View Related
Jun 22, 2004
Hi,
The SQL Service Manager is not running automatically despite that fact the the STartup type for the following service IS set to Automatic:
C:Program FilesMicrosoft SQL ServerMSSQLBinnsqlservr.exe -sMSSQLSERVER
When I start my PC and look at the taskbar (or is it better called the status bar), the service Manager appears with a big WHITE circle and when I get the tooltip it says:
"Unknown - \ - MSSQLServer"
Can someone please help me out.
View 1 Replies
View Related
Aug 3, 2004
I installed MSDE2000 with named instance on top of MSDE 7.0 and rebooted the system. The “SQL Server Service Manager” comes up with default server( MSDE7.0).
But I need “SQL Server Service Manager” has to come up with new instance name and the new server automatically after reboot.
I didn’t see any problem in connecting to instance name if I choose it from the server list. But user wants to see the server with instance name by default when system restarts. Do you have any idea about this?
Thank you,
Sri
View 4 Replies
View Related
Jun 22, 2004
Hi,
The SQL Service Manager is not running automatically despite that fact the the STartup type for the following service IS set to Automatic:
C:Program FilesMicrosoft SQL ServerMSSQLBinnsqlservr.exe -sMSSQLSERVER
When I start my PC and look at the taskbar (or is it better called the status bar), the service Manager appears with a big WHITE circle and when I get the tooltip it says that
"Unknown - \ - MSSQLServer"
Can someone please help me out.
View 1 Replies
View Related
Jun 30, 2004
Got an issue:
I am running SQL Server 7.0 on a Web server and recently the SQL Server has been acting up. Basically what happens is every time the server is restarted the Service Manager fails to restart. I even get an error telling me that the service failed to start. So, when I log back in I have to physically restart the Service Manager. I have the services set to start automatically. Can anyone direct me where to look...perhaps a SQL Server log that might give me a clue. My application and error logs only tell me that it stops. Any ideas?
View 2 Replies
View Related
Jan 18, 2006
I have uninstall MS SQL 2000 and installed MS SQL 2005, but i cant find nowhere the service manager to run the server
where is it ?
thank you
View 4 Replies
View Related
Jul 23, 2005
Folks,We're implementing a software based mirroring solution. This solutionrequires that the SQL Server service on the target server be stoppedwhile data is being replicated from the source server.One problem we encountered while testing was that the SQL ServerService on the target server was inadvertantly started when usersselected that server in Enterprise Manager. Is there any way to keepthe service from starting through Enterprise Manager?Thanks
View 2 Replies
View Related
Jul 23, 2005
I am running Win XP SP2 and MSDE 2000 SP3a. The user is logging on asa POWERUSER. When the user logs on the MSSQLSERVER service starts butthe SQL Server Service Manager, that runs in the system tray, showsthat the instance has not started. The field that displays theinstance name is blank and it is not listed in the drop down list.The MSSQLSERVER service is set to start with a Windows domainadministrator account. The SQL server can be accessed by a remotecomputer through Enterprise Manager. The local programs cannontinteract with the server though.Does anyone know if I could grant some user access rights to allow MSDEto work under a POWERUSER login?
View 2 Replies
View Related
Jul 20, 2005
SQL Server Enterprise Manager could not start the service 'MSDTC' on server'NTAS21'.1722 - (The RPC server is unavailable)I Setup A publication on a server called NTAS4D, then Pushed TheSubscription to another server called NTAS21. If I configure so that thechanges at the subscriber are not replicated to the publisher, all works ok,I make a change at the publisher, it is replicated to the subscriber.If I configure for updating at the subscriber, I am presented with a screenstating that the following services must be started for replication to work:SQL Server Agent on NTAS4D - RunningMSDTC on NTAS4D - RunningMSDTC on NTAS21 - UnknownWhen I complete the wizard, I receive the message listed above.The Servers are in two separate locations, each behind a NAT enabled routerusing the internet to transfer data between the publisher and subscriber.Any Suggestions will be greatly appreciated.ThanksSteve
View 1 Replies
View Related
Jun 5, 2006
Hi there. I am new to the SQL Express. I just finished installing the SQL Express 2005 with Advanced Services on a Windows XP SP2 computer. The first thing I noticed was the service manager (used to be on the taskbar) was being removed on the Express Edition. How do I get this feature back if it's even possible? I know you can find out the server status from the Configuration Manager but it's handy if the status is showned on the taskbar after logging in.
Any help will be greatly appreciated. Thank you.
KC
View 1 Replies
View Related
Jul 12, 2007
I have an almost virgin install of SQLExpres running on a WIN2K Pro system.
Have been able to create and connect db to Access 2000 without problem.
Now I wish to extend to remote connections. Using Surface Area Configuration tool, I changed Remote Connections to Local and Remote.
Whenever this setting contains TCP/IP and I try to restart the service I receive the following errors:
System Log:
The SQL Server (SQLEXPRESS) service terminated with service-specific error 10013.
Application Log:
Server TCP provider failed to listen on [ 'any' <ipv4> 0]. Tcp port is already in use.
TDSSNIClient initialization failed with error 0x271d, status code 0xa.
TDSSNIClient initialization failed with error 0x271d, status code 0x1.
Could not start the network library because of an internal error in the network library. To determine the cause, review the errors immediately preceding this one in the error log.
SQL Server could not spawn FRunCM thread. Check the SQL Server error log and the Windows event logs for information about possible related problems.
If I change back to Local Connections Only or Local and Remote using named pipes only, the service starts up again without a problem.
After five days of investigating, researching, reinstalling and waiting I have to ask for help.
Any suggestions or leads?
Thank You in advance.
View 14 Replies
View Related
Oct 10, 2007
Hi All,
We seem to be being plagued by the error below by our SQL Server agent. This happens almost everytime we restart the server that has been running for a day or two.
Our SQL Server Agent uses a none expiring domain credential. I understand that this problem only happens when the profile being used by the SQL Servr Agent has changed (password change). What puzzles me is that the login is A ok and no changes has been made to it's password.
We always resolve this problem by changing the login used in the SQL Server Agent to local and after that, returning it back to it's original domain login. Unfortunately, we cant always do this everytime something goes wrong.
Can anyone please help us shed a light on this? We're using SQL2k with SP3a. Thanks!
Error:
An error 1069 - )The service did not start due to logon failure) occurred while performing this service operation on the SQLServerAgent service.
Regards,
Joseph
View 29 Replies
View Related
Mar 24, 2008
I am using SSIS 2005 on Windows 2003 server. Using Excel Source to dump the data for staging database.
I am getting following error while I execute it through BI studio's execute button.
Please help.
- Sachin
View 2 Replies
View Related
Mar 11, 2008
I have deployed my packages into Sql Server and I am using Configuration File. As my Data Source is Excel, I have changed the connection string during deployment with Server Path. But I am getting the following errors. Actually the File Exist in Path. May I know What is cause of the issue? Do I need to give any permission to execute the package.
SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the connection manager "Excel Connection Manager" failed with error code 0xC0202009. There may be error messages posted before this with more information on why the AcquireConnection method call failed.
component "Excel Source Service Contract Upload" (1) failed validation and returned error code 0xC020801C.
One or more component failed validation.
There were errors during task validation.
DTS_E_OLEDBERROR, Error Code: 0x80004005 Source: "MS JET DB Engine" Description : Path is not valid
View 27 Replies
View Related
Nov 6, 2000
Hi
I have been getting this message in the event viwer and my SQL server goes down. I have to go and start the service once again. Can somebody throw some light as how to solve this problem?
Please respond.
Tks.
Zolla
View 3 Replies
View Related
Jul 20, 2005
ver: SQL-DMO Version: 8.00.760I have the option to automatically start SQL Server on startup, butwhen it does start up, the SQL Server Service Manager does not havethe green arrow indicating that it is active. When I double-click itto display the SQL Server Service Manager, it shows the name of theserver, but no services in the drop-down box.When I start Enterprise Manager I see an instance of MSDE wheresomeone installed an MSDE application. That is active. But I have to"connect" to the localhost. The instance name is the name of the MSDEapplication. I would like it to connect to the localhost on startup.Any ideas on how to correct this problem?Thanks,RBollinger
View 2 Replies
View Related
Jan 25, 2008
When I opened "Reporting Service Configuration Manger" from SQL server configuration tool list, The "Report Server Installation Instance window came out. It showed my local machine name on the field of Machine Name. When I click "Find" button, a message box came out. It says: "No report server were found on the specified machine. Details: Invalid namespace
What is the problem and how to solve it.
View 1 Replies
View Related
Aug 1, 2007
Hi all,
I have installed SQL Server 2005 Express Edition with Advanced Services and also Toolkit in my system. Following which I cofigured the Reporting Services Configuration.
When I try http://localhost/Reports it throws the following error.
---------------------------------------------------------------------------------------------------------------------------------------------------------------------
The report server cannot decrypt the symmetric key used to access sensitive or encrypted data in a report server database. You must either restore a backup key or delete all encrypted content. Check the documentation for more information. (rsReportServerDisabled) (rsRPCError) Get Online Help
The report server cannot decrypt the symmetric key used to access sensitive or encrypted data in a report server database. You must either restore a backup key or delete all encrypted content. Check the documentation for more information. (rsReportServerDisabled)
Bad Data. (Exception from HRESULT: 0x80090005)
---------------------------------------------------------------------------------------------------------------------------------------------------------------------
I have tried to search exhaustively for the solution and nothing seems to be crystal clear in solving the above error.
Under Reporting Services Configuraiton Manager (RSCM) all are ticked excepting:
Initialization, SharePoint Integration,Encryption Keys, EMail Settings,Execution Account.
Before this unknowingly I have changed "Windows Service Identity" during configuration which is not the same as Web Service Identity. Under "Web Service Identity" ASP.Net Service Account is listed as <machinename>ASPNET.
Now under "Windows Service Identity" it is selected to "Windows Account" : homequinn. After reading the installation steps it is suggested to have it with "Buil-in Account" ->"Network Services" is recommended. When I try to change it asks me for password and key file. Once I provide it, it is throwing me the following error.
---------------------------------------------------------------------------------------------------------------------------------------------------------------------
ReportServicesConfigUI.WMIProvider.WMIProviderException: The report server cannot decrypt the symmetric key used to access sensitive or encrypted data in a report server database. You must either restore a backup key or delete all encrypted content. Check the documentation for more information. (rsReportServerDisabled)
at ReportServicesConfigUI.WMIProvider.RSReportServerAdmin.ThrowOnError(ManagementBaseObject mo)
at ReportServicesConfigUI.WMIProvider.RSReportServerAdmin.BackupEncryptionKey(Byte[]& encryptedBytes, String password)
---------------------------------------------------------------------------------------------------------------------------------------------------------------------
Can someone tell how should I proceed to get the reporting services working.
View 3 Replies
View Related
Aug 28, 2005
Installing MSDE (SP3) on a clean updated Win-XP system with all the latest fixes installed unsuccesfully. A clean systems means a fresh installed Win-XP, updated all using webupdate. And Excel 2003 installed. Thats all (not even AntiVirus (yet))
View 19 Replies
View Related
Jun 21, 2006
I would like to reinstall the enterprise manager of sql server 2000,and i have currently sql server 2000 SP4 installed on it.I googled on it, and read that installation of enterprise manager ispossible from the setup disk, however, this is not possible: it rejectsbecause of the service pack.How can I reinstall enterprise manager, without haveing to uninstallsql completely?ThanksPrem
View 4 Replies
View Related
