SQL Trusted_connection
Nov 14, 2003
Hi people,
I have an application runnig on a server accessing a sql server on other server... how can I use trusted_connection? I thought maybe running the ASP.NET process as Administrator I can do this... but How can I change the ASP.NET process' user? it doesn't appear in the windows services... only ASP.NET State Service... please... can anybody help me?
thanx
Ricardo Gaefke
Justiça Federal
Desenvolvedor .NET
http://gaefke.tk
View 1 Replies
Jan 13, 2005
I have been using an Access DB until now and am going to start looking at using an SQL Server instead. My first task was to make sure that I could connect. I created a basic DB and created and added a user as public, datareader and datawriter.
My first attempt at a connection string was -"server=local;uid=someuser;pwd=password;database=basic"and it couldn't find the server (I tried 'localhost' as well).
My next attempt was -"server=QTLAP01;User ID=someuser;pwd=password;database=basic"And I got the error "Reason: Not associated with a trusted SQL Server connection.".
I eventually found that the following worked -"server=QTLAP01;User ID=someuser;pwd=password;database=basic;Trusted_Connection=true"But, I don't understand why. Why would it believe that the connection was trusted just because I said it was?
Thanks
Martin
PS the computer in question is not connected to a network so no problems with username and password security.
View 5 Replies
View Related
Feb 9, 2004
what does this imply Trusted_Connection=true parameter in the Connection String signify?
Secondly how can I make users with Windows Authentication Login to work in SQL Server Connection String?
Thanks in advance,
Neeraj.
View 1 Replies
View Related
Mar 31, 2006
When accessing a web application from an intranet....
And the web app tries to make a connection to a 'SQL Server' using the sqlconnection where does ASP.NET grab user credentials?
My webpage displays web security.principal.windows.getcurrent = domainUser (displays the correct information).
But the connection to sql says Null. Where is ASP.NET grabbing (retrieving) this information from?
Thanks,
View 3 Replies
View Related
Sep 26, 2004
Hello, all:
I am connecting to SQL Server 2000 with a trusted connection, and that is working fine. I then am issuing a SQLGetInfo call to find out the SQL_USER_NAME, which is always returning dbo instead of (my) Windows NT login name, which I expect to see. THe authentication is (apparently) confirmed by the SQL Server session monitor where it shows the right Windows NT user name logged in, over ODBC. With a standard SQL Login, untrusted, I definitely get the right user name back, not dbo.
So:
Login Type / user id /returned value from SQLGetInfo
Windows Authentication / Windows login / dbo
SQL Authentication / Windows login (UID) / UID
The problem is that I am trying to confirm that the userid entered in a dialog or passed on the command line to my application matches the actual connected user name inside SQL Server....
My questions:
Is there some pathology in Trusted_Connections that masks the Windows/NT login name and always returns UID 'dbo' from a call to SQLGetInfo? Is there a MSS (public) stored procedure that can robustly give back the logged in user name so I can bypass the SQLGetInfo call?
View 2 Replies
View Related
