Unable To Connect To Analysis Service Using HTTP On A Different Server

May 18, 2007

Hi all,



This one has really stumped me! I set up HTTP to connect to an Analysis Services cube within an ASP .NEt application. On inititial setup it worked well and I was able to connect and view the data in my ASP application.



However, for NO reason that I can see it is now coming up with the following error:







Either a connection cannot be made to the localhost server, or Analysis Services is not running on the computer specified.



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.Runtime.InteropServices.COMException: Either a connection cannot be made to the localhost server, or Analysis Services is not running on the computer specified.






I have tried everything I can think of to fix it but can't get it to work. I have even gone through the technet document titled "Resolving Common Connectivity Issues in SQL Server 2005 Analysis Services Connectivity Scenarios" but it hasn't helped.



I am using SQL Server (Analysis Services) 2005 and ASP .NET 2.0. The application is developed in VS 2005.



I'm at a loss...can you help?



Cheers in advance!

View 1 Replies


ADVERTISEMENT

HTTP Connection Manager Err:unable To Connect To Remote Server

Jan 23, 2007



Hi all,

i am trying to consume an webservice which under secure layer (HTTPS)

eg: https://test.com/test.asmx

i'm connected thro' a proxy server.

when i use the same url in IE it works fine, but when i connect thro' http connection manager it always throws me a error saying "unable to connect to remote server "

can anyone provide me solution to over come this problem

View 1 Replies View Related

Unable To Connect To HTTP Endpoint Using Digest Authentication On A Server 2003 PDC

Jan 31, 2007

I am just about ready to tear my hair out on this one, at this point you guys are my last resort! Wouldn't it be nice if I could go to bed and have an answer for me in the morning....

I've had a working HTTP endpoint using Basic Authentication over SSL for months in our development environment, but now I'm moving our application to a production server and I'd like to be able to use Digest Authentication in the clear instead so the processor doesn't waste cycles on the SSL decryption. I've spent hours fiddling with my endpoint to no avail.

This is the closest message relating to what I'm doing that I've been able to find: http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1131251&SiteID=1

In my case, the SQL Server is joined to a domain that is entirely Windows Server 2003 - no Windows 2000, so support for Digest Authentication is a non-issue. I'm also explicitly doing a GRANT CONNECT on my endpoint to the domain user I'm using. Here is the top of my CREATE ENDPOINT DDL:

CREATE ENDPOINT [Kudos] 
    STATE=STARTED
    AS HTTP (PATH=N'/Kudos',
        PORTS = (CLEAR),
        AUTHENTICATION = (DIGEST,NTLM),
        SITE=N'echobase.kudosnow.com'
        DEFAULT_LOGON_DOMAIN = N'kudosnow',
        AUTH_REALM = N'kudosnow'',
        CLEAR_PORT = 80,
        COMPRESSION=DISABLED)
    FOR SOAP (

I am debugging using wfetch 1.3... I can get this to work using NTLM Authentication; sending a GET to my endpoint with the ?wsdlsimple querystring parameter returns my WSDL just fine.

But Digest just doesn't want to work! If I remove NTLM from my AUTHENTICATION directive and try using Digest with wfetch or from my (PHP) web service consumer I get an HTTP 401 no matter what I do. I've tried fiddling with the DEFAULT_LOGON_DOMAIN, AUTH_REALM, and anything else I can think of.

The errors I am sporadically finding in the SQL Server error log are:

HTTP authentication failed. [CLIENT: 192.168.245.238] from source Logon

Followed by:

Error: 26026, Severity: 14, State: 1. from source Logon

I can't find any detail about the second error.

........

Just occurred to me that I've also been trying to view my WSDL directly in IE, and this is what's causing the SQL error to be logged, not wfetch - that's why it appeared sporadically.

So, wfetch isn't causing an 'HTTP authentication failed' error, but Internet Explorer is... maybe Digest Authentication isn't implemented correctly in wfetch?

Regardless... I'm still not able to authenticate from IE or from my client, but this may shed some more light on the issue.

Does anyone have any ideas?

View 4 Replies View Related

Cannot Connect To SQL Report Server Through Web As Well As Management Studio (Http:503 Error Service Unavailable.)

Apr 10, 2007

hi all,
i have SQL 2205 with SP1 installed on my machine.
and i m not bale to connect to Report Server using SQL management studio as well as from web.

i have installed reporting server and database on same machine. i tried using

"http://localhost/reportserver"
"http://localhost/reports"
"http://localhost/reportmanager"

but i am not bale to connect i am getting "Service Unavailable" page.

and when i try to connect using SQL Management Studio with "servername/instance" as well as "http://localhost/reportserver" i am getting a error saying.

===================================
Cannot connect to http://localhost/reportserver.The request failed with HTTP status 503: Service Unavailable. (Microsoft.SqlServer.Management.UI.RSClient)

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

but if i try and connect to other reporting server on other machine using web http://servername/reportserver i m able to connect it.
but dont know whats the problem on my machine.

do i need to start any services for this...

so anybody knows how to troubleshoot this issue.

Thanks in advance...

View 1 Replies View Related

Unable To Connect To Analysis Server From EXCEL

May 30, 2008



Hi,

I have Installed Analysis Services on Windows 2000 Server.
There is no Active Directory and no Domain configured.
All client PCs and the server are part of Workgroup.
I have also installed MS SQL Server on this Server and
an instance of MS SQL Express edition on this server.
There is no Firewall, no Office and no IIS installed on this server.

When I use Analysis Manager on the server, I am able to connect to the Sample Database
and browse/edit the cubes. Similarly I am also able to use the Sample MDX application.

However, when I try to connect to the same database from my Laptop (Vista home premium/Office 2007)
- either using Analysis Manager or From EXCEL, I am not able to connec to it.

The Excel gives me following error:
"The following system error occurred: No Connection could be made because the target machine actively refused it"

And Analysis Manager does not register the server. It gives me a different error:
"Errors occurred while connecting to INTRANETNT. Cannot open connection to Analysis server 'INTRANETNT'.
Security error [The user could not be authenticated]'' Do you still want to register this server?"

I am able to connect the SQL Server database from EXCEL from my laptop

I checked following:
I am able to do a telnet on port 1433 on my server from my PC - and it connects.

Please advise what should I do to sort out the problem. This is my first exposure to Analysis Server

Regards
Madhup

View 5 Replies View Related

Unable To Connect To SQL Server After Service Restart

Oct 19, 2004

Hi

We have been having a problem with on of our servers, applications connecting to it are experiencing poor performance, even though the server is only running at a peak of 50%.

The odd thing is that after a sql service restart we couldnt connect at all on the SQL port. We were only able to re-connect after rebooting the actuall box. Is there anything that can be done about this? Its strting to look like a network related problem instead of SQL

View 5 Replies View Related

Configure Reporting Service - Unable To Connect To The Remote Server

Feb 20, 2008

Vista + SQL Server 2005
Reporting Service Configuration Tool: No Red Cross.
http://localhost/reportserver get this error:
HTTP Error 403.1 - Forbidden
You have attempted to run a CGI, ISAPI, or other executable program from a directory that does not allow executables to run.
http://localhost/reports get this error:
w3wp!ui!4!20/02/2008-17:17:04:: e ERROR: Unable to connect to the remote server
w3wp!ui!4!20/02/2008-17:17:04:: e ERROR: HTTP status code --> 500
-------Details--------
System.Net.WebException: Unable to connect to the remote server ---> System.Net.Sockets.SocketException: No connection could be made because the target machine actively refused it 127.0.0.1:443
at System.Net.Sockets.Socket.DoConnect(EndPoint endPointSnapshot, SocketAddress socketAddress)
at System.Net.Sockets.Socket.InternalConnect(EndPoint remoteEP)
at System.Net.ServicePoint.ConnectSocketInternal(Boolean connectFailure, Socket s4, Socket s6, Socket& socket, IPAddress& address, ConnectSocketState state, IAsyncResult asyncResult, Int32 timeout, Exception& exception)
--- End of inner exception stack trace ---
at System.Net.HttpWebRequest.GetRequestStream()
at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String methodName, Object[] parameters)
at Microsoft.SqlServer.ReportingServices2005.ReportingService2005.ListSecureMethods()
at Microsoft.SqlServer.ReportingServices2005.RSConnection.GetSecureMethods()
at Microsoft.ReportingServices.UI.Global.RSWebServiceWrapper.GetSecureMethods()
at Microsoft.SqlServer.ReportingServices2005.RSConnection.IsSecureMethod(String methodname)
at Microsoft.SqlServer.ReportingServices2005.RSConnection.ValidateConnection()
at Microsoft.ReportingServices.UI.ReportingPage.EnsureHttpsLevel(HttpsLevel level)
at Microsoft.ReportingServices.UI.ReportingPage.ReportingPage_Init(Object sender, EventArgs args)
at System.EventHandler.Invoke(Object sender, EventArgs e)
at System.Web.UI.Control.OnInit(EventArgs e)
at System.Web.UI.Page.OnInit(EventArgs e)
at System.Web.UI.Control.InitRecursive(Control namingContainer)
at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
w3wp!ui!4!20/02/2008-17:17:06:: e ERROR: Exception in ShowErrorPage: System.Threading.ThreadAbortException: Thread was being aborted.
at System.Threading.Thread.AbortInternal()
at System.Threading.Thread.Abort(Object stateInfo)
at System.Web.HttpResponse.End()
at System.Web.HttpServerUtility.Transfer(String path, Boolean preserveForm)
at Microsoft.ReportingServices.UI.ReportingPage.ShowErrorPage(String errMsg) at at System.Threading.Thread.AbortInternal()
at System.Threading.Thread.Abort(Object stateInfo)
at System.Web.HttpResponse.End()
at System.Web.HttpServerUtility.Transfer(String path, Boolean preserveForm)
at Microsoft.ReportingServices.UI.ReportingPage.ShowErrorPage(String errMsg)



