Connection error

From: Erik vonBartheld (newsgroups@vonbartheld.net)
Date: 07/23/02 

From:     Erik vonBartheld <newsgroups@vonbartheld.net>
Date: Mon, 22 Jul 2002 15:33:57 -0700

Hi I live between two domains. Say I am in Domain A. I have a SQL
server in Domain B.

I have created an account (myaccount) and given it what I believe is the
proper permissions for accessing the DB on the SQL server.

Now I go to my client machine - try to register this new server using
the SQL account I created. After a few seconds I get the error.
SQL server registration failed because of the connection failure
displayed below. Do you wish....?
'Client unable to establish connection'
ConnectionOpen (CreateFile())

To register I have used the server name or IP and get the same problem.
I can get back a reply from pinging it so, I know it's on the network.

What can be the problem? We cannot use NT Authentication (at least I
don't think so) because the two domains are not trusted. Can you tell
me why the regular SQL authentication won't work EVEN if I try to
register using the SA account?

Thanks
Erik

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Relevant Pages

  • Re: SQL account rights
    ... Please advice what is the best, suitable rights rather than domain admin ... issues, such as a server that might have IIS running on the same machine, ... applicable to SQL 2000 environment, ... files, or backups, make sure that the service account has Full ...
    (microsoft.public.sqlserver.security)
  • RE: MP Install issue
    ... Where in the installation are you talking about specifying the account rather ... > MPDB ERROR - CONNECTION PARAMETERS ... > SQL Server Name: servername ... > with a trusted SQL Server connection. ...
    (microsoft.public.sms.setup)
  • Re: SQL Express Fails with Hardware Error
    ... The LocalSystem account is a built-in account, ... which the SQL Service runs. ... MCSE, CCEA, Microsoft MVP - Terminal Server ... Minimum Hardware Requirement (Warning) ...
    (microsoft.public.sqlserver.setup)
  • Re: SCCM with a remote SQL instance problems (IT IS NOT A WARNING)
    ... PreReq check is not a WARNING it is a FAILURE. ... account the run the SQL Server Service on the server, Domain Memberships, AD ...
    (microsoft.public.sms.installer)
  • Re: Distributed Query - Linked Servers?
    ... In the case of SQL style accounts, it doesn't seem very secure to me, because the password will be transmitted over the network. ... it should also be able to work by setting up a credential and proxy account on Server1. ... In this case it could work with NTLM authentication. ... we just need to verify that the 2 sql server instances are under sql server and windows authentication mode and the sql account you use has the permission on the 2 sql server instances. ...
    (microsoft.public.sqlserver.server)
Quantcast