Analysis Server

Can somebody help me understand what it take to install and setup Analysis
Server?
Is it part of standard MSSQL 2000 setup procedure?
Thx
YuriW
Yuri,
The procedure to install Analysis services is mentioned in
BooksOnLine(BOL).Here is the url:
mk:@.MSITStore:C:\Program%20Files\Microsoft%20SQL%2 0Server\80\Tools\Books\ola
pdmad.chm::/aginstalling_5trn.htm
To access a url, open up BOL and in the 'Go' menu, select 'url' and feed in
the above value.In case you dont have BOL installed, here is the same page
in the web:
'Running Setup'
http://msdn.microsoft.com/library/en...asp?frame=true
Dinesh
SQL Server MVP
--
SQL Server FAQ at
http://www.tkdinesh.com
"Yuri Weinstein (HotMail)" <yuriw_NOSPAM@.hotmail.com> wrote in message
news:63axc.68294$ep5.61876@.newssvr29.news.prodigy. com...
> Can somebody help me understand what it take to install and setup Analysis
> Server?
> Is it part of standard MSSQL 2000 setup procedure?
> Thx
> YuriW
>
|||In addition to Dinesh's answer, simply put the SQL CD in, and do
autorun.exe... Choose Install Database components, the next window will
give you an option to install Analysis services... Click click you are
done..
Then install the service pack..
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Yuri Weinstein (HotMail)" <yuriw_NOSPAM@.hotmail.com> wrote in message
news:63axc.68294$ep5.61876@.newssvr29.news.prodigy. com...
> Can somebody help me understand what it take to install and setup Analysis
> Server?
> Is it part of standard MSSQL 2000 setup procedure?
> Thx
> YuriW
>
sql

Analysis Server

Can somebody help me understand what it take to install and setup Analysis
Server?
Is it part of standard MSSQL 2000 setup procedure?
Thx
YuriWYuri,
The procedure to install Analysis services is mentioned in
BooksOnLine(BOL).Here is the url:
mk:@.MSITStore:C:\Program%20Files\Microso
ft%20SQL%20Server\80\Tools\Books\ola
pdmad.chm::/aginstalling_5trn.htm
To access a url, open up BOL and in the 'Go' menu, select 'url' and feed in
the above value.In case you dont have BOL installed, here is the same page
in the web:
'Running Setup'
/url]
Dinesh
SQL Server MVP
--
--
SQL Server FAQ at
[url]http://www.tkdinesh.com" target="_blank">http://msdn.microsoft.com/library/e...ww.tkdinesh.com
"Yuri Weinstein (HotMail)" <yuriw_NOSPAM@.hotmail.com> wrote in message
news:63axc.68294$ep5.61876@.newssvr29.news.prodigy.com...
> Can somebody help me understand what it take to install and setup Analysis
> Server?
> Is it part of standard MSSQL 2000 setup procedure?
> Thx
> YuriW
>|||In addition to Dinesh's answer, simply put the SQL CD in, and do
autorun.exe... Choose Install Database components, the next window will
give you an option to install Analysis services... Click click you are
done..
Then install the service pack..
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Yuri Weinstein (HotMail)" <yuriw_NOSPAM@.hotmail.com> wrote in message
news:63axc.68294$ep5.61876@.newssvr29.news.prodigy.com...
> Can somebody help me understand what it take to install and setup Analysis
> Server?
> Is it part of standard MSSQL 2000 setup procedure?
> Thx
> YuriW
>

an unkown insert type by me(!)

Hi Dear Coder Friends;

i just discovered below insert type in MSSQL 2005 Automatic creating insert sentence but i couldn't use because there is a syntax error.

INSERT INTO [KimlikBilgileri]

([CvId]

,[KimlikNo]

,[Ad]

,[Soyad]

,[Cinsiyet]

,[DogumTarihi]

,[UlkeId]

,[DogumYeri]

,[MedeniDurumu])

VALUES

(<CvId, int,>

,<KimlikNo, char(11),>

,<Ad, varchar(50),>

,<Soyad, varchar(50),>

,<Cinsiyet, char(5),>

,<DogumTarihi, smalldatetime,>

,<UlkeId, int,>

,<DogumYeri, varchar(50),>

,<MedeniDurumu, varchar(8),>)

Question for above;

-- What's this type called?

-- does it make any security bug like injections?

i want to use this one as a stored proc to add "create proc KimlikBilgilerInsert as ". So i think i don't have to declare one by one

am i right?

Thank you for your valuable knowledge

The syntax error is due to the datatypes. Remove all the datatype indicators.

This is called an INSERT statement.

Yes, it is susceptible to SQL Injection -there are very long varchar(50) fields, and there is no data validation. I would consider where the values are gathered, and if from textboxes on a form, then I would put this statement in a stored procedure and add some data validation code.

An instance of the SQL Server Reconciler error object cannot be created

I've got the following server configuration.

Database Server

- Windows 2003 Standard

- MSSQL 2000 sp4

Web Server

- Windows 2003 Standard

- SQL 2000 sp4 replication components

- SQL Mobile 2005 Server tools

The database server published out the snapshot to a share on the web server. This bit is working file, I can see the snapshot contents etc. When I connect from my own pc using SQL Management Studio and attempt to set up a subscription to a Mobile database, I get the following error.

TITLE: Microsoft SQL Server Management Studio

An instance of the SQL Server Reconciler error object cannot be created. Try reinstalling the replication components.
HRESULT 0x8007007E (28010)

BUTTONS:

OK

I've also accessed the Url using diagnostics and get the following output:

 SQL Server Mobile Server Agent Diagnostics

 2006/01/13 10:09:10

*General Information*Item Value
Server Name bundy
URL /services/taskmobileserversync/sqlcesa30.dll
Authentication Type Anonymous
Server Port 80
HTTPS off
Server Software Microsoft-IIS/6.0
Replication Allowed
RDA Allowed
Logging Level 1

*Impersonation and Access Tests* Action Status ErrorCode
Impersonate User SUCCESS 0x0
ReadWriteDeleteMessageFile SUCCESS 0x0

*SQL Server Mobile Modules Test*Module Status ErrorCode Version
SQLCERP30.DLL SUCCESS 0x0 3.0.5206.0
SQLCESA30.DLL SUCCESS 0x0 3.0.5206.0

*Reconciler Test* Reconciler Status ErrorCode
9.0 Database Reconciler FAILURE 0x80040154
8.0 Database Reconciler FAILURE 0x8007007E

*SQL Server Module Versions* Module Version
sqloledb.dll 2000.85.1022.0
8.0 replrec.dll 2000.80.2038.0
8.0 replprov.dll 2000.80.2038.0
8.0 msgprox.dll 2000.80.2038.0

Any suggestions? I've reinstalled the various components on the Web Server quite a few times by now...

thanks

// charlie

Search for REPLERRX.DLL and register using regsvr32. And then try. If the registration fails for this DLL, just check whether you have all the dependant DLLs. There are tools to find out the dependant DLLs of a particular binary. Most probably you may need to have MSVCR71.DLL and MSVCP71.DLL. However these two DLLs are already packaged in the 'SQL Server 2000 SP4 Replication Components' setup package. There is some problem in the installation I believe. If you could register REPLERRX.DLL, then you should be able to sync.

Thanks,

Laxmi NRO, MSFT, SQL Mobile, Microsoft Corporation

|||To fix this, I installed the SQL Server 2000 client tools. This resolved the problem.|||

Thanks for letting us know the information.

Thanks,

Laxmi Narsimha Rao ORUGANTI, MSFT, SQL Mobile, Microsoft Corporation

An existing connection was forcibly closed by the remote host

Hi,

