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)

4
votes
1answer
888 views

netlogon errors

I have two instances of mssql 2005 and am using CA XOSoft replication. The master is a failover cluster and the replica is a standalone server. They are all running Server 2003 sp2 x64. Same patch ...
-1
votes
0answers
17 views

IIS and SQL server connectivity/techniques

We have a two different new server we bought it to run the web application. 1. IIS Application Server Windows 2008 R2 Server IIS 8 Net Framework 4.0 2. SQL Database Server Windows 2008 R2 ...
1
vote
1answer
112 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 ...
1
vote
2answers
2k views

Can't install SQL Express 2008R2- caspol.exe application error - the application failed to initialize

I'm trying to install SQL Server Express 2008 R2 on Windows 2003 Server (enterprise edition). I get the following error message: Title: caspol.exe - Application Error Text: The application failed ...
0
votes
1answer
394 views

How do I permanently add additional connection parameters in SQL Server Management Studio

In the "Additional Connection Parameters" tab of the login form for SQL Server Management Studio (most recent versions), one may specify custom connection string parameters. See ...
0
votes
1answer
938 views

How to get php_mssql.dll working properly on IIS 7.5 and PHP version 5.2.17?

First of all I'll give a very brief introduction of what I'm trying to make. I need the mssql php functions to work on the webserver. I know that such functions were deprecated in PHP 5.3 and above. ...
1
vote
1answer
1k views

SQL Full-Text indexing not populating

We installed a clustered SQL 2005 installation on windows 2008 and reattached our san drives from another machine and restored to do a migration to new hardware. There have been a few minor issues, ...
2
votes
2answers
3k views

How can we recover/restore lost/overwritten data in our MSSQL 2008 table?

I am in serious trouble and I am seeking professional advices here. We are using MSSQL server 2008. We removed primary key, replaced exiting data with new data resulted losing our critical business ...
1
vote
1answer
730 views

SharePoint 2010 Server Configuration Error -> “Cannot connect to database master”

I recieve the following error when I try to configure SharePoint 2010 Server: "Cannot connect to the database master at SQL server at [computer.domain]. The database might not exist, or the current ...
2
votes
5answers
2k views

SQL Server 2008 R2 transactional replication over VPN

I'm having difficulty setting up replication over a VPN. I have a SQL Server 2008 R2, Enterprise Edition database on a Windows 2008 R2 Server. SQL Server is running on a non-standard port. I have ...
0
votes
2answers
42 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 ...
1
vote
1answer
1k views

sqlcmd won't execute - Claims Native Client not installed properly

I'm trying to use sqlcmd to execute some SQL scripts. Using a test command with a simple query like: sqlcmd -S HOSTNAME -d MYDATABASE -Q 'SELECT Names FROM Customers' sqlcmd does not appear to make ...
1
vote
1answer
742 views

SQL Server: “This filegroup cannot be used as a backup destination” error when attempting restore

When running a command like the following: "RESTORE FILELISTONLY FROM DISK='\\\\server\\folder\\DummyDB.bak'" I'm getting this error: Backup destination "\\server" supports a FILESTREAM filegroup. ...
2
votes
1answer
699 views

SQL Server Instance login issue

I've just brought up a new installation of SQL Server 2008. I installed the default instance as well as one named instance. I'm having a problem connecting to the named instance from anywhere ...
-2
votes
0answers
15 views

sql server 2008 express installation fail [closed]

The installation fail when you try to install sql server 2008 express on an x86-based computer.Сontent error: The following error has occurred: Cannot find service{0} Parameter name:Sqlwriter
1
vote
2answers
10k views

SQL Server 2012: I can connect locally but not remotelly

I'm trying to access a SQL Server 2012 database from a SQL Server Management Studio 2008 from a remote machine(on the same LAN). I can connect to the database using "sa" user under ...
-1
votes
1answer
51 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
2answers
1k views

SQL Server Database Access fails when User Granted Acess via Domain Group

On a SQL Server 2008 R2 (running on Win2003), we have an issue with logins via domain groups - login access is granted to the server instance, but cannot access certain databases on the server. The ...
1
vote
0answers
63 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
0answers
11 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
2answers
510 views

SQL Server Agent was not running on Server Dynamics CRM 2013

I'm trying to install Dynamics CRM 2013 on a server. This server is on a VM. There are several other VMs, an ADDS & DNS, a MSSQL and a WebServer VM. Each server is a Windows Server 2012 R2. The ...
-3
votes
0answers
19 views

Cannot connect to SQL Server 2014 running on one laptop from any other computer over the internet [closed]

I have setup SQL Server 2014 on my laptop (A1) and have projects accessing databases from it. If I run the project on another laptop which is connected to the same wifi router as A1 then it can access ...
0
votes
1answer
2k views

Error: Package 'Microsoft SQL Management Studio Package' failed to load. In SQL Server Management Studio

I had installed SQL Server 2008 R2, the installation was succesful. But I can't open the Management Studio because this error is shown: Package 'Microsoft SQL Management Studio Package' failed to ...
2
votes
2answers
4k views

