cyrus10101
asked on
Problems Installing SQL Server 2000 Personal Edition on Windows XP SP2
Many months ago, I installed the Client Tools on my machine... Things worked fine... More recently, I installed WinXP SP2 and things still worked fine... Yesturday, I decided to install the the actual SQL database so I would be able to work off-site, and ran into some headache...
First of all, the install didn't take... I was referred to look at the C:\Windows\sqlstp.log file... The SQL service was unable to start... I cross-referenced many articles on-line and eventually decided to un-install everything, and try to re-install from scratch... In addition to Add/Remove Programs, I manually un-installed SQL Server by following this article:
http://support.microsoft.com/default.aspx?kbid=290991
Now, if I install the Full Database, I am still getting the same problem... However, I am still able to install the Client Tools Only, but get the following message when I try to use the Query Analyzer:
[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
I am NOT using DSN... I think the problem is that I don't have any ODBC drivers installed... When I go to Programs->Administrative Tools-> Data Sources (ODBC) I see NOTHING listed under the Drivers tab... Because WinXP SP2 comes w/ MDAC 2.81 built-in, there is no way for me to re-install MDAC...
What's going on here??? Has any body seen anything like this???
Please Help!!!
First of all, the install didn't take... I was referred to look at the C:\Windows\sqlstp.log file... The SQL service was unable to start... I cross-referenced many articles on-line and eventually decided to un-install everything, and try to re-install from scratch... In addition to Add/Remove Programs, I manually un-installed SQL Server by following this article:
http://support.microsoft.com/default.aspx?kbid=290991
Now, if I install the Full Database, I am still getting the same problem... However, I am still able to install the Client Tools Only, but get the following message when I try to use the Query Analyzer:
[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
I am NOT using DSN... I think the problem is that I don't have any ODBC drivers installed... When I go to Programs->Administrative Tools-> Data Sources (ODBC) I see NOTHING listed under the Drivers tab... Because WinXP SP2 comes w/ MDAC 2.81 built-in, there is no way for me to re-install MDAC...
What's going on here??? Has any body seen anything like this???
Please Help!!!
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Éric Moreau
How do you connect? What is your connection string? Try to add "Network Library=DBMSSOCN;" to your connection string
ASKER
Thanks everybody for your help, but I figured out what it is...
SP2 comes w/ MDAC 2.81 Built-In... (Not such a bad thing)... But for some reason or another, My SQL drivers were missing from the "Data Sources (ODBC)" item of the Administrative Tools... (Don't know where they went but I surley didn't uninstall them)...
The problem was that the newest version of MDAC downloadable from the web is version 2.80... When I tried to install it, it would basically say, "You already have a newer version installed", and quit...
My solution was to rollback SP2... Then install MDAC 2.80... Then reinstall SQL Server... From this experience, I'd be caution about installing SP2 for WinXP right now... Wait till they come out with SP2a...:)
SP2 comes w/ MDAC 2.81 Built-In... (Not such a bad thing)... But for some reason or another, My SQL drivers were missing from the "Data Sources (ODBC)" item of the Administrative Tools... (Don't know where they went but I surley didn't uninstall them)...
The problem was that the newest version of MDAC downloadable from the web is version 2.80... When I tried to install it, it would basically say, "You already have a newer version installed", and quit...
My solution was to rollback SP2... Then install MDAC 2.80... Then reinstall SQL Server... From this experience, I'd be caution about installing SP2 for WinXP right now... Wait till they come out with SP2a...:)
:)