I'm running a website using MSSQL 2000. Sometimes (not always) I get this error message on the website:

A transport-level error has occurred when sending the request to the server. (provider: TCP Provider, error: 0 - An existing connection was forcibly closed by the remote host.)

I have also websites running with MySQL and those don't have this problem.
I searched google but I couldn't find usefull information on this problem.

Someone who knows what's going on here ?

All I've found untill now is that it has something to do with the server not responding within a certain time, and thus assuming the connection was closed.

I can't find how I can just let it reconnect again in stead of giving me this error message?

an error of login "sa" with Error 18456 Level 14

I got an error of login "sa" with Error 18456 Level 14 .
Server A is the MSSQL Server where the database sit and
the other Server B is just with MSSQL Server tool which
act as a Terminal Service and have the Accounting
applications.The Accounting application unable to perform
its database transfer to another application on the
Terminal Service. We use Window 2003 Server. The
application programs are fine. The ODBC, MSSQL and
application "sa" password are identical. Any idea? Thanks
See my reply in .clients. Please don't post independently to several
newsgroups.
Andrew J. Kelly SQL MVP
"Li" <li@.adb.com.au> wrote in message
news:1cc201c46fbb$deb13760$a601280a@.phx.gbl...
> I got an error of login "sa" with Error 18456 Level 14 .
> Server A is the MSSQL Server where the database sit and
> the other Server B is just with MSSQL Server tool which
> act as a Terminal Service and have the Accounting
> applications.The Accounting application unable to perform
> its database transfer to another application on the
> Terminal Service. We use Window 2003 Server. The
> application programs are fine. The ODBC, MSSQL and
> application "sa" password are identical. Any idea? Thanks

an error of login "sa" with Error 18456 Level 14

I got an error of login "sa" with Error 18456 Level 14 .
Server A is the MSSQL Server where the database sit and
the other Server B is just with MSSQL Server tool which
act as a Terminal Service and have the Accounting
applications.The Accounting application unable to perform
its database transfer to another application on the
Terminal Service. We use Window 2003 Server. The
application programs are fine. The ODBC, MSSQL and
application "sa" password are identical. Any idea? ThanksSee my reply in .clients. Please don't post independently to several
newsgroups.
Andrew J. Kelly SQL MVP
"Li" <li@.adb.com.au> wrote in message
news:1cc201c46fbb$deb13760$a601280a@.phx.gbl...
> I got an error of login "sa" with Error 18456 Level 14 .
> Server A is the MSSQL Server where the database sit and
> the other Server B is just with MSSQL Server tool which
> act as a Terminal Service and have the Accounting
> applications.The Accounting application unable to perform
> its database transfer to another application on the
> Terminal Service. We use Window 2003 Server. The
> application programs are fine. The ODBC, MSSQL and
> application "sa" password are identical. Any idea? Thanks

An error occurred while attempting to start the service (193)

