ODBC Error: SQLState 28000 && Server Error 18452
Feb 12, 2007
I have an application that connects to SQL 2000 thru ODBC.
When our administrators login on the workstation the application
works well. But when ordinary users login they get the following error.
SQLState: 28000
SQL Server Error: 18452
Login failed for user ". The user is not associated with a trusted SQL Server connection.
I have restarted SQL Server and IIS to no avail. We are using SQL and Windows auth mode.
Any ideas? This just started this morning.
View 1 Replies
ADVERTISEMENT
Oct 9, 2006
We have an application that connects to SQL 2005 thru ODBC with the following string:
driver=SQL Server;server=server1;database=db2005;uid=serveruser;pwd=pwd1;
When our administrators login on the workstation the application works well. But when ordinary users login they get the following error. (We only have 1 domain)
SQLState: 28000
SQL Server Error: 18452
Login failed for user ". The user is not associated with a trusted SQL Server connection.
Then the standard SQL Server Login window pops up asking for the Login ID and Password. On the window the 'Use Trusted Connection' is checked and the name of the user on the workstation appears on the LoginID. What we do is uncheck the 'Use Trusted Connection' then login using the credentials above.
Need help on this one please. Thanks.
View 9 Replies
View Related
Jun 1, 2007
Hi All,
There are two servers €˜A€™ and €˜B€™. At server €˜A€™, there is installed Window server at server €˜B€?, there is installed Window Server2000. And both servers have SQL SERVER 2000. I have created link server from A to B. I have to insert data into table of server €˜B€™ from server €˜A€™. When I used directly insert command like
Insert into [server name (B)]. [Database]. [Owner].[table name]
Select * from [server name (A)]. [Database]. [Owner].[table name]
The data is inserted successfully.
But when I created Jobscheduling , it is failed and show message :-
"Executed as user: HOerpserver. Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection. [SQLSTATE 28000] (Error 18452). The step failed."
Try to find out solution for this problem.
Regards,
Nikhil Chaturvedi
View 3 Replies
View Related
Dec 12, 2007
Can anyone give a quick description of the meaning of this message andwhat needs to be done to get a connection.I'm running DBArtisan with SQLServer 2000 client SP4 installed.I also get the same message with MS Enterprise Manager so this iscoming out of the actual ODBC connection attempt.Thanks in advance!
View 1 Replies
View Related
Jul 20, 2005
sql server 2000 8.00.194Microsoft Windows 2000 Service Pack 2I looked into my sqlserver agent log and found the followingODBC Error 0 Timeout expired[SQLSTATE HYT00]logon to server local '( failed)' (Job manager)I have no idea what that means but it did keep out users for a minute or more.The threads found on this forum almost all point to reccuring situationsmine is a sporadic one time issue.Is it Ok to conclude it is a network error as I did?TIAVince
View 1 Replies
View Related
Nov 15, 2007
Hi,
This is my first posting and actually I have big problem which I need to resolve immediately:
I have a 38 GB Database on my SQL Server which I want to full-backup. Until now backup was created on the same volume where the database resides. But now the volume is out of disk space. So what we did is that we connected an external USB disk drive with 500 GB to the SQL Server and try to backup there.
But our first and all consecutive backup attemps failed with error SQL-DMO (ODBC SQLState: 42000). It's working fine the first few minutes as we can see that the backup file is continously growing. But then it abruptly aborts with above error message.
Can anyone figure out why ? Any help is appreciated.
Thx
Overlord1970
View 5 Replies
View Related
Jan 18, 2008
Good morning all. I need some help with a stored proc that is driving me up a wall. It's probably something stairing me right in the face but I can't see it!
I keep getting the following error on the procedure that I'm working on:
SQL-DMO (ODBC SQLSTATE: 42000)
ERROR 156: Incorrect syntax near keyword 'AS'
Must declare the variable '@signid'
Must declare the variable '@signid'
Here's the code:
CREATE PROCEDURE [dbo].[ws_savesignature2db]
@xml as text='',
@image as image='',
@imageformat as varchar(20)='',
@imagename as varchar(40)='',
@imagesize as int=0,
AS
insert into signaturetable
([image], imageformat, imagename, imagesize)
values
(@image, @imageformat,@imagename,@imagesize)
/*
if your XML field datatype is Text or nTEXT, use the code below in Sql Server 2000.
If you use Sql Server 2005, you can use varchar(max) or nvarchar(max) which will be
much easier and you do not need the code.
*/
select @signid = @@IDENTITY
DECLARE @ptrval binary(16)
SELECT @ptrval = TEXTPTR([xml])
FROM ws_signature
WHERE signid= @signid
if @ptrval is not null
WRITETEXT ws_signature.xml @ptrval @xml
GO
Any help you can give would be a life saver!!!!
Thanks in advance.
Jim
View 3 Replies
View Related
Sep 6, 2007
Here's a real puzzler. I have a remote SQL Server running on a different domain than the one I am logged in to. From my own PC, logged in as myself, I can create an ODBC connection to this remote server (using integrated authentication) with no problem. When I log in to any other PC as myself, I get the "28000 (18452) Not associated with a trusted connection" error. This would therefore seem to be a PC-specific problem, but I can't see any difference between the PCs. All PC's are running the same version of MDAC.
Firewall is down, no proxy is involved, and I have given myself Administrative privelege on the PCs.
Can anyone explain this? Thanks in advance.
View 9 Replies
View Related
Jan 23, 2007
I have SQL 2000 installed in my windows 2003 server with mixed mode authentication. When I login to the server and open the SQL server manager under my windows name everything works. And if I try to create an odbc connection from one of the client pc's or from the server itself using windows authentication still everything works. Now I opened the SQL enterprise manager and in the Security section, there is a user group called BUILTINAdministrators, I was asked to deny access to this group in SQL. So I did that and added my windows login name in the security -> Login section. Now still if I try to open the enterprise manager and and login to sql under my windows login name it works. But if I try to create an odbc connection to the sql server either from the server itself or from the client work station I get the following error:
connection failed:SQLstate: '28000'SQL Server Error: 18456[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'PRODpchelin'
If I go to the security -> Login and enable BUILTAministrators group, everything works. But I would like to know how to disable that group and add my own windows group or login id in SQL server and connect using ODBC.
Your valuable feedback is greatly appriciated.
View 3 Replies
View Related
May 5, 2008
Hi Guys:
Our company wanted to try out SQL Server 2005 Enterprise Edition (64 Bit). So, we were on free trial of the Enterprise Edition for past 5 months. After which we decided to go for SQL SERVER 2005 Standard Edition (64 Bit). And, Last week, we installed the SQL Server Standard Edition (64 Bit) on our server. After installation, everything was restored as before.
The version we are on right now is:
Microsoft SQL Server 2005 - 9.00.3054.00 (X64) Mar 23 2007 18:41:50 Copyright (c) 1988-2005 Microsoft Corporation Standard Edition (64-bit) on Windows NT 5.2 (Build 3790: Service Pack 2)
Strangely, a job which ran fine till then is failing with the following error: And, to be more specific, when this job is run manually in the form of a stored procedure using the query optimizer it runs fine. But, when its executed as a scheduled job on SQL Agent, it fails. The History logs record the following error.
Error :
The OLE DB provider "SQLNCLI" for linked server "LV-SQL2" reported an error. Authentication failed. [SQLSTATE 42000] (Error 7399) Cannot initialize the data source object of OLE DB provider "SQLNCLI" for linked server "LV-SQL2". [SQLSTATE 42000] (Error 7303) OLE DB provider "SQLNCLI" for linked server "LV-SQL2" returned message "Invalid authorization specification". [SQLSTATE 01000] (Error 7412).
I tried everything possible, even recreated the job, but, no avail.
I also considered the possibility if SQL Agent login account did not have enough permissions. So, I changed the SQL Agent login to windows authentication, but the job still fails. So, its the problem has nothing to do with login accounts either.
For the record, I have cross checked all these too.
1. Enabled the remote connections in Surface Area Config
2. Added local server login to remote server login mappings.
3. Checked 'Rpc' and 'Rpc Out' under server options. Also, the Connection Timeout and Query Timeout have been set to zero (0).
Any suggestions pointing towards problem solution appreciated.
Thank you.
View 4 Replies
View Related
May 3, 2008
hello,
we have changed the name of MS SQL server 2005 from XYZ to ABC using
sp_dropserver <old_name>
GO
sp_addserver <new_name>, local
GO
Now our maitenance plan is getting failed we are not able to execute backup jobs we are getting following error
Date 03.05.2008 16:00:00
Log Job History (ADM_AdminDB_TP_Backup.Subplan_1)
Step ID 0
Server ABC
Job Name ADM_AdminDB_TP_Backup.Subplan_1
Step Name (Job outcome)
Duration 00:00:00
Sql Severity 0
Sql Message ID 0
Operator Emailed
Operator Net sent
Operator Paged
Retries Attempted 0
Message
The job failed. Unable to determine if the owner (XYZSQLServer) of job ADM_AdminDB_TP_Backup.Subplan_1 has server access (reason: Could not obtain information about Windows NT group/user 'XYZSQLServer', error code 0x534. [SQLSTATE 42000] (Error 15404)).
please help us in this issue
View 13 Replies
View Related
Nov 3, 2006
I'm using Sql Server Express on Windows xp Home Edition, I have created a user FAB in Sql server and then I have given it the rights as a server adminstrator. For creating a user I have followed the video tutorial from the web site of SQL Server Express.
But when I want to connect with SQL Server Express using Sql server authentication it gives me the following error:
Login failed for user 'FAB'. The user is not associated with a trusted SQL Server connection. (.Net SqlClient Data Provider)
Error Number 18452,
I have searched [ Sql Express Error 18452 ] from google and read many articals but I can't find any artical which can solve my problem.
Can anybody help me please?
Shahid Mahmood
View 1 Replies
View Related
May 3, 2006
Using sql2005 on a Novell network...
When attempting to log into Mgt Studio using windows authentication I am getting the error: Error 18452 (not associated with a trusted sql server connection) .
I added my domainuserName in sql with no problems and added the account to the sysadmin server role. However, I noticed my credentials on my pc are not listed as domainuserName but rather ComputerNameUserName. I think this is what is causing the problem but I am not sure. Can anyone lend a hand?
I'd appreciate any help,
Thanks.
Scott
View 52 Replies
View Related
Mar 9, 2006
Hello,
I have a problem that I hope anyone here can help me with. We have a new server with Windows Server 2003 installed as well as MS SQL Server 2005. Both of these are freshly installed with default options set. The server is configured to accept both windows certification and SQL server certification (mixed), and our company has a domain setup. This server will be used for internal development, so all of the necessary people have an administrator account on the domain, which is uploaded currently into SQL Server's Security > Users folder. When I am on the server itself, I can log in using my domain name with no problem, as well as sa. However, when I try to connect to the server remotely (by my machine down the hall) using Windows Authentication I cannot. The server has BUILTINAdministrators set up for users, as well as 'sa' and whatever other defaults were there.
I CAN connect using sa remotely on my machine, though, after I enabled the account. The error message I get when I try to log in through Windows Authentication is:
*********************************************
TITLE: Connect to Server
------------------------------
Cannot connect to LAF-SQL1.
------------------------------
ADDITIONAL INFORMATION:
Login failed for user '(null)'. The user is not associated with a trusted SQL Server connection. (Microsoft SQL Server, Error: 18452)
*********************************************
No other options other than what I've mentioned are installed. The (null) is not present, but the error message shows up as two single quotes ''. I strongly suspect there is a security option set by default somewhere in WinServer or SQLServer that does not permit remote connections, but I do not know where.
Help would be greatly appreciated here.
-Matt
View 3 Replies
View Related
Mar 11, 2008
I've received this error twice over 2 days in the SQL Agent error log during off-hours from a server which has not had any changes to it in the last few months (once at 3:32AM and the next day at 3:46AM. I've been able to tie it to log-shipping backup jobs (all of which run under the SQL Service domain account) which run every minute. It seems to be only momentary, as the next attempt a minute later is successful.
I get the same set of messages for each database for the same time which look like this:
Date 07.03.2008 3:31:51 AM
Log SQL Agent (Current - 10.03.2008 6:15:00 PM)
Message
[298] SQLServer Error: 258, TCP Provider: Timeout error [258]. [SQLSTATE 08001]
Date 07.03.2008 3:31:52 AM
Log SQL Agent (Current - 10.03.2008 6:15:00 PM)
Message
[165] ODBC Error: 0, Login timeout expired [SQLSTATE HYT00]
Date 07.03.2008 3:31:52 AM
Log SQL Agent (Current - 10.03.2008 6:15:00 PM)
Message
[298] SQLServer Error: 258, Unable to complete login process due to delay in login response [SQLSTATE 08001]
Date 07.03.2008 3:31:52 AM
Log SQL Agent (Current - 10.03.2008 6:15:00 PM)
Message
[382] Logon to server '(local)' failed (SubSystemStepHistoryLogger)
I can't find any documentation on these errors on the web or MSDN site. Can I chalk this up to possibly "winking" connection to our domain controller? We've never had these messages before, and our LAN department swears that there have been no upgrades to the network or domain controller servers recently.
View 25 Replies
View Related
Nov 5, 2007
I'm not sure if this is the correct group for this messages, but here it is anyway.
I have a job that has 3 steps to, periodicly the job errors out on Step 1. Following is the message (from Job History).
--------------------
Executed as user: SMIsqladmin. The operation could not be performed because the OLE DB provider 'SQLOLEDB' was unable to begin a distributed transaction. [SQLSTATE 42000] (Error 7391) [SQLSTATE 01000] (Error 7312) OLE DB error trace [OLE/DB Provider 'SQLOLEDB' ITransactionJoin::JoinTransaction returned 0x8004d00a]. [SQLSTATE 01000] (Error 7300). The step failed.
--------------------
Can someone please explain this message, I have no idea how to fix it or what the cause is.
Thanks
David Davis
View 1 Replies
View Related
Mar 1, 2000
Hi there,
I'm getting the following error when I try to run replication from Server A to Server B
28000 Login failed.
I have checked ODBC driver, client Configuration, Remote server set up and everything seems to be set up correctly.
I have also checked NT trusted Relationships and it is ok,
I can, however replicate data from Server B to server A
Does anyone have any thoughts on this,
Thanks in advance
Fin
View 1 Replies
View Related
Mar 9, 2006
a customer is getting on mS SQL 2000ERROR ODBC 28000 Invalid authorization specificationI dont understand because all the rigth are OKASP NET USER, IISS user and so on !i am trying to connect the to SQL from ASPX pages (it works for me and a few customers but not that one)what can be the problem ?thank you
View 6 Replies
View Related
Apr 27, 2006
Hi,
If I connect to
SQLServer Express via Windows Authentication it works
fine. But if I use SQL Server Authentication it doesn't work with a new
created user and
sa (with a new password) too. I turned mixed mode on, registry key
HKLMSoftwareMicrosoftMicrosoft Sql ServerMSSQL.1\MSSQLServerlogin
has the value 2 and all ports are set to 1433 but there is still
error 18452. Any suggestions?
View 7 Replies
View Related
Jul 23, 2001
The error is:
Connection failed:
SQL State '37000'
SQL Sever Error: 18452
[Microsoft][ODBC SQL Sever Driver][SQL Server]Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection.
I have verified in Enterprise Manager that the concerened login is using a Windows 2000 Authentication and has the correct grant access permissions set up for the default database. Also switching to SQL Server Authentication or disabling security are not the options available in this case.
How to resolve this please-any help is welcome.
thanks
Sanjeev
View 1 Replies
View Related
Feb 16, 2000
I keep getting this error when tring to log in to a SQL 7 db from a client application written in VB6.
The text reads:
Login failed for user 'rmuser'. Reason: Not associated with a trusted SQL Server connection.
I have the account setup in SQL security and I have the account listed in the database and I'm using named pipes on a common domain. I'm running out of options. The network is a mix of Novell and NT. Please help
View 1 Replies
View Related
Jun 24, 2007
Hi to all.
I'm trying to log in on local machine to my SQL Server 2005 (in Windows Server 2003) using a user not trused, like as 'sa' user, but I receive the error Login failed for user 'sa'. The user is not associated with a trusted SQL Server connection. (Microsoft SQL Server, Error: 18452).
No problem to connect with trusted user (my logon user to operating system).
I set the auth mode to SQL Server & Windows but doesn't work.
What can I do?
Ciao.
View 3 Replies
View Related
Oct 21, 2005
We have 2 failover servers and one client in our test environment. We have all the three configured in mixed mode authentication(windows + sql server authentication). But when we are failing over from 1st server to 2nd one, we are getting the following error message,
View 3 Replies
View Related
Aug 21, 2007
Login Failed for user , the user is not associated with a trusted sql server connection. (microsoft SQL Server,Error:18452)
hi ,
i am getting the above error message once in a while maybe two or 3 times a week , and then it goes away in 10 to 15 minutes or 5 minutes ,
our mode is set to mixed and we are able to connect and use both sql and windows , but once in a while , it will give us the above message when we try connecting throught sql server management studio client (using sql 05) using windows login , although it lets us connect using sql login while the windows login is denied, and after a while it lets us connect with both.
occurs randomly on some days , we run our servers on VM ware virtual machines using windows 2003 r2 enterprise 64 bit with sp2 with esx 301 virtual machine.
would appericate any feedback on this thanks
View 5 Replies
View Related
Mar 11, 2008
I received the above error yesterday and haven't been able to trace it to any job or process running. We haven't implemented any changes to the server in the past few months, and it doesn't look to be a user-established connection, since the Client IP Address of the SSPI handshake error is from the server itself.
I logged this set of messages in SQL AgentServer error log:
Date 10.03.2008 6:15:19 PM
Log SQL Agent (Current - 10.03.2008 6:15:00 PM)
Message
[298] SQLServer Error: 18452, Login failed for user ''. The user is not associated with a trusted SQL Server connection. [SQLSTATE 28000]
Date 10.03.2008 6:15:19 PM
Log SQL Agent (Current - 10.03.2008 6:15:00 PM)
Message
[382] Logon to server '<server>' failed (ConnAttemptCachableOp)
Date 10.03.2008 6:15:19 PM
Log SQL Server (Current - 11.03.2008 2:32:00 PM)
Source Logon
Message
Error: 17806, Severity: 20, State: 2.
Date 10.03.2008 6:15:19 PM
Log SQL Server (Current - 11.03.2008 2:32:00 PM)
Source Logon
Message
SSPI handshake failed with error code 0x80090304 while establishing a connection with integrated security; the connection has been closed. [CLIENT: <IP Address>]
Date 10.03.2008 6:15:19 PM
Log SQL Server (Current - 11.03.2008 2:32:00 PM)
Source Logon
Message
Error: 18452, Severity: 14, State: 1.
Any help in explaining this would be greatly appreciated.
View 8 Replies
View Related
Nov 7, 2007
Hi
Last week I was receiving an error when trying to connect to two of our seven sql servers from my laptop via my domain admin account. The only fix was to have my laptop rebuilt and everything re-installed.
Today however another administrator is starting to have the same problem but to only one of the seven servers!
When that administrator uses my laptop with her domain admin account it works!?
What could possibly be going wrong with our laptops? We have not installed or changed anything.
The full error message we see:
Login failed for user ''. The user is not associated with a trusted SQL Server connection. (Microsoft Sql Server, Error: 18452)
The error being logged on the server: (two errors are logged each time)
SSPI handshake failed with error code 0x8009030c while establishing a connection with integrated security; the connection has been closed. [CLIENT: 53.35.165.148]
Login failed for user ''. The user is not associated with a trusted SQL Server connection. [CLIENT: 53.35.165.148]
View 16 Replies
View Related
Jun 5, 2007
Mircrosoft recommends that you change the authenication from Windows Authenication to SQL and Windows Authenication. This will allow users to gain access to the SQL server.
View 1 Replies
View Related
Oct 28, 2007
When I use sa to log into one of my database , it give me the following error: The user is not associated with a trusted conncections. error code: 18452, please tell me how to solve this problem.
I appreciate your help.
View 1 Replies
View Related
Nov 19, 2007
Hi Experts,
Can anyone help me to identify the problem? The situation of my problem is : My company network in clients side is running either Window XP Pro or Window Xp Home.The problem occur when i access from Window XP Home to Server (Window Server 2003) an error pop up Sql Express Error 18452. It is worked fine in WIndow XP Pro version.
Thanks for anyone provide me a solution.
View 15 Replies
View Related
Jun 19, 2001
I am having a problem with a Job Step that is failing. The actual Step runs
a Stored Procedure, but the Job keeps failing and returning the following
error
"sqlmaint.exe failed. [SQLSTATE 42000](Error 22029). The step failed."
Does anyone know what this means ?
Thanks.
View 1 Replies
View Related
Sep 14, 2004
during maintenance plan i get following error :
Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 5070: [Microsoft][ODBC SQL Server Driver][SQL Server]Database state cannot be changed while other users are using the database 'AJAX'
[Microsoft][ODBC SQL Server Driver][SQL Server]ALTER DATABASE statement failed.
[Microsoft][ODBC SQL Server Driver][SQL Server]sp_dboption command failed.
[8] Database AJAX: Check Data and Index Linkage...
[Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 7919: [Microsoft][ODBC SQL Server Driver][SQL Server]Repair statement not processed. Database needs to be in single user mode.
View 2 Replies
View Related
Aug 7, 2007
Hello,
I'm having trouble running jobs with my active directory (ADS) account. I've setup my SQL services to run under an ADS account, but jobs cannot seem to query ADS for user information. We're running Windows Server 2003 and SQL Server 2005 SP2.
Here is the error message:
==
The job failed. Unable to determine if the owner (ADSme) of job eFASRtest has server access (reason: Could not obtain information about Windows NT group/user 'ADSme', error code 0x5. [SQLSTATE 42000] (Error 15404)).
==
also this message in log:
==
[298] SQLServer Error: 15404, Could not obtain information about Windows NT group/user 'ADSme, error code 0x5. [SQLSTATE 42000] (ConnIsLoginSysAdmin)
==
I already tested the suggested:
execute as login='adsme' and I get the same error on both (my local installations and production)
appreciate your help
View 23 Replies
View Related
