**URGENT** Please Help ! Installation Issue

While installing MSRS i have taken care of all pre-requisites. I am
installing it on Windows 2003 server machine. I want to have the remote
sql-server instance for my reporting services. For Sql-server, i have taken
'Mixed mode installation' and given the username & password as 'sa'. As
specified if sql-server is a remote instance, then we should use sql server
Authentication as the 'Credential Type'.
I have selected the service account as 'Domain account'. And for Report
server database i have selected Sql login option & provided the username &
password as 'sa'. But its giving error as 'Login failed for user
domainname\machinename$'.
The exact error message is given below
"Sql setup failed to connect to the database service for server
configuration. The error was: Login failed for user
'Americas\HTNESX605VM09$'. Refer to the server error logs and setup logs for
more infirmation."
Did anyone encountered this problem before. This is very urgent if anyone
can give there suggestions for this problem.
Note: I am carrying out a remote installation connecting to my VMware server
using Terminal Services.
Thanks in advance.
Rajendra VaishnavSounds to me like the TS machine is not authenticated to do installations on
the SQL Server machine.
-prophead
"Rajendra" wrote:
> While installing MSRS i have taken care of all pre-requisites. I am
> installing it on Windows 2003 server machine. I want to have the remote
> sql-server instance for my reporting services. For Sql-server, i have taken
> 'Mixed mode installation' and given the username & password as 'sa'. As
> specified if sql-server is a remote instance, then we should use sql server
> Authentication as the 'Credential Type'.
> I have selected the service account as 'Domain account'. And for Report
> server database i have selected Sql login option & provided the username &
> password as 'sa'. But its giving error as 'Login failed for user
> domainname\machinename$'.
> The exact error message is given below
> "Sql setup failed to connect to the database service for server
> configuration. The error was: Login failed for user
> 'Americas\HTNESX605VM09$'. Refer to the server error logs and setup logs for
> more infirmation."
> Did anyone encountered this problem before. This is very urgent if anyone
> can give there suggestions for this problem.
> Note: I am carrying out a remote installation connecting to my VMware server
> using Terminal Services.
> Thanks in advance.
> Rajendra Vaishnav
>|||Hi Prophead,
The terminal server should have access to Sql server. While installing MSRS,
i had configured to use Sql authentication. So, ideally when try to connect
to the remote sql server to do the installation it should use Sql
authentication instead of windows authentication. Even if it is trying to use
the windows authentication, i am surprised why it should use an account
something like <domain name>\<servername$> instead I would only expect it to
use <domain name>\<user name>. Kindly advice.
Could this be to do something with installing MSMRS from Terminal services.
I am stuck at this point and need some help in proceeding further.
Thanks in advance.
Rajendra Vaishnav
"prophead" wrote:
> Sounds to me like the TS machine is not authenticated to do installations on
> the SQL Server machine.
> -prophead
> "Rajendra" wrote:
> > While installing MSRS i have taken care of all pre-requisites. I am
> > installing it on Windows 2003 server machine. I want to have the remote
> > sql-server instance for my reporting services. For Sql-server, i have taken
> > 'Mixed mode installation' and given the username & password as 'sa'. As
> > specified if sql-server is a remote instance, then we should use sql server
> > Authentication as the 'Credential Type'.
> >
> > I have selected the service account as 'Domain account'. And for Report
> > server database i have selected Sql login option & provided the username &
> > password as 'sa'. But its giving error as 'Login failed for user
> > domainname\machinename$'.
> >
> > The exact error message is given below
> > "Sql setup failed to connect to the database service for server
> > configuration. The error was: Login failed for user
> > 'Americas\HTNESX605VM09$'. Refer to the server error logs and setup logs for
> > more infirmation."
> >
> > Did anyone encountered this problem before. This is very urgent if anyone
> > can give there suggestions for this problem.
> >
> > Note: I am carrying out a remote installation connecting to my VMware server
> > using Terminal Services.
> >
> > Thanks in advance.
> > Rajendra Vaishnav
> >|||I don't have an answer for you, Ragendra, so I posted this thread as a new
question in hopes one of the MS guys will answer. It is posted under the
subject "Installation Security Issue".
-prophead
"prophead" wrote:
> Sounds to me like the TS machine is not authenticated to do installations on
> the SQL Server machine.
> -prophead
> "Rajendra" wrote:
> > While installing MSRS i have taken care of all pre-requisites. I am
> > installing it on Windows 2003 server machine. I want to have the remote
> > sql-server instance for my reporting services. For Sql-server, i have taken
> > 'Mixed mode installation' and given the username & password as 'sa'. As
> > specified if sql-server is a remote instance, then we should use sql server
> > Authentication as the 'Credential Type'.
> >
> > I have selected the service account as 'Domain account'. And for Report
> > server database i have selected Sql login option & provided the username &
> > password as 'sa'. But its giving error as 'Login failed for user
> > domainname\machinename$'.
> >
> > The exact error message is given below
> > "Sql setup failed to connect to the database service for server
> > configuration. The error was: Login failed for user
> > 'Americas\HTNESX605VM09$'. Refer to the server error logs and setup logs for
> > more infirmation."
> >
> > Did anyone encountered this problem before. This is very urgent if anyone
> > can give there suggestions for this problem.
> >
> > Note: I am carrying out a remote installation connecting to my VMware server
> > using Terminal Services.
> >
> > Thanks in advance.
> > Rajendra Vaishnav
> >