Showing posts with label engine. Show all posts
Showing posts with label engine. Show all posts

Friday, February 24, 2012

[HELP] How can I start an Analysis Services service


Hi all,

at Surface Area Configuration in my SQL Server 2005 I noticed that I have Database Engine, Reporting Services and SQL Server Browser services. I want to deploy a cube modelled at SQL Server Business Intelligence Development Studio and I'm getting connection errors.

I checked at Management Studio that I don't have an instance of Analysis Services. Only Database Engine and Reporting Services.

How can I create an instance of Analysis Services.

Does anyone could help me please?

Thanks a lot.

Another way to verify if you have Analysis Services installed or not, is to look in Services for "SQL Server Analysis Services". To install it, re-run the Setup and there is an option for Analysis Services.

Adrian Dumitrascu

Thursday, February 16, 2012

[DBNETLIB] 2147467259(80004005) [Connection Write (Send()),] General Network Error

HI all

I am facing a problem on sql server 7 Desktop Engine with front end VB6 and ADO 2.8 my OS is windows 2000 Professional.

ie. I am doing appendchunk to add image files on SQL Table it works fine for Approximately 130 MB, But i am trying to add 249 MB size file it will be showing these error Message.

[DBNETLIB] 2147467259(80004005) [Connection write(send()),] General Network Error check your network documentation.

I do so many way to correct this problem but it stuck up overthere.

In vb appendchunk is completed and the error when Updated command starts (update command also going a long way then show the above mentioned error.

Any body have any idea or clue just tel me for experiment. and complete my project.

Once again I request you please help me.

Thanks in advance.

Note : it is working with Access Database very fine I am tested it But in Access not allow me to store me lots of images its only allow 2 GB storage totally in a table.

Error code 0x80004005 is a generic error that indicates something failed. Either the client or server broke the connection.

Two things you should try:

1. Attach SQL Profiler to trace the execution to determine if it is the client or server that is terminating the connection.

2. Check the ERRORLOG if there are any problems with the server.