It turned out the gui install somehow does not use the sql account I
specifyied. My event log indicated on my sql box that someone anoymous tried
to gain access to the sql box. So as always I searched the web. The solution
was to run setup by specifying rsssetupaccount=... rssetuppassword=... ,
then everything went fine including sp1 install.
Hope this helps others if they get into the same situation.
I am pretty sure I will encouter another problems when the web box goes
behind firewall. Gotta open sql port, etc.... fun stuffs. Until then, Happy
Easter !
[quoted text, click to view] "Jeff A. Stucker" wrote:
> Do you have both TCP and Named Pipes connections going to your database
> server? Named pipes won't work unless you have domain permissions. So try
> turning off named pipes on the DB server when you install.
>
> --
> Cheers,
>
> '(' Jeff A. Stucker
> \
>
> "sejoonpark" <sejoonpark@discussions.microsoft.com> wrote in message
> news:F1682E7A-14F1-4689-AE73-9973FD5E5BE9@microsoft.com...
> > Hello,
> >
> > I am trying to install Reporting Services on Windows 2003 server(web box)
> > which is not on domain. Everything goes fine until it tried to create
> > Reporting database on a remote SQL 2000 server(db box) which is on domain.
> >
> > I've searched, searched and searched. No luck so far.
> >
> > Th exact message is
> > " SQL Setup failed to connect to the database service for server
> > configuration. The error was: Login failed for user '(null)'. Reason: Not
> > associated with a trusted SQL server connection.... "
> >
> > The followings are what I've done so far.
> >
> > 1. Make sure SQL server loginmode is mixed mode. (Verified - always has
> > been)
> > 2. Installed Enterprise Manager on the web box and I can connect using sql
> > account.
> > 3. I can test connection via ODBC using the same account.
> >
> > Somehow when I specify SQL account on RS installation, it seems the
> > account
> > info gets disregarded.
> >
> > Please help...
> >
>
>
When you referred to (rsssetupaccount=... rssetuppassword=... ) what
exactly were you referring to? I get the same error using a SQL
account as well as a Domain account (both with sa rights on the SQL
Server). What exactly is rsssetupaccount and rssetuppassword?
Pardon my ignorance.
Thanks!
Todd
[quoted text, click to view] sejoonpark wrote:
> It turned out the gui install somehow does not use the sql account I
> specifyied. My event log indicated on my sql box that someone
anoymous tried
> to gain access to the sql box. So as always I searched the web. The
solution
> was to run setup by specifying rsssetupaccount=...
rssetuppassword=... ,
> then everything went fine including sp1 install.
>
> Hope this helps others if they get into the same situation.
>
> I am pretty sure I will encouter another problems when the web box
goes
> behind firewall. Gotta open sql port, etc.... fun stuffs. Until then,
Happy
> Easter !
>
> "Jeff A. Stucker" wrote:
>
> > Do you have both TCP and Named Pipes connections going to your
database
> > server? Named pipes won't work unless you have domain permissions.
So try
> > turning off named pipes on the DB server when you install.
> >
> > --
> > Cheers,
> >
> > '(' Jeff A. Stucker
> > \
> >
> > "sejoonpark" <sejoonpark@discussions.microsoft.com> wrote in
message
> > news:F1682E7A-14F1-4689-AE73-9973FD5E5BE9@microsoft.com...
> > > Hello,
> > >
> > > I am trying to install Reporting Services on Windows 2003
server(web box)
> > > which is not on domain. Everything goes fine until it tried to
create
> > > Reporting database on a remote SQL 2000 server(db box) which is
on domain.
> > >
> > > I've searched, searched and searched. No luck so far.
> > >
> > > Th exact message is
> > > " SQL Setup failed to connect to the database service for server
> > > configuration. The error was: Login failed for user '(null)'.
Reason: Not
> > > associated with a trusted SQL server connection.... "
> > >
> > > The followings are what I've done so far.
> > >
> > > 1. Make sure SQL server loginmode is mixed mode. (Verified -
always has
> > > been)
> > > 2. Installed Enterprise Manager on the web box and I can connect
using sql
> > > account.
> > > 3. I can test connection via ODBC using the same account.
> > >
> > > Somehow when I specify SQL account on RS installation, it seems
the
> > > account
> > > info gets disregarded.
> > >
> > > Please help...
> > >
> >
> >
> >
Don't see what you're looking for? Try a search.
