SQL2K: Performance Problem With A Query After Security Patch Ms03-031

Jul 20, 2005

After applying security patch MS03-031 (Sql server ver 8.00.818) a
query that used to execute in under 2 seconds, now takes over 8
Minutes to complete. Any ideas on what the heck might be going on?

I have tested this extensively and can say for certain that installing
this hot fix is what has caused the performance problem. I just don't
know why or how to fix it.


Brian Oster

View 3 Replies


ADVERTISEMENT

After Applying Security Patch MS03-031, I Lose My SQL 2K Performance Monitor Counters

Aug 20, 2003

This is related to an earlier post, but I found out that I was able to see SQL Server counters in Performance monitor before applying the patch, but the counters were not present afterwards....

do I need to edit the registry ?

View 3 Replies View Related

MS03-031 Security Patch Indexed View Bugs...

Jan 22, 2004

Hey!

Has anybody here had any issues with the MS03-031 security patch and SQL 2000 on Windows 2003?

We recently installed this patch on one of our test SQL 2000 machines, and the performance of queries running on this machine have gone up (gotten worse) by at least 10X.

We use indexed views and all queries are run with WITH(NOEXPAND) to force the indexed view to be used.

Anyway, after the patch was installed, the queries on the indexed view will ONLY use the clustered index, and not any of the other indexes, causing a Clustered Index Scan.

I removed the patch (well, re-installed SQL) patched it up to SP3a, and performance is back to normal.

Anybody experience anything similar?
Paul

View 4 Replies View Related

??'s About Security Patch

Dec 28, 2001

I plan to apply the new security patch on my SQL 7.0 sp3 servers and get my SQL 2000 servers up to SP2 (which apparently already includes this)

But I was reading the Mitigating Factors in the announcement of this vulnerability and one reads as below:

"The effect of exploiting the first vulnerability would depend on how the SQL Server service was configured. SQL Server can be configured to run in a security context of the administrator’s choosing. (By default, it runs as a domain user). If best practices are followed, and the service is configured to run with the least privileges necessary, it would limit the worst-case damage an attacker could achieve. "

So my question is: What is the best practice for the SQL Server service and Agent service? Also are there resources for Best Practices?

Thanks!!

View 2 Replies View Related

Security Patch/Service Pack Questions

Sep 17, 2007

<!--[if !supportLists]--><!--[endif]-->

I posted this question before, and got a response about Windows Update. However, I work in a larger corp. and need to know if there are any other answers to this? We use a patch client that rolls out patches and service packs after we have tested them in our environment. What can we do to stay as up to date as possible for security patches?



How are security patches for SQL Server Express made available (e.g., as separate distributions or bundled into other Microsoft patch distribution mechanisms)? Are there specific procedures that I need to put in place to ensure that it gets patched on end user machines?



-Kyle

View 1 Replies View Related

SQL2K WIN2K3 CONNECTION SECURITY

Jul 23, 2005

