Analysis Services 2000 SP3 or SP3A - how to identify ?

Hi,

Is there a way to identify whether I have Analysis Services 2000 SP3 or SP3A ?

Thank you very much.

You can go to Help/About and Google your version number. ?

Worked for me.

|||Code wise, you can read the registry on the server's LOCAL_MACHINE \ Software\Microsoft\OLAP Server\CurrentVersion and look at the VersionNum and CSDVersionNumber

Analysis Services - Provider cannot be found

I've got a big problem with the Analysis Services.
I have a SQL Server 2000 SP3 and the Analysis Services SP3 running. The SQL Server has no problems.
When I try to browse the Data of any cube, the following error message occurs:
"Provider cannot be found. It may not be properly installed." When I try to browse other cubes after this, the error message "unknown error" occurs.
The databases, on which the cubes are based are both Access2k and SQL Server 2k. The error even appears at the test cubes from Microsoft, so it cannot be simply a problem of the database.

Much thx for your answers.Try to restart the services on the machine.|||That would be an easy solution. I tried it at first. :-)
It didn't change anything.|||Are you trying to browse from WINXP? If so, you'll need to install sp3 for analysis services on the client.|||I could solve the problem. I had an error when installing sp3 for analysis services on the server. I didn't take notice of it. Later I checked the Version number and recognized, that sp3 was not installed. I installed sp3 again and then it works.

greets,
Stefan

Analysis Services

I have a MS SQL Server 2000 SP3 running under MS Server 2000 Standard Edit
SP4 (MDAC 2.8).
I just installed Analysis Services. How do I apply SP3 to this system?
Each time I try to reinstall SP3, I get the message:
"Setup was unable to validate the logged user. Press Retry to enter another
option, or Cancel to exit setup."
After I exit SP3, the SQLSERVER AGENT is stopped even though it was running
when I start the SP3.
Thank you...Ed
> I have a MS SQL Server 2000 SP3 running under MS Server 2000 Standard Edit
> SP4 (MDAC 2.8).
What? Can you explain this again?

> I just installed Analysis Services. How do I apply SP3 to this system?
If you review http://www.microsoft.com/sql/downloads/2000/sp3.asp, you'll
see that you need to download sql2kasp3.exe.
http://www.aspfaq.com/
(Reverse address to reply.)

Analysis Services

I have a MS SQL Server 2000 SP3 running under MS Server 2000 Standard Edit
SP4 (MDAC 2.8).
I just installed Analysis Services. How do I apply SP3 to this system?
Each time I try to reinstall SP3, I get the message:
"Setup was unable to validate the logged user. Press Retry to enter another
option, or Cancel to exit setup."
After I exit SP3, the SQLSERVER AGENT is stopped even though it was running
when I start the SP3.
Thank you...Ed> I have a MS SQL Server 2000 SP3 running under MS Server 2000 Standard Edit
> SP4 (MDAC 2.8).
What? Can you explain this again?
> I just installed Analysis Services. How do I apply SP3 to this system?
If you review http://www.microsoft.com/sql/downloads/2000/sp3.asp, you'll
see that you need to download sql2kasp3.exe.
--
http://www.aspfaq.com/
(Reverse address to reply.)

Analysis Service SP3

Where to download SQL Server 2000 Analysis Service SP3?
Does it include inside SQL Server 2000 SP3?
Thanks.
-Where to download SQL Server 2000 Analysis Service SP3?
http://www.microsoft.com/sql/downloads/2000/sp3.asp
-Does it include inside SQL Server 2000 SP3?
No you have to install it seperately. Sql2kasp3.exe only contains analysis
issues.
a.. Sql2ksp3.exe. Updates for database components.
a.. Sql2kasp3.exe. Updates for Analysis Services components.
a.. Sql2kdesksp3.exe. Updates for Microsoft SQL Server 2000 Desktop Engine
(MSDE 2000).
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
"Joe" <Joe@.discussions.microsoft.com> schrieb im Newsbeitrag
news:49C8FD2F-CBC4-48B6-BDC2-F2BC9C49071D@.microsoft.com...
> Where to download SQL Server 2000 Analysis Service SP3?
> Does it include inside SQL Server 2000 SP3?
> Thanks.

