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
0
votes
0answers
6 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
30 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
35 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
53 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
0answers
11 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
91 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
36 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
23 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
57 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
108 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
52 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
91 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
46 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
24 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 ...
5
votes
2answers
201 views

SQL Server Page File location - where to put it?

There are a lot of recommendations about the sizing of the windows page file. What I am looking for is the correct placement. We are running a MS SQL server on a Server 2012R2 VM with multiple ...
1
vote
2answers
84 views

no permission to connect to the WMI provider - after sql server installation

I am the administrator of a windows server 2016. After installing sql server, I want to use the sql server configuration manager to have a look at what ports and accounts are there, check if all is ok....
2
votes
1answer
32 views

Why can't I restore encrypted backup through front end?

I'm just starting to experiment with encrypting backups, I think I now understand it and have got the process working, but something strange is happening with restoring. On Server A (SQL 2014 ...
0
votes
0answers
24 views

Sql always on availability groups - Cluster offline after network lost

I have the following situation : Windows 2016 workgroup cluster with 3 nodes. All the 3 nodes are part of SQL 2016 always on availability groups. No quorum configure. The cluster works fine, for ...
0
votes
0answers
7 views

Using Splunk DB Connect 3 in a large environment with connection pool

I am wondering if anyone can speak from experience with using DB Connect for a large number of sql server instances, each of which installed (so about 2,000 separate instances total). We currently use ...
0
votes
3answers
94 views

Copying SQL Server settings to new server

We are a small business using a single SQL Server 2014 instance as our main data platform. We now need to set up a second instance (2017) to hold additional data - this is to be standalone, ie not ...
2
votes
2answers
153 views

Suggested indexes

I am new to indexing in general and have just started learning about query plans etc. I am working on this one specific query that keeps advising me to create the following index: CREATE NONCLUSTERED ...
0
votes
1answer
89 views

IIS and SQL 100% CPU Usage

We have an IIS server running an ASP.net application and SQL Server. Most of the time it runs fine, but recently we have had a couple of instances of severe performance degradation. The whole site ...
1
vote
2answers
77 views

Cannot connect to the MS SQL Server 2014 from a remote machine via named pipes

I installed MS SQL Server 2014 on a machine that had an MS SQL Server 2012 default instance. On the local machine, I can connect to both instances using named pipes. However, from a remote client, I ...
0
votes
1answer
39 views

Apache is getting SUSPENDED in MSSQL by another process when doing more than 5-6 queries via PHP PDO resulting in timeout

I will try to be as detailed as possible. Up until now I was only using Stack Overflow and other sites like this but never posting. I was always able to find the answer to my question. But not this ...
0
votes
0answers
27 views

Azure data migration project issue — AWS VM to ManagedInstance

I've been tasked with migrating a set of databases that are hosted on a single AWS VM (not RDS) running SQL Server 2012 (pre sp1... version string in SSMS is 11.0.2395.0) to Azure. Unfortunately, the ...
36
votes
7answers
8k views

Can Microsoft employees see my data in Azure?

I have sensitive data stored in both Azure DB and Azure SQL VM. An authorised DBA can log on and query the database, but in theory could a random Microsoft employee do the same without asking ...
0
votes
2answers
94 views

TDE vs Disk Encryption

We are a small business that host applications and data for clients. Some of our clients are requesting we protect their data with 'encryption at rest' - although it's never very clear if they know ...
0
votes
0answers
58 views

Why does SQL Server keep creating the folder “C:\Program Files\Microsoft SQL Server\” when installing on another driver?

I specified a different drive wherever applicable during the SQL Server 2017 install. However, the directory C:\Program Files\Microsoft SQL Server keeps getting created. I basically have the expected ...
0
votes
0answers
43 views

Very High Network bandwidth usage (almost 20 GByte/Hour) Windows server 2012 R2

My server provider sent me an email with PRTG network moniter report saying that my outward traffic volume is too high (say 15GByte/Hour). I checked my network consumption with resource monitor ...
0
votes
2answers
58 views

Backing up Azure SQL Server databases to external destination

