35 questions
0
votes
0
answers
395
views
Connect Budibase to SQL Server?
I have been trying to connect Budibase to SQL Server but all in vain. I have enabled the SQL Server Browser and SQL Server (SQLEXPRESS), however, I have failed to enable the SQL Server Agent (...
- 51
0
votes
0
answers
121
views
Connecting to SQL Server and performing BULK INSERT from Linux Container
I have made a Linux Docker container performing several tasks, and finally connecting to a SQL Server 2019 (v15), and executing BULK INSERT to load a local (to the SQL Server) .csv file. The ...
- 11
0
votes
1
answer
515
views
howto create Azure Synapse dedicated sql pools linked service across azure subscriptions?
I am trying to pull data from a dedicated sql pool in a different azure subscription, when I try to create the linked service from my target azure synapse workspace using sql authentication, firewall ...
1
vote
0
answers
186
views
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. ...
0
votes
0
answers
161
views
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 ...
- 1
0
votes
2
answers
665
views
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 ...
- 1,741
0
votes
1
answer
850
views
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 ...
- 137
0
votes
1
answer
2k
views
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 ...
- 525
0
votes
0
answers
261
views
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-...
1
vote
1
answer
1k
views
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 - ...
- 1,273
6
votes
1
answer
2k
views
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='...
0
votes
1
answer
716
views
"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 ...
1
vote
1
answer
2k
views
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 ...
- 885
0
votes
0
answers
33
views
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.
...
- 166
7
votes
1
answer
23k
views
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 ...
- 383
1
vote
1
answer
96
views
What is the proper syntax of "GO" in MSSQL? [duplicate]
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 ...
- 3,129
0
votes
1
answer
437
views
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 ...
0
votes
1
answer
82
views
SQL Server SQL Authentication
I want to connect to a sql Server.. Only it won't work.
I granted a user and role enough permissions. But what am I doing
<?php
$serverName = "LERAARSKAMER01\SQLEXPRESS";
$database = "...
- 752
2
votes
1
answer
2k
views
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 ...
- 31.4k
1
vote
1
answer
324
views
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 ...
- 2,767
1
vote
1
answer
6k
views
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 ...
- 8,112
3
votes
2
answers
98
views
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 ...
- 2,002
0
votes
0
answers
325
views
How to create users and store them in a database and link them to windows authentication logins
What I want:
An intranet application where only people who are logged in can see the application... and an Admin and Member role.
1:
I have created an MVC 5.0 web application (for intranet).
It ...
- 21.3k
1
vote
1
answer
16k
views
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.
...
- 8,990
2
votes
1
answer
72
views
how userid and password exposed in network in sql authentication [closed]
How is the userid and password exposed on the network in SQL authentication and why doesn't this happen in Windows authentication?
- 21
2
votes
0
answers
712
views
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 - ...
0
votes
2
answers
3k
views
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 ...
- 8,874
2
votes
1
answer
200
views
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 ...
- 877
0
votes
2
answers
204
views
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 ...
- 7
0
votes
3
answers
7k
views
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 ...
- 1
9
votes
7
answers
7k
views
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 ...
- 2,030
1
vote
2
answers
1k
views
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 ...
- 38.9k
0
votes
1
answer
92
views
Attaching catalog with SQL Authentication credentials attaches it as Read-Only
As part of our product's installation process, a database is attached to the server.
We use EXEC sp_attach_db in order to attach it to MSSQL.
The problem occures when we try to attach it with "SQL ...
- 6,593
0
votes
4
answers
304
views
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 ...
Dallas Smith
0
votes
1
answer
174
views
SQL 2005 User Instances and SQL Authentication
Can I use SQL Authentication with User Instances?
- 7,028