sorry I shud have been more clear , using ssms connect to reporting services using the account you are facing issues with. You may also want to check how your...

Considering your getting a random number after each process, have you check what the processing option is?

Any filters in the DSV would make a difference.also have you checked the uniqueness...

Have u looked in the log file

C:\Program Files\Microsoft SQL Server\MSAS10_50.MSSQLSERVER\OLAP\Log

Are u able to connect using that account from SSMS directly ? What kind of authentication are you using?

chances are the cut off is happening at the front end where the application textbox char length is set to a lower value.

At what length is it cutting off at...

Considering your new to SQL server it might be better for your to revisit ACID principles , transactions and isolation levels. Books online (F1 help on sql server is a...

looks like someone has set this value based on the sizing requirement for the tempdb utilization. Reducing this value could cause a performance issue. Do you know for sure this...

Did u have sql server express edition installed previously ?

SSMS is a shared component , it comes in 2 flavors basic and advanced which one are u trying to install...

Try the below link

http://blogs.msdn.com/b/psssql/archive/2010/08/03/how-it-works-error-18056-the-client-was-unable-to-reuse-a-session-with-spid-which-had-been-reset-for-connection-pooling.aspx

Ur most likely facing a memory issue , check your working set as well as the target memory settings.

If you are confident u have plenty of memory...

Look at the below link

http://www.microsoft.com/products/ee/transform.aspx?ProdName=Microsoft+SQL+Server&EvtSrc=setup.rll&EvtID=50000&ProdVer=10.0.1600.22

you need to include the columns mentioned in the key column for the above execution plan into the non clsutered index for the inner table. You have the right...

try disabling the anit virus , u might have window file protection enabled. if this doesnt fix the issue then probably the bootstrap file is corrupt . Try running the...

while i dont recommend MS PaaS to any of my clients esp those with critical projects. I think a lot of small companies I work with are benefiting from Iaas...

have u tried to right click the setup.exe file and run as admin.

Are u installing on window 7 , do u have a firewall or antivirus enabled ?

which version of sql server do u have currently ?

Is mirroring working now ?

Have you considered log shipping?