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)

16
votes
2answers
9k views

Windows LocalSystem vs. System

http://stackoverflow.com/questions/510170/the-difference-between-the-local-system-account-and-the-network-service-accou tells: Local System : Completely trusted account, moreso than the ...
-1
votes
1answer
39 views

Windows update 2919355 causes our SQL based app perf to drop to 1/6 of previous perf

We have a VB6 app calling out to a local SQL2008R2 instance. We have had complaints about it's performance dropping considerably. After a lot of experimental research, we have determined at least 1 ...
1
vote
2answers
784 views

How to remove dead SQL Server registrations from SQL Server 2000 Enterprise Manager?

We had some databases decommissioned recently, and my SQL Server 2000 Enterprise Manager still shows the server group I originally created containing those servers. I tried deleting the entire server ...
1
vote
4answers
5k views

DSN, ODBC: How to create DSN using different windows account

Is there a possibility to create DSN (ODBC to SQL Server) using different Windows account than current coputer login account? I’m trying to create System DSN to SQL Server and I would like to create ...
0
votes
1answer
60 views

Upgrading SBS 2003 Premium (with SQL server) to Essentials 2012 R2

As support (and running on old hardware) is fading out for SBS 2003, we are considering upgrading to essentials R2, as suggested by microsoft. The exchange environment will be migrated to Office365, ...
4
votes
6answers
39k views

SQL - an error occurred during the pre-login handshake

Until yesterday evening, I was able to connect to my server from my local machine. Now, I get the following error: A connection was successfully established with the server, but then an error ...
1
vote
1answer
808 views

Unexplained CPU and Disk activity spikes in SQL Server 2005

Before I pose my question, please allow me to describe the situation. I have a database server, with a number of tables. Two of the biggest tables contain over 800k rows each. The majority of rows ...
0
votes
1answer
40 views

Automatic log truncation when scripting from SQL 2008 to 2005

I have to convert a sql server 2008 database to a sql server 2005 database. As far as I understand it, the only reliable way to do this is by scripting the database to an earlier server version. Now, ...
8
votes
2answers
2k views

Should I encrypt OS disk with BitLocker for HIPAA compliance

I am looking into hosting a HIPAA compliant web application on Azure VM's. For the database, right now I am leaning towards using a VM with SQL 2014 Standard Edition. Since TDE is not available with ...
2
votes
5answers
577 views

Load estimation for an ASP.Net / SQL Server application

Are there any heuristics to define server requirements for typical applications? Coming from internal development to a handful of users, this is our first deployment of a internet application. ...
3
votes
4answers
231 views

“Catch All” Server-Side Load Profiling

If I have an infrastructure with some Web Servers (Windows 2003 and IIS) and a Database (SQL Server 2005) and ASP.net, I wonder if there is a catch-all tool that simply allows me to say "Ok, I now ...
0
votes
1answer
1k views

SQL server corrupt page

i am getting the following error when i try to select data from a table. SQL Server detected a logical consistency-based I/O error: incorrect pageid (expected 1:6380; actual 0:0). It ...
2
votes
1answer
1k views

Why are SQL Server pages 8 KB?

According to Mark Russinovich's Windows Internals 5th Edition, Windows uses (small) page sizes of 4 KB on both x86 and x64 architectures to manage memory. Even though I can't find a reason for this, ...
2
votes
1answer
85 views

Are there any other causes of this error that are NOT related to initial setup?

I'm trying to diagnose an issue at a customer site. They are receiving the following error: A network-related or instance-specific error occurred while establishing a connection to SQL Server ...
0
votes
2answers
47 views

What the permission required to view all the permissions on a given database?

What permission can grant the right to view all the permissions on a given database? In my current context, the support team of a piece of software need to be able to investigate the cause of ...
3
votes
1answer
102 views

SQL Server 2008 Restored Database allows differential backup when no full exists

I restored a backup file (it's used as a template for new databases) as a new database. Normally as part of this process, I take a full backup after the restore, but this time I was called away on ...
11
votes
6answers
14k views

How does changing Windows SID affect SQL Server?

Our Windows admins have identified an issue with the way that they clone Windows servers. Apparently some of the cloned servers end up with the same SID at the OS level. I hear Microsoft doesn't ...
1
vote
2answers
480 views

Configuring PHP and Mediawiki to use Microsoft SQL Server?

I have PHP 5.6 x86 installed on Windows 7 to C:\PHP. IIS is successfully running PHP and MediaWiki when it's configured to use MariaDB. I'm trying to get it to work with MS SQL Server and it's not ...
6
votes
2answers
3k views

MediaWiki on MS SQL Server

I've been doing some digging on running mediawiki on sql server instead of MySQL, but haven't come across any concrete information. All of our servers are running SQL Server so I'd like to stick with ...
6
votes
1answer
8k views

Will SQL Server 2012 install + run Windows 2003

I can't seem to find any information but can I install SQL Server 2012 Standard Edition on a server running Windows Server 2003 R2 x64? I don't intend to use this for production just for testing and ...
-1
votes
1answer
2k views

Restore SQL Database From BAK File using a SQL Query

I have my database backing up to the hard disk in the format of BAK file. I am trying to restore that backup, but I unable to do so. Here is my query: ALTER DATABASE DBASE SET SINGLE_USER WITH ...
0
votes
1answer
83 views

SQL Server - Cant connect to instance with either windows auth or SA account

I have just installed SQL Server 2012 and I cannot connect to the new instance using any method. The instance is MSSQLServer I have attempted \MSSQLSERVER, .\MSSQLSERVER, localhost\MSSQLSERVER and ...
0
votes
0answers
30 views

MSSQL 2005 - Server Service unable to start while installing

I am trying to install MSSQL 2005 Express on an VM running Windows Server 2012. I get to the point where it installs everything but fails to start the service. I have tried checking the Log-On ...
2
votes
2answers
780 views

Re-downloading Microsoft SQL Server 2008 Standard because of license issues?

I have many clients who have purchased Microsoft SQL Server 2008 Standard. Unlike other Microsoft software, there is not a serial number provided for each customer to install the software. ...
1
vote
1answer
48 views

Port 1434 - Company Website hosting blocking us

We have a small network setup on a Windows Domain. We also have a company website that has the same domain name - but is actually not in any way on the domain - it's hosted elsewhere on a cheapo ...
0
votes
0answers
71 views

How do I migrate a database between servers from SQL 2008 Std to SQL 2014 Std using T-SQL without losing data?

What is the process using T-SQL to copy/move/relocate a database from one server to another? Do I need to take a log backup on the source as well and restore it on the new server? I am pretty sure ...
0
votes
0answers
65 views

Upgrading SQL Server from 2008 to 2012 doesn't respect existing install paths

Basic Information : Running Microsoft Windows Server 2008 with MS SQL Server 2008 (version 10.0.5869), trying to upgrade to SQL Server 2012. Currently working in a cloned VM of our production server ...
0
votes
1answer
44 views

AWS Command Line - Query Instance MS SQL Version

My AWS account runs approximately 50 instances. They all run Windows, but they vary between being just Windows, or running SQL Server STD or SQL Server Web. I'd like to find a way of exporting all ...
3
votes
1answer
4k views

Why can't I connect on port 445?

I need to collect baseline performance data on a SQL Server running on Windows Server 2008 R2. When I open perfmon on my computer running Windows 7 and try to add counters from the remote server, I ...
0
votes
0answers
83 views

Single node SQL Server 2014 cluster at DR environment

We are setting up a new Disaster Recovery environment. On Production we have SQL Server cluster with two nodes. For DR we decided that one node should be enough. The plan is to add the second node ...
1
vote
2answers
114 views

TCP traffic on port 1433 blocked by NAT rules

We have a SQL server that is hosted on AWS, the SQL server it not directly accessible on the internet, it relies on a NAT box to route traffic to it. We are trying to set up a Linked SQL server from ...
1
vote
4answers
1k views

Why upgrade from SQL 2005 to SQL 2008 R2?

have been tasked to write a document outlining the best reasons to use SQL 2008 R2 instead of SQL 2005 for my brand new BI project. We have a policy of only using two versions at a time and there are ...
2
votes
2answers
87 views

Windows Server Administration - which services are safe to run internet facing?

Coming from a Linux background and now having to manage some Windows servers (2008R2 & 2012R2) I'm wondering which services are safe to run directly over the internet. The servers are all internet ...
0
votes
1answer
217 views

How to upgrade an RDS SQL Server Instance to an SSD

I'm trying to upgrade my RDS SQL Server 2012 instance from magnetic storage to an SSD. It is an instance class of db.m1.large with bring your own license. I've tried modifying the storage type, but ...
0
votes
0answers
111 views

FIPS 140-2 on Windows 2012R2 with SQL 2014

I'm attempting to set my Microsoft SQL 2014 instance to use FIPS 140-2 complaint encryption as described in this KB article for SQL 2012, but it does not appear to be working. I do not see "FIPS" ...
1
vote
1answer
59 views

Will a SQL incremental backup work for my purposes?

We are transitioning a large amount of data, in the form of a SQL database, from one location to another and the data transfer speeds are very slow but we want to cause as short of an interruption of ...
7
votes
5answers
216 views

How much effort is SQL Server 2008 Administration? [closed]

I am looking for a suitable hosting environment for an ASP.NET MVC application. One of the options I have is renting a Hyper-V server and installing my license of SQL Server 2008 on it. I'm a bit wary ...
0
votes
0answers
108 views

Configure Microsoft Sql Server Reporting services to redirect to ssl

I'm setting up an SSRS 2014 install, and I would like to make everything SSL by default. Getting SSL running isn't too hard, but for some reason there seems to be no easy way to redirect the http ...
1
vote
0answers
13 views

Should I back up full-text catalogs?

I am developing a small app for SQL Server database backup (version > 2005). I intend to use VSS snapshots (component based) to back it up and supported modes are Full & differential. Is it ...
1
vote
1answer
871 views

How to filter columns in SQL Server replication?

I need to replicate some data from two tables in one database to another databases. I used snapshot replication. The issue is that I would like to replicate only some selected columns and the others ...
1
vote
1answer
192 views

Is it possible to store a credential for Windows Authentication to an Analysis Services server?

SQL Server Analysis Services uses Windows authentication for server connections. Typically, you assign your domain account to a role (or the server administrator list), and then connect to the server ...
3
votes
0answers
57 views

Update SQL Service Pack Named Instance

I have an existing SQL 2008 R2 on SP3. Have another instance in use that is SQL 2008 R2 SP1 I need to update the named instance with sp1 to sp3 but i'm not getting any options. It tells me my version ...
1
vote
3answers
4k views

Is it safe to restart Sql Server Agent?

I've found myself in the tenuous role of a developer tasked to manage a SQL server. I've set up some jobs to run on a schedule, but would like to receive email notification on completion. I've set ...
0
votes
1answer
130 views

Is there a way to kill a range of session ids (connections) in ms sql server?

i was wondering if there is a way to kill a range of SQL Connections on an Microsoft SQL DB. If i want to kill a single session id i can use kill [session-id]; go;. If i want to kill all sessions i ...
1
vote
1answer
125 views

How do I use a domain account to connect to a MSSQL server for NPS accounting?

I'm trying to connect a Server 2008 R2 NPS to a MSSQL server for logging accounting data and I'm running into issues. I configured NPS Accounting through the "Configure Accounting" wizard and, using ...
0
votes
1answer
116 views

Unable to connect to SQL Server on live server

I have a copy of my client's database and website on my computer. There's also a matching copy of both online where my client's customers will use the website. When I test my local copy of the ...
1
vote
1answer
35 views

Error when using sp_addscriptexec

I have tried to run the following command on my server that is using sql 2008 merge replication sp_addscriptexec MyPub, '\\my-server\MSSQL\updateTablePermissions.sql', 1 and I get the following ...
2
votes
5answers
5k views

SQL Server 2008 - 2005 Compatibility

I want to use SQL Server 2008, but I'd also like to maintain a fall back position of switching back to SQL Server 2005. I know I cannot backup 2008 to restore 2005 and detach/attach won't work - what ...
1
vote
2answers
1k views

How to achieve the following RTO & RPO with logshipping only using SQL Server?

Trying to come up with viable backup restore & logshipping solution for achieving the following: 15 minutes Recovery Point Objective (no more than 15 minutes data loss at any time) 5 minutes ...
0
votes
2answers
252 views

SQL Log Shipping Two Databases using the same shared folder

I will configure Log Shipping for more than 1 database on single a server. And I wan't to know If I can use a single Shared Folder or if I have to create a Folder For Each Database. What I mean is: ...