Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 Old Forums
 CLOSED - SQL Server 2005/Yukon
 sql 2005 install error

Author  Topic 

helpme
Posting Yak Master

141 Posts

Posted - 2005-04-29 : 09:21:34
I'm trying to upgrade an existing instance of sql 2000 to sql 2005 and I get the following error. I've posted it on the microsoft 2005 site, but I thought I would post it here also to see if anyone could help me with it. Thanks



SQL Server setup could not connect to the database to validate upgrade options. The error was: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

tomy74
Starting Member

32 Posts

Posted - 2005-05-16 : 04:12:03
Hi,

I remarked the same problem but in other case :

If you install SQL Server 2005 on a machine where SQL Server 2000 is already installed, you might find some problems when using Enterprise Manager to manage SQL Server 2000 installations.
and you will have the same error :Data source name not found and no default driver specified

so for my case i solved this problem by this method:


Start -- > Run -- >type "Regsvr32 C:\Program Files\Microsoft SQL Server\80\Tools\Binn\SQLDMO.dll" without the quotes and press OK

I hope that will help u.
Thanks,

Tarek G.


Go to Top of Page

helpme
Posting Yak Master

141 Posts

Posted - 2005-05-27 : 06:32:40
Thanks Tarek, I will try this.
Go to Top of Page

burdittw
Starting Member

1 Post

Posted - 2005-06-20 : 03:41:28
I am having the following error trying to install the VS2005 Pro. Anyone know how to get passed this.

[06/20/05,00:31:53] Microsoft SQL Server 2005 Express Edition April CTP x86: [2] Error code 1603 for this component means "Fatal error during installation.
"
[06/20/05,00:31:54] Microsoft SQL Server 2005 Express Edition April CTP x86: [2] Setup Failed on component Microsoft SQL Server 2005 Express Edition April CTP x86
***EndOfSession***

I have been trying for 2 days without any success.

Walter Burditt
Advanced Mobile Systems, Inc
Go to Top of Page

ghen
Starting Member

1 Post

Posted - 2005-07-02 : 09:12:51
Try this:

http://blogs.officezealot.com/mauro/archive/2005/04/12/4524.aspx
Go to Top of Page

Cayla`Sha
Starting Member

2 Posts

Posted - 2005-09-26 : 09:31:25
Hi!
I also got problems with installing SQL Server 2005 - Developer Edition.
My OS is Windows 2003 Server. I installed all Windows-Updates and the IIS (because after SQL Server I want to install Visual Studio Team Foundation Server)
During SQL Server-Installation I got this Error Message:

Errors occured during the installation:
Error -2147023829 installing .NET Framework 2.0.
Der Prozess wurde unerwartet beendet.

( german:Der Prozess wurde unerwartet beendet = engl:The prozess was interrupted.)

Any ideas?
Go to Top of Page

Cayla`Sha
Starting Member

2 Posts

Posted - 2005-09-27 : 07:48:02
Hi again!
I did not really found out what the problem was....
Because I was installing SQL over Remote I copied all files from the CD in a folder on the Server. Because the first installation didn`t work I copied them again. Now I got an error message that the names of some files are too long. I had to copy some files extra and rename them.
Now the installation worked until the last components. Then, the installation said, that it could not found some files, but when I looked into this directory, there were the files.
So I ended yesterday evening with an unfinished installation.

Today I restarted the Server and deleted all setup-files and copied the whole folder from the CD again on the Server. This time: No error about too long file-names. And no problem with the installation....


Once again I know why I hate Computers! *...*
Go to Top of Page
   

- Advertisement -