Reporting Services installation crashed SQL Server

Hi everyone,
First of all, I'm sorry for the cross-post; I'm not sure where to post this
message.
I tried to install the Reporting Services in my local machine (WinXP pro
SP1. in portuguese), in which I had a SQL Server 2k Developer.
During the setup proccess, an error has ocurred - I didn't get exactly the
error message because I thought that it was just a notification, but it was
something similar to "Error ocurred when installing / verifying /
registering MDAC (-1)".
The setup stopped and since this I couldn't log on my local SQL Server. I
get the ODBC error message "Data source name not found and no default driver
specified".
I removed the SQL Server and tried to install it again. The setup proccess
was normal, until almost the end. In the step "Setup is starting the server
and installing your chosen configuration" it happened the error "Setup
failed to configure the server. Refer to the server error logs and
C:\WINDOWS\sqlstp.log for more information". The referred file finishes with
the following lines:
************************************************** ************************
Starting Service ...
Latin1_General_CI_AS
-m -Q -T4022 -T3659
Connecting to Server ...
driver={sql server};server=TB-060;UID=sa;PWD=;database=master
[Microsoft][ODBC Driver Manager] Nome da fonte de dados no encontrado e
nenhum driver padro especificado
<translating: "Data source name not found and no default driver
specified">
driver={sql server};server=TB-060;UID=sa;PWD=;database=master
[Microsoft][ODBC Driver Manager] Nome da fonte de dados no encontrado e
nenhum driver padro especificado
driver={sql server};server=TB-060;UID=sa;PWD=;database=master
[Microsoft][ODBC Driver Manager] Nome da fonte de dados no encontrado e
nenhum driver padro especificado
SQL Server configuration failed.
************************************************** ************************
Now I'm without the SQL Server, I can't install it and I'm trying to resolve
this whitout format my computer. Do someone know what is happening?
Any help or suggestion will be very appreciated.
Thanks in advance and best regards,
Fabrcio de Novaes Kucinskis.
This is an MDAC issue. Try (re)installing MDAC 2.8 and then try and install
SQL again. You can download it here
http://www.microsoft.com/downloads/d...DisplayLang=en
HTH
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Fabrcio de Novaes Kucinskis" <fabricio.nk@.uol.com.br> wrote in message
news:OLAWLlc9EHA.1452@.TK2MSFTNGP11.phx.gbl...
> Hi everyone,
> First of all, I'm sorry for the cross-post; I'm not sure where to post
> this
> message.
> I tried to install the Reporting Services in my local machine (WinXP pro
> SP1. in portuguese), in which I had a SQL Server 2k Developer.
> During the setup proccess, an error has ocurred - I didn't get exactly the
> error message because I thought that it was just a notification, but it
> was
> something similar to "Error ocurred when installing / verifying /
> registering MDAC (-1)".
> The setup stopped and since this I couldn't log on my local SQL Server. I
> get the ODBC error message "Data source name not found and no default
> driver
> specified".
> I removed the SQL Server and tried to install it again. The setup proccess
> was normal, until almost the end. In the step "Setup is starting the
> server
> and installing your chosen configuration" it happened the error "Setup
> failed to configure the server. Refer to the server error logs and
> C:\WINDOWS\sqlstp.log for more information". The referred file finishes
> with
> the following lines:
> ************************************************** ************************
> Starting Service ...
> Latin1_General_CI_AS
> -m -Q -T4022 -T3659
> Connecting to Server ...
> driver={sql server};server=TB-060;UID=sa;PWD=;database=master
> [Microsoft][ODBC Driver Manager] Nome da fonte de dados no encontrado e
> nenhum driver padro especificado
> <translating: "Data source name not found and no default driver
> specified">
> driver={sql server};server=TB-060;UID=sa;PWD=;database=master
> [Microsoft][ODBC Driver Manager] Nome da fonte de dados no encontrado e
> nenhum driver padro especificado
> driver={sql server};server=TB-060;UID=sa;PWD=;database=master
> [Microsoft][ODBC Driver Manager] Nome da fonte de dados no encontrado e
> nenhum driver padro especificado
> SQL Server configuration failed.
> ************************************************** ************************
>
> Now I'm without the SQL Server, I can't install it and I'm trying to
> resolve
> this whitout format my computer. Do someone know what is happening?
> Any help or suggestion will be very appreciated.
> Thanks in advance and best regards,
>
> Fabrcio de Novaes Kucinskis.
>
|||And if you still get the error trying to install MDAC have a look at
http://www.tkdinesh.com/faq/ans/MDACerr.html
HTH
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Fabrcio de Novaes Kucinskis" <fabricio.nk@.uol.com.br> wrote in message
news:OLAWLlc9EHA.1452@.TK2MSFTNGP11.phx.gbl...
> Hi everyone,
> First of all, I'm sorry for the cross-post; I'm not sure where to post
> this
> message.
> I tried to install the Reporting Services in my local machine (WinXP pro
> SP1. in portuguese), in which I had a SQL Server 2k Developer.
> During the setup proccess, an error has ocurred - I didn't get exactly the
> error message because I thought that it was just a notification, but it
> was
> something similar to "Error ocurred when installing / verifying /
> registering MDAC (-1)".
> The setup stopped and since this I couldn't log on my local SQL Server. I
> get the ODBC error message "Data source name not found and no default
> driver
> specified".
> I removed the SQL Server and tried to install it again. The setup proccess
> was normal, until almost the end. In the step "Setup is starting the
> server
> and installing your chosen configuration" it happened the error "Setup
> failed to configure the server. Refer to the server error logs and
> C:\WINDOWS\sqlstp.log for more information". The referred file finishes
> with
> the following lines:
> ************************************************** ************************
> Starting Service ...
> Latin1_General_CI_AS
> -m -Q -T4022 -T3659
> Connecting to Server ...
> driver={sql server};server=TB-060;UID=sa;PWD=;database=master
> [Microsoft][ODBC Driver Manager] Nome da fonte de dados no encontrado e
> nenhum driver padro especificado
> <translating: "Data source name not found and no default driver
> specified">
> driver={sql server};server=TB-060;UID=sa;PWD=;database=master
> [Microsoft][ODBC Driver Manager] Nome da fonte de dados no encontrado e
> nenhum driver padro especificado
> driver={sql server};server=TB-060;UID=sa;PWD=;database=master
> [Microsoft][ODBC Driver Manager] Nome da fonte de dados no encontrado e
> nenhum driver padro especificado
> SQL Server configuration failed.
> ************************************************** ************************
>
> Now I'm without the SQL Server, I can't install it and I'm trying to
> resolve
> this whitout format my computer. Do someone know what is happening?
> Any help or suggestion will be very appreciated.
> Thanks in advance and best regards,
>
> Fabrcio de Novaes Kucinskis.
>
|||Jasper,
Thank you very muche for your answer.
I already tried to reinstall MDAC, but it didn't solve the problem. I'll see
the link you send, maybe it can help me.
Thanks again,
Fabrcio.
"Jasper Smith" <jasper_smith9@.hotmail.com> wrote in message
news:%23PS7Nod9EHA.960@.TK2MSFTNGP11.phx.gbl...[vbcol=seagreen]
> And if you still get the error trying to install MDAC have a look at
> http://www.tkdinesh.com/faq/ans/MDACerr.html
> --
> HTH
> Jasper Smith (SQL Server MVP)
> http://www.sqldbatips.com
> I support PASS - the definitive, global
> community for SQL Server professionals -
> http://www.sqlpass.org
> "Fabrcio de Novaes Kucinskis" <fabricio.nk@.uol.com.br> wrote in message
> news:OLAWLlc9EHA.1452@.TK2MSFTNGP11.phx.gbl...
the[vbcol=seagreen]
I[vbcol=seagreen]
proccess[vbcol=seagreen]
************************************************** ************************[vbcol=seagreen]
************************************************** ************************
>
|||Jasper,
The link you sent has the solution to my problems! Once more, thank you very
much!!
Best regards,
Fabrcio.
"Jasper Smith" <jasper_smith9@.hotmail.com> wrote in message
news:%23PS7Nod9EHA.960@.TK2MSFTNGP11.phx.gbl...[vbcol=seagreen]
> And if you still get the error trying to install MDAC have a look at
> http://www.tkdinesh.com/faq/ans/MDACerr.html
> --
> HTH
> Jasper Smith (SQL Server MVP)
> http://www.sqldbatips.com
> I support PASS - the definitive, global
> community for SQL Server professionals -
> http://www.sqlpass.org
> "Fabrcio de Novaes Kucinskis" <fabricio.nk@.uol.com.br> wrote in message
> news:OLAWLlc9EHA.1452@.TK2MSFTNGP11.phx.gbl...
the[vbcol=seagreen]
I[vbcol=seagreen]
proccess[vbcol=seagreen]
************************************************** ************************[vbcol=seagreen]
************************************************** ************************
>