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 RepliesOn 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 RelatedIF 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 RelatedI 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 RelatedWhere 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 RelatedI 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 RelatedWhen 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
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.
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
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.
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?
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
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 RelatedHi 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
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 RelatedHi 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
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 RelatedI 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).
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
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
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 RelatedWhen 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.
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.
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 RelatedI 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 RelatedHi,
I've a slight problem with configuring my Report Server. I have set up everything apart from the initialisation and and the Windows Service Identity, however when I select the panel for the latter I am presented with a message box displaying the following:
" Reporting Services Configuration Manager:
There was an error while switching panels. The most likely cause is an error retreiving WMI properties. The exception details are:
InvalidArgument=Value of '1' is not valid for 'SelectedIndex'.
Parameter name: SelectedIndex "
I have tried re-installing the entire SQL server setup and this made no difference, I followed this by removing then reinstalling just the Report Service. Still nothing.
Any ideas as to what it is doing and how I should go about fixing it?
Sim
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
A user was created with a limited privilege under the USERS group. Once this user loged in the Report Manager he is acting like an Admin and Content Manager, though he is not given even a browser role.
What do u think that this guy is acting like a Super User evenif he is restricted to a browser role on the Report Manager ????????????
I did all my best, but no luck so far
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
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
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.
I have a VM with SP2013 and SQL Server 2012 SP1. I have installed the powerpivot plugin SP1.But when I run the PowerPivot for SharePoint 2013 configuration tool.
View 3 Replies View RelatedHello! I have the following problem. I developed CLR Stored Procedure "StartNotification" and deploy it on db. This sp calls external web service. Furthermore, this sp is called according with SQL Server Agent Job's schedule. On my PC SQL Server works under Local System account and this web service is called correctly (Executed as user: NT AUTHORITYSYSTEM). But on ther other server the following exception is raised during job running:
Date 17.04.2007 16:42:10
Log Job History (FailureNotificationJob)
Step ID 1
Server MSK-CDBPO-01
Job Name FailureNotificationJob
Step Name MainStep
Duration 00:00:00
Sql Severity 16
Sql Message ID 6522
Operator Emailed
Operator Net sent
Operator Paged
Retries Attempted 0
Message
Executed as user: CORPmssqlserver.
A .NET Framework error occurred during execution
of user defined routine or aggregate 'StartNotification':
System.Security.SecurityException: Request for the permission of type
'System.Net.WebPermission, System, Version=2.0.0.0, Culture=neutral,
PublicKeyToken=b77a5c561934e089' failed. System.Security.SecurityException:
at System.Security.CodeAccessSecurityEngine.Check(Object demand,
StackCrawlMark& stackMark, Boolean isPermSet)
at System.Security.CodeAccessPermission.Demand()
at System.Net. The step failed.
What is the reason of this behaviour? Unfortunately I do not have direct access to this server.
I have the following guesses:
1) CORPmssqlserver may have not enough permissions to call web service
2) Something wrong with SQL Server account's permissions
2) Something wrong with SQL Server Agent account's permissions
I will take the will for the deed. Thanks.