I googled but not found anything useful.
Thanks in advance!!!

View 8 Replies View Related

How To Connect To Analysis Service Database Through Reporting Service?

Mar 31, 2006

Hello,

In our project, we would like to use the same data source for our analysis service database cubes and for our reporting service reports.

I created the analysis service project first, deployed successfully. When trying to setting up the data source in the report model project, I selected the "create a data source based on another object", and then selected the "create a data source based on an analysis service project". However, there is no analysis service project to select, and no browse button to see where the reporting service is looking for analysis service project either.

I have tried creating a new analysis service project with data source views, cubes, dimensions and all the stuff, but still cannot see the analysis service project in the drop down box to be selected for my reporting model project data source.

As I am fairly new to the reporting service, I'm sure I'm missing something, but couldn't find much information in the help or on the web. Any suggestion would be much appreciated.

Thank you very much,

Annie

View 5 Replies View Related

Unable To Install Analysis Service SP3

Jun 18, 2004

Hi,

I was facing problems applying SP3 for Analysis Services so I removed it and then re-installed.

I then tried to apply SP3 but I am still getting v8.00.382 for AS (which represents SP1). I have tried a couple of things but it seems that SP3 is just not getting applied (for Analysis Services).

Anyone any clues? Thanks.

View 6 Replies View Related

Unable To Install Analysis Service SP3

Jun 18, 2004

Hi,

Shortly after I run the setup file of AS SP3, I get a Dialog box with the following error message:

"An error occurred during the move data process: -145"

Can someone please guide what this is and how this can be solved.

