Hi

In our server, only reporting service and interation services are running, there is no database engine.

Can we upgrade service pack.?

Thanks

Shashikala

In our server, only reporting service and interation services are running, there is no database engine.

Can we upgrade service pack.?

Technically ,Yes you can do.When you run the setup it will show you option for features present select SSIS and SSRS features and move forward.

Thanks for the reply.

how can I check which service pack is running.

Thanks

Thanks for the reply.

how can I check which service pack is running.

Thanks

Hello,

select serverproperty('productlevel'),
serverproperty('productversion'),
serverproperty('edition')
---
select @@version

For new questions please raise separate thread

To determine the versions, please follow this article:
http://support.microsoft.com/kb/321185

To understand the versions, please review this article:
http://sqlserverbuilds.blogspot.in/