The Why do I get error "Client unable to establish connection: OS Error: 'Connection refused'" and Why do I get error "Client unable to establish connection: Server not configured for TCP connection".
-u and -a options.
If you usually connect to SQL Server through your Windows account, specify your Windows user name with -u. Use the format domain\user_name, where domain is the name of the Windows domain to which user_name belongs. Otherwise, specify a valid SQL Server user name.
Specify the password for your user name with -a.
For example:
./tdshelper -s 'MYSQLSERVER2005HOST\MYINSTANCEI' -u 'mydomain\mywindowsuser' -a mywindowspassword -v
–Or–
./tdshelper -s MYSQLSERVER2000HOST -u mysqlserveruser -a mysqlserverpassword -v
If tdshelper can successfully access the SQL Server instance with your user name and password, the output contains the following line:
tdshelper: succesfully logged into server with diagnostic records
When configuring an SQL Server ODBC driver data source to connect to this instance, the User and Password attribute values should be the same as the values you specified with the -u and -a options.
If tdshelper is unable to connect and displays a Login failed for user ''. The user is not associated with a trusted SQL Server connection. error, check that you specified a valid Windows user name and password. If tdshelper fails with an Login failed for user 'myuser'. error, check that you specified a valid SQL Server user name and password.
For information about other situations in which these errors display, refer to Why do I get error "Login failed for user ''. The user is not associated with a trusted connection" and Why do I get error "Login failed for user 'myuser'".
© 1993 - 2024 Easysoft Limited. All rights reserved. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other trademarks and registered trademarks appearing on easysoft.com are the property of their respective owners.
