Questions tagged [trustedconnection]

32 questions
1
vote
1 answer

C# - How to get TrustedConnection property from a SqlConnection

I want to get connection string components from a string containing the conn string. It is pretty simple to get Database, Sql Instance , Username and Password using a SqlConnectionStringBuilder, like this: SqlConnectionStringBuilder cb = new…
darkdante
  • 707
  • 1
  • 17
  • 36
0
votes
1 answer

Spring Security integration into active directory

I want to authenticate my web service in Spring with an Active Directory lookup at both the producer and the consumer - under the Principal that that each are executing under (ie Service Accounts). I'm assuming I have to use…
hawkeye
  • 34,745
  • 30
  • 150
  • 304
0
votes
1 answer

Flask pyodbc showing "Login failed for user" when using "TRUSTED_CONNECTION=Yes"

I have the following connection: cnxn = pyodbc.connect("DRIVER={SQL Server};SERVER=nameofmyserver;DATABASE=nameofmydb;TRUSTED_CONNECTION=Yes;") The Flask app is on IIS and has Windows Authentication enabled. On one route, I return…
0
votes
0 answers

Elixir TDS with Trusted Connection

I am trying to connect MS-SQL from Elixir with tds. I do not have an userid-password, instead use windows auth. Is there a way to use the windows authentication to connect to a MS-SQL server. Something along the lines - {:ok, pid} =…
Shishir Pandey
  • 832
  • 1
  • 12
  • 23
0
votes
1 answer

SSL chain validation for internal sites

How do I validate the ssl chain served by server for a internal site ? I found online tools like ssl labs that do this but they don't work for a internal network site . I tried OpenSSL and inputted site url and it says the site's chain is ok. But…
0
votes
1 answer

Kerberos - difference between JAAS connection to server and SQL Server Trusted Connection

My understanding is that both JAAS and SQL Server can be configured to use kerberos in a domain environment, with an active directory server. My understanding that JAAS gets the user credentials from the user or from a file at the time of the…
hawkeye
  • 34,745
  • 30
  • 150
  • 304
0
votes
0 answers

Detect VPN connection or trusted network connection

Is is possible to check vpn connection or machine is connected to trusted network? My app need a connection to LDAP to get some data. this action is started when user login to machine and incase user working from outside of a trusted network (home…
new user
  • 1
  • 1
0
votes
1 answer

How to run Distributed SQL Server Query with trusted connection

I want to run SQL Server query on the remote machine and this is what I am doing EXEC sp_addlinkedserver N'remote-server', N'SQL Server'; //I don't want to do this step, and want to use trusted connection to remote server EXEC…
Muhammad Ummar
  • 3,541
  • 6
  • 40
  • 71
0
votes
1 answer

WCF hosted in IIS, Problem connecting to database with integrated security

I have a WCF service hosted in IIS 5.1 on my development XP machine. The service cannot connect to sql server DB with integrated security=true. The same service works fine when hosted in a console app. I have unchecked Anonymous access and checked…
0
votes
1 answer

How to initiate MS SQL trusted connection for PHP

I have been trying to initiate database trusted connection to MS SQL using PHP but failed. My PHP development machine is not part of the domain and the MS SQL server is in a domain. Unfortunately I cannot join my development machine to the domain.…
cheetooh
  • 16
  • 2
0
votes
1 answer

SQL Server 2000 Trusted Authentication Issue

I'm using Windows Server 2003 R2 and SQL Server 2000 and I'm attempting to connect to to my database from another PC in the same Network (Also using Win Server 2003 R2) But I'm getting SQLSTATE[28000] SQLDriverConnect: 18452 [Microsoft][ODBC SQL…
Gabriel Matusevich
  • 3,835
  • 10
  • 39
  • 58
0
votes
1 answer

SSO handshake with Active directory

I've done a small TCP/IP server which acts quite like an ftp server. On the client side, I'm using an API to connect and to exchange data against the server. This server will be on an active-directory ecosystem, so the client. What kind of API…
0
votes
3 answers

How does the SQL Server JDBC Trusted Connection Authentication work?

How does the SQL Server JDBC Trusted Connection Authentication work? (ie how does the trusted connection authenticate the logged in AD user in such a transparent and elegant fashion and how can I implement a similar authentication solution for my…
hawkeye
  • 34,745
  • 30
  • 150
  • 304
0
votes
1 answer

Domain considerations when using trusted_connection in SQL Server connection string

I have been trying to understand what using trusted_connection=true in a SQL Server connection string (from within C#) means. I understand that it uses the current Windows user credentials to connect to the database. But does it mean the database…
Cygnus
  • 3,222
  • 9
  • 35
  • 65
0
votes
0 answers

Error while connecting to a SQL Server Database: not trusted connection

We have installed on a company a SQL Server 2005 express on a server. Some workstations connects to the server while they're using our applications with Windows Authentication. But there's ONE computer that can't connect. When the user opens any…
davidrgh
  • 853
  • 2
  • 10
  • 17