Questions tagged [sql-server]

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.

781 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
2 votes
2 answers
1k views

PHP on IIS doesn't load sqlsrv extension

I'm trying to put together a page that can submit data from a form to an MSSQL database via PHP. I've got PHP installed successfully (phpinfo() runs fine even on a remote computer) but it will not ...
Abion47's user avatar
  • 191
2 votes
1 answer
1k views

SQL Mirror failing on setup

I've got two SQL servers, I need to mirror a database from one to the other. Should be straight forward, two servers no witness. Both servers are running the same edition of MS SQL Std 2014 The SQL ...
Patrick's user avatar
  • 1,290
2 votes
1 answer
56 views

RemoteApp: Can one be sure that no unwanted programs are started?

Back story: In our company, we bought a client/server process management software from which the client directly communicates with an SQL server. This is in my opinion a major security flaw, because ...
mario.schlipf's user avatar
2 votes
0 answers
1k views

The wait operation timed out

I have encountered this problem when running a Data-fill routine for a Data-set Data-adapter in C# which uses a stored procedure written in SQL Server Azure. The SQL Server stored procedure executed ...
jpWebLearner's user avatar
2 votes
0 answers
806 views

Constrained Delegation between IIS, SQL Server, SSRS and File System

First of all, not sure which site is best suited for this question be it SO, SF or SU so please feel free to suggest migration! I have a requirement to constrain delegation between several machines ...
Gareth's user avatar
  • 735
2 votes
1 answer
1k views

Is it safe to back up SQL Server data directly if using VSS?

I have a client with a very basic single server setup that includes a small SQL Server Express database. I recently configured Symantec Backup Exec 2010 Quickstart edition for them. This is the free,...
dbr's user avatar
  • 1,862
2 votes
1 answer
156 views

What are the network prerequisites for Windows Azure Pack

I have followed many articles to install and config windows azure pack distributed, But every time I finish configuring everything, the azure pack is not working and give me different errors, seams to ...
Amr Elgarhy's user avatar
2 votes
0 answers
1k 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 ...
Gavin Coates's user avatar
2 votes
0 answers
32 views

SQL Upgrade Adviser for win2k

I'm trying to upgrade a SQL Server 2000 instance to SQL Server 2008 R2. SQL Server 2000 resides on an old win2k box, and the new SQL instance is being run on a Server 2008 R2 platform. I am attempting ...
kubiej21's user avatar
  • 289
2 votes
2 answers
4k views

Is it possible to store a credential for Windows Authentication to an Analysis Services server?

SQL Server Analysis Services uses Windows authentication for server connections. Typically, you assign your domain account to a role (or the server administrator list), and then connect to the server ...
NReilingh's user avatar
  • 484
2 votes
0 answers
314 views

Failover_Partner connection in file DSN not working

I have an application which uses file DSNs to connect to a central database server. This database server is mirrored onto a secondary server, and in the event of a failover, it is my understanding ...
JJBurgess's user avatar
  • 141
2 votes
1 answer
199 views

Analyze meeting room coverage on Exchange server

We have a dozen meeting rooms, are looking to get rid of some of them, if we can prove that the remaining meeting rooms will cover our needs. We use an Exchange server. Is there any way I can query ...
forthrin's user avatar
  • 203
2 votes
0 answers
130 views

SQL Failover Cluster IP Migration

I have a four node cluster setup which I need to migrate from subnet A to subnet B. The cluster has roughly 12 instances running on it. I've found articles to update the SQL Cluster IP, but I've got ...
Untalented's user avatar
2 votes
1 answer
551 views

MSSQL Server 2012 Scheduled PowerShell Job fails

I have a simple PowerShell script that runs fine from the console (PSVersion 2.0). $psftpPath = "C:\Program Files (x86)\PuTTY\psftp.exe" $sftpHost = "foo.baa.com" $userName = "myusername" $...
Colin's user avatar
  • 121
2 votes
1 answer
501 views

Excluding a SQL File Group from DPM Backup

I have numerous SQL 2012 databases that are being backed up by Microsoft's Data Protection manager (DPM) 2012. However, in each of these databases there is a specific file group that contains a large ...
bigmac's user avatar
  • 469
2 votes
0 answers
44 views

SQL Server 2012 database availability design?

Can anyone please suggest me what is the best practice for me to follow when consolidating multiple stand alone DB from SQL Server 2005 - 2008 boxes into just 2x SQL Server 2012 Enterprise nodes in ...
Senior Systems Engineer's user avatar
2 votes
1 answer
239 views

What does -fixcolnames do in log parser 2.2?

I'm using Logparser 2.2 to try to bring a .csv filled with Performance Counter information into a SQL database, and I'm using the following command line command: logparser "Select * into IISCounters ...
Sean Long's user avatar
  • 463
2 votes
0 answers
3k views

Configuring IIS application pool to access SQL Filestream with ApplicationPoolIdentity

