Looking for how to create a report for sql'05 to see who's logging in succes
fully and then failed user logins as well perhaps on a second report.
Is there a way to capture logins historically with just sql server? How do
you set this up? Could someone point me in the right direction or, possibly
an example?
ThanksGo to Server Properties, Security tab, Login auditing. Login information
will be written to SQL Server Log and Windows Event Viewer.
Ben Nevarez, MCDBA, OCP
Database Administrator
"James Wuerflein" wrote:
> Looking for how to create a report for sql'05 to see who's logging in succ
esfully and then failed user logins as well perhaps on a second report.
> Is there a way to capture logins historically with just sql server? How d
o you set this up? Could someone point me in the right direction or, possib
ly an example?
> Thanks
>|||What an easy way to take that an create a report forthose logins that I coul
d give to management?
Thanks
Go to Server Properties, Security tab, Login auditing. Login information
will be written to SQL Server Log and Windows Event Viewer.
Ben Nevarez, MCDBA, OCP
Database Administrator
"James Wuerflein" wrote:
[vbcol=seagreen]
> Looking for how to create a report for sql'05 to see who's logging in succ
esfully and then failed user logins as well perhaps on a second report.
>
> Is there a way to capture logins historically with just sql server? How d
o you set this up? Could someone point me in the right direction or, possib
ly an example?
>
> Thanks
>
Showing posts with label failed. Show all posts
Showing posts with label failed. Show all posts
Monday, March 26, 2012
Friday, March 23, 2012
Report Model Template
HI,
When I create a new Business Intelligence Projects, I can not find the "Report Model Project" template. I am not sure If I failed to install a few components ( client components). If this is the problem, how can I add these templates?
Thanks,
RR
I'm having the same problem. I've chosen to install all components and yet no Report Model Project Template. Is there somewhere we could download this template. I don't know if this makes a difference, but I have a licensed copy of Visual Studio 2005 on my computer. Thanks in advance for your advice.|||
Ok. I've figured out what was wrong here.
The Report Model template appears to be related to integration services and is not included in the Express Edition.
I had installed Visual Studio, but not the SQL Server developer tools.
Later, I installed the express version when starting to work on SQL Server Reports.
After removing the Express Edition and then installing the SQL Server developer tools from the Visual Studio disks, the Report Model project is listed as an available option.
Report Model Template
HI,
When I create a new Business Intelligence Projects, I can not find the "Report Model Project" template. I am not sure If I failed to install a few components ( client components). If this is the problem, how can I add these templates?
Thanks,
RR
I'm having the same problem. I've chosen to install all components and yet no Report Model Project Template. Is there somewhere we could download this template. I don't know if this makes a difference, but I have a licensed copy of Visual Studio 2005 on my computer. Thanks in advance for your advice.|||
Ok. I've figured out what was wrong here.
The Report Model template appears to be related to integration services and is not included in the Express Edition.
I had installed Visual Studio, but not the SQL Server developer tools.
Later, I installed the express version when starting to work on SQL Server Reports.
After removing the Express Edition and then installing the SQL Server developer tools from the Visual Studio disks, the Report Model project is listed as an available option.
Monday, March 12, 2012
report manager is not working--urgent
hi,
I was working on reporting services and when i opening the report
manager in the browser, it is giving me error
the error is
the request failed with HTTP status 404: Not Found
and the reportserver it working fine.
I have seen the rswebapplication.config and the 2 virtual directories
also but i could trace out the problem. So please any one could help me
in finding the solution.
Thanks and Regards
JaganTry this : http://<servername>/Reports/Pages/Folder.aspx
And also : http://<servername>
On the other hand, when you do this : http://<servername>/reports/Pages,
error 404, it's normal.
However that may be, the server can't access the folder or the page...
Hope this can help|||I am also having same problem where in suddenly I have started getting:
The request failed with HTTP status 404: Not Found.
I have tried qualifying the server name and checked rswebapplication.config
file too but cant fix the problem.
Any other pointers will be highly appreciated!!
--
Thanks
"Doume" wrote:
> Try this : http://<servername>/Reports/Pages/Folder.aspx
> And also : http://<servername>
> On the other hand, when you do this : http://<servername>/reports/Pages,
> error 404, it's normal.
> However that may be, the server can't access the folder or the page...
> Hope this can help
>|||Hi What do we need to check in the rswebapplication.config file?
I have the same issue
"Doume" wrote:
> Try this : http://<servername>/Reports/Pages/Folder.aspx
> And also : http://<servername>
> On the other hand, when you do this : http://<servername>/reports/Pages,
> error 404, it's normal.
> However that may be, the server can't access the folder or the page...
> Hope this can help
>|||Check to see if you have removed the Virtual Directory 'Reportserver' in IIS
if so add back - it should point to "C:\Program Files\Microsoft SQL
Server\MSSQL\Reporting Services\ReportServer" or there's abouts.
"tiwanap" wrote:
> I am also having same problem where in suddenly I have started getting:
> The request failed with HTTP status 404: Not Found.
> I have tried qualifying the server name and checked rswebapplication.config
> file too but cant fix the problem.
> Any other pointers will be highly appreciated!!
> --
> Thanks
>
> "Doume" wrote:
> > Try this : http://<servername>/Reports/Pages/Folder.aspx
> >
> > And also : http://<servername>
> > On the other hand, when you do this : http://<servername>/reports/Pages,
> > error 404, it's normal.
> >
> > However that may be, the server can't access the folder or the page...
> >
> > Hope this can help
> >
> >
I was working on reporting services and when i opening the report
manager in the browser, it is giving me error
the error is
the request failed with HTTP status 404: Not Found
and the reportserver it working fine.
I have seen the rswebapplication.config and the 2 virtual directories
also but i could trace out the problem. So please any one could help me
in finding the solution.
Thanks and Regards
JaganTry this : http://<servername>/Reports/Pages/Folder.aspx
And also : http://<servername>
On the other hand, when you do this : http://<servername>/reports/Pages,
error 404, it's normal.
However that may be, the server can't access the folder or the page...
Hope this can help|||I am also having same problem where in suddenly I have started getting:
The request failed with HTTP status 404: Not Found.
I have tried qualifying the server name and checked rswebapplication.config
file too but cant fix the problem.
Any other pointers will be highly appreciated!!
--
Thanks
"Doume" wrote:
> Try this : http://<servername>/Reports/Pages/Folder.aspx
> And also : http://<servername>
> On the other hand, when you do this : http://<servername>/reports/Pages,
> error 404, it's normal.
> However that may be, the server can't access the folder or the page...
> Hope this can help
>|||Hi What do we need to check in the rswebapplication.config file?
I have the same issue
"Doume" wrote:
> Try this : http://<servername>/Reports/Pages/Folder.aspx
> And also : http://<servername>
> On the other hand, when you do this : http://<servername>/reports/Pages,
> error 404, it's normal.
> However that may be, the server can't access the folder or the page...
> Hope this can help
>|||Check to see if you have removed the Virtual Directory 'Reportserver' in IIS
if so add back - it should point to "C:\Program Files\Microsoft SQL
Server\MSSQL\Reporting Services\ReportServer" or there's abouts.
"tiwanap" wrote:
> I am also having same problem where in suddenly I have started getting:
> The request failed with HTTP status 404: Not Found.
> I have tried qualifying the server name and checked rswebapplication.config
> file too but cant fix the problem.
> Any other pointers will be highly appreciated!!
> --
> Thanks
>
> "Doume" wrote:
> > Try this : http://<servername>/Reports/Pages/Folder.aspx
> >
> > And also : http://<servername>
> > On the other hand, when you do this : http://<servername>/reports/Pages,
> > error 404, it's normal.
> >
> > However that may be, the server can't access the folder or the page...
> >
> > Hope this can help
> >
> >
Friday, March 9, 2012
Report Manager and The request failed with HTTP status 400
I have installed Reporting services on a win2k3 on a completely different
irtual Directory than Default Directory .My Report Server is working fine
but I can't get my reporting manager working it give me this error:
The request failed with HTTP status 400:bad request,
Is there somebody who can help me.
ThnaksI think I got the answert ,,
I'm using a DNS for the new virtual directory that I have installed report
server and report manager on it and I forogt to update <ReportServerUrl> in
the RSWebApplication.config file of "Report Manager"
in the following address:
C:\Program Files\Microsoft SQL Server\MSSQL\Reporting Services\ReportManager
It was pointing to the wrong address http://localhost/reportsver where as it
should be http://MyDNS/reportsver.
HTH,
ALI-R
"ALI-R" <newbie@.microsoft.com> wrote in message
news:%23s41$7MBFHA.3528@.tk2msftngp13.phx.gbl...
> I have installed Reporting services on a win2k3 on a completely different
> irtual Directory than Default Directory .My Report Server is working fine
> but I can't get my reporting manager working it give me this error:
> The request failed with HTTP status 400:bad request,
> Is there somebody who can help me.
> Thnaks
>|||Hi all,
we're still in trouble as our ReportManager webapp still won't work.
I verified the RSWebApplication.config files of both Report Manager and
Report Server to contain
<ReportServerUrl>http://localhost/ReportServer</ReportServerUrl>
and
<UrlRoot>http://localhost/ReportServer</UrlRoot>
respectively.
I already verified all permissions and even changed both above URLs to read
http://<servername> instead of localhost. This does not make any noticable
difference.
This is real trouble, MS, I'd hate to have to resort to reïnstalling
everything from scratch, as there's no telling how if, or how long, this will
work...
Please help? :o(
Ramses.
Still, the ReportServer works just fine on both
http://localhost/ReportServer and http://severname/ReportServer, wheras the
ReportManager simply refuses to work. It keeps yielding the dreaded
The request failed with HTTP status 400: Bad Request.
"ALI-R" wrote:
> I think I got the answert ,,
> I'm using a DNS for the new virtual directory that I have installed report
> server and report manager on it and I forogt to update <ReportServerUrl> in
> the RSWebApplication.config file of "Report Manager"
> in the following address:
> C:\Program Files\Microsoft SQL Server\MSSQL\Reporting Services\ReportManager
> It was pointing to the wrong address http://localhost/reportsver where as it
> should be http://MyDNS/reportsver.
> HTH,
> ALI-R
> "ALI-R" <newbie@.microsoft.com> wrote in message
> news:%23s41$7MBFHA.3528@.tk2msftngp13.phx.gbl...
> > I have installed Reporting services on a win2k3 on a completely different
> > irtual Directory than Default Directory .My Report Server is working fine
> > but I can't get my reporting manager working it give me this error:
> >
> > The request failed with HTTP status 400:bad request,
> >
> > Is there somebody who can help me.
> >
> > Thnaks
> >
> >
>
>|||Hi all,
we're still in trouble as our ReportManager webapp still won't work.
I verified the RSWebApplication.config files of both Report Manager and
Report Server to contain
<ReportServerUrl>http://localhost/ReportServer</ReportServerUrl>
and
<UrlRoot>http://localhost/ReportServer</UrlRoot>
respectively.
I already verified all permissions and even changed both above URLs to read
http://<servername> instead of localhost. This does not make any noticable
difference.
This is real trouble, MS, I'd hate to have to resort to reïnstalling
everything from scratch, as there's no telling how if, or how long, this will
work...
Please help? :o(
Ramses.
"ALI-R" wrote:
> I think I got the answert ,,
> I'm using a DNS for the new virtual directory that I have installed report
> server and report manager on it and I forogt to update <ReportServerUrl> in
> the RSWebApplication.config file of "Report Manager"
> in the following address:
> C:\Program Files\Microsoft SQL Server\MSSQL\Reporting Services\ReportManager
> It was pointing to the wrong address http://localhost/reportsver where as it
> should be http://MyDNS/reportsver.
> HTH,
> ALI-R
> "ALI-R" <newbie@.microsoft.com> wrote in message
> news:%23s41$7MBFHA.3528@.tk2msftngp13.phx.gbl...
> > I have installed Reporting services on a win2k3 on a completely different
> > irtual Directory than Default Directory .My Report Server is working fine
> > but I can't get my reporting manager working it give me this error:
> >
> > The request failed with HTTP status 400:bad request,
> >
> > Is there somebody who can help me.
> >
> > Thnaks
> >
> >
>
>|||I would check the host header in IIS. I have been having a problem
where I can't view the report properties, export a report, or schedule
a report (viewing is fine, though).
I was messing with the host headers in IIS and got that message if I
had things configured incorrectly. For working locally, you should
probably not have anything in the host header value for the site.|||I have no Host-headers set for the default website - checked this numerous
times. The default website is bound to both 127.0.0.1 and the LAN IP address
of the server. Note that my http://<servername>/Reports tests wouldn't have
worked otherwise.
Still at a loss. :o(
"cybermud" wrote:
> I would check the host header in IIS. I have been having a problem
> where I can't view the report properties, export a report, or schedule
> a report (viewing is fine, though).
> I was messing with the host headers in IIS and got that message if I
> had things configured incorrectly. For working locally, you should
> probably not have anything in the host header value for the site.
>
irtual Directory than Default Directory .My Report Server is working fine
but I can't get my reporting manager working it give me this error:
The request failed with HTTP status 400:bad request,
Is there somebody who can help me.
ThnaksI think I got the answert ,,
I'm using a DNS for the new virtual directory that I have installed report
server and report manager on it and I forogt to update <ReportServerUrl> in
the RSWebApplication.config file of "Report Manager"
in the following address:
C:\Program Files\Microsoft SQL Server\MSSQL\Reporting Services\ReportManager
It was pointing to the wrong address http://localhost/reportsver where as it
should be http://MyDNS/reportsver.
HTH,
ALI-R
"ALI-R" <newbie@.microsoft.com> wrote in message
news:%23s41$7MBFHA.3528@.tk2msftngp13.phx.gbl...
> I have installed Reporting services on a win2k3 on a completely different
> irtual Directory than Default Directory .My Report Server is working fine
> but I can't get my reporting manager working it give me this error:
> The request failed with HTTP status 400:bad request,
> Is there somebody who can help me.
> Thnaks
>|||Hi all,
we're still in trouble as our ReportManager webapp still won't work.
I verified the RSWebApplication.config files of both Report Manager and
Report Server to contain
<ReportServerUrl>http://localhost/ReportServer</ReportServerUrl>
and
<UrlRoot>http://localhost/ReportServer</UrlRoot>
respectively.
I already verified all permissions and even changed both above URLs to read
http://<servername> instead of localhost. This does not make any noticable
difference.
This is real trouble, MS, I'd hate to have to resort to reïnstalling
everything from scratch, as there's no telling how if, or how long, this will
work...
Please help? :o(
Ramses.
Still, the ReportServer works just fine on both
http://localhost/ReportServer and http://severname/ReportServer, wheras the
ReportManager simply refuses to work. It keeps yielding the dreaded
The request failed with HTTP status 400: Bad Request.
"ALI-R" wrote:
> I think I got the answert ,,
> I'm using a DNS for the new virtual directory that I have installed report
> server and report manager on it and I forogt to update <ReportServerUrl> in
> the RSWebApplication.config file of "Report Manager"
> in the following address:
> C:\Program Files\Microsoft SQL Server\MSSQL\Reporting Services\ReportManager
> It was pointing to the wrong address http://localhost/reportsver where as it
> should be http://MyDNS/reportsver.
> HTH,
> ALI-R
> "ALI-R" <newbie@.microsoft.com> wrote in message
> news:%23s41$7MBFHA.3528@.tk2msftngp13.phx.gbl...
> > I have installed Reporting services on a win2k3 on a completely different
> > irtual Directory than Default Directory .My Report Server is working fine
> > but I can't get my reporting manager working it give me this error:
> >
> > The request failed with HTTP status 400:bad request,
> >
> > Is there somebody who can help me.
> >
> > Thnaks
> >
> >
>
>|||Hi all,
we're still in trouble as our ReportManager webapp still won't work.
I verified the RSWebApplication.config files of both Report Manager and
Report Server to contain
<ReportServerUrl>http://localhost/ReportServer</ReportServerUrl>
and
<UrlRoot>http://localhost/ReportServer</UrlRoot>
respectively.
I already verified all permissions and even changed both above URLs to read
http://<servername> instead of localhost. This does not make any noticable
difference.
This is real trouble, MS, I'd hate to have to resort to reïnstalling
everything from scratch, as there's no telling how if, or how long, this will
work...
Please help? :o(
Ramses.
"ALI-R" wrote:
> I think I got the answert ,,
> I'm using a DNS for the new virtual directory that I have installed report
> server and report manager on it and I forogt to update <ReportServerUrl> in
> the RSWebApplication.config file of "Report Manager"
> in the following address:
> C:\Program Files\Microsoft SQL Server\MSSQL\Reporting Services\ReportManager
> It was pointing to the wrong address http://localhost/reportsver where as it
> should be http://MyDNS/reportsver.
> HTH,
> ALI-R
> "ALI-R" <newbie@.microsoft.com> wrote in message
> news:%23s41$7MBFHA.3528@.tk2msftngp13.phx.gbl...
> > I have installed Reporting services on a win2k3 on a completely different
> > irtual Directory than Default Directory .My Report Server is working fine
> > but I can't get my reporting manager working it give me this error:
> >
> > The request failed with HTTP status 400:bad request,
> >
> > Is there somebody who can help me.
> >
> > Thnaks
> >
> >
>
>|||I would check the host header in IIS. I have been having a problem
where I can't view the report properties, export a report, or schedule
a report (viewing is fine, though).
I was messing with the host headers in IIS and got that message if I
had things configured incorrectly. For working locally, you should
probably not have anything in the host header value for the site.|||I have no Host-headers set for the default website - checked this numerous
times. The default website is bound to both 127.0.0.1 and the LAN IP address
of the server. Note that my http://<servername>/Reports tests wouldn't have
worked otherwise.
Still at a loss. :o(
"cybermud" wrote:
> I would check the host header in IIS. I have been having a problem
> where I can't view the report properties, export a report, or schedule
> a report (viewing is fine, though).
> I was messing with the host headers in IIS and got that message if I
> had things configured incorrectly. For working locally, you should
> probably not have anything in the host header value for the site.
>
Subscribe to:
Posts (Atom)