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

0
votes
0answers
16 views

AD, Service Account, SQL Server DNS Issue

I have very very little experience with network admin and AD, so excuse my ignorance.. I am intermittently getting this error in a Windows Service and website running in IIS (both on the same Server ...
0
votes
1answer
2k views

Error in trying to delete a local publication for DB replication

I logged in in db ad sa (super admin). I want to remove a publication made using management studio wizard (right click on Replication/Local Publications/ New publication) After trying to delete I ...
-2
votes
0answers
13 views

Mouse cursor getting disabled after open MS SQL in server 2012R2 RDP [on hold]

The mouse cursor is getting disabled after opening MS SQL2012 in a Windows Server 2012R2 RDP connection. How can I fix this?
0
votes
0answers
21 views

Install SQL Server 2000 on Windows Server 2012 R2

We have a SQL Server 2000 running on a Windows Server 2008 R2 without problem. Now we have upgraded the main server to Windows Server 2012 R2. We have tried to install SQL Server 2000 on that ...
1
vote
1answer
1k 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
57 views

How much data can SQL Server handle without a DBA / other professionals?

We deploy clusters that use Cassandra, Elasticsearch and similar NoSQL technologies to index and process data. We go to quite some lengths to make sure we can consume and process records quickly. One ...
2
votes
2answers
1k views

Install SQL Server 2000 on virtual machine Windows Server 2008 (HyperV)

My hierarchy ask me to setup a production Windows server 2008 virtual machine (HyperV) with SQL 2000 Standard Ed. installed on it. I can't find on the net much information about the relative ...
0
votes
0answers
16 views

SQL Server does not exist or access denied but management studio connection works

I am trying to log on to SQLServer express 2008R2 on a Windows 2003 server using Sql server authentication over a VPN. The login and password work for Management Studio but not for the connection ...
0
votes
1answer
14 views

Windows Server 2012 R2 Hyper-V connection to external SQL Server not working

For almost 2 years, I've had a Hyper-V virtual machine on my local Windows 10 (formerly 8.1) machine running IIS and connecting to my production SQL Server (the Hyper-V VM is a development machine). I ...
1
vote
1answer
1k views

PHP 5.3 mssql support on Linux

I have a RHEL 5 box with php 5.3 that I am tasked with installing mssql support on. I installed php53-mssql and reloaded apache. It seems that modules were installed to /usr/lib/php/modules but my ...
0
votes
1answer
23 views

Log Shipping and Security for reporting

I have a SQL 2008 server with a database replicated via log shipping to a reporting server. The reporting server database gets updated once a day. The reporting server database is left in ...
0
votes
2answers
19 views

SQL randomly disconnects in the middle of querying data

I have a strange problem - when I am querying SQL table with more than 9000 rows, SQL randomly disconnects with some unrelated error. 1.) What I mean with randomly disconnects: On average it happens ...
0
votes
0answers
32 views

Redhat 6.8 - Where to install php-mssql

I tried following tons resources online to install php-mssql on Redhat 6.8 by using the Extra Packages for Enterprise Linux (EPEL) repo and it says that "No package php-mssql available". I made sure ...
0
votes
1answer
49 views

How to secure dual-homed Windows Servers that are connected to the internet

We have two machines running windows server 2012. Both have one NIC port connected to the public internet and another NIC port connected to a switch with internal IPs (192.168...). What is the most ...
0
votes
2answers
2k views

SQL Server Express cannot connect error: 28 - Server doesn't support requested protocol

I cannot connect to my local SQL Server Express (2012, but the version shouldn't matter) from my server (Windows 2008 R2) to use a tool on it (APEX SQL Data Diff if you are wondering). I can browse ...
0
votes
1answer
4k 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 ...
0
votes
0answers
6 views

OSQL only showing server name without the instance

When i run osql.exe -L on one of our MSSQL db servers, one particular server only ever returns its server name and now its servername and SQL instance name. This is causing an issue connecting ...
0
votes
1answer
2k 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
2k 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 ...
-3
votes
0answers
29 views

Which server should be more powerful - web or db?

I tried searching a lot on google as well as serverfault but could not find answer to my specific question, so please forgive if i am asking something common. I have an amazon instance running ...
0
votes
0answers
14 views

Cannot create an instance of OLE DB provider. Error 7302

I am trying to connect to Oracle server from SQL server. I have installed Oracle DB and trying to create linked server following this link. But when I click ok on creating linked server it fails ...
0
votes
1answer
1k views

Sql Server Transaction Log Backup Fails

I have a Sql Server 2008 Standard version. Mirroring is set up on the server in full safety mode. Its been working fine till today. The transaction log back-up fails every-time with an error "Error: ...
2
votes
3answers
5k views

SQL Maintenance Plan - Send email on fail

I have a maintenance plan on my SQL 2008 box - I would like it to send an email address when (or if) it fails. I've set up database mail, and can send a test email.. How can I do this?
0
votes
2answers
17k views

Is it safe to shrink tempdb.mdf in MS SQL Server?

Hej, my TEMPDB.mdf grew up to 42GB on MS SQL Server 2005 installed on Windows Server 2003. Last date change is 31/01/2013 at night. So, I wonder whether this is ok to shrink it?
1
vote
2answers
4k 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 ...
2
votes
1answer
2k views

WSS Search fills 10 GB limit on SBS server 2011

I've got a SBS Server 2011 Standard SP1 that isn't very busy. 2 Users local and 2 remote. We have sharepoint that has maybe a dozen small documents at most. I've just started getting the following ...
0
votes
1answer
2k views

Powershell execution policy within SQL Server

Can anyone help? Firstly I apologise if this is the wrong forum and for the amount of text you have to read. I'm not allowed to post images yet and a picture is worth a thousand words..... When ...
0
votes
1answer
2k views

Unable to run query in SQL Management Studio because of JIT debugging error

Recently I have built a Windows server 2008 and installed SQL Server 2008 and Dynamics CRM 2011 on it. Everything is working fine but when I open the SQL Server management Studio and try to open a new ...
7
votes
1answer
1k views

SQL Server Installer Update Cache management

Is it safe to delete the old cumulative update directories from the %ProgramFiles%\Microsoft SQL Server\110\Setup Bootstrap\Update Cache folders? At least this MSDN blog post tells to leave anything ...
4
votes
3answers
3k 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 ...
3
votes
5answers
4k views

Determine LSN of database in NORECOVERY mode

I'm restoring transaction logs to a database, but need a way to know which transaction log I should start with. Typically I'll see something like this: The log in this backup set terminates at ...
0
votes
1answer
2k 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 ...
2
votes
7answers
2k views

Enabling xp_cmdshell in a production environment

A SQL developer on a project I am working on has asked whether it would be possible to enable xp_cmdshell on the production database as it is easier to export CSV files using xp_cmdshell than to write ...
0
votes
0answers
16 views

freetds start job at step from linux python script on MSSQL DB

I'm trying to create a python script on a linux box that can execute an agent job. Looking around I found sp_start_job command. But it doesn't seem to exist on python. Does any one know if it does ...
-1
votes
1answer
39 views

Migration between Oracle and Azure SQL Data warehouse using SSMA

I am facing the below error while syncing table from Oracle to an Azure SQL data warehouse using SSMA tool (a tool used to migrate data from Oracle to Azure SQL). I am able to connect to the database ...
6
votes
4answers
8k views

SQL Server Backups using Volume Shadow Copy

Many well-known backup utilities for Windows use the Volume Shadow Copy Service built in to newer versions of windows to create a point-in-time snapshot of the disk in order to safely back up open ...
3
votes
3answers
4k views

How can I backup an SQL Server database using Windows Server Backup?

Apparently Windows Server Backup has some support for backup of SQL Server databases: Ability to recover applications. Windows Server Backup uses VSS functionality that is built into applications ...
0
votes
3answers
13k views

How can I get Transaction Logs to auto-truncate after Backup

Setup: Sql Server 2008 R2, databases set up with Full recovery mode. I have set up a maintenance plan that backs up the transaction logs for a number of databases on the server. It is set to create ...
0
votes
1answer
2k views

Cancel/Kill SQL-Server BACKUP in SUPSPENDED state (WRITELOG)

I have a SQL 2008 R2 Express on which backups are made by executing sqlmaint from windows task planer. Several backups ran into an error and got stuck in state SUSPENDED with wait type WRITELOG. How ...
0
votes
1answer
28 views

How do I upgrade Non-Readable replica to readable (active) replica in Azure SQL Database

We have a Azure SQL Database with one read-only replica. We want to upgrade it to a plan that makes the replica active, so that it becomes readable. However, the upgrade procedure produces the ...
1
vote
1answer
2k views

Red Hat 6 connect to MS SQL server 2005 using freetds; pdo_dblib and php

I'm having a problem connecting to my Microsoft SQL Server 2005 from a Red Hat box using freetds. My end goal is to be able to connect using php's PDO, but I don't appear to be able to connect when ...
0
votes
1answer
23 views

How to create a full dbo role for specified databases

We supply specialised data management software to the geothermal industry. From time to time, the database structure needs to be changed, and we issue a new version of the software that automatically ...
0
votes
2answers
48 views

SQL Server Named Pipe Error

I have been trying to install SQL Server Express for a few days now. I tried 2008, 2012, and now 2014 all with the same result. I cannot connect to the database remotely, even if I turn the firewall ...
0
votes
1answer
4k views

Can't connect to remote mssql server

I'm trying to connect to my remote mssql server for my GunZ private server, but for some reason i get the following error Cannot connect to 94.xx.xx.xx. ADDITIONAL INFORMATION: A connection was ...
0
votes
1answer
2k 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 ...
10
votes
8answers
27k views

Is using integrated security (SSPI) for accessing SQL Server better for web applications?

When deploying web applications (.net) to a production environment, is it better to use integrated security or does it even matter? It seems to me that if a hacker breaks the web server, it won't ...
3
votes
1answer
1k views

SQL Server Debugging: “Unable to Step. Invalid operation”

I'm debugging a call to a Stored Procedure in SSMS (2012). Frequently, and various random points in the code, a dialog pops up: Microsoft SQL Server Management Studio: Unable to Step. Invalid ...
1
vote
1answer
22 views

Using AWS, EC2, can't reach port 1433 for sql server

we're using two AWS EC2 instances, win 2012 servers, one for MS SQL Server and one for IIS. IIS is unable to reach port 1433 on the SQL Server. Here's what we've tried: Checked VPC setting and no ...
3
votes
1answer
5k views

The OLE DB provider “SQLNCLI10.1” has not been registered.; 42000

I have a SQL Server 2008 Analysis Services Project. In the Data Source View I have a Named Query which references a single Data Source containing three tables. The Project processes successfully and ...
12
votes
1answer
2k views

Delete performance for LOB data in SQL Server

This question is related to this forum thread. Running SQL Server 2008 Developer Edition on my workstation and an Enterprise Edition two-node virtual machine cluster where I refer to "alpha cluster". ...