I have an IIS 7.5 server with a number of applications in a single Application Pool. Some of these applications access a SQL Server 2008 R2 Filestream on a remote machine, on the same domain. The ...
Marco Righele's user avatar
2 votes
1 answer
710 views

.NET + Connection to SQL Server 2008 R2

Recently, our developers have increased the Pool size in all connection strings to 8000. They are using VS 2010 Framework 4.0. In the DB side I am monitoring that up to 4000 connections is opening. ...
A_Sh's user avatar
  • 21
2 votes
0 answers
825 views

How to index document files in NAS storage?

I'm currently developing an application that have to index document files (.pdf and .doc) which are in NAS storage. After that I want to query them over the application. My customer does not want to ...
Ogun's user avatar
  • 133
2 votes
1 answer
508 views

Zend 1 on Ubuntu with MSSQL not working

Does anyone know how to solve the following issue? If not, does anyone know how to setup Zend 1 on Linux to communicate with msSQL server? We get the following error in the nginx logs when trying to ...
user162321's user avatar
2 votes
0 answers
1k views

SQL Reporting Services Report Manager cannot be accessed by IP on the local computer

I have set up SQL Express 2012 with Advanced Services on a test machine. The requirements are that ReportServer should run on a dedicated IP address and port. So I went to Reporting Services ...
JustAMartin's user avatar
2 votes
0 answers
2k views

Compressed network file copy

I have 200 GB of SQL Server files I need to copy over a 100 Mbit connection. Assuming maximum throughput that will take five hours. SQL Server files compress very well, generally in the 80 - 90% range....
mroach's user avatar
  • 121
2 votes
0 answers
189 views

Full Text Search query elapsed time varying wildly