Many many thanks in advance.

View 3 Replies View Related

Unable To Start MS Analysis Service

Apr 28, 2004

Hi Gurus,

I have installed MS analysis service(OLAP) on my lap top

my user is in the Administrative group , other than that I tried creating a user with 'OLAP ADMINISTRATOR' privilate and tried to start the ms analysis service

I am getting the error , unable to start the service on server(), you are not a member of OLAP Administrators group

I tried to install the service pack 3 from Microsoft

Could you pleae guide me to start this serivice
Thanks,

View 2 Replies View Related

SQL 2012 :: Unable To Connect To Analysis Services

Apr 30, 2014

Currently we are unable to connect to analysis services and getting the below error

Element 'return' was not found.Line 5,position 2

What could be causing this?

View 1 Replies View Related

Unable To Archive Analysis Service Database

Mar 7, 2007

Hi

For strange reasons, I am now unable to backup (archive) any of the databases in Analysis Service. :eek:

When I try to archive, I get a dialog box with the following error:

"[MicroSoft][ODBC Driver Manager] Data source name not found and no default driver specified"

I am able to process my cubes and dimensions and am totally lost as to why I'm getting this problem :S

Will appreciate your help.

Thanks.

View 2 Replies View Related

Configuring Http Access To SQL Server 2005 Analysis Services On Vista

May 25, 2008

Does anyone have instructions on how to configure http access to SQL Server 2005 Analysis Services on Vista?

View 5 Replies View Related

Connect To HTTP-Endpoint With SQL-Server Authentication?

Apr 24, 2008

Hello,

I created a HTTP-Endpoint on SQL Server 2005. Now I try to call this web service from a c# client but using SQL-Server authentication (i.e. my user is a sql server user but not a windows user). But it doesn't work.
I can connect to the service using a windows user and NTLM authentication. But for some reasons Iwould much prefer if I could use SQL-Server authentication. Is it possible?

Here is how I created the endpoint:




Code Snippet
CREATE ENDPOINT myService
STATE = STARTED
AS HTTP(
PATH = '/services',
AUTHENTICATION = (INTEGRATED ),
PORTS = ( SSL ),
SITE = '*'
)
FOR SOAP (
WEBMETHOD 'GetStuff'
(name='MyDB.dbo.FKT_getStuff',
SCHEMA=STANDARD ),
WSDL = DEFAULT,
LOGIN_TYPE = MIXED,
SCHEMA = STANDARD,
DATABASE = 'MyDB',
NAMESPACE = 'Services'
);
GO






Thanks!
Jerma

View 5 Replies View Related

SQL Server 2005 Integration Service (SSIS) Reading HTTP Data

Jan 16, 2008



I need to read in general web pages (not a web service) from a typical web site using SSIS and make it available for other SSIS transformations (Script Component). I tried using the XMLSource data source but this appears to require well formed XML, and will not accept HTML which is what I am likely to be getting from the web pages.
I tried a HTTP Connection Manager with a DataReader Source, but seems to only accomodate web services.

Can this be done? If someone has an example (tutorial) of how to accomplish this I would greatly appreciate a copy.
James

View 1 Replies View Related

Connecting To Analysis Services Using HTTP

Jul 20, 2005

my analysis server is hosted on a win2k server with IIS, the hosting page ison another machine. I have followed everything as per MS KB article and Icould not connect through the analysis server using http. i have similarimplementation on my dev machine but the main difference is my OLAP is ontop of winxp. i just wanted to know if i am missing any other setting notspecified on the MS KB article on how to implement OLAP cube through HTTPover win2k operating system.note: i tried connecting to olap using the MDX sample application usingMSOLAP.2 provider and connecting through a simple office web component. Ithink the best way to test the connection is through the MDX sampleapplication that comes with Analysis Server installation.

View 2 Replies View Related

