way to see what server a URL is on

Hi Team mates,

I need some urgent assistance with regards to the following problem.

I have a client running a query in Visual Studio and gets the following error " An error occurred when saving changes to dataset.rsd.Verify that you have permission to save changes to this location
Im01.pngThis is I dont know where the location is pointed to I have the URL and have logged onto the server, which is an SQL server but there is no IIS Webiste for http://servername/ReportServer
Im002.pngPlease can you assist me where I am going wrong.
Jason LaskeyICT Systems and Network EngineerAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Kash2nd Line EngineerCommented:
you may need to look into ODBC data sources on the computer in question which may give you a clue where the database resides.
0
Jason LaskeyICT Systems and Network EngineerAuthor Commented:
I know where the SQL server is, and I have placed the user into the reporting services for this but it still not working, as mentioned I suspect its a share on the server, that why I would like to access the IIS site for this and then see if somewhere it displays this, hence my question how would I be able to see what IIS server this site would be on
0
Rainer JeschorCommented:
Hi,
SQL Server Reporting Server / Services is not using IIS - instead it has its own Windows Service which is running its own web server utilizing http.sys (as IIS is doing).
Report Server stores all its contents (data sources, reports ...) inside its report server databases.
If you have enabled the Report Manager web application, you can configure (e.g. permissions) through this web site (which is also hosted by the service).
More details:
https://msdn.microsoft.com/en-us/library/cc281384(v=sql.110).aspx

BTW, which SQL Server version?

HTH
Rainer
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

Kash2nd Line EngineerCommented:
apologies didn't see this before.
forget IIS.
SQL runs its own services.
If the services are running and you have ODBC configured correctly then it should work.
Are you able to query the DB at all?
0
Jason LaskeyICT Systems and Network EngineerAuthor Commented:
My Colleague managed to fix this problem as it was a link pointing to a SharePoint document which needed to allow permissions
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Jason LaskeyICT Systems and Network EngineerAuthor Commented:
Reason is this was A SharePoint share that SQL was pointing to to save the reports, which never had the necessary permissions
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.