473,324 Members | 2,313 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,324 software developers and data experts.

SQL Server does not exist...

Hi Guys,

<Posted yesterday to microsoft.public.dotnet.framework.aspnet.security,
but no responses garnered. For mpsc readers, this is a fairly common
error encountered when connecting from ASP.Net 1.1, but I've followed
all the help I can find online and it hasn't fixed my problem yet. So
any ideas for troubleshooting would be welcomed>

Yet another person suffering from the infamous "SQL Server does not
exist or access is denied problem". I've looked through a fair bit of
the checklists, but none have resolved my problem as yet. Here's what
we're using:

Machine running ASP.Net is either a Window 2000 Pro or Windows XP Pro
box (tried both). The server is Windows 2003, running SQL Server 2000.

We have an ASP.Net 1.1 application that consists of a simple set of
pages/code behind and a separate DLL which performs the data
operations. The DLL knows how to find it's own connection string from
the registry (uses SQL Authentication, BTW)

If we add the data DLL to a Windows Forms application, it connects
fine, so we know that the connection string stored in the registry is
correct. We've also demonstrated that we can connect using Query
Analyzer, using the same username/password, both whilst running under a

domain users account, and whilst running under the local system
account.

This has led me to suspect it's "something" special to ASP.Net. We've
unregistered/reregistered ASP.Net using aspnet_regiis (also, bear in
mind that we get the same from both test machines). We've tried
switching ASP.Net from using the ASPNET account to using the SYSTEM
account. We've tried forcing the connection to use Named Pipes, or to
use TCP/IP (and we've verified that both protocols are enabled at both
client and server). We've tried adding an <impersonateelement into
web.config. None of these has changed the error message (other than it
taking longer to error when we forced tcp connection).

We've verified under all these circumstances that we don't even get a
login failure in profiler.

So, what I'm looking for is more ideas of where we should look?

Thanks in advance for any help,

Damien

Sep 6 '06 #1
7 1319

I don't think there's anything "special" about dot net and the connection
string.

If you're using "nt authentication", then you need to be aware which account
asp_net uses.
Look under "Security / Users" in the Control Panel.

You can go here
http://www.connectionstrings.com/
and experiment with the different connection strings.

Keep in mind that ~every space and ";" is important. If you type in
"DataSource" instead of "Data Source", you'll screw yourself.
...

Also, if you aren't sure, you can research on how to use the IIdentity to
figure out who/which account you're actually using while in the dotnet
world.
I would say the most "Exact" connection string you can use is
The IP Address for the server name.
and use a sql authentication name/password pair. Use "sa" and "sapassword"
(whatever your sa password is) if you have access to it.
If not, make sure you create a new sql authentication username and try that.
CREATE A NEW ONE to make sure the "Login" (under management/security) is not
out of whack with the "(my)Database/Users".

My guess is that youre running under the asp.net account name, and you're
trying to use trusted security. And they aren't synced up.
But that's a guess.



"Damien" <Da*******************@hotmail.comwrote in message
news:11**********************@i3g2000cwc.googlegro ups.com...
Hi Guys,

<Posted yesterday to microsoft.public.dotnet.framework.aspnet.security,
but no responses garnered. For mpsc readers, this is a fairly common
error encountered when connecting from ASP.Net 1.1, but I've followed
all the help I can find online and it hasn't fixed my problem yet. So
any ideas for troubleshooting would be welcomed>

Yet another person suffering from the infamous "SQL Server does not
exist or access is denied problem". I've looked through a fair bit of
the checklists, but none have resolved my problem as yet. Here's what
we're using:

Machine running ASP.Net is either a Window 2000 Pro or Windows XP Pro
box (tried both). The server is Windows 2003, running SQL Server 2000.

We have an ASP.Net 1.1 application that consists of a simple set of
pages/code behind and a separate DLL which performs the data
operations. The DLL knows how to find it's own connection string from
the registry (uses SQL Authentication, BTW)

