Trusted SQL Server Connections && The Like
Dec 2, 2005
seems a lot of people are having this problem but none of the solutions i tried has worked so far. I want to develop asp.net applications at my home pc running Win Xp pro SP2. I use MSDE as the database server and manage it with sql server enterprise manager. I do all the programming in Delphi 2005 and I run IIS 5.1, all on the same PC.
Now...if I build a test windows application and try to connect to the database with a connection object or UDL file, winnt authentication works. If I then try to connect through an asp.net application, where I have the connection string coded in the .aspx file I either get a "login failed" or "not trusted sql server connection". I have tried to set up login accounts on Enterprise manager both as winnt authentication or sql server authentication but none has worked with asp.net (no problem with windows apps). Funnilly I don't have that problem at work, though the sql server at the office is on a separate pc. I know many people face this problem, can anyone help me out?
thanx in advance
View 1 Replies
ADVERTISEMENT
Apr 27, 2004
Hey all, not sure if this is even possible but is there a way to connection an SQL server with ASP.NET using my username and password as the trusted connection? As I am a trusted connection but the ASP.NET working process isnt. Anything can be done about this apart from addeing the ASP.NET account as a trusted connection?
Thanks
Luke
View 4 Replies
View Related
Dec 14, 2005
I was just wondering about the old error:"user not associated with a trusted connection"I know how to solve it, but I dont really understand what im doing. If my connection string is like:Trusted_Connection=true;Initial Catalog=jobitdev;Data Source=192.168.109.4;Packet Size=4096;then how validation is done on the sql server side of things? If i specify the "Trusted_connection" property what does the server do to validate the user? I'm assuming that the user it checks is the current windows user?
View 4 Replies
View Related
Oct 12, 2005
I am attemting to develop a link between a access and SQL2003 database on two different machines. The aim is to update information from a query within the access database to a table within the SQL2003 database - the stumbling block is that the SQL2003 database requires a user name and password to log into the database and append from the access database.
View 1 Replies
View Related
Jan 3, 2001
i am attempting to bcp using the -T (trusted connection) option in sql 6.5. the login security mode is set to integrated. the bcp is however failing with msg 18452 error not associated with a trusted connection. why is this happening? i do not want to hardcode the sa password in the bcp command.
thanks
View 1 Replies
View Related
Feb 19, 2001
Help!
I have rebuilt a very old sql server, and have managed to restore all databases etc.. and everything work okay logged in as sa, however if I try to link to it through odbc connections with the trusted connection option set I get a message like :
Login Failed User: Reason: Not defined as a valid user of a trusted SQL Server Connection.
Any suggestions?
View 1 Replies
View Related
Dec 5, 2007
Hi,
How does one go about setting up a trusted connection to sqlserver 2005 so I don't have to put the username/password in the web.config file?
Are there any other adv/disadv. with doing this?
View 6 Replies
View Related
Aug 29, 2007
Is there a way to use trusted connections in ASP.NET and WinForm applications yet prevent users from accessing databases directly (outside of applications) ? I know the use of trusted connections are recommended for several reasons however I have a lot of applications that I need to prevent users from accessing databases directly outside of the applications themselves.
View 5 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
Apr 3, 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 set up is Classic ASP/Sql Server 2000 in an intranet:
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.
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 2 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
Mar 5, 2008
Hi,
I have created a login for sphang1-desk server. But when I use the following command in my visual studio, the error as subject appears. what should i do?
Dim connectionString As String = "server=SPHANG1-DESK;User id=GARsprakasa;password='';database=Northwind"
thank you
View 7 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
Mar 17, 2008
I just started evaluation of the server and meet the fist problem. I searched the forum however most answers related to use SQL Server manager and security tab. Note I use the express edition which has no manager, but only configuration manager. There is no security tab. So can somebody help in setting up trusted accounts for SQL server express edition?
View 5 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
Feb 10, 2005
Hi Eeveryone!
I am using SQL server 2000 with Webmatrix to build a simple Asp.net app, but facing this problem:
Using Entrprise Manager, I have created a login name "ASPNET" and gave it access as db_owner to the default database "master" , but still could not open SQL connection from Webmatrix aspx file!
The error message I get is :
Login failed for user "ASPNET". Reason : Not associated with as trusterd SQL Server .
I truely apprciate your help!
View 3 Replies
View Related
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
View Related
Dec 7, 2000
Does anyone know of a component or other mini application that can be run on the IIS server and allow IIS to access SQL Server 7 databases using Trusted Security.
Our security unit has required us to run SQL Server with Trusted Security so changing to Mixed mode is not an option. We are also not allowed to use Basic Authentication for Active Server Pages with IIS. IIS and SQL server are also on different machines.
We are looking into the possibility of trying to create a component that would run on the IIS machine to allow us to use Trusted Security to the SQL Server (in effect try to make it work the same way that the Cold Fusion product does).
Any help would be really appreciated.
Thanks
View 1 Replies
View Related
Sep 24, 2005
Hello
I've spent close to 3 hours trying to figure this out.
I have SQL Server 2000 Developers Version + Service Pack 4 installed on Machine A which is running Windows XP Pro. I have Machine B running XP Pro and Apache 2.0 + PHP 4.40.
SQL Server is configured to SQL Authentication + Windows Authentication.
PHP is configured as follows:
; Use NT authentication when connecting to the server
mssql.secure_connection = Off
When trying to connect with either mssql_connect or odbc_connect I get the following error:
Quote: odbc_connect(): SQL error: [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'user'. Reason: Not associated with a trusted SQL Server connection., SQL state 28000 in SQLConnect
I have tried adding a System DSN to MDAC and it can connect no problems to MS SQL. I don't know what to do, I've googled and tried every possible solution and it didn't help.
Is there a way to make SQL accept any connections? I don't care if its insecure I just need it for several days to develope a small application.
Here is the sample code I'm using to test the connection:
PHP Code:
$myServer = '192.168.0.106';
$myUser = "user";
$myPass = "pass";
$myDB = "Northwind";
$s = mssql_connect($myServer, $myUser, $myPass)
or die("Couldn't connect to SQL Server on $myServer");
$d = mssql_select_db($myDB, $s)
or die("Couldn't open database $myDB");
$query = "SELECT TitleOfCourtesy+' '+FirstName+' '+LastName AS Employee ";
$query .= "FROM Employees ";
$query .= "WHERE Country='USA' AND Left(HomePhone, 5) = '(206)'";
$result = mssql_query($query);
$numRows = mssql_num_rows($result);
echo "<h1>" . $numRows . " Row" . ($numRows == 1 ? "" : "s") . " Returned </h1>";
while($row = mssql_fetch_array($result))
{
echo "<li>" . $row["Employee"] . "</li>";
}
Thanks in advance!!
View 1 Replies
View Related
Jul 20, 2005
I am trying to connect to a sql server database from enterprisemanager. I am using sql server authentication and have set the SQLServer up to accept mixed mode authentication. I am still get themessage : Login failed for xxx. Reason not associated with a trustedsql server connection.
View 1 Replies
View Related
Jun 15, 2007
Error setting-up updatable subscription
I get the following error when trying to set-up an updateable subscription.
Unable to set the Publisher login for the updatable subscription. You may have to set this up directly on the Subscriber machine using sp_link_publication. (New Subscription Wizard)
The user is not associated with a trusted SQL Server connection
Login failed for user ''. The user is not associated with a trusted SQL Server connection
The details are
Server Name: DEVELOPER_WS
Error Number: 18456
Severity: 14
State: 1
Line Number: 1
My servers are set up for mixed mode operation.Can anyone recommend a possible way of debugging the issue with this login?
View 4 Replies
View Related
