Getting "An existing connection was forcibly closed by the remote host (System)" error

I cannot connect to Analysis Services through SSMS. Receiving a "An existing connection was forcibly closed by the remote host (System) error." I changed my password this morning due to our company security policies and now I can't do squat. This is definitely a bug in the service as something is cached and not clearing out. I've rebooted both the server and client a couple of times. Running AS 2005 SP1 on Windows Server 2003. I can connect through another machine. Here's the message I'm getting. Don't know where to look to fix the problem.

===================================

Cannot connect to hctx-idwdev.

===================================

A connection cannot be made. Ensure that the server is running. (Microsoft.AnalysisServices.AdomdClient)

Program Location:

at Microsoft.AnalysisServices.AdomdClient.XmlaClient.Connect(ConnectionInfo connectionInfo, Boolean beginSession)
at Microsoft.AnalysisServices.AdomdClient.AdomdConnection.XmlaClientProvider.Microsoft.AnalysisServices.AdomdClient.AdomdConnection.IXmlaClientProviderEx.ConnectXmla()
at Microsoft.AnalysisServices.AdomdClient.AdomdConnection.ConnectToXMLA(Boolean createSession, Boolean isHTTP)
at Microsoft.AnalysisServices.AdomdClient.AdomdConnection.Open()
at Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.ObjectExplorer.ValidateConnection(UIConnectionInfo ci, IServerType server)
at Microsoft.SqlServer.Management.UI.ConnectionDlg.Connector.ConnectionThreadUser()

===================================

Unable to read data from the transport connection: An existing connection was forcibly closed by the remote host. (System)

Program Location:

at System.Net.Sockets.NetworkStream.Read(Byte[] buffer, Int32 offset, Int32 size)
at System.IO.BufferedStream.Read(Byte[] array, Int32 offset, Int32 count)
at Microsoft.AnalysisServices.AdomdClient.DimeRecord.ForceRead(Stream stream, Byte[] buffer, Int32 length)
at Microsoft.AnalysisServices.AdomdClient.DimeRecord.ReadHeader()
at Microsoft.AnalysisServices.AdomdClient.DimeRecord..ctor(Stream stream)
at Microsoft.AnalysisServices.AdomdClient.DimeReader.ReadRecord()
at Microsoft.AnalysisServices.AdomdClient.TcpStream.GetResponseDataType()

===================================

An existing connection was forcibly closed by the remote host (System)

Program Location:

at System.Net.Sockets.Socket.Receive(Byte[] buffer, Int32 offset, Int32 size, SocketFlags socketFlags)
at System.Net.Sockets.NetworkStream.Read(Byte[] buffer, Int32 offset, Int32 size)

I've uninstalled the client tools and reinstalled. After rebooting, I STILL CANNOT CONNECT TO ANALYSIS SERVICES FROM THIS MACHINE.

Major issue addressed in next service pack? Is there a local cache I need to clear? Any help would be greatly appreciated.

|||Fixed the problem even though the solution is less than ideal. To resolve, we had to delete my user profile on the machine. Apparently, something used by the drivers is being stored in the Document and Settings for the current user. What exactly we weren't able to identify.

Getting "An existing connection was forcibly closed by the remote host (System)" e

I cannot connect to Analysis Services through SSMS. Receiving a "An existing connection was forcibly closed by the remote host (System) error." I changed my password this morning due to our company security policies and now I can't do squat. This is definitely a bug in the service as something is cached and not clearing out. I've rebooted both the server and client a couple of times. Running AS 2005 SP1 on Windows Server 2003. I can connect through another machine. Here's the message I'm getting. Don't know where to look to fix the problem.

===================================

Cannot connect to hctx-idwdev.

===================================

A connection cannot be made. Ensure that the server is running. (Microsoft.AnalysisServices.AdomdClient)

Program Location:

at Microsoft.AnalysisServices.AdomdClient.XmlaClient.Connect(ConnectionInfo connectionInfo, Boolean beginSession)
at Microsoft.AnalysisServices.AdomdClient.AdomdConnection.XmlaClientProvider.Microsoft.AnalysisServices.AdomdClient.AdomdConnection.IXmlaClientProviderEx.ConnectXmla()
at Microsoft.AnalysisServices.AdomdClient.AdomdConnection.ConnectToXMLA(Boolean createSession, Boolean isHTTP)
at Microsoft.AnalysisServices.AdomdClient.AdomdConnection.Open()
at Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.ObjectExplorer.ValidateConnection(UIConnectionInfo ci, IServerType server)
at Microsoft.SqlServer.Management.UI.ConnectionDlg.Connector.ConnectionThreadUser()

===================================

Unable to read data from the transport connection: An existing connection was forcibly closed by the remote host. (System)

