Discussion :

[deathsurfer]

Bonjour à tous! J'aimerai me connecter à un serveur analysis services autre que "localhost".

Code :

Sélectionner tout - Visualiser dans une fenêtre à part

1
2
Dim rs As New Microsoft.AnalysisServices.Server
 rs.Connect("localhost")

Comment faire? Le nom du serveur est sql_server.
J'ai essayé rs.Connect("http://sql_server"), rs.Connect("sql_server") sans succès...
Merci à tous!

[boubounne]

essaye avec l'adresse IP, Je ne sait pas ce que ca peut donner c'est juste une idée..

[bouvda]

Bonjour,

essaie avec cette chaîne de connexion :

Code :

Sélectionner tout - Visualiser dans une fenêtre à part

1
2
Dim rs As New Microsoft.AnalysisServices.Server
 rs.Connect("Provider=MSOLAP.3;Password=MOT_DE_PASSE;Persist Security Info=True;User ID=UTILISATEUR;Data Source=SERVEUR")

[deathsurfer]

Avec l'adresse IP ça ne marche pas:

An existing connection was forcibly closed by the remote host
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Net.Sockets.SocketException: An existing connection was forcibly closed by the remote host

Source Error:


Line 12: If Not Page.IsPostBack Then
Line 13:
Line 14: rs.connect("192.168.0.104")
Line 15: Try
Line 16: For Each item3 In rs.Databases


Source File: C:\Inetpub\wwwroot\a\Administration\Autorisation\Page5.aspx.vb Line: 14

Stack Trace:


[SocketException (0x2746): An existing connection was forcibly closed by the remote host]
System.Net.Sockets.Socket.Receive(Byte[] buffer, Int32 offset, Int32 size, SocketFlags socketFlags) +1018171
System.Net.Sockets.NetworkStream.Read(Byte[] buffer, Int32 offset, Int32 size) +119

[IOException: Unable to read data from the transport connection: An existing connection was forcibly closed by the remote host.]
System.Net.Sockets.NetworkStream.Read(Byte[] buffer, Int32 offset, Int32 size) +267
System.IO.BufferedStream.Read(Byte[] array, Int32 offset, Int32 count) +194
Microsoft.AnalysisServices.DimeRecord.ForceRead(Stream stream, Byte[] buffer, Int32 length) +35
Microsoft.AnalysisServices.DimeRecord.ReadHeader() +37
Microsoft.AnalysisServices.DimeRecord..ctor(Stream stream) +100
Microsoft.AnalysisServices.DimeReader.ReadRecord() +74
Microsoft.AnalysisServices.TcpStream.GetResponseDataType() +74

[ConnectionException: A connection cannot be made. Ensure that the server is running.]
Microsoft.AnalysisServices.XmlaClient.Connect(ConnectionInfo connectionInfo, Boolean beginSession) +442
Microsoft.AnalysisServices.Server.Connect(String connectionString, String sessionId) +192
Microsoft.AnalysisServices.Server.Connect(String connectionString) +6
Autorisation5.Page_Load(Object sender, EventArgs e) in C:\Inetpub\wwwroot\a\Administration\Autorisation\Page5.aspx.vb:14
System.Web.UI.Control.OnLoad(EventArgs e) +99
System.Web.UI.Control.LoadRecursive() +47
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1061

Avec "Provider=MSOLAP.3;Password=MOT_DE_PASSE;Persist Security Info=True;User ID=UTILISATEUR;Data Source=SERVEUR" ca ne marche pas non plus:

The system detected a possible attempt to compromise security. Please ensure that you can contact the server that authenticated you
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.ComponentModel.Win32Exception: The system detected a possible attempt to compromise security. Please ensure that you can contact the server that authenticated you

Source Error:


Line 11:
Line 12: If Not Page.IsPostBack Then
Line 13: rs.Connect("Provider=MSOLAP.3;Password=Pass123;Persist Security Info=True;User ID=Administrator;Data Source=sql_server")
Line 14: Try
Line 15: For Each item3 In rs.Databases


Source File: C:\Inetpub\wwwroot\a\Administration\Autorisation\Page5.aspx.vb Line: 13

Stack Trace:


[Win32Exception (0x80004005): The system detected a possible attempt to compromise security. Please ensure that you can contact the server that authenticated you]
Microsoft.AnalysisServices.NTAuthentication.GetOutgoingBlob(Byte[] incomingBlob, Boolean& handshakeComplete) +297
Microsoft.AnalysisServices.XmlaClient.Authenticate(ConnectionInfo connectionInfo, DateTime startTime) +244

