Regarding install analysis service

Hi Guys,
I am new in analysis service. I just installed analysis service in my
personal computer that has a sql server enterprise installed. When I opened
analysis manager and try to open the server in the left pane, I got error
that no register sql server or it is not in the olap group(roughly, I cannot
remember clearly), then server icon because red(closed). it seems like I
couldn't connect to database server. But it is same server and of cause I
have already register this server. What is wrong with this? Thanks.
it would help if 'clearly' and not 'roughly' took the time to post the full
error and in return we will 'clearly' answer your question!
It sounds to me the user account you are logged on as isn't in the OlapAdmin
group. Add your logged on account to this group and it should do the trick.
Immy
"Iter" <Iter@.discussions.microsoft.com> wrote in message
news:75B81FA5-1CEC-4815-A597-95BBCA829BDB@.microsoft.com...
> Hi Guys,
> I am new in analysis service. I just installed analysis service in my
> personal computer that has a sql server enterprise installed. When I
> opened
> analysis manager and try to open the server in the left pane, I got error
> that no register sql server or it is not in the olap group(roughly, I
> cannot
> remember clearly), then server icon because red(closed). it seems like I
> couldn't connect to database server. But it is same server and of cause I
> have already register this server. What is wrong with this? Thanks.
>
|||You will get this behavior if you are trying to run an earlier version of
Analysis Services 2000 on Win XP Pro. If this is the case, you need to
upgrade both SQL Server 2000 and As 2000 to SP4. Search the MSKB for
details.
John G.
"Iter" <Iter@.discussions.microsoft.com> wrote in message
news:75B81FA5-1CEC-4815-A597-95BBCA829BDB@.microsoft.com...
> Hi Guys,
> I am new in analysis service. I just installed analysis service in my
> personal computer that has a sql server enterprise installed. When I
> opened
> analysis manager and try to open the server in the left pane, I got error
> that no register sql server or it is not in the olap group(roughly, I
> cannot
> remember clearly), then server icon because red(closed). it seems like I
> couldn't connect to database server. But it is same server and of cause I
> have already register this server. What is wrong with this? Thanks.
>

Reg SQL Svr Enterprise Edtn 2005 Win32 English MVL 1 Proc

Hi,

I have purchased

SQL Svr Enterprise Edtn 2005 Win32 English MVL 1 Proc does it mean that its 32 bit software? and its 1 processor based license ?

Also will it run on HP DL580 G4/(1) Dual-Core 64-bit Intel? Xeon? 7110M Processor (2.60 GHz, 95 Watts, 800MHz FSB) successfully ?

Pls reply urgently

Thanks

Yes, that is a 32 bit version, evidenced by the designation [ Win32 ].

Yes, it is single processor, evidenced by the designation [ 1 Proc ].

It will run on 32 or 64 bit Windows Server.

Referenced Memory Problem with Enterprise Manager

When I attempt to attach a database using the wizard in the manager, I get
the following error when I click on the button to select MDF file of
database to attach:
The instruction at "0x41d53c0a" referenced memory at "0xffffffff". The
memory could not be read.
I've reinstalled SQL SP3a and Windows 2003 patches. Is this error a result
of a memory hardware problem or a conflict with another installed
application?
How can I resolve the problem since I am unable to use the manager for this
function?
thanks.Could me several issues. Could be a bad SQL Server binary. Mismatched
MDAC. Bad MMC build. Or, your worst fears, the .MDF file may be locked or
corrupt.
I'd try to attach to another SS server and/or use Query Analyzer and
sp_attach_db to narrow down if it is the .MDF file the local SS installation
or just the SQL EM tool.
Sincerely,
Anthony Thomas
"Dan Slaby" <dslaby3@.comcast.net> wrote in message
news:eq6sX9WAFHA.2180@.TK2MSFTNGP10.phx.gbl...
When I attempt to attach a database using the wizard in the manager, I get
the following error when I click on the button to select MDF file of
database to attach:
The instruction at "0x41d53c0a" referenced memory at "0xffffffff". The
memory could not be read.
I've reinstalled SQL SP3a and Windows 2003 patches. Is this error a result
of a memory hardware problem or a conflict with another installed
application?
How can I resolve the problem since I am unable to use the manager for this
function?
thanks.|||I resolved the problem by making another install of SP3a.
"Dan Slaby" <dslaby3@.comcast.net> wrote in message
news:eq6sX9WAFHA.2180@.TK2MSFTNGP10.phx.gbl...
> When I attempt to attach a database using the wizard in the manager, I get
> the following error when I click on the button to select MDF file of
> database to attach:
> The instruction at "0x41d53c0a" referenced memory at "0xffffffff". The
> memory could not be read.
> I've reinstalled SQL SP3a and Windows 2003 patches. Is this error a result
> of a memory hardware problem or a conflict with another installed
> application?
> How can I resolve the problem since I am unable to use the manager for
> this function?
> thanks.
>
>

