Stack Overflow
Stack Overflow

Questions tagged [sa]

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

43 questions
121
votes
10 answers

How can I set an SQL Server connection string?

I'm developing a simple C# application, and I'd like to know this: When I connect my application to SQL Server on my PC, I know the connection string (server name, password, etc.), but when I connect it to another PC, the SQL Server connection…
Roshan
  • 3,236
  • 10
  • 41
  • 63
14
votes
2 answers

SQL Srv 2016: Login failed for user 'MicrosoftAccount\...'

I have Windows 10 Pro machine with SQL Server 2016 Dev installed. There are two local user accounts on the machine: [WORK\admin] and [WORK\erop]. [WORK\erop] account was created at first without connecting to Microsoft. But later I connect it to my…
erop
  • 1,510
  • 1
  • 14
  • 27
2
votes
2 answers

Is there a T-SQL function to return the name of the 'sa' account?

(I know the question sounds ridiculous, but bear with me ...) Our DBA changes the 'sa' account name to something else for their own security purposes. There are business needs to use the account name in script (e.g. sp_add_job), but this will break…
Chris Simmons
  • 6,924
  • 5
  • 31
  • 47
2
votes
2 answers

Forgot SA password and user in Administrators account can't change it?

I have a local install of SQLExpress that I haven't touched in months. Now I need to use it, and I've forgotten the SA password. That would be fine, except that my local user which IS a member of the local Administrators Group apparently doesn't…
James P. Wright
  • 8,991
  • 23
  • 79
  • 142
2
votes
2 answers

How to recover SQL Server ownership when NT account is not valid anymore

I have a local SQL Server Express 2005, for which I don't know the SA password. I always connected with my NT login and I used that when I created a DB I want to access now. My company split and I am a member of a new domain now. There are no…
vorai
  • 61
  • 3
2
votes
4 answers

Create a new database problem

I'm logging in to create a new database from CMD through sqlcmd with SA account. Its response is a message: CREATE DATABASE permission denied in database 'master'. I'm using Windows server 2003 and SQL 2008. Please help me. Thanks in advance.
Mr.Bua
  • 158
  • 1
  • 7
2
votes
1 answer

Sql Server 2008 - SA account lockout troubleshooting

We currently have a legacy system running on Windows 2003 IIS 6 using .Net 1.1. It makes connections to our SQL Server 2008 R2 using the 'sa' account (I know it shouldn't; we're rewriting the app, but it's a big process and not near completion). We…
gizmoboy
  • 260
  • 3
  • 12
2
votes
1 answer

H2 database password recovery

We have thousands of users using H2 database, and sometimes, somehow, someone forgets the password. Is there a way of recovering, at least, the SA user password? Of course, i tell them that no one would be happy that this would be possible if the…
marcolopes
  • 9,232
  • 14
  • 54
  • 65
1
vote
1 answer

How can I copy CTRL-C content from a single cell in DBISQL?

I use DBISQL on Win32 on 12.0.1.3769. Usually, I am interested in copying cell content from the Result pane of DBISQL, not the contents of the complete row or the row headers. I can do this by using the context menu and choose "copy data / cell" (I…
Gabriel Luke
  • 11
  • 3
1
vote
1 answer

Best place to keep user uploaded aspx file in asp.net application

In my asp.net application, user can send/upload aspx files & those files can be accessed by the users later(there need to implement code level security as it would be better to run the application with minimal permission). So now I need to store…
ramkumar
  • 269
  • 1
  • 3
  • 10
1
vote
2 answers

SQL Server Login Failed for User SA

I just logged in to SQL Server 2005 with SQL Server Authentication but was stuck at the error message saying "Login failed for user ‘sa’, (Microsoft SQL Server, Error: 18456)". What happened to this?
Ben
  • 11
  • 1
  • 2
1
vote
5 answers

how to reset SQL Server sa password

I've forgotten my sa password and already disabled windows authentication mode. How can I reset SQL Server sa password with disabled windows authentication tnx in advance
arman
  • 11
  • 1
  • 1
  • 5
1
vote
0 answers

sqlcmd Login failed for user sa

I am trying to run this command sqlcmd -U "sa" -P "mypassword" -S (local)\SQLEXPRESS -Q "ALTER DATABASE mydatabase SET SINGLE_USER WITH ROLLBACK IMMEDIATE" from a .bat file but it is failing with the error "Login failed for user 'sa' I have gone…
Sachin Kainth
  • 45,256
  • 81
  • 201
  • 304
0
votes
0 answers

I can not login with sa user with entity framework in .net core web api project 6.0. I am able to login on with sa user on sql server management

I have a .net core 6.0 web api project. I am using entity framework code first. I am trying to login with sa user. I set a password for sa user on sql server management and I am able to login with sa user and password on sql server managment. But I…
Tekin Bozyel
  • 1
0
votes
0 answers

storage bucket permissions GCP

I have a service account (editor) writer. i added the storage.objectadmin role. they still can't access current buckets in the project. am I missing storage.bucketviewer or storage.buckets.get? thanks, J
A Morales
  • 1
1
2 3