SQL Server Agent - start up account.

SQL Server Database Engine

Index ‹ SQL Server

- Previous
  - 1
    - Custom security extension - Report Manager and Report Server on different machines Hi, I'm trying to deploy Reporting Services on an Internet-facing web server using a custom security extension (forms authentication). We will be putting Report Manager on the Web Server outside of the firewall, and Report Server on another machine inside the firewall. When testing the solution in a development environment with Report Manager and Report Server on the same box, the solution works fine. When testing it using the Internet-facing environment described above, it almost works but there seems to be an issue with the authentication cookie that is generated. Here's what happens: 1. User enters credentials on UILogon.aspx and submits form. 2. In the code-behind, LogonUser() is called through a web service proxy and the authentication cookie is returned successfully. The code used here to set the cookie is the same code used in the Forms Authentication sample that ships with RS2005. 3. The user is redirected to Folder.aspx, and the request hangs for a while, and eventually kicks you back out to UILogon.aspx, as if it lost the authentication cookie. When doing a trace on the HTTP header, the cookie is still there. Is there anything special I need to do to make the Report Server "see" the cookie when I have Report Manager and Report Server on different machines Any help would be much appreciated! Mike Tag: SQL Server Agent - start up account.
  - 2
    - Root Element MIssing & For security reasons DTD is prohibited in this XML document I am an associate of VDeepak, the problem is definately not as simple as low memory. The report that is erroring out is only a page or so, and we routinely run 200 + page reports on this server. If it helps, here is the trace from the application error log: Event Type: Error Event Source: IHRS Event Category: None Event ID: 0 Date: 8/10/2007 Time: 9:28:40 PM User: N/A Computer: AFTRAHR-APP04 Description: 2007-08-10 21:28:40,225 [1] ERROR IHRSMESSAGE [(null)] - Root element is missing.AFTRA\escherrer System.Xml.XmlException: Root element is missing. at System.Xml.XmlTextReaderImpl.Throw(Exception e) at System.Xml.XmlTextReaderImpl.ThrowWithoutLineInfo(String res) at System.Xml.XmlTextReaderImpl.ParseDocumentContent() at System.Xml.XmlTextReaderImpl.Read() at System.Xml.XmlLoader.Load(XmlDocument doc, XmlReader reader, Boolean preserveWhitespace) at System.Xml.XmlDocument.Load(XmlReader reader) at Microsoft.Reporting.WinForms.WebRequestHelper.ExceptionFromWebResponse(Exception e) at Microsoft.Reporting.WinForms.ServerReport.ServerUrlRequest(Boolean isAbortable, String url, Stream outputStream, String& mimeType, String& fileNameExtension) at Microsoft.Reporting.WinForms.ServerReport.InternalRender(Boolean isAbortable, String format, String deviceInfo, NameValueCollection urlAccessParameters, Stream reportStream, String& mimeType, String& fileNameExtension) at Microsoft.Reporting.WinForms.ProcessingThread.ProcessThreadMain(Object arg) For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp . Tag: SQL Server Agent - start up account.
  - 3
    - Date conversion woes: Cast? Convert? The data type for this field is varchar(23). This is in a SQL table that is housing information for our Warehouse Managment System. I didn't actually build the table, just trying to report on some of the data in it... Did I go about finding the solution correctly, or would there have been a different approach I am always open to learning - as I have only been learning SQL for less than a year. Tag: SQL Server Agent - start up account.
  - 4
    - SQL login CHECK_POLICY calculations Hi.... I'm querying for SQL -logins whose passwords are about to expire. If Active Directory has a password expiration policy of x days, which is the correct query to use SELECT name, DateAdd(day, x, create_date ) FROM sys.sql_logins WHERE is_expiration_checked = 1 or SELECT name, DateAdd(day, x, modify_date ) FROM sys.sql_logins WHERE is_expiration_checked = 1 Or is this stored elsewhere from sys.sql_logins Thanks. Tag: SQL Server Agent - start up account.
  - 5
    - update system catelog data The problem was we had a whole bunch of "bit" fields that were not originally given default values and were allowed to be null. When we would do a batch data input we could not be sure (we weren't controlling the data set - I guess we could have written a SSIS package to control the column input) the bit fields would not be null. Once null, the fields would not show up in our queries. We just changed every field by hand - no null & default to 0, it was no big deal. Thanks. Tag: SQL Server Agent - start up account.
  - 6
    - Null value for Web Service task input I'm attempting to use the Web Service task to call a method provided by a vendor. The inputs are all simple types so that helps a lot, but for one input it's a string array. If I enter a single string value for a given id using the array dialog, the method works fine. However if I try to change the input to use a variable to provide the value it fails. I'm assuming that you can't create a variable to return a string array. Please let me know if this is the case or if I'm missing something obvious ;-) In addition, is there a way to specify a null value for an input Currently there doesn't appear to be a way to do this in SP2. I tried leaving the string empty which didn't work and I tried using a variable with expression "NULL(DT_WSTR, 1252)" but that failed too. Tag: SQL Server Agent - start up account.
  - 7
    - Can I pass '=' or '>' as parameters? I don't know, I usually would just suggest a dynamic SQL stored procedure in these cases, particularly if there is any real heft to your data. The other solutions suggested are a good possibilities too, but the complexities of coding tend to turn things like this into a nightmare both to maintain, and to get a decent query plan anyhow. Louis Tag: SQL Server Agent - start up account.
  - 8
    - String Search Hi, Was wondering how you do the equivalent of an Oracle "Instr" function in TSQL, which returns the position of a string pattern in a specified string I've looked through all the functions and can't find the equivalent. Thanks Simon Tag: SQL Server Agent - start up account.
  - 9
    - Dbbc not logging db name in error log correctly? Hi Just wondering if you used Maintenance plan wizards Jag Tag: SQL Server Agent - start up account.
  - 10
    - What's the best way to approach this situation? I think you want to add in the Person.Base.ID reference to the CustomField_Value table. Code Snippet Person.CustomField_Value BaseId (uniqueidentifier) (references Person.Base) FieldId (uniqueidentifier) Value (nvarchar(450)) You can also consider adding a "category" reference table for the definition of the custom field. If they can apply some broader categorization to the field types, that might facility searches and qualification. Addtionally, if it's on SS2005 then consider using an XML type. That will provide full flexability for the app side to do most anything, and you can put XML indexes on the column to provide some performance to the searches. Tag: SQL Server Agent - start up account.
  - 11
    - Triggers per row not per statement Anthony, This statement 'Update Order Set Name = 'test' Where OrderId In (1,2)' would fire a trigger only once. You have a data before update is available on deleted table and the data after update is available on inserted table. That means 2 rows on deleted and 2 rows on inserted. But the event is only one (business logic). So write all information into your audit database directly from the trigger itself. Don't use cursor. Thanks. Naras. Tag: SQL Server Agent - start up account.
  - 12
    - Data Conversion supported on Standard Edition? So both your workstation and the server are running SQL Server Standard edition Not developer/enterprise edition Tag: SQL Server Agent - start up account.
  - 13
    - database size issue One of the possible reasons might be that the datafile is allocated to 12GB size check it out RegarDs, Jacx Tag: SQL Server Agent - start up account.
  - 14
    - aggregates displayed in group header. I have a report that consists of three nested group levels. Each level can be expanded/collapsed. I wanted to have at each level the summed values: e.g. + Group Header 1 Sum1 Sum2 etc.. + Group Header 2 Sum1 Sum2 etc.. + Group Header 3 Sum1 Sum2 etc.. Rather I have had to output the aggregated values like so .. + Group Header 1 + Group Header 2 + Group Header 3 Total Group Footer Sum1 Sum2 etc.. Total Group Footer Sum1 Sum2 etc.. Total Group Footer Sum1 Sum2 etc.. Is there a way to display the aggregated values at the header level of the grouping. I thought this could be possible if I could hide the Group Footer and directly reference the footer sum total values in the header. Any help would be greatly appreciated. Theo Tag: SQL Server Agent - start up account.
  - 15
    - The AcquireConnection method call to the connection manager "Server.Northwind" failed with Error code 0xC0202009; Error at Text Inbound Task [SQL Server Destination [9]]: The AcquireConnection method call to the connection manager "Server.Northwind" failed with error code 0xC0202009. Error at Text Inbound Task [DTS.Pipeline]: component "SQL Server Destination" (9) failed validation and returned error code 0xC020801C. Please keep me posted with alternate work around(s) /solution(s). Tag: SQL Server Agent - start up account.
  - 16
    - Upgrading Access 2003 to Access Project and SQL 2000 backend. Hi, I am upgrading an Access 2003 database to an Access Project with a SQL 2000 backend. I am trying to develope a type of framework to communicate with the backend. I have read some about linked tables, pass through queries ect. My initial instinct would be to use sprocs and ADO from VBA modules like a .NET application. My database has reports, forms that update and insert data, and forms the call data proccessing procedures. Is ADO from VBA modules calling sprocs the best method to manipulate my data. The DB could have up to a million or 2 records in my biggest table, their are only two end users. Any suggestions or links or books would be appreciated. Thanks, Mike Tag: SQL Server Agent - start up account.
- Next
  - 1
    - Select full rows depending on distinct date Code Snippet set dateformat dmy create table #t ( id tinyint , title varchar ( 10 ), date datetime ) insert into #t select 1 , 'bill' , '6/7/2006' union all select 2 , 'gus' , '14/7/2006' union all select 3 , 'dan' , '6/8/2007' select left( convert ( varchar ( 10 ), date , 111 ), 7 ) as AsOf , substring ( ( SELECT ', ' + convert ( varchar ( 10 ), id ) + '-' + title AS [text()] FROM #t t2 WHERE left( convert ( varchar ( 10 ), t1 . date , 111 ), 7 ) = left( convert ( varchar ( 10 ), t2 . date , 111 ), 7 ) FOR XML path ( '' ), elements ), 2 , 1000 ) as data from #t t1 group by left( convert ( varchar ( 10 ), date , 111 ), 7 ) Tag: SQL Server Agent - start up account.
  - 2
    - Basic steps as how to web usage mine in sql server 2005 Hi there, I am doing a project on web usage mining of my universities server logs and im just wondering how i go about mining them in sql server 2005 Do i mine them in one table do i normalise the web log data what algorithms will i use on them as im trying to get usage patterns from the users and also where most of the users come from. Thanks in advance Gary Tag: SQL Server Agent - start up account.
  - 3
    - SQL Server sp_add_job procedure missing I have found out that the stored procedures sp_add_job, etc. are missing from msdb. How do I get these procedures Thanks, Mary Tag: SQL Server Agent - start up account.
  - 4
    - Formatting for Phone? Great, glad I could help. You'll get used to it. Does it make sense Getting the middle characters is a little awkward. I can't remember whether there is a Mid function defined or not, so I just use that. Tag: SQL Server Agent - start up account.
  - 5
    - Should I use dynamic SQL and combine 2 procs into 1? That expression is not considered a search argument by SQL Server, avoiding SQL Server from using an "index seek" operation in case there is an index by that column, with high selectivity. Example: Code Snippet create procedure dbo . p1 @customerid nchar ( 5 ) = NULL as set nocount on select orderid , orderdate , customerid from dbo . orders where customerid = isnull ( @customerid , customerid ) return @@error go dbcc freeproccache dbcc dropcleanbuffers go set showplan_text on go exec dbo . p1 'ALFKI' go exec dbo . p1 NULL go set showplan_text off go drop procedure dbo . p1 go Result: exec dbo.p1 'ALFKI' |--Clustered Index Scan(OBJECT:([northwind].[dbo].[Orders].[PK_Orders]), WHERE:([northwind].[dbo].[Orders].[CustomerID]=isnull([@customerid],[northwind].[dbo].[Orders].[CustomerID]))) exec dbo.p1 NULL |--Clustered Index Scan(OBJECT:([northwind].[dbo].[Orders].[PK_Orders]), WHERE:([northwind].[dbo].[Orders].[CustomerID]=isnull([@customerid],[northwind].[dbo].[Orders].[CustomerID]))) It is hard to come with a solution that fit all situations, so having different stored procedures is sometime a good option. Here are a couple of articles that can help you with this theme. The Curse and Blessings of Dynamic SQL http://www.sommarskog.se/dynamic_sql.html Dynamic Search Conditions in T-SQL http://www.sommarskog.se/dyn-search.html AMB Tag: SQL Server Agent - start up account.
  - 6
    - ora-12645 Paramater does not exist emmydotnet wrote: yes. I can connect from SQLPLUS. From the Windows 2003 server machine The sqlnet.ora file is likely wrong/corrupt/missing/something based on that error code. Do you know what client driver you are using Microsoft Oracle Tag: SQL Server Agent - start up account.
  - 7
    - Error Deleteing Remote File I can delete the files from the FTP command line. I have a DTS package that uses a .bat file to do this, I just want to put it into SSIS. Thanks for the info. Tag: SQL Server Agent - start up account.
  - 8
    - Data Connections: Where the hell are they stored??!! Connection managers do store connection information. You thought that's what they were for and that is exactly correct. Now the confusing part is that the connection information is stored in "both" places. However, once the connection manager is made, that information has been copied into the package itself, and that registry entry might as well have never existed and does not need to exist in the future. Now, if you want to see the last point demonstrated rather than just asserted (that is, that a connection manager's connectivity information is persisted to the package), create a IS package in BIDS with an OLEDB connection manager used in an execute sql task and execute the package sucessfully from BIDS. Then,export those those registry entries and delete them (you'll reimport them later), using a tool like regedit.exe. If you don't want to to mess with the registry, the following will demonstrate the point as well; double-click on the connection manager and point it to a different database. Now, run the package . What happens Runs as before. Which database is hit The one the connection manager was changed too. Is the registry updated to point to the connection manager's current database No, it is not. The connection information is persisted to the package. Now, if you deleted the registry entries, re-import them. BIDS is an acryonym for Business Intelligence development studio, which is the design-time environment hosted by Visual Studio 2005 for building BI projects ( Integration Services, Analysis Services, Reporting Services). Tag: SQL Server Agent - start up account.
  - 9
    - JPGs added to Image column are truncated at 1024 bytes (but only when import executed as a Job) I have a table in a SQL 2005 database that is designed to hold JPG product images for a website. Here is the schema: create table dbo.Eur_RMISWebInterface_Staging_ProductImages( product_code varchar(12) not null, image_order smallint not null, colour_identifier varchar(10) not null, image_data image not null, constraint PK_Eur_RMISWebInterface_Staging_ProductImages primary key clustered ( product_code, image_order ) ) Product images are inserted into the table from a database on a remote SQL 2000 server. Here is the script that does that (uses dynamic SQL): set @SQLCmd = ' set xact_abort on begin transaction delete Eur_RMISWebInterface_Staging_ProductImages insert Eur_RMISWebInterface_Staging_ProductImages ( product_code, image_order, colour_identifier, image_data ) exec "' + @RMISServerName + '".' + @RMISDatabaseName + '.dbo.Eur_RMISWebInterface_GetProductImagesForWeb ' + convert(varchar(3), @PortalID) + ', ' + @Locale_LCID + ' commit transaction' execute (@SQLCmd) About 500 images, each about 20KB, are transferred at a time. Here is the problem - when this script is run manually, all the images are inserted completely. When the script is run as part of a job (that has several other steps), the job step completes successfully and all the images are inserted, but every single one is truncated to the first 1024 bytes of the image. What this ends up looking like on the website is a a narrow strip of image instead of a complete image. Here are some other observations: - When I changed the "Eur_RMISWebInterface_GetProductImagesForWeb" SP to only return 1 product image instead of 500 it still failed - The owner of the job is the same Windows user as the user I have been running the script manually as - I have tried changing the datatype of image_data from image to varbinary(max) but it made no difference What could possibly be going on Tag: SQL Server Agent - start up account.
  - 10
    - create table by code Thank you very much. I used the following code. It worked in the first time. But when I debugged the program for the second time, I had this error " database customs already exists" How can I solve this problem And can you give me a sql script to create one database with one three-column table thanks Dim cnString As String = "Data Source=.\sqlexpress;Integrated Security=True;Pooling=False" Dim con As SqlClient.SqlConnection = New SqlClient.SqlConnection(cnString) Dim cmd As SqlClient.SqlCommand = New SqlClient.SqlCommand() con.Open() cmd.CommandType = CommandType.Text cmd.Connection = conGet cmd.CommandText = "create database [customs]" cmd.ExecuteNonQuery() con.Close() Tag: SQL Server Agent - start up account.
  - 11
    - binding textbox text to a database field hello is it possible to to bind a single field from a database table to a textbox. I am trying to open a web form with five textboxes on it. When it loads is it possible to have the textboxes filled with a different field from a row in a database, selected with a sql statment. Thanks in advance NubNub Tag: SQL Server Agent - start up account.
  - 12
    - Pattern Matching and Full-text search I'm not quite sure that this is possible but, I figured that I would check with you experts out there before trying a new approach. I've done quite a bit of research and have not seen anyone quite figure this out yet. We have a SQL Server 2005 application that stores and indexes documents to the database as an image data type. I'm able to do full-text queries against the documents without any trouble. I begin to run into problems when trying to pattern match social security numbers and drivers licenses stored in a full-text index. I have a user defined function that I call which runs my regular expression that checks for hits of a ssn or license number in the index. I have no problem getting hits when the data sits in a column. I do need to mention that I have no trouble when searching for a ssn with a fixed value and where I know the ssn (ex: 123-45-6789). I am actually trying to find the existence of the pattern of ###-##-#### (ex: ^\d{3}-\d{2}-\d{4}$) anywhere in the index. Any help would be very much appreciated. Tag: SQL Server Agent - start up account.
  - 13
    - Check remotely if Reporting Services exist You can check using http://servername/reportserver or http://servername/reports Tag: SQL Server Agent - start up account.
  - 14
    - rda dropping primary key index How wide is your index, please detail schema and create index statement. Do you create the index with the sdf file on your hard disk or on the SD card Tag: SQL Server Agent - start up account.
  - 15
    - How to handle multiple result sets return from Stored Procedure I am using TSQL to handle the result set Tag: SQL Server Agent - start up account.
  - 16
    - Analysis Service stops soon after starting Hi Markish, Were you able to solve this problem If so, pls let know how it happenned. I face the same issue, posted here: http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=2113409&SiteID=1 regards Tag: SQL Server Agent - start up account.

DBLearner

Hi all,

Please let me know what specific privileges an user account needs to be used as a LOG ON AS account for SQL Server Agent in SQL Server 2005.

Does the account needs to me in the domain administrator group

Thanks,

DBLearner

Top

Re: SQL Server Agent - start up account.

Caddre

Yep if you plan to use Replication and data automation which converts the Agent to a robot that moves data from one part of the Enterprise to another. You need to spend time with it because you can use proxy accounts for the automations. Run a search for Replication permissions requirements, Maintenance plans Agent dependency and Agent proxy accounts in SQL Server BOL. Hope this helps.

Top

Re: SQL Server Agent - start up account.

Madhu K Nair

refer this

Selecting an Account for the SQL Server Agent Service

http://msdn2.microsoft.com/en-us/library/ms191543.aspx

Madhu

Top