Database Version: Microsoft SQL Server 2005 - 9.00.4035.00 (Intel X86) Nov 24 2008 13:01:59 Copyright (c) 1988-2005 Microsoft Corporation Express Edition with Advanced Services on Windows NT 5.1 (...
Equixor's user avatar
  • 73
2 votes
1 answer
809 views

SQL Server Reporting Services subscription creation silently fails. No error message is displayed, but the subscription does not get created

I'm trying to set up a subscription for a SSRS report. I have deployed the report to the server and I can view the report in a web browser with no problems. I have tried to reproduce this issue on ...
jwnace's user avatar
  • 173
2 votes
0 answers
2k views

"Operating system error 1394" - How can I prevent it?

I get occasional and random failures of my SQL Server backups with the error message Operating system error 1394 Does anyone know why this error occurs and how I can prevent it? A little Googling ...
Guy's user avatar
  • 2,678
2 votes
1 answer
319 views

apache 2.2 with php 5.3 and miscrosoft sql 2008 crash

I am using Apache 2.2 with PHP 5.3 and Microsoft SQL Server 2008 on Windows Server 2008 64-bit. Every 3 to 5 hours, I get the error in the event viewer that Apache crashed for 20 seconds and then ...
mohamed Ali 's user avatar
2 votes
1 answer
2k views

Password mismatch while logging to sql server

Alright, I have a classic asp application and I have a connection string to try to connect to db. MY connection string looks as follows: Provider=SQLOLEDB;Data Source=MYPC\MSSQLSERVER;Initial ...
user194076's user avatar
2 votes
0 answers
1k views

Visual Studio giving Microsoft SQL Server Compact 4.0 error when trying to perform any database operation

"An unexpected error occurred in the .NET Framework Data Provider for Microsoft SQL Server Compact 4.0. Please contact the provider vendor to resolve this problem." is the actual error message. I am ...
RBZ's user avatar
  • 165
2 votes
1 answer
1k views

Repairing Dynamics CRM 2011 Server

As stated above, I had a bit of an issue with my CRM 2011 server last week. I run a small computer repair company and use it to manage my clients. I was running the server in a VirtualBox VM and the ...
Brian Morrison II's user avatar
2 votes
1 answer
534 views

SQL server start-up bringing online database priority

we have hundreds of databases on one sql server instance. After restart sql server takes databases online one by one using default order from sys.databases view. This order use database_id, so first ...
Alexey Smolyakov's user avatar
2 votes
1 answer
1k views

SQL Server synchronization failed

I'm getting the error message below when trying to synchronize a SQL compact database (SQL CE 2.0) to a SQL Server 2005 database. I have double and triple checked permissions, reconfigured IIS ...
notandy's user avatar
  • 564
2 votes
1 answer
207 views

SQL Server 2005 question about procedure cache

Server: SQL Server 2005 SP2 64 bit, 32 gigs of memory. 2 instances of SQL server running. Main instance I'm using has 20 gigs visible. We have a situation where it appears every so often our entire ...
Equixor's user avatar
  • 73
2 votes
1 answer
888 views

How to create a shared lock blocking an intent exclusive lock

As I understand it, a SELECT statement will place a shared lock on the rows that it will return. While that SELECT is running, if an UPDATE statement comes along and needs to grab an intent exclusive ...
FremenFreedom's user avatar
2 votes
2 answers
546 views

Benchmark tests for MSSQL 2000 VS MSSQL 2008.. (thinking for upgrade)

How much of a difference will there be (for speed and other benchmark results) for a database about 5 and even 10 GB to move from MSSQL 2000 to MSSQL 2008? It's running on a Windows 2003 VMWare guest ...
user avatar
2 votes
0 answers
211 views

Can encryption be disabled for the login handshake in SQL Server 2005 or 2008

When a client Application connects to SQL Server the login credentials are sent over the network in a TLS Encrypted Handshake Message. For testing purposes I would like to have the login credentials ...
KiwiNige's user avatar
  • 153
2 votes
1 answer
340 views

Citrix server running 3rd party app experiencing SQL timeouts

We are running an app that was not developed in house on several Citrix servers. The users of this application are experiencing intermittent SQL timeouts. The error message: "System.Data.SqlClient....
Graham Powell's user avatar
2 votes
3 answers
298 views

Sql Server 2005 cluster - unable to rename to old server name

We have a sql 2005 cluster on W2K8 cluster. It is a named instance say SRV1\A. Then I built a new W2K8 (with a diff cluster service name) but the same service account. Then I installed a new sql 2005 ...
user avatar
2 votes
1 answer
946 views

SQL Server Database In Single User Mode after Failover

Here is a weird situation we experienced with a SQL Server 2008 Database Mirroring Failover. We have a pair of mirrored databases running in high-availability mode and both the principal and mirror ...
user avatar
2 votes
1 answer
2k views

SQL Server "Long running transaction" performance counter: why no workee?

Please explain to me the following observation: I have the following piece of T-SQL code that I run from SSMS: BEGIN TRAN SELECT COUNT (*) FROM m WHERE m.[x] = 123456 or m.[y] IN (SELECT f.x FROM ...
user avatar
2 votes
1 answer
254 views

Web Platform Installer - Wants to instal SQL 2008 Express when I already have SQL 2008 Standard installed

I'm finding my use of the Web Platform Installer somewhat muted by it's insistence on trying to install SQL Express when I already have a full copy of SQL Server installed. Why is this happening? Is ...
CJM's user avatar
  • 730
2 votes
1 answer
1k views

SQL CLR not properly enabling

We have a SQL server running SQL 2005 Workgroup 64 bit (9.0.4273), on Windows 2003 server 64 bit. We have run sp_configure and reconfigured the server which indicates that the clr is now enabled. ...
dnolan's user avatar
  • 121
2 votes
1 answer
169 views

SQL Server Bulk Insert Issue on Windows7

I’ve got an application that uses SQL Server Express 2005 SP3. This application is distributed to several hundred users, each of whom is running XP. However, our company will be moving to Windows7 ...
user avatar
2 votes
1 answer
762 views

SQL Server 2000 and SSL Encryption

We are a datacenter that hsots a SQL Server 2000 environment which provides database services for a product we sell that is loaded as a rich-client applicatin at each of our many clients and their ...
user avatar
2 votes
1 answer
1k views

Delay index build until SQL Server table load is complete with SSIS

I have a large table that I am updating. Is it possible to disable index updates on the destination table until the load is complete? It seems like a waste for it to be constantly updating the index ...
Mattew's user avatar
  • 163
2 votes
1 answer
1k views

Windows Performance Monitor keeps trying to add unwanted counters

I have been running a Data Collector Set for SQL Server for a week, and everything was going just fine until I tried clicking on Action -> Save Current View and now it always tries to add the ...
ivanmp's user avatar
  • 180
2 votes
2 answers
2k views

Move Azure SQL database server between subscriptions

We have two subscriptions (DEV and PROD). A database server has been deployed to the DEV subscription, but it is now in use by our production system. I want to move the Azure SQL database server to ...
Ramon de Klein's user avatar
1 vote
0 answers
25 views

Fortify Software Security Center Database (HA) Issue

We have deployed Fortify Software Security Center in an environment with configured MSSQL ssc_db. How would I configure the High Availability Database configuration in Fortify SSC if possible? ...
Shahab Ali's user avatar
1 vote
2 answers
1k views

How to setup Windows Remote Desktop Connection Broker HA with SQL Server Express?

I am preparing an environment in which Remote Desktop Connection Broker for which HA is to be based on SQL server (windows server standard 2022) In my case, the SQL server is MS SQL Server Express ...
sprawdzone.it's user avatar
1 vote
0 answers
60 views

Unable to restore an MSSql Database from an Azure Storage backup

We have a simple sql script to restore an MSSql DB from an Azure storage blob. We backup our PROD DB to Azure Storage. Trying to run this script (which we swear used to work a while ago).. now errors: ...
Pure.Krome's user avatar
  • 6,608

1
2
3 4 5
16