Reduceing the filesize of datafiles

Hi,
in the enterprise manger I want to reduce the datafiles of a database. When
I do this the enterprise manager says,
that there are 80% (more then 17GB), that can be freed, but after the cleani
ng process the datafiles would not be
shorter then before.
How can I clean the freeable memory of the datafiles ?
Is there an other way that works better ?
Best regards
Axel LanserAlex
Look at DBCC SHRINKDATABASE or DBCC SHRINKFILE in the BOL.
"Axel Lanser" <anonymous@.discussions.microsoft.com> wrote in message
news:EDD50E53-D546-4F24-90EB-674C0172361C@.microsoft.com...
> Hi,
> in the enterprise manger I want to reduce the datafiles of a database.
When I do this the enterprise manager says,
> that there are 80% (more then 17GB), that can be freed, but after the
cleaning process the datafiles would not be
> shorter then before.
> How can I clean the freeable memory of the datafiles ?
> Is there an other way that works better ?
> Best regards
> Axel Lanser|||Hi,
Did you meant "How to reduce the datafile size", If yes then execute the
below command in query analyzer,
DBCC SHRINKFILE('logicalfilename','truncateon
ly')
If it is TX log file, perform a 'Backup LOG' before shrinking the file.
Refer the below link for more info.
http://www.sql-server-performance.c...p?TOPIC_ID=3140
Thanks
Hari
"Axel Lanser" <anonymous@.discussions.microsoft.com> wrote in message
news:EDD50E53-D546-4F24-90EB-674C0172361C@.microsoft.com...
> Hi,
> in the enterprise manger I want to reduce the datafiles of a database.
When I do this the enterprise manager says,
> that there are 80% (more then 17GB), that can be freed, but after the
cleaning process the datafiles would not be
> shorter then before.
> How can I clean the freeable memory of the datafiles ?
> Is there an other way that works better ?
> Best regards
> Axel Lanser|||Hi,
I have made a 'backup log' before I start the dbcc shrinkfile for the Log-Fi
le, but the Log-File wouldn't be reduce.
I think all active transaction must be proccessed, because the data base is
in single user mode and I was permanently
conected with this database and without any new transaction on this database
for two days.
Therfore I don't know why the Logfile is not reduceable.
Can you help me ?
What can I do ?
Thanks
Axel|||http://www.karaszi.com/sqlserver/info_dont_shrink.asp
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
"Axel Lanser" <anonymous@.discussions.microsoft.com> wrote in message
news:B15B5790-C11F-4D51-8D0E-64FA48EB0B48@.microsoft.com...
> Hi,
> I have made a 'backup log' before I start the dbcc shrinkfile for the
Log-File, but the Log-File wouldn't be reduce.
> I think all active transaction must be proccessed, because the data base
is in single user mode and I was permanently
> conected with this database and without any new transaction on this
database for two days.
> Therfore I don't know why the Logfile is not reduceable.
> Can you help me ?
> What can I do ?
> Thanks
> Axel

Reduce the Size of SQL Log File

We have MS SQL 2000 Enterprise Edition, running on Windows 2000 Server. Is
it a good idea to reduce the size of the SQL Log File? If it is, do I need
to make sure no one is using the database while I am reducing the size of
the log file? Is it possible to setup these commands in a batch file
instead of running them under Query Analyzer? Thanks.
BACKUP LOG Smart_DATA WITH TRUNCATE_ONLY
GO
DBCC SHRINKDATABASE (Smart_DATA, TRUNCATEONLY)
What recovery model is the database in? Also see
http://www.karaszi.com/SQLServer/info_dont_shrink.asp
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Diane Walker" <ett9300@.yahoo.com> wrote in message news:u90cVi%23vFHA.1256@.TK2MSFTNGP09.phx.gbl...
> We have MS SQL 2000 Enterprise Edition, running on Windows 2000 Server. Is it a good idea to
> reduce the size of the SQL Log File? If it is, do I need to make sure no one is using the
> database while I am reducing the size of the log file? Is it possible to setup these commands in
> a batch file instead of running them under Query Analyzer? Thanks.
> BACKUP LOG Smart_DATA WITH TRUNCATE_ONLY
> GO
> DBCC SHRINKDATABASE (Smart_DATA, TRUNCATEONLY)
>
>
>
|||"while I am reducing the size of the log file?"
-No you neednt, even that would speed up the task. if you have any
maintainance window, do it within this.
"Is it possible to setup these commands in a batch file instead of
running them under Query Analyzer ?"
-Yes of course, put the statements in a job (step) and execute it here.
HTH, Jens Suessmeyer.
|||Thank you very much.
"Jens" <Jens@.sqlserver2005.de> wrote in message
news:1127458411.014481.253870@.g49g2000cwa.googlegr oups.com...
> "while I am reducing the size of the log file?"
> -No you neednt, even that would speed up the task. if you have any
> maintainance window, do it within this.
> "Is it possible to setup these commands in a batch file instead of
> running them under Query Analyzer ?"
> -Yes of course, put the statements in a job (step) and execute it here.
> HTH, Jens Suessmeyer.
>

Reduce the Size of SQL Log File

We have MS SQL 2000 Enterprise Edition, running on Windows 2000 Server. Is
it a good idea to reduce the size of the SQL Log File? If it is, do I need
to make sure no one is using the database while I am reducing the size of
the log file? Is it possible to setup these commands in a batch file
instead of running them under Query Analyzer? Thanks.
BACKUP LOG Smart_DATA WITH TRUNCATE_ONLY
GO
DBCC SHRINKDATABASE (Smart_DATA, TRUNCATEONLY)What recovery model is the database in? Also see
http://www.karaszi.com/SQLServer/info_dont_shrink.asp
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Diane Walker" <ett9300@.yahoo.com> wrote in message news:u90cVi%23vFHA.1256@.TK2MSFTNGP09.phx.gbl...
> We have MS SQL 2000 Enterprise Edition, running on Windows 2000 Server. Is it a good idea to
> reduce the size of the SQL Log File? If it is, do I need to make sure no one is using the
> database while I am reducing the size of the log file? Is it possible to setup these commands in
> a batch file instead of running them under Query Analyzer? Thanks.
> BACKUP LOG Smart_DATA WITH TRUNCATE_ONLY
> GO
> DBCC SHRINKDATABASE (Smart_DATA, TRUNCATEONLY)
>
>
>|||"while I am reducing the size of the log file?"
-No you neednt, even that would speed up the task. if you have any
maintainance window, do it within this.
"Is it possible to setup these commands in a batch file instead of
running them under Query Analyzer ?"
-Yes of course, put the statements in a job (step) and execute it here.
HTH, Jens Suessmeyer.|||Thank you very much.
"Jens" <Jens@.sqlserver2005.de> wrote in message
news:1127458411.014481.253870@.g49g2000cwa.googlegroups.com...
> "while I am reducing the size of the log file?"
> -No you neednt, even that would speed up the task. if you have any
> maintainance window, do it within this.
> "Is it possible to setup these commands in a batch file instead of
> running them under Query Analyzer ?"
> -Yes of course, put the statements in a job (step) and execute it here.
> HTH, Jens Suessmeyer.
>

Reduce the Size of SQL Log File

We have MS SQL 2000 Enterprise Edition, running on Windows 2000 Server. Is
it a good idea to reduce the size of the SQL Log File? If it is, do I need
to make sure no one is using the database while I am reducing the size of
the log file? Is it possible to setup these commands in a batch file
instead of running them under Query Analyzer? Thanks.
BACKUP LOG Smart_DATA WITH TRUNCATE_ONLY
GO
DBCC SHRINKDATABASE (Smart_DATA, TRUNCATEONLY)What recovery model is the database in? Also see
http://www.karaszi.com/SQLServer/info_dont_shrink.asp
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Diane Walker" <ett9300@.yahoo.com> wrote in message news:u90cVi%23vFHA.1256@.TK2MSFTNGP09.phx
.gbl...
> We have MS SQL 2000 Enterprise Edition, running on Windows 2000 Server. I
s it a good idea to
> reduce the size of the SQL Log File? If it is, do I need to make sure no
one is using the
> database while I am reducing the size of the log file? Is it possible to
setup these commands in
> a batch file instead of running them under Query Analyzer? Thanks.
> BACKUP LOG Smart_DATA WITH TRUNCATE_ONLY
> GO
> DBCC SHRINKDATABASE (Smart_DATA, TRUNCATEONLY)
>
>
>|||"while I am reducing the size of the log file?"
-No you neednt, even that would speed up the task. if you have any
maintainance window, do it within this.
"Is it possible to setup these commands in a batch file instead of
running them under Query Analyzer ?"
-Yes of course, put the statements in a job (step) and execute it here.
HTH, Jens Suessmeyer.|||Thank you very much.
"Jens" <Jens@.sqlserver2005.de> wrote in message
news:1127458411.014481.253870@.g49g2000cwa.googlegroups.com...
> "while I am reducing the size of the log file?"
> -No you neednt, even that would speed up the task. if you have any
> maintainance window, do it within this.
> "Is it possible to setup these commands in a batch file instead of
> running them under Query Analyzer ?"
> -Yes of course, put the statements in a job (step) and execute it here.
> HTH, Jens Suessmeyer.
>