SQL2k5 Install - DTS/COM Error
May 7, 2008
Having problems installing SQL 2005 Developers Edition on a Terminal Services Server that already has SQL 2000 Developers Edition on it. I keep getting this error, no matter in what order I install packages:
Failed to install and configure assemblies M:Program FilesMicrosoft SQL Server90DTSTasksMicrosoft.SqlServer.MSMQTask.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.
The help link says to set the DTC service up to run as a network service and start it, but it already is and is already running. Restarting the DTC and then clicking on retry yields the same error.
Any ideas? I've been beating my head against this machine for a couple of days now.
Thanks.
Phil Hershey
View 3 Replies
ADVERTISEMENT
Jun 10, 2008
I found that SQL2K5 doesn't prompt for file locations while installing - for binaries and databases. Is this the default behavior?
------------------------
I think, therefore I am - Rene Descartes
View 4 Replies
View Related
Aug 2, 2007
Hello everyone,
I need to get a server built for a client today. He has sent me the proof of purchase for his SQL2005. He is working on getting me the licence / cd key today (if thats even possible?).
I have our SQL 2005 server CD here that I wanted to use however when I get to the company name stage of the install the CD-key/licence code is greyed out. Any ideas on how I can change the embedded cdkey/licence to the clients so I can use our media today but with our clients cdkey?
This needs to be done today, its extremly important but due to a problem with logistics the media from the client was delayed untill mid next week.
Any help you can provide would be aprecaited.
Cheers
~Chris
View 4 Replies
View Related
Jun 19, 2006
We have a new cluster that we are trying to install SQL 2k5 enterprise on and the security requirements will not allow us to install IIS on the same server as SQL. Is there a way around the requirement of having IIS installed on the server with SQL 2k5?
View 3 Replies
View Related
Sep 10, 2007
Hi, i created a report and i want to deploy it so i can view it in my browser, when i use deploy i get the following error:
Error1The permissions granted to user 'SRVDBTESTIUSR_SRVDBTEST' are insufficient for performing this operation.00
im logged in as administrator, i used mixed mode, where can i find that useraccount so i can give it more rights?
thx
View 1 Replies
View Related
Jun 1, 2007
I am dealing with the same issue posted in this other thread that seems to have died with no solution found:
http://forums.microsoft.com/TechNet/ShowPost.aspx?PostID=1131407&SiteID=17
Almost as soon as I start to install SQL 2005 on my Windows XP Pro Version 2002 Service Pack 2 machine at work it pops up a dialog with one of the following 2 error messages (they alternate randomly):
The SQL Server System Configuration Checker cannot be executed due to WMI configuration on the machine PCF092191 Error:2147500034 (0x80004002).
The SQL Server System Configuration Checker cannot be executed due to WMI configuration on the machine PCF092191 Error:2147749907 (0x80041013).
After clicking OK the installation just closes.
I also discovered when I load wmimgmt.msc and click Properties on the WMI Control, I get the following errors on the General tab, AND it does not allow me to click on any other tabs:
Failed to initialize all required WMI classes.
Win32_Processor: <Null>: No such interface supported
Win32_WMISetting: Successful
Security information: Successful
Win32_OperatingSystem: <Null>: No such interface supported
I have been searching online for days and tried doing virtually everything I found that I could understand and nothing works. Reinstalling WMI off the XP CD doesn't work, rebuilding the WMI repository doesn't work, registering all the WMI DLLs and MOF files doesn't work, running all the various scripts to fix WMI that are posted all over online doesn't work.
I downloaded the Microsoft WMI Diagnostics tool and ran it. It printed a ton of errors in a 466-line report that I can't make head or tail of. 6 here, 33 there, 27 over there...almost too many to count. The suggestions it gives to fix them range from vague and incomplete to incomprehensible. I'll paste those error results into a followup post.
I installed the WMI Tools package and can't figure out what to do with any of the tools at all. The only thing I noticed is that when examining a section under Win32_Processor, most entries for various properties are marked <empty>, while I have seen people discussing what I think are those same properties online and talking about seeing stuff typed into theirs (such as the HostingModel having LocalServiceHost typed in and ImpersonationLevel having 1 typed in). But there are so many properties and I'm not sure what should be typed into all of them or if I'm even looking in the right place.
I've seen some suggestions in WMI documentation that not all WMI errors may be related to WMI itself at all, which I think might be the case here, but I don't know. Some material said DCOM may be the problem, but I didn't have much luck figuring out how to fix that either. From the WMI Diagnostics it looks like there may be multiple errors of different kinds, but if it's that bad, I don't know how my computer's been working at all.
I've been using this computer for 9 months and had no major problems with it, although I did have a problem installing Microsoft Windows Genuine Advantage Notification, for which Microsoft sent me a script that fixed it. One other person here at work is suffering from this same WMI error, but most people have been able to install SQL 2005 here with no problem.
My boss does not want me to just do a full XP reinstall. He wants me to identify the specific problem and fix it. If this was my home computer I wouldn't spend so much time banging my head over this incomprehensible problem. But a full reinstall is not really an option for me in this case, unless maybe Microsoft says that's the only way to fix it.
I am available to deal with this issue during 9 to 5 eastern time Monday to Friday.
Thanks in advance for any help...
Eric
View 3 Replies
View Related
Jan 19, 2007
This is (some of) the output from the Core(Local)log:
If possible, determine action
Machine = DJONES-XP, Article = WMIServiceWin32OSWorking, Result = 2147500034 (0x80004002)
Machine = DJONES-XP, Article = WMIServiceWin32CompSystemWorking, Result = 2147500034 (0x80004002)
Machine = DJONES-XP, Article = WMIServiceWin32ProcessorWorking, Result = 2147500034 (0x80004002)
Machine = DJONES-XP, Article = WMIServiceReadRegWorking, Result = 0 (0x0)
Machine = DJONES-XP, Article = WMIServiceWin32DirectoryWorking, Result = 70347 (0x112cb)
Machine = DJONES-XP, Article = WMIServiceCIMDataWorking, Result = 70347 (0x112cb)
Machine = DJONES-XP, Article = XMLDomDocument, Result = 0 (0x0)
*******************************************
Setup Consistency Check Report for Machine: DJONES-XP
*******************************************
Article: WMI Service Requirement, Result: Error
Description: Windows Management Instrumentation (WMI) is not functioning properly. Further checks cannot be performed. Action: Please make sure Windows Management Instrumentation (WMI) is functioning properly.
The SQL Server System Configuration Checker cannot be executed due to WMI configuration on the machine DJONES-XP Error:2147500034 (0x80004002).
The checkResult returned is 2147500034
The checkResult for local machine returned by CheckSCCResult is 70036
Setup is unable to proceed because one of scc articles failed. Please address those errors before continuing the setup.
Thanks DeWayne
View 14 Replies
View Related
Nov 14, 2007
Hi,
I've tried looking for a solution in other threads but I couldn't find anything that was completely the same as my situation. I got a new pc at work and I've tried installing SQL Server 2005 on it but everytime I try to install it, regardless of services included or excluded with the install, I cannot get through the install without this error. Below is the excerpt from the Summary.txt log file.
Error Code: -2147024894
MSI (s) (74!98) [17:10:55:858]: Product: Microsoft SQL Server 2005 Tools -- 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.
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.
<Func Name='GetCAContext'>
<EndFunc Name='GetCAContext' Return='T' GetLastError='203'>
Doing Action: Do_sqlAssemblyRegSvcs
PerfTime Start: Do_sqlAssemblyRegSvcs : Mon Nov 12 17:10:55 2007
<Func Name='Do_sqlAssemblyRegSvcs'>
Failed to install and configure assemblies C:Program FilesMicrosoft SQL Server90NotificationServices9.0.242Binmicrosoft.sqlserver.notificationservices.dll in the COM+ catalog.
Error: 2147942402
Error message: The system cannot find the file specified.
Error descrition: 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.
Error Code: -2147024894
Windows Error Text: The system cannot find the file specified.
Source File Name: sqlcasqlassembly.cpp
Compiler Timestamp: Thu Aug 11 01:12:01 2005
Function Name: Do_sqlAssemblyRegSvcs
Source Line Number: 155
I've searched for and found similar problems that deal with the microsoft.sqlserver.notificationservices.dll not being found but I haven't found a fix that worked for me. These are the fixes I've refered to thus far.
http://forums.microsoft.com/TechNet/ShowPost.aspx?PostID=1651162&SiteID=17
http://support.microsoft.com/kb/940971
http://www.microsoft.com/products/ee/transform.aspx?ProdName=Microsoft+SQL+Server&ProdVer=9.00.1399.06&EvtSrc=setup.rll&EvtID=29549&EvtType=sqlcasqlassembly.cpp@Do_sqlAssemblyRegSvcs@Do_sqlAssemblyRegSvcs@x80131501
The answer that seems to fix this problem for everyone is to set the MSDTC service login as the NT AUTHORITYNetworkService account. The problem for me is that this is already set to this profile and I've tried resetting the services and rebooting the machine. I did not have a problem with my old machine, which as far as I can tell, is the same configuration, so I know this install should work.
I'm running Windows XP SP2. This is not the upgrade to SQL Server 2005 SP2, this is the original disk that came with Visual Studio 2005.
Has anyone else faced this issue where changing the MSDTC login wasn't the solution? Also, this is my first post, so I apologize if I've left anything out. Just let me know if you want any other information.
Thank you in advance.
Tim
View 7 Replies
View Related
Jun 12, 2007
I'm currently receiving the following error message whilst attempting to install SQL Server 2005 Standard Edition on Windows Server 2003 (32 Bit):
Error 29528. The setup has encountered an unexpected error while Installing performance counters. The error is: The system cannot find the file specified.
This server already has an install of SQL Server 2000 as the default instance. I'm attempting to install a new named instance of SQL Server 2005.
Extract from log:
<Func Name='LaunchFunction'>
Function=Do_sqlPerfmon2
<Func Name='GetCAContext'>
<EndFunc Name='GetCAContext' Return='T' GetLastError='0'>
Doing Action: Do_sqlPerfmon2
PerfTime Start: Do_sqlPerfmon2 : Tue Jun 12 10:20:02 2007
<Func Name='Do_sqlPerfmon2'>
<EndFunc Name='Do_sqlPerfmon2' Return='0' GetLastError='2'>
PerfTime Stop: Do_sqlPerfmon2 : Tue Jun 12 10:20:02 2007
MSI (s) (4C:FC) [10:20:02:833]: Executing op: ActionStart(Name=Rollback_Do_sqlPerfmon2.D20239D7_E87C_40C9_9837_E70B8D4882C2,Description=Removing performance counters,)
<EndFunc Name='LaunchFunction' Return='0' GetLastError='0'>
MSI (s) (4C:FC) [10:20:02:849]: Executing op: CustomActionSchedule(Action=Rollback_Do_sqlPerfmon2.D20239D7_E87C_40C9_9837_E70B8D4882C2,ActionType=1281,Source=BinaryData,Target=Rollback_Do_sqlPerfmon2,CustomActionData=100Removing performance counters200000DTSPipelineC:Program FilesMicrosoft SQL Server90DTSBinnDTSPERF.INI)
MSI (s) (4C:FC) [10:20:02:849]: Executing op: ActionStart(Name=Do_sqlPerfmon2.D20239D7_E87C_40C9_9837_E70B8D4882C2,Description=Installing performance counters,)
MSI (s) (4C:FC) [10:20:02:849]: Executing op: CustomActionSchedule(Action=Do_sqlPerfmon2.D20239D7_E87C_40C9_9837_E70B8D4882C2,ActionType=1025,Source=BinaryData,Target=Do_sqlPerfmon2,CustomActionData=100Installing performance counters200000C:Program FilesMicrosoft SQL Server90DTSBinnDTSPERF.INIC:Program FilesMicrosoft SQL Server90DTSBinnDTSPERF.HC:Program FilesMicrosoft SQL Server90DTSBinnDTSPipelinePerf.dllDTSPipeline0DTSPipelinePrfData_OpenPrfData_CollectPrfData_Close)
MSI (s) (4C:94) [10:20:02:864]: Invoking remote custom action. DLL: C:WINDOWSInstallerMSI1683.tmp, Entrypoint: Do_sqlPerfmon2
<Func Name='LaunchFunction'>
Function=Do_sqlPerfmon2
<Func Name='GetCAContext'>
<EndFunc Name='GetCAContext' Return='T' GetLastError='0'>
Doing Action: Do_sqlPerfmon2
PerfTime Start: Do_sqlPerfmon2 : Tue Jun 12 10:20:02 2007
<Func Name='Do_sqlPerfmon2'>
<EndFunc Name='Do_sqlPerfmon2' Return='2' GetLastError='2'>
PerfTime Stop: Do_sqlPerfmon2 : Tue Jun 12 10:20:02 2007
Gathering darwin properties for failure handling.
Error Code: 2
MSI (s) (4C!F0) [10:23:46:381]: Product: Microsoft SQL Server 2005 Integration Services -- Error 29528. The setup has encountered an unexpected error while Installing performance counters. The error is: The system cannot find the file specified.Error 29528. The setup has encountered an unexpected error while Installing performance counters. The error is: The system cannot find the file specified.
You can ignore this and it will complete the installation, but subsequently trying to patch with SP2 will fail on the same sections - Hotfix.exe crashes whilst attempting to patch Database Services, Integration Services and Client Components (3 separate crashes).
I've removed SQL Server 2005 elements and tried to re-install, but it's not improved the situation.
Any ideas?
View 3 Replies
View Related
Dec 28, 2007
Have people installed SP2 on SQL2k5 . Any problems / issues with that especially wrt failover clustering .
View 4 Replies
View Related
Apr 10, 2008
How to schedule a DTS package residing in LEGACY container, from SQL2K5?
------------------------
I think, therefore I am - Rene Descartes
View 5 Replies
View Related
Mar 30, 2007
In SQL2K EM you can right click a DB, and backup. Finally there is a option to schedule, which will create a job.
Is this option has been removed from SQL2K5?
------------------------
I think, therefore I am - Rene Descartes
View 7 Replies
View Related
May 9, 2008
Is there any reason why an application running on a 32-bit O/S that works with a SQL Server 2K database would not work with a SQL Server 2K5 64-bit database running on a 64-bit O/S?
It is my understanding that the connection layer (be it ODBC, OLEDB, ADODB, etc) would obfuscate any details regarding the underlying architecture... I wouldn't think the instructions sent would need to be any different, unless there is some deprecated call that is no longer supported.
Thanks in advance for any assistance!
View 5 Replies
View Related
Dec 17, 2007
Hello,
I have installed in a workstation (windows xp pro) sql 7 server (database engine + client tools).
After that I installed sql server 2005 with named instance (hostmyinstance).But I didn't end this installation.
I had a message saying me that there are problems on clients tools. moreover when I open a dos window and type "sqlcmd", I have the same message (client problems).
I then change my sql7 port to 1434 (which isn't the default port).But even with that my sql 2005 sqlcmd don't work correctly.
My question is :
can one install sql 7 (server + client tools) and sql 2005 (server + client tools) in the same machine ( a workstation [windows xp pro] )?
View 3 Replies
View Related
May 20, 2008
Dear All,
I have a need to replicate data between MS Access and SQL 2005 (Enterprise Edition).
Could someone give advice as to whether this is possible or not, and how I might go about setting it up?
Thanks
Krishna
View 3 Replies
View Related
Oct 9, 2007
Hi
I am a Oracle DBA who is going to embark upon a
oppurtunity to migrate Oracle to sqlserver.
Can somebody give me tips for
Learning sqlserver2k5 for a Oracle DBA Books
Or Beginner DBA/Development Books for sql2k5
How good is the migration assistant from m$$ for
migrating from oracle to sql2k5
Does it migrate data as well as procedural code ?
Do you anything for me to watch out for best parctices
migration guides
You opinion would be higly appreciated
regards
db2hrishy
View 2 Replies
View Related
Mar 27, 2008
For a SQL/2005 DB Server do I need the /3GB switch or not? I will have IIS running on the server; however, it won't be doing very much as the SQL Database is the main thing:
Windows 2003 R2 Enterprise w/16 GIG RAM 4 CPU (Virtual Machine)
SQL/2005 Enterprise Edition
Hardware: Dell Server 8 CPU w/32 GIG RAM running VM ESX V3
I know I need the /PAE switch to utilize Memory over 4 GB - the question is do I need the /3GB switch along with the /PAE switch?
DeWayne
View 1 Replies
View Related
Nov 2, 2006
I need tyo move tables from Oracle 9.2 or 10.2 version to SQL server 2005.Can any one give me some good hints, scripts etc.I try to look into the Business Intellegent Studio, but I only see Report,Analaysis or Integration services - NO DTS.Can someone tell me where to find it. It used to be so easy in 2000.Thanks,Nasir
View 4 Replies
View Related
Feb 28, 2008
I have a partition view named StudentRequest with underlying tables StudentRequest_T1 and StudentRequest_T2.
Primary Key is on NumericSchoolDBN, SchoolYear, TermId, StudentID, CourseCode
Partition View
Create View dbo.StudentRequestPartView with SchemaBinding
as
Select
NumericSchoolDBN, SchoolYear, TermId, StudentID, CourseCode, AssignedCourseCode, AssignedSectionId,
LockAssignedRequest, UpdatedByPID, UpdatedDate, CreatedByPID, CreatedDate, AuditCommentId, DebugTrace
from dbo.[StudentRequest_T1]
union all
Select
NumericSchoolDBN, SchoolYear, TermId, StudentID, CourseCode, AssignedCourseCode, AssignedSectionId,
LockAssignedRequest, UpdatedByPID, UpdatedDate, CreatedByPID, CreatedDate, AuditCommentId, DebugTrace
from dbo.[StudentRequest_T2]
go
Partition Tables
CREATE TABLE [dbo].[StudentRequest_T1](
[NumericSchoolDBN] [int] NOT NULL,
[SchoolYear] [smallint] NOT NULL,
[TermId] [tinyint] NOT NULL Check ([TermID] = 1),
[StudentID] [int] NOT NULL,
[CourseCode] [varchar](10) NOT NULL,
:
)
CREATE TABLE [dbo].[StudentRequest_T2](
[NumericSchoolDBN] [int] NOT NULL,
[SchoolYear] [smallint] NOT NULL,
[TermId] [tinyint] NOT NULL Check ([TermID] = 2),
[StudentID] [int] NOT NULL,
[CourseCode] [varchar](10) NOT NULL,
:
)
I am able to insert, update and delete records in the StudentRequest view using simple DML SQL statements i.e.
e.g.
Insert into Student Request (NumericSchoolDBN, SchoolYear, TermId,€¦)
Values(12345, 2006, 1,€¦)
Delete from StudentRequest Where NumericSchoolDBN = 12345 and TermId = 1
But when I use complex SQL statements using self-joins€¦
Insert into Student Request (NumericSchoolDBN, SchoolYear, TermId,€¦)
Select NumericSchoolDBN, SchoolYear, TermID,€¦.
From Student Request sr1 left outer join Student Request sr2 on
Sr1.NumericSchoolDBN = Sr1.NumericSchoolDBN and
Sr1.SchoolYear = Sr2.SchoolYear and
Sr1.TermId = Sr2.TermId and
Sr1.StudentID = Sr2.StudentID and
Sr1.CourseCode = Sr2.CourseCode
I get the following error and I can€™t seem to find any documentation that this is a limitation!!!...
Msg 4439, Level 16, State 6, Procedure Course_UpdateCoursePromotion, Line 232
Partitioned view 'STARS.dbo.StudentRequest' is not updatable because the source query contains references to partition table '[STARS].[dbo].[StudentRequest_T1]'.
View 5 Replies
View Related
Apr 13, 2006
Hi,
We recently migrated from a SQL 2K to 2K5. We had an automatic DTS scheduled every night that would transfer data to a MySQL server on one of our client€™s machine. It worked like a charm in SQL 2K.
I am trying to figure out how I can connect to a MySQL data source using SSIS in 2K5 as I don€™t see an ODBC Destination anywhere in the Data Flow Task; and run the same transfer using 2K5.
Do I have to add a reference of some kind or does 2K5 doesn€™t support ODBC destinations?
Thanks
View 8 Replies
View Related
May 7, 2007
I continue to have issues with SP-2 for SQL 2005 suite. It has now gotten so bad, I have multiple installations, including the TOOLS ONLY on my laptop failing, that I am going to stop ALL future installations of SP-2. The COM+ failures have not been resolved that I can determine. I have tried uninstalling, I have tried SP-1 before SP-2, every combination one can find. HELP.
Time: 05/07/2007 13:24:05.631
KB Number: KB921896
Machine: GA029-MDGRAVES
OS Version: Microsoft Windows XP Professional Service Pack 2 (Build 2600)
Package Language: 1033 (ENU)
Package Platform: x86
Package SP Level: 2
Package Version: 3042
Command-line parameters specified:
Cluster Installation: No
**********************************************************************************
Prerequisites Check & Status
SQLSupport: Passed
**********************************************************************************
Products Detected Language Level Patch Level Platform Edition
Setup Support Files ENU 9.00.1399.06 x86
SQL Server Native Client ENU 9.00.3042.00 x86
Client Components ENU RTM 9.00.1399.06 x86 STANDARD
MSXML 6.0 Parser ENU 6.00.3883.8 x86
Backward Compatibility ENU 8.05.1054 x86
**********************************************************************************
Products Disqualified & Reason
Product Reason
**********************************************************************************
Processes Locking Files
Process Name Feature Type User Name PID
**********************************************************************************
Product Installation Status
Product : Setup Support Files
Product Version (Previous): 1399
Product Version (Final) : 3042
Status : Success
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGHotfixRedist9_Hotfix_KB921896_SqlSupport.msi.log
Error Number : 0
Error Description :
----------------------------------------------------------------------------------
Product : SQL Server Native Client
Product Version (Previous): 3042
Product Version (Final) :
Status : Not Selected
Log File :
Error Description :
----------------------------------------------------------------------------------
Product : Client Components
Product Version (Previous): 1399
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: -2146233087
Error message: Unknown error 0x80131501
Error description: MSDTC was unable to read its configuration information. (Exception from HRESULT: 0x8004D027)
----------------------------------------------------------------------------------
Product : MSXML 6.0 Parser
Product Version (Previous): 3883
Product Version (Final) : 6.10.1129.0
Status : Success
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGHotfixRedist9_Hotfix_KB921896_msxml6.msi.log
Error Number : 0
Error Description :
----------------------------------------------------------------------------------
Product : Backward Compatibility
Product Version (Previous): 1054
Product Version (Final) : 2004
Status : Success
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGHotfixRedist9_Hotfix_KB921896_SQLServer2005_BC.msi.log
Error Number : 0
Error Description :
----------------------------------------------------------------------------------
**********************************************************************************
Summary
One or more products failed to install, see above for details
Exit Code Returned: 29549
View 3 Replies
View Related
Feb 20, 2007
I installed SP1 for SS 2005 on a quasi-production server, which is why I didn't mind rebooting the server. Unfortunately, it's been 5 hours and the server still hasn't rebooted. (I see a gray screen and a pointer, and that's it... but there's still disk access happening. I'm not really sure what it's doing.)
What's the best way to avoid the 5 hour reboot in the future?
Thanks,
Robert
View 3 Replies
View Related
Nov 28, 2005
Is it possible to convert a SQL2K datafile to SQL2K5? I have a 2K database that I need to easily convert to 2K5, I apprecaite any insight on this issue.
View 1 Replies
View Related
Jun 7, 2007
Hello All:
From my previous post it seems that the general consensus is for me to use backup and Restore to upgrade a dB from SQL2K to SQL2K5.
Could anyone refer me to some explicit instructions for doing this?
I have SQL2K5 and SQL2K on separate servers and I cannot back the dB up to SQL2K5. I also can't access the drives for SQL2K from SQL2K5. I'm hoping it's a simple mistake.
Any advice or guidance is greatly appreciated.
Thanks,
Cleech
View 3 Replies
View Related
Oct 16, 2007
I am trying to create a Linked server between Access 97 and SQL2K5
provider=Microsoft.Jet.OLEDB.4.0
MDAC version installed on SQL server system is 2.8
with same configuration if i convert MDB file to Office 2000 then its working fine
Please advice
View 1 Replies
View Related
Nov 8, 2007
I want to copy a SQL2005 database to a SQL2000 environment? I created a backup from the DB in SQL2005 and moved the file to the other server but SQL2000 says the BAK file is invalid since the backup has structure version 611 while the server supports version 539. Any solution?
Canada DBA
View 6 Replies
View Related
Jan 26, 2007
I've populated reporting DB's in the past using different techniques:
1. Have Transactions in Data Tier Write to OLTP AND Reporting DB Simultaneously
2. Log Shipping
3. Restore BAckups Nightly
4. Replication
5. DTS
My question is what is the BEST Practice in SQL2k5.
I'm all gung ho about using Mirroring but am not certain that this will be the best way to go.
My thoughts are something along the lines of this
1. have OLTP Mirrored to what I'll call a "Staging" DB. This is NOT to be used for Failover just as a means of accessing read only data for the Reporting DB
2. Have 2 DBs on another box that are flattened (Denormalized) for reporting (ReportA and ReportB)
3. Use SSIS to Populate the Report DBs in alternating sequences every XXX minutes (60 minutes let say)
4. Use Logic to let the Reporting Application Figure out which of the Two reporting DB's is "live". The Currently loading DB will be offline while it's being loaded and we'll alternate between the two (Exact method TBD but this wont be rocket science)
Now, I know this will "Work" but is this the best way to go about this ?
I do NOT want to use SSIS to populate the Reporting system directly from our OLTP system due to contention issues etc.
thoughts ?
View 3 Replies
View Related
Apr 3, 2006
I got following error when try to expand msdb under SSIS in SSMS, the SSIS I connected to is on clustered server. The windows account used is member of local admin on both nodes in the cluster and sysadmin in sql. I tried with host name that SSIS runs on and virtual sql server name for connection, tried connect from remote client machine and server itself, got same error:
Failed to retrieve data for this request. (Microsoft.SqlServer.SmoEnum)
Login timeout expired
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.
Named Pipes Provider: Could not open a connection to SQL Server [2]. (Microsoft SQL Native Client)
Login timeout expired
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.
Named Pipes Provider: Could not open a connection to SQL Server [2]. (Microsoft SQL Native Client)
Anyone knows what's happen? Thanks.
View 3 Replies
View Related
Aug 29, 2007
Hi All,
I have 2 SQL2K5 Box on different location, and can I replciate/sync sql username for this 2 box so I can maintain single login for both.
Brgds/Kevin
View 1 Replies
View Related
Sep 14, 2007
Hi
I'm trying to select data from a mirrored database situated on a SQL2k5 server, via a linked server on SQL2k.
I can select the data fine using SQLOLEDB but it's not aware of the mirroring so if the DB fails-over it errors.
To get around this, I installed SQLNCLI.msi to install the SQL2k5 provider and created a linked server like this:
exec sp_addlinkedserver @server=N'TEST2',@srvproduct=N'SQLNCLI',@provider=N'SQLNCLI',@provstr=N'Server=server1;failover partner=server2;'
exec master.dbo.sp_addlinkedsrvlogin @rmtsrvname=N'TEST2',@useself=N'False',@locallogin=NULL,@rmtuser=N'user',@rmtpassword='password'
Executing the statement: select * from test2.database.dbo.table
gives the following error:
Server: Msg 7356, Level 16, State 1, Line 1
OLE DB provider 'SQLNCLI' supplied inconsistent metadata for a column. Metadata information was changed at execution time.
OLE DB error trace [Non-interface error: Column 'IsActive' (compile-time ordinal 2) of object '"database"."dbo"."table"' was reported to have changed. The exact nature of the change is unknown].
If i change the statement to
select * from openquery(test2,'select * from database.dbo.table')
It works. I don't really want to have to go and refactor all the SQL though!
I've seen similar posts related to Oracle and SQL2k5 64bit but they don't seem to be relevant to this situation.
Here's the version info:
2000 server (SP3):
Microsoft SQL Server 2000 - 8.00.760 (Intel X86) Dec 17 2002 14:22:05 Copyright (c) 1988-2003 Microsoft Corporation Enterprise Edition on Windows NT 5.2 (Build 3790: Service Pack 2)
2005 mirrored servers (SP2 3054):
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 1)
I've also tried applying the following to the 2005 servers: sp2(3159) sp2(3161) but makes no difference.
Any ideas?
TIA
View 1 Replies
View Related
Dec 7, 2007
Hi All
Well I will be developing SSIS package which source will be MySql and destination will be SQL Server 2005. As i noticed, there is significant difference between MySQL and SQL data types; I would to have you guys' opinion that is SSIS smart enough to handle those differences or I should plan some strategy to deal?
Thanks in advance
View 1 Replies
View Related
Jun 6, 2006
Hi,
I created DTS packages in SQL 2k and I want to access them (modify) in SQL 2k5.
But I could not open those in SQL 2k5. Is there any way to open them in SQL 2k5
Thanks,
Geetha
View 1 Replies
View Related
Apr 6, 2007
I'm looking to design a web service to take in an XML response from another web service? Is this possible using ENDPOINTs and if so where can I find more information about taking in XML using SQL Server web services?
Thanks!
View 3 Replies
View Related
