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)

2
votes
0answers
40 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 ...
1
vote
1answer
24 views

create a view to show the backup status in every 10 mins

I have a question, my table have following data: userID, startTime, EndTime ————————————— 101, 04/11/2013 11:00:00, 04/11/2013 11:55:00 102, 04/11/2013 11:00:00, 04/11/2013 11:24:00 103, 04/11/2013 ...
1
vote
1answer
28 views

Uninstall SQL Server 2005 Express after Demoting the DC

A Windows Server 2003 SP2 hosting a now orphan installation of SQL 2005 Workgroup was pressed into service as a DC in a disaster recovery scenario. It has since been demoted. The server also hosts ...
1
vote
1answer
181 views

SQL Server 2008 R2 error: 18456, state 1: login failed for “domain\username”

I can't seem to authenticate to my SQL server using the following command: sqlcmd -S myserver -d mydatabase -U user -P password It always says, error: 18456, state 1: login failed for ...
0
votes
0answers
242 views

SQL Server Error - HRESULT E_FAIL has been returned from a call to a COM component

I have a huge 200MB .SQL file. When I try to open this in SQL server management studio 2008, I get the error -Error HRESULT E_FAIL has been returned from a call to a COM component. What could the ...
1
vote
0answers
94 views

SSRS reachable by FQDN on local computer, but not from a different computer

I am having trouble getting my SSRS server to successfully cohabitate with IIS, after having to move the server to a different subnet. I have 2 static IPs for that server: .242 is defined explicitly ...
0
votes
2answers
216 views

Just a few questions about Hyper-V virtual machines and clustering

I have been using Microsoft’s Hyper-V technology for a little while now, but I am just now dipping my toe into clustering. In particular, I am trying to implement a fault-tolerant SQL DB. This ...
1
vote
1answer
61 views

SQL Server does not enforce encryption rules

I am forcing encryption on my MS SQL server. My intention is to reject any client connection that does not use SSL to connect. Here are my detailed steps : makecert -r -pe -n ...
1
vote
1answer
23 views

Test Environment for Microsoft SQL Cluster [closed]

I have a the following test environment: 1 - Windows 2008 (DC Edition) Role - Active Directory 2 - Windows 2008 (Enterprise Servers) I would like to create a MSSQL Cluster in this test environment. ...
0
votes
0answers
71 views

SQL Azure automated export fails silently

I have a database in SQL Azure that's configured for a daily automated export but the export never occurs. I've tried turning off automated exports and re-enabling it, changing the time of day and the ...
0
votes
2answers
33 views

How to setup a connection to MS SQL without /InstanceName in the address?

How can I setup my SQL server to allow connections without having to type in the instance name? For example in the picture nelow, I'd like to connect without /SQLEXPRESS in the server name.
0
votes
1answer
89 views

SNMP walk on Virtual Ip not working? what can be the reason

I have two MSSQLcluster, at a time VIP [virtual ip] that will be assigned to on of the master. The problem is when i try to do any snmpwalk on VIP from a different machine its returning me a time out. ...
0
votes
0answers
30 views

AD mapping error with VMware

I'm trying to setup a VMware Data Center with Win Server 2008 R2 and SQL 2012. I have a VM that hosts DHCP and DNS services and created an account called "SQLAdmin" that is a local admin to a SQL VM ...
0
votes
0answers
15 views

What actions may reset the Snapshot Isolation setting for a database?

I have a customer who tells me they have previously set ALLOW_SNAPSHOT_ISOLATION ON and READ COMMITTED_SNAPSHOT ON on one of their databases, but as far as I can tell by looking in sysdatabases it is ...
1
vote
1answer
78 views

Cannot Connect to MsSql2008 R2 Database Engine, While Connecting to Other Services

I have installed MsSQL 2008 R2 on my computer as I have installed always before. But unfortunately this time, I cannot connect to Database Engine while I can easily connect to the other services like ...
0
votes
2answers
56 views

Recommended Setup

I have been running into issue with my MSSQL Database setup with speed. Here is my scenario. About 100M Rows Average: 1k Updates Per Second Hard Drives: RAID 10 SSD MDF --Active Time: 0 Log ...
0
votes
2answers
63 views

unlock database files when SQL server is idle