Analysis Service SP3

Where to download SQL Server 2000 Analysis Service SP3?
Does it include inside SQL Server 2000 SP3?
Thanks.-Where to download SQL Server 2000 Analysis Service SP3?
http://www.microsoft.com/sql/downloads/2000/sp3.asp
-Does it include inside SQL Server 2000 SP3?
No you have to install it seperately. Sql2kasp3.exe only contains analysis
issues.
a.. Sql2ksp3.exe. Updates for database components.
a.. Sql2kasp3.exe. Updates for Analysis Services components.
a.. Sql2kdesksp3.exe. Updates for Microsoft SQL Server 2000 Desktop Engine
(MSDE 2000).
HTH, Jens Suessmeyer.
--
http://www.sqlserver2005.de
--
"Joe" <Joe@.discussions.microsoft.com> schrieb im Newsbeitrag
news:49C8FD2F-CBC4-48B6-BDC2-F2BC9C49071D@.microsoft.com...
> Where to download SQL Server 2000 Analysis Service SP3?
> Does it include inside SQL Server 2000 SP3?
> Thanks.sql

Analysis Service SP3

Where to download SQL Server 2000 Analysis Service SP3?
Does it include inside SQL Server 2000 SP3?
Thanks.-Where to download SQL Server 2000 Analysis Service SP3?
http://www.microsoft.com/sql/downloads/2000/sp3.asp
-Does it include inside SQL Server 2000 SP3?
No you have to install it seperately. Sql2kasp3.exe only contains analysis
issues.
a.. Sql2ksp3.exe. Updates for database components.
a.. Sql2kasp3.exe. Updates for Analysis Services components.
a.. Sql2kdesksp3.exe. Updates for Microsoft SQL Server 2000 Desktop Engine
(MSDE 2000).
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
--
"Joe" <Joe@.discussions.microsoft.com> schrieb im Newsbeitrag
news:49C8FD2F-CBC4-48B6-BDC2-F2BC9C49071D@.microsoft.com...
> Where to download SQL Server 2000 Analysis Service SP3?
> Does it include inside SQL Server 2000 SP3?
> Thanks.

Analysis Service Connection Pooling

In SQL Server documentation it is mentioned that the SP3 Code sample contains
the Analysis Service Connection Pooling sample. Please help me in locating
the code sample.
Thanks in advance.
Manoj
http://msdn.microsoft.com/library/de...onnpooling.asp
Dave Wickert [MSFT]
dwickert@.online.microsoft.com
Program Manager
BI SystemsTeam
SQL BI Product Unit (Analysis Services)
This posting is provided "AS IS" with no warranties, and confers no rights.
"Manoj" <Manoj@.discussions.microsoft.com> wrote in message
news:AF17E419-ED8D-4E97-AA3D-76A06BCFD465@.microsoft.com...
> In SQL Server documentation it is mentioned that the SP3 Code sample
contains
> the Analysis Service Connection Pooling sample. Please help me in locating
> the code sample.
> Thanks in advance.
> Manoj

am I backing up free space

