Hi all,
I keep getting a bizarre login error, when trying to connect to a SQL Server 2005 database on a local domain to my machine using C#. The Exception returns: SQLException: Login failed for user 'OURDOMAIN\PC-DAVIDC$'.
Where "OURDOMAIN" is the domain my computer is connected to, and "PC-DAVIDC" is the computer name.
What's weird about this though, is this isn't in the connection string. Nor is it a valid NT account on the Active Directory my computer is connected to, or on the local machine itself. I have absolutely no idea where C#/SQL Server is getting this fake login from.
Does anyone know what might cause this kind of issue? It baffles me as to why it's saying "OURDOMAIN\ PC-DAVIDC$", and not "OURDOMAIN\Davi d Costello" which is the actual NT account it would usually log in with.
I don't even know what to google for, to look up this issue. :S
The connection string in question is, and has always been: Data Source=SRV-DB01;Initial Catalog=Develop ment;Integrated Security=SSPI;
The c# connectivity code isn't really an issue, as it connects fine to other databases on the same server. My account has permission to access the database in question. Nothing has really changed in the past few days since it was working fine. It's just utterly bizarre.
Any advice would be much appreciated.
2 2388 Motoma 3,237
Recognized Expert Specialist
Am I understanding you right? The code will connect to other databases on the same server, but just not that particular one?
Am I understanding you right? The code will connect to other databases on the same server, but just not that particular one?
Indeed.
I wanted to try and edit the post to refresh what I'd written, but I can't seem to edit it any more. :S
I didn't mention I was running the code in question as a Windows Service, and it would appear the problem laid in the fact that the service was running under the local system user account, instead of under a domain administrator account.
The problem seems to be fixed now. :)
Sign in to post your reply or Sign up for a free account.
Similar topics |
by: Frodo |
last post by:
I have a problem establishing a link between Visual
Studio.NET 2003 and SQL Server 2000. Both are installed on
a Windows Server 2003, standard version.
Visual Studio.NET Issues
===================
From Visual Studio.NET 2003 I attempt to ‘Connect to a
database’
The ‘Data Link Properties’ dialog box appears.
|
by: Gareth |
last post by:
Can somebody help me with the following problem I have?
Configuration:
1 x Microsoft Windows Server 2003 Web Edition + IIS 6.0 + ASP.NET
1 x Microsoft Windows Server 2003 Standard Edition + SQL Server 2000 Service
Pack 3
Both PC's are installed on a separate switch so that they can talk to each
|
by: RedEye |
last post by:
Hello,
I am working on a test site to explore the new login controls and membership
features of ASP.NET v2.0. I have tested the controls using SQL Express and
have now decided to try using a central SQL Server 2000 database. When I use
the all of the included controls with SQL Express everything works great but
when I use it against SQL Server 2000 I can't get past the login page.
When in Visual Studio IDE and open the web admin page I...
|
by: Mr Newbie |
last post by:
I was thinking about developing a workflow application yesterday and was
musing over the different approaches than one could take in restricting
specific actions on a ticket( Form ) at any said stage.
One approach I have used on other systems is to prevent the action buttons
appearing. For example, if one did not have the Role of Administrator, one
would be prevented from deleting a ticket not created by oneself.
However, it did occur...
|
by: coosa |
last post by:
Hi,
I was installing SQL Server on my machine and during installation my PC
freezed. It happens frequently on my machine. So i tried after
restarting to install it again and since then i always get the same
error message:
"An error occurred while creating one or more registry entries. Please
see C:\WINDOWS\sqlstp.log for details. The problem could be caused by a
low registry quota condition"
I have tried to clean the registry and i...
| |
by: VB Programmer |
last post by:
When I run my ASP.NET 2.0 web app on my dev machine it works perfect. When
I precomile it to my web deployment project and then copy the debug files to
my web server I get this problem when trying to login (obviously it's using
ASPNETDB.mdf). Any ideas?
Server Error in '/' Application.
--------------------------------------------------------------------------------
|
by: craig.overton |
last post by:
All,
I am currently developing an FTP class in VB.NET. It's kid tested,
mother approved when trying to access an FTP Server on a Windows box
meaning I can connect, run commands, upload and download a file no
problem. My issues come when I try to use the same class with the same
commands to access an FTP server on a UNIX box. I can connect and login
just fine, but after that all my commands come back "500 'PWD': command
not understood."....
|
by: matt.delvecchio |
last post by:
i saw a similar post from last year, but i didnt see any clear
solution. the error message:
"A connection was successfully established with the server, but then an
error occurred during the login process. (provider: TCP Provider,
error: 0 - The specified network name is no longer available.)
Exception Details: System.Data.SqlClient.SqlException: A connection was
successfully established with the server, but then an error occurred...
|
by: Gr8Ongole |
last post by:
Hi,
I have a SQL Server 2005 running on my machine with a named intance.
Recently I have got a DSL connection. After that the Microsoft SQL
Server Management Studio started giving connectivity issues.
Here I have copied the error Message. Could anybody help me out in
finding what is actually going wrong after getting a DSL Connection.
Thanks in Advance,
|
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...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
| |
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,...
|
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...
|
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...
|
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...
|
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...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
| |
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
| |