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)

-1
votes
1answer
56 views

Will an average PC run a 10 concurrent write intensive request with 50MB daily database server? [closed]

As I am a average programmer who have never been purchasing any hardware myself, I have to choose a computer for a prototype database server that will be used to serve 10 concurrent request per one ...
0
votes
0answers
36 views

Why is MSSQL 2008 saying @filter_clause is invalid and that articles do not exist when creating a new publication from a script?

I have a snapshot publication on a test server with a pull subscription set up on another test server (both SQL Server 2008 R2). This publication takes a snapshot of a few columns in a few tables for ...
0
votes
1answer
55 views

Windows server and ddns which binding and sql hostname do i use?

i'm trying to connect to websites on this server from outside the network. i've opened ports in router and firewall and can ping the ports using portchecker. let's pretend i want to use wordpress or ...
0
votes
1answer
46 views

Should I move to an Azure database? [closed]

I am currently using a database from an installed instance on my web server in a VM on Azure. I was thinking about moving it to an actual Azure Database so I could load balance the web server. Does ...
0
votes
0answers
153 views

MSSQL 2014 and Dynamics CRM 2013 SP1 (springwave)

Microsoft says MSSQL 2014 is not supported with MS Dynamics CRM 2013 (SP1 springwave '14). Is this because there are known problems with that configuration? Or does it just mean that Microsoft did ...
0
votes
0answers
15 views

Issues installing MSSQL extension in IIS

Hello long time lurker first time poster, I'm running PHP 5.4 on IIS and have installed the extensions mssql (SQLSRV30.exe) and activated the extension in the PHP manager. However, whenever I use ...
0
votes
2answers
119 views

Microsoft SQL Server Standard High Availability without Shared Storage

I'm a software dev with little experience managing SQL so please bear with me! We are developing a piece of software that needs to be highly available, with a significant degree of resilience. This ...
2
votes
2answers
49 views

Where is that backup file?

I want to restore a database using the most recent backup. In SSMS, it says there was a backup done this morning at 1:00 AM. Screenshot: If I select this backup, it fails, saying the file ...
0
votes
1answer
47 views

What happens when Core Cluster Group is failed over to another node? Will it take the whole cluster down? Single point of failure?

http://bit.ly/1lKJFIa "Cluster group" fail-over will cause cluster go offline. Really? Single point of failure? Am I missing something? What happens when Core Cluster resources (Cluster Group) are ...
0
votes
3answers
79 views

Windows Server SMTP Feature - Installation Ramifications

Background: I am a SQL Server DBA. I have inherited about 50 SQL Servers and need to set up various maintenance plans and alerts. To get the full benefit, I'll also need to configure Database Mail ...
0
votes
1answer
234 views

Error connecting to sql server database when running IIS from DMZ

I've been working on this for a few days now. One of our clients has a 3 tier server plan - an IIS server, an application server (where the Asp.Net MVC3 application is located) and the db server. All ...
0
votes
1answer
93 views

MSSQL: Roll back DB from backed up .MDF/.LDF

I've mistakenly deleted a table in Microsoft Server Management Studio, and the restore function was not properly configured. I have older .mdf and .ldf files of the particular db with the deleted ...
0
votes
1answer
61 views

Connect to Windows Server 2012 Essentials without creating new user login for Windows

Is it possible to connect to a Windows Server 2012 Essentials without having to create a new user login for Windows? I want to just take someones Windows 8 machine and connect it to the server to ...
0
votes
0answers
75 views

Transferring Windows server from Rackspace to AWS

I've had a Windows server hosted with Rackspace for a while. The same setup also hosts the SQL server, and has all the IIS configs, etc. Being a Windows server noob, I have no idea how I could ...
1
vote
1answer
72 views

BCP/xp_cmdshell access denied - but only when running procedure from outside the server

I've been attempting to run some of my team's database deployment code to a SQL 2014 server on a Windows 7 test box. Part of this code is a procedure that pulls in data from a file using BCP from a ...
0
votes
0answers
8 views

Google app engine server not answering when queried in bulk

I've recently launched my game worldwide and we currently have problems with our google app engine server not always giving it's result messages when bulk querying. By bulk query I mean sending 100 ...
0
votes
1answer
41 views

Rebuilding MS Agent Jobs from MSDB table

This morning our DB server died. They restored backups to another server but these didn't include the many MS Agent jobs. Anyway I have managed to get a backup of the old MSDB table where all the ...
0
votes
1answer
50 views

How do I know which node in a cluster answers?

I have set up an NLB with two servers (nodes) which are running the same service. The filtering is single host, because I don’t want them to run at the same time, because there is data in the cache ...
0
votes
2answers
144 views

SQL server performance over long distance

Is it reasonable to expect decent performance from a SQL server connected via fiber private WAN - 5000 km's away. The carrier is telling us that this network is the 'best' possible, and will ...
0
votes
1answer
77 views

RAID 10 Cluster Size for SQL Dynamics AX Database

Many article read and many websites visited yet still no closer to a firm or concrete answer. We have created all our Arrays for our SQL 2012 installation with the appropriate LUN's and understand ...
0
votes
1answer
220 views

High memory usage windows 2008

I have a Windows server with 32 GB RAM, which is running sqlserver and tomcat. In resource monitor it show more than 95% memory usage, but when I searched in processes all process, each process is ...
1
vote
1answer
264 views

SQL Server 2014 Setup Fails with Error 5 - Terminal Services Unsupported?

I am installing SQL Server 2014 on a hosted virtual machine using remote desktop. When I run setup command line options display using .\setup.exe /? , I get the following error: An error occurred ...
0
votes
1answer
53 views

How to locate the cause of a excessive memory in ms sql

We are experiencing memory issues with MS Sql 2008 R2. There appears to be a memory leak that is consistently increasing in memory usage until it gets to about 1.5 gb and then stops. We have used ...
3
votes
1answer
53 views

How can I verify whether a Windows cluster has previously been successfully validated?

As part of an automated SQL Server installation process, I'd like to programmatically check whether a Windows Failover Cluster has already been validated. There are some ways to validate the cluster ...
0
votes
0answers
235 views

Intermittent Error SQL Server Error 67 and 17

We are running Windows SQL Server 2012 Standard on Windows Server 2012. There is a SQL Database with an Access Front End which we migrated from older versions of Access and SQL. The Access front end ...
-1
votes
2answers
113 views

Amazon RDS - UTC daylight savings

I haven't been able to get AWS support on the line and need an answer asap - do the SQL instances on Amazon Web Services RDS use daylight savings? I know the timezone is UTC but not sure if it uses ...
0
votes
0answers
51 views

SQL Server 2014 Standard 2014 no access and bad preformance

My company looks after a server which is running SQL Server 2014 Standard Edition. The main application database on the server is replicated out to about 20 subscribers. The server has only been in ...
1
vote
1answer
120 views

Password case sensitivity when upgrading from SQL Server 2000 to 2005

Anyone please help! Today is 3rd day that I'm banging my hand to solve this problem. So the situation is, I've inherited a project which worked on SQL Server 2000, later client decided to upgrade the ...
0
votes
0answers
45 views

Network Issues Connection to SQL database on MS server

Prior to asking this question, I followed this thread: Cannot telnet to SQL Server on port 1433 I am attempting to connect to a database on a server distinct from the computer upon which I am ...
1
vote
0answers
39 views

SQL Server Background Task Running?

I am developing a web application, which consists of a .NET application, using Entity Framework, and MS SQL 2012 back end. Every now and then we experience a slowdown in the system, which causes ...
0
votes
1answer
38 views

Perfmon % Processor Time unbalanced

I am somewhat of an accidental DBA, and I'm troubleshooting a SQL Server box where performance has been notoriously poor (as reported by the customer). I was not involved in the initial planning of ...
0
votes
0answers
22 views

Access Multiple Remote MSSQL Server DBs from Single Web Console for DBA

Purpose: Performing Queries, Generating Reports from Database Issue: At Present, I manually connect to each server, then do perform queries and generate reports. There are multiple Remote sites ...
1
vote
1answer
246 views

Can SQL server 2012 Service Pack 2 be applied to an Express Edition instance?

I need to upgrade an instance of SQL Server 2012 Express Edition (SP1) to Service Pack 2. Can the standard Service Pack 2 package be applied to an Express Edition instance, or do I need to run the ...
1
vote
0answers
102 views

MSDTC Errors: QueryInterface failed for “ITransactionDispenser”: 0x8004d01c(XACT_E_CONNECTION_DOWN)

I’m having some issues with a server where MSDTC is not working properly. This started happening about two days ago. I’ve tried a number of different things including restarting the VM and I’ve ...
0
votes
1answer
550 views

Time-out occurred while waiting for buffer latch type 3 for page (1:401831), database ID 8

I'm getting the below error while insert record into a SQL 2005 SP3 DB. Msg 845, Level 17, State 1, Line 1 Time-out occurred while waiting for buffer latch type 3 for page (1:401831), database ID 8. ...
0
votes
0answers
24 views

SQL Server Express Application Deployment Via CD

Our company has an ancient home-grown Win-32 application which uses a SQL Server Express db. We have a salesperson at a remote office who has no reliable internet and I need a way to package this app ...
0
votes
1answer
198 views

Installing SQL remotely using Invoke-Command

i'm trying to install SQL Server 2012 on Win 2012 r2 server remotely via Powershell using Invoke-Command, but it fails with this error "Validation for setting 'SQLSVCACCOUNT' failed. Error message: ...
0
votes
1answer
57 views

Is there a way to roll back inside a SQL Server 2012 stored procedure?

In a stored procedure, several "update" sql statements are being called. If any of them fails, I want to roll back the previously executed update statements in the same stored procedure. Is there a ...
0
votes
1answer
79 views

Periodically run an MS SQL query on multiple sites

I have been tasked with pushing Google Analytics data periodically to SQL Server 2005 running on a different server from various websites (about 450 of them) grouped on various servers. I understand I ...
0
votes
0answers
21 views

DPM Protection Groups & SQL Server

I've been tasked with moving our backup solution from standard sql backups to DPM backups. We have a fairly standard setup. Transaction logs backed up every 15 minutes. Daily backups which expire ...
1
vote
1answer
29 views

SSRS Failing with error on App_global.asax

Our SSRS server has started failing. The Logs are currently showing the following error: System.BadImageFormatException: Could not load file or assembly 'file:///C:\Program Files\Microsoft SQL ...
2
votes
1answer
207 views

MSSQLSvc Service Principal Names, Kerberos, and NTLM

Was recently helping a DBA with an issue that appeared to be related to an invalid SPN. Discovered that a good number of SQL service accounts simply don't have an SPN set, resulting in NTLM ...
0
votes
1answer
27 views

Old SQL installation media

We have MSSQL Server 2008 R2 licenses. We have an Action Pack subscription, which provides us SQL 2014. But we just need the installation media for 2008 R2 so that we can install Reporting Services. ...
0
votes
0answers
290 views

Getting Error: “Cannot open database \”DB PATH“ requested by the login. The login failed.\r\nLogin failed for user 'ACTADMIN' ”

Overview: OS: Tried on both win 7x64 and win8.1x64 Visual Studio version: Tried on VS 2013 (.net version 4.0 and 4.5), and VS 2010 (.net version 4.0) DB used: ACT2014Default Act version: Act! Premium ...
1
vote
1answer
158 views

SQL 2012 -> SQL 2014 upgrade failure

I did a SQL 2012 to SQL 2014 upgrade using the upgrade wizard. The install failed for the DB, Full-Text, Replication, AS and SSRS components, and the error reported was due to a backup location no ...
-1
votes
1answer
68 views

Connect to SQL Server from different network (remote) [closed]

I am new to SQL server stuff and recently thought of creating a Database for my website. I would like to stop things like comments, blog post, stuff like that. But I am trying not to pay for SQL ...
2
votes
1answer
47 views

Does an SQL Server instance allow both secure and non-secure connections at the same time?

we have an application running MS SQL Server 2012. For one specific use case we'd like to SSL protect the jdbc connection. I've checked the following links: How to enable SSL encryption for an ...
-1
votes
1answer
72 views

Cannot access my database, it says database inaccessible

I am hositng my application on a server but runs my Sql server in windows mode as application is still bieng developed. But suddenly when today I opened my Sql Management Studio, it is not allowing me ...
1
vote
1answer
82 views

What happens to active connections to my SQL Server DB if I back up the transaction log with the NORECOVERY option?

Some background: I'm migrating my SQL Server DBs to a new machine and I wrote a few Powershell scripts to send/apply full backups and transaction logs asynchronously to the new server, but my question ...
0
votes
2answers
49 views

How to export database from Azure with an invalid server name?

I have a SQL Server database on Azure that I want to export. On the Windows Azure portal, I select the database. From the dashboard page I select Export and I get the following error: <html ...