In my development/test environment on my laptop, I can't back up the SQL server database files because the file handles are kept permanently open by SQL server (VSS doesn't work because the drive is ...
1
vote
1answer
183 views

Need to stop SQL Server when using Disk Defragmenter?

Our provider told me today that I should stop Microsoft SQL Server and other database systems like MySQL when using the Windows Disk Defragmenter. Otherwise, the database might get corrupted. Since ...
0
votes
1answer
94 views

If a SQL Server Replication Distributor and Subscriber are on the same server, should a PUSH or PULL subsciption be used?

Thanks in advance for any help. I'm setting up a new Microsoft SQL Server replication and I have the Distributor and Subscriber running on the same server. The Publisher is on a remote server (as it ...
0
votes
1answer
83 views

how to copy sql server database on same server

I've got a SQL Server 2008 and want to make a copy of a database so I've got a 2nd Version of the database for testing on the same server. The database copy wizard is not able to copy the database, ...
0
votes
0answers
49 views

Mail to Mailenable group sometimes bounces back because it cannot find one of the group members

I am using MailEnable Enterprise Edition 6.53. On one of my PostOffices I have a group address set up with 5 members in the group. Under normal circumstances when someone sends a mail to this group ...
0
votes
1answer
31 views

I attached an MSSQL database but its read-only

I copied a small database from one SQL Server 2008 R2 Express (physical) server to another of the same version, but I cannot re-attach. It attaches but the DB is greyed and read-only. It was writable ...
0
votes
0answers
74 views

After installing MS SQL Server 2012 not able to log into SSMS

Okay, lot's of posts around the internet on this subject. But I haven't been able to find an answer I was looking for. I installed SQLS 2012 on Windows Server 2012. I installed the Engine and the ...
0
votes
1answer
662 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
1answer
78 views

Windows Server 2012 Hyper-V Rename - SQL DB Issues

I set up a Windows Server 2012 virtual machine exactly the way we want it. I shut down the instance, made a copy of the .vhdx virtual drive, then spun up a new VM and attached the copy of the drive. ...
3
votes
1answer
62 views

How to create SQL account that can only perform certain actions?

I'm used to working on contracts where someone else is responsible for the SQL database. However, I'm now working a contract where I must set up a new SQL Server, so I set up MS SQL Server 2012 ...
0
votes
0answers
28 views

How does Windows Server Backup authenticate on a SQL Sever?

My unerstanding is that when making a backup with Windows Server Backup it calls on the vss shadow copy service to create shadows of various components. One of the vss writers is SqlServerWriter, ...
0
votes
1answer
87 views

Windows Server and SQL Server Licenses [duplicate]

I have the following servers: PROD: 2 x web servers (content delivery) 1 x cms server 2 x database servers (SQL) UAT: 1 x web server (content delivery + cms) 1 x database server (SQL) I'm a ...
1
vote
1answer
107 views

How to make clustered storage available from SAN to Hyper-V for two node cluster

I want to make a 2 node SQL Server 2012 cluster. Both nodes are virtual machines running Windows Server 2012 on Hyper-V. I have a physical SAN available which I can use for clustered storage so I was ...
0
votes
1answer
887 views

Telnet 1433 on SQL Server Failing

I work with a number of SQL servers. Some are clusters and some are standalone. Some of the standalone servers run multiple instances and some do not. What I've found is that any SQL server I have ...
0
votes
1answer
81 views

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

Apparently Windows 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 like ...
1
vote
1answer
118 views

Slow MSSQL on DB (~2TB) - Index / fragmentation?

I have a fairly large MS SQL database (~2TB). Most of the data is in one table (~6 billion rows). Two weeks ago I dropped two non-clustered indexes on the large table and migrated the data onto a ...
0
votes
1answer
116 views

SQL Server Merge - Pull replication error

I have a configuration problem to create a Merge/Pull replication between two databases SQLServer 2012. The machine Publisher is a Windows Server 2008 R2 not in windows domain, this Server is also ...
0
votes
0answers
16 views

SQL Server rotating Azure backups

SQL Server 2012 SP1 CU2 allows backing up databases into the cloud: BACKUP DATABASE myDatabase TO URL = 'https://mystorageaccount.blob.core.windows.net/mycontainer/myDatabase.bak' WITH CREDENTIAL = ...
0
votes
0answers
142 views

