473,609 Members | 1,900 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

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 connectionstrin g

"data source=MYSERVER ;initial catalog=MYDATAB ASE;password=MY PWD;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 2139

"Simone" <ov*********@ho tmail.com> wrote in message
news:uP******** ********@TK2MSF TNGP12.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 connectionstrin g

"data source=MYSERVER ;initial catalog=MYDATAB ASE;password=MY PWD;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=MYSERVE R" 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*********@ho tmail.com> wrote in message
news:uP******** ********@TK2MSF TNGP12.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 connectionstrin g

"data source=MYSERVER ;initial catalog=MYDATAB ASE;password=MY PWD;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 connectionstrin g is Correct because if I use this connectionstrin g in
a vb.Net Application, it run!

thanks,

Simone
Nov 19 '05 #5
> but my connectionstrin g is Correct because if I use this connectionstrin g
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*********@ho tmail.com> wrote in message
news:ea******** ******@tk2msftn gp13.phx.gbl... Ok,

but my connectionstrin g is Correct because if I use this connectionstrin g
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

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

Similar topics

3
2515
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. Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. Exception Details:...
7
4995
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. I created the websetup and built the MSI, have the bundled version. Copied to webserver and ran Websetup.msi. Said I had to remove old version, which I did, then reran WebSetup.msi and keeps giving me this error. "The installer was interrupted...
8
9447
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 System.Security.Principal.WindowsImpersonationContext Dim currentWindowsIdentity As System.Security.Principal.WindowsIdentity
9
3196
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 questions are below... "David Good" wrote: > We have a network running both Win2k and Win2k3 webservers and our web sites > reside on a UNC network share that happens to be a Network Appliance NAS.
0
23473
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) 5: Procedure call or argument is not valid. 6: Overflow. 7: Out of memory.
1
4184
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 my application to the new laptop and I am experiencing as SQL Server connection error: "SQL Server does not exist or access denied". Following is a simply ASP.NET application to test the connection and I am getting following error: For your...
1
4622
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. The Asp website and its database(sql server) are in two different servers. Can any one help me out. Did enybodyelse come accross such issue?????? I referred the msdn and tried the solutions(like setting permissions..etc) already but none of them...
2
8023
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"> <title>Untitled Page</title> </head> <body>
23
5083
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 solution, and was greeted with the following error: ======================================================================== It is an error to use a section registered as allowDefinition='MachineToApplication' beyond application level. This error...
1
8220
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
8404
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
0
6997
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
1
6056
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
5509
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
4017
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
1
2530
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
1
1667
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
0
1386
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

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.