Analysis :: Excel 2013 Pivot-table / Grouping On Date That Comes From Analysis Service 2008?

Nov 24, 2015

I am using

SSAS: version 2008
Excel: version 2013

I am connecting to SSAS cube from Excel and I have date dimension with 4 fields (I have others but I don't use it for this case). I created 4 fields in order to test all possible scenarios that I could think of:

DateKey:
    - Type: System.Integer
    - Value: yyyyMMdd
Date:
    - Type: System.DateTime
DateStr0:
    - Type: System.String
    - Value: dd/MM/yyyy (note: I am not using US culture)
    - Example: 01/11/2015  
DateStr1:
    - Type: System.String
    - Value: %d/%M/yyyy (note: I am not using US culture) 
    - Example: 1/11/2015  

Filtering on date is working fine:

Initially, in excel, filtering on date was not working. But after changing dimensional type to time, and setting  DataType to Date, as mentioned in [URL] filter is working fine as you can see in the picture.Grouping on date is not working:

I have hierarchy in my Date dimension and I can group based on hierarchy, no problem. But user is used to pre-build grouping function of excel, and he wants to use that. Pre-build functions of Excel, Group and ungroup seems to be available as you can see in following picture:

But when user clicks 'Group', excel groups it as if it is a string, and that is the problem. User wants to group using pre-build grouping function available in Pivot table. I also find out that Power Pivot Table does not support this excel grouping functionality. And if I understood well, this pre-build grouping functionality of excel, needs to do calculation at run time, and that is not viable solution if you have millions of rows. So Power pivot table does not support pre-build grouping functionality of excel and hence we need to use dimension hierarchy to do the grouping. But I am not using Power Pivot table, I am using simple Pivot Table. So I expect grouping functionality to be working fine. Then I tried to do simple test. I created a simple data source in excel itself. And use it as source of my Pivot table. Then grouping is working fine. The only difference that I can see is (When double click the Measure value in Excel),For date values of my simple test, excel consider them as 'Date'.

For date values of my data coming from cube, excel consider them as 'General'

    2.1. But value here is same as it was in simple test.

    2.2. 'Date Filter' works just fine.

    2.3. If I just select this cell and unselect it, then excel change type to 'Date' though for that cell. 

    2.4. I have created 4 different types of fields in my date dimension thinking that values of attribute of my dimension might be the problem, but excel consider 'General' for all of them.

    2.5 This value (that can be seen when double clicking on measure) comes from 'Name Column' of the attribute. And the DataType defined is WChar. And I thought that might be the reason of issue. And I changed it to 'Date'. But SSAS does not allow it to change to 'Date' giving error : The 'Date' data type is not allowed for the 'NameColumn' property; 'WChar' should be used.

So, I don't know, what is the puzzle piece that I am missing.

1. Date filter works, group does not work

2. Excel consider it as 'General' string.

3. SSAS does not allow to change 'NameColumn' to Date.

View 2 Replies View Related

Change Reporting Services Default URL (From Http://server/reports To Http://CompanyReports)

Jul 31, 2007

I looked online and couldn't find anything to help me make this change. I want to change the default URL for reporting services to another url. Is this possible? Any assistance would be greatly appreciated.

View 3 Replies View Related

Connect To Analysis Server

Nov 2, 2004

Helo!

Analysis manager is not able to coonect to analysis server. I can't register server -> Network error [Internal error].

Tnx, E

View 3 Replies View Related

Cannot Connect To Analysis Server

Dec 21, 2004

I have installed sql 2k and analysis service 2k including sp3a on my PC with XP professional. When I try to connect to the olap service from the olap manager I get the "cannot open connection to the analysis server". Does any one has a clue on a solution???

View 1 Replies View Related

How Can I Connect To Analysis Server In C#?

Dec 11, 2007


Hi
I want a request about mining model; I have solicitation that if every one can help me, please read this request and give a simple mining model with time series algorithm.
For example if you want to predict sale€™s of good (e.g. book )for next month, you should have a column about the number of books that is sold for every month ,and we have the values of 11 month ago and now want to predict the value of 12th month for selling books and after predicting with time series and building a model, we see the result of prediction in the mining structure in sql ,also we can use query in the mining model prediction, we see this result in this software but if we want to see in a interface that is built with c# ,so we should create a connection with analysis server and mining structure ,so I should have the codes that beget this connection, so we need a button and a combobox and a textbox that the textbox use for showing the result of prediction and a button that you click on and the value of 12th month predict then you can see it in textbox and a combobox for choosing the name of customer(because in this project, we predict €œpurchasing book€? for one by one ,for every customers)
And if every body does this simple project for me, I say thank a lot
Please if you can help me, do this project with time series algorithm and build a c# form with up conditions and connect to analysis sever and put this file for reply me.
And if data were in the excel file and we want to use in the table how can do this work without that wihch import data?


please if you want to answer ,say simple becasue i am a tenderfoot user

View 1 Replies View Related

Cannot Connect To Analysis Server Using DM

Feb 14, 2008


I was trying to get setup with DM but have issues getting it to work.
I cannot connect to the Analysis server - both using the Server Configuration Utility, and by using the Connections tab within Data Mining Tab in Excel. the error that i get is:
Test Connection Failed.
The '18441' locale is not supported.

The analysis server is on a different machine, and i have tried both the IP and Host name to connect to the server.
I have admin privelleges on the server.
I have also installed the DM tools on the server, and given myself permissions to the analysis server.
However my SQL server 2005 may not be SP2, or maynot have the hotfix applied.
Will that cause the DM to fail connection?

Can you please give me some pointers on how to resolve this issue?

View 3 Replies View Related

Analysis :: Running Analysis Service In Terms Of Port Usage?

May 30, 2015

I would like to know the best practice for running analysis service in terms of port usage. Is it better to run on a specific port or have dynamic ports ? We have clustered servers that run default on 2383 but not sure with non clustered what's the best way to get performance.

View 2 Replies View Related

Analysis :: Creating Roles In Analysis Service Without AD Account

Aug 6, 2015

I want to find out if it is possible to create a role in a cube without an AD account, e.g. using a GMail email address.

View 3 Replies View Related

Cannot Connect To Analysis Server 'VMFGSRVR'

Jun 4, 2002

I am trying to register the analysis server from a w2k
client. The shortcut is executing "J:analysis
manager.msc".
I have applied analysis spsp2 to the client. Please note i
have the same setup on anothe w2k client.

View 2 Replies View Related

Connect To Remote Analysis Server

May 22, 2006

Hi,

How do I connect to a remote Analysis Server using SQL management studio on my local machine.

Thanks in advance..

View 7 Replies View Related

Unable To See Sqlserver/http Endpoint In Visual Studio

Jul 19, 2007

Hi,

I've created the following endpoint on a local database as follows,


CREATE ENDPOINT Wrox_EndPoint
STATE = STARTED
AS HTTP
(
SITE = 'localhost',
PATH = '/Wrox',
AUTHENTICATION = (INTEGRATED),
PORTS = ( CLEAR ),
CLEAR_PORT = 81
)
FOR SOAP
(
WebMethod 'GetProductCountByProductModelID'
(
NAME = 'adventureworks.dbo.ProductByProductModelID',
SCHEMA = STANDARD
),
WebMethod 'GetProductModels'
(
NAME = 'adventureworks.dbo.GetProductModels',
SCHEMA = STANDARD
),
WSDL = DEFAULT,
BATCHES = ENABLED,
DATABASE = 'AdventureWorks'
)

When I try to add a web reference in visualstudio to http://localhost/wrox?WSDL I get a 404 error.



I checked the web service is created in sys.http_endpoints



I've also run the following to grant permissions

USE MASTER
GO
GRANT CONNECT ON ENDPOINT::Wrox_EndPoint TO [myDomainpaulm]
GO



Any ideas where I'm going wrong?



Many thanks Paul

View 3 Replies View Related

OLAP Server Or SQL Analysis Service

Jul 24, 2006

Hi

I am new to SQL Server and not quite understand the difference between OLAP server or SQL Analysis Service. Are they referring to the same thing?? An user asked me to confirm that the OLAP server is active on a server running SQL Server 2005, what do I need to check. The Analysis service is up and running, does it mean it is OK??

Please advise.

Thanks.

View 2 Replies View Related

SQL Server Unable To Connect... Please Help

Jan 14, 2000

I upgraded my 6.5 server to 7.0 two days ago running into small problems with the database upgrade wizard. I had some small problems with security which took me some time but was not that difficult once I figured it out. I then proceeded to switch back to 6.5 mode to transfer all the data that had been done that day to my development machine so I could then import it to the SQL 7.0 version. When I was done with the transfer I switched back successfully, started the server successfully, but I was unable to connect. I get the error "Connection could not be established...", so after several attempts to connect and shuting the server down I now am at a loss. The server runs fine in 6.5 mode but it will not connect in 7.0?? Tonight I am going to try to reinstall SP1, if that does not work I am going to try to reinstall SQL 7.0. Any suggestions???

View 2 Replies View Related

Unable To Connect To Server

Nov 14, 2000

On a fresh installation of SQL Server 6.5, I have
opened the EM and registered the server but am unable
to connect. I get the error of 'A connection could not
be established to [ServerName]- [DB-Library] Unable
to connect: SQL Server is unavailable or does not exist.
General Network Error. Check your documentation.'

I've tried connecting with all different DB-Lib settings
to no avail. Ultimately, I want to use TCP/IP. I am,
however, able to connect to other SQL Server boxes from
this EM, just not the local server. I am able to stop
and start the services from Control Panel and from SQL
Service Manager.

Since I haven't been able to log into the local SQL Server,
I've registered the server in EM to log in with sa and a
blank password. I've already completely uninstalled SQL
and reinstalled it to see if that would help. It didn't.

Does anyone have any idea what the problem could be?

Thank you!
Toni

View 7 Replies View Related

Unable To Connect To Server

Jan 20, 2003

Hi,

I am running SQL 2000 on Windows 2000 Server. The clients are running different OS ranging from Win 98/NT/2000. Although i am able to connect to the local host, but whenever i try to connect over the network the following error pops up :

unable to connect to server <server name>
Server : Msg 11, Level 16, State 1
[Microsoft][ODBC SQL Server Driver][TCP/IP Socket]General network error. Check your network documentation.

I checked up the event long on the server and found the following entry:

Event Type: Warning
Event Source: MSSQL$NETSDK
Event Category: (8)
Event ID: 19011
Date: 1/20/2003
Time: 2:12:32 PM
User: N/A
Computer: <computer name>
Description:
The description for Event ID ( 19011 ) in Source ( MSSQL$NETSDK ) 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:
(SpnRegister) : Error 1355.

May i further clarify that this error started today n till last week end (saturday, i am

stationed in India) there was no problem and the users were able to connect to the server

without any problem. My network engineer feels that its an sql problem and has nothing to do with network related issues.

i would appreciate if anybody could help me out. thanking in advance

- Paramesh

View 4 Replies View Related

Unable To Connect To Sql Server

Nov 20, 2003

recently i made my PC dual boot by installing windows 2000 advanced server. It already had win2000 profesional installed on it. since then i have been unable to connect to sql server running on some other server(called CONTROLS) on the LAN. I am able to access the CONTROLS server thru 'my networkplaces' and able to see all its hsared directories and access htem. but when i open Enterprise manager i cannot connect to CONTROLS.
Please help me . i have already wasted 2 days over it.

View 3 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved