Accuracy of Host column on SS 2000 Enterprise Manager Current Activity Process Info Screen

Yesterday and today, the Process Info screen in Enterprise Manager indicates that the "Host", a single workstation on our network, is generating around 50 connections to the database. This particular application is well-behaved and typically generates only 2 to 5 connections per instance. Furthermore, we cannot find this particular workstation/host on our network because we retired it off the network some time ago.

Anyone know of the accuracy of the Hosts column on this Enterprise Manager screen? We're suspecting that the network address column is correct but the Hosts column is incorrect. There are about 10 different network addresses pertaining to this particular Host (1-5 connections per network address).

Can you check the mAC Address for that host and find on the network?|||I have also been having that problem. I was able to use the MAC address to track down the PC when I first saw the problem, but found that the computer name was not what was displayed in SQL EM. Additionally, I am continuing to have the same problem but have found that different MAC addresses are being listed all with the same Host name. Should you find more information regarding this issue please post your results here.

Accuracy of Host column on SS 2000 Enterprise Manager Current Activity Process Info Screen

Yesterday and today, the Process Info screen in Enterprise Manager indicates that the "Host", a single workstation on our network, is generating around 50 connections to the database. This particular application is well-behaved and typically generates only 2 to 5 connections per instance. Furthermore, we cannot find this particular workstation/host on our network because we retired it off the network some time ago.

Anyone know of the accuracy of the Hosts column on this Enterprise Manager screen? We're suspecting that the network address column is correct but the Hosts column is incorrect. There are about 10 different network addresses pertaining to this particular Host (1-5 connections per network address).

Can you check the mAC Address for that host and find on the network?|||I have also been having that problem. I was able to use the MAC address to track down the PC when I first saw the problem, but found that the computer name was not what was displayed in SQL EM. Additionally, I am continuing to have the same problem but have found that different MAC addresses are being listed all with the same Host name. Should you find more information regarding this issue please post your results here.

accessing Report using the browser