Microsoft Security Paradigmes are Irritating. I sure they're fine onceyou know what they are, but for the uninitiated it's quitecounterintuitive to work with.I moving an old SQL Server-backend-IIS5/ASP-frontend application toservers with windows 2003 standard edition. One server will run thedatabase the other will run IIS 6.0. Note that i haven't set-up adomain, which i think requires one machine to be domain controllerwhich would decrease performance and stuff. I've simply put them on thesame group.I wan't to restrict access the sql server so only the incommingconnection from the webserver is allowed. I can use either namedpipes(which should be the fastest protocol) or tcpwhich should beslight slower than named pipes) but i seem to have a problem. If I usenamed pipes to connect the IUSR(the user under which IIS is running)must have access-rights to IPC$ share on the sql server. I can't seemto set any access-right directly for IPC$ share, but i can reactivatemy guest user and then it works, everyone can now access the ipc$ shareso it's not really what i'm looking for.I can also connect through TCP( and set up some kind of filter onlyallowing incomming connections on port 1433 from the ip of the webserver.But i don't know how to do this. I've taken a look at the IPSec stuffbut it's all about kerberos authentication and other bull which i don'tthink i need. What i need is simply a ip traffick filter, which doesnothing else but reject incomming connection from all other ip's thanmy webserver.My question is how do I do this? Do i need to have a addtitíon"firewall" service running and if so why, how much extra overhead willthis create for the server. Alternately, is it possible to change theaccess right for the IPC$ share manually?Thanks in advance for any input you might have on this?Regs Jens

View 2 Replies View Related

Performance Problems With SQL2K SP4 On Win2K3 SP2

Jan 7, 2008

Hello All and Happy New Year (I believe that is still allowed by the PC police?!)

Has anyone experienced performance problems (i.e. processes taking a lot longer to connect to the database server) after appyling Windows Server 2003 SP2 to a server that was previously running Windows Server 2003 RTM? The version of SQL Server (2000 SP4) has not changed between OS Service Packs.

To set the scene, we upgraded one node of a cluster to Win2K3 SP2 intending to upgrade the other node the following night if no problems were encountered. However, after failing over to the patched node we experienced something akin to a Denial Of Service attack whereby connections were gradually refused until even existing connections were kicked out.

We resolved that issue by disabling the SynAttackProtect Registry key (details http://support.microsoft.com/default.aspx?scid=kb;en-us;899599), but although connections are no longer being refused they are taking a lot longer, e.g. opening a Query Analyzer window now takes several seconds to connect to the database. The actual time taken by the database engine to execute sql queries has not increased, but is perceived by the users as having done so because of the time taken to return results.

I asked our server team to run diagnostics against both nodes and they found no problems and no differences apart from the OS service pack level.

I am about to reopen the case I logged with Microsoft, but thought I'd see if you guys had experienced anything similar.

Thanks and regards
Lempster :confused:

View 1 Replies View Related

Can Msdb From SQL2K Personal Edition Be Restored On SQL2K Standard?

Oct 12, 2007

The company for which I work did not have a DBA until I started a few weeks ago. Whoever installed SQL2K used the wrong CD so they have been running Personal Edition on their servers. I have installed a new SQL2K standard instance and have restored everything except the jobs and DTS packages. Can the msdb from the Personal edition be restored to the standard instance?

View 3 Replies View Related

Downgrade SQL2K Enterprise To SQL2K Standard

Mar 15, 2007

Is it possible to downgrade SQL from Enterprise to Standard Edition, or do you have to remove the previous installation (uninstall) and reinstall. Meaning you would also have to restore all user databases? Thanks.

View 1 Replies View Related

ADO.NET Cannot Connect To SQL2k, But Query Analyzer Does

Dec 21, 2006

I have an ADO.NET (.NET 2.0) application that throws a connection exception when trying to connect to a SQL 2000 Standard server (despite what the message says about 2k5, which I assume is generic):

System.Data.SqlClient.SqlException: 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) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Connect(Boolean& useFailoverPartner, Boolean& failoverDemandDone, String host, String failoverPartner, String protocol, SqlInternalConnectionTds connHandler, Int64 timerExpire, Boolean encrypt, Boolean trustServerCert, Boolean integratedSecurity, SqlConnection owningObject, Boolean aliasLookup) at System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance) at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance) at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection) at System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options) at System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject) at System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject) at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) at System.Data.SqlClient.SqlConnection.Open() at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet)
The strange thing is that I can connect just fine to this server (and run the stored procedure in question) using Query Analyzer from the client machine. I have double- and tripple-checked the credentials (and had someone else look too) and they are correct. I also checked telnet to port 1433 and it doesn't fail to connect. Ping is shut down at the firewall.

The connection string looks like this (basically):

Data Source=10.0.0.137;Initial Catalog=XXXXXX;uid=xxxxx;pwd=xxxxx
This is conecting to a remote instance across a couple firewalls. Both machines are Windows Server 2003. I don't have much more information about the SQL 2000 server machine, but the client machine is running plain vanilla server 2k3 with no third party software firewalls or a/v.

Has anyone run into this before? I know Query Analyzer and ADO.NET user different connection methods, but the permissions shouldn't be any different, right?

Thanks in advance.

--
Jeremy Wadsack
Seven Simple Machines
http://7simplemachines.com/

View 3 Replies View Related

