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.

learn more… | top users | synonyms (3)

0
votes
1answer
19 views

Can't connect to SQL Server machine from another server any more

My sql server is on a machine 198.135.X.XX1 My dev server is on a machine 198.135.X.XX2 I used to be able to connect from my dev server to my sql server machines, but not any more. I am still able ...
0
votes
1answer
27 views

from security perspective one instance with Multiple Databases or multiple instance for multiple clients

We have 20 clients which currently every client has his own database on his own server(in his own environment) all the databases have the same structure(schema) and all of them has MS Sql Server 2008 ...
1
vote
2answers
16 views

SQL Server domain-group based login

I have a couple clustered SQL server instances, 2 on 2014 and 1 on 2008r2. In all 3 cases, I've created a SQL login (server principal) for a domain group, say DOMAIN\SqlAdmins. I grant it the ...
0
votes
0answers
6 views

Unable to access Reporting Services using Administrator account Windows 2012R2 / SQL Server 2012

We have a standalone Windows 2012 R2 server with SQL Server 2012 installed. The Windows 2012 server has an Administrator account only in the group "Administrators". This Administrator account is ...
0
votes
1answer
15 views

SQL Server Management Studio always encrypt connections

In the connections dialog of Management Studio there is an option to encrypt the connection so that you can force the connection to the remote server to be encrypted. Is there a way that I can make ...
1
vote
0answers
31 views

Connecting SSIS to AWS RDS SQL Server Instance

I am trying to connect SSIS to an AWS RDS SQL Server instance. Whenever I try to run the packages through the SQL Server Agent, I encounter this error message: Non-SysAdmins have been denied ...
0
votes
1answer
28 views

Setting up End-User Connection to ODBC Data Source

I need to connect my MS Access (front-end) database to SQL Server 2008 (back-end), using my ODBC connection, for all of my team to view the data in the MS Access reports, forms, etc. My MS Access ...
0
votes
1answer
20 views

MS SQL replication run only with system account

I'm trying to configure a new replication with SQL Server 2012 I configured the distribution While configuring the publication, it asked for a user to run the snapshot agent. I set a strong user ...
1
vote
1answer
38 views

SQL Server Full BackUP functionality

In SQL Server 2008 R2 (or Any other Version); Transaction-1 had started at 11:50:00 and it takes 1hr.5min to complete(i.e., completed at 12:55:00) and Transaction-2 had started at 17:45:00 and it ...
0
votes
0answers
26 views

Block Windows Service Access to Remote SQL Server with Firewall

So I've got a fun firewall question. We have a windows service that we have running on a Windows Server 2012 instance. It is connecting to a remote SQL Server that we do not own, among other things. ...
0
votes
1answer
12 views

SQL Server data and log file location on single physical drive

I have just got my hands on a dedicated hosted Windows Server 2012 R2 which has had SQL Server 2014 installed. The server has a single 2Tb drive (C:) which I assume is a standard hard-drive, rather ...
3
votes
1answer
117 views

RDS 2012R2: RD Connection Broker HA - cannot connect to SQL

I have a brand new RDS environment I am trying to set up. I'm trying to follow this guide: https://msfreaks.wordpress.com/2013/12/09/windows-2012-r2-remote-desktop-services-part-1/ and have gotten ...
0
votes
1answer
47 views

Install WSUS with remote SQL on port different to default

How do I specify the connection parameter to a remote MSSQL Server during WSUS setup that's default instance is not running on the default port?
-2
votes
1answer
49 views

SQL Server Backup Procedure and different types of backup [closed]

Need to know perfect solution on how to backup SQL server Database Version SQL server 2008 R2.
0
votes
1answer
60 views

SQL Server 2014 “Relocate all files to folder” option

In SQL Server while restoring database .bak file are are two option "Relocate all files to folder" and "Restore As". I can change the location of database using "Restore As" option, what is the ...
1
vote
1answer
119 views

Configured Azure Backup sends me a health check report every 15 minutes

I configured my SQL Server 2014 database to back up to an Azure storage account. I also enabled email notifications via EXEC msdb.smart_admin.sp_set_parameter @parameter_name = ...
6
votes
1answer
130 views

DL380 Gen9 which processor and what impact on NUMA

We are about to build a new server and I was wondering what would the impact on NUMA with the options available. The system will be built using a Proliant DL380 Gen9 8SFF which has 2 sockets, and 12 ...
0
votes
0answers
6 views

