Skip to main content
21 questions
Newest Active Bountied Unanswered
Filter by
Sorted by
Tagged with
0 votes
1 answer
578 views

In our Azure Pipeline we add members to roles of a SQL Server database: ALTER ROLE [db_datareader] ADD MEMBER [$(user)] ALTER ROLE [db_datawriter] ADD MEMBER [$(user)] This has worked years without ...
Silvan's user avatar
  • 381
1 vote
0 answers
166 views

I have a SQL Server on Azure Virtual Machine joined to a Microsoft Entra Domain Services instance that has Enable Microsoft Entra authentication for SQL Server on Azure VMs enabled. I have a user in ...
Andrew Stubbs's user avatar
  • 4,497
0 votes
1 answer
178 views

I am using Isolated Azure Functions and SQL Server with Entity Framework. This is configuration I am having inside my Program.cs of corresponding Azure Function App: var connectionString = ...
Mykyta Halchenko's user avatar
  • 818
1 vote
1 answer
783 views

I visited and tried several examples, but error still the same. I have a AAD group named Azure_SqlServer_Admins assigned to SQL Server in Entra section as Microsoft Entra admin. I have a service ...
Mykyta Halchenko's user avatar
  • 818
2 votes
0 answers
522 views

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. ...
Lou Nik's user avatar
  • 125
0 votes
1 answer
238 views

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 ...
Piotr Lasota's user avatar
  • 201
0 votes
0 answers
49 views

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 ...
sajid's user avatar
  • 1
0 votes
1 answer
978 views

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 : ...
asmgx's user avatar
  • 8,150
0 votes
0 answers
307 views

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 ...
Sivamani V's user avatar
  • 61
0 votes
1 answer
484 views

I have a store procedure with dynamic parameters (@ parametr1, @parametr2) and I wanna use it in an openrowset with SQL-SERVER authentication.
Zahra's user avatar
  • 337
0 votes
1 answer
1k views

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 this: Server=...
Robert's user avatar
  • 1
0 votes
1 answer
1k views

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 ...
Brindha Thangamuthu's user avatar
  • 1
2 votes
2 answers
1k views

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 ...
Babu's user avatar
  • 21
5 votes
3 answers
84k views

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 ...
Jack Lim's user avatar
  • 315
3 votes
1 answer
4k views

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 ...
Sebin Thomas's user avatar
  • 289
0 votes
3 answers
1k views

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; ...
Johnseito's user avatar
  • 315
1 vote
1 answer
2k views

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 ...
dev's user avatar
  • 565
0 votes
1 answer
95 views

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 ...
nam's user avatar
  • 24.3k
0 votes
1 answer
83 views

I am working on SQL Server 2008 and currently I am using my local server with windows authentication. Can i set SA password for SQL Server Authentication? What are the steps and also I want to know ...
user avatar
0 votes
4 answers
1k views

Typically I remote into a machine with IP Address 00.00.00.00 and then I have an account in a domain, let's call it myspecialaccount\firstname.lastname. Then I use Windows auth to connect to SQL ...
Tom Stickel's user avatar
  • 20.6k
1 vote
1 answer
7k views

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 ...
JosephDoggie's user avatar
  • 1,604