SQL2K Help! SQL Union Query And Varchar / Integer Conversion Problems =(

Aug 8, 2007

Hi, I need help.  Understatement of the year right now, too =
So... I've created a stored procedure that partially pulls a SQL union query to give me a complete one-line result set of a bunch of data... four separate selects comprise the query.
The tables are structured identically to each other, but the values being pulled are specific and distinct.  All of the non-date values stored are varchar values in the tables, and yet when I execute the SQL union query, I get the error message:  Syntax error converting the varchar value to a column of data type int.
 I know SQL does implicit conversions, however Im not sure why it's trying to do that with this query, I suppose.  it should have been straightforward.
Any suggestions?  Here is the query logic to look at, in case I'm missing the obvious 

exec('
SELECT ACCOUNT, LNAME, FNAME, SEX, DOB, cast(MA_ContentValue as decimal) as MA_ContentValue, cast(MA_DOS as smalldatetime) as MA_DOS,cast(LDL_ContentValue as decimal) as LDL_ContentValue, cast(LDL_DOS as smalldatetime) as LDL_DOS, cast(HgbA1C_ContentValue as decimal)as HgbA1C_ContentValue, HgbA1C_DOS, cast(Creatinine_ContentValue as decimal) as Creatinine_ContentValue, Creatinine_DOS
FROM ( SELECT     Account, Lname, FName, Sex, DOB,MA_ContentValue, MA_DOS,   0 as LDL_ContentValue, 0 as LDL_DOS,   0 as HgbA1C_ContentValue, 0 as HgbA1C_DOS,   0 as Creatinine_ContentValue, 0 as Creatinine_DOS FROM         dbo.vwDiabetic_MicroalbuminTop3  UNION  SELECT     Account, Lname, FName, Sex, DOB, 0 as MA_ContentValue, 0 as MA_DOS,   LDL_ContentValue, LDL_DOS,   0 as HgbA1C_ContentValue, 0 as HgbA1C_DOS,   0 as Creatinine_ContentValue, 0 as Creatinine_DOS FROM         dbo.vwDiabetic_LDLTop3  UNION  SELECT     Account, Lname, FName, Sex, DOB, 0 as MA_ContentValue, 0 as MA_DOS,   0 as LDL_ContentValue, 0 as LDL_DOS,   HgbA1C_ContentValue, HgbA1C_DOS,   0 as Creatinine_ContentValue, 0 as Creatinine_DOS FROM         dbo.vwDiabetic_HgbA1CTop3  UNION
 SELECT     Account, Lname, FName, Sex, DOB, 0 as MA_ContentValue, 0 as MA_DOS,   0 as LDL_ContentValue, 0 as LDL_DOS,   0 as HgbA1C_ContentValue, 0 as HgbA1C_DOS,   Creatinine_ContentValue, Creatinine_DOS FROM         dbo.vwDiabetic_CreatinineTop3) tbl1
 
')
Anything else that I can provide for someone to help me? I appreciate any/all feedback!
 

View 11 Replies View Related

Clustering, Security, Performance, Load Balance

Nov 27, 2007

I think this question has been asked number of times. However, I amlooking for some specific information. Perhaps some of you can helpclose the gap. Or perhaps you can point me towards right direction.Perhaps this group can help me fill in ms-sqlserver related followingquestions.1. Do this database have data Clustering capabilities?1a. If yes, what mechanism is used such as shared disk, share nothing,etc.2. Do these dB have Security features?2a. If yes, what security features are supported? For instance do theysupport encryption or SSL connection?3. How does the database perform and what is the criteria for theperformance matrix?4. Do they have inbuilt load balance capabilities?I want to thank everyone for taking your time to read thiscorrespondence. I will also greatly appreciate your efforts in sharingyour thoughts.Regards,Manish

View 3 Replies View Related

Dynamic Dimension Security Limitations And Performance When Using Custom Dll (UDF)

May 21, 2008

Hi,

I've created a custom dll using ADOMD.net that takes in a few parameters (Username being one of them) and returns a set of Allowed Members to apply dynamic dimension security. Example:





Code Snippet

Security.GetSetList(UserName,1,"SQL Server")

This works fine for users with less than, say, 100 tuples/members in their set....however for users with more an error:

Error ocurred retreiving child nodes: The 'S' attribute in the 'S' dimension has a generated dimension security expression that is not valid. ...


However, if I take the same set and explicitly (ie


Code Snippet

{[S].[1],[S].[2],.......[S].[50000]}) put it in the Allowed set there's no issue!

I noticed that it takes the UDF a couple of seconds longer to return for users with a large security context. Is there a time-out parameter that controls this? Is there a limitation in the amount of members I can add via custom dll (UDF)? (Some users can have up to 70,000 members)

I should also mention that the UDF uses the StrtoSet function to convert the security context string to a set. The string can be as large as 210,000 characters. Is there a limitation on the string size that can be passed in this function?

Any assistance would be greatly appreciated.

Thanks!!

View 7 Replies View Related

Extremely Poor Query Performance - Identical DBs Different Performance

Jun 23, 2006

Hello Everyone,I have a very complex performance issue with our production database.Here's the scenario. We have a production webserver server and adevelopment web server. Both are running SQL Server 2000.I encounted various performance issues with the production server with aparticular query. It would take approximately 22 seconds to return 100rows, thats about 0.22 seconds per row. Note: I ran the query in singleuser mode. So I tested the query on the Development server by taking abackup (.dmp) of the database and moving it onto the dev server. I ranthe same query and found that it ran in less than a second.I took a look at the query execution plan and I found that they we'rethe exact same in both cases.Then I took a look at the various index's, and again I found nodifferences in the table indices.If both databases are identical, I'm assumeing that the issue is relatedto some external hardware issue like: disk space, memory etc. Or couldit be OS software related issues, like service packs, SQL Serverconfiguations etc.Here's what I've done to rule out some obvious hardware issues on theprod server:1. Moved all extraneous files to a secondary harddrive to free up spaceon the primary harddrive. There is 55gb's of free space on the disk.2. Applied SQL Server SP4 service packs3. Defragmented the primary harddrive4. Applied all Windows Server 2003 updatesHere is the prod servers system specs:2x Intel Xeon 2.67GHZTotal Physical Memory 2GB, Available Physical Memory 815MBWindows Server 2003 SE /w SP1Here is the dev serers system specs:2x Intel Xeon 2.80GHz2GB DDR2-SDRAMWindows Server 2003 SE /w SP1I'm not sure what else to do, the query performance is an order ofmagnitude difference and I can't explain it. To me its is a hardware oroperating system related issue.Any Ideas would help me greatly!Thanks,Brian T*** Sent via Developersdex http://www.developersdex.com ***

View 2 Replies View Related

Q323875_SQL2000_SP2_en Patch

Aug 2, 2002

I am trying to apply this patch to a Developers Edition of SQL 2000. According to the instructions, I am to replace ssnetlib.pdb, located int the binndll folder. well, this file does not exist in this or any other folder on the server. I have installed SP2 and all previous patches. Anyone have any idea why this is and how to resolve it?

Thanks,
Mitchel

View 1 Replies View Related

Need Knowledge About Patch

Jun 3, 2004

Hello, everyone:

Are ther any basic information about patch on SQL Server? How to develop patch, and run it? Thanks a lot

ZYT

View 7 Replies View Related

Do I Need To Reinstall Or Patch Something??

Apr 17, 2007

Hi,

I have discovered something wrong with my SSIS package and I thought it best to post a new thread since the problem is not what I thought it was initially.

With relation to my post of 'directory variable problem' I have now discovered by opening my project this morning that apparently my project had gone corrupt, according to the dev environment since the message reads:

"There were errors while the package was being loaded.The package might be corrupted.See the Error List for details."

The Error List:
"Error 13 Error loading MyTestSSISPackage.dtsx: The connection "(local).MyTestDB.sa" is not found. This error is thrown by Connections collection when the specific connection element is not found."
This is a buggy ADO.net connection that I deleted yesterday since, even though it connects successfully, doesn't want to work! It keeps on telling me log in failed for user <MyTestUser> even after I test it and it connects fine with the username and password during the UDL screen of the connection.. It's like it forgets the bloody password.
I created another connection, this time an OLE connection and it seems to work fine.

*EDITED*
I stand corrected..no bloody connection manager is working now. They all fail stating that they cannot connect to the db due to some or another 'unsupported' value in the connection string...the connectionstring was set up by the environment's udl????? how is this possible. I am beginning to get annoyed with SSIS

Now finally my question...WHY is it that every time I change something its like the dev environment doesn't cascade the change throughout the project or package? The problem I have been having with my variables not getting picked up with the correct values which I gave them during design time is probably also related to this. How or where can I remove the reference to this old ADO.Net connection since I cannot find it anywhere in the <package>.dtsx file?

Anyone ever experienced this?

Regards
Mike

View 2 Replies View Related

Patch Null Value?

May 11, 2007

following is my sql:


select a.dcode, b.district from table1 a, table2 b
where
a.id = b.id

and return following result:



dcode district
123 south
321 north
456 east
789 west
123
789


so for those records that district are null, how can i fill them up as i know they have the same dcode as the other records?

View 9 Replies View Related

How To Patch A 2005 Cluster?

Dec 12, 2007

According to SP1 documentation patching the Active node in a cluster will automatically apply the SP1 patch to the Passive nodes. However, I found a MS document that says if you have management tools installed on the passive node, you must patch this node separately. Is this correct?

Also, since Integration Services is not cluster-aware and therefore must be installed separately to the passive node(s), does SP1 need to be applied directly to the passive node(s) to patch Integration Services or is it automatically patched when I patch the Active node?

Thanks, Dave

View 5 Replies View Related

Patch Apply Question

Feb 11, 2008

I got 4 sql2k5 servers with service patch version as following:

Microsoft SQL Server 2005 - 9.00.2221.00 (Intel X86) Feb 9 2007 17:30:38
Copyright (c) 1988-2005 Microsoft Corporation Standard Edition on Windows
NT 5.2 (Build 3790: Service Pack 2)
Microsoft SQL Server 2005 - 9.00.2153.00 (Intel X86) May 8 2006 22:41:28
Copyright (c) 1988-2005 Microsoft Corporation Standard Edition on Windows NT
5.2 (Build 3790: Service Pack 2)
Microsoft SQL Server 2005 - 9.00.3054.00 (Intel X86) Mar 23 2007 16:28:52
Copyright (c) 1988-2005 Microsoft Corporation Standard Edition on Windows NT
5.2 (Build 3790: Service Pack 2)

Can anyone please advise me what is the easiest way to upgrade them to the
most updated patch version? i.e. update path.

Meanwhile, what is the best practice to apply patches? Do you go to
microsoft website and check it out daily and apply it or other tricks?
Please advise. Thanks.

View 1 Replies View Related

Error In Install Service Patch 5a

Nov 29, 1999

Hi,

I have problem in install SQL Server 6.5 service patch 5a. I download the .exe
from Microsoft and try to install it, it give error:

"setup initalizarion could not be successfully completed.
isql.exe can not be executed.
see error from relevant.OUT file. "

I thought the setup file need to run name pipes prototal instead of TCP/IP, so I change, but still give me the error. I install SS service patch 5a in other mechines before. Never has any problem. This time two of my server run into this problem, any help will be appreciated.


Eugene Shi

View 2 Replies View Related

Critical Patch KB824105 And SQL Failure

Jul 20, 2005

On the re-boot required for critical patch KB824105 MS SQL Server failed torecgnize the log on for the account it is registered under, and all otheraccounts when manually cahnged.It seems to have completely lost all ability to recognize and logon.SQL is totally hooped - no ODBC at all at the service doesn't start. At allbecause of no recognition of any accounts.Any suggestions? I've been trying for a while.

View 1 Replies View Related

Latest Sql Server 2005 Patch

Jan 27, 2008



Please advice me, now we are using service pack1, what is the latest service pack i can upgrade and has all the issues been recitified.

Thanks

View 17 Replies View Related

Determing SQL Server Patch Level

May 12, 2008

Sort of new to MSSQL and I have a problem with my maintenance script not deleting files on 2 out of 3 servers so I am trying to determine what patch level I am at.
'Server A' works as expected:

Microsoft SQL Server 2005 - 9.00.2050.00 (Intel X86)

Feb 13 2007 23:02:48

Copyright (c) 1988-2005 Microsoft Corporation

Standard Edition on Windows NT 5.2 (Build 3790: Service Pack 2)


These two servers don't:
Server B.

Microsoft SQL Server 2005 - 9.00.2050.00 (Intel X86)

Feb 13 2007 23:02:48

Copyright (c) 1988-2005 Microsoft Corporation

Standard Edition on Windows NT 5.2 (Build 3790: Service Pack 1)


Server C.
Microsoft SQL Server 2005 - 9.00.1399.06 (Intel X86)

Oct 14 2005 00:33:37

Copyright (c) 1988-2005 Microsoft Corporation

Standard Edition on Windows NT 5.2 (Build 3790: Service Pack 2)

So I can see where I should patch server B to SP2 but why does Server C report as 9.00.1399 SP2?

View 5 Replies View Related

Moving A Database Between Two SQL Server With Different Patch Levels

Jul 20, 2005

Hi,I need to move a database from an instance running SQL Server 2000 SP3to another running SQL Server 2000 SP2. Can I just use backup/restoreor detach/reattach and let SQL server take care of any downgrading (ifany).Many thanksGiovanni

View 4 Replies View Related

Report Server Errors After DST Patch Applied

Mar 12, 2007

After applying the DST (daylight savings time) fix by METHOD-2 in the following KB article:

http://support.microsoft.com/default.aspx/kb/914387

We are receiving the following error for all reports we currently serve:

aspnet_wp!webserver!3c88!03/12/2007-08:44:53:: e ERROR: Internal error: System.ArgumentOutOfRangeException: Specified argument was out of the range of valid values.
Parameter name: date
at System.Web.HttpCachePolicy.UtcSetLastModified(DateTime utcDate)
at System.Web.HttpCachePolicy.SetLastModified(DateTime date)
at Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.ReturnResponseHeaders(HttpClientRequest sessionManager, RSStream result, HttpResponse resp)
at Microsoft.ReportingServices.WebServer.ResponseHeaderData.ReturnResponseHeaders()
at Microsoft.ReportingServices.WebServer.HttpResponseStream.InternalFlush(Boolean finalFlush)
at Microsoft.ReportingServices.WebServer.HttpResponseStream.Close()
at Microsoft.ReportingServices.WebServer.HttpResponseStreamFactory.CloseAllOpenStreams()
at Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderReport()
at Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderItem(ItemType itemType)
at Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderItem()
at Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPageContent()
at Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPage()


Reporting Services Version: Microsoft SQL Server Reporting Services Version 8.00.1042.00

SQL Server Version: Microsoft SQL Server 2000 - 8.00.2039 (Intel X86) May 3 2005 23:18:38 Copyright (c) 1988-2003 Microsoft Corporation Standard Edition on Windows NT 5.0 (Build 2195: Service Pack 4)

We are using the work around specified in the following post to fix this issue:
http://groups.google.com/group/microsoft.public.sqlserver.reportingsvcs/browse_thread/thread/3f2b4854dc79e5e8/1b8261f4cf149078?lnk=st&q=Reporting+Services+dst+error&rnum=2&hl=en#1b8261f4cf149078

Any Help would be greatly appreciated!

Thanks,

ML

View 4 Replies View Related

Daylight Savings Patch For 2000 Server

Feb 13, 2007

I was wondering if there is a simple patch for 2000 server. It seems that the only fix is to edit the registry and to use the time zone editor app. If there is a simple patch like there is for the 2003 servers i would appreciate it if anyone can show me where. I have about 80+ servers with 2000!!!

Much appreciated!

View 7 Replies View Related

Rretrieve The DST Patch Updated Date In Sqlserver 2000

Oct 30, 2007



Hello all,

Hope all of us know that DST Patch update will be on 4th November,07.
Here my query is how to retrieve the DST patch updated date in sqlserver 2000?
any queries on this?
Would any one help me on this?


Thanks in advance,


View 6 Replies View Related

Setup And Upgrade :: Failed To Run Patch Request For Instance

Sep 17, 2012

Having an issue updating SQL Server 2012 RTM Standard  to CU3.I'm getting the following error from the Detail log on each try: "Error: Failed to run patch request for instance: MSSQLSERVER (exit code: -2061893565)"I've tried rebooting the server, ensuring the user running the installer is a local admin account, ran the repair wizard on the SQL install...Nothing seems to work.I have two identical servers, the first has gone smoothly, this is bugging me...

Server: Dell R720XD, Dual E5-2643 CPU, 64Gb RAM, Windows Server 2008 R2 Enterprise x64, SQL Server 2012 RTM CU2 x64 Installed.

Final result: The patch installer has failed to update the following instance: MSSQLSERVER. To determine the reason for failure, review the log files.
  Exit code (Decimal):           -2061893565
  Start time:                    2012-09-17 16:25:32
  End time:                      2012-09-17 16:28:41
  Requested action:              Patch

Instance MSSQLSERVER overall summary:
  Final result:                  The patch installer has failed to update the shared features. To determine the reason for failure, review the log files.
  Exit code (Decimal):           -2061893565
  Start time:                    2012-09-17 16:27:21
  End time:                      2012-09-17 16:28:39
  Requested action:              Patch

[code]...

View 14 Replies View Related

ADO.NET Parameterized Query Security

Sep 6, 2007

I am developing a website for multiple clients, each with their own separate database on SQL Server 2005. The database structures are identical for all clients. I like to use SQL stored procedures for the security advantages (i.e., don't need to grant access to the tables, only exec permissions on the stored procedures), but maintaining and deploying many sp's across all databases is becoming unwieldy and error-prone.

Is there a way to use parameterized queries (SqlCommand, SqlParameter) in C# code (which could be reused for all databases by changing the connection string) without having to grant access to the tables?

View 5 Replies View Related

Query Users In A Security Group With LDAP

Aug 11, 2004

I have a linked server set up and working correctly. I can create a query to get all the users from active directory with something like this:

SELECT [name], [samaccountname] from OpenQuery( ADSI,
'SELECT name, samaccountname FROM ''LDAP://DC=domain,DC=com'' WHERE objectClass = ''user'' and objectCategory=''Person''')

Now I am trying to select all the users in a specifed security group, but I am not having much luck. What is the best way to get this?

Thanks much.

View 3 Replies View Related

T-SQL (SS2K8) :: Search Query Including Security?

Jul 17, 2014

I'm trying to integrate the security settings for our system into the reports and search and its a nightmare trying to fit in all the rules.

Basically I have a massive custom search query which I now have filter even further. [URL] for previous discussions on this query, which I'm currently happy with).

so we have 6 different types of transactions. each type can have different admins. the search can be done for either 1 type or all types.Transactions by default are available to everyone, But there are a few (probably less than 1% of all) that security is enabled which is simply done by added people to the security table.

each transaction can be see by

* Everyone If no record found in security table for transaction.

* If even just one transaction found, the below have permission to view it.

- Person who raised transaction

- person currently responsible for it.

- person currently working on it.

- everyone in the security table for this transaction.

- Admins for this Transaction Type.

So when someone does a search I need to fit all the above. Because I'm building the search query it does make it a little easier to accommodate the various scenarios.And I think I have them all EXCEPT someone who is trying to search for records under ALL types, but is an admin of just 1 or 2 of the types. Ie they have too be able to see all records for those they are admins for, and then have normal security imposed for the other types of records.

The section near "DECLARE @IsUserAdmin AS BIT" sets admin flags for when they are an admin of a single type if searching for a single type, or sets admin flag if they are an admin for all types.

ALTER PROCEDURE [dbo].[uspJobSearch]
@csType as nvarchar(20) = '-1',
@status as nvarchar(20) = '-1',
@startID as nvarchar(50) = '',
@endID as nvarchar(50) = '',
@complaintType as nvarchar(50) ='',

[code]....

View 0 Replies View Related

Security Warning When Running SQL Server Query Within An HTA

Dec 20, 2006

Hello all.I'm using ADO to connect to a SQL Server database and run a T-SQLquery.The script template I'm using can be found here:http://groups.google.com/group/micr...56?dmode=sourceWhen I run a VBScript, I get no popups. When I run an HTA, I get thefollowing popup:"This page is accessing a data source on another domain. Do you want toallow this?" [Yes] [No]How can I turn off this warning within the script - without having togo into the Tools...Internet Options...Security...Trusted Sites menu?Any help would be greatly appreciated. Thanks!- Dave

View 3 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved