473,803 Members | 4,391 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Q: SQL Server login error, used to work fine?

Just this week I have discovered that my ASP.NET apps do not connect
properly to SQL server anymore. If I try to connect to the server by name,
I get the error "SQL Server does not exist or access denied."

However, if I change the SQL server connection string to use IP address, I
can connect successfully. I am using SQL Server Security (not integrated)
to connect to the SQL server. I have tried adding "Net=dbmsso cn" to the
connection string and adding the server name to my HOSTS file just in case
there was a named pipes issue or a slow lookup; neither thing helped. I can
ping the server by name with no problem, and other apps (e.g. VB 6 apps) can
connect by server name.

The failures on the client correspond to logon failures on the server for
WORKSTATION\ASP NET. (Logon Type 3, process NtLmSsp, plus another error code
3221225572.) My workstation connects to the network via a VPN, just in case
it's relevant.

The app shouldn't be trying to connect as WORKSTATION\ASP NET at all, and I
definitely don't understand why it started to do this out of the blue. My
guess is it has something to do with the security updates I installed last
week (against Sasser, I don't remember the #s), but that is only a guess.

Has anyone had any related problems, perhaps associated with the latest
security updates? Or have any insight why my app refuses to use SQL Server
authentication with the server name?

Matt
Nov 18 '05 #1
0 1017

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

Similar topics

1
8191
by: Tom Jones | last post by:
Hi, I have MS SQL Server set up on a win2k box (and am running my PHP scripts on the same box that SQL Server is on) ... not connected to a network and just using the command line version of PHP ... (no web server) I set up ODBC with a DSN for the login and password I installed in SQLServer I set up the DSN for "local" i.e. on the local server
2
1602
by: Chris Stewart | last post by:
We're having an issue here at school with trying to access a SQL Server database from a .NET application. As a department, we roll out a generic image to all of our lab computers. For some reason we were getting "SQL Server does not exist or access denied" errors ( http://www.isy.vcu.edu/~cstewart/sqlerror.jpg ). One of the lab machines in the lab worked fine and could connect without any issues. As a quick fix, we re-imaged 3 of the...
13
2286
by: Edward Mitchell | last post by:
I have a problem that involves the error I receive when attempting to complete the asp.net web application example (Walkthrough: Creating a Web Application Using a Third-Party Business Object). When I first create the SQL connection in VS.NET 2003, I test the connection and everything works fine. However, when I attempt to run the first stage of the app (the bound datagrid), I receive an error stating: login failed for user...
4
1359
by: Brent Waldrop | last post by:
Ok everyone, i have been pulling my hair out on this one. I have been working on it for 3 days with no sucess. This problem is occuring at home where i am running a workgroup. I have Windows 2003 Ent Server on one machine and windows xp sp2 on another. The db server is located on the Windows 2003 machine. I am working locally with asp.net 1.1 on the xp workstation and the web server is also locally on the xp workstation. Every time i try...
22
3438
by: Bob and Sharon Hiller | last post by:
I have an ASP page that was done in VBScript It is setup to read an Access database and I need to change it to read a Sql 2005 Database. The code that is used to open the Access Database: Set adoConnection = server.CreateObject("ADODB.Connection") Set adoRecordset = server.CreateObject("ADODB.Recordset") adoConnection.Provider = "Microsoft.Jet.OLEDB.4.0" Dim strLocation, iLength
0
1219
by: Don | last post by:
When I attempt to access a SQL Server database from my ASP.NET 1.1 application I get the folllowing error: Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection. I have impersonate set to true with the following setting in my web.config file. <identity impersonate="true" userName="" password=""/> This project had been working fine. A few weeks ago I installed Visual
0
1064
by: zeplynne | last post by:
Having trouble using ActiveDirectoryMembershipProvider with one specific website. When attempting to login to the site, after a long period of time (about 2 - 3 minutes), "Server Application Unavailable" message is returned. If I switch the provider back to SQLServer everything works fine. If I create a new simple Web Application and just add a Login.aspx page and Default.aspx page, and nothing else, and add a Login Control everything...
3
3263
by: Lee T. Hawkins | last post by:
I am having a number of problems over the last two full days trying to get an ASP.NET 2.0 application to connect to a SQL Server 2005 database... First off, I built this application w/ Visual Studio 2005 SP1 and had it working perfectly on my Windows XP machine on SQL Server 2005 Express. I decided to publish this application to a test development server (with both the SQL and IIS servers on the same box) running on: Windows Server...
2
2293
by: gnewsgroup | last post by:
OK, I know this has been a popular question from newbies. But, please don't haste to reply yet. I've googled and tested for a few hours, and cannot have this problem resolved. I have followed articles on the web and enabled "SQL Server and Windows Authentication" for my SQL Server 2005. But, it does not solve my problem. (It is actually my default setting for my SQL Server)
8
6340
by: Brett | last post by:
I wrote an ASP.NET application that queries a SQL Server database (on a different box from the web server) and displays the result in a GridView. The datasource for the GridView is a SQLDataSource. Just to get it to work, I hard-coded the username and password of a SQL Server account in the connectionstring in web.config. Once I confirmed that this worked on the web server, I wanted to remove the hard-coded password from web.config, so I...
0
9562
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
10542
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
0
10068
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
9119
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
7600
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
6840
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
5625
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
4274
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
3
2968
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.