Questions tagged [sql-authentication]
32 questions
1
vote
2 answers
SQL Server 2005 Remote Login Permissions
I have a user Sql Authentication account that has remote access to my database server. The user has a default database, and is only able to access or modify that DB. So far so good. However, I'd like to prevent the user from viewing the other…
Scott Klarenbach
- 37,171
- 15
- 62
- 91
0
votes
2 answers
SQL Server restrict user to selected stored procedures only
The sa account was recently locked out on my company's public-facing database due to numerous failed login attempts from an unknown user. I have their IP address in the logs but it scared the hell out of me.
I changed all my passwords and am in the…
Greg
- 8,574
- 21
- 67
- 109
0
votes
4 answers
How to Suppress SQL Authentication
I am really stumped on this, I am not sure if someone can at least point me in the right direction?
I have an MS Access Reporting Application. It has a few local tables in it but predominantly relies on tables from a SQL Server 2005 database that…
Dallas Smith
0
votes
0 answers
Connect to SQL Server container from C# application
Have a C# App and SQL Server database from a domain environment; restored the DB in a non-domain support environment (SQL Server running in a Docker Container). Connections are successful via ODBC using SQL Server authentication:
Server …
Omnitec
- 1
- 1
0
votes
2 answers
SQL Server 2005 query results differ for different AD accounts using same SQL login
There are two AD accounts, admin1 and admin2. Both are logged in to identical machines, both open SQL Server Management Studio and log in as the same SQL user to the same SQL server (using SQL Server Authentication, NOT using Integrated Security),…
Corehop
- 7
- 3
0
votes
2 answers
SQL Server v14 - Login Failure
We are using SQL server 2014, we update a password for a user login here
we click properties on a given login account and change the password here
we are certain we entering it correctly when we then try to login to the server using the login and…
YelizavetaYR
- 1,611
- 6
- 21
- 37
0
votes
1 answer
How do you change the authentication method on SSIS?
I've deployed an SSIS project using the "SA" account to my SQL Server. When I run a package from the SQL Server I am getting the error saying I need to use Integrated Authentication. I corrected the problem in Visual Studio (I changed it to use…
Dominic Isaia
- 127
- 1
- 9
0
votes
1 answer
Azure App Service Fails to Find Newly Created Certificate
I have an Azure app service I did not create but now maintain. The app service finds a certificate in a Key Vault by thumbprint and in turn uses that to get a token for doing some SQL work via nightly jobs.
It appears the certificate was set to auto…
RichP
- 525
- 1
- 10
- 25
0
votes
0 answers
My SQL Server Agent job is running for long time and failing with Login issues
Please see the logs shown below for more information:
2020-04-23 13:13:56.97 spid10s Starting up database 'tempdb'.
2020-04-23 13:13:57.42 spid10s The tempdb database has 4 data file(s).
2020-04-23 13:13:57.42 spid10s The tempdb database…
0
votes
3 answers
Error in ASP.NET (Server Error in '/' Application.)
for about month I'm trying to solve this problem which is driving me mad, so i said to myself let me post it on this site so may some one could help me.
let's get to the point
my program is asp.net connected to SQL Server 2008, once i try to run the…
Basim
- 1
- 1
- 1
0
votes
1 answer
"Login failed for user..." when I log on to my online SQL Server using C#?
I have a database on a hosting server that I try to connect using C# SqlConnection class. I can log on to the server through SQL Server Management Studio using SQL Server authentication without problem.
My initiation code looks like this:
public…
0
votes
0 answers
MS Access front end able to log in Cross-domain with SQL Authentication to 2008 instance, but not 2012
I have a Microsoft Access front-end application that can log in (cross-domain) with SQL authentication just fine to a SQL Server 2008 instance, but is not able to log in to a SQL Server 2012 instance.
Is there a difference in the network protocols? …
J.D. Walker
- 56
- 6
0
votes
1 answer
SQL Server Authentication Method
I would like to know if it is possible to change a SQL Server authentication account to Windows Authentication?
Why would I want to do this you are asking yourself right now, well I don't want to give out a SQL Server Auth username and password to…
0
votes
1 answer
SQL 2005 User Instances and SQL Authentication
Can I use SQL Authentication with User Instances?
mrtaikandi
- 6,753
- 16
- 62
- 93