I have seen several threads on this topic but none of the solutions
mentioned work for me. I recentley uninstalled MSSQL 200 from my
machine and now I am trying to reinstall. I get this message
consistently. Any help is appreciated.
Thanks!
12:17:31 C:\Program Files\Microsoft SQL
Server\80\Tools\Binn\cnfgsvr.exe -F "C:\WINNT\sqlstp.log" -I
MSSQLSERVER -V 1 -M 0 -Q "SQL_Latin1_General_CP1_CI_AS" -H 66094 -U sa
-P
###############################################################################
Starting Service ...
SQL_Latin1_General_CP1_CI_AS
-m -Q -T4022 -T3659
An error occurred while attempting to start the service (193)
SQL Server configuration failed.
###############################################################################have you tried this kba?
http://support.microsoft.com/default.aspx?scid=kb;en-us;285100
"shcodip" wrote:
> I have seen several threads on this topic but none of the solutions
> mentioned work for me. I recentley uninstalled MSSQL 200 from my
> machine and now I am trying to reinstall. I get this message
> consistently. Any help is appreciated.
> Thanks!
> 12:17:31 C:\Program Files\Microsoft SQL
> Server\80\Tools\Binn\cnfgsvr.exe -F "C:\WINNT\sqlstp.log" -I
> MSSQLSERVER -V 1 -M 0 -Q "SQL_Latin1_General_CP1_CI_AS" -H 66094 -U sa
> -P
> ###############################################################################
>
> Starting Service ...
> SQL_Latin1_General_CP1_CI_AS
> -m -Q -T4022 -T3659
> An error occurred while attempting to start the service (193)
> SQL Server configuration failed.
> ###############################################################################
>|||My computer name is already upercase. So this does not apply.
Olu Adedeji wrote:
> have you tried this kba?
> http://support.microsoft.com/default.aspx?scid=kb;en-us;285100
> "shcodip" wrote:
> > I have seen several threads on this topic but none of the solutions
> > mentioned work for me. I recentley uninstalled MSSQL 200 from my
> > machine and now I am trying to reinstall. I get this message
> > consistently. Any help is appreciated.
> > Thanks!
> >
> > 12:17:31 C:\Program Files\Microsoft SQL
> > Server\80\Tools\Binn\cnfgsvr.exe -F "C:\WINNT\sqlstp.log" -I
> > MSSQLSERVER -V 1 -M 0 -Q "SQL_Latin1_General_CP1_CI_AS" -H 66094 -U
sa
> > -P
> >
###############################################################################
> >
> >
> > Starting Service ...
> >
> > SQL_Latin1_General_CP1_CI_AS
> >
> > -m -Q -T4022 -T3659
> >
> > An error occurred while attempting to start the service (193)
> >
> > SQL Server configuration failed.
> >
> >
###############################################################################
> >
> >

An error occurred while attempting to start the service (193)

I have seen several threads on this topic but none of the solutions
mentioned work for me. I recentley uninstalled MSSQL 200 from my
machine and now I am trying to reinstall. I get this message
consistently. Any help is appreciated.
Thanks!
12:17:31 C:\Program Files\Microsoft SQL
Server\80\Tools\Binn\cnfgsvr.exe -F "C:\WINNT\sqlstp.log" -I
MSSQLSERVER -V 1 -M 0 -Q "SQL_Latin1_General_CP1_CI_AS" -H 66094 -U sa
-P
################################################## #############################
Starting Service ...
SQL_Latin1_General_CP1_CI_AS
-m -Q -T4022 -T3659
An error occurred while attempting to start the service (193)
SQL Server configuration failed.
################################################## #############################
have you tried this kba?
http://support.microsoft.com/default...b;en-us;285100
"shcodip" wrote:

> I have seen several threads on this topic but none of the solutions
> mentioned work for me. I recentley uninstalled MSSQL 200 from my
> machine and now I am trying to reinstall. I get this message
> consistently. Any help is appreciated.
> Thanks!
> 12:17:31 C:\Program Files\Microsoft SQL
> Server\80\Tools\Binn\cnfgsvr.exe -F "C:\WINNT\sqlstp.log" -I
> MSSQLSERVER -V 1 -M 0 -Q "SQL_Latin1_General_CP1_CI_AS" -H 66094 -U sa
> -P
> ################################################## #############################
>
> Starting Service ...
> SQL_Latin1_General_CP1_CI_AS
> -m -Q -T4022 -T3659
> An error occurred while attempting to start the service (193)
> SQL Server configuration failed.
> ################################################## #############################
>
|||My computer name is already upercase. So this does not apply.
Olu Adedeji wrote:[vbcol=seagreen]
> have you tried this kba?
> http://support.microsoft.com/default...b;en-us;285100
> "shcodip" wrote:
sa[vbcol=seagreen]
################################################## #############################[vbcol=seagreen]
################################################## #############################[vbcol=seagreen]