SQL 2005 GUI Tools

Feb 2, 2005

Are there any GUI tools available to access SQL2k5 Express. I am able to connect via ISQL however couldn't find anything equvivalant of EM

View 2 Replies


ADVERTISEMENT

Visual Baisc 2005 Express Edition And SQL 2005 Database Diagram Tools

Jan 29, 2008

Hi,

I have created a database using VB Express 2005 express edition and I have created number of tables and SP's etc.

I am trying to use the database diagram tool but I get an error stating that the database doesn't have a valid dbo. I say yes to the prompt about making myself a valid dbo but I then get a message stating that I do not have permissions to imprersonate the dbo.

How do I overocome this issue?

Thanks

Bill

View 4 Replies View Related

SQL Server 2005 Service Pack 2 Has Not Upgraded Visual Studio 2005 Business Intelligence Tools

Mar 18, 2008

Hi,
I understand from previous threads that installing SQL Server 2005 Service Pack 2 on the desktop client can speed up the response rate of the Visual Studio 2005 Business Intelligence Tools.

However after logging on as an administrator and installing Service Pack 2, Service Pack 2 returned no errors. However after launching Visual Studio and clicking on the about dialog box the version reported was still €œRTM.050727-4200€? where I was expecting to see €œSP.050727-7600€?.

I understood that I applied the same service pack to my copy of SQL Server on my laptop and the upgrade worked successfully.

Can anyone help?

Thanks in advance,

Kieran.

View 9 Replies View Related

Tools For MS SQL 2005

Apr 23, 2008

Hi,

Is there any tool, by which cross database integrity constraint (foreign keys between two different databases) can be displayed via a diagram, etc.

Any idea is appreciated.

View 3 Replies View Related

Which Tools To Choose For Asp.net 2 And Sql 2005

Mar 22, 2006

Hi,

I'm helping a small company built a new website and intranet in asp.net 2.0 and SQL.

I'm having trouble choosing among vs.net 2005, vwd express, SQL 2005
express or SQL 2005 Developers Edition for the prototype/testing phase.

Any advice?  I want to build production-ready versions with easy
migrations to production, but I don't want them to have to spend too
much $$$ while it's just in alpha and being prototyped.

thanks,
Bruce

View 1 Replies View Related

Sql 2005 Client Tools

Sep 14, 2006

I have installed SQL 2005 on a new machine and cannot find any of theclient tools I am used to having: query analyzer, enterprise mgr.,profiler. Shouldn't they be included in a default installation if Ichose to install client tools? Where do I go to find them?*** Sent via Developersdex http://www.developersdex.com ***

View 1 Replies View Related

SQL 2005 Management Tools

Jul 11, 2006

Hi, I installed sql 2005 dev for testing sharepoint, and the management studio was not installed. Now, i am afraid to try to install it because i am thinking it may uninstall or re-install all sql components (and probably erase existing instances and sharepoint data may be lost. I have installed on an other pc the client tools, but i cannot connect to that instance, and i cannot attach the user databases (i get the 5123 error)

Can anyone help me how i can install management services without messing up the sharepoint instance?

View 4 Replies View Related

SQL Tools :: How To Disable Customer Improvement Program From Menu For Server MGMT Tools 2012

Mar 25, 2014

Am customizing SQL server MGMT tools 2012 for Mass deployment.Client had asked to remove Customer Feedback option from help menu.how to disable that.

View 6 Replies View Related

SQL Tools :: R2 Management Tools Install Fails - Specified Account Already Exists

Oct 20, 2014

The installation SQL 2008 R2 Management Tools on a Windows 7 workstation fails with the error, The specified account already exists.

Final result: SQL Server installation failed. To continue, investigate the reason for the failure, correct the problem, uninstall SQL Server, and then rerun SQL Server Setup.

  Exit code (Decimal):           -2068052700
  Exit facility code:            1212
  Exit error code:               1316
 
[code]...

View 10 Replies View Related

Backup Strategy - SQL2005 Tools Versus 3rd Party Tools

Jun 1, 2007

I am running SQL Server 2005 x64 Enterprise under Windows 2003 x64 Enterprise. My current backup strategy uses T-SQL jobs run by SQL Agent (writes out *.bak files) and then I have an Integration Services job that copies the *.bak files to our NAS device. I have performed a restore without issue. The jobs are all automated every four hours via SQL Agent. Is this a sound strategy or are there additional benefits to using 3rd party tools? If so, what are the advantages and which tool provides them?

View 3 Replies View Related

Management Tools In SQL SERVER 2005

Jan 12, 2006

Hi Team,
Is there any management tools in SQL SERVER 2005? I just installed my standard edition and also developer version in different computer, but seems that both versions doesn't support management tools such as query analyzer.
Can anyone explain to me...
Thanks.

View 2 Replies View Related

SQL Server 2005 Client Tools

Oct 15, 2007

What is the quickest and easiest way to use client tools for 2005 like 2000....
?

View 4 Replies View Related

Using External Tools In Sql Server 2005

Jul 5, 2007

I have seen the
Tools------>External tools
in sql server 2005 window

What external tools are used ? How they are used?
Plz give me the link to study this

Thanks,
Swati

View 3 Replies View Related

Migration Tools For 2005 Express

Jul 23, 2005

Hi everyoneDoes anyone know or has anyone heard of any migration tools whichare/might be available for converting SQL Server 2000 databases to SQLServer 2005 Express?I'm guessing it is probably a bit early but it was worth a shot!ThanksDave

View 1 Replies View Related

Tools Suggestion For Sql Server 2005

Dec 31, 2007

Question 1
I want to check which is the best easy to use cost saving tool in sql server which can do a check the performance of a query and rewrite the query with best performance
Question 2
Which is the best tool for load testing tool in sql server, which is easy to understand and use.
Question 3
Which tool monitors the changes in the server including the dba's activities and send report to the audit team.
Qustion 4
Which tool can send notification about the job's failed , backup task failed etc.
Question 5
Which tool can suggest the correct index for all the tables


Please recommend me a tool for all this which is easy to use + cost saving and their licencing details with their pricing.






View 3 Replies View Related

MS SQLServer 2005 - Client Tools

Nov 27, 2007

Hi there,
When I try and install the client tools on my SQLServer 2005 SP2 installation I get the following message:


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: The Transaction Manager is not available. (Exception from HRESULT: 0x8004D01


I have tried to uninstall and reinstall the Client Tools, but I keep on getting the same message.

Any suggestions?

Regards

Dawid

View 5 Replies View Related

Install Of 2005 Tools Fails

Jun 29, 2006

I'm trying to install SQL Server 2005 tools, but keep getting this error,

TITLE: Microsoft SQL Server Setup------------------------------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.For help, click: http://go.microsoft.com/fwlink?LinkID=20476&ProdName=Microsoft+SQL+Server&ProdVer=9.00.1399.06&EvtSrc=setup.rll&EvtID=SQLSetup90&EvtType=28108
Then on the Details, it says the following,

Name: Microsoft SQL Server 2005 ToolsReason: Your upgrade is blocked. For more information about upgrade support, see the "Version and Edition Upgrades" and "Hardware and Software Requirements" topics in SQL Server 2005 Setup Help or SQL Server 2005 Books Online.Build version check:Your upgrade is blocked because the existing component is a later version than the version you are trying to upgrade to. To modify an existing SQL Server component, go to Add or Remove Programs in Control Panel, select the component you would like to modify, and then click Change/Remove.

I uninstalled the Express tools from the system and can't get the tools to install. I've rebooted to no avail. Help!

View 3 Replies View Related

Design Tools / Sql Server Mgt Tools Cause Login Fail

Sep 20, 2007

Login failed for user 'TOSHIBA-USERASPNET'
I know that the file persmission for the web application have to include aspnet, so i keep resetting the folder permission for aspnet in file manager, but the login failed keeps coming back every day or two
problem is after working with VS05 Pro, SQL Server Management Studio CTP, somehow the aspnet persmission get changed, use alot of sqldatasource wizards and often there is a conflict/hang between the datasource wizard and the need to have the mdf in a dettached state within VS server explorer,
not sure but the procedure to fix this seems to be to reboot, detach and re-attach the mdf in the Sql server Studio tool, re-apply the aspnet file permission on the web app folders (wonder should i be doing this in IIS instead), make sure the mdf within server explorer is detached, the it works
anyway, getting real tired of the resulting delays and design time derailment, clues greatly appreciated, thanks
 sometimes i can use View in Browser when in VS05 form view and i wont get the aspnet folder permission error and other times i do.
last thing, is it a bad idea to give aspnet full permission for the entire web applicaiton??
 

View 2 Replies View Related

SQL 2005 Client Tools Install Fails

Feb 2, 2007

Hi all... assisting with mass deployment of SQL 2005 Client Tools.

Multiple users are able to pass the System Configuration Check, and click Next. It is on the next screen they see the following:

Microsoft SQL Server 2005 Setup                              [_][X]
-------------------------------------------------------------------
Microsoft SQL Server Installation
  Setup is preparing to continue with the installation.
-------------------------------------------------------------------
Please wait while setup prepares to continue with the installation.

Status: Extracting custom action file from stream
       ________________________________________________
      [________________________________________________]

[Help]                                  [< Back] [Next >]  [Cancel]

After eight minutes, the install bombs, and sends an error report to Microsoft.

I saw a similar post here, but these are XP machines and Administrators appear to have the proper permissions. I also do not get the error message "Error writing to file".

Here is a section of the _WI log file generated by the install..

MSI (c) (48:A4) [09:20:49:208]: PROPERTY CHANGE: Adding ENABLERANU property. Its value is '1'.
Action ended 9:20:49: SetEnableRanuUI. Return value 1.
MSI (c) (48:A4) [09:20:49:208]: Skipping action: UnsetEnableRanuUI (condition is false)
MSI (c) (48:A4) [09:20:49:208]: Skipping action: SetSharedVolumePath (condition is false)
MSI (c) (48:A4) [09:20:49:208]: Skipping action: UnsetINSTALLSQLDATADIR (condition is false)
MSI (c) (48:A4) [09:20:49:208]: Doing action: StreamSupportFiles.D20239D7_E87C_40C9_9837_E70B8D4882C2
Action 9:20:49: StreamSupportFiles.D20239D7_E87C_40C9_9837_E70B8D4882C2. Extracting custom action file from stream
Action start 9:20:49: StreamSupportFiles.D20239D7_E87C_40C9_9837_E70B8D4882C2.
MSI (c) (48:44) [09:20:49:223]: Invoking remote custom action. DLL: C:DOCUME~1axn4835aLOCALS~1TempMSI117.tmp, Entrypoint: StreamSupportFiles
MSI (c) (48:70) [09:20:49:223]: Cloaking enabled.
MSI (c) (48:70) [09:20:49:223]: Attempting to enable all disabled priveleges before calling Install on Server
MSI (c) (48:70) [09:20:49:223]: Connected to service for CA interface.
Action ended 9:20:49: StreamSupportFiles.D20239D7_E87C_40C9_9837_E70B8D4882C2. Return value 3.
MSI (c) (48:A4) [09:20:49:301]: Skipping action: FatalError (condition is false)
Action ended 9:20:49: INSTALL. Return value 3.
MSI (c) (48:44) [09:28:50:859]: Destroying RemoteAPI object.
MSI (c) (48:70) [09:28:50:859]: Custom Action Manager thread ending.

And here is a section of the _Core(Local).log

Running: ReportChainingResults at: 2007/0/29 9:28:57
Error: Action "ReportChainingResults" threw an exception during execution.
DwLaunchMsiExec() returned : 1603
        Error Code: 0x80070643 (1603)
Windows Error Text: Fatal error during installation.

  Source File Name: sqlchainingsqlchainingactions.cpp
Compiler Timestamp: Thu Sep  1 22:23:05 2005
     Function Name: sqls::ReportChainingResults::perform
Source Line Number: 2992

A section of _Core.log:

Running: LaunchLocalBootstrapAction at: 2007/0/29 9:19:37
Error: Action "LaunchLocalBootstrapAction" threw an exception during execution.  Error information reported during run:
"C:Program FilesMicrosoft SQL Server90Setup Bootstrapsetup.exe" finished and returned: 1603
Aborting queue processing as nested installer has completed

When the install fails, this is the event signature:

EventType: sql90setup
P1: unknown
P2: 0x643
P3: unknown
P4: 0x643
P5: unknown
P6: unknown
P7: sqlrun.msi@9.00.1399.06

View 5 Replies View Related

Problem Installing SQL Mobile 2005 Tools

Jan 13, 2006

I'm trying to install the SQL Mobile 2005 Server tools on a Windows 2003
Server with IIS & MSSQL 2000 sp4.


I've stuck .NET 2.0 on already, but the installer for the server tools
Sqlce30setupen.msi just goes straight to the last page of the wizard and says
the install was interrupted.


I've run the install with logging turned on and this is the last portion of
the trace. Can anyone shed any light on whats going wrong.


-------------------------------><-------------------------------------


MSI (c) (9C:14) [14:12:35:912]: Doing action: FindRelatedProducts
Action start 14:12:35: FindRelatedProducts.
Action ended 14:12:35: FindRelatedProducts. Return value 1.
MSI (c) (9C:14) [14:12:35:912]: Doing action: AppSearch
Action start 14:12:35: AppSearch.
MSI (c) (9C:14) [14:12:35:912]: Note: 1: 2262 2: Signature 3: -2147287038
MSI (c) (9C:14) [14:12:35:912]: PROPERTY CHANGE: Adding IISROOTFOLDER
property. Its value is 'C:Inetpubwwwroot'.
MSI (c) (9C:14) [14:12:35:912]: Note: 1: 2262 2: Signature 3: -2147287038
MSI (c) (9C:14) [14:12:35:912]: Note: 1: 1402 2:
HKEY_LOCAL_MACHINESOFTWAREMicrosoftMicrosoft SQL
Server90ToolsShellServices{CA8A686A-0882-4e79-BCA3-AF3F3AB3EB8A} 3: 2
MSI (c) (9C:14) [14:12:35:912]: Note: 1: 2262 2: Signature 3: -2147287038
MSI (c) (9C:14) [14:12:35:912]: PROPERTY CHANGE: Adding MDACFOUND property.
Its value is '2.80.1022.0'.
MSI (c) (9C:14) [14:12:35:912]: Note: 1: 2262 2: Signature 3: -2147287038
MSI (c) (9C:14) [14:12:35:912]: PROPERTY CHANGE: Adding ISIISINSTALLED
property. Its value is 'LocalSystem'.
MSI (c) (9C:14) [14:12:35:912]: Note: 1: 2262 2: Signature 3: -2147287038
MSI (c) (9C:14) [14:12:35:912]: PROPERTY CHANGE: Adding SQL2KREPLCLIENT
property. Its value is '{2FAD19D0-E309-11D2-B6E5-00C04F688E8F}'.
MSI (c) (9C:14) [14:12:35:928]: Note: 1: 2262 2: Signature 3: -2147287038
MSI (c) (9C:14) [14:12:35:928]: Note: 1: 2262 2: Signature 3: -2147287038
Action ended 14:12:35: AppSearch. Return value 1.
MSI (c) (9C:14) [14:12:35:928]: Skipping action: CheckOSVersion (condition
is false)
MSI (c) (9C:14) [14:12:35:928]: Doing action: CA_CheckInstalledSQL
Action start 14:12:35: CA_CheckInstalledSQL.
MSI (c) (9C:94) [14:12:35:943]: Invoking remote custom action. DLL:
C:DOCUME~1CharlieLOCALS~1Temp1MSIB.tmp, Entrypoint: CheckInstalledSQL
MSI (c) (9C:88) [14:12:35:943]: Cloaking enabled.
MSI (c) (9C:88) [14:12:35:943]: Attempting to enable all disabled priveleges
before calling Install on Server
MSI (c) (9C:88) [14:12:35:943]: Connected to service for CA interface.
Action ended 14:12:36: CA_CheckInstalledSQL. Return value 3.
MSI (c) (9C:14) [14:12:36:005]: Doing action: SetupCompleteError
Action start 14:12:36: SetupCompleteError.
MSI (c) (9C:54) [14:12:36:082]: Note: 1: 2731 2: 0
Action ended 14:13:33: SetupCompleteError. Return value 2.
Action ended 14:12:32: INSTALL. Return value 3.
MSI (c) (EC:00) [14:19:35:619]: Destroying RemoteAPI object.
MSI (c) (EC:0C) [14:19:35:619]: Custom Action Manager thread ending.
=== Logging stopped: 11/01/2006  14:19:35 ===
MSI (c) (EC:34) [14:19:35:619]: Note: 1: 1708
MSI (c) (EC:34) [14:19:35:619]: Product: Microsoft SQL Server 2005 Mobile
[ENU] Server Tools -- Installation operation failed.


-------------------------------><-------------------------------------


thanks


// charlie

View 3 Replies View Related

Install Of 2005 Management Tools Fails

Apr 23, 2008



I have VS2008 installed. Now, I need to install the SQL server Management Tools, because of tasks I have on SQL server instances which are installed on other servers. I guess a lot of developers are in such a situation. You develop on your own machine, but deploy the final database on a production machine.And you happen to be the manager of those databases too (well, I am)

Now, it seems impossible to install the neccesary tools as I get messages;
The following components that you chose to install are already installed on the machine. To view a report of available options and alternatives click on details (Workstation components, Books Online and development tools 9.2.3042.00)

Then on the Details, it says the following,


Name: Microsoft SQL Server 2005 Tools Express Edition

Reason: Your upgrade is blocked. For more information about upgrade support, see the "Version and Edition Upgrades" and "Hardware and Software Requirements" topics in SQL Server 2005 Setup Help or SQL Server 2005 Books Online.

Build version check:

Your upgrade is blocked because the existing component is a later version than the version you are trying to upgrade to. To modify an existing SQL Server component, go to Add or Remove Programs in Control Panel, select the component you would like to modify, and then click Change/Remove.


Now, I have no clue of what can be safely removed to allow the installation of the Management Tools. I am afraid that I will end up with a non-working SQL server Express installation which is required for VS2008

What should I do to get these Managment Tools installed on my develop machine?

View 3 Replies View Related

Problems Installing SQL 2005 Client Tools

Mar 13, 2008

HI
I have recently installed a copy of SQL server 2005 on to a windows 2003 server. During the install I selected to install the client tools (management studio and all that) all seemed to install ok no errors but after the install there is no management studio in the start menu. I have tried uninstalling the client tools and reinstalling them again I have also tried to launch management studio by browsing to the SqlWb.exe but the program fails to initialise any ideas?

(both SQL and Windows are at SP2)

Thanks
Jon

View 2 Replies View Related

SQL Tools :: Repair Database Without Being Attached (2005)

May 17, 2015

Is it possible to try repair a database without being attached, giving the path to the files?

I'm trying to attach a database that i recover from a disk, and i'm not able to attach, gives me an error, saying i should do a db check.

View 3 Replies View Related

Error - Installing Client Tools - Sql Server 2005

Jan 4, 2007

Hello

I am trying to install client tools on my desktop and I am getting the following error :

Edition Change Check (Warning)

Messages
Edition Change Check


To change an existing instance of Microsoft SQL Server 2005 to a different edition of SQL Server 2005,
you must run SQL Server 2005 Setup from the command prompt and include the SKUUPGRADE=1 parameter.

This error , I am have seen in the logs.

The installation wizard is closing down with the above log error.

Thanks

View 3 Replies View Related

Bad Un-install Of SQL Server 2005 Tools Express Edition CTP

Jun 21, 2006



I have used the tool at this URL

http://msdn.microsoft.com/vstudio/express/support/uninstall/#Tool

and *cannot* get SQL Server 2005 Tools Express Edition CTP to uninstall. I get the following dialog box:

"The setup has encountered an unexpected error in datastore. The action is Write_CommitFlag. The error is:Unable to write property into cache flagCommit Unable to write property into cache: "flagCommit" XmlRW Error: Failure loading xmlrw.dll CheckAllProcedures() returned 2."

Any ideas as to how I can work around this ?



View 3 Replies View Related

What Other Associated Tools SQL Server 2005 Intergration Services Can Work With?

Sep 8, 2006

Hi, all,

Thank you very much for your kind attention.

I am having a question which is: What other associated tools/environment SQL Server 2005 Integration Services (SSIS) can work with? (like we know SSIS can work with other components of SQL Server 2005, Excel,XML files etc.), so what other tools it can work with?

Thanks a lot in advance for any guidance and advices for that.

With best regards,

Yours sincerely,

View 4 Replies View Related

2000 DTS Packages Corrupted By 2005 Client Tools?

Jan 12, 2006

Hi,

I have many sql 2000 DTS packages that I support from my development workstation  running v2000 sp4. Packages are altered on the development machine and then go through a normal release mechanisms to production via testing servers etc.

I have recently installed the client tools for SQL Server 2005 on my desktop to evaluate the product.  The 2005 DB instance is running on a seperate server.

So, I have dev edition of sql 2000 and 2005 client tools (including BI Dev studio etc) on my workstation.

I have recently had to make changes to a 2000 DTS package and used my 2000 enterprise manager to do so. No Problem- saved and tested fine on my workstation. 

But when I try and release it to another server, or open the package using enterprise manager from another machine that does not have sql 2005 installed - I get an error message 'Unspecified error'.  This I've seen before when trying to open packages created in v2000 , using v7 or where the service packs are different between machines.

Digging around my workstation and comparing some of the DLLs I know to be required to distribute DTS  packages (from RDIST.txt) it seems that some of the SQL 2000 dll files have been updated by my 2005 installation. 

E.g

DTSFFILE.DLL on my machine is 2000.85.1054.0 whilst on any 'clean' 2000 machine is at version v2000.80.760.0

Surely it cant be right that SQL 2005 has newer versions of components for SQL 2000 than is available with the latest SP for the actual product! Especially considering that the installation of 2005 does not even allow you to edit 2000 DTS packages through the management studio without a 'special' download' of the feature pack,(whihc by the way does not work very well either)

So am I to conclude that you can not run side by side installations of SQL 2000 and 2005 on a single machine and expect 2000 to run as it did previously

View 11 Replies View Related

Error - Installing SQL Server 2005 Client Tools

Jan 5, 2007

Hello

I am trying to install sql server 2005 client tools and I get the following error:



Error code 2356 : Could not locate cabinet in stream : sql.cab

How can I go about this

Thanks

View 5 Replies View Related

SQL 2005 Fails To Install Workstation Components And Tools

Feb 15, 2007

Hello.

When I install SQL Server 2005, it all goes well except that it fails to install these two:

- SQLXML 4

- workstation components and tools

When I try to install these two from the CD in the Setup folder of the CD 2 with the files sqlxml4.msi and sqlRun_Tools.msi (if I remember these names correctly), it gives me an error:

'Ce package d'installation n'est pas pris en charge par ce type de processeur'

Sorry. My SQL CDs are in french, but it roughly translates to the message:

This installation package is not taken by this processor.

I thought that my hardware configuration does not meet the requirements. But I have a Pentium 4, 2Gig RAM, over 100Gig free HD space. Also I tried to install on other computers to no avail. This is a fresh install, that is, there is no previous SQL Server 2000 in it, no VS.NET 2005 or before. Nothing. I have just a fresh, new computer.

Can anyone help, please?

Jean

View 10 Replies View Related

Unable To Uninstall SQL Server Express 2005 Tools

Sep 16, 2005

I get an error message when trying to uninstall the SQL Server Express 2005 Tools.  It reports,

View 7 Replies View Related

SQL Tools :: Tools To Determine Version From BAK File

Apr 24, 2014

Is there - apart from the notorious RESTORE HEADERONLY - an tool which is able to tell which SQL Server version created a specific BAK file? I'm looking for a tool that can be used w/o an available/running SQL Server installation.

Alternatively, is there any documentation about what is read with RESTORE HEADERONLY so I could write a tool myself?

Where would I find the version "bytes" in a BAK file?

View 4 Replies View Related

Cannot Install SQL Server 2005 Developer Edition - Configuration Tools Only

Jul 16, 2006

I have tried several times to install
SQL Server 2005 Developer Edition (most recently from MSDN Disk
3097.1) I have tried to complete an uninstall before each
attempt.



I do get the warning about Minimum Hardware Requirement, but can find
nothing in the detail requirements to exclude my PCs configuration.



I have installed: IIS and .NET Framework 2.0

I have also used ..aspnet_regiis -r to register ASP.NET



I am, successfully, running Visual Studio 2005.



Why does the installation process stop there and what can I do next?

View 4 Replies View Related

Updates To SQLServer 2000 DLL's When 2005 Client Tools Installed

Jan 12, 2006

Hi,

I have many sql 2000 DTS packages that I support from my development workstation  running v2000 sp4. Packages are altered on the development machine and then go through a normal release mechanisms to production via testing servers etc.

I have recently installed the client tools for SQL Server 2005 on my desktop to evaluate the product.  The 2005 DB instance is running on a seperate server.

So, I have dev edition of sql 2000 and 2005 client tools (including BI Dev studio etc) on my workstation.

I have recently had to make changes to a 2000 DTS package and used my 2000 enterprise manager to do so. No Problem- saved and tested fine on my workstation. 

But when I try and release it to another server, or open the package using enterprise manager from another machine that does not have sql 2005 installed - I get an error message 'Unspecified error'.  This I've seen before when trying to open packages created in v2000 , using v7 or where the service packs are different between machines.

Digging around my workstation and comparing some of the DLLs I know to be required to distribute DTS  packages (from RDIST.txt) it seems that some of the SQL 2000 dll files have been updated by my 2005 installation. 

E.g

DTSFFILE.DLL on my machine is 2000.85.1054.0 whilst on any 'clean' 2000 machine is at version v2000.80.760.0

Surely it cant be right that SQL 2005 has newer versions of components for SQL 2000 than is available with the latest SP for the actual product! Especially considering that the installation of 2005 does not even allow you to edit 2000 DTS packages through the management studio without a 'special' download' of the feature pack,(whihc by the way does not work very well either)

So am I to conclude that you can not run side by side installations of SQL 2000 and 2005 on a single machine and expect 2000 to run as it did previously !!!

View 2 Replies View Related







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