error configuration HTTP connect to analysis services

I want to connect to cube using HTTP/ internet outside. I already set up : copy Folder OLAP in inetpub/wwwroot Added Aplication pool in IIS Added website with application pool i just created enable ...
0
votes
1answer
55 views

multi instance failover clustering (sql server)

just want to straighten my concept properly - when we are talking about SQL multi instance failover cluster, e.g. on a 2 node cluster, it means that each node can run its own sql instance, but each ...
0
votes
1answer
69 views

How to fix a slow connection between web to sql

I use Microsoft SQL Server, my web server is IIS When the database server was on the same network as the web server, it worked very good. Now that the web server is in one network in one city and ...
0
votes
2answers
71 views

Unable to start SQL server agent automatically

I am working on SQL 2012, I already been set up my SQL server agent in automatic start up mode in windows services as well in SQL config. Even though it was not starting automatically. How can I fix ...
0
votes
0answers
15 views

Is there Equivilent of SQL Server 2012 Distributed Replay for SQL Azure?

I have a client that wants to replay their daily work load in a SQL Azure environment to test it's performance against their current environment. Does anyone know a product or process I could use to ...
2
votes
1answer
30 views

OK to disable TLS1.0 with IIS and SQL Server 2014?

(This identical question in dba is drawing a blank) Background We need PCI-DSS compliance, and so must disable TLS1.0. In my test environment we have SQL Server 2014 SP1 with CU 1 (as per this post) ...
0
votes
1answer
47 views

Best Way to Restart 2 Node SQL Cluster To Perform Windows Updates?

So I have a 2 node MS SQL Server cluster, using AlwaysOn, on Windows 2012 r2. SQL1 is the primary. SQL2 is the secondary. I want to restart both servers today to perform windows updates which will ...
-1
votes
1answer
22 views

SQL Server Failover Clustering (4 nodes)

I think I was able to convince my cow-erkers that jamming all the databases on one server is a good idea. So, our setup will be something like this: Production - SQL 2014 Enterprise Standby - SQL ...
0
votes
0answers
22 views

Establishing performance baseline with SCOM 2012 APM

We're lookign at establishing a performance baseline for our production environment. This could be as simple as establishing highest measured TPS for MS SQL environment and highest measured RPS for ...
1
vote
2answers
85 views

What is the risk of a SQL Server backup strategy that is only weekly full backups and daily transaction log backups?

I'm trying to convince a client that their SQL Server backup strategy is insufficient. Long story short is that their current backup "strategy" is a weekly full backup followed by daily transaction ...
0
votes
1answer
19 views

SQL Server: One Production server be Failover for other

I'm surely using the wrong terminology, but I have the following: SQL Server A (SAN1) - DB1, DB2, DB3 SQL Server B (SAN2) - DB4, DB5, DB6 It's currently SQL 2008 and we're looking to move to SQL ...
-1
votes
1answer
42 views

Sync two Non-Enterprise SQL Servers [closed]

We have a SQL Server 2005 in one of our company's locations. Since DB calls from other locations are very slow, we would like to set up another SQL Server on the other location and keep the server ...
2
votes
1answer
27 views

Back up a database nightly

Question: Is it possible to automate the process of coping a full database every night into the development database on the same server? Software: Windows Server, SQL, SQL Server Management Studio, ...
0
votes
1answer
45 views

SQL Server login for other domain user with the same name

Due to some circumstances I had to dis-join from the domain Windows Server 2012 R2 based machine with SQL Server 2014 Business Intelligence Edition installed . Let's call it 'mydomain.local'. Then I ...
0
votes
2answers
201 views

SQL Server in “Recovery Pending” status after reboot

We have quite a few programs of our own design which communicate to our SQL Server (SQL Server 2014 Express). Every now and then they start blowing up all over the place; we run around trying to ...
1
vote
2answers
55 views

TFS DB and Recovery Model. Is Simple Safe

On my TFS database server all the databases are set to Full Recovery Model. We don't do any log shipping and just do full db backups each night so would there be any impact to TFS is we changed our ...
0
votes
3answers
504 views

An error occurred during the pre-login handshake. The local security authority cannot be contacted