I run a bunch of Azure SQL Server databases, and they are backed up internally in Azure to storage. This is great for most cases. However, to mitigate risk (if for example, we lose access to the ...
0
votes
1answer
133 views

Windows Memory Usage - Is something throttling available RAM

Can anyone tell by the images below if this machine is unnaturally throttling memory usage. The memory was upgraded from 32GB-64GB for SSRS report rendering, which is the only sizable process to run. ...
1
vote
1answer
125 views

256TB, GPT disk, I can, but should I?

I just learned (thank you Kevh) that a GPT drive on Windows can hold 256TB Unlike MBR that limits each partition to only 2TB in size, each partition in GPT can hold up to 2^64 blocks in length (...
0
votes
0answers
39 views

Unable to access SQL Server on the Host Machine from SQL Server Management Studio in the Guest VM

Using VMware Workstation 15, should I be using host-only for my scenario below? I need to access SQL Server, hosted on a Windows 10 host, from a Windows 10 Guest VM, without giving the Guest VM ...
0
votes
0answers
163 views

Attaching to an existing DB fails - folder keeps setting itself to read only

Having found no solution to the network problems I suddenly encountered, I uninstalled MSQE but left the MDF files in place. I then re-installed a fresh 2014 and started it up with a test DB from a ...
1
vote
1answer
57 views

Suddenly my local SQLServer is kicking named pipe errors

I have a local instance of 64-bit SQL Server Express 12.0.something. I use it for local tests of our SQL code. Today, out of the blue, I get: Additional information: A transport-level error has ...
0
votes
1answer
44 views

Microsoft SQL gradually increasing RAM consumption while using my website

I'm developing a website hosted on Apache 8.5 that connects to a Microsoft SQL server using Hybernate and the entity/dao/bean structure. When I start the server where MS SQL is located and open the ...
-1
votes
1answer
142 views

SQL Server 2019 RC in Production? [duplicate]

I have a MS SQL Server 2008R2 running our two main databases. I have a few problems with MS SQL Server 2008R2, and would like to upgrade ASAP. i did however not get the funds to buy a 2017, only for ...
1
vote
2answers
303 views

How to find missing permission in MS SQL server

Problem description: I am trying to use SQLDependency on a table of a commercial product (TAC Reservation Assistant). The DB is a large Microsoft SQL 2016 database on which we don't have db_owner ...
0
votes
1answer
37 views

Email notification when login attempt fails on RDS SQL Server DB

I need to get notified when there is an attempt to access our SQL database with the incorrect credentials. Is this something that I can do in AWS or do I need to do it in SQL Server? I can manually ...
0
votes
0answers
76 views

Next step when DBCC CHECKDB REPAIR_ALLOW_DATA_LOSS failes

I'm in a situation where a few Tables of a Database (MSSQL2016 - 13.0.5081.1) are corrupted (selecting data failes at some point) There is no valid backup available (the error seems to be present in ...
1
vote
1answer
28 views

Alter database blocked by -2

We have a database that we can't restore because any alter database to put it into single_user mode (or offline) will fail because it is blocked by a distributed transaction. sp_lock -2 shows the ...
0
votes
0answers
156 views

OLE DB Driver for SQL Server on Windows 10: only 64 bit?

I'm trying to install SQL Server OLE DB Driver 32 bit on a Windows 10 (64 bit) via the downloaded instaler: msoledbsql_18.2.2.0_x86.msi. I get the message: Microsoft documentation says that on ...
0
votes
1answer
31 views

How to connect Azure Database migration service with on premise based source SQL server

I am trying to connect Azure Database migration service with SQL server which is in On premise VPN. Not able to establish the connection.
1
vote
0answers
93 views

Docker SQL Server remote login from IIS login failed for user sa

I have this error when I trying to connect ASP Classic web app (hosted in IIS 10) to SQL Server 2014 with username and password using a DSN configured in IIS dockerfile: Microsoft OLE DB Provider for ...
0
votes
0answers
9 views

Azure data sync

I have a SQL server on premise, and a Azure instance of SQL Server. I am working through the implementation guides, but this one question, i have not found a solid answer to. If the connection fails ...
3
votes
1answer
315 views

SQL Server 2016 remote access denied

I have two VM with an SQL server on each and I need to connect to both SQL servers from each machine, either from SSMS and with PowerShell script. Also, today I don't manage to do that I'm always ...
1
vote
1answer
229 views

Is this an IIS issue or a Database Issue? Non Concurrent collections must have exclusive access

I am using asp.net core api with EF core and today I got this error message and it confuses me as of why it could have happened. Operations that change non-concurrent collections must have exclusive ...
0
votes
0answers
19 views

Is there is a way to configure SQL Server 2014 cluster to keep the same DB ids when switching between nodes?

The DB has different id on SQL Server nodes, and it a problem because our license depends on db id. Is there any way to configure the cluster to keep the same id on both nodes? Thank you!
1
vote
0answers
99 views

Restore AWS RDS Database with memory optimized Filegroup in Amazon S3

Can't restore AWS RDS database that has memory-optimized data. I have a backup in S3 and when I try to do a restore into RDS: exec msdb.dbo.rds_restore_database @restore_db_name='MyDatabase', ...