Server Fault Stack Exchange
Server Fault Stack Exchange

Questions tagged [sql-server-2016]

63 questions
1
vote
2 answers

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. however I get the error message - cannot…
Marcello Miorelli
  • 215
  • 1
  • 12
1
vote
0 answers

MS SQL 2008R2 Peer-to-Peer replication Zombie data

We have two SQL 2008R2 boxes - each in a geographically separate data center - that stay sync'd using peer to peer replication (with a pair of smaller boxes acting as replication providers). This replication has been running like a champ for more…
RemonsterGrrr
  • 11
  • 1
1
vote
0 answers

Restoring SQL Database with NoRecovery stuck

We are moving from a SQL 2008 standalone instance to a SQL 2016 HA Failover Cluster Instance (FCI) with an AlwaysOn Basic Availability Group (BAG) configured to replicate to a standalone DR instance off site. I am trying to restore the database from…
Z Holt
  • 219
  • 1
  • 6
  • 19
1
vote
0 answers

T-SQL Finding who attempted to backup the “master” database?

I'm running SQL Server 2016. For the last two nights at 7pm the SQL Server Alert System sent me this alert: 'Severity 016: Miscellaneous User Error' DATE/TIME: 8/8/2018 7:02:19 PM DESCRIPTION: BACKUP failed to complete the command BACKUP…
andyabel
  • 111
  • 1
1
vote
1 answer

Is Windows able to run Disk Optimize with SQL Server running?

I've just inherried a SQL Server, where the database file growth was set to 1MB. So there are a lot of databases (>25) that have grown in small increments until now (currently totalling 300 GB). So I thought the hard disk must be really fragmented,…
Henrik Staun Poulsen
  • 143
  • 1
  • 5
1
vote
0 answers

Using AlwasyOn Failover Cluster Instance in conjunction of Peer to Peer Transactional Replicaiton

We are deploying two physical sites each with writable/readable access to its local SQL server. Each site has site redundancy and also cross site synchronization is required. My thought is to use the AlwaysOn Failover Cluster instance to achieve…
MidTierDeveloper
  • 49
  • 1
  • 5
1
vote
1 answer

You were not connected because a duplicate name exists on the network.

I am getting this error daily on my web server that is trying to connect SQL Server. "A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that…
Siddharth Rathore
  • 11
  • 3
1
vote
1 answer

SQL Server - Connect via SSMS works fine, but ODBC fails

I have a SQL 2016 Express instance, and I can connect to this fine using sqlsrv_connect() from within PHP. However, when I try to create a ODBC connection it fails. I get the error message "SQL Server does not exist or access denied". I have…
Phil
  • 203
  • 1
  • 2
  • 9
1
vote
1 answer

Error accessing database after migration

We've an old application made on Classic asp and we're migrating this to a new server. until here everything works fine, our problem is when the application needs to access the database, we get the following error: "An error occurred on the server…
Bruno Fontainha
  • 11
  • 2
1
vote
0 answers

SQL 2016 clustering, creating and failover

I'm a application manager, and I had my application wizard create a SQL database on the clustername, not on one of the two nodes of the cluster, but on the clustername. Now a week later, my application stopped working. After some research I found…
Dennis
  • 677
  • 1
  • 9
  • 23
1
vote
1 answer

MSSQL proxy system permissions required to run PowerShell steps

I started to ask this on StackExchange DBA but decided it was probably going to be more of a Windows Server security type of question. SQL Server 2016 SP1+CU on Server 2012 R2. I'm trying to run a PowerShell step in a SQL Agent job using a proxy…
Drew Lanclos
  • 188
  • 1
  • 11
1
vote
0 answers

Update SQL installs remotely

I have sys admin, local admin and remote desktop access on a bunch of Windows Server 2012 R2 VM's with SQL Server 2016 installed. Is there a way to install an update on all of them from a single server? Basically in a scripted manner,without…
Akash
  • 111
  • 2
1
vote
1 answer

SQL Server backup overwrite increases in size

I have a small database, that backs up to around 3.5mb. If I overwrite the backup Tasks -> Backup -> Type: Full -> Backup to disk it increases in size each time around 3.5mb. If I delete the existing backup, then follow the above process it's back…
Tom Gullen
  • 385
  • 4
  • 8
  • 24
1
vote
0 answers

SQL Server 2016 Always Encrypted and AlwaysOn readable secondary connection error

I've used Always Encrypted in SQL 2016 to encrypt the data in a few columns of a table in my application. Always encrypted appears to be set up correctly, because I can see the encrypted data in SSMS and the decrypted data in my application. My…
NorthFork
  • 151
  • 6
1
vote
1 answer

SQL Server 2016 - Server crash

I did a fresh installation of a SQL Server Standard 2016 on Microsoft Windows Server 2016. During the installation and manually starting the database engine service i get the following error: Windows could not start the SQL Server (MSSQLSERVER)…
eKKiM
  • 1,540
  • 9
  • 23
1
2
3 4 5