Offisite DB Connection Failure

I am trying to write a simple program for test purpose with VB .Net 2005 and SQL Server Express 2005. My server is not even in the same state as me, but I have the following on the server:

Server 2003 Web Edition SP1
SQL Server Express 2005

I am writing in the following:
Visual Basic 2005 Pro Edition

I have read where you can setup Express to allow TCP/IP connection, and I have done what it stated HERE (http://www.datamasker.com/SSE2005_NetworkCfg.htm). However, I am still not able to connect to the DB on the remote server.

I go to:
Tools --> Connect to Server --> Type IP and get the connection failed to connec to server "xxx.xxx.xxx.xxx"
I even tried:
Tools --> Connect to Server --> Type IP\SQLEXPRESS and get the connection failed to connec to server "xxx.xxx.xxx.xxx"

Has anyone been able to do this, or am I wasting my time? If I can get the SQL Server to do as requested then I am going to purchase and work with it, however, I want to test out before I spend the $$$$$ to begin the full project. If anyone can be of assistance here I would appreciate it.

Thanks in advance.Can you access the server on a remote machine on the same location as the server is (that is, in the same domain, at least without going through a firewall) ? It might have something to do with TCP/IP port 1433 that is not opened in the firewall ... and believe me, you don't want that !!!
Is your SQL server directly accessible from the Internet with IP address xxx.xxx.xxx.xxx ? Or should some routing be done because it's behind a firewall ? I would check your network admin for some assistence ...

Gr,
Yveausql

ODS

In the Event Log I'm received next message:
Source: MSSQLServer
Category: ODS
ID: 17052
Error: 17833, Severity: 18, State: 1 yyyy-mm-dd hh:mm:ss ods ListenOn
connection 'servername' is already in use.
But my SQL Server are working normally.
What's a problem?
Michael S. Androsov
EXPOCENTRHi,
Another application or service running in the server would have taken
control of the port before SQL Server starts.
Have a look into the below article.
http://support.microsoft.com/default.aspx?scid=kb;EN-US;293107
Thanks
Hari
MCDBA
"Michael S. Androsov" <androsov@.expocentr.ru> wrote in message
news:f99f3e13.0403030156.77a793c5@.posting.google.com...
> In the Event Log I'm received next message:
> Source: MSSQLServer
> Category: ODS
> ID: 17052
> Error: 17833, Severity: 18, State: 1 yyyy-mm-dd hh:mm:ss ods ListenOn
> connection 'servername' is already in use.
> But my SQL Server are working normally.
> What's a problem?
> Michael S. Androsov
> EXPOCENTR|||"Hari" <hari_prasad_k@.hotmail.com> wrote in message news:<OkydjcQAEHA.712@.tk2msftngp13.phx.gbl>...
> Hi,
> Another application or service running in the server would have taken
> control of the port before SQL Server starts.
> Have a look into the below article.
> http://support.microsoft.com/default.aspx?scid=kb;EN-US;293107
> Thanks
> Hari
> MCDBA
> "Michael S. Androsov" <androsov@.expocentr.ru> wrote in message
> news:f99f3e13.0403030156.77a793c5@.posting.google.com...
> > In the Event Log I'm received next message:
> > Source: MSSQLServer
> > Category: ODS
> > ID: 17052
> > Error: 17833, Severity: 18, State: 1 yyyy-mm-dd hh:mm:ss ods ListenOn
> > connection 'servername' is already in use.
> >
> > But my SQL Server are working normally.
> >
> > What's a problem?
> >
> > Michael S. Androsov
> > EXPOCENTR
I have't other applications working with 1433 or 1118 ports. If this
applications exist my SQL Server will not working. But now the server
is working.
Michael S. Androsov
EXPOCENTR

ODS

In the Event Log I'm received next message:
Source: MSSQLServer
Category: ODS
ID: 17052
Error: 17833, Severity: 18, State: 1 yyyy-mm-dd hh:mm:ss ods ListenOn
connection 'servername' is already in use.
But my SQL Server are working normally.
What's a problem?
Michael S. Androsov
EXPOCENTRHi,
Another application or service running in the server would have taken
control of the port before SQL Server starts.
Have a look into the below article.
http://support.microsoft.com/defaul...kb;EN-US;293107
Thanks
Hari
MCDBA
"Michael S. Androsov" <androsov@.expocentr.ru> wrote in message
news:f99f3e13.0403030156.77a793c5@.posting.google.com...
> In the Event Log I'm received next message:
> Source: MSSQLServer
> Category: ODS
> ID: 17052
> Error: 17833, Severity: 18, State: 1 yyyy-mm-dd hh:mm:ss ods ListenOn
> connection 'servername' is already in use.
> But my SQL Server are working normally.
> What's a problem?
> Michael S. Androsov
> EXPOCENTR|||"Hari" <hari_prasad_k@.hotmail.com> wrote in message news:<OkydjcQAEHA.712@.tk2msftngp13.phx.
gbl>...
> Hi,
> Another application or service running in the server would have taken
> control of the port before SQL Server starts.
> Have a look into the below article.
> http://support.microsoft.com/defaul...kb;EN-US;293107
> Thanks
> Hari
> MCDBA
> "Michael S. Androsov" <androsov@.expocentr.ru> wrote in message
> news:f99f3e13.0403030156.77a793c5@.posting.google.com...
I have't other applications working with 1433 or 1118 ports. If this
applications exist my SQL Server will not working. But now the server
is working.
Michael S. Androsov
EXPOCENTR

Odd null behavior

I am writing an upsert proc that should detect the change in state for a record. The change in state happens when a particular date field (default null) is populated. However, I can not get a record set that detects the changes properly.

Here is an example
set ANSI_NULLS on
go
create table #t1
(
ID int,
DateField datetime
)

create table #t2
(
ID int,
DateField datetime
)

insert into #t1 (ID, DateField) values (1, '7/20/2006')
insert into #t2 (ID, DateFIeld) values (1, null)

select * from #t1 join #t2 on #t1.ID = #t2.ID where #t1.DateField <> #t2.DateField

drop table #t1
drop table #t2

The select should return a record because NULL does not equal '7/20/2006' but it doesn't.
What am I missing?

Thanks in advance.

straight out of BOL:

"Comparisons between two null values, or between a NULL and any other value, return unknown because the value of each NULL is unknown."

use the IS NULL clause to assist.

HTH,

Derek

|||Then why does this return a record?:

set ANSI_NULLS off
go
declare @.var datetime
select @.var = null

create table #t1
(
ID int,
DateField datetime
)

insert into #t1 (ID, DateField) values (1, '7/20/2006')

select * from #t1 where #t1.DateField <> @.var

drop table #t1|||

ANSI NULLS setting only affects comparisons of the form:

column <Operator> @.value

column <Operator> literal

value <Operator> @.value

value <Operator> literal

and combinations thereof. The column to column comparison will always follow the ANSI semantics for NULL value comparison. So you could write your SELECT like:

-- Depends on whether you have datetime values with the default value or not

select * from #t1 join #t2 on #t1.ID = #t2.ID

where #t1.DateField <> coalesce(#t2.DateField, '')

--or

select * from #t1 join #t2 on #t1.ID = #t2.ID

where #t1.DateField <> #t2.DateField

or (#t1.DateField IS NULL and #t2.DateField IS NOT NULL)

or (#t1.DateField IS NOT NULL and #t2.DateField IS NULL)

ODBC SQL Server Driver connection issues

Issue:
[Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionRead (rec
v()).
Server: Msg 11, Level 16, State 1, Line 0
General network error. Check your network documentation.
Connection Broken
above error is recieved during a heavy SQL query from Query Analyzer & a
OLEDB application client. Other queries like sp_who2 operate fine.
Environment:
SQL Servers running both SQL 2000 & 2005 (currently disabled) patched and
hotfix'd to most recent. Windows 2003 Servers patched and hotfix'd also. MDA
C
2.8.
Interestingly, when the query is run with SQL Server Management Studio it
runs just fine. Is there a compatiblity issue running both of these SQL
server versions on the same machine? When I run the query from a different
machine without the server software, just the two client versions I don't
experience this network connectivity issue.
ThanksOn May 24, 9:33 pm, Outlook 2003 user
<Outlook2003u...@.discussions.microsoft.com> wrote:
> Issue:
> [Microsoft][ODBCSQL Server Driver][DBNETLIB]ConnectionRead (re
cv()).
> Server: Msg 11, Level 16, State 1, Line 0
> General network error. Check your network documentation.
> Connection Broken
> above error is recieved during a heavy SQL query from Query Analyzer & aOL
EDBapplication client. Other queries like sp_who2 operate fine.
> Environment:
> SQL Servers running both SQL 2000 & 2005 (currently disabled) patched and
> hotfix'd to most recent. Windows 2003 Servers patched and hotfix'd also. M
DAC
> 2.8.
> Interestingly, when the query is run with SQL Server Management Studio it
> runs just fine. Is there a compatiblity issue running both of these SQL
> server versions on the same machine? When I run the query from a different
> machine without the server software, just the two client versions I don't
> experience this network connectivity issue.
> Thanks
Check for registry setting SynAttack in KB|||Thanks, but I added that a while ago with no success.
"M A Srinivas" wrote:

> On May 24, 9:33 pm, Outlook 2003 user
> <Outlook2003u...@.discussions.microsoft.com> wrote:
> Check for registry setting SynAttack in KB
>|||Just a follow-up to my post.
I figured out that the TOE was not operating correctly. This situation was
happening on new DELL 2950 & 1950 Servers with TCP/IP Offloading Engine
enables. After completely disabling this feature, via Microsoft & DELL
hardware the erroneous ODBC error stop occurring.
Thanks,
Outlook 2003 User (lol)
"Outlook 2003 user" wrote:
[vbcol=seagreen]
> Thanks, but I added that a while ago with no success.
> "M A Srinivas" wrote:
>

ODBC SQL Server Driver connection issues

Issue:
[Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionRead (recv()).
Server: Msg 11, Level 16, State 1, Line 0
General network error. Check your network documentation.
Connection Broken
above error is recieved during a heavy SQL query from Query Analyzer & a
OLEDB application client. Other queries like sp_who2 operate fine.
Environment:
SQL Servers running both SQL 2000 & 2005 (currently disabled) patched and
hotfix'd to most recent. Windows 2003 Servers patched and hotfix'd also. MDAC
2.8.
Interestingly, when the query is run with SQL Server Management Studio it
runs just fine. Is there a compatiblity issue running both of these SQL
server versions on the same machine? When I run the query from a different
machine without the server software, just the two client versions I don't
experience this network connectivity issue.
Thanks
On May 24, 9:33 pm, Outlook 2003 user
<Outlook2003u...@.discussions.microsoft.com> wrote:
> Issue:
> [Microsoft][ODBCSQL Server Driver][DBNETLIB]ConnectionRead (recv()).
> Server: Msg 11, Level 16, State 1, Line 0
> General network error. Check your network documentation.
> Connection Broken
> above error is recieved during a heavy SQL query from Query Analyzer & aOLEDBapplication client. Other queries like sp_who2 operate fine.
> Environment:
> SQL Servers running both SQL 2000 & 2005 (currently disabled) patched and
> hotfix'd to most recent. Windows 2003 Servers patched and hotfix'd also. MDAC
> 2.8.
> Interestingly, when the query is run with SQL Server Management Studio it
> runs just fine. Is there a compatiblity issue running both of these SQL
> server versions on the same machine? When I run the query from a different
> machine without the server software, just the two client versions I don't
> experience this network connectivity issue.
> Thanks
Check for registry setting SynAttack in KB
|||Thanks, but I added that a while ago with no success.
"M A Srinivas" wrote:

> On May 24, 9:33 pm, Outlook 2003 user
> <Outlook2003u...@.discussions.microsoft.com> wrote:
> Check for registry setting SynAttack in KB
>
|||Just a follow-up to my post.
I figured out that the TOE was not operating correctly. This situation was
happening on new DELL 2950 & 1950 Servers with TCP/IP Offloading Engine
enables. After completely disabling this feature, via Microsoft & DELL
hardware the erroneous ODBC error stop occurring.
Thanks,
Outlook 2003 User (lol)
"Outlook 2003 user" wrote:
[vbcol=seagreen]
> Thanks, but I added that a while ago with no success.
> "M A Srinivas" wrote:

ODBC Problem after install SP3 on SQL 2000

After install SP3 on SQL server 2000, some computers can't connect to the SQL server through ODBC.

Connection failed:
SQL State: '01000'
SQL Server Error: 10060
[Microsoft][ODBC SQL Server Driver][DBNETLIB]Connection Open(Connect()).
Connection failed:
SQLState: '08001'
SQL Server Error: 17
[Microsoft][ODBC SQL Server Driber][DBNETLIB]SQL Server does not exist or
access denied

Please helpRE:
Q1 After install SP3 on SQL server 2000, some computers can't connect to the SQL server through ODBC. Please help

A1 Consider checking general network connectivity (ping the server from the workstations). If network connectivity is present consider verifying / checking the DSNs in use (verify protocol settings, etc., and test the connection) and / or use the MDAC compatibility checking tool to assess MDAC component status. See: http://www.microsoft.com/data/download.htm#CCinfo
http://download.microsoft.com/downl...XP/EN-US/cc.exe|||Ping the server OK
Already checked Client Network Utility and Server Network Utility. Both use TCP and NamePipe.
Run MDAC check already.

ODBC still don't work.

ODBC Native State S1T00: timeout expired

Hello :
I am very new to ODBC connectivity, but i know sql fairly
well:

What can generate a Native State Error: Native State
S1T00: timeout expired on a SQL 2000 database; NT4 OS
Server??

I am running sql database dependent applications on this
server: 3 to be exact.

e.g. I have an application which transports data that was
entered to the SQL database located on this Server via a
LAN user. This application then dynamically takes this
data and transports it to another device located on the
same sub-net as the Server for data recognition and other
functionalities. This is performed in milliseconds hence
it may be utilizing the (winmm.dll) file to accomplish
this. But the error message:

"Warning State: S1T00,Native:0, Origin: [Microsoft][ODBC
SQL Server Driver] timeout expired"

causes this process to fail along with other ODBC and SQL
dependent applictions. also my maintenance plans failed as aresult of this message..

Can someone please help/ inform me what can cause this and
how to prevent this??

Can a modem dial-in access cause this?? though it was
running fine with modem access in the past, and no change
in its configs.??

Thank you in advance

AdiggaMay check this KBA (http://support.microsoft.com/default.aspx?scid=http://support.microsoft.com:80/support/kb/articles/q175/2/64.asp&NoWebContent=1) .

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...B;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.

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[/vbc
ol]
(Connect())[vbcol=seagreen]
> Error on connection:
> SQL State: '08001'
> SQL Server Error 17
> [Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]SQL Server does[/vb
col]
not exist[vbcol=seagreen]
> 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/defaul...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.

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.