Re: SQL authentication

[CJohnson]

Check the network and client libraries and make sure everyone is using the
same protocol.

That should clear it up.
--Charles


                                                                                       
                   
                    Terence Choy                                                       
                   
                    <terencec@nan        To:     "NT System Admin Issues"              
                   
                    cys.com>             <[EMAIL PROTECTED]>       
                   
                                         cc:                                           
                   
                    09/12/2001           Subject:     SQL authentication               
                   
                    03:34 PM                                                           
                   
                       Please                                                          
                   
                    respond to                                                         
                   
                    "NT System                                                         
                   
                    Admin Issues"                                                      
                   
                                                                                       
                   
                                                                                       
                   




Hi,
I have a MS SQL question and I understand this is not the forum for it, but
I would really appreciate if someone will help here or point me to the
right
places!  Here is my situation:
A standalone NT4 computer loaded with SQL 7 (can't join the domain because
the main application in this computer won't work).
A NT4 member server loaded with Veritas 8.6 and SQL 2000 for backup
operation.

I need to backup the SQL 7 databases in the standalone machine by using the
backup member server.  The problem is I cannot connect to the SQL 7
databases from the member server.  When I tried in the SQL 2000 Enterprise
Manager to create a new SQL Server group for the standalone computer with
SQL 7, it failed to connect by either using the Windows NT authentication
or
the SQL Server authentication.  What do I miss?  TIA.

Terence Choy

http://www.sunbelt-software.com/ntsysadmin_list_charter.htm






http://www.sunbelt-software.com/ntsysadmin_list_charter.htm