AclPermissionsFacet fault install SQL-2008-R2

While attempting to do an installation repair of SQL-2008R2, I'm failing the pre-check rules. Module that is failing is AclPermissionsFacet - with this message "The SQL Server registry keys from a ...
0
votes
2answers
1k views

SQL 2008 install failed - Could not find the Database Engine startup handle

My SQL 2008 install failed, I'm getting this error: Could not find the Database Engine startup handle This happens after uninstalling SQL Server 2008 and trying to install SQL Server 2008 R2, any ...
2
votes
3answers
2k views

Can’t connect to SQL Server 2008 - looks like Shared Memory problem

I am unable to connect to my local instance of SQL Server 2008 Express using SQL Server Management Studio. I believe the problem is related to a change I made to the connection protocols. Before the ...
0
votes
3answers
59 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
27 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 ...
1
vote
4answers
879 views

SQL Server Maintenence Plan error on an offline Database

Today is SQL day for me :) I have a maintenance plan that is failing to run with the following error: Failed:(-1073548784) Executing the query "USE [SharedServices1_DB]" failed with the ...
1
vote
1answer
821 views

Restore SQL 2008 database fails with error on page xxx:xxx

This is the situation: Got a full backup (.bak file) of a SQL 2008 database, with partitions. The .bak file is 100gb. I need to restore this database on a different server, to a new database. ...
0
votes
1answer
37 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
38 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 ...
1
vote
3answers
5k views

Can't login to SQL Server in Single User mode

I've been trying all sorts of different combinations of startup flags to SQL Server 2008 R2 Express and I can not get past this error: Login failed for user 'LOCALSERVER\Administrator'. Reason: ...
6
votes
3answers
443 views

How to protect SQL Server from Hackers

I am having an issue and could not figure out how to handle it. I have a SQL Server on a Windows 2008 R2 server. This SQL Server 2005 is being used to receive DB subscriptions from another SQL Server ...
0
votes
1answer
1k views

MySQL ADO.NET Connector & MSSQL Integration Services

Here I am, day three... attempting to sync a data view on a Windows Vista box (64 bit) running MSSQL 2012 and Visual Studio 2010. Sanity is slipping and hunger for progress fills my attention. I ...
3
votes
6answers
5k views

SQL Server 08 Express error when connecting to localhost - “Timeout expired”. Works with ::1 or 127.0.0.1

EDIT New info: Navigating to localhost:1434 in Chrome gives me an "ERR_EMPTY_RESPONSE", while other ports give me an "Oops! This link appears to be broken". So it seems to binding ok there? So ...
0
votes
1answer
32 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
3answers
845 views

syspolicy_purge_history generates failed logins

I have a development server with 3 instances: Default, A and B. It is a physical server, non clustered. Whenever the syspolicy_purge_history job runs at 2 am, I get failed login alerts. Looking ...
0
votes
0answers
11 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
295 views

SQL Server 2012 Reporting Services to export CSV

I have an SQL Server 2012 Reporting Services instance, and by default, it can only export to PDF, Excel and Word. Users require CSV export as well. All I found is that there are different extensions, ...
0
votes
1answer
47 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 ...
3
votes
2answers
2k views

Combining failover clustering and database mirroring

When you combine failover clustering and database mirroring in SQL Server, you need to change the mirroring partner timeout value so that the local cluster gets a chance to fail over before database ...
3
votes
2answers
1k views

Why is my database not available?

I have one database on my server that constantly becomes unavailable. To fix, I take it offline, then back online. Looking at the event viewer there are three errors in quick succession: FCB::Open ...
2
votes
2answers
45 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
883 views

Firewall configuration for SQL Server 2012 Express on Windows Server 2008 R2 for Workgroup

We are attempting to configure a server application to run on Windows Server 2008 R2 using SQL Server 2012 Express. With the server firewall turned off completely the application can communicate just ...
1
vote
3answers
2k views

Error when trying to open SQL Maintenance Plan - SSMS 2008

If I open SSMS on my client machine, connect to our SQL server, and try and open a maintenance plan on there, I get this error: TITLE: Microsoft SQL Server Management Studio Could not ...
0
votes
0answers
28 views

Identify whether server is running MSSQL, IBM DB2, or neither, IE, by using Telnet [migrated]

I need a way to identify whether a given port at a given address is running an instance of Microsoft SQL Server, IBM DB2 Server, or neither, from Python. My first thought is that I can use Python's ...
0
votes
1answer
29 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
1answer
802 views

Performance Issue Between SQL and IIS on Seperate Machines

First time OP on serverfault, but an avid user of stackoverflow. We have two high-specification boxes, both running Windows Server 2008 R2 Standard. On one we have IIS 7.5, the other SQL Server 2008 ...
0
votes
2answers
1k views

Cannot access local database with IIS Manager

I've created a local .mdf database with Visual Studio 2010 and did a couple of modifications to it. Now I want to edit it in IIS Manager. However, I cannot access it neither by connection string, nor ...