Stack Overflow
Stack Overflow

Questions tagged [sql-server-administration]

43 questions
1
vote
0 answers

Script to Deny backup for Database owners

I am looking for a script to Restrict Database owner to take database backups in SQL server. Till now i was using Sp_msforeachdb to create role and adding DENY Full and LOG backups to it.
latha
  • 11
  • 2
1
vote
0 answers

Not Able to Connect to my MS Sql Data Base on My Vps from my WCF Service Hosted on IIS7 on the same Vps

I have written a webservice from where i pass data to my localhost Ms Sql DB. It was working properly on my pc but when i hosted it on my godaddy Windows Vps there is an error: Request Error The server encountered an error processing the request.…
Vishal Jain
  • 11
  • 1
1
vote
1 answer

Permission of sqlserver doesn't exist but with sa exists

I have a problem with sqlserver authentication . When i connect to my instance using this information local,windows authentican i have this permission : But with sqlserver authentication local,sa,12345 i have this permission: Last day the both…
Ehsan Akbar
  • 6,977
  • 19
  • 96
  • 180
1
vote
2 answers

SQL Server 2008 R2 Upgrade / Server Move to SQL Server 2014

I have a new server and want to install SQL Server 2014 Standard and migrate my database across from my old server which runs SQL Server 2008 R2 (10.50.1600.1). I have upgraded locally, but having to move servers on my production environment…
Andrew Kelly
  • 123
  • 1
  • 2
  • 10
1
vote
1 answer

Rails, Extjs and SQL Server

So I'm running Extjs on top of Rails 2.3.3 against a SQL Server DB. I'm able to pull data from the DB and display it, but I'm unable to create, update or destroy. Oddly enough, it's not throwing console or any other errors on attempted updates or…
Joseph Weissman
  • 5,697
  • 5
  • 46
  • 75
1
vote
4 answers

Apply upgrades (application related) to database

Since I've not done this before I am not sure if the way I am planning to do this is okay or is there a better way. Like using Windows Installer or Install Shield or Windows Installer XML (WiX) toolset. Any help would be great, as I have no clue. We…
UB.
  • 367
  • 5
  • 14
0
votes
0 answers

SQL Server 2019 user is dropped from database but error log says couldn't remove

I have SQL Server 2019. I have dropped a user from the database but there was below message in error log. "Couldn't remove the user (n) from database (n) from the external libraries folder, error: 0x80070003" Dropped the user. Checked error log,…
Sai Prabhu
  • 1
0
votes
1 answer

Blocking access to specific tables

We have PowerBI Users that are now asking for access to our database as datareaders. I have added a new User, provided the Username/Password to them. However, I would like to block access to two specific tables due to sensitive information. The…
Scott Scriver
  • 17
  • 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

There is any option to run sp_addmessage in Google Cloud SQL Server

I am trying to migrate SQL Server 2017 which is running on on-premise to Google Cloud SQL. I have created the cloud instance & imported my current database backup to it. Now all working fine and able to connect applications to database without any…
Girish007
  • 442
  • 6
  • 26
0
votes
0 answers

SQL Server Agent new Job dependency on existing Step of an existing Job

I have 2 jobs; Job2 is dependant on the completion of Step16 of Job1. All these steps are performing data refresh for different systems. Job1: has 25 steps in a sequenced manner i.e. Step 1 completes then Step2 starts and so on Job2: has only 1…
Adityan s nair
  • 13
  • 5
0
votes
1 answer

How to security access onprem database from Azure AppService

Is there a way to securely access a on-prem Sql Server, from an AppService? The IT guys are nervious about letting an App Service which needs access to our on-premise database. I am not a networking guy, and am trying to come up with a solution. The…
Greg Gum
  • 33,478
  • 39
  • 162
  • 233
0
votes
1 answer

I have problem when I config a distributed always on availability group

I have 4 virtual machines with SQL Server 2017 Two machines IP are x.x.190.5 and x.x.190.6; these machine have first always on availability group (AVG01) And the other machines IP x.x.189.1 and x.x.189.2; these machine have second always on…
Mahdi Rahimi
  • 564
  • 4
  • 22
0
votes
0 answers

SQL Server Connection error: Setting IsolationLevel to ReadCommitted is not supported

I'm trying to connect to SQL Server from Anypoint Studio but I'm getting following error: This is the connection string which I'm using: jdbc:sqlserver://adwdmzdw1.database.windows.net;DatabaseName=adwdmzdw1;user=*****;password=********** Thank…
Hitesh
  • 11
  • 2
0
votes
1 answer

The transaction log for database 'tempdb' is full

I have only read permission to the database I'm querying in. The same query was working for since yesterday but today I am encountering the below error in sql server management studio. The transaction log for database 'tempdb' is full. To find out…
Rob
  • 9
  • 1
  • 1
  • 3
1
2
3