Stack Overflow
Stack Overflow

Questions tagged [sa]

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

43 questions
0
votes
1 answer

Strong password for SQL Server doesn't follow the documentation

I'm installing a new instance of SQL Server Express with mixed mode for access. The password I'm setting is Abcd1234(). According to the docs for strong password guidelines, it's supposed to be valid if it consists of more than 8 of the…
Konrad Viltersten
  • 36,151
  • 76
  • 250
  • 438
0
votes
1 answer

'sa' user is "pinging" my Azure SQL Database

I have a Azure SQL Database with Auditing turned on. I noticed that my database comes online after a pause when it shouldn't. I checked the audit logs and it shows strange entries of 'sa' login trying to do smth. Not sure what these entries mean. Is…
Tautvydas Perminas
  • 31
  • 3
0
votes
1 answer

Quantifying the load on SQL Server 2008 from brute force attacks?

I have a SQL 2008 box that has been the recent target of brute force attacks on the "sa" account (silly kids . . .). Is it possible to quantify the server load of a single attempt at logging in to SA with a bad password on an account that is also…
Unknown Coder
  • 6,625
  • 20
  • 79
  • 129
0
votes
0 answers

set mixed mode authentication in SQLCMD

Is it possible to set mixed mode authentication from within SQLCMD? I installed SQL Server 2012 Express last week because I forgot my old installation password. It didn't help. I've been through a ton of stuff just trying to get back to square…
urbancenturion
  • 3
  • 8
0
votes
0 answers

why I search Milvus return `The vector dimension must be equal to the collection dimension`?

great guys.I have one problem to ask all of you for help! Yesterday,I have a task that was I need to search Milvus. The Milvus API in my application is already have.I just need to get the client and send request! But there is a wild question cause I…
Eric's easy home
  • 1
0
votes
1 answer

NER german natural objects

I have some familiarity with R, and I am just starting with python to get into NLP, with a specific interest in Semantic Analysis and Named Entity Recognition (i am currently learning spaCy). I have a background in Humanities and very little…
Grig
  • 109
  • 1
  • 10
0
votes
2 answers

sql server 2008 enable sa account

I logged into my PC with administrator account. When I try to enable the 'sa' account of SQL Server 2008, I get the following error: TITLE: Microsoft SQL Server Management Studio ------------------------------ Alter failed for Login 'sa'. …
y_zyx
  • 582
  • 4
  • 10
  • 28
0
votes
2 answers

sql server 2008 enable sa account

I logged into SQL Server 2008 via SQL Server Management Studio using Windows admin account. When I run the command (ALTER LOGIN sa ENABLE) I get the following error. Cannot alter the login 'sa', because it does not exist or you do not have…
y_zyx
  • 582
  • 4
  • 10
  • 28
0
votes
0 answers

SA default password SQL Server on Linux

I installed SQL Server 2017 on Linux on a CentOS 7 derivate. Now I want to login with the command: "sqlcmd -S 172.0.0.1 -U SA". But I never set up a password. How am I able to login to the SQL Server? Root password is also not working. Could it be…
Ivo
  • 303
  • 2
  • 15
0
votes
0 answers

SQL Server 2014 sa account audit trail

I need to implement an auditing for everyone logging in to SQL Server 2014 using the sa account. User should be able to provide user id and reason why he/she is logging as sa, which should be stored in a specific table with a timestamp. What is the…
Hanna Vasilenka
  • 11
0
votes
1 answer

Sql Server 2012 enterprise "sa" login failed. Error: 18456

SQL server 2012. Windows 10 Professional. I enabled "sa" user account, and the authentication mode is set to "windows authentication and SQL server authentication". I set the password for "sa user account". but I cannot login into it. Error:…
AverageJoe
  • 13
  • 1
  • 5
0
votes
2 answers

Can you protect linked servers from sa

We have a third-party vendor setting up software on a server. They have full access to that server and the sql-server on it with the sa account. We would like to set up a linked server so that a trigger can update data on a remote machine. Does…
Marty Neal
  • 8,741
  • 3
  • 33
  • 38
0
votes
2 answers

Why I cannot change sa password using osql?

I got a laptop on which SQL Server Express is already installed. The server name is SRH\SQLEXPRESS and the version is 10.0.2531.0. The operating system is Windows 7. I can connect to it through Windows Authentication. But I would like to connect to…
srh
  • 1,661
  • 4
  • 30
  • 57
0
votes
1 answer

Print my sa password

I've logged in to my sqlserver with a registred "sa" sql account and I want to print (not change) my current password. I can change it but I have an application using the current password. I have done select * from sys.sql_logins where name…
jellad.tarek
  • 135
  • 1
  • 3
  • 10
0
votes
1 answer

Running query on a linked server

I have a local database server which has an associated sa account and on a cloud instance where we have another server I have added it to the local database server as a linked object. When I attempt to query on the database using the…
Jay
  • 3,012
  • 14
  • 48
  • 99
1
2
3