Backup Exec 2012 not backing up SQL logs

I am unable to make BUE 2012 backup (and truncate) the SQL Logs from our Microsoft SQL 2005 and SQL 2008 database servers that are set to FULL mode. No errors are being reported, but the Transaction ...
3
votes
2answers
171 views

SQL Server backup compression vs 7zip

Moving to SQL Server 2012 Standard Edition from 2008 Standard Edition, I was hoping to ditch my scripts that use 7z to compress backups in favor of built-in backup compression. I find that the SQL ...
0
votes
1answer
26 views

delta in global sequencing for SQL Server RML utilities - anyone?

I'm having a hard time trying to get ostress from SQL Server's Microsoft RML Utilities , to work with delta timing for the events. It's a capability that seems to be deprecated (as per the help file) ...
0
votes
1answer
1k views

RESTORE detected an error on page (0:0) in database <database> as read from the backup set

I'm attempting to restore a SQL Server 2012 .BAK file to my local server. I've successfully restored this .BAK file before. However now, when I try, I get the following error: RESTORE detected an ...
0
votes
2answers
110 views

SQL-Server SQLEXPRESS slower then real SQL 2008 Server?

I got my first bigger project with around 150 users at every day since a week. For my smaller projects like a company homepage with 100 visits each day, I installed the free sqlexpress. Now it all ...
-1
votes
1answer
32 views

Why is SQL Server seperate from the roles in Windows Server 2008 Server Manager?

I have an instance of Windows Server 2008 running on my machine. Within the OS there is a useful application called Server Manager, where I can manage several roles for my machine (such as web server, ...
0
votes
0answers
305 views

Very simple Update query hanged on one database but not on a mirror

A little background I am working with an ASP.NET MVC ERP-like Intranet application. It uses the Entity Framework technology for data access for a MS SQL server. We have 3 versions of the application ...
0
votes
0answers
20 views

BCM database accessable for all but ONE computer in domain

I have a small network of 6 computers running the latest version of good old WinXP and a Ubuntu Linux machine acting as PDC for the domain. All machines have MS Office 2010 Professional installed. ...
0
votes
1answer
109 views

SQL Server Trace keeps outputting files

A consultant has come and gone to do some audit on our SQL server, and has left a bit of a mess here. The problem is that he did things that we don't know anything about. In the C:\Program ...
0
votes
1answer
276 views

Failing SQL Server Cluster installation, Addnode: Remote registry call failed

I'm adding a node to a SQL Server failover cluster. The installer throws the error "Addnode: Remote registry call failed. Unable to retrieve primary node Filestream settings" when adding node two ...
1
vote
1answer
26 views

Lab 2012 Hyper-v migration from esxi

I need some clarity on the hyper-v virtualization strategy coming from ESXi 4.x. Purpose: A VM for Sql Server 2012 w/ SP1 A VM for Sql Server 2014 CPT1 Hardware: Poweredge T100 8GB RAM, 2 SSDs ...
0
votes
1answer
46 views

How to restore a database removing the filestream data

I have a 50GB SQL Server 2008R2 database backup. I'd like to restore only the "tables" and not the filestream data (the blobs saved as filestream). This is because I fon't have 100GB free (50 needed ...
0
votes
0answers
159 views

A connection was successfully established with the server, but then an error occurred during the pre-login handshake

While i was logged in SQL server following error was occurred : A connection was successfully established with the server, but then an error occurred during the pre-login handshake. (Provider: SSL ...
1
vote
2answers
49 views

SQL 2008 - Local only connections

I'm running SQL 2008 on a Rackspace VM. I want to lock it down so that SQL will only accept connections from processes on the local machine, can I configure this in SQL itself or is it a firewall ...
-1
votes
2answers
318 views

Can there be two machines with the same server name (SQL SERVER) in the same network? [closed]

I have a program in excel that connects to several sql servers using servername and instance. My question is, what would happen if there are two servers (machines) with the same servername in the same ...
0
votes
1answer
52 views

How can I troubleshoot an application connecting to SQL Server

I'm trying to get ASP.net StoreFront to Connect to SQL Server Express 2005, on Windows Server 2008. I followed This Microsoft Support article without success. Below is the error. [SqlException ...