Can't see content tab or properties tab.

An administrator installed reporting services. I went to the url to the
report manager, I cannot see anything on the home page, no tabs at all. How
do I set it up to show me these tabs?
Thanks,
Rick.Log into the machine locally as a member of the local administartor's group.
You'll be able to assign permissions either using the SiteSettings-->Manage
site wide security or through the properties tab
-Lukasz
This posting is provided "AS IS" with no warranties, and confers no rights.
"Rick" <noodle@.noodle.com> wrote in message
news:%23cSbAlPaEHA.644@.tk2msftngp13.phx.gbl...
> An administrator installed reporting services. I went to the url to the
> report manager, I cannot see anything on the home page, no tabs at all.
> How
> do I set it up to show me these tabs?
> Thanks,
> Rick.
>

can't register server

I have SQL Server 2k, sp3a, on a w2k, sp4 box. I'm at home, where I
have no domain. I have two clients, one w2k Pro, sp4, and the other
XP, sp1. I'm using Windows authentication. Neither can register my
server. The error msg is the same for both:
<mysvr> - SQL Server does not exist or access denied.
ConnectionOpen (Connect())
Mind you, the server did show up in the client window, so the client
does seem to know that the server does exist.
Might anyone have an iea as to what I've done wrong? Or haven't done?
Thanks in advance,
Tom
Do you have a firewall running on the box that is hosting SQL Server?
Perhaps it is blocking the connection attempts.
Keith
"Tcs" <tsmith@.eastpointcityNoSpam.org> wrote in message
news:s5ev619fasn9sskr0pdvevu9mfarrldo3l@.4ax.com...
>I have SQL Server 2k, sp3a, on a w2k, sp4 box. I'm at home, where I
> have no domain. I have two clients, one w2k Pro, sp4, and the other
> XP, sp1. I'm using Windows authentication. Neither can register my
> server. The error msg is the same for both:
> <mysvr> - SQL Server does not exist or access denied.
> ConnectionOpen (Connect())
> Mind you, the server did show up in the client window, so the client
> does seem to know that the server does exist.
> Might anyone have an iea as to what I've done wrong? Or haven't done?
> Thanks in advance,
> Tom
>
|||Tom hi,
Did you check your client network utility in your clients. Is any record in
there?
You use DHCP or static IP?
Is your name resolution correct?
Are your windows logins in the SQL Server logins?
Check these first
HTH
Andreas
"Tcs" wrote:

> I have SQL Server 2k, sp3a, on a w2k, sp4 box. I'm at home, where I
> have no domain. I have two clients, one w2k Pro, sp4, and the other
> XP, sp1. I'm using Windows authentication. Neither can register my
> server. The error msg is the same for both:
> <mysvr> - SQL Server does not exist or access denied.
> ConnectionOpen (Connect())
> Mind you, the server did show up in the client window, so the client
> does seem to know that the server does exist.
> Might anyone have an iea as to what I've done wrong? Or haven't done?
> Thanks in advance,
> Tom
>

cant open databases folder

Hello, I just installed SQL Server 2000 on my home computer and am
connecting to a remote SQL server over the Internet. I can log into
the server just fine and see 7 folders including the 'Databases'
folder. I can open up all of the other 6 folders but for some crazy
reason when I double click on the 'Databases' folder, I can't open it!
The hourglass appears and Enterprise Manager basically locks up. Does
anyone know what's going on???
Please email response to nkulshresh@.hotmail.com as well as posting to
group.

Thanks,
Navin[posted and mailed, please reply in news]

Navin Kulshreshtha (amador612@.hotmail.com) writes:
> Hello, I just installed SQL Server 2000 on my home computer and am
> connecting to a remote SQL server over the Internet. I can log into
> the server just fine and see 7 folders including the 'Databases'
> folder. I can open up all of the other 6 folders but for some crazy
> reason when I double click on the 'Databases' folder, I can't open it!
> The hourglass appears and Enterprise Manager basically locks up. Does
> anyone know what's going on???

It could be that autoclose is turned for one or more databasees. Connect
with Query Analyzer, and run an sp_help and check the options columns.

