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
33 views

SQL Server : Improve SIMPLE SELECT to retun 2 LAC Rows faster?

We have a stored procedure in which we are creating a temp table which has more than 200,000 rows with 30 columns (2 of DATETIME, 4 of INT, 5 of [numeric](20, 3) and rest of VARCHAR(500) data types. ...
0
votes
0answers
116 views

sql server, group by then count, 25 million rows per month, feasibility

So. We are doing some analytics in a scale I have no experience with. We have to extract some aggregate numbers and data from a whole bunch of server logs. (Estimated at 2gig a month total). I'm ...
0
votes
0answers
26 views

Can't Find SQL Server 2008 R2 SP2 uninstall option

Supposedly, the method to uninstall a service pack to SQL Server 2008 R2 (and other versions after a certain point) is through Control Panel > Programs and Features. I think it's supposed to be ...
0
votes
0answers
26 views

Reporting Services layout changed

I have a new SQL 2012 Reporting Services installation on Server 2008 R2. I logged into the site using Internet Explorer 8 and it is now appearing like this. Does anyone know what is causing this and ...
0
votes
0answers
43 views

SQL Server 2008R2 multi instance Cluster with mutual active/passive

I'm looking for a way to set up an 2008R2 SQL Server with an multi instance Cluster which serves mutual active/passive. So basically two nodes where each one holds half of the databases active and ...
0
votes
0answers
261 views

SQL Failover Cluster Resource DNS Registration Failure

I've got a cluster I migrated from one location to another (new IPs). I've moved a few other clusters like this recently with no issues. This recent cluster all came up fine except one 2012 instance. ...
0
votes
0answers
69 views

MSSQL on AWS RDS - Should I be worried about falling freeable memory?

My question is similar to What is "freeable memory"?, however we are using MSSQL on RDS, as opposed to mysql. We are seeing a consistent downward trend in freeable memory. Currently sitting ...
0
votes
0answers
71 views

SQL database instance cannot be set to SINGLE_USER

I am trying to make my database Single User Mode and I tried executing this: ALTER DATABASE [db] SET SINGLE_USER WITH NO_WAIT and it returned: Option 'SINGLE_USER' cannot be set in database ...
0
votes
0answers
406 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 ...
0
votes
0answers
86 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
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
16 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 ...
0
votes
0answers
54 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
0answers
84 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
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
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
192 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 ...
0
votes
0answers
347 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
23 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
0answers
169 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 ...
0
votes
0answers
292 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 ...
0
votes
0answers
89 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 ...
0
votes
0answers
45 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
34 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 ...
0
votes
0answers
64 views

Need UTF-8 support with PHP/MSSQL-Constellation (FreeTDS)

We have a PHP 5.2 installation and lacking of the FreeTDS support to use the UTF-8 compilance to the MSSQL-Database, is there a way to get FreeTDS into PHP ?
0
votes
0answers
64 views

Azure SQL Reporting Services - cost and options

At the moment, it costs $119 per month to use Azure SQL Reporting services. We want to make the move to Azure SQL Reporting/SSRS as our reporting capabilities are expected to grow quite dramatically ...
0
votes
0answers
86 views

Server infrastructure for busy e-commerce site built on MVC4 using MSSQL and Solr

What kind of server architecture do I need for this kind of application to make it more reliable. eCommerce application with abt 100,000 product with moderate to heavy traffic. The site performs very ...
0
votes
0answers
68 views

Errors after moving DB from server

I am moving a database (MS SQL Server) from a server to a new one (virtual machine). Running CHECKDB on the original server I get no errors, the DB is OK. After moving the DB to the new server and ...
0
votes
0answers
168 views

SQL Server Cannot see tables in Object Browser where Login = db_owner

A colleague is trying access a particular SQL Server over a remote link. He can login to the server (via SSMS) with the SQL Server credentials I supplied, but although he can view tables/etc in the ...
0
votes
0answers
57 views

Identical tables, different sizes?

I have transactional replication with updatable subscriptions going between a few SQL 2008 R2 servers (publisher is Enterprise, subscribers are Express). I need to add another subscriber, and come to ...
0
votes
0answers
39 views

Inserted 3k rows into MsSql, now querying them times out

I have a table which had about 4k rows, then I inserted 3k rows from another table into it. The import have caused me problems, querying for new data never seems to finish. And I cannot figure out how ...
0
votes
0answers
78 views

Can't select database for transaction log backup in maintenance plan

I am running into a problem while trying to save a transaction log database backup maintenance task: Add the 'Back Up Database Task' to the maintenance plan. Edit the task. Select backup type: ...
0
votes
0answers
29 views

SQL server Error

I am trying to load the data from text file to database table by running a job. Sometimes its giving an error like "Failed at split file".. Can anybody suggest on this how to overcome this error.
0
votes
0answers
136 views

to overwrite a table or update it?

I've had situations where there was a large feed I was taking in that basically overwrote a table in the db. This tabled information was queried a lot. If Sql Server uses memory to store the queried ...
0
votes
0answers
54 views

AppFabric vs AD LDS

I'm helping design a solution for a huge organization which relies on a SQL cluster. If this cluster is unavailable, the entire organization will not be able to authenticate to printers. there are ...
0
votes
0answers
517 views

Creating database from Entity Framework and Code First create database error

This got kicked off of Stackoverflow as off topic. I was told to post here so hoping you guys can help me out. I'm running on MSSQL 2008 Express, EF5 and MVC4 My web.config file looks a bit like ...
0
votes
0answers
156 views

Getting “error: 26 - Error Locating Server/Instance Specified” all of a sudden

Alright, a little explanation. I have two separate PCs, both of which have virtually an identical installation of SQL Server 2012 Express on them. During installation for both, I had chosen the ...
0
votes
0answers
63 views

Moving WSUS Content - Issue with SQL Server

Im trying to gain some space on the main partition on the C:\ drive of a Win 2008r2 SBS server. Im following this guide . However, after detaching the Db ,moving it to the new partition E:\ i can't ...
0
votes
0answers
1k views

Fatal error 9001 on shared SQL Server 2008

I've asked this same question on StackOverflow, but I might actually have a better chance for an answer here so am posting here as well. I know this question has been asked here before, but none of ...
0
votes
0answers
479 views

MSSQL 2012 Error 26 and remote connection

I'm trying to set up MSSQL 2012 for a school project and I need to be able to connect to it remotely as my teammates will also be working on it. I did a clean install of SQL Server 2012 Express. ...
0
votes
0answers
134 views

cannot connect to ssms local database windows7

i am running SQL Server 2012 Management Studio Express in windows 7, i am having issues connecting to the local db. i tried all the above mentioned solutions, didnt work. please help. thanks in ...
0
votes
0answers
206 views

Unique index failed?

Recently, we've been having some kind of memory leak in SQL Server. We do have a .NET assembly running to audit our tables, but this has ran for a few years without problems, so I doubt it's the ...
0
votes
0answers
1k views

SQL Server error: Error: 802, Severity: 17, State: 20

I'm randomly getting this error while running a script... Exception calling "ExecuteNonQuery" with "1" argument(s): "An exception occurred while executing a Transact-SQL statement or batch." ...
0
votes
0answers
61 views

Reporting Server and Multiple AD Domains

We have a Database sever running Microsoft Reporting Services on our network. The users with browser permissions on the server come from our AD Domain, and from a second AD Domain we share trust with ...
0
votes
0answers
320 views

How to migrate SharePoint List with attachments to SQL Server in untrusted domain?

As part of a larger effort to migrate LiveLink and older SharePoint sites to SharePoint 2010. At the moment, my customer has multiple SharePoint lists, whose data is divided by location. Ideally, ...
0
votes
0answers
78 views

strange web app errors possibly sql server related?

apologies if this is not a good place to post this, but we are experiencing some very strange things with our web ap which is running on a SQL 2005 instance. the application is a .net web app and ...
0
votes
0answers
451 views

SQL Server OPENROWSET/OPENQUERY Issue with Access DB

Server: Win Server 2003 R2 standard x64 MSSQL: Server 2005 Standard x64 Using SSMS on the database server itself I can execute a simple select on a linked server with OPENQUERY and I can also execute ...
0
votes
0answers
128 views

inLoox is unable to connect to SQL Server

I just installed InLoox and configured a connection to our MS SQL Server 2005. The connection should be fine - telnet works and I can connect to the inLoox database with my query analyzer. My ...
0
votes
0answers
90 views

SQL Server Management Studio Express 2008 is unresponsive

I use SQL Server Management Studio Express 2008 to manage SQL Server Express 2008. It (Management Studio) was working until recently, but now on opening it just hangs indefinitely, with all the panes ...
0
votes
0answers
512 views

Estimating SQL Server network bandwidth requirements for replication

We are starting to implement replication with four different database SQL SERVER 2008 R2. All standard editions and merge replication. The problem right now is how to estimate a minimum required ...