sql 2005 reporting services 2

[19972003]

Do I have to have domain setup in order to have the client(report serverice running to connect to the sql 2005 report server database in the backend? Is there way I can set it up if the user is in the workgrop, will it work?

 

[onpnt]

use sql server authentication and not windows. you'll have to reference the server by IP probably though. I've nvr played with workgroups so I'm not 100% sure on resolving names

_{____________ signature below ______________
I am Tedward Keyboardhands!!!
You are a amateur developer until you realize all your code sucks.
Jeff Atwood}

 

[19972003]

It was set to sql authen and windows authentication

 

[onpnt]

ok. so make your shared connection connect via sql server authentication



_{____________ signature below ______________
I am Tedward Keyboardhands!!!
You are a amateur developer until you realize all your code sucks.
Jeff Atwood}

 

[19972003]

can you give me the steps?

 

[19972003]

Is there a way to view the report on the client machine since the report is on the sql server? I don't want to have port 80 open on the sql server. What tools can I use.

Many thanks,

 

[onpnt]

Are you serious? Maybe I just didn't read that correctly. You can't see the reports from the clients? Huh????

_{____________ signature below ______________
I am Tedward Keyboardhands!!!
You are a amateur developer until you realize all your code sucks.
Jeff Atwood}

 

[philhege]

http://TheSQLServer/NeedsPort80Open/ToServeSSRSReports

Should be in the first page of the manual.

 

[gmmastros]

Mr. philhege,

I've been following this thread very closely because I also want to use reporting services, but without any ports open. I got [!]very[/!] excited when I saw your post. Unfortunately, that link doesn't work.

Do you have another suitable link that I can use?



-George

"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom

 

[19972003]

Can you give me the link again? Is this doable?

 

[ca8msm]

Phil, that link just shows a holding page so maybe it isnt doable. Did I type it in wrong or am I using the wrong manual?


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

Mark,
[URL unfurl="true"]http://aspnetlibrary.com[/url]
[URL unfurl="true"]http://mdssolutions.co.uk[/url] - Delivering professional ASP.NET solutions

 

[onpnt]

hold on everyone. I'm a genius! I got the link to work

http://TheSQLServer:80/NeedsPort80Open/ToServeSSRSReports

_{____________ signature below ______________
I am Tedward Keyboardhands!!!
You are a amateur developer until you realize all your code sucks.
Jeff Atwood}

 

[19972003]

Server not found, the link didn't work.

 

[johnwm]

Woohoo! That's so easy! I just had to actually read what you have written! Thanks very much guys!

___________________________________________________________
If you want the best response to a question, please check out FAQ222-2244 first.
'If we're supposed to work in Hex, why have we only got A fingers?'
Drive a Steam Roller
Steam Engine Prints

 

[damber]

maybe this will help:

http://you.canlead.a:80/hors/e/to/wat/er/etc..

A smile is worth a thousand kind words. So smile, it's easy!

 

[philhege]

Damber wins.

 

[19972003]

The link is a dead link, it doesn't work.

 

[damber]

Sorry, I'll make it a bit clearer...
[URL unfurl="true"]http://really.obvio.us/this/time[/url]

This time the link should work and give you some results.... read through them carefully and then come back to this thread.

Does that make it any clearer ?



A smile is worth a thousand kind words. So smile, it's easy!

 

[onpnt]

_{____________ signature below ______________
I am Tedward Keyboardhands!!!
You are a amateur developer until you realize all your code sucks.
Jeff Atwood}

 

[19972003]

wasn't reading thoroughly. got it now. Thanks