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
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 ...
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 ...
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 ...
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 ...
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 ...
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,...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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"
$...
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 ...
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 ...
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 ...
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 ...
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. ...
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 ...
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 ...
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 ...
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....
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 (...
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 ...
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 ...
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 ...
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
...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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....
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 ...
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 ...
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 ...
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 ...
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.
...
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 ...
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 ...
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 ...
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 ...
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 ...
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? ...
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 ...
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:
...