If we add the data DLL to a Windows Forms application, it connects
fine, so we know that the connection string stored in the registry is
correct. We've also demonstrated that we can connect using Query
Analyzer, using the same username/password, both whilst running under a

domain users account, and whilst running under the local system
account.

This has led me to suspect it's "something" special to ASP.Net. We've
unregistered/reregistered ASP.Net using aspnet_regiis (also, bear in
mind that we get the same from both test machines). We've tried
switching ASP.Net from using the ASPNET account to using the SYSTEM
account. We've tried forcing the connection to use Named Pipes, or to
use TCP/IP (and we've verified that both protocols are enabled at both
client and server). We've tried adding an <impersonateelement into
web.config. None of these has changed the error message (other than it
taking longer to error when we forced tcp connection).

We've verified under all these circumstances that we don't even get a
login failure in profiler.

So, what I'm looking for is more ideas of where we should look?

Thanks in advance for any help,

Damien

Sep 6 '06 #2
on the 2003 server, set the identity of the app pool to a domain account
with acces to the database. then be sure in the web config impersonate is
false.

-- bruce (sqlwork.com)

"Damien" <Da*******************@hotmail.comwrote in message
news:11**********************@i3g2000cwc.googlegro ups.com...
Hi Guys,

<Posted yesterday to microsoft.public.dotnet.framework.aspnet.security,
but no responses garnered. For mpsc readers, this is a fairly common
error encountered when connecting from ASP.Net 1.1, but I've followed
all the help I can find online and it hasn't fixed my problem yet. So
any ideas for troubleshooting would be welcomed>

Yet another person suffering from the infamous "SQL Server does not
exist or access is denied problem". I've looked through a fair bit of
the checklists, but none have resolved my problem as yet. Here's what
we're using:

Machine running ASP.Net is either a Window 2000 Pro or Windows XP Pro
box (tried both). The server is Windows 2003, running SQL Server 2000.

We have an ASP.Net 1.1 application that consists of a simple set of
pages/code behind and a separate DLL which performs the data
operations. The DLL knows how to find it's own connection string from
the registry (uses SQL Authentication, BTW)

If we add the data DLL to a Windows Forms application, it connects
fine, so we know that the connection string stored in the registry is
correct. We've also demonstrated that we can connect using Query
Analyzer, using the same username/password, both whilst running under a

domain users account, and whilst running under the local system
account.

This has led me to suspect it's "something" special to ASP.Net. We've
unregistered/reregistered ASP.Net using aspnet_regiis (also, bear in
mind that we get the same from both test machines). We've tried
switching ASP.Net from using the ASPNET account to using the SYSTEM
account. We've tried forcing the connection to use Named Pipes, or to
use TCP/IP (and we've verified that both protocols are enabled at both
client and server). We've tried adding an <impersonateelement into
web.config. None of these has changed the error message (other than it
taking longer to error when we forced tcp connection).

We've verified under all these circumstances that we don't even get a
login failure in profiler.

So, what I'm looking for is more ideas of where we should look?

Thanks in advance for any help,

Damien

Sep 6 '06 #3
Contrary to this advise, it is a very bad decision to use the [sa] account
for web access to a database. It should 'never' be done!

--
Arnie Rowland, Ph.D.
Westwood Consulting, Inc

Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
"sloan" <sl***@ipass.netwrote in message
news:uh**************@TK2MSFTNGP05.phx.gbl...
>
....
and use a sql authentication name/password pair. Use "sa" and
"sapassword"
(whatever your sa password is) if you have access to it.

Sep 6 '06 #4

I meant try this as a test, not a permanent setting.

Naturally, after getting sa working, you want to drill down the security
model to a more specific one.


"Arnie Rowland" <ar***@1568.comwrote in message
news:%2****************@TK2MSFTNGP05.phx.gbl...
Contrary to this advise, it is a very bad decision to use the [sa] account
for web access to a database. It should 'never' be done!

--
Arnie Rowland, Ph.D.
Westwood Consulting, Inc

Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
"sloan" <sl***@ipass.netwrote in message
news:uh**************@TK2MSFTNGP05.phx.gbl...
...
and use a sql authentication name/password pair. Use "sa" and
"sapassword"
(whatever your sa password is) if you have access to it.


