Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
Author |
Topic |
joe8079
Posting Yak Master
127 Posts |
Posted - 2011-07-08 : 15:42:36
|
Hello, I was hoping someone could help me get SQL reporting services going on SQL 2008 R2 express. I've been trying this for months and nothing seems to work, i've spent days searching online, but no suggestion seems to work. First, i'm using vista home 2007 SP1. When I go to click on the connect button, it is greyed out and my only option is to click find. The find box has my computers workstation ID in the server name field. When I click find, it says unable to connect to report server. I've tried the full sql server express path in there and all kinds of other stuff. When i put the full server name in, i get an error saying report server WMI provider invalid namespace. I appreciate any suggestions anyone has. I really need to practice this at home because we're going to be using this at work soon. Any suggestions will be greatly appreciated. Thanks, |
|
sunitabeck
Master Smack Fu Yak Hacker
5155 Posts |
Posted - 2011-07-08 : 15:51:10
|
Where are you trying to connect from? Visual Studio? Report Builder? In any case, you may need to use SERVERNAME\SQLEXPRESS as the server name. See here for connection strings for SQL 2008 (including express edition). |
|
|
joe8079
Posting Yak Master
127 Posts |
Posted - 2011-07-08 : 16:23:46
|
hello,the way i'm trying to connect is by going to start - all programs - sql 2008 - configuration tools - reporting services configuration manager. sorry, kind of new to this |
|
|
rchalla
Starting Member
3 Posts |
Posted - 2011-09-21 : 15:57:46
|
I have same problem..Couldnt connect to report server through Configuration Manager...Did you find any solution!!!! |
|
|
|
|
|