I have been trying to install SQL 2005 Server Developer Edition 64-bit on Vista 64 all morning.
The setup refuses to install many components.
Has anyone gotten this to work?
jerry
Refused with which error ?
Jens K. Suessmeyer
http://www.sqlserver2005.de
I've installed it on my local machine using SQL Server 2005 Express with no problem. Now I need to install it on the server. I want to use the remote SQL Server 2005 database, but that means installing the scripts manually. I did that and thought it went well, but I'm getting all kinds of errors, so there's a problem of some kind.
I have SQL Server 2005 Express installed. I's be happy enough to use that, but I don't know how to. I tried to install and got an error that I couldn't create a database. I don't want to try to do it manually again, that didn't work very well before.
How do I do this?
Diane
Did you successfully install Express edition on the server? What kind of Sql Server is installed on your remote server? What kind of error are you getting. Without seeing the errors, it is very hard to tell what might be the problem. Post the error here.
difference between SQL Server 2000 and MSDE 2000? Do they have
different entries in the Registry?
From the documentation that I've read it seems as if they are one and the same.
However, if someone knows how to differentiate between them in the Registry it would be greatly appreciated.
ThanksMSDE 2000 is the desktop engine of the SQL Server 2000.|||So as far as Registry entries go, there would be no noticeable difference between the two....is that correct?
i am using sql 2005 with sp1 standard edition.
i have a question regarding the antivirus software. Is it ok to install anti-virus software on the sql server box? what are the issues involved if we install anti-virus software on the sql server box?
I heard, it causes some performance and other issues.
Is there anything we need to take care of .if we decide to install anti-virus software on the sql server box?
Can anybody share experience on this?
Thanks
Personally, I am very much against installing anti-virus software on a SQL Server box, for performance reasons. You see conflicting advice from Microsoft about this. The Perf people say no, and the security people say yes. If you decide to run AV on your SQL Server, make sure to exclude the data and log files from the scanning.|||
Generally speaking, it is not a good idea to have anti-virus products on a SQL Server.
Consider that anti-virus products protect the computer from user activities in the Workstation service.
On a SQL Server, there 'should' not be any user activities in the Workstation service.
|||I disagree with the other posts here.ALWAYS run anti-virus on ALL machines on the network, servers and pcs, with current virus defs.
On SQL server, exclude the data and log directories from the scanning and virus protection.
Many viruses will infect all machines on the entire network, and if you don't have AV on ALL machines, when you remove it from all your PCs, it will hide on your SQL server box until it infects the entire network again and again and again. I know because this has happened to me, with more than one customer who has the same "performance" concerns.
|||Yes, I agree with Tlom. There are several approaches, defined by the policy of the companies which way you can take if you secure SQL Server. You can either exclude the data file and directories or exclude the appropuiate MDF / LDF extensions (which assumes that you are using these extensions with your files) I prefer the extensions exclusion which will makes it even not possible to inject a virus in the data directories of SQL Server.
Jens K. Suessmeyer.
http://www.sqlserver2005.de
|||Thank you everyone for your replies. I really appreciate it.So if you exclude the data and log files, are there any performance issues and other issues like communication/blocking etc ?
Thanks
|||
I hope this will help you:
Guidelines for choosing antivirus software to run on the computers that are running SQL Server
http://support.microsoft.com/kb/309422/en-us
Currently, I install an Anti-virus solution on MS SQL Server. It protects windows OS. In order to speed up the SQL performance, I dont want this Anti-virus to scan my SQL database. I want to know what's the exclusion list for the Anti-virus application. Thanks,
Hi,all file extension that are used for SQL Server, by default this is mdf,ndf,ldf but this can be changed by the user, so you will need to have a look at your database. The logfiles .log can be dismissed, as there is no heavy load on them.
The information about the datafiles is stored in the sysfiles table, therefore you will have to query this table for each database in order to get the extensions. I prepared something for you which should help you to identity the needed extensions.
CREATE Table #Extensions
(
Extension VARCHAR(10)
)
INSERT INTO #Extensions
EXEC sp_msforeachdb 'Select REVERSE(LEFT(REVERSE(filename),CHARINDEX(CHAR(46),REVERSE(filename))-1)) from sysfiles'
SELECT DISTINCT Extension FROM #Extensions
If you data is stored in specific folders, you could also try to exclude this folder instead of using the file extension filter (if you application is able to do this)
HTH, Jens K. Suessmeyer.
http://www.sqlserver2005.de
|||Hi,
All anti virus server have Exclusion List which means it won't scan those files(Extension) listed , you have to enter .mdf,.ldf & .ndf to its Extention Exclusion List and then it won't scan your Database. http://www.nus.edu.sg/comcen/antivirus/faq.htm#10 FYI & E.G.
Hemantgiri S. Goswami
Thanks
DarrenIf I answer my own question, at least I'll get one right.
SQL 2000 DTS tools are now available as part of the -
Download details: Feature Pack for SQL Server 2005 Nov 2005
(http://www.microsoft.com/downloads/details.aspx?familyid=D09C1D60-A13C-4479-9B91-9E8B9D835CDC&displaylang=en)
The direct link to the MSI-
http://www.microsoft.com/downloads/info.aspx?na=46&p=16&SrcDisplayLang=en&SrcCategoryId=&SrcFamilyId=D09C1D60-A13C-4479-9B91-9E8B9D835CDC&u=http%3a%2f%2fdownload.microsoft.com%2fdownload%2f4%2f4%2fd%2f44dbde61-b385-4fc2-a67d-48053b8f9fad%2fSQLServer2005_DTS.msi&oRef=http%3a%2f%2fforums.microsoft.com%2fMSDN%2fShowPost.aspx%3fPostID%3d126513%26SiteID%3d1|||
I have downloaded the dts tools and when I try to edit a dts package on a SQL2000 instance using the new SQL Server Management Studio, I still get the following errors:
Package Error
Error Source : Microsoft Data Transformation Services (DTS) Package
Errir Description : The DTS host failed to load or save the package properly.
<hit ok>
DTS Designer Error
The selected package cannot be opened. The DTS Designer has been closed.
<hit ok>
SQL Server 2000 DTS Designer components are required to edit DTS packages. Install the special Web download, "SQL Server 2000 DTS Designer Components" to use this feature. (Microsoft.SqlServer.DtsObjectExplorerUI)
<hit ok>
it takes me to the dts designer (it doesn't close it like it says) and all of the icons in the workspace look like a default windows form icon. I can click on each of them to get the properties, transformations, etc. But I dare not save them.
Any idea how to fix this? Or am I not supposed to be able to manage SQL 2000 instances with this tool.
|||I'm experiencing the very same problem. It occurs even if you right-click on Data Transformation Services and select Open package file..., so it's not a server instance issue. Perhaps it requires the latest MDAC and/or SQL Server Native Client to be installed on the accessed server? Feels a bit buggy to me.|||The designer download does require MDAC 2.6 sp2 or newer, but you're likely to have that already.-Doug
|||Can we install the SQL Native Client on a SQL2000 box? would that make any difference to the Management Studio?
|||You can install SNAC on SQL 2000 machines, after all that is what happens in side by side installations of SQL 2000 and SQL2005, but it is not requrired for DTS.
I can happily edit most 2000 packages (through the web download designer) on a clean SQL 2005 machine, pointing at an existing SQL 2000 instance. Sometimes I get invalid class string errors, since the SQL 2005 machine lacks some custom tasks I used with DTS. I do sometimes get a similar error to you, but haven't got around to seeing which components are used in a good package and a problem package. I suspect there may be a problem task. AS processing tasks gave some problems, but I skipped around it and haven't had time to work it yet.|||
After uninstalling the entire CTP (including the beta .NET framework) and reinstalling SQL 2005 enterprise I also downloaded and installed the S2k DTS designer web pack.
Now I can't create or save DTS packages in SQL 2000 without getting the same error. In SQL 2005 using the legacy designer I get mixed results.
So I created a new and very simple DTS package on a different (and clean) SQL 2000 machine that has never had SQL 2005 components installed. It worked fine on the SQL 2000 machine. But when I try to open it using the SQL 2005 designer that I downloaded I get the same annoying error. HOWEVER, certain older packages from that same clean SQL 2000 server CAN be edited and saved using the SQL 2005 designer.
This is WAY buggy. Am I missing a download? What about the backwards-compatible pack I saw with all of the (daunting) SQL 2005 downloads? Is there a sequence to doing this? Do I need to fully uninstall all SQL 2000 components first? Can I then reinstall them?
|||I'm having the same problem. I never had SQL Server 2000 installed, I installed SQL Server 2005 & Visual Studio 2005, then the SQL Server 2000 DTS Designer Component package, but still get error message to install component when trying to open SQL Server 2000 DTS package.
I unintalled SQL Server 2005, then installed SQL Server 2000, ran Enterprise Manager ok, then installed SQL Server 2005, and then SQL 2000 Enterprise Manager will not run now, then installed DTS Component package, and still get same error message to install component when trying to open SQL Server 2000 DTS package.
Tom E.
|||I get exactly the same errors and here's what I found... After trying to migrate a DTS package that failed to open I got a somewhat more informative error message out of the report. It stated that the package name cannot contain any of the following characters: / \ : [ ] . =.
It so happens many of my packages have ':', '.' in the names and so apparently they have changed this aspect as well (thanks Bill for the lack of documentation). Anyhow, after renaming the packages I was able to open them (still with errors but it worked) and migrate them. What a pain in the a**!!!
Hope this helps...
|||I was also having same problem
error message was
SQL Server 2000 DTS Designer components are required to edit DTS packages. Install the special Web download, "SQL Server 2000 DTS Designer Components" to use this feature. (Microsoft.SqlServer.DtsObjectExplorerUI)
The resolution
First download and install SQLServer2005_BC component for backward compatibility from microsoft
Then Install SQLServer2005_DTS component.
http://www.microsoft.com/downloads/details.aspx?familyid=D09C1D60-A13C-4479-9B91-9E8B9D835CDC&displaylang=en)
It should work.In my case it was successfully leting me edit DTS package developed in SQL Server 2000 version
Thankx
|||
|||
Scott,
There is no documented resolution from Microsoft that these forums will be frequented by MS staff.
You should seek support via your MSDN subscription and then PSS as far as I know.
-Jamie
|||In case somebody else still experience the same problems...
I found help at:
http://support.microsoft.com/kb/917406/en-us
-duke63
|||Sometimes happen the same and even only appears the arrows. I had a lot of problems with this messing up my Sql2k Entreprise Manager.
