Stack Overflow
Stack Overflow

Questions tagged [sql-authentication]

32 questions
9
votes
7 answers

Connect to domain SQL Server 2005 from non-domain machine

I asked a question a few days ago (Access to SQL Server 2005 from a non-domain machine using Windows authentication) which got some interesting, but not usable suggestions. I'd like to ask the question again, but make clear what my constraints…
user304582
  • 1,910
  • 5
  • 28
  • 49
6
votes
1 answer

NotSupportedError: Authentication plugin 'caching_sha2_password' is not supported

I use the following line of code in order to connect to a database instance of my computer. cnx = mysql.connector.connect(host=Host, user=User, password=Password, database=db, auth_plugin='mysql_native_password') The connection works perfectly both…
Xristos Timplalexis
  • 119
  • 1
  • 5
6
votes
1 answer

How to add windows user as a SQL users in windows authentication mode

I want to add windows user to SQL users pragmatically. my problem is that I want to do this on systems that have SQL installed in mixed mode but I don't have username and password , I just know the instance name and I don't know how can I execute my…
Shima.Y
  • 373
  • 4
  • 9
  • 18
3
votes
2 answers

Deny access to self in SQL Server 2012?

I have a unique request from my boss. I'm the only software developer for my company, so I'm doing everything from the initial design to the database design. I regularly design and maintain the databases and the same with the front end. We do not…
Humpy
  • 2,004
  • 2
  • 22
  • 45
2
votes
1 answer

Web server to SQL Server integrated authentication

I want to find a solution whereby my user account is passed on via a website to authenticate to a remote SQL server instance. So if my account name is Domain\Yaqoub, then when I browse my web page which connects to SQL it will pass on Domain\Yaqoub…
Perplexed
  • 877
  • 2
  • 19
  • 32
2
votes
1 answer

Get current user while using SQL Authentication

We are using a SQL Login as a vehicle for issuing permissions, but once authenticated through SQL, we'd still like to know the Active Directory name of the connected user? We've tried: SELECT SUSER_NAME() SELECT SUSER_SNAME() SELECT…
KyleMit
  • 30,350
  • 66
  • 462
  • 664
2
votes
1 answer

how userid and password exposed in network in sql authentication

How is the userid and password exposed on the network in SQL authentication and why doesn't this happen in Windows authentication?
user1626237
  • 21
  • 1
2
votes
0 answers

sharepoint mysite authentication

I have created mysite and two other sites as 3 different web applications in my sharepoint server like http://site1.sp.com:45 - site 1 http://site2.sp.com:45 - site 2 http://mysite.sp.com:45 - mysite site all sites are using authentication …
Manoj Prasanna
  • 99
  • 1
  • 11
1
vote
0 answers

How do I run a program that uses SQL Server on a workgroup without "Running as Administrator?"

Our office has a very simple SQL Server setup. Because of our limited hardware and resources, we use a workgroup instead of a Domain Controller. Everything is working smoothly, expect for one thing. When I use a 3rd party program (such as a CAD…
Austin Daniel
  • 11
  • 1
1
vote
1 answer

What are the new login options for Sql Studio (v17) such as "Active Directory - Integrated"

I've been using Sql and Sql Studio for many years, so I was surprised when I first saw these three new options in the authentication dialog... Active Directory - Universal with MFA support - MultiFactory Authentication) Active Directory -…
ebol2000
  • 1,195
  • 11
  • 16
1
vote
1 answer

Create weblogic user and assign roles from database to weblogic server

Hi I have table called user_data, which contains user_id, passwd and user_priv ( role for weblogic user). I need to map my database user_data with weblogic server. I have tried to create a provider with sqlAuthenticator with my datasource which…
YLG
  • 855
  • 2
  • 14
  • 36
1
vote
1 answer

What is the proper syntax of "GO" in MSSQL?

I'm attempting to run a script that adds a login to MSSQL it includes two GO commands, both of which yield the error: Msg 102 ... Incorrect syntax near 'GO'. The following example code runs on a database named MyDB DECLARE @currentUsername…
AaronF
  • 2,841
  • 3
  • 22
  • 32
1
vote
1 answer

Login failed for user 'domain\ServerName'

I have creates an asp.net mvc 4 web app. I have deployed it to my dev server. (different box than my local on same domain). Both the database and the website exists on the same server/box. I am trying to connect from my local machine which is on the…
EB.
  • 2,627
  • 8
  • 35
  • 55
1
vote
1 answer

LocalDB connection with Integrated security=False

I was looking everywhere and still have not found clear answer to this simple question: Is it possible to use SQL authentication with LocalDB, i.e. is it possible to use connection string containing Integrated Security=False ?
Vojtěch Dohnal
  • 7,867
  • 3
  • 43
  • 105
1
vote
1 answer

configuring SQL Server instance for Data Access using OPENROWSET, OPENQUERY

I have SQL Server 2012 full version installed on my standalone non-networked development PC running Windows 7 x-64. Let's say FOO is the name of my PC, and my SQL Server named instance is FOO\SQL2012. I am trying to follow the examples here, which…
Tim
  • 8,669
  • 31
  • 105
  • 183
1
2 3