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?
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...
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
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...
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?
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..
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?
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
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.
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: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.
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 :(
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
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.
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.
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.
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.
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 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....
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?
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'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???
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.
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.
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?
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?
