Client access problems after domain change.

From: David Pounds (david.pounds_at_no_spam_briars.net)
Date: 02/22/05 

Date: Tue, 22 Feb 2005 12:56:31 +0000

Hi all.

Got a weird problem since changing the domain membership of a SQL server.

Since the change (including all client PC's and user accounts), when
opening the SQl client the error "SQL Server is unavailable or does not
exist" is returned repeatedly. After 20 minutes to half an hour, the
client logs on OK and stays on until the PC is rebooted.

I cannot figure out what is going on, I have no address resolution
issues on the domain and the SQL server has been published in AD. This
affects both XP and Win2K clients.

Anybody got any ideas - all gratefully accepted, no matter how wacky :)

Cheers,

Relevant Pages

  • Re: Best way to populate webpages from multiple tables
    ... tables within hash tables, custom classes etc. ... > Set a session expiring cookie at the client that stores the Customer ID. ... > send it to the client, instead store it in your session mgmt sql server - ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Best way to populate webpages from multiple tables
    ... tables within hash tables, custom classes etc. ... > Set a session expiring cookie at the client that stores the Customer ID. ... > send it to the client, instead store it in your session mgmt sql server - ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: SQL and Bandwidth use
    ... In addition to the other responses, take a look at the memory and CPU usage ... in Great Plains Client software. ... > near 100Mb/sec bandwidth). ... Client PC is on same segment as SQL server (not passing through ...
    (microsoft.public.sqlserver.server)
  • Re: SQL Server 2005 Express OLEDB Connection from VB6
    ... Thanks for getting me to read this again and realizing they meant the client ... I think we'll stick with ODBC, since there is less to install on the client ... Microsoft SQL Server Native Client ...
    (microsoft.public.sqlserver.connect)
  • RE: Im so confused
    ... Running a SELECT @@trancount just before calling sp_grantdbaccess will ... determine that expectation, consider the connection's IMPLICIT_TRANSACTIONS ... Were SQL Server to allow a developer the ability to execute ... upon a client. ...
    (microsoft.public.sqlserver.security)