Stack Exchange Network

Stack Exchange network consists of 174 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

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.

0
votes
0answers
21 views

SQL Server Dropped Index

I'm using SQL server 2014, and I have set up always-on availability group database. At some point the communication between a primary replica and a secondary replica lost connection. I couldn't fail ...
0
votes
0answers
12 views

Is Software Assurance required to install SQL Server 2017 on rented physical servers? [duplicate]

Edit : OK, got it, this is not a question for server fault. I've got to find some other source, since I cannot find this information right now on Microsoft's web site nor from the solution provider ...
-3
votes
1answer
24 views

Is there a SQL Server command for sizing the MDF and LDF files? [on hold]

I'm just doing some research and would like to know what are the different ways to preset the size of MDF and LDF files. Is this better done through the GUI or through T-SQL?
3
votes
1answer
50 views

Access Denied issue, SQL Server LocalDB on Windows Server 2008 R2 SP1

Running SQL Server LocalDB 2012 and 2014 on Windows Server 2008 R2 SP1 VM I have some bizarre issues which don't happen when running on Windows 7 or Windows 10. I can create databases, save data to ...
0
votes
1answer
32 views

Connect SQL Server Profiler 2017 to Azure SQL Server

The title is pretty explicit, how can I connect my profiler to Azure? So, I begin by opening the software, then a connect to my server: However, I am getting this: So I began to search what it ...
0
votes
0answers
6 views

Alter table and Create 40+ Column in existing table in single script [migrated]

On an existing table, I want to add 47 columns using alter table script select Distinct FieldName From customFields Above query will list 47 rows and these row names I need to create in another ...
0
votes
1answer
25 views

Not able to access SQL Server 2014

I am trying to access Microsoft SQL Server 2014 using "SQL Server Authentication". But even after entering the correct credentials, it says the following. C:\Users\morry>sqlcmd -S aana\sqlexpress -...
0
votes
0answers
47 views

SQL Server 2017, 2012 Express Edition Insert Select Performance Issue with very less data

Command 1: (Get Count from View1) Select Count(*) From View1 Results: ----------- 183 (1 row affected) Execution time = 11 seconds Command 2: (store the count in a table called Temp) Drop Table ...
0
votes
0answers
25 views

MSSQL - Failed to Start Engine

I restarted my Dedicated server for maintenance. Everything worked fine before I did the restart now I can't get MSSQL working. I'm using CentOS Linux 7 sudo systemctl status mysql-server mssql-...
0
votes
0answers
29 views

Where could a SQL Server shrink operation be hiding?

I've started using the Blitz scripts from BrentOzar.com to help me improve the SQL server instances that I manage. One of the message lines has me stumped. The message is to the effect of 'SQL ...
0
votes
1answer
30 views

Unknown MSSQL data spaces/storages

I was trying to create another table and specify a data space, when I couldn't avoid noticing these weird elements on the list: The thing is, I didn't create them. My storages are "PRIMARY" and "...
0
votes
0answers
21 views

Untrusted Domain connection error - Windows Authentication SQL Server 2017

I hope you can help with a mysterious Windows Authentication error. We have a new member of staff who can connect to our PROD SQL Server environment via SSMS without issue using Windows ...
1
vote
0answers
7 views

Team Foundation Server 2013 backup completes successfully but not saving any .BAK and .TRN files

I just encountered this issue with my production TFS server, which was backing up normally for the last few years. Backups have just stopped saving any other files except these 2. Also, there are no ...
0
votes
0answers
26 views

Intranet Apps require access to externally hosted database

I have about a hundred users behind a corporate firewall that use an app that connects to a database server to retrieve data. The server is moving and will be hosted externally soon; the corporate ...
1
vote
0answers
31 views

SQL Server 2016 Restore From URL

I'm having some trouble restoring databases in SQL Server Management Studio which have been backed up to Microsoft Azure. I have been able to create the maintenance plans which successfully create the ...
1
vote
2answers
47 views

windows server backup. how to restore msssql database

it's theoretical question. If i have a window server 2012 r2 which have mssql server installed. I add role windows server backup. So can restore the database which was backuped by windows server ...
0
votes
1answer
86 views

How to configure IIS 10 to read from local SQL database file?

