473,320 Members | 1,817 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

Error: SQL Server does not exist or access denied in ASP Application

Hi!
I'm an Italian Boy,
Excuse Me for my incorrect language.
I have a Server with Windows Server 2003 Enterprise Architect and SQL Server
2000 Enterprise.

I'm developing an ASP Web Application, but when i try to connect to my SQL
Server Database by this connectionstring

"data source=MYSERVER;initial catalog=MYDATABASE;password=MYPWD;user id=Sa"

I receive th error : 'SQL Server does not exist or access denied'.

I' have checked the condition in this Kb :

http://support.microsoft.com/default...b;en-us;328306

and this Kb
http://support.microsoft.com/default...Product=aspnet

but i cannot resolve my problem.

Thanks!
Simone


Nov 19 '05 #1
12 2114

"Simone" <ov*********@hotmail.com> wrote in message
news:uP****************@TK2MSFTNGP12.phx.gbl...
Hi!
I'm an Italian Boy,
Excuse Me for my incorrect language.
I have a Server with Windows Server 2003 Enterprise Architect and SQL
Server
2000 Enterprise.

I'm developing an ASP Web Application, but when i try to connect to my SQL
Server Database by this connectionstring

"data source=MYSERVER;initial catalog=MYDATABASE;password=MYPWD;user
id=Sa"

I receive th error : 'SQL Server does not exist or access denied'.

I'm not an expert on these things but I would use "server=MYSERVER" or, if
the database is on the same machine, leave out that bit altogether

make sure SQL server is running and listening on port 1433 and
I' have checked the condition in this Kb :

http://support.microsoft.com/default...b;en-us;328306

and this Kb
http://support.microsoft.com/default...Product=aspnet

but i cannot resolve my problem.

Thanks!
Simone

Nov 19 '05 #2
I develope in a Remote Machine,
SQL server is running and listening on port 1433.

Any ideas?

thanks.

Simone
Nov 19 '05 #3
Try this Kb:

http://www.connectionstrings.com/

--
HTH,

Kevin Spencer
Microsoft MVP
..Net Developer
Neither a follower nor a lender be.

"Simone" <ov*********@hotmail.com> wrote in message
news:uP****************@TK2MSFTNGP12.phx.gbl...
Hi!
I'm an Italian Boy,
Excuse Me for my incorrect language.
I have a Server with Windows Server 2003 Enterprise Architect and SQL
Server
2000 Enterprise.

I'm developing an ASP Web Application, but when i try to connect to my SQL
Server Database by this connectionstring

"data source=MYSERVER;initial catalog=MYDATABASE;password=MYPWD;user
id=Sa"

I receive th error : 'SQL Server does not exist or access denied'.

I' have checked the condition in this Kb :

http://support.microsoft.com/default...b;en-us;328306

and this Kb
http://support.microsoft.com/default...Product=aspnet

but i cannot resolve my problem.

Thanks!
Simone

Nov 19 '05 #4
Ok,

but my connectionstring is Correct because if I use this connectionstring in
a vb.Net Application, it run!

thanks,

Simone
Nov 19 '05 #5
> but my connectionstring is Correct because if I use this connectionstring
in
a vb.Net Application, it run!
If I were to tell you that my carbeurator was correct because it works in my
Volkswagon, but when I put it in my Porsche, it doesn't run, would I be
correct?

A VB.Net executable is not an ASP.Net web application. For one thing, they
run under different user accounts. Hence, the "access denied" part of the
error message.

--
HTH,

Kevin Spencer
Microsoft MVP
..Net Developer
Neither a follower nor a lender be.

"Simone" <ov*********@hotmail.com> wrote in message
news:ea**************@tk2msftngp13.phx.gbl... Ok,

but my connectionstring is Correct because if I use this connectionstring
in
a vb.Net Application, it run!

thanks,

Simone

Nov 19 '05 #6
I have tryed all solution in www.connectionstrings.com, but it doesn't work

thanks

Simone
Nov 19 '05 #7
I'm resolved the problem by installing MS SQL Server 2000 SP3

Thanks

Simone
Nov 19 '05 #8
Simone wrote:
I have tryed all solution in www.connectionstrings.com, but it
doesn't work

We can't help you if you don't:
1. SHOW us what you tried
2. Describe your symptoms without using the words "doesn't work" This means:
detailed error messages (or the lack thereof), perceived behavior vs.
expected behavior, etc.

Are you tying to use trusted connection? If so, are you aware of what
account is being used by ASP.Net to run your code? That there is a
possibility that it is not the user loading the page? See if these KB
articles are relevant:
http://support.microsoft.com/default...;en-us;Q315159
http://support.microsoft.com/kb/316989
http://support.microsoft.com/default...;en-us;Q315158

Bob Barrows
--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.
Nov 19 '05 #9
I'm Installed SQL Server 2000 SP3 and now my application run.

Thanks

Bye,

