Stack Overflow
Stack Overflow

Questions tagged [sa]

`sa` is the System Administrator account in Microsoft SQL Server.

43 questions
0
votes
1 answer

Allow only dbonwer from accessing stored procedures

I created SQL DB. and I want to allow only "DB owner" to access stored procedures. I want to prevent all other users including 'sa' user from doing that . how to do that ?
Raed Alsaleh
  • 1,581
  • 9
  • 27
  • 50
0
votes
1 answer

Is there a way to stop the 'sa' user changing records inside particular table or particular db in mssql?

Is there a way to stop the 'sa' user changing records inside particular table or particular db in mssql? My preliminary searches did not find me anything except cell level encryption. Is there any other way? UPDATE Requirement is to prevent IT users…
Novice Programmer
  • 423
  • 3
  • 15
0
votes
2 answers

In SQL Server 2008 R2 - why can't I change the sa credentails

I'm using AMAZON cloud with SQL Server 2008 R2 installed. I tried to create a password to sa and saved it. But when I went back to SQL Server (after I closed SQL Server and opened it again) it does not let me enter it with the sa credentials that I…
mql4beginner
  • 2,193
  • 5
  • 34
  • 73
0
votes
1 answer

Sysadmin and sa in sql server 2000 - drop and recreate login?

A somewhat open-ended question so any information that closes the gaps in my knowledge would be appreciated. When doing a SQL Server upgrade from 2000 to 2008 the upgrade advisor can give the following warning: The Upgrade Advisor detected one or…
Rowan
  • 463
  • 3
  • 8
  • 20
0
votes
1 answer

Login failed for user 'sa' Reset password every day

Though it seems a very basic question but I am fed up with this problem. Every day I get System.Data.SqlClient.SqlException Login failed for user 'sa'. Then I reset 'sa' password and my asp.net application starts working. I have searched this error,…
Abdul Ghaffar
  • 151
  • 3
  • 14
0
votes
1 answer

Properly set sa account for MSSQL 2012. Unable to login

I made the following settings on my SQL Server 2012 as suggested in many tutorials: I set the server authentication to "SQL Server and Windows Authentication mode" I set a strong password with enforced password policy with default database…
Vojtech B
  • 2,837
  • 7
  • 31
  • 59
0
votes
0 answers

ms sql server 2005 sa account can not access the database i created while the system databse is ok

Just like the title said. I try to write a tutorial to show how to communicate with the ms sql server. And I can communicate with the system database such like master and model. But while I create a database manually, I can't access the database.…
YiFan Wu
  • 123
  • 5
0
votes
1 answer

Can't access SQL Server with my sa credential

I reset my SQL Server 2008 R2 sa password: sp_password @new = 'joomlacmssenha', @loginame = 'sa' But when I try to access using SQL Server Authentication with these credentials, I get the following error: Connection was successfully established…
Guilherme Longo
  • 2,278
  • 7
  • 44
  • 64
0
votes
1 answer

Have SA account out of sysadmin

We have lots of scripts and applications connecting to SQL 2000 using SA account. We also have a lot of people connecting directly from their stations using the SA account. We need to migrate to 2008r2 but we can't have these users have a privilege…
Hans Gates
  • 1
0
votes
3 answers

getting into sentiment analysis

I've got a requirement of determining whether the entered sentence is positive or negative.... First I thought it is something to do with Social Network analysis and later I realised that it is Sentiment analysis. My first question is what is the…
siva
  • 1,105
  • 4
  • 19
  • 38
-1
votes
0 answers

Notepad formatting

OK folks? I need help, my notepad is not opening the document the way I need it in windows 11, I managed to fix this error in w10 through this link: https://devblogs.microsoft.com/commandline/extended-eol-in-notepad/ But in w11 it doesn't work at…
Carlos Alberto
  • 1
-1
votes
1 answer

Is it possible to remove SPI from IPSec header?

I know that SPI plays an important role in IPsec. But I want to know that: Is it possible to remove SPI from IPSec header and still get it work?
Ali Haghighat
  • 9
  • 1
-2
votes
1 answer

How to setEnabled(false) all the sap.m.Input simultaneously in sapui5 without using jquery

I am using this code but it is not giving me the result sap.m.Input.prototype.onAfterRendering = function(e){ this.setEnabled(false); };
Somdutt Sharma
  • 1
  • 1
  • 1
1 2
3