ODBC Issue

When I attempt to connect to an SQL server via ODBC, I get the following
error :
Error on connection:
> SQL State: '01000'
> SQL Server Error 10061
> [Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]ConnectionOpen
(Connect())
> Error on connection:
> SQL State: '08001'
> SQL Server Error 17
> [Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]SQL Server does
not exist
> or access denied
However,
When I log on to the computer I am on as a different user, I can make
the connection. The users are both administrators of the local machine and
I am connecting via SQL Authentication, sa account. Is there is something
in the user's profile that would prohibit him from connecting to the remote
SQL box ? Maybe something in HKEY_CURRENT_USER in the registry ?
Thanks in advance for your help..Hello sqlnewbie,
Did the error occur when you connect to SQL server locally? Or did the
issue occur when you connect to SQL server remotely?
If the problem occurs when you connect to SQL server from a client
computer, please try to connect to SQL server from another computer. If the
issue only occurs on one computer, the problem is specially related to the
problematic computer or user.
If the issue occurs on the computer which have SQL server installed, please
check if you can connect to SQL server using SQL Query Analyzer(QA).
I recommend you refer to the steps in the following article to troubleshoot
the issue:
Potential causes of the "SQL Server does not exist or access denied" error
message
http://support.microsoft.com/?id=328306
I hope the information is helpful.
Sophie Guo
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
=====================================================When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||It occurs on a remote computer, but only with one particular user. It would
be simple enough to delete the user and re-create it, but there has to be a
reason why this is happening...
"Sophie Guo [MSFT]" <v-sguo@.online.microsoft.com> wrote in message
news:%239Us3TgJFHA.3548@.TK2MSFTNGXA02.phx.gbl...
> Hello sqlnewbie,
> Did the error occur when you connect to SQL server locally? Or did the
> issue occur when you connect to SQL server remotely?
> If the problem occurs when you connect to SQL server from a client
> computer, please try to connect to SQL server from another computer. If
> the
> issue only occurs on one computer, the problem is specially related to the
> problematic computer or user.
> If the issue occurs on the computer which have SQL server installed,
> please
> check if you can connect to SQL server using SQL Query Analyzer(QA).
> I recommend you refer to the steps in the following article to
> troubleshoot
> the issue:
> Potential causes of the "SQL Server does not exist or access denied" error
> message
> http://support.microsoft.com/?id=328306
>
> I hope the information is helpful.
> Sophie Guo
> Microsoft Online Partner Support
> Get Secure! - www.microsoft.com/security
> =====================================================> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> =====================================================> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>
>
>|||Hello,
I understand that the issue occurs only when logging on as a particular
user; however, many factors can cause the issue. If you'd like to know the
root cause, I suggest you perform the steps in the "Client-related or
application-related causes" section in the following article 328306:
Potential causes of the "SQL Server does not exist or access denied" error
message
http://support.microsoft.com/?id=328306
If the issue still exists, you can refer to the following article:
How to troubleshoot connectivity issues in SQL Server 2000 (827422)
http://support.microsoft.com/default.aspx?scid=KB;EN-US;827422
It might be difficult because the cause might be user profile corruption. I
recommend you create a new profile to migrate files & settings from
original one.
I hope the information is helpful.
Sophie Guo
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
=====================================================When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================This posting is provided "AS IS" with no warranties, and confers no rights.