Program Location:

at System.Net.Sockets.NetworkStream.Read(Byte[] buffer, Int32 offset, Int32 size)
at System.IO.BufferedStream.Read(Byte[] array, Int32 offset, Int32 count)
at Microsoft.AnalysisServices.AdomdClient.DimeRecord.ForceRead(Stream stream, Byte[] buffer, Int32 length)
at Microsoft.AnalysisServices.AdomdClient.DimeRecord.ReadHeader()
at Microsoft.AnalysisServices.AdomdClient.DimeRecord..ctor(Stream stream)
at Microsoft.AnalysisServices.AdomdClient.DimeReader.ReadRecord()
at Microsoft.AnalysisServices.AdomdClient.TcpStream.GetResponseDataType()

===================================

An existing connection was forcibly closed by the remote host (System)

Program Location:

at System.Net.Sockets.Socket.Receive(Byte[] buffer, Int32 offset, Int32 size, SocketFlags socketFlags)
at System.Net.Sockets.NetworkStream.Read(Byte[] buffer, Int32 offset, Int32 size)

I've uninstalled the client tools and reinstalled. After rebooting, I STILL CANNOT CONNECT TO ANALYSIS SERVICES FROM THIS MACHINE.

Major issue addressed in next service pack? Is there a local cache I need to clear? Any help would be greatly appreciated.

|||Fixed the problem even though the solution is less than ideal. To resolve, we had to delete my user profile on the machine. Apparently, something used by the drivers is being stored in the Document and Settings for the current user. What exactly we weren't able to identify.sql

Get the sa password possible?

Hello,
Is it possible to get or change the existing sa password for microsoft
sql server 2000 as i've forgotten it?
I'm able to use Enterprise Manager by via Windows Authentication, but
i need to connect to a database with SQL Authentication.
Thanks,
jack.Hello,
YOu can not see the password, but you can change the password. All you have
to do is:-
1. Login into the query analyzer using windows authentication
2. Execute the below query to change the SA password
sp_password NULL,'Newpassword','sa'
This will change the password of SA to a new password. THis will work well
if you r windows user is part od Admin group.
Thanks
Hari
"Jack" <bradnerdhss@.hotmail.com> wrote in message
news:1171849045.996306.258230@.s48g2000cws.googlegroups.com...
> Hello,
> Is it possible to get or change the existing sa password for microsoft
> sql server 2000 as i've forgotten it?
> I'm able to use Enterprise Manager by via Windows Authentication, but
> i need to connect to a database with SQL Authentication.
> Thanks,
> jack.
>|||On Feb 19, 11:19 am, "Hari Prasad" <hari_prasa...@.hotmail.com> wrote:
> Hello,
> YOu can not see the password, but you can change the password. All you hav
e
> to do is:-
> 1. Login into the query analyzer using windows authentication
> 2. Execute the below query to change the SA password
> sp_password NULL,'Newpassword','sa'
> This will change the password of SA to a new password. THis will work well
> if you r windows user is part od Admin group.
> Thanks
> Hari
> "Jack" <bradnerd...@.hotmail.com> wrote in message
> news:1171849045.996306.258230@.s48g2000cws.googlegroups.com...
>
>
>
>
> - Show quoted text -
Yes thanks. That worked perfectly.
Jack.

Get the sa password possible?

Hello,
Is it possible to get or change the existing sa password for microsoft
sql server 2000 as i've forgotten it?
I'm able to use Enterprise Manager by via Windows Authentication, but
i need to connect to a database with SQL Authentication.
Thanks,
jack.
Hello,
YOu can not see the password, but you can change the password. All you have
to do is:-
1. Login into the query analyzer using windows authentication
2. Execute the below query to change the SA password
sp_password NULL,'Newpassword','sa'
This will change the password of SA to a new password. THis will work well
if you r windows user is part od Admin group.
Thanks
Hari
"Jack" <bradnerdhss@.hotmail.com> wrote in message
news:1171849045.996306.258230@.s48g2000cws.googlegr oups.com...
> Hello,
> Is it possible to get or change the existing sa password for microsoft
> sql server 2000 as i've forgotten it?
> I'm able to use Enterprise Manager by via Windows Authentication, but
> i need to connect to a database with SQL Authentication.
> Thanks,
> jack.
>
|||On Feb 19, 11:19 am, "Hari Prasad" <hari_prasa...@.hotmail.com> wrote:
> Hello,
> YOu can not see the password, but you can change the password. All you have
> to do is:-
> 1. Login into the query analyzer using windows authentication
> 2. Execute the below query to change the SA password
> sp_password NULL,'Newpassword','sa'
> This will change the password of SA to a new password. THis will work well
> if you r windows user is part od Admin group.
> Thanks
> Hari
> "Jack" <bradnerd...@.hotmail.com> wrote in message
> news:1171849045.996306.258230@.s48g2000cws.googlegr oups.com...
>
>
>
> - Show quoted text -
Yes thanks. That worked perfectly.
Jack.