sql2k sp3
All ideas are welcomed. In my db;
dbfile1 used 5796.94mb, free 295.56mb
dbfile2 used 4212.52mb, free 75.62mb
log used 75.14mb, free 4401.1mb
My backup is 13.2 gigs. By my calulations it should be 10.
How can it be?
TIA, Chrisi'm pretty sure you are backing up the free space. try restoring one
of the dbs and you can see then how the files are restored. do you
need such a large transaction log?
think you would be better shrinking it and letting it grow again.
advice from - http://www.sql-server-performance.com/misc_tips.asp
According to Microsoft, the way to shrink a log file is to use DBCC
SHRINKFILE. This process is painfully slow and inefficient. Even after
running the procedure numerous times, you may not get much free space.
Here's another way to shrink your logs that is guaranteed to work
every time. First, back up the database and then detach (sp_detach_db)
it (you will have to bring the database down to do this). Next,
delete the log file and then re-attach (sp_attach_db) the database,
not providing the old log file location from within the sp_attach_db
command. This will create a new log file with the old log file name in
the old location with default size i.e. 512 KB.
To make sure there is no problem during the operation, the old log
file can be renamed and kept until the database is reattached
successfully. This provides a backup plan if for some reason SQL
server fails to attach the database without the old log file.
This trick won't work if the database has more than one log file, but
if you need to, you can alter the database so that it only has a
single log file, while will allow you to perform the above steps.
After carrying out the detach and attach database activity, the
database can be again altered to add more log files. [7.0, 2000] Added
2-24-2003 Contributed by Gaurav Bindlish
hope this helps,
rh
"chris" <anonymous@.discussions.microsoft.com> wrote in message news:<21fb01c3e081$13570960$a401280a@.phx.gbl>...
> sql2k sp3
> All ideas are welcomed. In my db;
> dbfile1 used 5796.94mb, free 295.56mb
> dbfile2 used 4212.52mb, free 75.62mb
> log used 75.14mb, free 4401.1mb
> My backup is 13.2 gigs. By my calulations it should be 10.
> How can it be?
> TIA, Chris

Always write to Windows event log" doesn't work in MS SQL Server 2

Hi,
I have an MS SQL Server 2000 SP3, MS Windows 2000 SP4 machine. When I set
the "Always write to Windows event log" option for the 14150 (replication
agent success) error and start a snapshot agent, a message is logged in SQL
Server errorlog but not in Windows application log. Why?
-- Thanks, Oskar.
Sorry this wasn't a valid question. The error actually is logged, only it is
logged as an informational message, not error message. I was mislead by that.
--Thanks, Oskar.
"Oskar" wrote:

> Hi,
> I have an MS SQL Server 2000 SP3, MS Windows 2000 SP4 machine. When I set
> the "Always write to Windows event log" option for the 14150 (replication
> agent success) error and start a snapshot agent, a message is logged in SQL
> Server errorlog but not in Windows application log. Why?
> -- Thanks, Oskar.
>

Always write to Windows event log" doesn't work in MS SQL Server 2

Hi,
I have an MS SQL Server 2000 SP3, MS Windows 2000 SP4 machine. When I set
the "Always write to Windows event log" option for the 14150 (replication
agent success) error and start a snapshot agent, a message is logged in SQL
Server errorlog but not in Windows application log. Why?
-- Thanks, Oskar.Sorry this wasn't a valid question. The error actually is logged, only it is
logged as an informational message, not error message. I was mislead by that
.
--Thanks, Oskar.
"Oskar" wrote:

> Hi,
> I have an MS SQL Server 2000 SP3, MS Windows 2000 SP4 machine. When I set
> the "Always write to Windows event log" option for the 14150 (replication
> agent success) error and start a snapshot agent, a message is logged in SQ
L
> Server errorlog but not in Windows application log. Why?
> -- Thanks, Oskar.
>

Always write to Windows event log" doesn't work in MS SQL Server 2

Hi,
I have an MS SQL Server 2000 SP3, MS Windows 2000 SP4 machine. When I set
the "Always write to Windows event log" option for the 14150 (replication
agent success) error and start a snapshot agent, a message is logged in SQL
Server errorlog but not in Windows application log. Why?
-- Thanks, Oskar.Sorry this wasn't a valid question. The error actually is logged, only it is
logged as an informational message, not error message. I was mislead by that.
--Thanks, Oskar.
"Oskar" wrote:
> Hi,
> I have an MS SQL Server 2000 SP3, MS Windows 2000 SP4 machine. When I set
> the "Always write to Windows event log" option for the 14150 (replication
> agent success) error and start a snapshot agent, a message is logged in SQL
> Server errorlog but not in Windows application log. Why?
> -- Thanks, Oskar.
>

Always SQL Server 8.x from Management Studio