Hi,
I have created a sample report called Report1 in SSRS 2005. This currently
is running locally on my workstation.
I can even browse to it using the http address i.e. http://localhost/Reports
The question is: How can someone else access this report on my machine. They
can not browse to my machine by typing http://12.32.2.344/Reports
Do I need to do any configuration in my local IIS?
ThanksIf you are on domain just create the other users logins in your reports /
machine and give access and they should be able to see it. Go to
http://localhost/reports and
site settings and give access for your machine or the server access as well
for the same users.
Amarnath
"farshad" wrote:
> Hi,
> I have created a sample report called Report1 in SSRS 2005. This currently
> is running locally on my workstation.
> I can even browse to it using the http address i.e. http://localhost/Reports
> The question is: How can someone else access this report on my machine. They
> can not browse to my machine by typing http://12.32.2.344/Reports
> Do I need to do any configuration in my local IIS?
> Thanks|||Hello,
I am now in the site settings page.
Not sure what to do now. Can you guide me please so that other users can
view the reports on my local machine?
Thanks
"Amarnath" wrote:
> If you are on domain just create the other users logins in your reports /
> machine and give access and they should be able to see it. Go to
> http://localhost/reports and
> site settings and give access for your machine or the server access as well
> for the same users.
> Amarnath
> "farshad" wrote:
> > Hi,
> > I have created a sample report called Report1 in SSRS 2005. This currently
> > is running locally on my workstation.
> > I can even browse to it using the http address i.e. http://localhost/Reports
> > The question is: How can someone else access this report on my machine. They
> > can not browse to my machine by typing http://12.32.2.344/Reports
> >
> > Do I need to do any configuration in my local IIS?
> > Thanks|||Just got to Home-> and properties tab, go for New role Assignment and give
your domain\name and select "Browser" if they just want to see.
Amarnath
"farshad" wrote:
> Hello,
> I am now in the site settings page.
> Not sure what to do now. Can you guide me please so that other users can
> view the reports on my local machine?
> Thanks
> "Amarnath" wrote:
> > If you are on domain just create the other users logins in your reports /
> > machine and give access and they should be able to see it. Go to
> > http://localhost/reports and
> > site settings and give access for your machine or the server access as well
> > for the same users.
> >
> > Amarnath
> >
> > "farshad" wrote:
> >
> > > Hi,
> > > I have created a sample report called Report1 in SSRS 2005. This currently
> > > is running locally on my workstation.
> > > I can even browse to it using the http address i.e. http://localhost/Reports
> > > The question is: How can someone else access this report on my machine. They
> > > can not browse to my machine by typing http://12.32.2.344/Reports
> > >
> > > Do I need to do any configuration in my local IIS?
> > > Thanks|||Since my last post, I think my IIS settings have changed. Now I can not
browse to http://localhost/reports.
Do you think it could be to do with the IIS settings? Can you guide me on
what the properties settings should be for reports and ReportServer please?
This is the error I get (See below):
Object not found!
The requested URL was not found on this server. If you entered the URL
manually please check your spelling and try again.
If you think this is a server error, please contact the webmaster.
Error 404
localhost
Thursday, February 15, 2007 12:50:47
Apache/2.0.54 (NETWARE) mod_jk/1.2.14
"Amarnath" wrote:
> Just got to Home-> and properties tab, go for New role Assignment and give
> your domain\name and select "Browser" if they just want to see.
> Amarnath
>
> "farshad" wrote:
> > Hello,
> > I am now in the site settings page.
> > Not sure what to do now. Can you guide me please so that other users can
> > view the reports on my local machine?
> > Thanks
> >
> > "Amarnath" wrote:
> >
> > > If you are on domain just create the other users logins in your reports /
> > > machine and give access and they should be able to see it. Go to
> > > http://localhost/reports and
> > > site settings and give access for your machine or the server access as well
> > > for the same users.
> > >
> > > Amarnath
> > >
> > > "farshad" wrote:
> > >
> > > > Hi,
> > > > I have created a sample report called Report1 in SSRS 2005. This currently
> > > > is running locally on my workstation.
> > > > I can even browse to it using the http address i.e. http://localhost/Reports
> > > > The question is: How can someone else access this report on my machine. They
> > > > can not browse to my machine by typing http://12.32.2.344/Reports
> > > >
> > > > Do I need to do any configuration in my local IIS?
> > > > Thanks|||"Just got to Home-> and properties tab, go for New role Assignment and give
your domain\name and select "Browser" if they just want to see."
What happens if there is no domain. We are using Novell.
"farshad" wrote:
> Since my last post, I think my IIS settings have changed. Now I can not
> browse to http://localhost/reports.
> Do you think it could be to do with the IIS settings? Can you guide me on
> what the properties settings should be for reports and ReportServer please?
> This is the error I get (See below):
> Object not found!
> The requested URL was not found on this server. If you entered the URL
> manually please check your spelling and try again.
> If you think this is a server error, please contact the webmaster.
> Error 404
> localhost
> Thursday, February 15, 2007 12:50:47
> Apache/2.0.54 (NETWARE) mod_jk/1.2.14
> "Amarnath" wrote:
> > Just got to Home-> and properties tab, go for New role Assignment and give
> > your domain\name and select "Browser" if they just want to see.
> >
> > Amarnath
> >
> >
> > "farshad" wrote:
> >
> > > Hello,
> > > I am now in the site settings page.
> > > Not sure what to do now. Can you guide me please so that other users can
> > > view the reports on my local machine?
> > > Thanks
> > >
> > > "Amarnath" wrote:
> > >
> > > > If you are on domain just create the other users logins in your reports /
> > > > machine and give access and they should be able to see it. Go to
> > > > http://localhost/reports and
> > > > site settings and give access for your machine or the server access as well
> > > > for the same users.
> > > >
> > > > Amarnath
> > > >
> > > > "farshad" wrote:
> > > >
> > > > > Hi,
> > > > > I have created a sample report called Report1 in SSRS 2005. This currently
> > > > > is running locally on my workstation.
> > > > > I can even browse to it using the http address i.e. http://localhost/Reports
> > > > > The question is: How can someone else access this report on my machine. They
> > > > > can not browse to my machine by typing http://12.32.2.344/Reports
> > > > >
> > > > > Do I need to do any configuration in my local IIS?
> > > > > Thanks|||No domain then just give the user name and give the same name on your machine
access from windows as well. So that the user when logs in will have your
machine (or where the reportserver is installed) access.
Amarnath
"farshad" wrote:
> "Just got to Home-> and properties tab, go for New role Assignment and give
> your domain\name and select "Browser" if they just want to see."
> What happens if there is no domain. We are using Novell.
>
> "farshad" wrote:
> > Since my last post, I think my IIS settings have changed. Now I can not
> > browse to http://localhost/reports.
> > Do you think it could be to do with the IIS settings? Can you guide me on
> > what the properties settings should be for reports and ReportServer please?
> >
> > This is the error I get (See below):
> > Object not found!
> > The requested URL was not found on this server. If you entered the URL
> > manually please check your spelling and try again.
> >
> > If you think this is a server error, please contact the webmaster.
> >
> > Error 404
> > localhost
> > Thursday, February 15, 2007 12:50:47
> > Apache/2.0.54 (NETWARE) mod_jk/1.2.14
> >
> > "Amarnath" wrote:
> >
> > > Just got to Home-> and properties tab, go for New role Assignment and give
> > > your domain\name and select "Browser" if they just want to see.
> > >
> > > Amarnath
> > >
> > >
> > > "farshad" wrote:
> > >
> > > > Hello,
> > > > I am now in the site settings page.
> > > > Not sure what to do now. Can you guide me please so that other users can
> > > > view the reports on my local machine?
> > > > Thanks
> > > >
> > > > "Amarnath" wrote:
> > > >
> > > > > If you are on domain just create the other users logins in your reports /
> > > > > machine and give access and they should be able to see it. Go to
> > > > > http://localhost/reports and
> > > > > site settings and give access for your machine or the server access as well
> > > > > for the same users.
> > > > >
> > > > > Amarnath
> > > > >
> > > > > "farshad" wrote:
> > > > >
> > > > > > Hi,
> > > > > > I have created a sample report called Report1 in SSRS 2005. This currently
> > > > > > is running locally on my workstation.
> > > > > > I can even browse to it using the http address i.e. http://localhost/Reports
> > > > > > The question is: How can someone else access this report on my machine. They
> > > > > > can not browse to my machine by typing http://12.32.2.344/Reports
> > > > > >
> > > > > > Do I need to do any configuration in my local IIS?
> > > > > > Thanks