Get the sa password possible?

Hello,
Is it possible to get or change the existing sa password for microsoft
sql server 2000 as i've forgotten it?
I'm able to use Enterprise Manager by via Windows Authentication, but
i need to connect to a database with SQL Authentication.
Thanks,
jack.Hello,
YOu can not see the password, but you can change the password. All you have
to do is:-
1. Login into the query analyzer using windows authentication
2. Execute the below query to change the SA password
sp_password NULL,'Newpassword','sa'
This will change the password of SA to a new password. THis will work well
if you r windows user is part od Admin group.
Thanks
Hari
"Jack" <bradnerdhss@.hotmail.com> wrote in message
news:1171849045.996306.258230@.s48g2000cws.googlegroups.com...
> Hello,
> Is it possible to get or change the existing sa password for microsoft
> sql server 2000 as i've forgotten it?
> I'm able to use Enterprise Manager by via Windows Authentication, but
> i need to connect to a database with SQL Authentication.
> Thanks,
> jack.
>|||On Feb 19, 11:19 am, "Hari Prasad" <hari_prasa...@.hotmail.com> wrote:
> Hello,
> YOu can not see the password, but you can change the password. All you have
> to do is:-
> 1. Login into the query analyzer using windows authentication
> 2. Execute the below query to change the SA password
> sp_password NULL,'Newpassword','sa'
> This will change the password of SA to a new password. THis will work well
> if you r windows user is part od Admin group.
> Thanks
> Hari
> "Jack" <bradnerd...@.hotmail.com> wrote in message
> news:1171849045.996306.258230@.s48g2000cws.googlegroups.com...
>
> > Hello,
> > Is it possible to get or change the existing sa password for microsoft
> > sql server 2000 as i've forgotten it?
> > I'm able to use Enterprise Manager by via Windows Authentication, but
> > i need to connect to a database with SQL Authentication.
> > Thanks,
> > jack.- Hide quoted text -
> - Show quoted text -
Yes thanks. That worked perfectly.
Jack.

Get table_names and column_names

I want to create a function(procedure) which find all my table_names and (column names in those tables) in my database. Do anyone know of a existing function that retrives these names?You can use the INFORMATION_SCHEMA.Columns view for this information.

SELECT * FROM INFORMATION_SCHEMA.Columns

There is also a view called Tables which might be of interest to you.

Terri

get max row size for every table

SQL Server 2000 has a max size of 8k per row limit. In an existing database,
how do I find out to get the tables that have this problem.
Is there a procedure that I can use or a sql script?
Magic
SELECT ob.name [Table Name], sum(col.length) [Max column Length]
from sysobjects ob, syscolumns col
where ob.id = col.id and ob.xtype = 'U'
group by ob.name
"Magic" <Magic@.discussions.microsoft.com> wrote in message
news:BC335A68-429E-4246-ABD9-55928A00F3AD@.microsoft.com...
> SQL Server 2000 has a max size of 8k per row limit. In an existing
database,
> how do I find out to get the tables that have this problem.
> Is there a procedure that I can use or a sql script?

get max row size for every table

SQL Server 2000 has a max size of 8k per row limit. In an existing database
,
how do I find out to get the tables that have this problem.
Is there a procedure that I can use or a sql script?Magic
SELECT ob.name [Table Name], sum(col.length) [Max column Length]
from sysobjects ob, syscolumns col
where ob.id = col.id and ob.xtype = 'U'
group by ob.name
"Magic" <Magic@.discussions.microsoft.com> wrote in message
news:BC335A68-429E-4246-ABD9-55928A00F3AD@.microsoft.com...
> SQL Server 2000 has a max size of 8k per row limit. In an existing
database,
> how do I find out to get the tables that have this problem.
> Is there a procedure that I can use or a sql script?

get max row size for every table

SQL Server 2000 has a max size of 8k per row limit. In an existing database,
how do I find out to get the tables that have this problem.
Is there a procedure that I can use or a sql script?Magic
SELECT ob.name [Table Name], sum(col.length) [Max column Length]
from sysobjects ob, syscolumns col
where ob.id = col.id and ob.xtype = 'U'
group by ob.name
"Magic" <Magic@.discussions.microsoft.com> wrote in message
news:BC335A68-429E-4246-ABD9-55928A00F3AD@.microsoft.com...
> SQL Server 2000 has a max size of 8k per row limit. In an existing
database,
> how do I find out to get the tables that have this problem.
> Is there a procedure that I can use or a sql script?