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)

0
votes
0answers
60 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
61 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
29 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
13 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
63 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
55 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
49 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
125 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
51 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
59 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
39 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
27 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
52 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
281 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
61 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
57 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
71 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
80 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
419 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
59 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
90 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
94 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
72 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
124 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
25 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
738 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
90 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
206 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
15 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
77 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
168 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
25 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
42 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
134 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
44 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
167 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
45 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 ...
0
votes
0answers
228 views

Event ID 5586 on SP Foundation and SQL Express

I have a brand new Hyper-V VM with Windows 2012, fully updated up to today (11 Sept 2013). I installed SharePoint Foundation 2013 and additionally MS SQL Express 2012 on the same instance. In my ...
1
vote
1answer
125 views

dbcc checkdb('XYZ', REPAIR_ALLOW_DATA_LOSS) indicating that XYZ is already open and can only have one user at a time

I have a DB, XYZ, that had a corrupt log file and now since the log file is totally unusable this is rendering this specific DB unusable and I need to be able to rebuild it. I've already done a lot ...
-1
votes
2answers
260 views

SQL Server queries running more than the timeout values set in IIS 7.5 and SQL Server query timeouts

Which time out value does SQL server takes while executing the query/ stored procedure? The application time out is set at 20 minutes, the SQL Query/ command timeout is set at 10 minutes, then there ...
0
votes
0answers
44 views

Unable to launch SQL Server Configuration Manager - WMI provider issue

Hoping you can help. I am having issues opening SQL Server Configuration Manager on Server 2k3 with the following error: Cannot connect to WMI provider. You do not have permission or the server is ...
3
votes
2answers
1k views

Web app running as NETWORK SERVICE can connect to SQL Server but windows service running as LOCAL SYSTEM cannot

I have installed a .net web application on a Windows Server 2003 IIS server, running in an Application Pool as NETWORK SERVICE and connecting to SQL Server on a different machine using Integrated ...
1
vote
1answer
38 views

Can't Connect to SQL Server 2008 via sqlmd

I want to schedule a backup for my database for SQL 2008 express. I found a nice stored procedure for this job. I made a bat file for it and I want to run it, but the following sqlcmd statement fails ...
0
votes
2answers
72 views

Why is SQL Server IO so much slower than the disk capacity?

I'm running SQL Server 2012, and doing a simple SELECT * query, I can see that my disk IO in performance monitor is < 10MB/s. If I do a backup of the database, however, I see values > 200 MB/s. ...
0
votes
0answers
31 views

error in business intelligence development studio while processing cube

What i have to do to fix the following error? The project could not be deployed to the 'localhost' server because of the following connectivity problems : A connection cannot be made. Ensure that the ...
0
votes
0answers
26 views

Copy Database Wizard Attach-Detach method executes forever

I have no reputation to post my screenshot I've been copying this database for about 4 hours now. It's a 30GB size, 29 data + 1 for logs (already Shrinked). The problem I see is that the ...