SP1 And Hotfixes On Client
Sep 28, 2006
I've just finished applying SP1 and the hotfixes (in the prescribed order) to my development SQL2005 server. I'm guessing that I need to upgrade my clients, too. I imagine the clients can be upgraded using the big SP1 installer, but do I need to install all of the hotfix packages or just the sqltools hotfix? The article about the hotfix is pretty adamant about all hotfixes being installed on a server, even if particular components aren't installed, but they completely neglect the client where only SQL tools are installed.
Thanks
Steve
View 1 Replies
ADVERTISEMENT
Jan 15, 2008
I am currently at build 9.00.3054.00 and I'm having some strange
performance problems.. inserts hanging etc.....
Has anyone applied build 3175 or 3215 with good results....
any input is appreciated!
View 1 Replies
View Related
Aug 31, 2007
How do I tell what hotfixes have been applied to an instance?
Thanks
View 3 Replies
View Related
Nov 29, 2006
Hi, has anyone got the following error message before? It seems like it occurred when the snapshot creation agent reached the UDF fn_getOwner():
StartIndex cannot be less than zero.
Parameter name: startIndex
Error messages:
Message: StartIndex cannot be less than zero.
Parameter name: startIndex
Command Text:
select 'number' = convert(int, 0), 'definition' = definition
from sys.sql_modules
where object_id = object_id(@qualified_object_name)
union all
select 'number' = convert(int, procedure_number), 'definition' = definition
from sys.numbered_procedures
where object_id = object_id(@qualified_object_name)
Parameters: @qualified_object_name = [dbo].[fn_getOwner]
Stack: at Microsoft.SqlServer.Replication.AgentCore.ExecuteWithOptionalResults(CommandSetupDelegate commandSetupDelegate, ProcessResultsDelegate processResultsDelegate, Int32 queryTimeout, CommandBehavior commandBehavior)
at Microsoft.SqlServer.Replication.AgentCore.ExecuteWithOptionalResults(CommandSetupDelegate commandSetupDelegate, ProcessResultsDelegate processResultsDelegate, CommandBehavior commandBehavior)
at Microsoft.SqlServer.Replication.Snapshot.SmoScriptingManager.TextModeOnObjectScripter.Script()
at Microsoft.SqlServer.Replication.Snapshot.SmoScriptingManager.GenerateNonTableArticleSchScript(Scripter scripter, BaseArticleWrapper articleWrapper, SqlSmoObject smoObject, Boolean quotedIdentifierOn, Boolean ansiNullsOn, Boolean textMode)
at Microsoft.SqlServer.Replication.Snapshot.SmoScriptingManager.GenerateFunctionArticleScripts(ArticleScriptingBundle articleScriptingBundle)
at Microsoft.SqlServer.Replication.Snapshot.TransSmoScriptingManager.GenerateArticleScripts(ArticleScriptingBundle articleScriptingBundle)
at Microsoft.SqlServer.Replication.Snapshot.SmoScriptingManager.GenerateObjectScripts(ArticleScriptingBundle articleScriptingBundle)
at Microsoft.SqlServer.Replication.Snapshot.SmoScriptingManager.DoScripting()
at Microsoft.SqlServer.Replication.Snapshot.SqlServerSnapshotProvider.DoScripting()
at Microsoft.SqlServer.Replication.Snapshot.SqlServerSnapshotProvider.GenerateSnapshot()
at Microsoft.SqlServer.Replication.SnapshotGenerationAgent.InternalRun()
at Microsoft.SqlServer.Replication.AgentCore.Run() (Source: MSSQLServer, Error number: 52006)
Get help: http://help/52006
Source: mscorlib
Target Site: System.Text.StringBuilder Remove(Int32, Int32)
Message: StartIndex cannot be less than zero.
Parameter name: startIndex
Stack: at System.Text.StringBuilder.Remove(Int32 startIndex, Int32 length)
at Microsoft.SqlServer.Replication.Snapshot.SmoScriptingManager.TextModeOnObjectScripter.ProcessGetObjectScriptResult(SqlDataReader dataReader)
at Microsoft.SqlServer.Replication.AgentCore.ExecuteWithOptionalResults(CommandSetupDelegate commandSetupDelegate, ProcessResultsDelegate processResultsDelegate, Int32 queryTimeout, CommandBehavior commandBehavior) (Source: mscorlib, Error number: 0)
Get help: http://help/0
Here's the function:
set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
go
/* various comments here. */
ALTER
FUNCTION [dbo].[fn_getOwner] (@moduleID integer, @FY char(4))
RETURNS varchar(5)
AS
BEGIN
declare @tin char(9),
@owner varchar(5),
@ownerCount integer
-- Get owner via ModuleID
select @owner = owner
from tblControlPage
where moduleid = @moduleID and AuditFY = @FY;
-- Get owner via ATIN (This is when the moduleId is not on control page or no owner.
-- Check to see if the ATIN is on control page and use ATIN's Owner)
if @owner is null
begin
-- get module's TIN.
select @tin = tin from tblModule where moduleid = @moduleID
-- count the number of owners by ATIN those owner is not null via entity association.
select @ownerCount = count(*) from
(
select owner from vwControlPage c inner join vwEntityAssociation e
on c.tin = e.atin and e.tin = @tin
and auditfystart <= @FY and @FY < auditfyend
where owner is not null
group by owner
) owners
if @ownerCount = 1
begin
-- good, there's only one owner, get the ATIN owner.
select top 1 @owner = owner from vwControlPage c inner join vwEntityAssociation e
on c.tin = e.atin and e.tin = @tin
and auditfystart <= @FY and @FY < auditfyend
where owner is not null
group by owner
end
-- else there are multiple owners, set owner value to 'Multi'
if @ownerCount > 1
begin
set @owner = 'Multi'
end
end
-- Get owner via TIN if @owner is still null
if @owner is null --or len(@owner) = 0
begin
-- get TIN of module (Commented out the following because it was retrieved on prior "if" condition)
-- select @tin = tin from tblModule where moduleid = @moduleID
-- count number of owners by that TIN those not null.
select @ownerCount = count(*) from
(
select owner from vwControlPage
where tin = @tin and auditFY = @FY and owner is not null
group by owner
) owners
if @ownerCount = 1
begin
-- good, there's only one owner.
select top 1 @owner = owner from vwControlPage
where tin = @tin and auditFY = @FY and owner is not null
group by owner
end
-- else there are multiple owners, set owner value to 'Multi'
if @ownerCount > 1
begin
set @owner = 'Multi'
end
end
return @owner
end
View 1 Replies
View Related
Oct 19, 2015
I'm doing a certification process using AlwaysOn, and was using the link below, and on the lower 90 hotfix, and instead of downloading one by one, and then upgrade one by one updates, is there any way to make it more faster or practical, or unfortunately have to do this one by one, so the download as the update? This rollup contains the latest version of the Windows system files that are updated after the release of SP1. URL...
View 2 Replies
View Related
Jun 14, 2004
I’m wondering if anyone can shed light on a problem I’ve noticed that's really made for a major thorn in my side. I recently had a Microsoft patch installed on my server, and now for some reason, trying to run INSERT or UPDATE queries against the SQL 2000 database are severely limited. I constantly get the error:
“Error: A severe error occurred on the current command. The results, if any, should be discarded.�
My Event Logs also return the following:
"Invalid buffer received from client."
I think I’ve isolated the problem to be that I can’t add new or modify existing records that try using a field which is of type TEXT, but now can’t be longer than 4,000 characters, else the error fires. This is really weird, as I’ve used the same ASP.NET script to call a stored procedure to INSERT/UPDATE records thousands of times before with 100% success.
I have a feeling this might have something to do with the patch, but has anyone come across this problem specifically, or know for sure which patch(es) cause it? Why all of a sudden would a TEXT field be so limited in capacity?
View 2 Replies
View Related
Jan 9, 2008
Hi,
We've had this issue for awhile, but I have not been able to find a resolution for this. We have 2 identical servers (hardware & software) set-up: IBM x3850-(88633RU) running Windows Server 2003 Enterprise x64 (5.2.3790 SP1 Build 3790 R2). Server A was running SP1 (Build 9.0.2047) on a 3-node active-passive-passive failover cluster. Server B was running SP2 + Hotfix KB933097 (Build 9.0.3152) on a 2-node active-passive failover cluster. Both these servers are heavily utilized, and when originally installed with these versions of SQL Server Enterprise 2005 experienced no issues during or post-install. The original install of SQL 2005 Enterprise on both these servers had the Cluster Group Selection "Data files" setting changed to "M:MICROSOFT SQL SERVER" so that all system dbs and binaries would be installed to that location. On Server B where SP2 had already been applied, the update was downloaded on May 1, 2007, well after the GDR issues which had been plaguing SP2 releases was supposed to have been resolved.
Our problems began the night when we tried to apply hotfix KB933097 on Server A, and cumulative update packages 1,2,3 on Servers A & B, as well as catch-up the same SP2 and hotfix packages on other non-clustered servers where default system db locations remained the same. On all servers other than Servers A and B, the installs proceeded smoothly and without issue.
On Server B, which was already running SP2 + Hotfix KB933097, we tried installing Cumulative Update Package 1 (Build 9.0.3161) on the primary node. The install proceeded until the following errors were encountered:
"[Microsoft][SQL Native Client][SQL Server]Cannot find the object 'dm_exec_query_resource_semaphores', because it does not exist or you do not have permission."
"[Microsoft][SQL Native Client][SQL Server]Cannot find the object 'dm_exec_query_memory_grants', because it does not exist or you do not have permission."
After this, the setup finished with the message "Product: Microsoft SQL Server 2005 (64-bit) - Update 'Hotfix 3161 for SQL Server Database Services 2005 (64-bit) ENU (KB935356)' could not be installed. Error code 1603. Additional information is available in the log file C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGHotfixSQL9_Hotfix_KB935356_sqlrun_sql.msp.log."
We rebooted the server and tried several times to reinstall the hotfix as sa and as the database service account with full windows and sa credentials, each time with no success, and rebooting between retries. All other components were installed successfully. We were hesitant to try uninstalling the hotfix, since it was unable to be removed successfully in previous attempts. However, when I connected to Database Engine using Management Studio, I found that the version of SQL being reported was in fact Build 9.0.3161! Everything also appeared to be running properly.
I tried to to Google the answer, but could only find information as applied to SP1 when system dbs master and mssqlsystemresource were located on different locations (http://support.microsoft.com/default.aspx?scid=kb;EN-US;918695 ). I had already verified that all system dbs, including the ones mentioned, were originally and currently located together on M:Microsoft SQL ServerMSSQL.1MSSQLData.
Finally I contacted a fellow DBA who advised me to continue installing all the other hotfixes, and then compare all SQL files against other servers where the install succeeded to ensure all system files were updated correctly (matching file sizes and datetime stamps). Since we were depending on a fix in Cumulative Update Package 3 to fix a critical log-shipping security issue, I went ahead with the rest of the installs, getting the same error with each package, rebooting between each install.
We found after the final install that the mssqlsystemresource files in the M:Microsoft SQL ServerMSSQL.1MSSQLData
directory were in fact updated after each install with a new timestamp, and that all files in C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinn matched on both file size and timestamp. The log-shipping security issue we were looking to fix also appeared to be resolved by the last update.
On Server A, which was running SP1 (Build 9.0.2047), we installed the same SP2 package as we had on Server B with no issue. We rebooted and then tried to apply the same Hotfix KB933097 (Build 9.0.3152) that had been applied successfully on Server B and found to our surprise that the same errors were being generated here as well. We continued to apply the rest of the hotfixes so that both servers matched software updates. Comparing the above directories showed that files seemed to have been updated, even though database services appeared to be not installed.
It looks like we now need Cumulative Update 5 hotfix package in order to deal with WMI alerting issues, but I'm afraid to apply it until we have a known resolution for the past errors.
Since this issue was supposed to be resolved by SP2, I'm not sure why these post-SP2 hotfixes should fail. It seems to me to be an issue of the directory location of the system files which is in question.
I can post the hotfix log files as well, if anyone is interested in seeing them.
Any help would be greatly appreciated. As well, does anyone have any idea when SP3 is scheduled to come out? I really don't like applying hotfixes which are usually untested for general purposes, and it seems Microsoft is delaying this in favour of releasing SQL 2008.
View 6 Replies
View Related
May 28, 2001
We have 15 clients running our applicaton
14 of then conected to SQL server using TCP/IP and it runs fine
1 of 15 when connected using TCP/IP produce "..Time out error "
but runs fine when swiched from TCP/IP to Named pipes
1.What area should we look to correct problem with Time out using TCP/IP ?
2. Where to get information about using TCP/IP via Named pipes ?
View 1 Replies
View Related
May 10, 2006
Product: Microsoft SQL Server 2005 -- Error 29515. SQL Server Setup could not connect to the database service for server configuration. The error was: [Microsoft][SQL Native Client]Encryption not supported on the client. Refer to server error logs and setup logs for more information. For details on how to view setup logs, see "How to View Setup Log Files" in SQL Server Books Online.
View 78 Replies
View Related
May 2, 2006
On Windows XP systems I get the following issue when trying to browse the MSDB folder in SSIS
Client unable to establish connection
Encryption not supported on SQL Server. (Microsoft SQL Native Client)
I have noticed another post where several others have noticed the same issue. It appears to only occur on Windows XP installations. Is there a workaround or fix for this?
View 2 Replies
View Related
Nov 1, 2006
Hi,
I have SQL2000 installed as the default instance, and now I'm trying to install SQL 2005 standard edition as a named instance.
I receive this error :
SQL Server could not connect to database service for server configuration.. [SQL Native client] Encryption not supported on the client. However I'm able to install client tools
The setup works fine on other box with the same config : SQL 2000/Windows XP, is there any work around for this issue ?
In my SQL 2000 client network utilty "Force proctocol encryption " is desabled and did not find the setting for SQL 2005 !
Thank you
View 1 Replies
View Related
Jul 23, 2005
Hello,Is it necessary to upgrade the Client Connectivity Tools on all clientmachines after the SQL Server database server is upgraded from Version7.0 to 2000?Thank you in advance!Eddy
View 1 Replies
View Related
Mar 3, 2007
Hi,
While using Sql Native Client ,VB Application giving error
"Transcation Cannot Start because more than one ODBC connection is in use"
But when useing SqlServer client then work perfectly ok.
Please guide where to use Sql Native Client.
Thanks
Rizwan
View 1 Replies
View Related
Apr 23, 2008
I have tried this on several different operating systems (VISTA and XP ) and several versions of SQL NATIVE CLIENT including 2005.90.3042.0
I have a 64 bit "SQL NATIVE CLIENT" connection that fails. The exact same connection and code succeeds on 32 bit.
My customer and I prepend "oledb:" to the connection string and it starts working.
FAILS on 64 bit:
Provider=SQLNCLI.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=Wrigley_Test;Data Source=MONGO;Use Procedure for Prepare=1;Auto Translate=True;Packet Size=4096;Workstation ID=RIPTIDE;Use Encryption for Data=False;Tag with column collation when possible=False;MARS Connection=False;DataTypeCompatibility=0;Trust Server Certificate=False
WORKS
oledb:Provider=SQLNCLI.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=Wrigley_Test;Data Source=MONGO;Use Procedure for Prepare=1;Auto Translate=True;Packet Size=4096;Workstation ID=RIPTIDE;Use Encryption for Data=False;Tag with column collation when possible=False;MARS Connection=False;DataTypeCompatibility=0;Trust Server Certificate=False
I debugged my code to the point that I know it is happening when I call CreateAccessor for my SQL statement.
m_hr=m_pIAccessor->CreateAccessor(DBACCESSOR_ROWDATA, GetCols(), (m_pDBBinds+IsBookmarked()), 0, &m_hAccessor, NULL);
Error:
Microsoft SQL Native Client: Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done.
Does anyone have any suggestions?
View 6 Replies
View Related
Jan 13, 2004
When I try to add a database connection,it say it needs a sql client to continue.I downloaded msde and it still dosnt work.PLease help me out
View 3 Replies
View Related
Jul 13, 2000
Hi ,
One of my user is accessing 65 database. she is having 65 client on her work station. SO , she is able to access 65 thru her application. So today i just installed 70 client without removing 65.
SUddenly the front end application is not working either 65 or 70.
It is givng
Application defined error or object defined error.
Pls tell me how to handle the interfacing applications.
Pls suggest me regarding this.
--kavira
View 3 Replies
View Related
Oct 31, 2000
How can I get IP's clients when they connect to my SQL Server?
Thanks in advance.
View 1 Replies
View Related
Apr 27, 2000
I have installed SQL 6.5 Client onto my laptop under windows 98. I have copied over the database files from the server. I need to be able to run SQL 6.5 Enterprise manager and see the databases on my laptop. Is this possible? I tried to run enterprise manager but it won't let me do anything. I try to register the server... but my laptop is the one I want to use. Please help! Basically I want my computer so that it does not have to be hooked up to the network. Thanks
View 3 Replies
View Related
Oct 18, 1999
Problem with DTS
I can use DTS on SQL Server 7.0 (lets call it SRVR1)to get tables from Oracle 8.0.5 database on Unix and/or on NT, but when I want to do it from my PC which has MS SQL server 7.0 (desktop version) and client installed, and SRVR1 is registered in Enterprise Manager, to run DTS where source is Oracle database and destination is SRVR1 using Import/Export Wizard., after specifying ODBC connection for Oracle as source and clicking 'Next', (which when done on SRVR1 leads to the next screen where you specify destination) on NT client it does nothing, no error is reported and you can keep on 'Next' hundreds of times, it goes nowhere.
I tested ODBC connection to Oracle from my NT client and it works fine, except when used with DTS.
I welcome any suggestions.
Regards,
Zorica
View 2 Replies
View Related
Nov 4, 1999
Hi all, here's my question: is there a SP level that the SQL 6.5 _clients_ should
be on to ensure y2k compatibility? One of our packaged apps vendors sent us a
y2k blurb asking us to update both the server (which we'd already done) *and* the
clients to SP5a. Now, we have a large number of clients and installing the SP
on all of them would require a considerable amount of time.
Any thoughts on that? Any experiences? What parts of the client are modified by the SP?
The client is a vendor-built VB front end.
Thanks.
View 1 Replies
View Related
Jan 3, 2004
environment:
server: windows 2000 server
database server: microsoft sql server 2000+sp3
How to choose the client operation system?
windows98?
windows me?
windwos 2000 Professional?
or
windows xp
thanks
by the way,I am a foreigner.
not good at English.
View 1 Replies
View Related
Jan 29, 2004
Anyone know where I can find information regarding the "sql.log" placed in the root directory of a client that utilizes SQL Server tools (EP, QA, etc.). I've searched BOL and did not locate any topics regarding this. We had to stop the MSSQLServerOLAPService in order to delete this file as it had grown to > 1GB, after about 10 months use.
I'm curious if this file is also created on client workstations that are just running a SQL app.
View 2 Replies
View Related
Dec 11, 2007
Hello,
We are looking into the feasibility of moving one of our databases off of informix and potentially onto SQLServer. Specifically, I want to understand more about available client API shared libs on the AIX platform. We have applications written in C running on AIX that utilize embedded dynamic SQL. We use an informix precompiler on our existing embedded sql code in C. Also, there is an XA based resource manager that is used as the interface to the data base. The C applications are actually Tuxedo servers. Tuxedo has a resource manager that gets called and passes the SQL calls to the Informix database (no other database involved but MQ is also used in the global transaction that the Tuxedo service is using).
Looks like Tuxedo supports SQL Server XA data source implementation. The question then is 'Does Microsoft have client libraries for AIX?'
View 2 Replies
View Related
Apr 23, 2008
Hi
I am using sql server 2005 on my machine. But I have no idea whether I am using sql server or client on my machine.
Is there any way to see that
Regards
Karan
View 7 Replies
View Related
May 25, 2001
Hello,
I am upgrading existing databases through the wizard from 6.5 to 7.0. If I leave the databases in 6.5 mode do I need to install the SQL 7.0 client?
Thanks,
Darrin Carter
View 1 Replies
View Related
Jun 6, 2001
Newbie Question : Fair Warning ;>
Does SQL Server have a client tool similiar to Oracle's SQL Plus? If so, how do I set that up?
I have installed a desktop edition on my server, and I want to use some client to connect so that I can run queries from another machine. Am I set up correctly, or do I need to install the Enterprise edition on the server to do something like that.
I was thinking of writing a web-based client, but I can't seem to find the time. Plus, I wouldn't want to do that if a solution already exists.
Thanks in advance,
Tommy
View 1 Replies
View Related
Aug 8, 2001
Hi, I just recently applied sql70 service pack 2 on some sql70 servers. Has anyone have applied service pack 2 on the client boxes? Are they coming from the same download file sql70sp2i. If not, where can I find the download files for clients? I went searching Microsoft web site, but had no luck on this one.
Thanks in advance,
CC
View 1 Replies
View Related
Jul 5, 2000
I need to be able to administer SQL 6.5 and 7.0 servers from a single pc.
I have been told that I can't have SQL 6.5 and 7.0 tools installed on the same pc.
Is this correct? I can't find anything in BOL or Technet on the subject.
Regards,
Kevin Napier
View 1 Replies
View Related
Mar 30, 2000
Hi all,
I am going to upgrade a SQL server 6.5 box to SQL7.0. The 16 bit-client utilities are a prerequisite because there is a 16-bit application and requires some of the database libraries. My question is how does SQL7.0 deal with 16-bit application? In my case, could I upgrade the SQL6.5 box to SQL7.0?
I appreciate any input and help ahead,
Stella Liu
View 1 Replies
View Related
Mar 22, 2000
Quick question,
After upgrade the server from 6.5 t 7.0, is it necessary to upgrade all its clients as well ? (any documentation)
I learned from "pricing policy" that upgrade to 7.0 is considered as a major upgrade and CALS needed to be upgraded as well.
But I tried to connect from a 6.5 client to 7.0 server with SQL/W
with no problem ? however if try to connect through Enterprise Manager, I got a message saying "I need to upgrade the SQLDMO EM), Why was I able to connect
using SQL/W or ISQL ?
Thanks.
Anthony
View 2 Replies
View Related
Feb 5, 2001
I had SQLServer 7 installed when my machine (using Windows 98)was hit by a virus. This necessitated running the original setup disk. When I did this, I found a number of existing files had been deleted (history files for a credit card program, Windows dial-up connections ) including some needed for the SQLServer. I eventually uninstalled SQLServer and attempted to reinstall it. When I do, I get a message saying that this disk can only install the client version. I originally installed it from this disk so why can't I install it again?
View 1 Replies
View Related
Nov 2, 1999
I have one SQL app that needs the 7.0 client software and one that needs the 6.5 client installed. Are there any big issues in having the SQL 6.5 and 7.0 client components both installed on the same client computer in separate installation directories? (specifically issues that may occur with shared components & client-side requirements?)
Thanks
RM
View 1 Replies
View Related