[ConnectionException: Authentication failed.]
Microsoft.AnalysisServices.XmlaClient.Authenticate(ConnectionInfo connectionInfo, DateTime startTime) +1096
Microsoft.AnalysisServices.XmlaClient.OpenTcpConnection(ConnectionInfo connectionInfo) +383
Microsoft.AnalysisServices.XmlaClient.Connect(ConnectionInfo connectionInfo, Boolean beginSession) +447
Microsoft.AnalysisServices.Server.Connect(String connectionString, String sessionId) +192
Microsoft.AnalysisServices.Server.Connect(String connectionString) +6
Autorisation5.Page_Load(Object sender, EventArgs e) in C:\Inetpub\wwwroot\a\Administration\Autorisation\Page5.aspx.vb:13
System.Web.UI.Control.OnLoad(EventArgs e) +99
System.Web.UI.Control.LoadRecursive() +47
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1061

Je suis assez bloqué quand même...

[deathsurfer]

bouvda, j'ai essayé rs.Connect("Provider=MSOLAP.3;Password=Pass123;Persist Security Info=True;User ID=sql_server\\Administrator;Data Source=sql_server") mais toujours la même erreur:

The system detected a possible attempt to compromise security. Please ensure that you can contact the server that authenticated you
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.ComponentModel.Win32Exception: The system detected a possible attempt to compromise security. Please ensure that you can contact the server that authenticated you

[boubounne]

Juste une idée, tu as vérifié les firewall ??? ils sont bien désactivés ??

[deathsurfer]

Oui oui l'ICS service est désactivé, donc pas de firewall...
Ce problème me

[deathsurfer]

j'ai tout reinstallé. Donc les deux machines sont bien dans le meme domaine, et quand j'utilise le logiciel Pivotview j'arrive a me connecter de la ws03 vers la machine srvsql2 (a distance donc)
J'utilise la meme chaine de connexion que celle utilisé dans PivotView qui est

Code :

Sélectionner tout - Visualiser dans une fenêtre à part

Provider=MSOLAP.3;Cache Authentication=False;Password=pass;User ID=administrator;Initial Catalog=piou;Data Source=srvsql2;Impersonation Level=Impersonate;Location=srvsql2;Mode=ReadWrite;Protection Level=Pkt Privacy;Auto Synch Period=20000;Default Isolation Mode=0;Default MDX Visual Mode=0;MDX Compatibility=0;MDX Unique Name Style=0;Non Empty Threshold=0;SQLQueryMode=Calculated;Safety Options=1;Secured Cell Value=0;SQL Compatibility=0;Compression Level=0;Real Time Olap=False;Packet Size=4096

pourtant quand je fais :

Code :

Sélectionner tout - Visualiser dans une fenêtre à part

1
2
Dim rs As New Microsoft.AnalysisServices.Server
rs.connect("Provider=MSOLAP.3;Cache Authentication=False;Password=pass;User ID=administrator;Initial Catalog=piou;Data Source=srvsql2;Impersonation Level=Impersonate;Location=srvsql2;Mode=ReadWrite;Protection Level=Pkt Privacy;Auto Synch Period=20000;Default Isolation Mode=0;Default MDX Visual Mode=0;MDX Compatibility=0;MDX Unique Name Style=0;Non Empty Threshold=0;SQLQueryMode=Calculated;Safety Options=1;Secured Cell Value=0;SQL Compatibility=0;Compression Level=0;Real Time Olap=False;Packet Size=4096")

cette erreur est renvoyée:

An existing connection was forcibly closed by the remote host
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Net.Sockets.SocketException: An existing connection was forcibly closed by the remote host
Stack Trace:


[SocketException (0x2746): An existing connection was forcibly closed by the remote host]
System.Net.Sockets.Socket.Receive(Byte[] buffer, Int32 offset, Int32 size, SocketFlags socketFlags) +1018171
System.Net.Sockets.NetworkStream.Read(Byte[] buffer, Int32 offset, Int32 size) +119

[IOException: Unable to read data from the transport connection: An existing connection was forcibly closed by the remote host.]
System.Net.Sockets.NetworkStream.Read(Byte[] buffer, Int32 offset, Int32 size) +267
System.IO.BufferedStream.Read(Byte[] array, Int32 offset, Int32 count) +194
Microsoft.AnalysisServices.DimeRecord.ForceRead(Stream stream, Byte[] buffer, Int32 length) +35
Microsoft.AnalysisServices.DimeRecord.ReadHeader() +37
Microsoft.AnalysisServices.DimeRecord..ctor(Stream stream) +100
Microsoft.AnalysisServices.DimeReader.ReadRecord() +74
Microsoft.AnalysisServices.TcpStream.GetResponseDataType() +74

[ConnectionException: A connection cannot be made. Ensure that the server is running.]
Microsoft.AnalysisServices.XmlaClient.Connect(ConnectionInfo connectionInfo, Boolean beginSession) +442
Microsoft.AnalysisServices.Server.Connect(String connectionString, String sessionId) +192
Microsoft.AnalysisServices.Server.Connect(String connectionString) +6
Autorisation5.Page_Load(Object sender, EventArgs e) in C:\Inetpub\wwwroot\a\Administration\Autorisation\Page5.aspx.vb:22
System.Web.UI.Control.OnLoad(EventArgs e) +99
System.Web.UI.Control.LoadRecursive() +47
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1061