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)

3
votes
1answer
35 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
98 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
32 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
98 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
21 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
44 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 ...
3
votes
1answer
31 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
56 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
546 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
97 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
620 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
165 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
41 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
135 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
80 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
16 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
22 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 synchronized....
0
votes
1answer
48 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
496 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
57 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
143 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 folder(...
0
votes
0answers
16 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
57 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
58 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
285 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): ...
2
votes
0answers
971 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
49 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
48 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
829 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
108 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
92 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
302 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
363 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
37 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
28 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
74 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
13 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 ...
0
votes
1answer
122 views

Restoring a differential database file “the backup set holds a backup of a database other than the existing”

I am trying to test restoring a SQL database using a full/differential approach to a different server than it was backed up from. The database is in simple recovery mode as it is a test data warehouse....
0
votes
1answer
229 views

“Unable to connect to data source” Debian unixODBC FreeTDS; PHP CLI works, apache/web doesn't

Envoironment: webserver: Debian8 with Apache, PHP, unixODBC, FreeTDS (current versions installed with apt-get last week) dataserver: Windows Server 2008 with MS SQL Server 2008 Opening this in ...
0
votes
1answer
62 views

Connecting with SQL Server Management Studio (Remote)

All right, here's my problem: I have set up a sql server 2014 on a windows server 2012 R2. If I'm connecting through the local network just with the ip, everything works fine. Now we need to access ...
0
votes
0answers
46 views

SQL Report Server Subscription PDF Corrupted

I have a SQL Report Server 2012 with subscriptions that emails PDF reports to external users. The report runs once a week, and is about 100 pages long. However, the PDF the users get in their emails ...
1
vote
0answers
61 views

Creating an assymmetric key inside SQL server to access a DLL fails

I need to access a DLL (C#) from SQL trigger for one of our requirements. I have compiled the DLL and could load it in SQL server space by using the "Create Assembly" and then create a trigger for it. ...
1
vote
1answer
23 views

Restrict login to SQL availability groups

Is it possible to restrict the databases available to a user based on an availability group in SQL ent 2012/2014. Want to have two databases where a domain user has access right on these databases. ...
1
vote
2answers
65 views

Separate TLS control for MSSQL & IIS

We have a system that needs to provide both database and web services. We want to lock down the TLS security settings to the highest degree possible. It's running MS SQL 2008 on Windows Server 2008 R2....
0
votes
1answer
35 views

What is Best Practice for migrating SQL 2012 system databases to failover cluster?

What is the best practice for copying system databases when migrating from SQL Server 2012 (no SP) to 2012 SP2 in a Failover Cluster? Just backup and restore? Or, script out and script in?
-2
votes
1answer
40 views

Share the database with another person in same network [closed]

I am a newbie to the database topic. I need to create a database and share the database to another person in my office so the other person can also create/delete tables in the same database. I created ...