Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Missing Instance of SSRS 2008 Expand / Collapse
Author
Message
Posted Saturday, August 29, 2009 7:01 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, September 8, 2009 12:52 PM
Points: 6, Visits: 21
Thanks to all for read this.

Sorry if I am wrong, please take me to the rigth way.

I had installed Sql server 2008 trial for a 180 days test period. It is a full product version.

Databases reportserver$InstanceName and reportserver$InstanceNameTempdb, are present. This means that ssrs was installed.
Furthermore, I had checked on dvd installed components, and reporting services was installed.

Ok, the problem: When I try to connect via Management Studio to the instance: Reporting Services, in order to assign reports roles,
this instance is not on the list. Only appears Database Engine and Sql Server Compact instances, but not Reporting Services instance.
What is wrong?

I tried to connect to the url report server, of course, only as administrator, and only a few text was displayed.


pcname/ReportServer_instancename - /

--------------------------------------------------------------------------------


--------------------------------------------------------------------------------
Microsoft SQL Server Reporting Services Version 10.0.2531.0


What i had missed?


By the way, I using Windows Vista U 64 ed, with Sql Server 2008 Trial :
This is the my sql server help info :

Microsoft SQL Server Management Studio 10.0.2531.0
Microsoft Data Access Components (MDAC) 6.0.6002.18005
Microsoft MSXML 2.6 3.0 4.0 5.0 6.0
Microsoft Internet Explorer 8.0.6001.18813
Microsoft .NET Framework 2.0.50727.4016
Operating System 6.0.6002


Thanks.
David.
Post #779516
Posted Sunday, August 30, 2009 10:47 AM
SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: 2 days ago @ 3:37 PM
Points: 4,389, Visits: 9,522
Using SSMS to connect to reporting services, the first thing you need to do is select Reporting Services as the type of connection, then type in the instance name you want to connect to (e.g. servername\instance).

The drop-down does not perform a search - it is more like a most recently used list and only displays the servers that you have connected to.



Jeffrey Williams
Problems are opportunites brilliantly disguised as insurmountable obstacles.

How to post questions to get better answers faster
Managing Transaction Logs
Post #779596
Posted Sunday, August 30, 2009 9:00 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, September 8, 2009 12:52 PM
Points: 6, Visits: 21
That is the problem. Any kind of instance appears like Reporting Services in what I can select the server\instancename. Just, it is not on the list of types of instances.
But, ok, I had Uninstalled all SQL, restart my pc and installed a full installation, this time, when configuring accounts, I just used one, the windows account of my session for all BI activities as I could assign it.
This happening :
- Business intelligence instances appears.
- I have any permission to assign roles or create it.
- I logged in as administrator and can create system roles and roles.
- Report Server Manager page is in the last status, just a couple of words like last post.
- I can not assign any user to any role. I suggesting that I had missing something else, or,
installed in a wrong way my sql server, once again.

Can you or someone else illustrate me?
I still cannot deploy due to an user/password window.

Thanks a lot answer and read my post.

Dalsom.
Post #779678
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse