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
0answers
10 views

SQL Server Job Database name

First time post, long time lurker. I am trying to find and write a query for what database is affected by a SQL Server job. I have checked the following: Get a list of SQL Server Agent Jobs and ...
0
votes
0answers
8 views

How to upgrade an RDS SQL Server Instance to an SSD

I'm trying to upgrade my RDS SQL Server 2012 instance from magnetic storage to an SSD. It is an instance class of db.m1.large with bring your own license. I've tried modifying the storage type, but ...
-1
votes
0answers
11 views

Login failed due to untrusted domain

Restored logins from one server to another and well as restored msdb. Removed domain logins and readded them and still unable to login with windows authentication. The login is from an untrusted ...
0
votes
0answers
6 views

FIPS 140-2 on Windows 2012R2 with SQL 2014

I'm attempting to set my Microsoft SQL 2014 instance to use FIPS 140-2 complaint encryption as described in this KB article for SQL 2012, but it does not appear to be working. I do not see "FIPS" ...
1
vote
1answer
38 views

Will a SQL incremental backup work for my purposes?

We are transitioning a large amount of data, in the form of a SQL database, from one location to another and the data transfer speeds are very slow but we want to cause as short of an interruption of ...
0
votes
0answers
5 views

Configure Microsoft Sql Server Reporting services to redirect to ssl

I'm setting up an SSRS 2014 install, and I would like to make everything SSL by default. Getting SSL running isn't too hard, but for some reason there seems to be no easy way to redirect the http ...
1
vote
0answers
9 views

Should I back up full-text catalogs?

I am developing a small app for SQL Server database backup (version > 2005). I intend to use VSS snapshots (component based) to back it up and supported modes are Full & differential. Is it ...
3
votes
0answers
23 views

Update SQL Service Pack Named Instance

I have an existing SQL 2008 R2 on SP3. Have another instance in use that is SQL 2008 R2 SP1 I need to update the named instance with sp1 to sp3 but i'm not getting any options. It tells me my version ...
-1
votes
0answers
7 views

Convert/Insert all files in a directory [closed]

My task is to convert jpeg's to binary and then insert them into a table called "images". I need to convert/insert all jpeg files in a directory. I'm able to accomplish the task if the files are ...
1
vote
1answer
26 views

How do I use a domain account to connect to a MSSQL server for NPS accounting?

I'm trying to connect a Server 2008 R2 NPS to a MSSQL server for logging accounting data and I'm running into issues. I configured NPS Accounting through the "Configure Accounting" wizard and, using ...
0
votes
1answer
23 views

Unable to connect to SQL Server on live server

I have a copy of my client's database and website on my computer. There's also a matching copy of both online where my client's customers will use the website. When I test my local copy of the ...
1
vote
1answer
13 views

Error when using sp_addscriptexec

I have tried to run the following command on my server that is using sql 2008 merge replication sp_addscriptexec MyPub, '\\my-server\MSSQL\updateTablePermissions.sql', 1 and I get the following ...
-3
votes
0answers
25 views

sql database recovery from .bkf file [closed]

Few days ago I lost some part of .bkf file where is stored sql database due to accidental deletion. I backed it up, so I tried to restore the database from the .bkf file. The problem is next, when I ...
0
votes
1answer
18 views

How to backup Microsoft SQL Server 2014 to our SAN and Off Site [closed]

We are running Microsoft SQL Server 2014 in a mirrored setup with a witness. The server has two database s which in total are about 200 GB, on the servers we have a 500GB data drive (D) and then a ...
1
vote
2answers
36 views

SQL Server file size

There is something I don't understand with the MSSQLServer mdf files. I have been asked to replace a file with its previous version (the database has been modified between the two versions), but when ...
0
votes
0answers
42 views

SQL server session tasks all waiting

I have a query that often completes in a fraction of a second (~200ms). Sometimes it takes 10-13 seconds to complete. Doing SET STATISTICS TIME ON it shows: SQL Server Execution Times: CPU time = ...
0
votes
1answer
7 views

Will SQL Alias compromise existing connections to [cluster name]/[database name]?

On a migration project we plan to use SQL Alias, since we learned it should be easier to use when moving databases between servers. The plan forward is to continue to move around databases to other ...
0
votes
0answers
17 views