I have been trying to deploy original ASP .NET Web Application using MVC template with authentication via a local SQL database file. So far, I am able to get it to work on my computer. When I publish ...
0
votes
1answer
27 views

Should SQL Server min and max memory settings be fixed to the same value

Hello, If the server has the resources to dedicate to the SQL server should you keep the min and max server memory settings fixed at the same value? Will setting the values the same produce any ...
0
votes
0answers
23 views

SQL Transactional Replication Overwriting Full-text Indexes

Very basic question: I am running SQL 2016 transactional replication to an Azure SQL db. It copies over everything but in doing so, it deletes the full-text indexes which then leads to more issues ...
0
votes
1answer
36 views

MSSQL: How to transfer database directly (looking for a counterpart to mysqldump | ssh mysql)

I have been very happy to have a command to directly copy a mysql database from one system to another without the need to create a backup file: ssh -C user@machine 'mysqldump sourceDb' | mysql ...
0
votes
0answers
33 views

How to set up a multi subnet sql always on availability groups in google compute VM's?

I have two sql nodes vm in two different subnets. I wanted to know how to set up network or NIC for virtual IP's. Apart for SQL node IP; two cluster IP addresses will be used from each subnets. One ...
0
votes
1answer
19 views

Unable to Connect to SQL Server - A Network-related or instance specific error

I get the following error each time I try to connect to SQL Server, as shown in the image: I have followed the instructions from the link https://stackoverflow.com/questions/18060667/why-am-i-getting-...
1
vote
1answer
48 views

No databases visible in SQL Server Management Studio

I'm trying to determine what databases are present on an SQL server. Can I assume that if I do not see any in management studio, then there are none? This article from Microsoft seems to suggest that ...
0
votes
0answers
34 views

Quickly converting hundreds of SQL Server .bak files to .csv files

I have several hundred SQL Server .bak files that I need to convert to CSV files (one per table in each .bak file). The "obvious" way to do this would be to restore each .bak file to a local SQL ...
0
votes
2answers
33 views

Best way to secure a SQL VM when clients do not have static IPs

I have a VM running SQL in the cloud. Typically I would set up inbound rules on the SQL ports in Azure and on the VM's firewall, but my clients do not have static IP addresses to use in the rules. ...
0
votes
0answers
30 views

Unable to connect to a new installation of sql server

I just installed SQL Server on my Windows Server 2012 R2 box. The installation went well but my apps can't connect to it. If I use the public DNS name for the server in the connection string, the ...
0
votes
0answers
17 views

Error in job agent when running a package in SSISDB catalog (SQL Server)

I created a simple package in visual studio. Then I deployed this package in SSISDB catalog which is on a different server. I am using Job agent to execute this package with a proxy account. But I am ...
4
votes
3answers
93 views

Azure high availability solution with synchronization of website and SQL server data

We have a web solution that we sell and it comes with 1 dedicated Azure VM containing everything it requires to run the application: ASP.NET web application Production environment QA environment SQL ...
0
votes
0answers
46 views

Kerberos Double Hop Delegation from IIS to SQL server (using django)

I need to pass the credentials (Integrated Windows Authentication) from a django website on IIS onto a backend SQL server so that it runs under the proper user context. This is how my setup looks so ...
0
votes
0answers
42 views

Failed connect from XP to SQLServer on Linux (use SQLOLEDB)