I am having trouble to connect to SQL Server. The SQL Server, version Express 2008 R2, was running normally until one night that server needed to restart to make some system updates (The machine runs ...
0
votes
1answer
114 views

XA transaction timeouts with SQL Server, MSDTC, and WebSphere

I have a Java/WebSphere application that is doing XA transactions with a SQL Server 2008 instance. In some environments, everything works as expected. In two of our environments, transactions will ...
3
votes
1answer
38 views

Finding SQL Server Bottleneck - not CPU, IO, available memory

I'm trying to identify the bottleneck on a new SQL Server implementation (2012 Enterprise). I've been running some meaty queries/ETL jobs which are taking a considerable time - but I'm having ...
0
votes
0answers
98 views

Azure Web Site stopped working because of timeouts on SQL queries

My site is crashed unexpectedly after several months of smoothly work. I haven't done any site updates or re-configuration. But for last 14 hours I have the following situation: When site is up and ...
0
votes
1answer
26 views

SQL Server, local instance, No process is on the other end of the pipe

On a fresh installation, on my local SQL server instance, using SQL Server Management Studio, I can login with my Windows authentication, but not with my sa user. In both cases, I'm using (local) as ...
0
votes
0answers
14 views

SQL Equivalent to Mysqltuner

We are running SQL Server 2008 R2 which powers our order processing system. I am familiar with the linux products like mysqltuner. Is there one that would do the same for sql databases?
1
vote
0answers
14 views

Can connect to MSSQL 11 with SQL Auth, but can't connect with the same credentials to “import and export” wizard

I'm connecting to a MSSql 11.0.2100 server named "server" with a user named "user" via SQL auth. When I try the exact same credentials in the "import and export" wizard, the connection fails with: ...
0
votes
0answers
19 views

Unable to Change SQL Server 2012 Service Account When Using AlwaysOn Availability and TDE Encryption

I am unable to successfully change the service account in SQL Server 2012. Whenever I attempt to change the service account, the service starts up but the databases in the cluster are not ...
0
votes
1answer
31 views

SQL Server 2012 event ID 18487

Good morning guys. We have a SQL 2012 instance we use to store data on the parts we create. We have software that goes and pulls data out of the PLC on the machine and dumps the data into the SQL ...
2
votes
2answers
329 views

KVM top shows high CPU load on host for windows7 guest though windows is on idle

we have an virtualization environment with actually 4 VMs (2 x linux, 1 x w2k3, 1 x win7). In the host system (Debian Jessie) top always shows a CPU load of 30-70% (or more) for the qemu process of ...
0
votes
3answers
53 views

Moving SQL 2012 Enterprise license from physical server to Azure VM

We purchased a 4-core license for SQL 2012 Enterprise back in mid-2012, without Software Assurance. At this point we would like to move the license to a VM in Azure but I can't figure out if that's ...
0
votes
1answer
110 views

Windows server 2012: MSSQL missing .NET 3.5 Framework. Unable to install

The MSSQL installer does not go through - it's missing .NET 3.5 framework to complete. Unfortunately I've been unable to solve this, what I've tried: Manually download and transfer the /sxs ...
0
votes
0answers
14 views

How to deploy database and blob storage in sql express 2014

this is my first time deploying my application (ASP.net MVC 5) in local environment and I had a lot of problems doing so. My first problem is deploying the database, I used entity framework which ...
0
votes
1answer
49 views

What carries out SQL Server Mirroring?

I'd like to know what service(s)/process(s) carries out Mirroring in SQL Server. For example, we have various Agents carrying out the different steps for SQL Database Replication. Similarly, what is ...
0
votes
0answers
9 views

AWS which MS SQL server EC2 type should be used for MS Navision ERP backend database [duplicate]

I am trying to host Microsoft Navision ERP on AWS Cloud, currently it is on local data center. The licensing is based on number of cores with unlimited users. Which type of EC2 instance should be ...
1
vote
1answer
52 views

Using Perfmon to determine which service consuming all CPU

I have written a windows based webserver service which uses Sql Server Express as the back-end database. Every couple days CPU will spike to 100%. Inspection of my webserver logs reveal my service ...
1
vote
0answers
203 views

Cannot connect to sql server by IP Address but using the hostname works

After upgrading to the newest version of windows (windows 10 build 10586) I am no longer able to connect to a remote sql server by ip address. Here is the error I see: [SqlException (0x80131904): ...