Windows Server Failover Cluster (WSFC) - Customize Failover Policy

On a Windows Server 2012 Windows Server Failover Cluster (WSFC) supporting a SQL 2012 AlwaysOn Failover Cluster Instance (2-node) setup - I am wondering about the following: Is there a way to trigger ...
1
vote
1answer
45 views

MS SQL Server 2014 is not able to connect to Coldfusion 11

I have Coldfusion 11 installed on my Laptop (Windows 8.1 Pro) and MS SQL Server 2014 but unable to get them talking to one another. Here are the three screenshots for your reference, please let me ...
1
vote
1answer
42 views

Is it possible to use the SQL Profiler on SQL Server 2014 Web or Express edition?

I'm a bit confused as to whether or not it is possible to use the SQL Profiler on the Web/Express edition of SQL Server. From what I've read so far people generally say "No - it was removed in SQL ...
0
votes
0answers
30 views

Is it possible to create my own custom SQL 'trigger' with Powershell?

I'm familiar with MSSQL triggers already, however they aren't fine grained enough for what I want to do. In my scenario I want the trigger to fire after a row containing certain information lands in ...
0
votes
0answers
24 views

SSPI trying to authenticate local user against domain

Our domain controller's event log is being flooded with EventID 4625 errors, "An account failed to log on." Here are some of the details from the event: Logon Type: 3 (Network) Account For Which ...
1
vote
1answer
50 views

Why is sqlservr.exe Running?

sqlserver.exe is running according to ProcessExplorer. When I kill it, it comes back later. Why? I have disabled the service in Services, and it doesn't show as "Started" even though it is clearly ...
0
votes
0answers
13 views

Reporting Services 2014 security configuration

I have some reports in SSRS 2014 that I would like to be available on demand as well as on subscription. Making them available on demand is easy to secure - just set the data source to Windows ...
0
votes
0answers
34 views

Route sql server traffic through firewall

We currently host our web application on multiple servers using Rackspace Auto Scale. This causes our outbound IP addresses to regularly change. At the same time we need to connect to an external sql ...
1
vote
1answer
40 views

Backup and Restore all databases and users SQL Server

Is there a way to backup and restore an entire SQL Server in one command (Databases, Data and Users)? I've successfully achieved this with out MySql server but can only find examples of single ...
0
votes
1answer
32 views

Un-cluster storage added to Windows Failover Cluster Manager

Forgive me if I'm mixing up terminology, I'm a DBA and trying to see if I can un-do my error here. Background: I was adding a 3rd DR site node to a Windows Server Failover Cluster to utilize AlwaysOn ...
0
votes
1answer
22 views

SQLEXPRESS User password from hardcoded application

I am setting up a new computer with an application which has a hardcoded password for the SQL database. I am not getting any help from the apllication provider because they want to do it themselves to ...
1
vote
2answers
71 views

open firewall ports on mssql for SCOM

Im trying to figure out, which ports i have to open on my MSSQL-Server to let the SCOM (System center operations manager) connect successfully. Ive tried: disable the domain network firewall -> SCOM ...
1
vote
1answer
54 views

Can't Install freetds php-mssql on Centos7

I am at my wits end... Newbie to Linux... please help me... Goal is to connect to MS SQL Server 2005 using PHP. I have installed PHP and ODBC. I am running CentOS7. PHP Version => 5.4.16 .... ...
0
votes
1answer
29 views

Which full backup will my diff backup be connected to?

I am trying to understand exactly how backups work for SQL Server. The hosting provider have a scheduled FULL backup every night. There are also a number of DIFF backups taken during the day. We ...
0
votes
1answer
47 views

TCP packet loss against SQL-server

Where I work, we have had some issues with connections to the database. We get a lot of failures which appear as "recv failed" on the client side. I have used Wireshark to try to debug the problem and ...
1
vote
0answers
29 views

SSL certificate for sql-server on ec2

I have an ec2 node provisioned to host mssql server. I'm trying to request and install an ssl certificate for this node so I can securely connect to it but I can't get the certificate to appear in the ...
0
votes
2answers
61 views

Why isn't sql server using all of the available memory

I Have SQL server 2012 standard 64bit with 64GB RAM and 40 CPU cores. In the server properties, I can see that all the RAM is listed in the memory field on the general tab. Underneath the Memory tab, ...
0
votes
1answer
42 views

