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 (4)

0
votes
0answers
13 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 ...
0
votes
0answers
17 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
26 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
19 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
16 views

Build a IIS and SQL Server replicated cluster [on hold]

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
23 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 = ''}; ...
0
votes
1answer
42 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
23 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 ...
-2
votes
0answers
24 views

error connecting to a sql server database through a desktop application [closed]

I'm not a programmer or anything, I bought a software a couple of years ago and I formatted the computer, but when I called the software company that made the software for me, all their phone numbers ...
-1
votes
0answers
14 views

MS SQL Server service account Windows priveleges and rights [migrated]

I quite often have to setup MS SQL Server and wondered if anyone can provide advice on configuring the accounts the services should run as. IMO this has been vaguely documented by Microsoft, while ...
-1
votes
0answers
11 views

SQL ssis delete imported rows from source table [migrated]

I have setup a simple SSIS package that copies data from a source table to a destination table which works. I would like to get the package to also delete the data in the source table that has been ...
1
vote
1answer
46 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
28 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
20 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 ...
24
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
45 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
27 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
30 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 ...
0
votes
0answers
3 views

SQL Select top 1 record on dm_db_index_physical_stats with a join on sys.partitions very slow [migrated]

I'm running a small query below in a MS Dynamics AX 2012 database and it runs more than 5 minutes which I had to cancel and it is showing PAGEIOLATCH_SH wait type. The database data file is 560GB and ...
7
votes
2answers
433 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 ...
2
votes
1answer
33 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
45 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
76 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 ...
-1
votes
1answer
33 views

SQL Server Express 2005 cannot accept connection (but ODBC working from external and local server)

I'm having a problem with SQL Server Express 2005 edition; it's unable to be contacted from an application (3rd party monitoring utility software). I have perform the following tests, all of which ...
-2
votes
3answers
65 views

SSDs for MS SQL Server 2008: slc or mlc: what is expected life for mlc? [closed]

Until recently, Dell et all would only provide slc drives for servers. It appears the winds have shifted and now the cheaper mlc drives are avail for servers. In a sql environment, will mlc give ...
2
votes
1answer
36 views

Will SQL Server Express do in this specific situation

I'm doing research on the best suitable database for an in-house web application for our (non-IT) company. It's a web information system with few database-heavy tasks. Users can add new customer ...
1
vote
3answers
54 views

Migrating Mssql databases from different instances to a new server

I have 3 instances of Sql (2008 R2) on 3 different servers. The versions are (10.50.2550.0 SP1 Standard Edition (64-bit), 10.50.2550.0 SP1 Standard Edition (64-bit)). The goal is to migrate all the ...
2
votes
1answer
77 views

IIS 7.5 web application failing with NT Authority\Anonymous Logon

I am finding various google results, but none seem to fix my problem. I am setting up a new WINDOWS 2008 R2 box at work that is to communicate with an existing SQL 2012 box via web tools running in ...
1
vote
1answer
57 views

SQL Express Reporting Server 2014

I have a problem getting my SQL SSRS service working. Version: SQL Express 2014 When I try to start SQL SSRS in services, the service starts, but looking at the event viewer it fails to connect to ...
0
votes
0answers
17 views

EMC AVAMAR Compatibility with SQL Server 2008 R2 in Active/Passive Clustered Mode

We are currently using EMC AVAMAR as part of our backup policy for backing up all our servers. We also have a SQL Server 2008 R2 active/passive setup. Does anyone know if EMC AVAMAR is compatible in ...
0
votes
1answer
25 views

SQL BCP Permission needed?

Need to check a permission level, a user needs bulk insert\update\delete permission. If I add them to "BulkAdmin" server role, will this be enough? (Running SQL 2012)
1
vote
2answers
174 views

SQL Management Studio Can't Connect to Database---Microsoft fixes failed

I just installed MS SQL Server 2014 a couple days ago and it was working fine until today. I attempted to connect using the Object Viewer and I got the error message Cannot Connect to MyserverName. ...
1
vote
3answers
43 views

SQL Server 2012 SP1 transaction log getting full?

One of my DBs is having a problem with the transaction log filling up. It's set to full recovery and is regularly being backup via maintenance plan. I have a full DB backup every weekend then daily ...
0
votes
1answer
12 views

FIM2010 R2 SP1 service account requirements on database after installation

