Questions tagged [sql-server-administration]
43 questions
0
votes
1 answer
Prevent user from set DB to a single user mode
We have a requirement for application (NextGen ERH) to work with SQL Server (2016, on-premises) DB under credentials with sysadmin role.
Our need is to prevent that tech user from setting DB to a single user mode - we noticed that sometimes such…
vyarovoy
- 62
- 7
0
votes
1 answer
Error message from database execution: Access to the remote server is denied because no login-mapping exists
Environment & Details
Environment – SQL Server 2014.
All DB’s are participating in
availability group.
To connect to Read only node of Server, we
created the linked server on both node.
Internally,we have provided the Server DNS name and…
Mangesh Tambare
- 49
- 2
- 7
0
votes
1 answer
How can we assign permissions to setup SQL Server Reporting Services
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 backup/restore their Databases but do not have…
nam
- 21,967
- 37
- 158
- 332
0
votes
1 answer
multiple user on sql server
It might be very basic question for you friends, but how to allow multiple users on SQL Server installed on remote windows server 2012 machine.?
right now only two user can work at the same time if third one comes one of two who are active has to…
user2040021
- 309
- 3
- 15
0
votes
0 answers
How to find out the configuration need for the server?
We are creating 2 sets of 2 new server(2 for prod 2 for test) and one server will have database engine and SSIS and the other server will have SSAS and SSRS.
How can I find out what configuration I need for the server and what RAM, Size of Disk,…
Justin
- 393
- 1
- 7
- 21
0
votes
0 answers
Granting permissions to analysis services SQL Server 2014 with windows authentication
I am trying to deploy my first cube in SSAS but the deployment fails because a connection isn't established. The problem is related to giving privileges to SSAS from windows. It seems I have to create or change privileges to something called Local…
user2004820
- 321
- 2
- 11
0
votes
0 answers
Database Backup Failure SQL Server 2012 Enterprise
I am running a split disk backup such as:
BACKUP DATABASE [At] TO
DISK = N'O:\sql_bak\At_full1.bak',
DISK = N'M:\sql_bak\At_full2.bak',
DISK = N'L:\sql_bak\At_full3.bak' WITH NOFORMAT,
INIT,
NAME = N'At-Full Database Backup',
SKIP,…
Anandita Sharma
- 405
- 1
- 3
- 9
0
votes
1 answer
DBA's Checklist for performance tuning
In our production environment, Some times server becomes too slow, even good optimized queries start facing timeout error & some even get blocked.
What are the basic things that could cause this slowdown ?
I'm very new to these type of activities,…
Vignesh M
- 168
- 3
- 14
0
votes
3 answers
Detach and Attach a database in Suspect Mode
Problem:
Backups were failing in one of our servers with the below message: (Backups are taken via Netbackup)
Could not allocate space for object 'dbo.backupfile'.'PK__backupfi__57D1800AC4FFEEA3'
in database 'msdb' because the 'PRIMARY' filegroup…
aok
- 334
- 4
- 7
0
votes
1 answer
Slow queries on a MySQL slave
Let's suppose a system that has a MySQL master server and a slave.
A lot of read\write is happening on the master server and I choose to perform a heavy slow query on the slave.
What could happen? Could the master server show some slowdown?
XCore
- 119
- 3
- 9
0
votes
1 answer
What is the most secure way to allow users to execute BCP export command from SQL?
I am currently working in an environment where the ability to export a table programatically from within a hand-run SQL script would be of great help.
Performing the exports from script will be the first step towards running the entire process…
samaspin
- 2,342
- 1
- 26
- 31
0
votes
2 answers
How to calculate the total memory occupied by the database
I am using sqlserver 2008, How can I calculate the total memory occupied by the Database with tables (>30) and also data in it.
I mean if I have DB (DB_name) and with few tables(tblabc, tbldef......) with data in it, how to calculate the total…
user301016
- 2,207
- 7
- 36
- 50
-1
votes
1 answer
Can SQL Azure Globan Admin & created user passwords be reset/changed?
After I provision a SQL Azure Single DB - with a Global Admin login/password - can it be changed after the initial deployement via SQL Scripts?
Can the passwords for the SQL logins/user created by the above Global Admin - be changed/reset after the…
GilliVilla
- 4,998
- 11
- 55
- 96