SQLTeam.com | Weblogs | Forums

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


#1

Hello,

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!
Alan


#2

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?

https://technet.microsoft.com/en-us/library/aa964129(v=sql.90).aspx


#3

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