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
17 views

Assigning a subnet to a sqladmin instance with jinja

I have deployed a Google Cloud sqladmin instance (sqladmin.v1beta4.instance) and database (sqladmin.v1beta4.database), but I now want to assign it to my private subnet. I have done this successfully ...
0
votes
0answers
58 views

What may increase the latency 3-4 times for SQL FCI the database?

We have SQL Server Basic Availability Groups (BAG) configured to run an SQL database running over local Intel SSD drive. I was asked to move a database to SQL Server Failover Cluster Instance (FCI) to ...
-3
votes
2answers
33 views

SQLServer 2008 R2 (also SP1/SP2) on Windows 10 within Virtualbox does not start [on hold]

The results of an epic afternoon... Installed SQLServer 2008 on Windows 10 within Virtual box. Service won't start. Installed SP1. Service won't start. Installed SP2. Service won't start. the ...
-2
votes
0answers
14 views

How to connect Azure Data Catalog to SQL Server source? [on hold]

I am looking for Azure Data Catalog connect to SQL Server source. Can anyone refer a good article on the same to proceed? Many Thanks!
0
votes
0answers
7 views

Selecting 1 of many transactions from a given transaction id [migrated]

I have the following query, selected for a single transaction id, to sum up the total of cost of sales from our accounting system. This query will need to sum up costs across all tranid's but I'm just ...
0
votes
1answer
32 views

MS SQL Server provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) (Microsoft SQL Server, Error: 5)

I have a server that is running a MS SQL Server 2016 database. I have two other servers: Server A and Server B. I can connect to the database using SSMS on Server A but I can't connect to the database ...
1
vote
1answer
6 views

Is SQL Server capable of sending certificate chain to the client?

I wonder if SQL Server is capable of sending certificate chain to the client, I tried every option while creating certificates and I am aware of what restrictions SQL Server puts on a certificate to ...
0
votes
0answers
19 views

Run SQL Server Standard 2017 Edition Together with SSRS 2017 Developer Edition

Has anybody ever tried running SQL Server 2017 Standard with SSRS Developer Edition and had it worked successfully? I'm setting up a client environment in Azure. This will be there production ...
0
votes
0answers
17 views

SQL Server service: the service did not start due to a logon failure (Error 1069)

I am administering a database server running SQL Server 2016. The MSSQLSERVER service has been running under a domain account (with a password that does not expire) for a long time now with no ...
0
votes
0answers
41 views

Use SSH Tunnel with MSSQL

An owner of a MS SQL db has allowed access to their db from an IP address of a remote machine I own. I can SSH into that machine and connect to the DB using: ssh -i my.pem 100.0.0.100 sqlcmd -...
0
votes
0answers
20 views

Google Cloud SQL update broke itself on Table Views?

There was an update (initiated by Google) on Oct 17, 2018 on our cloud SQL Server. I think it broke itself and it particularly removed some of the important table views. made the exporting job based ...
0
votes
0answers
30 views

Configure SSRS remotely - A connection to the computer cannot be established

I just installed the newest SQL Server Reporting Services 2017 using this instructions: https://docs.microsoft.com/en-us/sql/reporting-services/install-windows/install-reporting-services?view=sql-...
0
votes
0answers
7 views

What are the project settings in SSRS deployment and what do they mean and refer to?

What are the project settings in SSRS deployment and what do they mean and refer to? I have successfully created my first SSRS project in Visual Studio. The deployment process requires setting up the ...
0
votes
0answers
6 views

Why is this SQL update query returning rows? [migrated]

I'm running the following update command UPDATE table SET [End] = '2018-12-17' WHERE (ID = '5b010204-c12c-4b38-8d28-affe11684da0') This will give the following result: What can cause this on SQL ...
0
votes
0answers
100 views

Identity value incorrect after migration to Azure SQL

I used the new MS Data Migration Assistant (v4.1 link) to migrate a database from a SQL 2008 R2 server to an Azure SQL database. The process worked well and the data migration worked great! However, ...
1
vote
0answers
90 views

Importing data from Informix DB to SQL Server

Configured Informix drivers (32-bit) ODBC on my local machine and trying to import the data to SQL Server using SQL Server IMPORT and export wizard. I selected source tables and views(steps in SQL ...
0
votes
0answers
21 views

SQL Server Express limited by instance or by installation?

I've got one installation of SQL Server Enterprise and a couple of satellite installations of SQL Server Express. I can't justify additional installations of SQL Server itself for these satellites. ...
0
votes
0answers
11 views

Excel Power Query (aka Get and Transform) from SSAS 10x slower after version change

I have been using Excel Data Get and Transform (i.e. Power Query) for some time to query data from our data warehouse Excel BI server using the SSAS wizard. A number of such queries that pulled more ...
0
votes
0answers
27 views

Can you upgrade an AWS RDS sql server license to enterprise version after it's been running?

My company is trying to decide on whether to to buy a standard or enterprise license of Microsoft SQL Server on AWS. We will probably outgrow a standard license in 4-5 years, so we know we are going ...
0
votes
1answer
37 views

Is it possible for a group policy to interfere with a Sql Server Express installation?

We have a software package that our customers install on their user's laptops. Part of the installer runs MS's Sql Server Express 2014. We're passing the command-line options to to the installer ...
1
vote
0answers
16 views

Is there a way to have password-less SQL server login for another user without kerberos enabled?

I am connecting to SQL server with JDBC. I am able to use Integrated authentication with JDBC to connect to a SQL Server 2016 instance as the current logged in user, and I did not have to supply a ...
1
vote
0answers
60 views

Cannot Connect to Azure Database from Azure Web Application

We have a SQL Server database in Azure. In the same resource group is an App Service. The App service connects to the database, using the connection string: Server=tcp:[server].database.windows.net,...
0
votes
0answers
17 views

Creating an ODBC connection only master is available in the change database drop-down

I'm creating an ODBC connection to a SQL Server database on Azure an only master is available in the 'change the default database to' drop-down. If I put the name of the database name in manually and ...
1
vote
0answers
47 views

Server response time

Someone should please come to my aid before this thing makes me do the unthinkable. How can I have a 16GB RAM, 6cores digital ocean droplet. Running on Wordpress with 34 plugins. Linked to Cloudflare ...
-1
votes
1answer
178 views

How to create a SQL Server Database from DBML [closed]

I have corrupted an entire database and I have no access to it or backups. Is there a way to recreate the structure of it using a .dbml from visual studio project? Thank you in advance.
0
votes
1answer
67 views

Failover Cluster validation test failed

Greetings fellow admins, I'm trying to set up a SQL server failover cluster with 2 Windows Server 2016 servers on a VMware vSphere host. When validating the Cluster I got the following error: List ...
1
vote
2answers
94 views

MS SQL Server: where is my user account?

I have access to any database on this server using my ID and password. Here's my connection string: Data Source=my.database; Initial Catalog=main_table; User ID=my_user_id; Password=my_password; ...
0
votes
0answers
29 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
73 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
81 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
1answer
27 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
48 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
68 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
38 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
80 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
11 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
30 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
40 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
99 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
177 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
59 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
27 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
0answers
45 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
41 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
22 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
49 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
43 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. ...