Wednesday, March 28, 2012
MSSQL 2000 - cant connect to DB from remote computer
I have installed MSSQL 2000 Developer and I have setup a database which I am able to connect to and work fine with from the actual server MSSQL is installed on.
The problem comes in when i try to connect to that same database from a different remote server. It will not connect to the DB from this remote server but I know all the connection information is correct so its something on the MSSQL DB server causing this and not on this remote server.
Someone I know has had this problem and has fixed it but they wont tell me how. All I know is they said something about manually opening the ports on the MSSQL server and he also said when you set it to dynamicly determine the port that MSSQL is listening on it errored out. however if you set it staticly to 1433 it worked fine.
Ive also installed SP4 in attempt to fix this but no luck with that either. And I can also get the same exact remote server to connect to completely different DB server without issues.
If anyone can please help walk me through this I would be greatly appreciate and I am also willing to pay some money if it will make my life easier.Can "Developer Version" be connected from a remote client?|||While these (http://msdn2.microsoft.com/en-us/library/ms175043.aspx) directions are specifically for SQL 2005, I'm pretty sure that they'll work for SQL-2000 too.
-PatP|||Ronin- Yes it can be done.
Pat- The firewall is completely disabled. It says Windows Firewall and ICS(internet connection sharing) is disabled when I try to go to the firewall settings so I dont think thats the problem unless I have to enable it and then do this but that doesnt make much sense.|||can anyone help?|||Which SQL network libraries did you select?
-PatP|||named pipes, tcp/ip, nwlink ipx/spx, VIA giganet
MSSQL - (2) - 17055
Source: MSSQL
Category: (2)
ID: 17055
18052: Error: 9001, Severity: 21, State: 4
What's the problem?
Michael S. Androsov
EXPOCENTRMisha
It might be a hardware issue, see these KB's for more information:
Q259237 Troubleshooting Event ID 9, 11, and 15 on Cluster Servers
http://support.microsoft.com/support/kb/articles/q259/2/37.asp
Q154690 How to Troubleshoot Event 9 and Event 11 Error Messages
http://support.microsoft.com/support/kb/articles/q154/6/90.asp
Q244780 Information About Event ID 51
http://support.microsoft.com/support/kb/articles/q244/7/80.asp
"Michael S. Androsov" <MichaelSAndrosov@.discussions.microsoft.com> wrote in
message news:D9A9BB4F-117F-400F-B168-507EB9E0253F@.microsoft.com...
> I have a SQL Server 2000 (SP3) on the Windows NT Server 4.0 (SP6a)
computer. And I received next message in the Event Log:
> Source: MSSQL
> Category: (2)
> ID: 17055
> 18052: Error: 9001, Severity: 21, State: 4
> What's the problem?
> Michael S. Androsov
> EXPOCENTR
>|||Michael,
Can be due to a number of reasons.Check 'Eventid.Net'
http://www.eventid.net/display.asp?eventid=17055&source=
Are all the databases in the server running fine?Is there any entry in the
SQLServer error log around the same timestamp?
--
Dinesh
SQL Server MVP
--
--
SQL Server FAQ at
http://www.tkdinesh.com
"Michael S. Androsov" <MichaelSAndrosov@.discussions.microsoft.com> wrote in
message news:D9A9BB4F-117F-400F-B168-507EB9E0253F@.microsoft.com...
> I have a SQL Server 2000 (SP3) on the Windows NT Server 4.0 (SP6a)
computer. And I received next message in the Event Log:
> Source: MSSQL
> Category: (2)
> ID: 17055
> 18052: Error: 9001, Severity: 21, State: 4
> What's the problem?
> Michael S. Androsov
> EXPOCENTR
>|||Sorry, but this articles is not for my problem.
Michael S. Androsov
EXPOCENTR
"Uri Dimant" wrote:
> Misha
> It might be a hardware issue, see these KB's for more information:
> Q259237 Troubleshooting Event ID 9, 11, and 15 on Cluster Servers
> http://support.microsoft.com/support/kb/articles/q259/2/37.asp
> Q154690 How to Troubleshoot Event 9 and Event 11 Error Messages
> http://support.microsoft.com/support/kb/articles/q154/6/90.asp
> Q244780 Information About Event ID 51
> http://support.microsoft.com/support/kb/articles/q244/7/80.asp
>
>
> "Michael S. Androsov" <MichaelSAndrosov@.discussions.microsoft.com> wrote in
> message news:D9A9BB4F-117F-400F-B168-507EB9E0253F@.microsoft.com...
> > I have a SQL Server 2000 (SP3) on the Windows NT Server 4.0 (SP6a)
> computer. And I received next message in the Event Log:
> > Source: MSSQL
> > Category: (2)
> > ID: 17055
> > 18052: Error: 9001, Severity: 21, State: 4
> >
> > What's the problem?
> >
> > Michael S. Androsov
> > EXPOCENTR
> >
>
>|||I don't find a message about my problems in your URL. But all massages in this URL relay with BACKUP. May be my problem with NTBACKUP? I'm using this utility.
My databases is working normally on this seerver.
Michael S. Androsov
EXPOCENTR
"Dinesh T.K" wrote:
> Michael,
> Can be due to a number of reasons.Check 'Eventid.Net'
> http://www.eventid.net/display.asp?eventid=17055&source=
> Are all the databases in the server running fine?Is there any entry in the
> SQLServer error log around the same timestamp?
> --
> Dinesh
> SQL Server MVP
> --
> --
> SQL Server FAQ at
> http://www.tkdinesh.com
> "Michael S. Androsov" <MichaelSAndrosov@.discussions.microsoft.com> wrote in
> message news:D9A9BB4F-117F-400F-B168-507EB9E0253F@.microsoft.com...
> > I have a SQL Server 2000 (SP3) on the Windows NT Server 4.0 (SP6a)
> computer. And I received next message in the Event Log:
> > Source: MSSQL
> > Category: (2)
> > ID: 17055
> > 18052: Error: 9001, Severity: 21, State: 4
> >
> > What's the problem?
> >
> > Michael S. Androsov
> > EXPOCENTR
> >
>
>|||Michael,
The messages in eventid.net is from people who faced that particular event
ID in diffrerent circumstances.If yours doesnt match, then okay, we need to
look elsewhere.
The reason why I asked if all databases are fine is because I checked the
Error: 9001 in BooksOnLine and it mentioned that the error may occur if the
log file is missing.Now, from your reply, Iam not sure if 9001 in this
context represents the one in BOL.
>>May be my problem with NTBACKUP?
Are the errors appearing even now? at regular intervals? If so, compare the
timing of the error with the backup.Also, since the source is sqlserver, you
can also check the sqlserver errorlog.May be, a detailed description is
present there.
--
Dinesh
SQL Server MVP
--
--
SQL Server FAQ at
http://www.tkdinesh.com
"Michael S. Androsov" <MichaelSAndrosov@.discussions.microsoft.com> wrote in
message news:8E12C100-B02F-43C1-89AC-D3A03FBB6B3B@.microsoft.com...
> I don't find a message about my problems in your URL. But all massages in
this URL relay with BACKUP. May be my problem with NTBACKUP? I'm using this
utility.
> My databases is working normally on this seerver.
> Michael S. Androsov
> EXPOCENTR
> "Dinesh T.K" wrote:
> > Michael,
> >
> > Can be due to a number of reasons.Check 'Eventid.Net'
> > http://www.eventid.net/display.asp?eventid=17055&source=
> >
> > Are all the databases in the server running fine?Is there any entry in
the
> > SQLServer error log around the same timestamp?
> >
> > --
> > Dinesh
> > SQL Server MVP
> > --
> > --
> > SQL Server FAQ at
> > http://www.tkdinesh.com
> >
> > "Michael S. Androsov" <MichaelSAndrosov@.discussions.microsoft.com> wrote
in
> > message news:D9A9BB4F-117F-400F-B168-507EB9E0253F@.microsoft.com...
> > > I have a SQL Server 2000 (SP3) on the Windows NT Server 4.0 (SP6a)
> > computer. And I received next message in the Event Log:
> > > Source: MSSQL
> > > Category: (2)
> > > ID: 17055
> > > 18052: Error: 9001, Severity: 21, State: 4
> > >
> > > What's the problem?
> > >
> > > Michael S. Androsov
> > > EXPOCENTR
> > >
> >
> >
> >
MSSQL - (2) - 17055
Source: MSSQL
Category: (2)
ID: 17055
18052: Error: 9001, Severity: 21, State: 4
What's the problem?
Michael S. Androsov
EXPOCENTR
Misha
It might be a hardware issue, see these KB's for more information:
Q259237 Troubleshooting Event ID 9, 11, and 15 on Cluster Servers
http://support.microsoft.com/support.../q259/2/37.asp
Q154690 How to Troubleshoot Event 9 and Event 11 Error Messages
http://support.microsoft.com/support.../q154/6/90.asp
Q244780 Information About Event ID 51
http://support.microsoft.com/support.../q244/7/80.asp
"Michael S. Androsov" <MichaelSAndrosov@.discussions.microsoft.com> wrote in
message news:D9A9BB4F-117F-400F-B168-507EB9E0253F@.microsoft.com...
> I have a SQL Server 2000 (SP3) on the Windows NT Server 4.0 (SP6a)
computer. And I received next message in the Event Log:
> Source: MSSQL
> Category: (2)
> ID: 17055
> 18052: Error: 9001, Severity: 21, State: 4
> What's the problem?
> Michael S. Androsov
> EXPOCENTR
>
|||Michael,
Can be due to a number of reasons.Check 'Eventid.Net'
http://www.eventid.net/display.asp?e...=17055&source=
Are all the databases in the server running fine?Is there any entry in the
SQLServer error log around the same timestamp?
Dinesh
SQL Server MVP
--
SQL Server FAQ at
http://www.tkdinesh.com
"Michael S. Androsov" <MichaelSAndrosov@.discussions.microsoft.com> wrote in
message news:D9A9BB4F-117F-400F-B168-507EB9E0253F@.microsoft.com...
> I have a SQL Server 2000 (SP3) on the Windows NT Server 4.0 (SP6a)
computer. And I received next message in the Event Log:
> Source: MSSQL
> Category: (2)
> ID: 17055
> 18052: Error: 9001, Severity: 21, State: 4
> What's the problem?
> Michael S. Androsov
> EXPOCENTR
>
|||Sorry, but this articles is not for my problem.
Michael S. Androsov
EXPOCENTR
"Uri Dimant" wrote:
> Misha
> It might be a hardware issue, see these KB's for more information:
> Q259237 Troubleshooting Event ID 9, 11, and 15 on Cluster Servers
> http://support.microsoft.com/support.../q259/2/37.asp
> Q154690 How to Troubleshoot Event 9 and Event 11 Error Messages
> http://support.microsoft.com/support.../q154/6/90.asp
> Q244780 Information About Event ID 51
> http://support.microsoft.com/support.../q244/7/80.asp
>
>
> "Michael S. Androsov" <MichaelSAndrosov@.discussions.microsoft.com> wrote in
> message news:D9A9BB4F-117F-400F-B168-507EB9E0253F@.microsoft.com...
> computer. And I received next message in the Event Log:
>
>
|||I don't find a message about my problems in your URL. But all massages in this URL relay with BACKUP. May be my problem with NTBACKUP? I'm using this utility.
My databases is working normally on this seerver.
Michael S. Androsov
EXPOCENTR
"Dinesh T.K" wrote:
> Michael,
> Can be due to a number of reasons.Check 'Eventid.Net'
> http://www.eventid.net/display.asp?e...=17055&source=
> Are all the databases in the server running fine?Is there any entry in the
> SQLServer error log around the same timestamp?
> --
> Dinesh
> SQL Server MVP
> --
> --
> SQL Server FAQ at
> http://www.tkdinesh.com
> "Michael S. Androsov" <MichaelSAndrosov@.discussions.microsoft.com> wrote in
> message news:D9A9BB4F-117F-400F-B168-507EB9E0253F@.microsoft.com...
> computer. And I received next message in the Event Log:
>
>
|||Michael,
The messages in eventid.net is from people who faced that particular event
ID in diffrerent circumstances.If yours doesnt match, then okay, we need to
look elsewhere.
The reason why I asked if all databases are fine is because I checked the
Error: 9001 in BooksOnLine and it mentioned that the error may occur if the
log file is missing.Now, from your reply, Iam not sure if 9001 in this
context represents the one in BOL.
[vbcol=seagreen]
Are the errors appearing even now? at regular intervals? If so, compare the
timing of the error with the backup.Also, since the source is sqlserver, you
can also check the sqlserver errorlog.May be, a detailed description is
present there.
Dinesh
SQL Server MVP
--
SQL Server FAQ at
http://www.tkdinesh.com
"Michael S. Androsov" <MichaelSAndrosov@.discussions.microsoft.com> wrote in
message news:8E12C100-B02F-43C1-89AC-D3A03FBB6B3B@.microsoft.com...
> I don't find a message about my problems in your URL. But all massages in
this URL relay with BACKUP. May be my problem with NTBACKUP? I'm using this
utility.[vbcol=seagreen]
> My databases is working normally on this seerver.
> Michael S. Androsov
> EXPOCENTR
> "Dinesh T.K" wrote:
the[vbcol=seagreen]
in[vbcol=seagreen]
|||This mistake has appeared in the Log once. I look through log some days, but this mistake does not appear any more, though reserve copying with ntbackup doing every day.
Michael S. Androsov
EXPOCENTR
"Dinesh T.K" wrote:
> Michael,
> The messages in eventid.net is from people who faced that particular event
> ID in diffrerent circumstances.If yours doesnt match, then okay, we need to
> look elsewhere.
> The reason why I asked if all databases are fine is because I checked the
> Error: 9001 in BooksOnLine and it mentioned that the error may occur if the
> log file is missing.Now, from your reply, Iam not sure if 9001 in this
> context represents the one in BOL.
> Are the errors appearing even now? at regular intervals? If so, compare the
> timing of the error with the backup.Also, since the source is sqlserver, you
> can also check the sqlserver errorlog.May be, a detailed description is
> present there.
> --
> Dinesh
> SQL Server MVP
> --
> --
> SQL Server FAQ at
> http://www.tkdinesh.com
> "Michael S. Androsov" <MichaelSAndrosov@.discussions.microsoft.com> wrote in
> message news:8E12C100-B02F-43C1-89AC-D3A03FBB6B3B@.microsoft.com...
> this URL relay with BACKUP. May be my problem with NTBACKUP? I'm using this
> utility.
> the
> in
>
>
MSSQL - (2) - 17055
And I received next message in the Event Log:
Source: MSSQL
Category: (2)
ID: 17055
18052: Error: 9001, Severity: 21, State: 4
What's the problem?
Michael S. Androsov
EXPOCENTRMisha
It might be a hardware issue, see these KB's for more information:
Q259237 Troubleshooting Event ID 9, 11, and 15 on Cluster Servers
http://support.microsoft.com/suppor...s/q259/2/37.asp
Q154690 How to Troubleshoot Event 9 and Event 11 Error Messages
http://support.microsoft.com/suppor...s/q154/6/90.asp
Q244780 Information About Event ID 51
http://support.microsoft.com/suppor...s/q244/7/80.asp
"Michael S. Androsov" <MichaelSAndrosov@.discussions.microsoft.com> wrote in
message news:D9A9BB4F-117F-400F-B168-507EB9E0253F@.microsoft.com...
> I have a SQL Server 2000 (SP3) on the Windows NT Server 4.0 (SP6a)
computer. And I received next message in the Event Log:
> Source: MSSQL
> Category: (2)
> ID: 17055
> 18052: Error: 9001, Severity: 21, State: 4
> What's the problem?
> Michael S. Androsov
> EXPOCENTR
>|||Michael,
Can be due to a number of reasons.Check 'Eventid.Net'
http://www.eventid.net/display.asp?...d=17055&source=
Are all the databases in the server running fine?Is there any entry in the
SQLServer error log around the same timestamp?
Dinesh
SQL Server MVP
--
--
SQL Server FAQ at
http://www.tkdinesh.com
"Michael S. Androsov" <MichaelSAndrosov@.discussions.microsoft.com> wrote in
message news:D9A9BB4F-117F-400F-B168-507EB9E0253F@.microsoft.com...
> I have a SQL Server 2000 (SP3) on the Windows NT Server 4.0 (SP6a)
computer. And I received next message in the Event Log:
> Source: MSSQL
> Category: (2)
> ID: 17055
> 18052: Error: 9001, Severity: 21, State: 4
> What's the problem?
> Michael S. Androsov
> EXPOCENTR
>|||Sorry, but this articles is not for my problem.
Michael S. Androsov
EXPOCENTR
"Uri Dimant" wrote:
> Misha
> It might be a hardware issue, see these KB's for more information:
> Q259237 Troubleshooting Event ID 9, 11, and 15 on Cluster Servers
> http://support.microsoft.com/suppor...s/q259/2/37.asp
> Q154690 How to Troubleshoot Event 9 and Event 11 Error Messages
> http://support.microsoft.com/suppor...s/q154/6/90.asp
> Q244780 Information About Event ID 51
> http://support.microsoft.com/suppor...s/q244/7/80.asp
>
>
> "Michael S. Androsov" <MichaelSAndrosov@.discussions.microsoft.com> wrote i
n
> message news:D9A9BB4F-117F-400F-B168-507EB9E0253F@.microsoft.com...
> computer. And I received next message in the Event Log:
>
>|||I don't find a message about my problems in your URL. But all massages in th
is URL relay with BACKUP. May be my problem with NTBACKUP? I'm using this ut
ility.
My databases is working normally on this seerver.
Michael S. Androsov
EXPOCENTR
"Dinesh T.K" wrote:
> Michael,
> Can be due to a number of reasons.Check 'Eventid.Net'
> http://www.eventid.net/display.asp?...d=17055&source=
> Are all the databases in the server running fine?Is there any entry in the
> SQLServer error log around the same timestamp?
> --
> Dinesh
> SQL Server MVP
> --
> --
> SQL Server FAQ at
> http://www.tkdinesh.com
> "Michael S. Androsov" <MichaelSAndrosov@.discussions.microsoft.com> wrote i
n
> message news:D9A9BB4F-117F-400F-B168-507EB9E0253F@.microsoft.com...
> computer. And I received next message in the Event Log:
>
>|||Michael,
The messages in eventid.net is from people who faced that particular event
ID in diffrerent circumstances.If yours doesnt match, then okay, we need to
look elsewhere.
The reason why I asked if all databases are fine is because I checked the
Error: 9001 in BooksOnLine and it mentioned that the error may occur if the
log file is missing.Now, from your reply, Iam not sure if 9001 in this
context represents the one in BOL.
Are the errors appearing even now? at regular intervals? If so, compare the
timing of the error with the backup.Also, since the source is sqlserver, you
can also check the sqlserver errorlog.May be, a detailed description is
present there.
Dinesh
SQL Server MVP
--
--
SQL Server FAQ at
http://www.tkdinesh.com
"Michael S. Androsov" <MichaelSAndrosov@.discussions.microsoft.com> wrote in
message news:8E12C100-B02F-43C1-89AC-D3A03FBB6B3B@.microsoft.com...[vbcol=seagreen]
> I don't find a message about my problems in your URL. But all massages in
this URL relay with BACKUP. May be my problem with NTBACKUP? I'm using this
utility.[vbcol=seagreen]
> My databases is working normally on this seerver.
> Michael S. Androsov
> EXPOCENTR
> "Dinesh T.K" wrote:
>
the[vbcol=seagreen]
in[vbcol=seagreen]|||This mistake has appeared in the Log once. I look through log some days, but
this mistake does not appear any more, though reserve copying with ntbackup
doing every day.
Michael S. Androsov
EXPOCENTR
"Dinesh T.K" wrote:
> Michael,
> The messages in eventid.net is from people who faced that particular event
> ID in diffrerent circumstances.If yours doesnt match, then okay, we need t
o
> look elsewhere.
> The reason why I asked if all databases are fine is because I checked the
> Error: 9001 in BooksOnLine and it mentioned that the error may occur if th
e
> log file is missing.Now, from your reply, Iam not sure if 9001 in this
> context represents the one in BOL.
>
> Are the errors appearing even now? at regular intervals? If so, compare th
e
> timing of the error with the backup.Also, since the source is sqlserver, y
ou
> can also check the sqlserver errorlog.May be, a detailed description is
> present there.
> --
> Dinesh
> SQL Server MVP
> --
> --
> SQL Server FAQ at
> http://www.tkdinesh.com
> "Michael S. Androsov" <MichaelSAndrosov@.discussions.microsoft.com> wrote i
n
> message news:8E12C100-B02F-43C1-89AC-D3A03FBB6B3B@.microsoft.com...
> this URL relay with BACKUP. May be my problem with NTBACKUP? I'm using thi
s
> utility.
> the
> in
>
>
Friday, March 23, 2012
MSOLAP.DLL Version Numbers
pre-requisite software in my computer. The third party software is
returning the following diagnostic result (saying I do not heve the correct version of PTS).
Microsoft PivotTable Service 2000
Required: OLAP Server 8.0.986.0
Currently: OLAP Server 8.0.760.0
Status: Error
It is my understanding that "PTS" is MSOLAP.DLL.
I have Analysis Server 2000 SP3 installed and all appears OK.
According to other posts in this group, the correct version of
msolap.dll (pivot table services) for SP3 and SP3A is 8.0.760.0.
My version of msolap.dll currently installed is 8.0.2039.0, which I
believe to be the SP4 version of PTS
The third party software is searching for a version 8.0.986.0.
Nowhere in the MSDN world can I find ANY mention of 8.0.986.0 as a
version number of anything.
Is this an error in the third party diagnostic?
Where would they possibly be getting that version number (8.0.986.0)?
What do you think they are looking at when they say "OLAP SERVER"
The third party support people are saying I must uninstall Analysis
Server 2000 and then download and install PTSFullSP4.exe. I am not
prepared to take so drastic a step, especially given the strange
Product Titles and version numbers they are looking for.
Can anyone shed some light on this issue?
Version 8.00.2039 corresponds to the service pack 4 of SQL Server 2000.
So looks like you've got SP4 of PTS installed and not SP3.
From the error message it looks like the software you trying to install requires SP4 version of Analysis Server.
You can try and run SP4 setup for Analysis Services from
http://www.microsoft.com/downloads/details.aspx?FamilyID=8e2dfc8d-c20e-4446-99a9-b7f0213f8bc5&DisplayLang=en
Edward Melomed.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
Friday, March 9, 2012
MSDTC?
The description for Event ID ( 0 ) in Source ( ODBC ) cannot be found. The
local computer may not have the necessary registry information or message DLL
files to display messages from a remote computer. The following information
is part of the event: Failed to enlist in DTC: SQL state 37000, native error
8501, error message [Microsoft][ODBC SQL Server Driver][SQL Server]MSDTC on
server 'PROSQL' is unavailable..
what does this mean?...thanks
-Jim
Check to see if DTC is running on PROSQL.
-Sue
On Mon, 16 Oct 2006 14:14:02 -0700, Jim
<Jim@.discussions.microsoft.com> wrote:
>I keep getting this message on my application server.
>The description for Event ID ( 0 ) in Source ( ODBC ) cannot be found. The
>local computer may not have the necessary registry information or message DLL
>files to display messages from a remote computer. The following information
>is part of the event: Failed to enlist in DTC: SQL state 37000, native error
>8501, error message [Microsoft][ODBC SQL Server Driver][SQL Server]MSDTC on
>server 'PROSQL' is unavailable..
>what does this mean?...thanks
>-Jim
MSDTC?
The description for Event ID ( 0 ) in Source ( ODBC ) cannot be found. The
local computer may not have the necessary registry information or message DL
L
files to display messages from a remote computer. The following information
is part of the event: Failed to enlist in DTC: SQL state 37000, native error
8501, error message [Microsoft][ODBC SQL Server Driver][SQL Serv
er]MSDTC on
server 'PROSQL' is unavailable..
what does this mean?...thanks
-JimCheck to see if DTC is running on PROSQL.
-Sue
On Mon, 16 Oct 2006 14:14:02 -0700, Jim
<Jim@.discussions.microsoft.com> wrote:
>I keep getting this message on my application server.
>The description for Event ID ( 0 ) in Source ( ODBC ) cannot be found. The
>local computer may not have the necessary registry information or message D
LL
>files to display messages from a remote computer. The following information
>is part of the event: Failed to enlist in DTC: SQL state 37000, native erro
r
>8501, error message [Microsoft][ODBC SQL Server Driver][SQL Ser
ver]MSDTC on
>server 'PROSQL' is unavailable..
>what does this mean?...thanks
>-Jim