Sep 6 '06 #5
Still bad advice, since many folks will use it, find it works, and then
never change it.

--
Arnie Rowland, Ph.D.
Westwood Consulting, Inc

Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
"sloan" <sl***@ipass.netwrote in message
news:%2****************@TK2MSFTNGP02.phx.gbl...
>
I meant try this as a test, not a permanent setting.

Naturally, after getting sa working, you want to drill down the security
model to a more specific one.


"Arnie Rowland" <ar***@1568.comwrote in message
news:%2****************@TK2MSFTNGP05.phx.gbl...
>Contrary to this advise, it is a very bad decision to use the [sa]
account
for web access to a database. It should 'never' be done!

--
Arnie Rowland, Ph.D.
Westwood Consulting, Inc

Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
"sloan" <sl***@ipass.netwrote in message
news:uh**************@TK2MSFTNGP05.phx.gbl...
>
...
and use a sql authentication name/password pair. Use "sa" and
"sapassword"
(whatever your sa password is) if you have access to it.



Sep 6 '06 #6
Arnie Rowland wrote:
Still bad advice, since many folks will use it, find it works, and then
never change it.

--
Arnie Rowland, Ph.D.
Westwood Consulting, Inc

Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
When I first joined my present company, the enterprise wide windows
application was using sa and a blank password. I still shudder to think
of it (and the day I set a password and broke several smaller apps)

Why do I always forget to include some relevant information in my posts
though? We're using sql authentication already, not intergrated
security, so I'm thinking it cannot be a user issue (since we can
connect using this user when in a windows forms app)

I have subsequently used netcap and Network Monitor, and I am seeing
what looks like traffic between the two machines, but I'm still seeing
nothing in profiler. (I'm worried we might not have shutdown everything
that might be doing SQL work between the two machines, but I'm
definitely seeing SQL Traffic (connections to port 1433))

Where do I look next?

Damien

Sep 7 '06 #7
Hi Damien,

Do you get this error while trying to connect or later on,
especially while running in a loop?

-------
Frank

Sep 14 '06 #8

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

Similar topics

2
by: Jay Chan | last post by:
We have just installed a SQL Server 2000 (SP 3A) onto a computer that has Windows-2003 Server on it. Now, we cannot get access to that database server from other computers. Seem like this may be an...
4
by: hooi | last post by:
I'm new to Visual Studio.NET and Visual Basic.NET. While trying to run the sample application, it shows an error message as shown below. I have an SQL Server containing the sample database...
2
by: george r smith | last post by:
Gentlemen, I know that this problem has happened before and I searched and tried all solutions but problem is not solved. I install asp.net community starter kit with some help from this...
3
by: Hermit Dave | last post by:
Hi, I am getting this SQLException: Sql Server does not exist or access denied Here is the situation: Build machine: VS 2003, Framework 1.1, Windows XP and SQL Server I have two sets of...
5
by: Bruce Schechter | last post by:
I just started to develop an ASP.NET application in vs.net 2003 . But each time I try to execute the application (which is basically empty so far), I get a dialog box titled "Microsoft Development...
3
by: Olivogt | last post by:
Hello, I was just puting an application on the web server but it did not work as usual... - I do develop on my notebook and move released applications to the Web server - both have Sql Server...
1
by: ssp | last post by:
G'Day All, I have a web application sitting on my laptop and a Sql Server 2000 database on our INTRANET server running Windows 2003. Up until recently I was able to access the database using my...
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...
2
by: itfetish | last post by:
I've just upgraded our WIndows 2003 (with SBS server) web server to .Net framework 2.0 (it had 1.1 before) As I have been working on a web parts page on my laptop, hosting it there, working...
3
by: LamSoft | last post by:
I am not going to write a aspx to connect a SQL Server... but it tries to connect the SQL Server... Some of the Code.. protected void LoginButton_Click(object sender, EventArgs e) { if...
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
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: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
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)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
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.