SQLTeam.com | Weblogs | Forums

What do I need to install to set up Web Services?



I'm a fairly new DBA, working for a small company that just made the jump to a medium\large company. I have been asked to set up an XML Connection via web services reporting workflow and I'm wondering what needs to be installed for me to get started. I inherited a bare bones SQL Server. We do not have SSRS, Analysis services, ro IIS, installed. Integrations services is installed but it hasn't been utilized until now. What steps do I need to take to set up web services? I work in an environment that has to comply with bank level security.

Thank you!


that is such a deep subject. have you read the whitepapers and MS documentation on that specific subject? Also do you have a pre prod environment you can try this out in?



Try this site: http://www.databasejournal.com/features/mssql/article.php/3821271/Calling-a-Web-Service-from-within-SQL-Server.htm