Is there a way to kill a range of session ids (connections) in ms sql server?

i was wondering if there is a way to kill a range of SQL Connections on an Microsoft SQL DB. If i want to kill a single session id i can use kill [session-id]; go;. If i want to kill all sessions i ...
0
votes
2answers
29 views

Build a IIS and SQL Server replicated cluster [closed]

I have four Microsoft Windows Server 2012 R2 Standard virtual machines on three physical nodes. Two will be dedicated for IIS, and two for SQL Server 2014 Standard. I have to replicate them (IIS1 to ...
0
votes
1answer
30 views

interpret unknown piece of powershell related to SQL Server

I am migrating from SQL 2008 on Win2003 to SQL 2014 on Win2012. One of the jobs from the old system has this step: if ('$(ESCAPE_SQUOTE(INST))' -eq 'MSSQLSERVER') {$a = '\DEFAULT'} ELSE {$a = ''}; ...
-1
votes
1answer
133 views

Restore SQL Database From BAK File using a SQL Query

I have my database backing up to the hard disk in the format of BAK file. I am trying to restore that backup, but I unable to do so. Here is my query: ALTER DATABASE DBASE SET SINGLE_USER WITH ...
0
votes
0answers
30 views

SQL Server service dependency not working

I have an service that tries to connect to a MSSQL DB on startup, but when I start the computer it throws an error becouse it's not able to connect to the DB. This happens becouse the specific DB was ...
1
vote
1answer
98 views

Activity Monitor not showing stored procedures?

This is SQL Server 2008 R2 running in Hyper-V virtual machine with 4 virtual cores. Task Manager is reporting sqlservr.exe to use at least 50% CPU, sometimes 100% for minutes. I/O is very low. The ...
0
votes
1answer
33 views

Can a database created in MS SQL Server Express be exported to MS SQL standard?

As the title states, can a databse created in MS SQL Server Express be exported to MS SQL standard? For the inent of the question, the version in question is 2008.
0
votes
0answers
46 views

How to execute unicode .sql file on azure sql via sqlcmd?

I have an Azure blog created via "Brandoo WordPress" template (wordpress website and azure sql server). All works fine, but if I populate wordpress tables from .sql file with unicode characters via ...
26
votes
5answers
3k views

How can I prevent accidentally jacking with a production database?

Just recently, I had a developer accidentally try to restore a database to production, when he should have been restoring to a staging copy. It's easy to do, given that the db names are similar, i.e., ...
0
votes
2answers
47 views

What is optimal sql server cluster storage solution?

I have been assigned a project where sql server is running on a single server with single raid 1 volume. This setup has worked fine until hardware failure resulted in about a day worth of downtime ...
-4
votes
2answers
42 views

websitepanel - Is web site panel support sql server 2014 in its services? [closed]

I have server that website panel installed on it for web hosting, my question is that Is web site panel support sql server 2014 in its services?
0
votes
1answer
59 views

SQL 2008 R2 automated install w/ configuration file - The credentials you provided for the SQL Server Agent service are invalid

I am doing an automated installation of SQL Server 2008 R2. I have a new VMware guest with Windows 2008 R2 and ran the SQL Server 2008 R2 setup to create a configuration file. I am only installing the ...
7
votes
2answers
650 views

Should I encrypt OS disk with BitLocker for HIPAA compliance

I am looking into hosting a HIPAA compliant web application on Azure VM's. For the database, right now I am leaning towards using a VM with SQL 2014 Standard Edition. Since TDE is not available with ...
3
votes
1answer
40 views

Architecting for Load Testing

I'm trying to architect a set of web and database servers so that we can load test them. I'm running into some problems given the constraints I have to work with: We can't load test against ...
0
votes
1answer
46 views

How to upgrade a MSSQL Server?

As we were updating a service on an older enviroment, we experienced compartibility issues because the service we were updating is working with MSSQL Server 2008+ only. Now we have the issue that we ...
2
votes
1answer
101 views

Azure IO performance sql server [duplicate]

We are in the process of migrating our on-premises sql server to Azure and I am having trouble with the IO performance. I have created a new D14 instance and attached 16 virtual disks at 100GB in ...