Questions tagged [sql-server]

Questions related to Microsoft SQL Server. If your question is version specific please tag it specifically for that version as well. Does your SQL Server question belong here or on another site? Click the about the sql-server tag link on the line below.

Filter by
Sorted by
Tagged with
1
vote
1answer
21 views

How do I disconnect a VM from a Log Analytics workspace that has already been deleted?

I created a Log Analytics Workspace (LAW) and connected the SQL Server to it in order to test a theory. I then deleted the Log Analytics Workspace (LAW) but did not "Disconnect" it from the LAW. I ...
0
votes
0answers
25 views

Can not create SQL Database using “Azure SQL Database Create New”. Location is no supported

When I select create a SQL Database option and select new in Database server row of the "Azure SQL Database Create New" For all selection of items of the "Location"; I get the message "This location ...
0
votes
1answer
289 views

Restore DB from SQL 2000 to SQL 2008 [closed]

I am trying to restore a SQL Server 2000 backup to a SQL Server 2008 instance. The backup does not have an extension. I also used windows authentication when the backup was created in 2004 and no ...
0
votes
0answers
11 views

Disable Remote Connections for Single Database in SQL Server Instance

I have a single machine running exactly one SQL Server instance with multiple databases. Can I disable remote connections for exactly one of these databases? I don't want to setup another SQL Server ...
0
votes
0answers
16 views

SQL Server AlwaysOn cluster - seeding large availability database creating strange behavior

I set up a 2-node SQL Server 2016 AlwaysOn Availability Group cluster (1 primary, 1 secondary). The underlying hardware is fairly powerful; 4 CPUs, 16 GB of RAM and local-attached SSD disk. Then I ...
1
vote
2answers
23 views

How to create read replica from MSSQL to MySQL through RDS

I have a RDS instance with SQL Server Standard edition. This DB is used for transactions, I want to create read replica but I want the new replica to be MySQL/MariaDB or PostgreSQL. This is because we ...
-1
votes
0answers
10 views

Unable to create new SQL Server instance

I am unable to create a new SQL server in any of the available regions in Azure. I have upgraded my subscription to pay-as-you-go as suggested in the chat with support engineer. Still no luck! Any ...
1
vote
1answer
20 views

Windows Server Authentication on SQL Server for Site-to-Site VPN

We are trying to expand our company network infrastructure to the cloud with Azure. One of the things that we will be starting with is to replicate our Domain Controller to Azure as shown in the ...
0
votes
0answers
58 views

Windows 2016 Server Core - Add node to a SQL Server Failover Cluster (NOT Working)

2016 Server CORE. Add node to SQL server 2019 Failover Cluster. Steps were taken: Added the server to the Failover Cluster I found this page, Install SQL Server from the Command Prompt which is ...
0
votes
1answer
40 views

RDS Connection Broker High Availability cannot connect to database

Scenario You want to configure Remote Desktop Services Connection Broker in High Availability mode, using (at least) Windows Server 2016. You have completed and verified all prerequisites: database ...
2
votes
2answers
31 views

Decreasing OS drive free space on Azure VM running SQL Server 2016

Recently I noticed that drive C: is decreasing in free space on my Azure VM running Windows Sql Server 2016 (doing daily azure VM backups in Recovery Services Vault). Drive C: keeps adding 100-250mb ...
0
votes
2answers
30 views

TFS Configuration - SQL Verification Error

TFS 2017.3 on-premise environment: 1 App Server, 1 Web Server, 1 DB Server I'm using an existing tfs db located at sqlserver\instance and receive the following error when specifying a tfs connection ...
0
votes
0answers
18 views

SQL Server Backup Size varies day to day

I am using SIMPLE recovery mode, and I need a backup around midnight each day. The size of the backup file changes day to day and I can't figure out why. Example, 2 days ago size is 9.6GB, 1 day ago ...
1
vote
1answer
12 views

Databases “Synchronized / In Recovery” after adding server to SQL Avaylability Group

I have an SQL AlwaysOn Availabilty Group configured with 2 nodes. The AG works without any problem with this 2 nodes and I can do a failover to/from any of them (this servers are on the same network). ...
0
votes
0answers
26 views

Sql Server 2017 - Cannot shrink transaction log file, blocked by LOG_BACKUP status

Last week my sql server 2017 instance (running on windows server 2016) ran out of space, filling the disk completely up with a 190GB transaction log file. Luckily this was on a cloud instance, so I ...
0
votes
0answers
27 views

“An unexpected error occurred” Power Bi Role definition generates error against SQL server DB

I'm trying to filter a Power Bi Dashboard based on the user profile. if an admin logs in he should be able to see everything. Otherwise a row level filter is applied. to do this I'm connecting to a ...
0
votes
1answer
30 views

Results of reorganize vs rebuild index

(Some context first because while I hope the questions are general enough we're always told the solutions depend on context. There's no DBA in this scenario.) This is a [very small office] database, ...
0
votes
0answers
17 views

Run Apache2 as active directory service user including Kerberos

I've a problem running Apache on Ubuntu as a service user. The Ubuntu server is joined to Active Directory and Kerberos Authentication is working fine for hosted webpages. Apache server is running as ...
2
votes
1answer
46 views

Server 2012 R2 backup and restore

I do not have much experience with backup/restore to windows server images. I have a Windows server 2012r2 with sql and an accounting program. It is/was joined to a domain. I had to do a restore ...
0
votes
0answers
29 views

LOGMAN save to SQL Server with Sql Server Authentication

I want to set up LOGMAN to save counters to a SQL database on another server, with Sql Server Authentication mode. First I create a database on the SQL Server (another machine) and a login: Create ...
0
votes
0answers
25 views

I can't connect directly to SQL using local IP if router has port forward enabled

I'm experiencing a rather weird situation. I have a SQL server that I connect every timd by using this "Connection String": Data Source=TCP:MyPublic-IP\SQLEXPRESS, 1433; Initial Catalog=MyDatabase;...
1
vote
1answer
34 views

Cannot login to SQL Server instance installed on Debian using domain account

I can login to SQL Server 2019 (installed on Debian Buster) with SA account using SQL Management Studio on Windows Server 2016, but I cannot do this with the domain account using integrated ...
0
votes
0answers
27 views

Starting MSSQL's SSIS on Linux and making sure it works

I'm trying to connect with SSIS that was installed on MySQL Server (on RHEL 7). It was installed and configured according to documentation. I can connect to server using SSMS (as Database Engine), ...
0
votes
0answers
28 views

Database Connection in AWS Window Web Server to AWS window database server is too Slow

I have two windows server in AWS, One Web Server (hosted in a ASP.NET Core web application) second one is Windows server with SQL Server (stranded version). I have problem in connection application ...
0
votes
0answers
24 views

Transfer Logins between LocalDBs?

I am trying to emulate a fairly complex database schema inside of a localdb. Essentially I am running a third party installer on my own instance of localdb which creates logins, users, stored ...
0
votes
2answers
62 views

Permission issues in cloudSQL SQL Server (GCP)

I see permission error when i tried to shrink files/db in CloudSQL sql server. I know its a managed service and do not have sa user and super privileges. But is there any similar user like sa (or) ...
-2
votes
1answer
27 views

What is “localcomputer” or domain and how to get it?

I am trying to install a program (Microsoft SQL Data Sync Agent), and in one step it is asking me the following: Enter the account you want to run Windows Service under. E.g. domain\user. ...
0
votes
0answers
20 views

ODBC / MS Access connection from Hyper-V VM to SQL Server on host

I am working on a very legacy piece of software which requires that the development environment runs in a Hyper-V VM. It uses ODBC to connect to a SQL Server, which is currently installed on my ...
0
votes
1answer
45 views

NUMA 1 not used on SQL Server 2008 R2 on Windows Server 2008 R2 on ESXi

We've got Microsoft SQL Server 2008 R2 running on Windows Server 2008 R2, virtualized on VMWare ESXi 6.7.0. The server has 2 CPU sockets with 22 cores each. The VM is allocated 8 sockets with 3 cores ...
0
votes
0answers
44 views

SQL Server 2014 not replicating NEW non-clustered indexes

I have an instance of SQL Server 2014 running replication. I have selected the option to copy nonclustered indexes on all tables: When this was first enabled, all existing nonclustered indexes were ...
0
votes
1answer
37 views

SSH Port Forwarding to SQL Server Not Working

I am working with an AWS environment containing a Ubuntu server to which I can establish an SSH connection a MySQL server an MS SQL server I can SSH into the Ubuntu server and from there verify ...
1
vote
1answer
29 views

What are the best practices I should follow to secure my windows server 2016 web server

I have a dedicated server windows server 2016, IIS, Sql server 2018 enterprise edition with MS SQL Server databases. I use this server to host my dotnet core applications I manage this server via ...
0
votes
0answers
32 views

Trying to figure out long run times with sqooping jobs (sql server to hadoop)

I inherited a new customer as a sql server dba and they are using some java-based framework that has a jdbc connection from sql server to hadoop. They have a sqooping job that runs once a day to do ...
0
votes
1answer
18 views

localdb RESTORE SQL works on my Win 10 box, but not my Azure pipeline agent

I have an Azure pipeline that refuses to run my integration tests (well, prior to running the tests, it must create necessary databases from .bak files - and that's the part that is failing) This SQL ...
0
votes
2answers
45 views

How to allow remote connection to SQL Server instance only to specific public IP Address (white-list) & restrict access to all other IP's [closed]

How do I allow remote connection to SQL Server instance only to specific public IP Address (white-list)? For example, login from SSMS to SQL Server instance hosted on Windows dedicated server ...
0
votes
0answers
8 views

SSRS - no layout after migration

I have tried migrating SSRS (SQL Server Reporting Services) to a new application server and database, but the web app on the new server no longer has any CSS (layout). BEFORE SSRS and database on ...
0
votes
1answer
68 views

Cloud SQL Server get sa password

I have created an SQL Server instance in Google Cloud SQL, I have the sqlserver user but it doesn't have sysadmin permission, so I want to know if it's possible to get or reset the password of the sa ...
0
votes
0answers
38 views

Finding the powershell CIM equivalent to columns from Sql Server sys.dm_os_sys_info

I have a normal sql server select that I do which collects information from these two columns from a dynamic management view: SELECT cpu_count, hyperthread_ratio FROM sys.dm_os_sys_info I am ...
0
votes
1answer
77 views

SQL Server sometimes returns null

We are experiencing a strange problem we weren't able to reproduce as it is only happening sometimes. The issue is that sometime a query returns empty when it should contain data. If run again, it ...
0
votes
1answer
18 views

MSSQL Passthrough Database options?

Is there an option out there to create a MSSQL Database that is a passthrough of a sort? To give the scenario we are in, we have one central large database that is a copy of production that is used ...
0
votes
2answers
113 views

Is my MS SQL Server being attacked?

I use MS SQL Server 2017 Express Database in windows 2016 server, I am seeing that the ERRORLOG file of MS SQL Server is increasing 600MB per day. The below is from the ERRORLOG file. Does this mean ...
1
vote
0answers
38 views

Client App using MS SQL Server 2000 periodically requires sa to reconnect client

I am now supporting a funky old app from 2000 that is an MS SQL Server 2000 client. For some unknown reason, random staff members will periodically not be able to log in to the app. I then have to ...
0
votes
1answer
38 views

SQL Server Express Reporting Services is accesible from another server?

I am thinking of installing a Sql Server 2017 Express with Advanced Services. All data will be stored in the local instance as well as the Reporting Services. The question is if someone in another ...
0
votes
1answer
62 views

SSMS Designer Removing Square Brackets

I am designing a view that accesses tables in a linked server. Every time I paste this query into the SQL pane, Intellisense removes the square brackets, and then complains that there's more than 3 ...
0
votes
1answer
113 views

How to install a certificate and encryption on SQL Server without downtime?

So I have a SQL Server 2016 instance running a mission critical workload. I want to install an SSL/TLS (publicly signed) certificate into the server, and enable encryption. But I don't want to incur ...
0
votes
1answer
37 views

How can I work around Read-only SQL users finding out an MSSQL app login without needing to take a production outage?

I've inherited a 3-tier production environment where some app servers are using a local SQL admin login to integrate to the database (terrible, I know). Some honest developers recently disclosed to ...
0
votes
1answer
99 views

Windows Firewall blocks SQL Server after installing Update KB4505224

after installing the SQL Server Update KB4505224 this weekend, I’m no longer able to connect to the SQL server from the network. On localhost it still works. If I disable the windows firewall ...
0
votes
1answer
93 views

sql server blocks after multiple failed connections from trusted ip

We have a high load sql server that is not externally exposed. The web server accesses the sql server over a lan. For the most part it works great but from time to time when the sql server has ...
0
votes
1answer
47 views

Do numerous failed logins from unauthorized IP address affect sql server performance?

If a sql server is allowed to be accessed from any outside IP, and if windows event logs numerous (wrong) login attempts from unauthorized ip addresses/uses, does it influence sql server performance? ...
0
votes
0answers
41 views

Enable SQLSRV on centos 6.10 for php 7.2

I want to use the MSSQL database with my PHP application. I have Server with Centos 6.10 and PHP version 7.2. What should I do so I can enable SQLSRV extension or any other extension where I can use ...

1
2 3 4 5
93