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
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:
We have two instances of SQL Server 2005 - SP1 installed on one server. The default instance starts very slowly. When looking at the log I can see the delay is due to Resource Manager based upon the following error.
Hi,I've managed to get a couple of shortcuts on my desktop that log meright into SQL Query Analyzer for whichever particular database I want(using the isql.exe command line options). Now, I want to do a similarcustomization for the SQL Server Enterprise Manager. I want to be ableto open SQL Server Enterprise Manager and have it pop me all the waydown into my particular database/tables view -> e.g. "Microsoft SQLServersSQL Server Group(LOCAL) (WindowsNT)DatabasesmyDatabaseName". I'm hitting a local db server...I've tried saving new consoles (.msc files), but that just doesn't seemto do anything. I've tried using bookmarks, also, and they just don'tdo anything at all when I select them.Any ideas??
In the SP1 update of SSIS there was a call from the SSIS service that would attempt to validate itself against the http://crl.microsoft.com web site. If the SSIS service didn't have access to the internet then it would timeout and not start the service. In our company we have our development systems behind a firewall which only allows for limited internet access due to it being a development system.
Does the installation of SP2 remove this authentication restriction?
i have a sql cluster setup, and need to change the user account that sqlserver starts with....any ideas? i screwed up and left it using localsystem account and now i can`t get sqlmail to work. i`m trying to avoid having to create the cluster again. any info appreciated.......jim jones
I just inherited a SQL Server that was set up by a non-DBA. It`s running NT 4.0 and SQL Server 6.50 - 6.50.201 (the vendor hasn`t certified the product on SP4). I am trying to change the SQL Executive Service to use a non-system logon account. The account that I want to use is running SQL Executive on 9 other servers.
I went into Usrmgr and added the account to the administrators group. Made sure that it has rights to: log on as a service, log on as a batch job, increase quotas, act as part of the operating system, replace a process level token.
When I try to change to that id in services, I get the following error:
"cannot set the startup parameters for SQL Executive service. Error 1057 occurred. The account name is invalid or does not exist."
Looking in Technet, I found that if "log on as a service" isn`t set you could get this message but I`ve check/re-checked, had someone else check and it`s set.
I want to change Startup Service Account of an instance on SQL Server 2000 from System Account to a Domain Account from Enterprise Manager. What impact maybe bring up on database and frond end?
I am running SQL 2008 R2. I have SQL Full-Text Search installed (part of a standard Automated build) - but disabled and switched-off as the applications don't need it. However as a result I get SQL Server error 9954:
SQL Server failed to communicate with filter daemon launch service (Windows error: Windows Error: hr = 0x80070422(failed to retrieve text for this error)). Full-Text filter daemon process failed to start. Full-text search functionality will not be available.
appear in the event / error logs everytime I start SQL server. Is it possible to suppress this error (other than by starting the SQL Full-text service) ...
hopefully, the subject addresses my problem. the server is running like a charm.
Service pack 2 has been installed. The only connection I remember creating after the initial installation is a remote connection.
I've checked to make sure I am allowing multiple protocols.
I am not able to get a response from the following:
C:Usersamfrizzell>SQLCmd -S .aaron-toshiba -E -Q "SELECT @@Version" HResult 0xFFFFFFFF, Level 16, State 1 SQL Network Interfaces: Error Locating Server/Instance Specified [xFFFFFFFF]. Sqlcmd: Error: Microsoft SQL Native Client : An error has occurred while establi shing a connection to the server. When connecting to SQL Server 2005, this failu re may be caused by the fact that under the default settings SQL Server does not allow remote connections.. Sqlcmd: Error: Microsoft SQL Native Client : Login timeout expired.
The instance is running as I can connect to it through Visual Studio 2005.
What did I do wrong? I could really use this application in order for me to develop websites. It's sort of a pain to go to another computer to use the more powerful features of SQL Server 2005 Server management Studio (standard edition).
On a fairly new install of SQL 2005 64-bit, upon bootup the Active Directory Helper Serivice is aborting with the error 3221225572 (0XC0000064). When an attempt is made to start the service manually the following error appears: "Windows could not start teh SQL Server Active Directory Helper on Local Computer. For more infromation, review the System Event Log. If this is a non-Microsoft service, contact the service vendor, and refer to the service-specific error code - 1073741724."
The service is strating up under the network services account, which I am suspicous may be a problem. Currently the SQL server is running under SQL 2005 SP2 with no post service pack hotfixes. Do you have any advice on how to get the service to launch without errors?
Hi, I have a service using SQL 2005 Express database, the service is started automatically on system startup, most of the times it can logon to the database successfully, however, sometimes, I got the following error:
"Error: 18456, Severity: 14, State: 16"
Any suggestions?
Thanks in advance!
Yuxi
2006-11-22 11:09:49.90 Server Microsoft SQL Server 2005 - 9.00.2047.00 (Intel X86) Apr 14 2006 01:12:25 Copyright (c) 1988-2005 Microsoft Corporation Express Edition on Windows NT 5.1 (Build 2600: Service Pack 2)
2006-11-22 11:09:49.92 Server (c) 2005 Microsoft Corporation. 2006-11-22 11:09:49.92 Server All rights reserved. 2006-11-22 11:09:49.93 Server Server process ID is 1956. 2006-11-22 11:09:49.93 Server Logging SQL Server messages in file 'c:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLLOGERRORLOG'. 2006-11-22 11:09:49.93 Server This instance of SQL Server last reported using a process ID of 1952 at 11/22/2006 11:08:07 AM (local) 11/22/2006 7:08:07 PM (UTC). This is an informational message only; no user action is required. 2006-11-22 11:09:49.95 Server Registry startup parameters: 2006-11-22 11:09:49.95 Server -d c:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLDATAmaster.mdf 2006-11-22 11:09:49.95 Server -e c:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLLOGERRORLOG 2006-11-22 11:09:49.95 Server -l c:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLDATAmastlog.ldf 2006-11-22 11:09:49.98 Server SQL Server is starting at normal priority base (=7). This is an informational message only. No user action is required. 2006-11-22 11:09:50.00 Server Detected 4 CPUs. This is an informational message; no user action is required. 2006-11-22 11:09:50.95 Server Using dynamic lock allocation. Initial allocation of 2500 Lock blocks and 5000 Lock Owner blocks per node. This is an informational message only. No user action is required. 2006-11-22 11:09:50.96 Server Database mirroring has been enabled on this instance of SQL Server. 2006-11-22 11:09:50.96 spid4s Starting up database 'master'. 2006-11-22 11:09:51.06 spid4s Recovery is writing a checkpoint in database 'master' (1). This is an informational message only. No user action is required. 2006-11-22 11:09:51.18 spid4s SQL Trace ID 1 was started by login "sa". 2006-11-22 11:09:51.23 spid4s Starting up database 'mssqlsystemresource'. 2006-11-22 11:09:51.25 spid4s The resource database build version is 9.00.2047. This is an informational message only. No user action is required. 2006-11-22 11:09:51.59 spid8s Starting up database 'model'. 2006-11-22 11:09:51.60 spid4s Server name is 'TestMachineTestSQLServer'. This is an informational message only. No user action is required. 2006-11-22 11:09:51.60 spid4s Starting up database 'msdb'. 2006-11-22 11:09:51.93 Server A self-generated certificate was successfully loaded for encryption. 2006-11-22 11:09:51.93 Server Server local connection provider is ready to accept connection on [ \.pipeSQLLocalTestSQLServer ]. 2006-11-22 11:09:51.93 Server Server local connection provider is ready to accept connection on [ \.pipeMSSQL$TestSQLServersqlquery ]. 2006-11-22 11:09:51.93 Server Dedicated administrator connection support was not started because it is not available on this edition of SQL Server. This is an informational message only. No user action is required. 2006-11-22 11:09:51.95 Server SQL Server is now ready for client connections. This is an informational message; no user action is required. 2006-11-22 11:09:52.12 spid8s Clearing tempdb database. 2006-11-22 11:09:53.12 spid8s Starting up database 'tempdb'. 2006-11-22 11:09:53.21 Logon Error: 18456, Severity: 14, State: 16. 2006-11-22 11:09:53.21 Logon Login failed for user 'sa'. [CLIENT: <local machine>] 2006-11-22 11:09:53.70 spid4s Recovery is complete. This is an informational message only. No user action is required. 2006-11-22 11:09:53.70 spid11s The Service Broker protocol transport is disabled or not configured. 2006-11-22 11:09:53.70 spid11s The Database Mirroring protocol transport is disabled or not configured. 2006-11-22 11:09:54.09 spid11s Service Broker manager has started. 2006-11-22 11:10:19.26 spid51 Starting up database 'TestDatabase'. 2006-11-22 11:10:19.42 spid51 Recovery is writing a checkpoint in database 'TestDatabase' (5). This is an informational message only. No user action is required. 2006-11-22 11:18:08.92 spid51 Starting up database 'TestDatabase'.
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
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.
database : MS SQL server ver 6.50.201 problem: server startup / server time out details SQL server shows usage of 100 % CPU utilization, if started automatically / manually. and does not proceed / hangs up(server time out), but win nt operates extremely slow.
The background of the situation in brief is as stated below. The errorlog was found to have the messages warning : OPEN OBJECTS parameter may be too low. Attempt was made to free up descriptors in localdes() Run sp_configure to increase parameter value.
Error : 644, severity : 21, state; state 1 the non clustered leaf row entry for page 2 row 1 was not found in index page 40 indexid 2 database 'tempdb'
Error : 2620 severity 21 state 3 the offset of the row number at offset 32 does not match the entry in the offset table of the follwoing page : page pointer = 0x1395800, page no= 40, status = 0x2, objectid = 1, indexid = 2
Action taken I used the sp_option to increase the open objects from default 500 to 1000, and the LE threshold maximum value to 400 from the default 200. after which I used reconfigure go and restarted the computer to take the effect. The following did work fine and server was working ok. But then from yesterday I am having the problem that the MS SQL sever is utilizing the cpu to 98 - 99 % and I am not able to connect to the server. I tried to start the server with the minimal configuration by specifying the -f option in the service manager start up options, it showed the following message 00/12/07 10:40:49.73 ods Unable to connect. The maximum number of '5' configured user connections are already connected. System Administrator can configure to a higher value with sp_configure. 00/12/07 10:40:50.02 ods Unable to connect. The maximum number of '5' configured user connections are already connected. System Administrator can configure to a higher value with sp_configure.
afterwhich I tried with the option of starting the sql server with the option -c -f which in the event detail of the win nt shows "mesg 18109: Recovery dbid 6 ckpt(55813,8) oldest tras= (55813,0)"
The open procedure for service "MSSQLServer" in DLL "SQLCTR60.DLL" has taken longer than the established wait time to complete. The wait time in milliseconds is shown in the data. DB-LIBRARY error - SQL Server connection timed out.
The dbid is / was 6 for both the instances, the database which is having this dbid is database name "AM" and is having above 1300 tables (approx) what could be the problem and solution for it? kindly help me out of this situation.
If any more information is needed please contact me on devendrakulkarni@yahoo.com / devendra@me.iitb.ernet.in
I have several DTS jobs that runs well as a job with my nt login account for the SQL agent service startup account, but if I use the System account they fail with this error. " Error opening datafile: Access is denied. Error source: Microsoft Data Transformation Services Flat File Rowset Provider"
The data has change access to the System account under the NT security.
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?
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?
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!
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.
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
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?
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?
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
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)
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?
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
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
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.
