Not Associated With A Trusted SQL Server Connection Error
Aug 24, 2005
Hello all. I'm still learning SQL Server so hopefully you'll be patient with me. I've been using mostly MS Access db files in all my web sites ...but SQL Server on a few of them.I've installed SQL Server 2000 Personal Edition for web development (testing). I installed it under my log in name to this particular machine and used the same password and installed using Windows Authentication. I opened Ent Mgr and created a first database. I imported my Access data and all is well so far.I "convert" a test page to connect to my local SQL Server using the uid and pwd and get the error in the subject. I double check and the uid & pwd is in fact correct in the Security >> Logins section and it matches my code. I switch my connection string to use "sa" with and without a password....same results. I add ASPNET as a user and give it access to the new db and same results again. I also tried to enclose my Accout/Machine ID in single quotes in my connection string and no luck. Any ideas as to what I might be missing? Again - I also tried "sa" - no luck.server=MyMachineName; uid=Shane Fowlkes; pwd=123456; database=NewDatabase
Login failed for user 'Shane Fowlkes'. Reason: Not associated with a trusted SQL Server connection.
View 1 Replies
ADVERTISEMENT
Feb 19, 2007
Hi I've got a common error using SQL server 2005
"The user is not associated with a trusted SQL Server connection"
I'm building a application using C# when using a standalone environment, it worked well. But, now I have the following environment.
A.
SQL server
Domain XXX
B. Remote machine
Application
Domain YYY
I changed SQL server to support SQL and WIN authentication mode and I have changed SQl server surface area configuration to support TCP/IP and Named Pipes for remote connections. But I still have two problems:
1. When using the IP - serverName of the dataserver, the error is
System.Data.SqlClient.SqlException: Login failed for user ''. The user is not associated with a trusted SQL Server connection..
1. When using the server name(MYServerName), I have this error:
System.Net.Sockets.SocketException: A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond.
Besides, I have tried from my remote machine to use a sqlcmd -E -S tcp:myhost command but I have the same answer.
Any help, I will thank.
View 2 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
Jun 24, 2007
Hi, I have installed MS SQLExpress 2005 on our test sever (W2K3), not a domain controller, created a database and added some tables. I am using this connection string in a asp script but get the following error when trying to connect to the database.
strAsgSQLConn = "Provider=SQLNCLI; Server=BENDERSQLExpress; Database=myasg; Uid=Admin Pwd=password"
Microsoft SQL Native Client error '80004005'
Login failed for user 'Admin€™. The user is not associated with a trusted SQL Server connection
The account I am using is the server admin account. I have installed QL Server Management Studio Express on both the server and a client PC and can connect to the database from both fine. I have tried setting the security on SQLExpress to both Windows Authentication and SQL Authentication but neither works.
Cheers
John D
View 9 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
Oct 20, 2006
Hi,
I have a piece of Java code that needs to connect to SQL 2000 (SP4) using Windows Authentication. It's running on Windows Server 2003 SP1.
I tried JDBC v1.1 and followed the code from the following blog:
http://blogs.msdn.com/angelsb/default.aspx?p=1
But still get this error as shown below. Any help appreciated.
I am using JDK1.4.2, "sqljdbc_auth.dll" is located under "E:SQL2005JDBCDrvsqljdbc_1.1enuauthx86", also made a copy under "E:JavaTest" and "C:WindowsSystem32" but still won't work.
Cheers
Allan
===========================================================
E:JavaTest>javac -classpath ".;E:JavaTestsqljdbc.jar" TestW2.java
E:JavaTest>java -classpath ".;E:JavaTestsqljdbc.jar" -Djava.library.path=E:S
QL2005JDBCDrvsqljdbc_1.1enuauthx86 TestW2
com.microsoft.sqlserver.jdbc.SQLServerException: Login failed for user '(null)'.
Reason: Not associated with a trusted SQL Server connection.
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError
(Unknown Source)
at com.microsoft.sqlserver.jdbc.IOBuffer.processPackets(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.processLogon(Unknown
Source)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.logon(Unknown Source
)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.connectHelper(Unknow
n Source)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.loginWithoutFailover
(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.connect(Unknown Sour
ce)
at com.microsoft.sqlserver.jdbc.SQLServerDriver.connect(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at TestW2.main(TestW2.java:7)
===========================================================
The code is simple (TestW2.java):
import java.sql.*;
public class TestW2 {
public static void main(String[] args) {
try {
java.lang.Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
Connection conn = java.sql.DriverManager.getConnection("jdbc:sqlserver://VMW2k3ENT003.TESTCBFPOC.COM.AU;integratedSecurity=true");
System.out.println("Connected!");
conn.close();
} catch (Exception ex) {
ex.printStackTrace();
}
}
}
==============================================================
View 27 Replies
View Related
Aug 11, 2005
can any one help
View 3 Replies
View Related
Mar 24, 2008
I installed sql server 2000 personal edition in a PIV mechine. it asked an instance name and installed as mixed mode. When i connect to the database through isqlw only alows windows authentication only. it gives the error like ' the user sa login failed because the sa is not associated with trusted connection' - i don't understand this please help me.
View 1 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
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
Jan 12, 2012
I'm trying to connect to a SQL Server database from a web app programmed in C#/ASP.NET. It's throwing an exception that says "Login failed for user 'CISUser'. The user is not associated with a trusted SQL Server connection."
I've searched around for solutions to this problem and the only one I've come across is to change the authentication mode in the SQL Server Management Studio from "Windows Authentication" to "SQL Server and Windows Authentication". But on my machine, it's already set to "SQL Server and Windows Authentication". I've restarted the server and still I'm getting the same issue.
View 5 Replies
View Related
Feb 18, 2008
All the research I found dealing with this problem is that the solution is to set SQLserver to mix mode. I have SQL server already set to mix mode. I am not sure what else to do. Has anybody run into this problem?
my connection string: <connectionStrings>
<add name="ConnectionString" connectionString="Data Source= server name ;
Initial Catalog=FILESHAREDB.MDF;
Integrated Security=false;"providerName="System.Data.SqlClient"/>
</connectionStrings>
Server Error in '/SendItNow' Application.
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: System.Data.SqlClient.SqlException: Login failed for user ''. The user is not associated with a trusted SQL Server connection.Source Error:
Line 41:
Line 42: 'open the connection and execute the stored procedure
Line 43: mConnection.Open()
Line 44: mResourceID = mCommand.ExecuteScalar()
Line 45: mConnection.Close()Source File: H:MIS DepartmentIntranetSendItNowApp_CodeDalResourceDB.vb Line: 43 Stack Trace:
[SqlException (0x80131904): Login failed for user ''. The user is not associated with a trusted SQL Server connection.]
System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +800131
System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) +186
System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) +1932
System.Data.SqlClient.SqlInternalConnectionTds.CompleteLogin(Boolean enlistOK) +33
System.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfo serverInfo, String newPassword, Boolean ignoreSniOpenTimeout, Int64 timerExpire, SqlConnection owningObject) +172
System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(String host, String newPassword, Boolean redirectedUserInstance, SqlConnection owningObject, SqlConnectionString connectionOptions, Int64 timerStart) +381
System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance) +181
System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance) +173
System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection) +357
System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options) +30
System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject) +424
System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject) +66
System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) +494
System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) +82
System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) +105
System.Data.SqlClient.SqlConnection.Open() +111
ResourceDB.SaveResource(String filename, String fromContactEmail, String toContactEmail, String message, Int32 ID) in H:MIS DepartmentIntranetSendItNowApp_CodeDalResourceDB.vb:43
Resource.SaveResource(String filename, String fromContactEmail, String toContactEmail, String message) in H:MIS DepartmentIntranetSendItNowApp_CodeBllResource.vb:31
ContentFiles_Default.ImageButton1_Click1(Object sender, ImageClickEventArgs e) in H:MIS DepartmentIntranetSendItNowContentFilesDefault.aspx.vb:33
System.Web.UI.WebControls.ImageButton.OnClick(ImageClickEventArgs e) +86
System.Web.UI.WebControls.ImageButton.RaisePostBackEvent(String eventArgument) +115
System.Web.UI.WebControls.ImageButton.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +7
System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +11
System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +33
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1746
Version Information: Microsoft .NET Framework Version:2.0.50727.1433; ASP.NET Version:2.0.50727.1433
View 2 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
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
Mar 9, 2007
All --
Please help.
I have some questions about connection strings.
BACKGROUND...
Note that I am using the "SQL Native Client OLE DB Provider", SQL Sever 2005 Express, ASP.NET, C#.NET, and VS.NET 2005.
Note that I do not want to use the "Attach a database file" type of connection string.
Note that I am using the site http://www.ConnectionStrings.com as a reference.
Note that this "Standard security" connection string...<add name="LocalSqlServer" connectionString="Server=MYTESTOFFICESERVERS;Database=MyDatabase;Uid=MyDatabaseUser;Pwd=MyDatabasePassword;" />...does not work and causes the following run-time error...A connection was successfully established with the server, but then an error occurred during the login process. (provider: Shared Memory Provider, error: 0 - No process is on the other end of the pipe.)
Note that this "Trusted connection" connection string...<add name="LocalSqlServer" connectionString="Server=MYTESTOFFICESERVERS;Database=MyDatabase;Trusted_Connection=yes;" />...works but is less-than ideal because it uses a Trusted Connection rather than a Username/Password combination.
QUESTIONS...
(A) What exactly does the error in Item 4 mean?
(B) Do 4 and 5 imply that one must use a Trusted_Connection for all SQL Server 2005 Express connection strings when the database does not reside in the web application's App_Data folder or use a "Attach a database file" type of connection string?
(C) Are there any alternatives?
(D) What do you suggest?
Please advise.
Thank you.
-- Mark Kamoski
View 1 Replies
View Related
Jul 10, 2007
When using jdbc with IntegratedSecurity, I run into this problem when the machine is not part of a domain & gets its IP address via dhcp. Is this expected behavior or a bug in the jdbc driver.
The SQLServer and client application are installed on the same machine and a local admin is logged in, running the client app.
If I change one of the two parameters mentioned above, the connection can be established leading me to believe this may be intentional for security issues. Am I correct?
View 6 Replies
View Related
Jul 4, 2006
Hi folks, when i try to connect to my sql express sever through Sql sever authentication I keep getting an error that says
"Login failed for user 'username'. The user is not associated with a trusted SQL Server connection. "
I know the password is right.. how do i overcome this??
View 3 Replies
View Related
Apr 2, 2008
Hello All,
I know this issue has been dealt with every where in the universe. but none seem to solve my problem. I need help desperatelyThe Web Application is a Classic ASP/Sql Server 2000 using two computers in the same physical network:Computer-A is the Sql Server2000 running Windows XP Professional.Inside Sql Server2000 i created a login, AA, as a dbowner of a database called XXX. Inside XXX, AA is right there as a user.
i configured the SqlServer to accept mixed (Windows and Sql) logins.I restarted the computer and i logged into sqlserver successfully as AA. Everything is fine here.
Computer-B is the Web Server running IIS in Windows XP Professional.Here, I successfully created a System ODBC i named EEEE to connect to XXX using the AA login. Everything is fine up to this point.But, to my greatest surprise when i use - conn.Open("DSN=EEEE;UID=AA;PWD=AApassword;") in a classic ASP page, it returns this very famous error.
What did i do wrong? Please help
View 4 Replies
View Related
May 22, 2008
Hi All,
My Webserver and SQL Server are of different machines.I have connected my website with sql server database. I published that website in IIS. I can able to browse that in local machine. But, if I try to browse from some other machine its giving me error saying "NOT ASSOCIATED WITH TRUSTED SQL SERVER CONNECTION".
MY Connection string is this:
connectionString="Data Source=BOOKSQL;Initial Catalog=CustomerDb;Trusted_Connection=True;"
I also tried with
connectionString="Data Source=BOOKSQL;Initial Catalog=HeCustomerDb;Integrated Security=SSPI;"
How can I overcome this problem. Please help me! I need ur immediate response.
View 6 Replies
View Related
Sep 10, 2005
Hi,
Iam getting the following error when trying to connect to a database on the remote server using asp.net web form
"Login failed for user '(null)'. Reason: Not associated with a trusted SQL
Server connection."
can anybody tell me what could be the exact reason for this.
Regards
Adonis
View 1 Replies
View Related
Nov 16, 2000
Two days ago I had no problem creating or running DTS packages.
Now, when I try to design or run a DTS package that has a connection to SQL Server (using userid 'sa') I get the following error message:
Error Source: Microsoft OLDDB Provider for SQL Server
Error Description: Login failed for user 'sa'. Reason: Not associated with a trusted SQL Server connection.
I am running from an NT Client. The only thing that might have caused a problem is that we had a power hit yesterday.
Has anyone seen this problem, and does anyone know what need to be done to resolve the problem?
Thanks, in advance.
View 1 Replies
View Related
Mar 12, 2001
Hi
when i am registoring my remote database to my mechine i am getting This error " Not Associated with a trusted SQL Server Connection "
The remote server is working on Windows 2000/ SQL Server 7.0 Mine is Windows NT4.0 / SQL Server 7.0 why I am getting this error, I am using user is sa with pass word.
Help me regarding this
Thanks
View 1 Replies
View Related
Feb 26, 2002
I just upgraded my SQl tools from 7.0 to 2000. Now, when I want to access information from our sql server (v. 7.0) through ODBC, I get an error, the login box comes up with the trusted connection checked (this particular database doesn't use trusted connection). My PC runs Windows 2000 and has for over a year. Others in my company have developed this issue immediately after installing W2k on their computer or installing other software. Is there a way to have the login NOT have trusted connection checked?
Thank you.
View 1 Replies
View Related
Feb 11, 2004
I am trying to connect to a SQL Server database using windows athenication over Cisco VPN 4.0.3. I recieve the error "Login Failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection" using Enterprise Manager. I am able to connect sucessfully when connecting using a SQL Server logon. I able to connect to the domain and connect to remote drives. I am able to using Microsoft Outlook with no problems.
I am running Windows XP and connecting to SQL Server 2000 running on windows 2000. I have no problems connecting via Windows authenication at work. I only have the problem over VPN. I just recently rebuilt my hard drive due to hardware failure, and have not been able to connect using Windows authenication since I re-installed all of my software. Prior to that, it worked great. Does any body know what might be the problem and what the solution is?
I appreciate any help that I can get.
Glenn
View 13 Replies
View Related
Mar 29, 2006
Please suggest the error message: "Login failed for user 'sa'. Reason: Not associated with a trusted SQL Server connection
regardz,
sAm
View 3 Replies
View Related
Jul 20, 2005
Hi, I've got SQL2000 Evaluation edition running on my ownWindows XP Pro computer. I've installed it fine, and createdsome sample databases. It works fine.I can connect using Windows authentication. But when I try toconnect with username & password I get the error message:"Login failed for user sa Reason: not associated with a trustedSQL Server connection.What's going wrong here? How do I set up a trusted connection?
View 2 Replies
View Related
Nov 11, 2006
Hi All... I'm using asp.net 2.0 against a SQL Server 2005 database and am getting an error,
Login failed for user 'MyUser'. The user is not associated with a trusted SQL Server connection.
I've done searches for this error and most say to switch from windows-only authentication to mixed mode. That seems more like a workaround rather than a solution. I mean we should be able to use windows-only right? So how does one set up that user to be associated with a trusted connection?
The odd thing in my setup is that I'm using the exact same username and password as I'm using to connect to the database with Visual Studio 2005 and that works fine. But when I try the same acct/pwd from asp.net, I get that error.
FWIW, here's my connection string:
"Server=192.168.1.47; Database=MyDatabase; UID=MyUser; PWD=MyPassword"
What gives here? Any thoughts? Thanks!
View 6 Replies
View Related
Aug 29, 2006
I setup a DSN to a remote SQL 2000 Enterprise Server and was able to successfully complete the test connection. However, when I went to use the DSN to establish a connection in Integration Manager for GP 8.0 I got the following error:
"Integration Manager was unable to obtain column information.
You will not be able to map to fields in this query until the following problem is corrected:
Could not create connection to Data Source '_Web Customers':
Attempt to open connection Failed:
[Microsoft][ODBC SQL Server Driver][SQL Sevrer]Login Failed for user'(null)'. Reason:Not Associated with a trusted SQL Server connection."
I have tried everything I have been able to find on Trusted Connections but nothing seems to work.
Any ideas or pointers on where to look for help with this?
Thanks in advance for any help
Terry
View 13 Replies
View Related
Apr 23, 2007
Hello Everyone,
In a Windows domain
i have One PC for SQL Server 2000 Database
and other PC is my development .
So When I create C# Windows Application on my PC and try to get the data , It Works Perfectly fine
but
when I create C# ASP.NET Application on my PC and try to get data , It throws Error as
"Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection."
my connection string for Windows Authentication is as follows
SqlConnection miConnection= new SqlConnection("integrated security=SSPI;data source=SID_DB;persist security info=False;initial catalog=CC");
I tried using "sa" account , it gives me following error
"Login failed for user 'sa'. Reason: Not associated with a trusted SQL Server connection"
my connection string is as follows
SqlConnection miConnection= new SqlConnection("user id=sa;password=sa000;data source=SID_DB;persist security info=False;initial catalog=CC");
I tried both the ways above stated , It is giving me the Error .
Configuration is as follows
IIS on My PC
VS 2003 on MY PC
MS SQL Server 2000 on "SID_DB" pc.
Thanks in Advance,
Sidheshwar
View 1 Replies
View Related
Feb 14, 2008
Hi,
My question is related to accessing the data of one SQL server 2000 from another SQL server 2000 thru query analyser which are in different domains.
When I run SELECT query from one Query analyser of SQL server 2000 which is in domain A to fetch the data from the other SQL server database which is in different domain. I am getting the error as "Login failed for the user <username>, Not associated with a trusted SQL server connection"
Both SQL servers are having mixed mode (SQL & windows authentication).
Your help is very much appreciated.
Thanks in advance.
Hanumant
View 3 Replies
View Related
Apr 2, 2008
Hello All,
I know this issue has been dealt with every where in the universe. but none seem to solve my problem. I need help desperately
The Web Application is a Classic ASP/Sql Server 2000 using two computers in the same physical network:
Computer-A is the Sql server2000 running Windows XP Professional.
On it i created a login, AA, as a dbowner of a database called XXX. Inside XXX, AA is right there as a user.
i configured the SqlServer to accept mixed (Windows and Sql) logins. I restarted the computer and i logged into sqlserver successfully as AA. Everything is fine here.
Computer-B is the web server running IIS in Windows XP Professional.
Here in Computer B, I successfully created a system ODBC named EEEE to connect to XXX using the AA login. Everything is fine up to this point.
But, to my greatest surprise when i use - conn.Open("DSN=EEEE;UID=AA;PWD=AApassword;") in a classic ASP page, it returns this very famous error.
What did i do wrong? Please help
View 6 Replies
View Related
Dec 11, 2006
I have developed a web application which works with SQL server express with out any problem on my development pc. I used the copy project from VS2005 to copy the whole project to my test pc which has Win XP and SQL server express installed. SQL authentication on both PCs is set to mixed mode (windows and SQL). But when I run the application I get the following error:"The user is not associated with a trusted SQL Server connection" I checked user permissions and everything works ok. Application works well on the development pc. Please help. Any help is greatly appriciated.
View 1 Replies
View Related
