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)

4
votes
1answer
28 views

DL380 G9 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 G9 8SFF which has 2 sockets, and 12 ...
0
votes
0answers
18 views

Calculate datediff between events on different rows

I have the following table selected and want to be able to calculate the DATEDIFFbetween events within the same job. Note: OperationID=event, ServiceReqID=Job OperationID is from ...
0
votes
1answer
26 views

Installing SQL Server 2014 Enterprise on a Domain Controller Windows 2012 R2 [on hold]

All I found in the internet was: Do NOT install a SQL Server on a domain controller and that it is not supported. Why: I hate it, when I re-install my domain controller and WSUS Server and lose all ...
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
34 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 ...
1
vote
0answers
7 views

BizTalk Server 2009 - Not being able to contact SQL BizTalkMsgBoxDb?

We have a BizTalk server 2009 setup running on windows server 2003, The root problem is that BizTalk cannot contact its BizTalkMsgBoxDb to execute one of its heartbeat stored proc's. Basically any ...
0
votes
1answer
47 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
44 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
12 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 ...
0
votes
0answers
6 views

Alias of COUNT is not being “recognized” by SQL Server [migrated]

I have restored the Northwind database(https://northwinddatabase.codeplex.com/) from a backup file using SQL Server. Trying to execute the following query results in error "Invalid column name ...
2
votes
1answer
22 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
17 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
19 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
9 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
3answers
62 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
17 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 ...
0
votes
1answer
20 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
43 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
26 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
2answers
180 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
28 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
30 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
52 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
14 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
10 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
11 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
22 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
144 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
39 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
69 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
10 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
38 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
37 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
86 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): ...
1
vote
0answers
219 views

Connecting to MS SQL Server using FreeTDS: Error 20002: “Adaptive Server connection failed”

I am trying to use FreeTDS to connect from a Linux server (RHEL v7) to a separate server running MS SQL Server 2014. However, when attempting to connect with tsql I get the following errors (error ...
2
votes
3answers
46 views

Regular backup and archival options for a client device that runs MS SQL Express including restores

In the current environment, a client application has been deployed on a single endpoint device e.g. laptop. The client application records & retrieves information that is needed for regulatory and ...
1
vote
2answers
43 views

How to connect to sql server to take backup of a database from powershell

I am new to powershell. I got requirement to take the backup of MS sql database backup from the other machine and not within the server. Can you please let me know what possible utilities required to ...
1
vote
2answers
459 views

SQL Server express - Management studio installation hangs at native images installation

I've been trying to install SQL server express edition (2014) with management studio and consistently failing to do so because installation stalls at step 'Install_sql_common_core_Cpu64_Action : ...
1
vote
2answers
47 views

Google Cloud with SQL Server Express - add database permissions

I've recently setup a google cloud server for the first time and I installed the asp.net framework which is marketed as "Windows dev stack featuring IIS, SQL Express and ASP.NET". I'm familiar with ...
3
votes
1answer
59 views

How to find out who / what is hammering SQL Server TempDB

I am using SQL Server 2012 Enterprise. The server has one availability group configured. There are several databases for different tools on the instance. The tools all belong together and therefore ...
0
votes
1answer
85 views

Cannot execute job in MSSQL Agent

Executed as user: NT SERVICE\SQLSERVERAGENT. Cannot initialize the data source object of OLE DB provider "Microsoft.ACE.OLEDB.12.0" for linked server "(null)". [SQLSTATE 42000] (Error 7303) OLE DB ...
0
votes
0answers
10 views

MySQL 5.5 performance settings [duplicate]

We are using server this theses parameters: 8 cores CPU 18GB RAM MySQL version 5.5 We would like to get the best performance. The DB is InnoDB type. I would like to know your experience and maybe you ...
0
votes
1answer
100 views

sqlsrv not showing up in phpinfo.

I'm using Win server 2k12, php 5.5.12, on wamp. Edited php.ini (both on apache dir and php dir) to add php_sqlsrv_55_ts.dll and the php_pdo_sqlsrv_55_ts.dll, and configured the extension dir path ...
1
vote
1answer
35 views

Failing over to mirror instance when not using a witness server

I have a set up where I have two SQL servers set up for failover mirroring to two other SQL servers. I am not using a witness server. I had previously used a witness server and that of course would ...
0
votes
1answer
26 views

Web application access permission

I have a web application that uses SQL server . SQL server is hosted on a server and accessed using port 1433 . My question is will the user who is accessing my application required to be able to ...
-1
votes
1answer
59 views

CentOS7 mysqlserver download error

[root@localhost bin]# rpm -qa httpd httpd-2.4.6-31.el7.centos.x86_64 [root@localhost bin]# rpm -qa php php-5.4.16-36.el7_1.x86_64 [root@localhost bin]# rpm -qa mysql [root@localhost bin]# I am a ...
1
vote
0answers
10 views

SQL Server Table Partitioning & Impact of Raid Levels

How does SQL Server Table partitioning get impacted by the DISK RAID level ? We have a SQL Server with 8 data disks . The main table in the database has over 200 million rows partitioned by day of ...