Attempting to connect to windows XP via SQLOLEDB to SQLServer on Linux will result in "SSL Security Error". Server CentOS Linux release 7.5.1804 (Core) 64bit SQLServer 2017 Standard on Linux (yum CU ...
0
votes
0answers
46 views

SQL server named instance connection

On several occasions I have observed a intermittent connection failure to SQL server (2012) resulting in the following stacktrace System.Data.SqlClient.SqlException (0x80131904): A network-related or ...
0
votes
0answers
33 views

Set static TCP port in SQL Server unattended installation

I have an unattended installation of SQL Server 2016 using the .INI answer file. In my answer file, I enable TCP like this: ; Specify 0 to disable or 1 to enable the TCP/IP protocol. TCPENABLED="1" ...
2
votes
1answer
192 views

IIS and SQL Server Windows authentication in a django application

I am trying to run a django website which connects to a SQL Server, using IIS with Windows authentication. IIS server and SQL server are on different machines under the same domain i.e., iis_machine....
1
vote
1answer
316 views

How can I get Microsoft Command Line Utilities 14 for SQL Server to install?

In order to run a third-party WSUS script (against the Windows Internal Database) I downloaded the x64 version of the Microsoft Command Line Utilities 14 for SQL Server, but when I attempt the ...
0
votes
0answers
23 views

Sharepoint 2016 Backup Database Permissions

We have a VMware Windows Server 2012R2 server VM running Sharepoint Server 2016. It connects to a separate dedicated SQL Server 2016 for all its DB needs. Whenever our Veeam Backup & Replication ...
0
votes
1answer
36 views

Azure SQL to On-Premise SQL Server Data Transfer

I need to securely transfer data from a SQL Server in Microsoft Azure to a SQL Server on-premises. I have been researching different methods but I have not found the right way. Following is the list ...
1
vote
0answers
15 views

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: ...
0
votes
0answers
23 views

Backup Scenario with CQRS (MSSQL)

I have a question regarding a backup scenario since we are going to move our software to CQRS and I am not sure how to make a consistent backup on the database side. We have a software that was in ...
0
votes
1answer
78 views

Where does DPM use space on a protected SQL Server?

I'm using Microsoft System Center Data Protection Manager 2016 to protect SQL Server 2017 on Windows Server 2016. I believe that whenever DPM does a backup (synchronization or express full) it will ...
0
votes
1answer
40 views

How to run SQL server 2012 instead of 2014 when both are installed and 2014 is currently running?

I need to backup a DB using SQL server 2012 to match another server it is going to. However on my local machine I'm currently running 2014. I can see that SQL server 2012 is installed along with ...
0
votes
1answer
58 views

So does MediaWiKi support MSSQL or not?

So I am trying to install MediaWiKi 1.31.0 on a machine running IIS 8 on server 2012 R2. We are running MSSQL server 2012. I followed the instructions on the media wiki page to install for MSSQL, but ...
1
vote
0answers
193 views

Importing BACPAC via SSMS to Azure SQL Server fails with AzureAD user

Recently, trying to import a BACPAC to an Azure SQL Server using SSMS (SQL Server Management Studio) has been failing with the following error: Failed to connect to server ___.database.windows.net. ...
0
votes
0answers
37 views

Sql server on ubuntu doesn't respnod

I have installed sql server 14.0.3030 express with .netcore 1.1 on ubuntu 16.04 and everything was fine till last night suddenly i encountered with this err message from my dot net core web app ...
0
votes
1answer
39 views

SQL Server Sort Order to Binary Search on SQL Server 2008 SP1

I am installing an OLT Software that requires Windows SQL Server 2008. I am getting this error below; The database sort order must be "binary sort". Please run the Transact-SQL command ...
1
vote
0answers
16 views

It is not possible to establish a connection with SQL Server 2008 R2

I'm having a little weird inconvenience. 9 months ago I have a Windows VPS with SQL Server database, which I was always using from a WebHosting that was connected remotely to my server. Yesterday ...
4
votes
0answers
777 views

Parallel Redo Is Shutdown

When looking in Windows event logs, i'm seeing the following messages on an almost continuous basis - Starting up database 'Database'. Parallel redo is started for database 'Database' with worker ...
0
votes
0answers
216 views

Linux : Undefined symbol: php_pdo_register_driver in Unknown on line 0

When i add the extenstion extension=pdo_sqlsrv.so in php.ini file in linux server with PHP v7.0 it's giving following error undefined symbol: php_pdo_register_driver in Unknown on line 0 Please ...
0
votes
2answers
155 views

Can't access remote SQL Server instance even if its firewall its disabled

I'm trying to remotely access to an old SQL Server 2005 instance in order to port some data over to another server, however I am unable to access to the database while using my database administrator ...
0
votes
0answers
134 views

Sql availability group listener not failing over

We have built two sql clusters with always on availability groups, based on the windows failover cluster service. This is done as per Microsoft documented process, however we are getting some ...
0
votes
0answers
52 views

SQL Server 2016 replication monitor from the slave ( subscriber ) without admin access to the publisher

Question: Is it possible to check the replication status of SQL Server 2016 from the slave ( subscriber ) without admin access to the publisher? We have an SQL Server 2016 which is a slave ( ...