I installed SQL2005 (first time). I have a couple of problems that perplex me.
I can connect to my instance when starting up SQL Management Studio no problem. After connecting, I can manually backup and restore DBs, no problem.
However, when I attempt to start SQL Server Agent - I get the follwoing message:
Unable to start service SQLAgent$GREATPLAINSV80 on server USIND-BAT3835N1.
===================================
The SQLAgent$GREATPLAINSV80 service on USIND-BAT3835N1 started and then stopped. (ObjectExplorer)
------------------------------
Program Location:
at Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.Service.Start()
The error log is as follows:
Date,Source,Severity,Message
05/13/2006 12:08:57,,Information,[098] SQLServerAgent terminated (normally)
05/13/2006 12:08:56,,Error,[382] Logon to server 'USIND-BAT3835N1GREATPLAINSV80' failed (DisableAgentXPs)
05/13/2006 12:08:56,,Error,[298] SQLServer Error: 772<c/> Cannot generate SSPI context [SQLSTATE HY000]
05/13/2006 12:08:56,,Error,[298] SQLServer Error: 772<c/> SQL Network Interfaces: The Local Security Authority cannot be contacted [SQLSTATE HY000]
05/13/2006 12:08:56,,Error,[000] Unable to connect to server 'USIND-BAT3835N1GREATPLAINSV80'; SQLServerAgent cannot start
05/13/2006 12:08:56,,Error,[298] SQLServer Error: 772<c/> Cannot generate SSPI context [SQLSTATE HY000]
05/13/2006 12:08:56,,Error,[298] SQLServer Error: 772<c/> SQL Network Interfaces: The Local Security Authority cannot be contacted [SQLSTATE HY000]
I researched using Microsoft SQL Home knowledge base for error 772, cannot generate SSPI context and [SQLSTATE HY000] and didn't find anything that seems to apply.
Why can I connect to the database engine but not start SQL ServerAgent?
Hi,Hopefully someone can help me. I'm having difficulty with the syntax to delete a record from 4 joined tables when creating a job.I have an 'Applicants' table linked to four other tables 'Courses', 'EmploymentHistory', 'Qualifications', and 'References' using the field 'ApplicantID'.I want to create a job to delete all the records where the Finalised field = '0' and the record was created more than 3 days ago.The syntax I have been using on just one of the joined tables to start with doesn't delete from the joined table:USE OnlineApplicationsDELETE Applicants FROM ApplicantsINNER JOIN CoursesON Applicants.ApplicantID = Courses.ApplicantIDWHERE Finalised = 0 AND Created < DATEADD(d, 3, Created) How can I delete the records from the other four tables?Thanks
After installing SQL Server 2005, a security scan was performed on the SQL server. Below are a few items that the scan identified within the Windows User Rights Assignment as potential vulnerabilities; it is worthy to note in Microsoft's defense that we lock things down pretty tightly in our IT shop. I suspect the SQL Server install assigns these OS privileges to the SQLServer and SQLServerAgent accounts by default. I have not heard of the 1st, 3rd and 4th below and suspect that they are not essential to the normal operation of SQL Server, but would like to know if anyone out there knows for sure. We are considering eliminating some or all of these privieleges for the SQLServer and SQLServerAgent system accounts at the OS level.
1) SQLServer and SQLServerAgent accounts have "Bypass Traverse Setting" privilege within Windows User Rights Assignment
2) SQLServer and SQLServerAgent accounts have "Log on as Batch Job" privilege within Windows User Rights Assignment. I realize I need this to schedule SQL Server jobs which run batch jobs and such, but any other reason to keep this privilege.
3) SQLServer and SQLServerAgent accounts have "Memory Quota" privilege within Windows User Rights Assignment
4) SQLServer and SQLServerAgent accounts have "Replace Process Token" privilege within Windows User Rights Assignment
Any guidance on this would be greatly appreciated.
I was looking at a previos thread in this very queston and the answers given to it, I tried a SSIS package that works fine on its own but on creating a new job and invoke it, the JOB fails ,it says its not able to locate the file specified,
I tried copying the package to the server machine wher am creating the job,but again the same error; and when i try to alter the protection level of the SSIS package to Server Storage its throwing an error like '' This protection level cant be applied to this destination,The system can't verify that the destination supports storage capacity. this error occurs when saving to XML."
I am using OLE DB Destination in the dataflow task of the SSIS package I ve created. Please guide whr am going wrong. Some detailed steps which has some screenshots depicting step by step procedure of creating a JOB that calls a SSIS package will be highly helpful
I have built a SSIS package which runs fine in BIDS. I went into SqlServer Management Studio and created a new job and job step. When Iselect the SQL Server Integration Services Package, I get the belowerror. There are no options on selecting a SSIS package.I searched this error for about 5 hours yesterday and the onlysolution I could find was a user who rebooted their server which fixedthis problem. I did restart the server, which did not fix theproblem.Can anyone help provide more information on this problem and thesolution to it? Thank you, Jason.The specified module could not be found. (Exception from HRESULT:0x8007007E) (SqlManagerUI)------------------------------Program Location:atMicrosoft.SqlServer.Management.SqlManagerUI.DTSJob SubSystemDefinition.Microsoft.SqlServer.Management .SqlManagerUI.IJobStepPropertiesControl.Load(JobSt epDatadata)atMicrosoft.SqlServer.Management.SqlManagerUI.JobSte pProperties.UpdateJobStep()atMicrosoft.SqlServer.Management.SqlManagerUI.JobSte pProperties.typeList_SelectedIndexChanged(Objectsender, EventArgs e)at System.Windows.Forms.ComboBox.OnSelectedIndexChang ed(EventArgse)at System.Windows.Forms.ComboBox.WmReflectCommand(Mes sage& m)at System.Windows.Forms.ComboBox.WndProc(Message& m)atSystem.Windows.Forms.Control.ControlNativeWindow.O nMessage(Message& m)atSystem.Windows.Forms.Control.ControlNativeWindow.W ndProc(Message& m)at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32msg, IntPtr wparam, IntPtr lparam)
I am experiencing a big problem with my SQL Server- it won't start. Every time I attempt to start it I get an error "Error 1069 (The service did not start due to logon failure) occurred while performing this service operation on the MSSQLService service. " sa will not work either. I have not made any system changes recently. I tried to use regrbld but nothing happened. Is there anything else I can do short of reinstalling SQL7?
...So glad there are still folks out there running 6.5! We've been running 6.5 and 7.0 for the last year or so (one of our apps required 6.5). SQL 6.5 is running on an Alpha box, and SQL 7.0 is running on an Intel box. I want to install 6.5 on yet another Intel box, then install 7.0 on that SAME box so that I can perform the DTS. (Doing DTS across different CPU types failed to transfer application objects.) After that is successful, I will uninstall the 6.5 on the Intel box and no longer use the Alpha box for SQL. Both the Alpha and Intel boxes are on the same Windows NT domain.
Here is the issue. After performing the CD install of 6.5 on the Intel box, I get a message that the install could not be performed successfully because the MSSQL service could not be started. When I attempt to start it manually from Control Panel, I get an NT Error 3 - that the path cannot be found. (And the errorlog says that the server is unnamed.) So the MSSQL folder exists, the MSSQL Server and SQL Exec services are visible in Control Panel (unstarted), the registry contains SQL Server info, but the only way I've been able to start SQL Server at all is by using the Net Start MSSQLserv command.
I have repeated this step a few times - by deleting the MSSQL folder and re-running SETUP. At no point does NT remove the MSSQL services or the registry entries. In the end, NT or MSSQL still cannot find the "path" needed to start up SQL Server.
What do I need to do to "reset the clock" so that NT knows where to find these services?
I was trying to restore a master database. This is what I did: 1. rebuild the master database and it was successful 2. restart server in single mode with sqlservr.exe -c -m and I got the following window:
************************************************** ******** 2006-01-27 10:30:01.49 server Microsoft SQL Server 2000 - 8.00.2039 (Intel X 86) May 3 2005 23:18:38 Copyright (c) 1988-2003 Microsoft Corporation Standard Edition on Windows NT 5.2 (Build 3790: Service Pack 1)
2006-01-27 10:30:01.52 server Copyright (C) 1988-2002 Microsoft Corporation.
2006-01-27 10:30:01.52 server All rights reserved. 2006-01-27 10:30:01.52 server Server Process ID is 600. 2006-01-27 10:30:01.52 server Logging SQL Server messages in file 'e:Microso ft SQL ServerMSSQLlogERRORLOG'. 2006-01-27 10:30:01.54 server SQL Server is starting at priority class 'norma l'(4 CPUs detected). 2006-01-27 10:30:01.71 server SQL Server configured for thread mode processin g. 2006-01-27 10:30:01.74 server Using dynamic lock allocation. [2500] Lock Bloc ks, [5000] Lock Owner Blocks. 2006-01-27 10:30:01.99 server Attempting to initialize Distributed Transactio n Coordinator. 2006-01-27 10:30:04.04 spid3 Warning ****************** 2006-01-27 10:30:04.04 spid3 SQL Server started in single user mode. Updates allowed to system catalogs. 2006-01-27 10:30:04.04 spid3 Starting up database 'master'. 2006-01-27 10:30:04.29 server Using 'SSNETLIB.DLL' version '8.0.2039'. 2006-01-27 10:30:04.29 spid5 Starting up database 'model'. 2006-01-27 10:30:04.29 spid3 Server name is 'SQLTEST1'. 2006-01-27 10:30:04.31 spid7 Starting up database 'msdb'. 2006-01-27 10:30:04.31 spid8 Starting up database 'pubs'. 2006-01-27 10:30:04.31 spid9 Starting up database 'Northwind'. 2006-01-27 10:30:04.31 server SQL server listening on 10.10.4.17: 1433. 2006-01-27 10:30:04.33 server SQL server listening on 127.0.0.1: 1433. 2006-01-27 10:30:04.34 server SQL server listening on TCP, Shared Memory, Nam ed Pipes. 2006-01-27 10:30:04.36 server SQL Server is ready for client connections 2006-01-27 10:30:04.67 spid5 Clearing tempdb database. 2006-01-27 10:30:05.54 spid5 Starting up database 'tempdb'. 2006-01-27 10:30:05.70 spid3 Recovery complete. 2006-01-27 10:30:05.70 spid3 SQL global counter collection task is created.
Now an hour passed and the window is still there. The SSQL service manager on the toolbars still has a red icon but not green. My questions are how do I know the process is done? What is the next step after SQL global counter collection task? Where can I find more information?
I have recently invested in a new server that is running SBS premium, this come with SQL server and as a result of which I feel its time for me to start getting to grips with it.
I have reasonable knowledge of database design and SQL, extensive experience with access and some with Oracle. I have however never dealt with SQL server.
I generally don't have too much trouble picking up new technologies, and was wondering if anyone can point me in the right direction for learning SQL server from scratch? Is it realistic to be able to achieve this without doing a formal course? I intend to start using it to develop data-driven websites and applications.
Any help, advice and/or pointers are greatly appreciated.
Getdate() will get me the date, but how I can calculate two other datetime values corresponding to the very first second and the very last second of the current day?
Eg.
Today is 2008-04-09 <whatever time> Startdate should be 2008-04-09 00:00:01 Enddate should be 2008-04-09 23:59:59
Ram writes "Hi mate, I am New in this forum. I am working as developer in C++ and .net ( 4 Years). I plan to do the SQL SERVER 2005 and do some Microsoft certification. I really don't know where I can start and which source is suitable for me. I already download the express edition and I play arround that.
could you all please help me for this. I am awaiting your good response.
hi how to get the start day end day one row for each employee like this ID fname start day end day val_holiday -------------------------------------------------------------------------------------
-------------------------------------------------------------------------------------------------------- this is my table ID fname new_date val_holiday ----------------------------------------------------
Where would be a good place to start learning SQL? I know all the links in the e-mail that I got sent when I registered....but there not very help full.
I'm new in the field of Microsoft products and particularly with the Microsoft SQL Server. So in the beginning I would like to ask some questions and to understand the base lines. First thing is, I heard that there are several editions of Microsoft SQL Server 2005 : standard, workgroup, express, developer. I would like to know what is the difference between each of them. I suppose that developer means that it should be good for a developers to use this edition, but compared to the Standard edition or to the Express edition what are the main differences. In my case I'll use the server for a little, not complicated, database and may be there will be a migration to do from some old Access database to the new one (under SQL Server). Is the edition of the SQL Server important for doing that ? And my last question is about the compatibility between the SQL Server 2000 and 2005. In fact the server that is in use currently is version 2000 but in the future months the administrator plans to upgrade the software to the 2005 version. So I'm asking myself, if I start to develop for directly for 2005 version, is the product will be entirely compatible with the current version (2000)? That's all I think for now.
I had a small power outage and after that, SQL Server (2000) is not starting. I press the start button, it looks like it tries to do something (since all the buttons get disabled) and then its back to square one. I tried this from command line: sqlservr.exe -c -f but it does not help either. I checked the SQL Server logs and this is what I found: 2007-08-08 10:05:09.63 spid3 Starting up database 'master'. 2007-08-08 10:05:09.63 spid3 Error: 823, Severity: 24, State: 6. 2007-08-08 10:05:09.63 spid3 08/08/07 10:05:09 Stack Overflow Dump not possible - Exception c00000fd E at 0x004436DD 2007-08-08 10:05:09.63 spid3 Address=4436dd Exception Code = c00000fd I tried to google but could not find a solid solution.
Dear Friends,I cannot start my SQL Server 2005. When I'm trying to conect to local database it's showing me error:TITLE: Connect to Server------------------------------Cannot connect to WIN2006.------------------------------ADDITIONAL INFORMATION:An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) (Microsoft SQL Server, Error: 2)This error mean that server not started.When I read more details (error log in SQL Configuration Manager) I found that the source of the problem - "master" table was compressed. It should be decompressed to start server. What's this? I'm seeing this kind of error first time. Need your advise guys!
I've just installed VS.NET and have installed MSDE. All has gone well so far. I followed the instructions for setting a db password during install and the installer seemed to do its job. The SQL Server Service Manager runs in the taskbar when I reboot but the status icon is a white circle... The status bar indicates that it is not connected.
After installing WebMatrix on my computer, I installed Microsoft SQL Server 2000 Desktop Engine (MSDE 2000) in my computer, but I can't see MSDE on my Start menu. I am really new to this and don't know how to open MSDE, so I could work with it. Nothing displayed after I installed MSDE, such as the typical "Installation is complete."
Sorry for such a silly question, but please help me. How can I open MSDE from the Start menu. I have windows XP Home.
I have the following error when trying to test EMail from SQL.
I have logged onto the server and sent EMail using the SQLServer Service Account and the Profile is correct. This tells me that Outlook is working OK and the Exchange Server is sending OK. However, lookin on TechNet Q274330 mentions the error number but it's description is about Emailing an open file. I am not Emailing an open file.
Here's the error message.
xp_startmail 'eweb02mail'
Server: Msg 18025, Level 16, State 1, Line 0 xp_startmail: failed with mail error 0x80040106
Hi !! I am trying to configure SQL mail with POP3 (Lotus notes) mail client. I created the mail profile, I am sure that my login and service logon account is the same, i have mail client working on my work station (i.e i can send and recieve mails on my lotus notes ID). I am running NT 4.0 / SQl 7.0
When i do a test profile on SQL MAIL properties i get "ERROR 22030,A MAPI ERROR(ERROR NUMBER 87)OCCURED, MapiLogonEx FAIILED DUE TOMAPI ERROR 87; INVALID PARAMETER"
When i try an start my SQL MAIL, i get, " Error 17952: Failed to Start mail session: "
Where am i going wrong guys ?
any insight would be apprecieted !!
i am running sevice pack 3 on sql server 7.0 and 6a on NT 4.0
Hello, I made an Oracle query like SELECT ID,PARENTID,NIVEL FROM EQUIPO START WITH NIVEL=0 CONNECT BY PRIOR ID=PARENTID is there a way to made the same query without using the Oracle START WITH and CONNECT BY PRIOR statements? thanks and regards Marko