Stack Overflow
Stack Overflow

Questions tagged [sql-server-authentication]

Tag to be used for all authentication questions regarding Microsoft's SQL Server product.

18 questions
4
votes
3 answers

Python pyodbc connect to Sql Server using SQL Server Authentication

The window user details is different from the Sql Server user I log in. So I had tried to use pyodbc connect to the database using the username(Admin_JJack) and password. But the connection show fails for the Window User(Jack) and I don't know where…
Jack Lim
  • 195
  • 2
  • 5
  • 16
2
votes
2 answers

node.js is not connecting to SQL Server database using SQL Server authentication

I'm using node.js and the mssql package to connect to a SQL Server database using SQL Server authentication. When I try connecting using SQL Server Management Studio with the same credentials, it is working fine. However, with node.js, I cannot…
Babu
  • 21
  • 3
2
votes
1 answer

Connect Local SQL Server Database using Azure Active Directory Credentials

The SQL Server (version 2016) is located in the local Virtual Machine(Windows Server 2012 R2) and I need to provide authentication for the users in the Azure Active Directory. As I am new to this I am not even sure whether it is possible or not. Can…
Sebin Thomas
  • 279
  • 8
  • 21
1
vote
1 answer

ColdFusion is not connecting datasource with SQL Server 2014

I am trying to connect datasource in coldfusion admin with my local sql server 2014 but it is not connecting . I have tried every method to do this but no success. I have also created new user but it is also not working. I am getting this…
dev
  • 555
  • 1
  • 13
  • 31
1
vote
1 answer

MVC 5 IIS 7.5 double-hop issue (avoid hard coded SQL passwords)

I am experiencing the double-hop SQL server log in problem associated with MVC projects. I am using IIS 7.5; MVC 5; Visual Studio 2013, and simple Windows 7 system running IIS. I need to make an intranet project with either Windows Authentication or…
JosephDoggie
  • 1,514
  • 4
  • 27
  • 57
0
votes
0 answers

postman server basic auth and bearer token

When I load my staging environment from the browser, a popup appears for me to fill in username and password. If credentials are correct, I can load the website, otherwise I get a nginx auth error. I also have a local environment that has no…
Lou Nik
  • 115
  • 4
0
votes
1 answer

Default dbo schema for user from ACL group

I have following situation ACL group: domain\aclgroup user account: domain\account user account is a member of the ACL group in the sql server ACL group is added to the server logins, mapped to the database with default schema dbo. user account is…
Piotr Lasota
  • 201
  • 1
  • 6
0
votes
0 answers

Error when connecting to sql-server using windows authentication mode

for a couple of days or weeks I am finding a solution to my problem on google but still, I don't get any solution so that's why am here to ask you to help me. Actually I am getting an error by connecting SQL server with java in Netbeans here is the…
sajid
  • 1
  • 2
0
votes
1 answer

Cannot create new user in SQL Server

Everythiing was working fine My laptop has SQL Server installed I formatted my laptop Installed SQL Server (latest version) then Changed my computer name Old name was : DESKTOP-EP40R17 New Name is : DELLG3 Now trying to add new user to access…
asmgx
  • 7,328
  • 15
  • 82
  • 143
0
votes
0 answers

Securing database credential with user, data database for mobile/web application

I'm creating a mobile application with react-native and mongoDB (AWS mongoDB server). How to I store the user database creation credentials (need database admin access) to signup in application. Do I need any third party web server[I prefered MERN…
Sivamani V
  • 61
  • 9
0
votes
1 answer

How to pass parameter to a store procedure in openrowset and sql-server authentication

I have a store procedure with dynamic parameters (@ parametr1, @parametr2) and I wanna use it in an openrowset with SQL-SERVER authentication.
Zahra
  • 317
  • 4
  • 16
0
votes
1 answer

What would be the connection string of a .Net Core web app that runs on Linux and connects to SQL server using an AD account

On windows the web app service would run under a service account and that service account would have permissions to connect to the SQL server and DB. Using a connection string similar to…
Robert
  • 1
0
votes
1 answer

Pyodbc is only accepting windows authentication

I'm having one python script which connects to the MS SQL server from windows via pyodbc. When trying with windows authentication, it is getting connected to the database, but when trying with SQL server authentication (with username and password),…
Brindha Thangamuthu
  • 1
  • 1
0
votes
3 answers

VB code to connect to SQL server on windows server 2012R2 - not locally

I know how to connect to SQL server Management studio locally, the one to your desktop, Windows Authentication. Code is as below. myconnection As New SqlConnection("data source =serverNAME01; initial catalog=ZPCD; integrated security=true") But how…
Johnseito
  • 315
  • 1
  • 9
  • 24
0
votes
1 answer

How can we assign permissions to setup SQL Server Reporting Services

In SQL Server 2012, how can we give a permission to someone to have full control to SSRS and a permission to a specific Db so they can configure and run the SSRS reports and have a full control to backup/restore their Databases but do not have…
nam
  • 21,967
  • 37
  • 158
  • 332
1
2