July 21, 2009 at 3:38 am
when i am installing sql server setup i am getting the error as following
sql server setup could not connect to the database service for server
The error was microsoft odbc driver manager datasource name not found and no default driver specified
i googled but i cannot find any answer relating to this.
i have cleaned up the registeries relating to sql server.stilll i am gettting this error
so pls help
July 21, 2009 at 4:00 am
At what stage of the install process do you get this error? Are you installing a default or named instance? What port are you using and is that port available?
Regards
Lempster
July 21, 2009 at 4:06 am
In which OS you r installing SQL server 2005 and check whether any old SQL server related folders exists in disk
July 21, 2009 at 4:41 am
i have deleted the sql server folders.os is windows 2003
while installing the database service am geting the error
July 21, 2009 at 4:42 am
defalut instance only
July 21, 2009 at 4:56 am
OK, so you've got past the point where you specify the various components you want to install and the authentication mode screen. What authentication method are you using?
Is port 1433 available (you've said that you are installing a default instance)?
Also, have you looked in the setup log for more details regarding the error?
July 21, 2009 at 5:06 am
actulay i run the
netstat -o from the cmd prompt
i cannot see the port 1433 there
so wht might be the problem ?
i am using sql server authentication
July 21, 2009 at 7:41 am
netstat -o will show you the established ports and as 1433 doesn't appear in the list then it should be available. You can confirm this by running: netstat -an | find /i "1433" which should return a status of LISTENING.
What did you find in the setup log? (Should be found in C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG)
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply