SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Missing Instance of SSRS 2008


Missing Instance of SSRS 2008

Author
Message
David Brea
David Brea
Forum Newbie
Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)

Group: General Forum Members
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.
Jeffrey Williams 3188
Jeffrey Williams 3188
SSCoach
SSCoach (19K reputation)SSCoach (19K reputation)SSCoach (19K reputation)SSCoach (19K reputation)SSCoach (19K reputation)SSCoach (19K reputation)SSCoach (19K reputation)SSCoach (19K reputation)

Group: General Forum Members
Points: 19867 Visits: 10042
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 opportunities brilliantly disguised as insurmountable obstacles.

How to post questions to get better answers faster
Managing Transaction Logs

David Brea
David Brea
Forum Newbie
Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)

Group: General Forum Members
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.Hehe
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search