Also check that you have not enabled ODBC tracing on your machine.

> Please email response to nkulshresh@.hotmail.com as well as posting to
> group.

If you want replies to a certain address, please put it in the Reply-To
field of your posting.

--
Erland Sommarskog, SQL Server MVP, sommar@.algonet.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp

Can't log in to reporting services in my browser

I've installed the Developer's edition of SQL05 on my PC at home. I am able to open the reporting services via the Manager Studio and Windows login under my username and password, however I cannot open it in my browser when I enter the

http://computername/reports address. I get a login dialog and enter "computername/myloginID" for the user and my local login password. It will not accept the login and reprompt until I exceed 3 tries.

I also tried logging in with the PC's admin id and password as well as the sa account name and password.

Any ideas on what I missed in the setup or security?

Thanks for any assistance anyone can provide

mike...

Hi,

Did you installed a named SQL Server named instance? If so, you need to add the name of your instance to the url.

Are you using a proxy server?

Greetz,

Geert

Geert Verhoeven
Consultant @. Ausy Belgium

My Personal Blog

|||

Thank you for responding. The answer to both of your questions is no, I used the defaults through the entire install process. The service is running locally on my pc.

I've tried to log in via http://localhost/reports as well as http://<pcname>/reports. In both instances a dialog box with "Connect to <pcname>" with two fields one for my user name and one for a password. My normal password and ID does is not accepted.

mike...

|||

This is usually an indication that the service is having some sort of fatal error. Can you look in the log files and see if there are any errors in there?

-Daniel

|||

Hi Daniel, thanks for your suggestion. I found logs in C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\LogFiles, I assume this is the logs folder you mean.

I looked through some of the 50 or so log files there and saw nothing that looked like an error log, the all seem to be process tracking logs. Can you be more specific on which log I should look at?

Thanks

|||

Hello Mike,

I believe this is due to the security settings in IIS. One thing to try is to enable anonymous access from the 'Reports' and 'ReportServer' directories in your IIS websites and see if it works. I had this same problem before I got the security settings ironed out in IIS.

In my setup, I have disabled anonymous access on the 'Default Web Site', 'Reports', and 'ReportServer' items. I have also enabled 'Integrated Windows authentication' on all 3. The DefaultAppPool runs as the Network Service.

From Reporting Services Configuration Manager, Report Server and Report Manager, both run in the DefaultAppPool application pool.

Hope this helps.

Jarret

|||

Hi Jarret,

Thank you for your tip, it did the trick! I enabled anonymous access access on the two folders and got into the Report Manager.

I guess this leads to another question, anonymous access is fine for me on my local machine here at home, but not exactly what I want on the production system at work. We're using Windows authentication at work, (with none of the problems I've had here at home that I am aware of), but I'm thinking I need to educate myself more on how the security settings between SQL05, Reporting Services, and IIS interact.

You spoke of "ironing out IIS security", can you recommend any resources from Microsoft which will help me learn how to manage security for SQL, etc.?

To all, thanks for your replies to my questions here!

|||

That is correct, I wouldn't set up my servers with anonymous access enabled either. I actually had one of my developers help me initially, but eventually I figured out how to have it work without anonymous access.

Sorry I don't have any links to any articles, I just haven't searched. Researching how the security between SQL2005, RS, and IIS work with each other is on my list of things to do as well.

Jarret

Cant Install Reporting Service on Vista Home Premium

I am using Vista Home Premium, Sql 2005 Sp2 & IIS 7.0

I tried to install Reporting service on Vista home premium. Got message there is compatability issue with this version of Windows. Then i check support website and downloaded SP2. BUT CANT STILL INSTALL REPORTING SERVICE ON MY SYSTEM.

Have tried all solution but i think problem is with windows authentication. which is creating problem for me.

Can Someone Help......?

Hi vishals_patel,

What edition of SQL Server Reporting Services SP2 you try to install on Vista Home Premium?

It seems that for Vista Home Premium 32 bits only these editions are supported: Developer, Express Advanced, and Evaluation.

For more information, you can go here:

http://msdn2.microsoft.com/en-us/library/ms143506.aspx

Mihaela

This posting is provided "AS IS" with no warranties, and confers no rights.

|||

Hi Mihaela,

I am using Vista home premium with evaluation version of SQL 2005 Enterprise. Everything is working okay except Reporting service. Is only reporting service not supported on Home premium.

Vishal Patel

|||

Hi Vishal,

You said you cannot install Reporting Services Evaluation edition on your Vista Home Premium machine, even if Evaluation is a supported edition for this OS.

I would like to have more information about your installation process:

- did you install first RTM and after this SP2? If not, how did you install? Did the installation done before SP2 (RTM or SP1) succeed?

- you should find some error messages in the setup log files located here:

%Program Files%\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix

The name of the SP2 RS setup log file should look something like this: RS9_Hotfix_KB921896_sqlrun_rs.msp_X.log. Could you, please, take a look there and let me know what errors you find?

Thank you,

Mihaela

This posting is provided "AS IS" with no warranties, and confers no rights.

Could you, please,

|||

Hi,

Cant find file name like this.

Let me tell you how i have done installation. First i have installed Sql evaluation version from CD i got with my book. I got message that "This version have compatibility issue with this version of windows". Then i went to microsoft.com to find solution. I found that install sql server and then install SP2 to resolve this error.

So, ultimately i have first installed SQL 2005 (Cant get option for RS). Then it automatically updated to SP1 by Vista and to SP2 later on. Then i thought that RS will work on my system. But it didnt, So i tried to repair sql and tried to check RS at installation screen but cant do that again.

Hope this would help you to find solution for me.

Thanks for your response.

|||

Hi Vishals,

According with this:

http://www.iis.net/default.aspx?tabid=2&subtabid=25&i=1100

IIS7 on Vista Home Premium does not support Windows Authentication. This explains why your pre-requisites check for RS fail and you cannot install RS on your Vista Home Premium.

It seems that there is a mismatch between this document and the document I previously pointed to, so I would suggest you to go at:

http://connect.microsoft.com/

and to open a bug. We will investigate your issue and we will provide you direct feedback.

I also found another thread about a similar issue:

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1269577&SiteID=1

Thank you,

Mihaela

Cant Install Reporting Service on Vista Home Premium

I am using Vista Home Premium, Sql 2005 Sp2 & IIS 7.0

I tried to install Reporting service on Vista home premium. Got message there is compatability issue with this version of Windows. Then i check support website and downloaded SP2. BUT CANT STILL INSTALL REPORTING SERVICE ON MY SYSTEM.

Have tried all solution but i think problem is with windows authentication. which is creating problem for me.

Can Someone Help......?

Hi vishals_patel,

What edition of SQL Server Reporting Services SP2 you try to install on Vista Home Premium?

It seems that for Vista Home Premium 32 bits only these editions are supported: Developer, Express Advanced, and Evaluation.

For more information, you can go here:

http://msdn2.microsoft.com/en-us/library/ms143506.aspx

Mihaela

This posting is provided "AS IS" with no warranties, and confers no rights.

|||

Hi Mihaela,

I am using Vista home premium with evaluation version of SQL 2005 Enterprise. Everything is working okay except Reporting service. Is only reporting service not supported on Home premium.

Vishal Patel

|||

Hi Vishal,

You said you cannot install Reporting Services Evaluation edition on your Vista Home Premium machine, even if Evaluation is a supported edition for this OS.

I would like to have more information about your installation process:

- did you install first RTM and after this SP2? If not, how did you install? Did the installation done before SP2 (RTM or SP1) succeed?

- you should find some error messages in the setup log files located here:

%Program Files%\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix

The name of the SP2 RS setup log file should look something like this: RS9_Hotfix_KB921896_sqlrun_rs.msp_X.log. Could you, please, take a look there and let me know what errors you find?

Thank you,

Mihaela

This posting is provided "AS IS" with no warranties, and confers no rights.

Could you, please,

|||

Hi,

Cant find file name like this.

Let me tell you how i have done installation. First i have installed Sql evaluation version from CD i got with my book. I got message that "This version have compatibility issue with this version of windows". Then i went to microsoft.com to find solution. I found that install sql server and then install SP2 to resolve this error.

So, ultimately i have first installed SQL 2005 (Cant get option for RS). Then it automatically updated to SP1 by Vista and to SP2 later on. Then i thought that RS will work on my system. But it didnt, So i tried to repair sql and tried to check RS at installation screen but cant do that again.

Hope this would help you to find solution for me.

Thanks for your response.

|||

Hi Vishals,

According with this:

http://www.iis.net/default.aspx?tabid=2&subtabid=25&i=1100

IIS7 on Vista Home Premium does not support Windows Authentication. This explains why your pre-requisites check for RS fail and you cannot install RS on your Vista Home Premium.

It seems that there is a mismatch between this document and the document I previously pointed to, so I would suggest you to go at:

http://connect.microsoft.com/

and to open a bug. We will investigate your issue and we will provide you direct feedback.

I also found another thread about a similar issue:

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1269577&SiteID=1

Thank you,

Mihaela

Can't get to report manager home page.

I have Reporting Services 2005 installed on my Windows XP machine. I can access the Report Manager home page with the built-in Administrator account. However, my own account, which is a member of the Computer Admin group, is denied access with a 401.3 error. The 401.3 seems to be access denied due to not being on the ACL. I am using simple file sharing. What should I do to give access to my own account?

I don't know if IIS works with simple file sharing. It is something at the IIS security layer, nothing to do with SSRS. You might try some other files a simple ASP.NET app.|||

It wouldn't be correct to say that IIS doesn't work with Simple File Sharing, since I am able to get to the Report Manager home page using the built-in administrator account. Also, I should mention that if I allow anonymous access to the Report Manager directory I can get to the Report Manager home page under my own account, but then the home page is crippled (no site settings tab for example). I agree this might not be a SSRS problem per se, but I was hoping someone has encountered this problem when using a development machine (Windows XP) to host SSRS, as I am.

|||Yes, turning off Simple File Sharing works.

Cant get SQL Server Express to install

I'm using the disk that came with my Visual Web Developer for Dummies book. It installed on my XP Home machine, but when installing on my XP Pro machine, the fourth step, SQL Server Express, it fails. I cleaned up my hard drive (about ten gigs of free space), I followed the steps herehttp://msdn.microsoft.com/vstudio/support/readme/default.aspx to uninstall everything dot net related. Rebooted, checked my control panel, etc. Tried to install. It just fails. No error message.

Can anyone give me an idea of where to start?

Thanks

Try to install the version on msdn rather then on the CD and see if it works. Here is the link for the download.

http://msdn.microsoft.com/vstudio/express/sql/download/default.aspx

|||

Ha ha ha. Never quit.

Banging my head against the wall, or trying to get this thing to work?

I was thinking about my gov't issued perpetual virus scan, and thought I'd disable it. And then some time ago I had to do something (that never worked) regarding permissions to the INETPUB folder. And another source also suggested a direct download. Which is what I'll try next. I think I'll try it first in the 'repair' mode if it's available (as it is on the disk - it recognizes that the first three options installed properly and offers up the fourth).

|||

Success!

I had already disabled the virus scan, and so don't know if that had anything to do with it. But the download of just the SQL Server says it was successful. My dot net 2.0 framework was detected (it must be installed first), and it sailed thru like it should have in the first place.

As I think I mentioned in my first post, installation on my other laptop (wife's) with XP Home went perfect from the disk. A little weird that my old standby wouldn't work with it, but I'll accept it. And get started with what appears to be some very cool stuff.

|||I came across an issue on installing. When operating from the disk in the Visual Web Developer for Dummies book, the SQL Server just failed. No messages. When downloading from MicroSoft, I got a message that the c:\program files\microsoft sql server folder couldn't be compressed. So, while that message was up, I went thru explorer to change the properties of it. More than a few times, exe and dll files came up that were in use and couldn't be uncompressed. I finally hit the ignore all button and hoped for the best. When it was finished, I went back to the installation routine and hit continue. And it appears to have worked.