Saturday, February 25, 2012

MSSQL Server 2000 error Setup fail to configure server

I have searched and could not find an answer for this one I read log and it said
Starting Service ...

SQL_Latin1_General_CP1_CI_AS

-m -Q -T4022 -T3659

Connecting to Server ...

driver={sql server};server=KENSHIN;UID=sa;PWD=;database=master

[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

driver={sql server};server=KENSHIN;UID=sa;PWD=;database=master

[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

driver={sql server};server=KENSHIN;UID=sa;PWD=;database=master

[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

SQL Server configuration failed.

how do I fix this?Seems that WINS or DNS does not work properly. Can you ping the KENSHIN name in the command prompt ?

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de
|||Yes, I can ping KENSHIN in the command prompt.|||

I'm having the same issue as Dante. I have this issue on a Windows XP SP2 - based system. I didn't think of trying to ping the server name, since I'm trying to set up the instance on a local machine.

One thing that I also found, was that there were no OBDC drivers listed in my Data Source Administrator console. Now, I watched as the setup program stated that it was installing MDAC components, so what's correlation?

|||I am having the same issue.|||

I'm having the same issue as well. We've tried reinstalling MDAC, re-SP4ing and now just detached the dbs and reinstalling SQL Server 2000.

I get the same error messages. Is there a resolution to this?

|||

How are you connecting to the DB on the production server? DSN, DSN-less? If DSN, is the DSN setup correctly on the live server? If DSN-less, is the driver present?

Also check if there is any anti-virus & anti-spyware is installed on the machine that will have this negative effect of SQL installation, so you might try stopping them until the SQL installation is finished.

|||i fixed it already well i never installed MSSQL dont need it anymore i have my db's up and running with out it

No comments:

Post a Comment