Simone
Nov 19 '05 #10
Check your network protocols. By default, SQL Server uses named pipes, while
the app itself will attempt a TCP/IP connection. If you can connect with SQL
Server tools, like Query Analyzer, this is most likely the problem (at least
when you are using SQL security). The same is true for most Windows apps and
Console apps, which will try named pipes first.

If this is your problem, add the TCP/IP network protocol to the SQL Server
and you will be up and running again. You do this through the Server Network
Utility.
---

Gregory A. Beamer
MVP; MCP: +I, SE, SD, DBA

***************************
Think Outside the Box!
***************************

"Simone" wrote:
Hi!
I'm an Italian Boy,
Excuse Me for my incorrect language.
I have a Server with Windows Server 2003 Enterprise Architect and SQL Server
2000 Enterprise.

I'm developing an ASP Web Application, but when i try to connect to my SQL
Server Database by this connectionstring

"data source=MYSERVER;initial catalog=MYDATABASE;password=MYPWD;user id=Sa"

I receive th error : 'SQL Server does not exist or access denied'.

I' have checked the condition in this Kb :

http://support.microsoft.com/default...b;en-us;328306

and this Kb
http://support.microsoft.com/default...Product=aspnet

but i cannot resolve my problem.

Thanks!
Simone


Nov 19 '05 #11
More likely it is a protocol problem. Windows apps attempt named pipes first.
ASP.NET apps are more likely to try TCP/IP first, which is not loaded in all
SQL Server installations.

---

Gregory A. Beamer
MVP; MCP: +I, SE, SD, DBA

***************************
Think Outside the Box!
***************************

"Kevin Spencer" wrote:
Try this Kb:

http://www.connectionstrings.com/

--
HTH,

Kevin Spencer
Microsoft MVP
..Net Developer
Neither a follower nor a lender be.

"Simone" <ov*********@hotmail.com> wrote in message
news:uP****************@TK2MSFTNGP12.phx.gbl...
Hi!
I'm an Italian Boy,
Excuse Me for my incorrect language.
I have a Server with Windows Server 2003 Enterprise Architect and SQL
Server
2000 Enterprise.

I'm developing an ASP Web Application, but when i try to connect to my SQL
Server Database by this connectionstring

"data source=MYSERVER;initial catalog=MYDATABASE;password=MYPWD;user
id=Sa"

I receive th error : 'SQL Server does not exist or access denied'.

I' have checked the condition in this Kb :

http://support.microsoft.com/default...b;en-us;328306

and this Kb
http://support.microsoft.com/default...Product=aspnet

but i cannot resolve my problem.

Thanks!
Simone


Nov 19 '05 #12
hmm, that's pretty strange

maybe some firewall or antivirus program realised you didn't have SP3 and
blocked the traffic in case of slammer vulnerability?

"Simone" <ov*********@hotmail.com> wrote in message
news:et****************@TK2MSFTNGP09.phx.gbl...
I'm Installed SQL Server 2000 SP3 and now my application run.

Thanks

Bye,

Simone

Nov 19 '05 #13

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

3
by: Matthew Louden | last post by:
I attempt to connect ASP.NET application with SQL Server using ADO.NET. I just open a connection, and it had run-time error in line 34: cn.open(): SQL Server does not exist or access denied....
7
by: p | last post by:
WE had a Crystal 8 WebApp using vs 2002 which we upgraded to VS2003. I also have Crystal 9 pro on my development machine. The web app runs fine on my dev machine but am having problems deploying....
8
by: Razak | last post by:
Hi, I have a class which basically do Impersonation in my web application. From MS KB sample:- ++++++++++++++++++++code starts Dim impersonationContext As...
9
by: Tim D | last post by:
Hi, I originally posted this as a reply to a rather old thread in dotnet.framework.general and didn't get any response. I thought it might be more relevant here; anyone got any ideas? My...
0
by: HKSHK | last post by:
This list compares the error codes used in VB.NET 2003 with those used in VB6. Error Codes: ============ 3: This Error number is obsolete and no longer used. (Formerly: Return without GoSub)...
1
by: Atia Amin | last post by:
Hi, I am a new member. Hello to every one. I am new in ASP.NET area. I wrote an ASP.NET web application which was running ok with my old laptop. Currently I have given a new laptop. Now I copied...
1
by: vamshika | last post by:
hi, I got a serious Problem. I get "Server does not exist or access denied" with 80004005 as the error code. the win2003 server uses all the latest components(like iis6,jet..etc) and is upto date....
2
by: Paolo | last post by:
Hi to all, I have an error that drove me crazy. Try the following page that should only allow to upload a file: <html xmlns="http://www.w3.org/1999/xhtml" > <head runat="server">...
23
by: deathtospam | last post by:
A day or two ago, I wrote a quick ASPX page with a CS codebehind using Visual Studio .NET 2005 -- it worked, I saved it and closed the project. Today, I came back to the project, reopened the...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
0
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.