Greetings,
I originally have had SQL 2k SP3 installed before installing Visual Studio
2005 and SQL Server 2005. Anyway, that was a while ago. Now, for the first
time in a blue moon I have the need to be doing some SQL Server 2005 stuff
on my machine and the only server that SQL Server Management Studio finds or
connects to on this box is version 8.0.760. I can swear I had set up a 2k5
database in the past and did some work with it. I have installed SQL 2k5
Developer Edition.
My main question is, how do I connect to the 2k5 database, and if need be,
how do I add one so I can connect to it? This should be simple but it seems
not.
Thanks,
ShawnProbably you still have your SQL Server 2000 instance installed, and if you
worked with a SQL Server 2005 instance before on the same computer, most
likely this is a named instance.
Run SQL Server 2000 Service Manager and click the Server list to see the
installed instances (I can even see SQL Server 2005 instances there).
Run SQL Server 2005 Configuration Manager and look into SQL Server 2005
Services.
Hope this helps,
Ben Nevarez, MCDBA, OCP
Database Administrator
"Shawn B." wrote:

> Greetings,
> I originally have had SQL 2k SP3 installed before installing Visual Studio
> 2005 and SQL Server 2005. Anyway, that was a while ago. Now, for the fir
st
> time in a blue moon I have the need to be doing some SQL Server 2005 stuff
> on my machine and the only server that SQL Server Management Studio finds
or
> connects to on this box is version 8.0.760. I can swear I had set up a 2k
5
> database in the past and did some work with it. I have installed SQL 2k5
> Developer Edition.
> My main question is, how do I connect to the 2k5 database, and if need be,
> how do I add one so I can connect to it? This should be simple but it see
ms
> not.
>
> Thanks,
> Shawn
>
>|||> Probably you still have your SQL Server 2000 instance installed, and if
> you
> worked with a SQL Server 2005 instance before on the same computer, most
> likely this is a named instance.
> Run SQL Server 2000 Service Manager and click the Server list to see the
> installed instances (I can even see SQL Server 2005 instances there).
> Run SQL Server 2005 Configuration Manager and look into SQL Server 2005
> Services.
>
It does not show any SQL Server 2005 instances. Only the 2000 instance on
this machine and the 2000 instance on another machien. If it isn't showing
any 2005 instances running, how do I start it up? When I run SQL Server
2005 config man. everything seems as if 2005 is okay.
Thanks,
Shawn|||Try SQL Server Configuration Manager and select SQL Server 2005 Services.
Then look for the lines showing 'Service Type' as 'SQL Server'. There you
will see the instance name on the 'Name' column and you could check 'State'
to see if the instance is running or stopped.
Ben Nevarez, MCDBA, OCP
Database Administrator
"Shawn B." wrote:

> It does not show any SQL Server 2005 instances. Only the 2000 instance on
> this machine and the 2000 instance on another machien. If it isn't showin
g
> any 2005 instances running, how do I start it up? When I run SQL Server
> 2005 config man. everything seems as if 2005 is okay.
>
> Thanks,
> Shawn
>
>|||> Try SQL Server Configuration Manager and select SQL Server 2005 Services.
> Then look for the lines showing 'Service Type' as 'SQL Server'. There you
> will see the instance name on the 'Name' column and you could check
> 'State'
> to see if the instance is running or stopped.
Well, there's my problem... I do not have "SQL Server" but I have a crap
load of others. How do I get the "SQL Server" service to appear? Should I
reinstall sql 2k5?
Thanks,
Shawn|||If 'SQL Server' is not listed on the 'Service Type' column then you do not
have an instance of SQL Server 2005. You could install a new one.
Ben Nevarez, MCDBA, OCP
Database Administrator
"Shawn B." wrote:

