 | |
Re: System.Data.SqlClient.SqlException: SQL Server does not exist or access denied.
Dotnet Framework (ODBC.net) microsoft.public.dotnet.framework.odbcnet
 |
| | Thread Tools | Search this Thread | Display Modes |
#1
 
| |||
| |||
|
Re: System.Data.SqlClient.SqlException: SQL Server does not exist or access denied. -
09-19-2003
, 09:46 AM
|
Hi Skip, Have a try to see if the login account to the SQL Server is correct. Check what the login name and password are used in your application to connect to that SQL Server, and if they can connect to it. If anything is unclear, please feel free to reply to the post. Kevin Yu ======= "This posting is provided "AS IS" with no warranties, and confers no rights." | From: "Skip Borland" <skip.borland (AT) eig (DOT) com | Subject: System.Data.SqlClient.SqlException: SQL Server does not exist or access denied. | Date: Thu, 18 Sep 2003 23:51:54 -0700 | Lines: 15 | X-Priority: 3 | X-MSMail-Priority: Normal | X-Newsreader: Microsoft Outlook Express 6.00.2800.1106 | X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106 | Message-ID: <eyTpEqnfDHA.1732 (AT) TK2MSFTNGP12 (DOT) phx.gbl | Newsgroups: microsoft.public.dotnet.framework.odbcnet | NNTP-Posting-Host: 12-228-161-20.client.attbi.com 12.228.161.20 | Path: cpmsftngxa06.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTN GP12.phx.gbl | Xref: cpmsftngxa06.phx.gbl microsoft.public.dotnet.framework.odbcnet:2985 | X-Tomcat-NG: microsoft.public.dotnet.framework.odbcnet | | Hi. I'm running the same code on the same IIS box in two different virtual | directories, but against two different SQL servers. We upgraded the SQL | servers to SQL SP3 and I now cannot connect to one of them. I'm not | convinced it is a client issue as, as I mentioned previously, I'm running | the exact same code base in both apps, just pointing to a different SQL box | in each case. The apps both worked fine until I upgraded to SQL SP3, and now | one is broken. | | When I try to connect I get "SQL Server does not exist or Access Denied". | | has anyone seen this issue and if so were you able to solve it? | | Thanks...Skip | | | |
#2
| |||
| |||
|
|
From: "Skip Borland" <skip.borland (AT) eig (DOT) com References: <eyTpEqnfDHA.1732 (AT) TK2MSFTNGP12 (DOT) phx.gbl tJ2M#fqfDHA.2632 (AT) cpmsftngxa06 (DOT) phx.gbl Subject: Re: System.Data.SqlClient.SqlException: SQL Server does not exist or access denied. Date: Fri, 19 Sep 2003 06:46:50 -0700 Lines: 76 X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.2800.1106 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106 Message-ID: <OgeE8RrfDHA.3528 (AT) tk2msftngp13 (DOT) phx.gbl Newsgroups: microsoft.public.dotnet.framework.odbcnet NNTP-Posting-Host: 12-228-161-20.client.attbi.com 12.228.161.20 Path: cpmsftngxa06.phx.gbl!TK2MSFTNGP08.phx.gbl!tk2msftn gp13.phx.gbl Xref: cpmsftngxa06.phx.gbl microsoft.public.dotnet.framework.odbcnet:2990 X-Tomcat-NG: microsoft.public.dotnet.framework.odbcnet Thanks Kevin... Nope. I've looked at the obvious stuff. Login is correct, As a matter of fact, I even created a new user to test this. Neither the old or new user works from the ASP app, but they both are able to create DSNs and log in correctly. Like I mentioned, this worked fine until SQL SP3 was installed on the SQL boxes. I'm pretty convinced that it is not a client issue as I have the exact same code base running in two different virtual directories on the same server. The only difference is that I am pointing to two different SQL boxes. Both of the SQL boxes had SP3 applied. Now one works and the other doesn't. Thanks for responding. I look forward to more ideas....Skip "Kevin Yu" <v-kevy (AT) online (DOT) microsoft.com> wrote in message news:tJ2M#fqfDHA.2632 (AT) cpmsftngxa06 (DOT) phx.gbl... Hi Skip, Have a try to see if the login account to the SQL Server is correct. Check what the login name and password are used in your application to connect to that SQL Server, and if they can connect to it. If anything is unclear, please feel free to reply to the post. Kevin Yu ======= "This posting is provided "AS IS" with no warranties, and confers no rights." | From: "Skip Borland" <skip.borland (AT) eig (DOT) com | Subject: System.Data.SqlClient.SqlException: SQL Server does not exist or access denied. | Date: Thu, 18 Sep 2003 23:51:54 -0700 | Lines: 15 | X-Priority: 3 | X-MSMail-Priority: Normal | X-Newsreader: Microsoft Outlook Express 6.00.2800.1106 | X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106 | Message-ID: <eyTpEqnfDHA.1732 (AT) TK2MSFTNGP12 (DOT) phx.gbl | Newsgroups: microsoft.public.dotnet.framework.odbcnet | NNTP-Posting-Host: 12-228-161-20.client.attbi.com 12.228.161.20 | Path: cpmsftngxa06.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTN GP12.phx.gbl | Xref: cpmsftngxa06.phx.gbl microsoft.public.dotnet.framework.odbcnet:2985 | X-Tomcat-NG: microsoft.public.dotnet.framework.odbcnet | | Hi. I'm running the same code on the same IIS box in two different virtual | directories, but against two different SQL servers. We upgraded the SQL | servers to SQL SP3 and I now cannot connect to one of them. I'm not | convinced it is a client issue as, as I mentioned previously, I'm running | the exact same code base in both apps, just pointing to a different SQL box | in each case. The apps both worked fine until I upgraded to SQL SP3, and now | one is broken. | | When I try to connect I get "SQL Server does not exist or Access Denied". | | has anyone seen this issue and if so were you able to solve it? | | Thanks...Skip | | | |
#3
| |||
| |||
|
|
Hi Skip, I'm not quite sure why the access is denied with limited information. Would you please provide me with more information such as what kind so authentication (Windows or SQL Server authentication) are you using, did you impersonate the ASP .NET, so that I can deliver my assistance more quickly? Could you show me some of your code with the connection string? I'm looking forward to your reply. If anything is unclear, please feel free to reply to the post. Kevin Yu ======= "This posting is provided "AS IS" with no warranties, and confers no rights." -------------------- | From: "Skip Borland" <skip.borland (AT) eig (DOT) com | References: <eyTpEqnfDHA.1732 (AT) TK2MSFTNGP12 (DOT) phx.gbl tJ2M#fqfDHA.2632 (AT) cpmsftngxa06 (DOT) phx.gbl | Subject: Re: System.Data.SqlClient.SqlException: SQL Server does not exist or access denied. | Date: Fri, 19 Sep 2003 06:46:50 -0700 | Lines: 76 | X-Priority: 3 | X-MSMail-Priority: Normal | X-Newsreader: Microsoft Outlook Express 6.00.2800.1106 | X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106 | Message-ID: <OgeE8RrfDHA.3528 (AT) tk2msftngp13 (DOT) phx.gbl | Newsgroups: microsoft.public.dotnet.framework.odbcnet | NNTP-Posting-Host: 12-228-161-20.client.attbi.com 12.228.161.20 | Path: cpmsftngxa06.phx.gbl!TK2MSFTNGP08.phx.gbl!tk2msftn gp13.phx.gbl | Xref: cpmsftngxa06.phx.gbl microsoft.public.dotnet.framework.odbcnet:2990 | X-Tomcat-NG: microsoft.public.dotnet.framework.odbcnet | | Thanks Kevin... | | Nope. I've looked at the obvious stuff. Login is correct, As a matter of | fact, I even created a new user to test this. Neither the old or new user | works from the ASP app, but they both are able to create DSNs and log in | correctly. | | Like I mentioned, this worked fine until SQL SP3 was installed on the SQL | boxes. I'm pretty convinced that it is not a client issue as I have the | exact same code base running in two different virtual directories on the | same server. The only difference is that I am pointing to two different SQL | boxes. Both of the SQL boxes had SP3 applied. Now one works and the other | doesn't. | | Thanks for responding. I look forward to more ideas....Skip | | | "Kevin Yu" <v-kevy (AT) online (DOT) microsoft.com> wrote in message | news:tJ2M#fqfDHA.2632 (AT) cpmsftngxa06 (DOT) phx.gbl... | > Hi Skip, | | > Have a try to see if the login account to the SQL Server is correct. Check | > what the login name and password are used in your application to connect | to | > that SQL Server, and if they can connect to it. | | > If anything is unclear, please feel free to reply to the post. | | > Kevin Yu | > ======= | > "This posting is provided "AS IS" with no warranties, and confers no | > rights." | | | > | From: "Skip Borland" <skip.borland (AT) eig (DOT) com | > | Subject: System.Data.SqlClient.SqlException: SQL Server does not exist | or | > access denied. | > | Date: Thu, 18 Sep 2003 23:51:54 -0700 | > | Lines: 15 | > | X-Priority: 3 | > | X-MSMail-Priority: Normal | > | X-Newsreader: Microsoft Outlook Express 6.00.2800.1106 | > | X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106 | > | Message-ID: <eyTpEqnfDHA.1732 (AT) TK2MSFTNGP12 (DOT) phx.gbl | > | Newsgroups: microsoft.public.dotnet.framework.odbcnet | > | NNTP-Posting-Host: 12-228-161-20.client.attbi.com 12.228.161.20 | > | Path: cpmsftngxa06.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTN GP12.phx.gbl | > | Xref: cpmsftngxa06.phx.gbl | microsoft.public.dotnet.framework.odbcnet:2985 | > | X-Tomcat-NG: microsoft.public.dotnet.framework.odbcnet | > | | > | Hi. I'm running the same code on the same IIS box in two different | virtual | > | directories, but against two different SQL servers. We upgraded the SQL | > | servers to SQL SP3 and I now cannot connect to one of them. I'm not | > | convinced it is a client issue as, as I mentioned previously, I'm | running | > | the exact same code base in both apps, just pointing to a different SQL | > box | > | in each case. The apps both worked fine until I upgraded to SQL SP3, and | > now | > | one is broken. | > | | > | When I try to connect I get "SQL Server does not exist or Access | Denied". | > | | > | has anyone seen this issue and if so were you able to solve it? | > | | > | Thanks...Skip | > | | > | | > | | | | | |
#4
| |||
| |||
|
|
From: "Skip Borland" <skip.borland (AT) eig (DOT) com References: <eyTpEqnfDHA.1732 (AT) TK2MSFTNGP12 (DOT) phx.gbl tJ2M#fqfDHA.2632 (AT) cpmsftngxa06 (DOT) phx.gbl |
<XqbIswQgDHA.2556 (AT) cpmsftngxa06 (DOT) phx.gbl>
Quote:
|
Subject: Re: System.Data.SqlClient.SqlException: SQL Server does not exist or access denied. Date: Wed, 24 Sep 2003 00:14:11 -0700 Lines: 142 X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.2800.1106 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106 Message-ID: <eQav2tmgDHA.1200 (AT) TK2MSFTNGP09 (DOT) phx.gbl Newsgroups: microsoft.public.dotnet.framework.odbcnet NNTP-Posting-Host: 12-228-161-20.client.attbi.com 12.228.161.20 Path: cpmsftngxa06.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTN GP09.phx.gbl Xref: cpmsftngxa06.phx.gbl microsoft.public.dotnet.framework.odbcnet:3015 X-Tomcat-NG: microsoft.public.dotnet.framework.odbcnet OK. I figured it out. Somehow during the application of the SQL SP3 patch, it wiped out the port setting for TCP. You can verify that by looking at the SQL logs. On startup it shows the server listening on Named Pipes, but not TCP. If you look at the protocols in the Enterprise Manager, it shows TCP installed to listen on port 1433. But if you look at it in the registry, the entry is blank. I believe that the Enterprise manager shows it as 1433 as a defualt, even if it is not there. By removing the TCP protocol, saving the settings, then re-adding the TCP protocol, the correct entries were made in the registry. Skip "Kevin Yu" <v-kevy (AT) online (DOT) microsoft.com> wrote in message news:XqbIswQgDHA.2556 (AT) cpmsftngxa06 (DOT) phx.gbl... Hi Skip, I'm not quite sure why the access is denied with limited information. Would you please provide me with more information such as what kind so authentication (Windows or SQL Server authentication) are you using, did you impersonate the ASP .NET, so that I can deliver my assistance more quickly? Could you show me some of your code with the connection string? I'm looking forward to your reply. If anything is unclear, please feel free to reply to the post. Kevin Yu ======= "This posting is provided "AS IS" with no warranties, and confers no rights." -------------------- | From: "Skip Borland" <skip.borland (AT) eig (DOT) com | References: <eyTpEqnfDHA.1732 (AT) TK2MSFTNGP12 (DOT) phx.gbl tJ2M#fqfDHA.2632 (AT) cpmsftngxa06 (DOT) phx.gbl | Subject: Re: System.Data.SqlClient.SqlException: SQL Server does not exist or access denied. | Date: Fri, 19 Sep 2003 06:46:50 -0700 | Lines: 76 | X-Priority: 3 | X-MSMail-Priority: Normal | X-Newsreader: Microsoft Outlook Express 6.00.2800.1106 | X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106 | Message-ID: <OgeE8RrfDHA.3528 (AT) tk2msftngp13 (DOT) phx.gbl | Newsgroups: microsoft.public.dotnet.framework.odbcnet | NNTP-Posting-Host: 12-228-161-20.client.attbi.com 12.228.161.20 | Path: cpmsftngxa06.phx.gbl!TK2MSFTNGP08.phx.gbl!tk2msftn gp13.phx.gbl | Xref: cpmsftngxa06.phx.gbl microsoft.public.dotnet.framework.odbcnet:2990 | X-Tomcat-NG: microsoft.public.dotnet.framework.odbcnet | | Thanks Kevin... | | Nope. I've looked at the obvious stuff. Login is correct, As a matter of | fact, I even created a new user to test this. Neither the old or new user | works from the ASP app, but they both are able to create DSNs and log in | correctly. | | Like I mentioned, this worked fine until SQL SP3 was installed on the SQL | boxes. I'm pretty convinced that it is not a client issue as I have the | exact same code base running in two different virtual directories on the | same server. The only difference is that I am pointing to two different SQL | boxes. Both of the SQL boxes had SP3 applied. Now one works and the other | doesn't. | | Thanks for responding. I look forward to more ideas....Skip | | | "Kevin Yu" <v-kevy (AT) online (DOT) microsoft.com> wrote in message | news:tJ2M#fqfDHA.2632 (AT) cpmsftngxa06 (DOT) phx.gbl... | > Hi Skip, | | > Have a try to see if the login account to the SQL Server is correct. Check | > what the login name and password are used in your application to connect | to | > that SQL Server, and if they can connect to it. | | > If anything is unclear, please feel free to reply to the post. | | > Kevin Yu | > ======= | > "This posting is provided "AS IS" with no warranties, and confers no | > rights." | | | > | From: "Skip Borland" <skip.borland (AT) eig (DOT) com | > | Subject: System.Data.SqlClient.SqlException: SQL Server does not exist | or | > access denied. | > | Date: Thu, 18 Sep 2003 23:51:54 -0700 | > | Lines: 15 | > | X-Priority: 3 | > | X-MSMail-Priority: Normal | > | X-Newsreader: Microsoft Outlook Express 6.00.2800.1106 | > | X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106 | > | Message-ID: <eyTpEqnfDHA.1732 (AT) TK2MSFTNGP12 (DOT) phx.gbl | > | Newsgroups: microsoft.public.dotnet.framework.odbcnet | > | NNTP-Posting-Host: 12-228-161-20.client.attbi.com 12.228.161.20 | > | Path: cpmsftngxa06.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTN GP12.phx.gbl | > | Xref: cpmsftngxa06.phx.gbl | microsoft.public.dotnet.framework.odbcnet:2985 | > | X-Tomcat-NG: microsoft.public.dotnet.framework.odbcnet | > | | > | Hi. I'm running the same code on the same IIS box in two different | virtual | > | directories, but against two different SQL servers. We upgraded the SQL | > | servers to SQL SP3 and I now cannot connect to one of them. I'm not | > | convinced it is a client issue as, as I mentioned previously, I'm | running | > | the exact same code base in both apps, just pointing to a different SQL | > box | > | in each case. The apps both worked fine until I upgraded to SQL SP3, and | > now | > | one is broken. | > | | > | When I try to connect I get "SQL Server does not exist or Access | Denied". | > | | > | has anyone seen this issue and if so were you able to solve it? | > | | > | Thanks...Skip | > | | > | | > | | | | | |
|
« Previous Thread
|
Next Thread »
| Thread Tools | Search this Thread |
| Display Modes | |
Linear Mode
| |
Powered by vBulletin Version 3.5.4
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.