Do I Need To Re-install SP5A For SqlServer 6.5?
Jul 19, 2000
I am having problems with stack dumps (as many as 12 a day) at a production site running NT 4.0 SP4 with Sql Server 6.5 SP5A. I've tried running every diagnostic utility on the server but it shows no problems. Before I open a ticket with Microsoft on the stack dumps, I'd like to upgrade the server to NT Service Pack 6A. My question is, do I need to re-install SqlServer SP5A? Will the NT Service Pack 6A invalidate SQL SP5A?
TIA,
Mike
View 2 Replies
ADVERTISEMENT
Dec 16, 1999
we have a client that just upgraded to sp5a and are encountering problems...one stored procedure seems to routinely become corrupted, and does not complete correctly. however, it does not error out, and the only way to tell that it did not complete successfully it to query the data.
the only solution that i have found to this problem is to recreate the procedure. i have tried using sp_recompile to force a recompile at next runtime, and the problem still occurs. i have tried recreating the calling procedure, and recreating procedures it calls, but neither fix the problem.
after recreating the procedure, it continues to run fine for anywhere from 1 hour to 8 hours, and then starts to fail again.
microsoft so far has not been able to give us help in diagnosing this, and i am coming up with nothing in my own investigations.
has anyone seen a problem like this in sp5a?
also, it is occurring on 5 similar dbs that are on the same server...
thanks
carl
View 2 Replies
View Related
Sep 2, 2004
Hello,
I have 3 questions on the most eficient install of SQLSERVER
1.Do i create a specific user for the instance, or do i use the local system
2.Do i specify a port number ( 1433 ) in the install process , i leave the port number 0.
3.Do i use the names pipes protocol, my path is
programfilemssql$instance ..
Please help me.
View 1 Replies
View Related
Nov 7, 2005
I installed Visual Studio 2005 (released edition) that I downloaded from MSDN, and then went to install the released edition of SQL Server 2005. On the SQL Server 2005 setup "components to install" screen, all but the last choice ("Workstation components, Books Online, and development tools" are grayed out so I cannot install them.The machine on which I was installing these had just been re-imaged and was clean.How do I get around this so I can install SQL Server2005? Mark
View 1 Replies
View Related
May 29, 2008
Hi Folks,
I have installed the sql server last month, that time sql server shows the Instance like "SelComputerSQLEXPRESS" after one week from installed i have uninstall the sql server express edition. now i have installed again this sql server but it doesnt shows the Instance, I have tried lot of times, but still it shows the same empty. I cant find any intance in my local machine, In Management studio Connect to server dialod window Server Name Box Shows the Empty Box, But i can connect remote servers, Any can help to resolve this issue, i am currently using winXp Profession with SP2...
Thanks
View 5 Replies
View Related
May 20, 2007
Install SQLServer 2005
I am trying to install SQLServer 2005 to a Windows 2003 terminal server. Although I specify D drive as destination it still installs it to C drive. Where would the problem be?
View 1 Replies
View Related
Mar 12, 2008
Hi,
I am trying to install Sql server on my new laptop. First i installed the VS2005 and then the SQL server 2005. but after i installed SQL server 2005 i cannot see the Performance tools, Sql Server Mangaement studio.. How can i get those things on my Laptop. when i installed it the first time i clicked everything that i need thats
Database, Analysis service, integration, reporting service etc.. and BIDS too
but i cannot see the SSMS in the my programs..
any help will be apprecaited
View 1 Replies
View Related
Sep 22, 2006
Hi, I'm after some advice.
I have a server containing two mirrored HD's connected to a SAN.
I have to install SQL Server 2005 onto this server, I intend to put all data/log files on the disks that are in the SAN but my question is: where is the best place to install SQLServer itself, the local disk (ie. C:) or disks within the SAN?
Thanks
View 4 Replies
View Related
Nov 9, 2007
All the Componets are grayed out disabled and not available to proceed further while installing.
All of them have a red cross mark on it saying "Unavailable"
I actually wanted to instal Reporting services component and related services in my machine
Note : MY database server(sqlserver 2005) is connected to this report server(above) by LAN.
Could you please let me know where and how I could install Reporting services
Thanking you in anticipation
Srinivas
View 1 Replies
View Related
Nov 9, 2006
The situation is as follow:
Sqlserver 2005 installed, reporting services NOT installed
SP1 installed
Trying to add Reporting Services results in an eror messages about incompliant versions. Nothing happens
Is there anybody who has a clue?
View 6 Replies
View Related
May 10, 2006
When I try to run the install it detects some previous versions
components. The remove all previous beta components fails and I have
removed everything from the Add/Remove Programs.
Any advice would be helpful
Irina
View 1 Replies
View Related
Apr 26, 2006
I have a error instaling SP1 for SQLServer 2005 Standard Edition Spanish.
The log is the following:
.....
Doing Action: SetInstanceProperty
PerfTime Start: SetInstanceProperty : Wed Apr 26 16:02:31 2006
<Func Name='SetInstanceProperty'>
MSI (s) (48!D0) [16:02:31:827]: PROPERTY CHANGE: Adding SqlOriginalMachineName property. Its value is 'WS03'.
MSI (s) (48!D0) [16:02:31:827]: PROPERTY CHANGE: Adding SqlLegacyRegPath property. Its value is 'MSSQLServer'.
MSI (s) (48!D0) [16:02:31:859]: PROPERTY CHANGE: Adding PreviousInstId property. Its value is 'MSSQL.1'.
Using instanced id: MSSQL.1
MSI (s) (48!D0) [16:02:31:859]: PROPERTY CHANGE: Adding InstId property. Its value is 'MSSQL.1'.
Previous instance id: MSSQL.1
Using instance name: MSSQLSERVER
MSI (s) (48!D0) [16:02:31:890]: PROPERTY CHANGE: Adding PrevRegRootPath property. Its value is 'SoftwareMicrosoftMicrosoft SQL ServerMSSQL.1'.
MSI (s) (48!D0) [16:02:31:921]: PROPERTY CHANGE: Adding Sql2KSxS property. Its value is '1'.
MSI (s) (48!D0) [16:02:31:921]: PROPERTY CHANGE: Adding InstanceName.D20239D7_E87C_40C9_9837_E70B8D4882C2 property. Its value is 'MSSQLSERVER'.
MSI (s) (48!D0) [16:02:31:921]: PROPERTY CHANGE: Adding ServicePrefixRS.6080319C_1466_426E_9E7A_1DD555143E0A property. Its value is 'SQLServer2005ReportServerUser$WS03$'.
MSI (s) (48!D0) [16:02:31:921]: PROPERTY CHANGE: Adding ServicePrefixSSIS.6080319C_1466_426E_9E7A_1DD555143E0A property. Its value is 'SQLServer2005DTSUser$WS03'.
MSI (s) (48!D0) [16:02:31:921]: PROPERTY CHANGE: Adding ServiceGroupSQLBrowser.2FC2D269_8625_4826_BB3F_F9059090CB38 property. Its value is 'SQLServer2005SQLBrowserUser$WS03'.
MSI (s) (48!D0) [16:02:31:921]: PROPERTY CHANGE: Adding QuotedServiceGroupSQLBrowser.2FC2D269_8625_4826_BB3F_F9059090CB38 property. Its value is 'RIEDERSQLServer2005SQLBrowserUser$WS03'.
MSI (s) (48!D0) [16:02:31:921]: PROPERTY CHANGE: Adding ServiceGroupSQLBrowser.03BE59F9_3DFA_413B_A99C_B95CA31A7BFE property. Its value is 'SQLServer2005SQLBrowserUser$WS03'.
MSI (s) (48!D0) [16:02:31:921]: PROPERTY CHANGE: Adding QuotedServiceGroupSQLBrowser.03BE59F9_3DFA_413B_A99C_B95CA31A7BFE property. Its value is 'RIEDERSQLServer2005SQLBrowserUser$WS03'.
MSI (s) (48!D0) [16:02:31:921]: PROPERTY CHANGE: Adding ServiceGroupSQLBrowser.879C8BDB_884A_4C3C_80C3_3452EA2B8439 property. Its value is 'SQLServer2005SQLBrowserUser$WS03'.
MSI (s) (48!D0) [16:02:31:921]: PROPERTY CHANGE: Adding QuotedServiceGroupSQLBrowser.879C8BDB_884A_4C3C_80C3_3452EA2B8439 property. Its value is 'RIEDERSQLServer2005SQLBrowserUser$WS03'.
MSI (s) (48!D0) [16:02:31:921]: PROPERTY CHANGE: Adding ServiceGroupADHelper.2C8E638F_C982_4AA5_A173_7148A8E8649D property. Its value is 'SQLServer2005MSSQLServerADHelperUser$WS03'.
MSI (s) (48!D0) [16:02:31:921]: PROPERTY CHANGE: Adding QuotedServiceGroupADHelper.2C8E638F_C982_4AA5_A173_7148A8E8649D property. Its value is 'RIEDERSQLServer2005MSSQLServerADHelperUser$WS03'.
MSI (s) (48!D0) [16:02:31:921]: PROPERTY CHANGE: Adding InstanceRegKey.2C8E638F_C982_4AA5_A173_7148A8E8649D property. Its value is 'Microsoft SQL ServerMSSQL.1'.
MSI (s) (48!D0) [16:02:31:921]: PROPERTY CHANGE: Adding DataInstanceTxt.EAD22282_F1AF_4119_B1F9_C9F1DCBC62FF property. Its value is 'C:Archivos de programaMicrosoft SQL ServerMSSQL.1MSSQL'.
MSI (s) (48!D0) [16:02:31:921]: PROPERTY CHANGE: Adding ServiceNameSQL.EAD22282_F1AF_4119_B1F9_C9F1DCBC62FF property. Its value is 'MSSQLSERVER'.
Using PrevRegRootPath: SoftwareMicrosoftMicrosoft SQL ServerMSSQL.1
GetServiceUserGroup failed for MSSQLSERVER, 5
Error Code: 0x80070534 (1332)
Windows Error Text: No se ha efectuado ninguna asignación entre los nombres de cuenta y los identificadores de seguridad.
Source File Name: sqlcasqlcax.cpp
Compiler Timestamp: Mon Feb 27 02:04:14 2006
Function Name: SetInstanceProperty
Source Line Number: 1223
MSI (s) (48!D0) [16:02:31:937]: Transforming table Error.
MSI (s) (48!D0) [16:02:31:937]: Note: 1: 2262 2: Error 3: -2147287038
MSI (s) (48!D0) [16:02:31:937]: Transforming table Error.
MSI (s) (48!D0) [16:02:31:937]: Transforming table Error.
MSI (s) (48!D0) [16:02:31:937]: Note: 1: 2262 2: Error 3: -2147287038
MSI (s) (48!D0) [16:02:31:937]: Transforming table Error.
MSI (s) (48!D0) [16:02:31:937]: Note: 1: 2262 2: Error 3: -2147287038
MSI (s) (48!D0) [16:02:31:937]: Transforming table Error.
MSI (s) (48!D0) [16:02:31:937]: Note: 1: 2262 2: Error 3: -2147287038
Error Code: 1332
MSI (s) (48!D0) [16:02:31:952]: Transforming table Error.
MSI (s) (48!D0) [16:02:31:952]: Note: 1: 2262 2: Error 3: -2147287038
MSI (s) (48!D0) [16:02:31:952]: Transforming table Error.
MSI (s) (48!D0) [16:02:31:952]: Transforming table Error.
MSI (s) (48!D0) [16:02:31:952]: Note: 1: 2262 2: Error 3: -2147287038
MSI (s) (48!D0) [16:02:31:952]: Transforming table Error.
MSI (s) (48!D0) [16:02:31:952]: Note: 1: 2262 2: Error 3: -2147287038
MSI (s) (48!D0) [16:02:31:952]: Transforming table Error.
MSI (s) (48!D0) [16:02:31:952]: Note: 1: 2262 2: Error 3: -2147287038
MSI (s) (48!D0) [16:02:31:952]: Producto: Microsoft SQL Server 2005 -- Error 29528. El programa de instalación ha detectado un error inesperado al Estableciendo propiedades internas. El error es: Error grave durante la instalación.
.
Error 29528. El programa de instalación ha detectado un error inesperado al Estableciendo propiedades internas. El error es: Error grave durante la instalación.
.
<Failure Type='Fatal' Error='1332'>
<EndFunc Name='LaunchFunction' Return='1332' GetLastError='0'>
MSI (s) (48:9C) [16:02:31:952]: Transforming table InstallExecuteSequence.
MSI (s) (48:9C) [16:02:31:952]: Note: 1: 2262 2: InstallExecuteSequence 3: -2147287038
MSI (s) (48:9C) [16:02:31:952]: Transforming table InstallExecuteSequence.
MSI (s) (48:9C) [16:02:31:952]: Transforming table InstallExecuteSequence.
MSI (s) (48:9C) [16:02:31:952]: Note: 1: 2262 2: InstallExecuteSequence 3: -2147287038
MSI (s) (48:9C) [16:02:31:952]: Transforming table InstallExecuteSequence.
MSI (s) (48:9C) [16:02:31:952]: Note: 1: 2262 2: InstallExecuteSequence 3: -2147287038
MSI (s) (48:9C) [16:02:31:952]: Transforming table InstallExecuteSequence.
MSI (s) (48:9C) [16:02:31:952]: Note: 1: 2262 2: InstallExecuteSequence 3: -2147287038
La acción terminó a las 16:02:31: SetInstanceProperty.D20239D7_E87C_40C9_9837_E70B8D4882C2. Valor devuelto: 3.
La acción terminó a las 16:02:31: INSTALL. Valor devuelto: 3.
Property(S): ProductCode = {FD515EB7-E1C3-4278-9EC2-047672A8B718}
Property(S): ProductLanguage = 3082
Property(S): Manufacturer = Microsoft Corporation
Property(S): ProductVersion = 9.1.2047.00
Property(S): MEDIAPACKAGEPATH = Setup
Property(S): ALLUSERS = 1
Property(S): NULLGUID = {00000000-0000-0000-0000-000000000000}
Property(S): ASPNetVersion = 2.0.50727
Property(S): ARPHELPLINK = http://go.microsoft.com/fwlink/?LinkId=52152
Property(S): ARPPRODUCTICON = ARPIcon.ico
Property(S): ARPNOREPAIR = 1
Property(S): ARPSYSTEMCOMPONENT = 1
Property(S): MsiHiddenProperties = SQLPASSWORD;AGTPASSWORD;ASPASSWORD;RSPASSWORD;SQLBROWSERPASSWORD;RSSQLPASSWORD;RSSQLPassword;RSSQLPasswordQuoted;RSSETUPPASSWORD;RSSetupPassword;SAPWD;saPWD;UPGRADEPWD;SqlUpgradePwd;SQLPassword;ServicePassword;ADMINPASSWORD;PIDKEY;FTEPassword.68C6D15C_77E0_11D5_8528_00C04F68155C;checksum.7354AFCB_913B_4E9F_B76C_2376101FDE0C;checksum.;DigitalProductID;DPID;Do_sqlScript.D20239D7_E87C_40C9_9837_E70B8D4882C2;Rollback_SqlConnection.D20239D7_E87C_40C9_9837_E70B8D4882C2;Do_XmlSingleNode.D20239D7_E87C_40C9_9837_E70B8D4882C2;Do_RSSetting.D20239D7_E87C_40C9_9837_E70B8D4882C2;PID;ProductID;RSUPGRADEPASSWORD;Do_RSSetSharePointExclusionPath.D20239D7_E87C_40C9_9837_E70B8D4882C2
Property(S): SecureCustomProperties = SQL_SHOWLIC;UPGRADESQL90
Property(S): SqlServerBuild = 1
Property(S): SqlCluster = 0
Property(S): INSTALLLEVEL = 90
Property(S): FXAssemblyVersion = 2.0.0.0
Property(S): VSAssemblyVersion = 8.0.0.0
Property(S): SqlErrorReporting = #0
Property(S): SqlSqmReporting = #0
Property(S): SqlEnableRanu = 0
Property(S): SqlPatchLevel = 9.1.2047
Property(S): ChannelID = 271
Property(S): PIDTemplate = 77656<````=````=````=````=`````>@@@@@
Property(S): mpc = 77656
Property(S): OEMRelease = 0
Property(S): PIDKEY = **********
Property(S): ProgramFilesFolder = C:Archivos de programa
Property(S): ProductID = **********
Property(S): SqlInstanceName = MSSQLSERVER
Property(S): SqlSecurityMode = SQL
Property(S): SqlClusterSec = 0
Property(S): MDACSXS = 1
Property(S): DefaultUIFont = Tahoma8
Property(S): VersionNT = 502
Property(S): LocalSystemAccount = NT AUTHORITYSYSTEM
Property(S): DefaultBuiltInAccount = LocalSystemAccount
.....
Thks
View 25 Replies
View Related
Aug 26, 2006
I've problem in setup Microsoft SQL server 2005 when i click on setup this error message appear
View 9 Replies
View Related
Feb 19, 2007
Hi Folks,
I'm receiving an error when i'm trying to setup a maintenance plan. I'm getting weird errors (and cannot continue) and i'm thinking it's related to a 32 bit error i received during installation on a 64 bit edition.
Background
We have a sql server behind hosted on a dedicated 64 bit box out of SanFran. The hosting company installed the 32 bit version of SqlServer 2005 standard on the box and I requested them to remove it and put the 64 bit edition on. They removed the 32 bit edition and installed the 64 bit edition. So far so good. I installed sp1 and that was fine. I then tried to start a MAINTENCE PLAN and was denied -> the component was not installed. I've asked them to install the component and they did, but they recorded an error during the install. The error screen shot is here: http://img525.imageshack.us/img525/5089/errormessagehs4.png
Now i cannot drop any tasks onto the maintenence plan ... so i'm assuming it's related to the above error. Is there any way i can determine what the 32 bit component is, remove it and re-install the correct component? Is there an error log somewhere where i can check things?
This is stopping me from setting up any backup plans :(
Regards,
Justin.
View 8 Replies
View Related
Mar 4, 2008
hi Champion,
My machine is already having vs2003 with sqlserver 2000. Now when I have installed vs2005 that time I have not loaded sqlserver 2005 express edition.
But now when am trying to install the same i.e sqlserver 2005 express edition its unable to install/update this database.
the error coming as "None of the selected features can be installed or upgraded. Setup cannot proceed since no effective change is being made to the machine. To continue click Back, and then select features to install. To exit sql server setup, click cancel"
pls help
View 1 Replies
View Related
Apr 17, 2008
I updated a windows application. It runs great on my development box.
We then published it to a web site. When they run the application it prompts them to update. The process begins and then they get the following message.
Unable to install or run the application. The application requires that assembly Microsoft.SqlServer.PipelineHost Version 9.0.242.0 be installed in the Global Assembly Cache (GAC) first. Please contact your system administrator.
Any ideas?
View 8 Replies
View Related
Jul 31, 2007
Currently I am just trying to completely remove all Vista Ultimate's knowledge of installed instances of SQLServer 2005 Developer edition.
I cannot do this for some reason. This all began when I tried to install SQLServer 2005 and it installed but I could not connect to it. Now I have two installed instances that I cannot access, after removing all SQL programs from the Programs and Features icon in the control panel.
I tried running "WIndows Installer CleanUp Utility" as I read in a thread on this forum. This did not help. After going thru and removing all SQLServer programs using the "programs and features" icon in control panel... The installation process shows two installed instances of SQLServer 2005.
1) How can I completely erase all Vista Ultimate's knowledge of any SQLServer 2005 install and start over?
I have downloaded SQLServer 2005 SP 2, and run it, but clearly what I should do, and what Microsoft has asked me to do are not working...
2) What should I be doing to install SQLServer 2005 Developer Edition successfully?
I have been a strong supporter of Microsoft, but this is getting me very frustrated.
Please help,
- Chaz
View 3 Replies
View Related
May 25, 2007
I have Windows XP Professional Version 2002 Service Pack2.
I Have:
Microsoft SQL Server Management Studio 9.00.2047.00
Microsoft Analysis Services Client Tools 2005.090.2047.00
Microsoft Data Access Components (MDAC) 2000.085.1117.00 (xpsp_sp2_rtm.040803-2158)
Microsoft MSXML 2.6 3.0 5.0 6.0
Microsoft Internet Explorer 7.0.5730.11
Microsoft .NET Framework 2.0.50727.42
Operating System 5.1.2600
Service Pack is failing to Install CLIENT COMPONENTS; message is:
Product : Client Components
Product Version (Previous): 2047
Product Version (Final) :
Status : Failure
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGHotfixSQLTools9_Hotfix_KB921896_sqlrun_tools.msp.log
Error Number : 29549
Error Description : MSP Error: 29549 Failed to install and configure assemblies c:Program FilesMicrosoft SQL Server90NotificationServices9.0.242Binmicrosoft.sqlserver.notificationservices.dll in the COM+ catalog. Error: -2147024894
Error message: The system cannot find the file specified.
Error description: Could not load file or assembly 'System.EnterpriseServices, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a' or one of its dependencies. The system cannot find the file specified.
This situation, I am guessing, also preventing me to run import/export from the SQLServer Client.
Any help is appreciated. Thanks.
View 6 Replies
View Related
Feb 23, 2007
Hello,
I am kind of new with .Net development and really new with using SqlExpress. Here is my question, I hope it is easy:
I have a shareware program that I have been selling since 2000 and it was written in VB6 using a third party database program. What I would like to do is rewrite this application using C# and SqlServer Express. The program as it stands right now is about 5mb to download and install.
My concerns:
1) How do I embed and quietly install sqlserver express to the end user's computer without them having any intervention?
2) By using sqlserver express as my database how much extra overhead is going to be included in the install package? I want to keep the install package as small as possible and the user experience of installing the program as painless as possible.
Thanks in advance,
View 8 Replies
View Related
Apr 11, 2000
Got the following message while trying to apply sp5a:
"Setup initialization could not be successfully completed.
ISQL.EXE could not be executed. Please check the relevant .OUT file."
And yes, i did check the readme file, but found no problem in the PATH variable.
(unless I'm looking at it wrong!)
Please help!
View 2 Replies
View Related
Feb 9, 1999
I am trying to apply SQL Server Service Pack 5a to my original SQL
Server 6.5 but an error keeps coming up "Setup initialization could not
be successfully executed. ISQL,EXE could not be executed.Pls check
relevant .out file".
The last line of the relevant .out file produced by this error is:
You cannot run SELECT INTO this database. The DBO would have to run
sp_dboption to enable this option.
Msg 208, Level 16, State 1, Server REYWINNT, Procedure sp_helpsort, Line
295
I would appreciate any help to solve my problem
Thanks a lot
Rey Caunca
View 2 Replies
View Related
Mar 10, 1999
I have a third party app that has been 'certified' by the vendor on SQL 6.5 SP5. We are aware of the dump database issues when using SP5 and Enterprise Manager. We would like to use SP5a to get around those issues.
Is anyone aware of any other 'bugs' or problems that have come about in SP5a....
Thanks tons!
Dean
View 1 Replies
View Related
Jun 28, 1999
Is there a proper order to installing SQL SP5a. Should you reinstall NT SP4 after you install
the SQL SP5a?
View 1 Replies
View Related
Jan 13, 2000
I've got a script that runs regularly to monitor log space usage on a SQL 6.5 sp5a server. Where the log space usage is greater than 75% it then dumps the log. However the Enterprise Manager screen still shows usage as being above 75%. I'm aware that I need to run dbcc checktable(syslogs) to have EM reflect the change, and my question is:
Within my sql script how do I switch context to the database where I need to run the dbcc checktable(syslogs) command?
View 4 Replies
View Related
Sep 10, 1999
I currently have SP5 in a folder on the server desktop. MSSQL Server is installed on drive E:
Running setup, it finds SQL Server and shuts it down. It then returns errors about not being able to find files, though the files are actually there.
I appologize for the brain-cramps, as I know this has been discussed before, but I need HELP ASAP.
Thanks
Steve Jimmo
View 1 Replies
View Related
Jun 17, 1999
I run replication among several SQL 6.5 Servers with SP3. Recently,
I've applied SP5a to publisher/distributor. After that, some publications
continued to replicate normally, but two of them started to act strangely -
the distribution tasks end succesfully, but it seems that no transactions
were marked for replication.
After investigating a bit, I've found that the data that continued to
replicate normally is modified by stored procedures, while problematic
tables are updated directly. Then I've tried to run isql/w updates against
problematic tables - all the changes were succesfully applied to the
subscribers. The other difference between problematic and non-problematic
tables is their size - problematic tables are much bigger and more
frequently updated.
All the subscribers are still SQL 6.5 Servers with SP3. One of them
is also a publisher that uses SP5a-upgraded SQL Server as remote
distributor. Its publications replicate OK.
I'd appreciate any explanation of the above.
Thanks
Maja
View 2 Replies
View Related
Feb 22, 1999
I've installed SQL Server Service pack 5a on our test lab Database and have come up with problems with my protocol. Everything works fine IF I set the Net Library to Named pipes. But before the service patch, I was running Multi-Protocol WITH TCP/IP (much faster). How can I make SQL use Multi?
Using Named pipes screws up my replication. Any suggestions???
Thanks,
Andrew
P.S. I also have SP4 on WindowsNT.
View 2 Replies
View Related
Feb 3, 2000
HELP!!!!!!!!!!!!!!!!!!
I loaded SQL SP5a last night on my SQL Server and now none of my users can connect and run their applications.
I removed the virtual server and loaded the sp without any problems (so it seemed). "sa" works fine.
I am getting login failed errors:
Sql State 28000 and Sql Server 4002
Any thougts, ideas, curses would be GREATLY APPRECIATED!!!!!!!!!!!!
View 2 Replies
View Related
Dec 24, 1999
Hi:
I installed SQL sp5a on most SQL servers with no error. However, one server, a special application failed after upgrading to sp5a.
Is there a way to uninstall sp5a and back to sp3 without re-install entire SQL 6.5 on this particular machine?
thanks in advance
david
View 1 Replies
View Related
Jul 28, 1999
While installing the service pack 5a, I had the following error
"setup could not be successfully completed,
ISQL.EXE could not be executed. Please check the relevant *.Out file.
Now I am unable to start up my SQL service. When I try to start it , I get the following message:
Error : 1105, Severity: 17, State: 2
Can't allocate space for object 'Syslogs' in database 'master' because the 'logsegment' segment is full. If you ran out of space in Syslogs, dump the transaction log. Otherwise, use ALTER DATABASE or sp_extendsegment to increase the size of the segment.
Apparently 4 mb of free space in my master database was not enough for the service pack. I can't extend the size of my Master database because I can't get the SQL service to start.
Any suggestions?
LH
View 1 Replies
View Related
Dec 28, 1999
Hi all,
I recently upgraded to SQL 6.5- sp5a. I run DBCC TEXTALL as part of my nightly maintenance. Our db is about 3 GB and is heavy on text
fields. Since the upgrade, DBCC TEXTALL hangs up the server until I reboot it. The last message in the error log is "Warning:
out of RA slots... comfigure more RA slots." (or something like that). This never happened before.
BOL says don't monkey with the RA slots per thread, so
I've been adjusting the number of RA worker threads. I raise it, bounce SQL SERVER, and try to run the DBCC TEXTALL again.
Same results. Eventually I got up to 10 RA worker threads, at which point I got an "IO buf_wait" error, which also hung up the server.
I've read that increasing RA worker threads will eventually run you out of buffer space, and it looks like that's what happened.
I'm beginning to think that the problem isn't really with isn't really with the number of RA worker threads I have configured,
but rather with something that sp5a changed. Or maybe DBCC TEXTALL is running into some sort of corruption it can't handle...
Or something...
So, I'm reading up on the relationship between buffer cache, RA, etc., but
the sad fact is that information on that low down level is hard to find, and I don't understand most of it anyway.
Any suggestions, reading recommendations, comments, or jeers would be highly appreciated.
View 1 Replies
View Related
Sep 3, 1999
When running Enterprise Manager from my desktop pc to try and expand a database device I am unable to do so. The size shown is negative, and the max size is the same, with the 'Change Now' box greyed out.
When I log on directly onto the server I can easily expand the db device. There is lots of free space on the server.
Our set up is quite small with four NT workstations and two NT servers with SQL Server 6.5 on them. All these six machines are in the same workgroup. The workstations are on a separate floor to the servers, which are in the computer room. I have a feeling this is a networking issue. Can anyone suggest why this is happening?
View 3 Replies
View Related
Aug 10, 1999
Hi,
Has anyone encountered this?
After applying SP 5a I found out that my SQL strings with sums and groups produced double rows. I found out that grouping one column (type CHAR(6)) produced two distinct rows of the equal values.
All the values in that column have 4 characters, but it seemed like some distinct values were grouped by the whole field length i.e 6 characters. I haven't seen earlier that those blanks after field value change the grouping results.
When I transferred the table and data to old SQL Server without any SPs, query showed distinct values correctly.
The sort order and other settings are the same. Can anyone tell where to look for help?
TIA, Al
View 1 Replies
View Related