> Well, there's my problem... I do not have "SQL Server" but I have a crap
> load of others. How do I get the "SQL Server" service to appear? Should
I
> reinstall sql 2k5?
>
> Thanks,
> Shawn
>
>|||> If 'SQL Server' is not listed on the 'Service Type' column then you do not
> have an instance of SQL Server 2005. You could install a new one.
How? Do I pop in the SQL Server 2005 (Server) disk? (as opposed to the
tools disk?). I've been spending hours and endless Google searches to
answer that very question and the answer is not clear (unless I'm using SQL
Express, which I'm not).
Thanks,
Shawn|||Hi Shawn,
Yes, install a new instance from your SQL Server 2005 media (in my case it
is SQL Server 2005 X Edition Disk 1'. Run setup and make sure you select 'SQ
L
Server Database Services' on the 'Components to Install' window.
If you already have a SQL Server 2000 default instance you can install a new
named instance for SQL Server 2005.
Installing SQL Server 2005 Service Pack 1 is a good idea too.
Hope this helps,
Ben Nevarez, MCDBA, OCP
Database Administrator
"Shawn B." wrote:

> How? Do I pop in the SQL Server 2005 (Server) disk? (as opposed to the
> tools disk?). I've been spending hours and endless Google searches to
> answer that very question and the answer is not clear (unless I'm using SQ
L
> Express, which I'm not).
>
> Thanks,
> Shawn
>
>|||> Yes, install a new instance from your SQL Server 2005 media (in my case it
> is SQL Server 2005 X Edition Disk 1'. Run setup and make sure you select
> 'SQL
> Server Database Services' on the 'Components to Install' window.
> If you already have a SQL Server 2000 default instance you can install a
> new
> named instance for SQL Server 2005.
> Installing SQL Server 2005 Service Pack 1 is a good idea too.
Done. That's all it was.
Thanks,
Shawn

Always SQL Server 8.x from Management Studio

Greetings,
I originally have had SQL 2k SP3 installed before installing Visual Studio
2005 and SQL Server 2005. Anyway, that was a while ago. Now, for the first
time in a blue moon I have the need to be doing some SQL Server 2005 stuff
on my machine and the only server that SQL Server Management Studio finds or
connects to on this box is version 8.0.760. I can swear I had set up a 2k5
database in the past and did some work with it. I have installed SQL 2k5
Developer Edition.
My main question is, how do I connect to the 2k5 database, and if need be,
how do I add one so I can connect to it? This should be simple but it seems
not.
Thanks,
ShawnProbably you still have your SQL Server 2000 instance installed, and if you
worked with a SQL Server 2005 instance before on the same computer, most
likely this is a named instance.
Run SQL Server 2000 Service Manager and click the Server list to see the
installed instances (I can even see SQL Server 2005 instances there).
Run SQL Server 2005 Configuration Manager and look into SQL Server 2005
Services.
Hope this helps,
Ben Nevarez, MCDBA, OCP
Database Administrator
"Shawn B." wrote:
> Greetings,
> I originally have had SQL 2k SP3 installed before installing Visual Studio
> 2005 and SQL Server 2005. Anyway, that was a while ago. Now, for the first
> time in a blue moon I have the need to be doing some SQL Server 2005 stuff
> on my machine and the only server that SQL Server Management Studio finds or
> connects to on this box is version 8.0.760. I can swear I had set up a 2k5
> database in the past and did some work with it. I have installed SQL 2k5
> Developer Edition.
> My main question is, how do I connect to the 2k5 database, and if need be,
> how do I add one so I can connect to it? This should be simple but it seems
> not.
>
> Thanks,
> Shawn
>
>|||> Probably you still have your SQL Server 2000 instance installed, and if
> you
> worked with a SQL Server 2005 instance before on the same computer, most
> likely this is a named instance.
> Run SQL Server 2000 Service Manager and click the Server list to see the
> installed instances (I can even see SQL Server 2005 instances there).
> Run SQL Server 2005 Configuration Manager and look into SQL Server 2005
> Services.
>
It does not show any SQL Server 2005 instances. Only the 2000 instance on
this machine and the 2000 instance on another machien. If it isn't showing
any 2005 instances running, how do I start it up? When I run SQL Server
2005 config man. everything seems as if 2005 is okay.
Thanks,
Shawn|||Try SQL Server Configuration Manager and select SQL Server 2005 Services.
Then look for the lines showing 'Service Type' as 'SQL Server'. There you
will see the instance name on the 'Name' column and you could check 'State'
to see if the instance is running or stopped.
Ben Nevarez, MCDBA, OCP
Database Administrator
"Shawn B." wrote:
> > Probably you still have your SQL Server 2000 instance installed, and if
> > you
> > worked with a SQL Server 2005 instance before on the same computer, most
> > likely this is a named instance.
> >
> > Run SQL Server 2000 Service Manager and click the Server list to see the
> > installed instances (I can even see SQL Server 2005 instances there).
> >
> > Run SQL Server 2005 Configuration Manager and look into SQL Server 2005
> > Services.
> >
> It does not show any SQL Server 2005 instances. Only the 2000 instance on
> this machine and the 2000 instance on another machien. If it isn't showing
> any 2005 instances running, how do I start it up? When I run SQL Server
> 2005 config man. everything seems as if 2005 is okay.
>
> Thanks,
> Shawn
>
>|||> Try SQL Server Configuration Manager and select SQL Server 2005 Services.
> Then look for the lines showing 'Service Type' as 'SQL Server'. There you
> will see the instance name on the 'Name' column and you could check
> 'State'
> to see if the instance is running or stopped.
Well, there's my problem... I do not have "SQL Server" but I have a crap
load of others. How do I get the "SQL Server" service to appear? Should I
reinstall sql 2k5?
Thanks,
Shawn|||If 'SQL Server' is not listed on the 'Service Type' column then you do not
have an instance of SQL Server 2005. You could install a new one.
Ben Nevarez, MCDBA, OCP
Database Administrator
"Shawn B." wrote:
> > Try SQL Server Configuration Manager and select SQL Server 2005 Services.
> > Then look for the lines showing 'Service Type' as 'SQL Server'. There you
> > will see the instance name on the 'Name' column and you could check
> > 'State'
> > to see if the instance is running or stopped.
> Well, there's my problem... I do not have "SQL Server" but I have a crap
> load of others. How do I get the "SQL Server" service to appear? Should I
> reinstall sql 2k5?
>
> Thanks,
> Shawn
>
>|||> If 'SQL Server' is not listed on the 'Service Type' column then you do not
> have an instance of SQL Server 2005. You could install a new one.
How? Do I pop in the SQL Server 2005 (Server) disk? (as opposed to the
tools disk?). I've been spending hours and endless Google searches to
answer that very question and the answer is not clear (unless I'm using SQL
Express, which I'm not).
Thanks,
Shawn|||Hi Shawn,
Yes, install a new instance from your SQL Server 2005 media (in my case it
is SQL Server 2005 X Edition Disk 1'. Run setup and make sure you select 'SQL
Server Database Services' on the 'Components to Install' window.
If you already have a SQL Server 2000 default instance you can install a new
named instance for SQL Server 2005.
Installing SQL Server 2005 Service Pack 1 is a good idea too.
Hope this helps,
Ben Nevarez, MCDBA, OCP
Database Administrator
"Shawn B." wrote:
> > If 'SQL Server' is not listed on the 'Service Type' column then you do not
> > have an instance of SQL Server 2005. You could install a new one.
> How? Do I pop in the SQL Server 2005 (Server) disk? (as opposed to the
> tools disk?). I've been spending hours and endless Google searches to
> answer that very question and the answer is not clear (unless I'm using SQL
> Express, which I'm not).
>
> Thanks,
> Shawn
>
>|||> Yes, install a new instance from your SQL Server 2005 media (in my case it
> is SQL Server 2005 X Edition Disk 1'. Run setup and make sure you select
> 'SQL
> Server Database Services' on the 'Components to Install' window.
> If you already have a SQL Server 2000 default instance you can install a
> new
> named instance for SQL Server 2005.
> Installing SQL Server 2005 Service Pack 1 is a good idea too.
Done. That's all it was.
Thanks,
Shawn