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
1answer
51 views

What is the location of the SQL Server Fallback Certificate?

We are required to use encryption with SQL Server, so we have enabled ForceEncryption. According to the documentation, if a certificate is not provided, SQL Server will generate its own internal ...
0
votes
0answers
22 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. ...
1
vote
1answer
104 views

Setting up a SQL Server 2012 Failover Cluster Instance on an Azure VM

I'm trying to set up a test lab in Windows Azure for a SQL Server 2012 Standard Failover Cluster. When deploying a SQL Server 2012 VM through the gallery, the instance that's created is pre-installed ...
0
votes
0answers
65 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 ...
1
vote
1answer
44 views

Colliding/overlapping full and differential backups in SQL Server

I am trying to set up a monthly full backup and a daily differential. The full backup is currently on the 1st, but I might change it to the first Saturday. I need to retain full backups for a few ...
0
votes
1answer
52 views

How can I view the SQL Server database created by an ASP.NET MVC web application?

I have an ASP.NET MVC web application deployed to IIS on a Windows Server 2012 machine. When the application first starts, it will create the database and tables it needs if necessary. This all ...
1
vote
1answer
28 views

SQL: name without a login name

I have noticed that when I open SQL server enterprise manager and I navigate to the list of users under a specific DB, I found users with"Name" but some have no "Login Name" value. What does this ...
0
votes
1answer
71 views

SQL Server 2012 Reporting Services need to repair

I had SQL 2012 installed with SSRS. Then I was playing with IIS and deleted (I think) ReportServer aliases and webs Now I need to work with SSRS but can't figure out how to return it back. Service is ...
0
votes
1answer
35 views

SSRS 2012 SharePoint-Integrated mode

We have a 2-server (web and app server plus a database server) SharePoint 2013 farm. We would like to add SharePoint-integrated mode SSRS 2012 to it. We were thinking of installing SSRS SharePoint ...
1
vote
3answers
67 views

SQL Backup Is Taking All My Hard Drive Space

I have a job that I run every day to backup my SQL database. I just bought a band new server and was going to transfer the database backup over to the new serer and restore it. Our database isn't as ...
0
votes
0answers
23 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 ...
2
votes
4answers
259 views

Suitability of DL380p-Gen8 + D2700 for SQL 2012 Standard Edition

A question for those who know about HP server performance and SQL... I am trying to spec a suitable server that has the following requirements: Run SQL 2012 Standard Edition (I cannot get approval ...
1
vote
1answer
34 views

Failover clustering or Network Load Balance on windows server

I have 2 servers with Windows 2008 R2 standard OS. I need to create a cluster in case on of the servers goes down ; so the other one will continue provide services. The services we mostly use are a ...
1
vote
1answer
42 views

Does converting a disk from basic to dynamic require a reboot?

I'm finding conflicting info on converting a disk from basic to dynamic and have a few questions. Will it require a reboot? The server with the disk in question is hosting SQL Server 2008 R2, and ...
0
votes
2answers
91 views

Less than 10% Free Space on Database Server

2-weeks ago one of our web servers CPU Usage started bottle-necking lot at 100% for long periods of time when an application runs and requests "sqlserver.exe"..When this app runs and does its ...
0
votes
0answers
22 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
1answer
48 views

Internal Office Domain and External Server Domain Trusts

I have a single office domain - internal with an external IP address. This server is our office active directory running windows server 2008r2. (AD : PPInternal) With that, I have a private cloud ...
1
vote
1answer
562 views

Why does my SQL Server use AWE memory? and why is this not visible in RAMMap?

We have a Windows Server 2008 R2 (64-bit) 8GB server where, according to Sysinternals RAMMap, 2GB of memory is allocated using AWE. As far as I understood, this means that these pages stay in ...
1
vote
1answer
148 views

MS SQL Server configured for secure (SSL) connection allows non-secure connection from JDBC Client

I need to connect to the MS SQL Server 2008 r2 using the secure communication. I have been able to do the same using the following connection string: jdbc:sqlserver://<<db server ...
0
votes
0answers
31 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 ...
-1
votes
1answer
39 views

How to create a new sql server instance without installation media

I'm relatively new to SQL Server installations ( however I use extensively the Management Studio), the situation is that I have a server (machine) where the SQL Server has been installed ( not by me ...
0
votes
2answers
23 views

Do you have to fully install SQL Server if you want a .NET application to do a remote connection?

I have a .NET application that connects to a local SQL Server 2008 database. Now the application is changing to connect to a remote database. My question is, if I'm going to install this application ...
1
vote
2answers
214 views

Can remote queries cause locks?

We have a SQL Server 2005 (SERVER-A) server that holds the database for an application that has been locking a lot lately. We suspect that the problem are transaction locks, so we decided to capture ...
0
votes
2answers
47 views

Does it change anything when I disable obsolete parameters in SQL Backups? SKIP , stats, Nounload , norewind etc

I am pretty new in managing Computersystems but I always want to know everything to get out the maximum. When we last time deployed a new version of our application I was given a backup script to ...
0
votes
1answer
32 views

SSPI authentication error and untrusted domain with valid account

I am developing a program in .Net and it works great in the development environment. It connects to a few databases (SQL Server) and uses SSPI authentication to do so. When I move this program local ...
-1
votes
2answers
62 views

Secure communication between two hosted dedicated servers? [closed]

I'm planning to host a site on a pair of dedicated servers (both running IIS/SQL Server with SQL replication). Since the hoster only provides a public IP on each machine, how would I secure ...
0
votes
0answers
70 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. ...
2
votes
3answers
154 views

Is it okay to put applications on an Active Directory secondary server? What pitfalls?

I have a fixed number of VMs in my Windows/IIS website setup, which I cannot change in the short term: a web server, which is badly overloaded from a memory and cpu load standpoint (IIS6, Server ...
3
votes
1answer
231 views

How to Rename a Database on a SQL Server Amazon RDS Instance?

Attempts via SQL Server Management Studio and Transact SQL to rename a database hosted on a SQL Server Amazon RDS instance result in the following error. User does not have permission to alter ...
1
vote
1answer
288 views

Install MSSQL and .Net Framework 3.5 in Windows Server 2012

I have downloaded Windows Server 2012 VHD (Hyper-V VM) and wanna install MSSQL 2012 in it. But it's failing asking for "NetFX3". Googling about it I discovered it's .Net Framework 3.5 and lots of ...
3
votes
1answer
165 views

Why do I get prompted for “Data Source Credentials” when editing a SSRS report for SCCM?

When attempting to add a dataset in Report Builder I am prompted to "Enter Data Source Credentials." Choosing "Use the current Windows user" fails, and I don't have the password for the specified ...
0
votes
2answers
63 views

Possible to take a backup of SQL Server 2012 DB and restore on 2008?

I want to take a backup of SQL 2012 and restore on 2008, is that possible ? I have this options which I can't change on DB. Thank you
1
vote
1answer
35 views

Protecting SQL from Profiling

We have some sensitive IPR in some Stored Procedures. We encrypt the stored procedures. However, at the point they are created, they are plain text. Is there anyway we can prevent SQL Server Profiler ...
0
votes
0answers
39 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 ...
1
vote
2answers
92 views

Spoof database connection to be local instead of remote

I am trying to connect one of our clients "as is" programs to a remote database instead of a local one, they think that they have coded it to work that way, but for some reason the program crashes ...
0
votes
0answers
45 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 ...
2
votes
0answers
35 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
22 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
103 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
66 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
55 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
155 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
53 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
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
60 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 ...