We're in the process of updating our Forefront Identity Manager to 2010 R2 SP1. The SQL Server instance for the old installation has the FIM service account in the sysadmin role, as is required for ...
-4
votes
1answer
37 views

Setup network between 2 computers connected using wifi [closed]

In my office I have a WiFi Router that allows 2 computers to connect to Internet. I have 2 questions - How can I create a network between these 2 computers for file sharing? Can I access SQL server ...
0
votes
0answers
32 views

MS SQL driver (Azure SQL) for PHP running on an Azure Website?

I am at my wits end. I've been googling this and all I get is 2010 blog posts that unfortunately do not appear to work today. I am trying to set up PHPBB on an Azure Website which uses the MS ...
0
votes
0answers
19 views

SQL Server Witness Server Alternative Approach

I have the setup below: 3 Database Servers 1 DR Database Server 1 Domain Controller 1 DR Domain Controller Currently I have the DR domain controller acting as the mirroring witness for the 3 ...
1
vote
1answer
86 views

SQL Server 2008 local connection an error occurred during the pre-login handshake

I am getting an error while trying to connect to SQL locally either via a web application or SQL management Studio. Oddly, I can connect fine remotely via apps on other servers or SQL management on my ...
1
vote
2answers
54 views

Configuring PHP and WikiMedia to use Microsoft Sql Server?

I have PHP 5.6 x86 installed on Windows 7 to C:\PHP. IIS is successfully running PHP and MediaWiki when it's configured to use MariaDB. I'm trying to get it to work with MS SQL Server and it's not ...
3
votes
1answer
92 views

SQL Server 2008 R2 Temporary Login Issue

We have a mature SQL Server 2008 R2 server, being used from many C# web applications, each with connection pooling. Last night, all web applications lost the ability to login to the database for 6 ...
0
votes
0answers
52 views

Network connection from old application to SQL Server 2008 R2 lost once in a while

We are trying to migrate an Axapta 2.5 database from SQL Server 2000 to 2008 R2. We are testing performance etc. on the new server, but once in a while, these two events are thrown on the Axapta ...
1
vote
1answer
101 views

SQL Server 2012 and 2014 memory limits

We're in the process of building a new server with 128GB of RAM. We would like to utilise as much of this as possible and my understanding is that 2008, 2008R2 and 2012 (all STANDARD) are all limited ...
3
votes
1answer
72 views

Find Full or Differential backup from .bak (with powershell or by any other means)

I'm trying to determine whether an MS SQL backup file (.bak) is Full or Differential. Is there an easy way to do this? A way of doing this in powershell?
0
votes
1answer
45 views

SQL Server Multiple Instances but showing the same databases

I am running SQL Server 2008 R2 Standard Edition and need to have multiple instances which I have installed. However, when I restore a database onto one instance, it is showing up on the other ...
0
votes
0answers
114 views

Volume Shadow Copy Service error: Unexpected error calling routine XML document is too long. hr = 0x80070018

I have about 1400 SQL databases on my environment (on 3 different volumes). I've got follow errors during taking VSS snap. Also SQLWriter goes from stable to failed "nonretryable" *Event ID 8193, ...
0
votes
2answers
72 views

Microsoft SQL Server Data Limit

I am using a Microft SQL Express edition server limited to 10GB/database. The original database runs on a licenced server and it is ~15GB. I was given a small part of this database (last couple years ...
0
votes
0answers
23 views

Password change to SQL user and SQL Agent user broke mail agent

We changed the passwords on the accounts which the SQL Server service and the SQL Server Agent use to log in. Both seem to be mostly working fine, however the mail agent is now having problems. It is ...
1
vote
1answer
60 views

Cannot start the T-SQL debugger when logged into a remote server via SSMS

Background information SQL Server 2012 on Windows Server 2012 Connecting to server remotely using SSMS The user I am using is in the sysadmin role Able to log in with SSMS and run queries without ...
0
votes
1answer
149 views

Exporting a Subset of Data in Microsoft SQL Server to Script

We are running a Microsoft 2012 SQL Server and are looking at a way to dump a subset of data (based on queries) to .sql scripts we could then run on another server to pull that data back in. We have ...
1
vote
0answers
56 views

How many MSDTC clustered services (if any) are needed for a multiple-instance SQL Server 2012 cluster?

I'm creating a new SQL Server 2012 cluster, running on 2 physical nodes (the O.S. is Windows Server 2012 R2); the cluster will host multiple SQL Server instances; the exact number is yet to be ...