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)

0
votes
1answer
283 views

How to rebuild MS Agent Jobs from MSDB table?

This morning our DB server died. They restored backups to another server but these didn't include the many MS Agent jobs. Anyway I have managed to get a backup of the old MSDB table where all the ...
2
votes
1answer
339 views

Index reorganizing slow after index rebuild with MS SQL

Why does index reorganizing take 3 times longer after I make an index rebuild? I wasn't sure if this happens every time, so I made a test for the last month. I configured SSMS to execute Index ...
1
vote
1answer
1k views

Can't rebuild master DB on MS SQL Server 2005 Express after power failure

There has been a power loss on our server and I cannot start the SQL service because the master DB is corrupted (as the log states). I found many articles recommending running the setup.exe with ...
1
vote
0answers
29 views

SQL Server Connection Issue with New Router But Works With Old Router

I have an issue that really has me stumped. I have a router that is overheating and needs to be upgraded. When I connect the new router and configure it with the same DHCP settings and IP ranges as ...
9
votes
1answer
64k views

What is a SQL Server instance?

When I install SQL Server 2008 Express in prompts me to create an instance and aborts if I don't. Then I see that information in an entry in Sql Server Configuration Manager on SQL Server Services. ...
-1
votes
2answers
187 views

MSSQL 2008 r2 Express: there is insufficient system memory in resource pool 'internal' to run this query

I'm experiencing this error during the lifecycle of my DotNetNuke Installation. I've change the hosting server and now I've got a Windows Server 2012 with IIS 8 an SQL server 2008 r2 Express running ...
2
votes
1answer
474 views

Define priority of database access into SQL Server 2008

We're using a SQL Server 2008 database. This database provides data for two main applications: A website to display a Viewer. A routing application that needs to be highly responsive ! Is it ...
3
votes
1answer
90 views

High Available SQL Server without SAN by using AlwaysOn feature

I have two Microsoft SQL Servers (v 2012) and I want to make them mirror and when one of them goes down the second one will be replaced. AlwaysOn is a new feature in SQL Server 2012 that is ...
4
votes
2answers
7k views

How to temporarily stop time syncing with domain controller?

I wish to do some testing on my local machine which requires me to put the date forward a year. So I can test some stuff in SQL Server (i've found it not possible to override the sql server time). ...
0
votes
0answers
57 views

Server high memory and cpu - no leads

I've been asked to troubleshoot a server hosting our application at a client's facility. The client has complained to us on two separate occasions in the last week - week and a half. In one instance ...
2
votes
1answer
160 views

Change SSL Protocol in MSSQL 2012

Is there a way to change the SSL Protocol support in MSSQL express 2012 on windows 2008R2 ? I want to change the protocol from SSL3 to TLS (1.0,1.1,1.2), after hours of looking I cant find ...
5
votes
4answers
6k views

Does restoring a SQL database from backup rebuild its indexes?

Does restoring a SQL database from backup rebuild its tables and indexes from scratch? Or does it keep it in the same internal physical order it was in at the time of backup? We're using SQL 2000 ...
1
vote
1answer
53 views

Windows Server 2012 R2 Virtual Switch

We have an Dell R510 that has Windows Server 2012 R2 Core installed. We are having a problem where the guest VMs are losing their network connections but will come back after a couple of minutes. The ...
0
votes
3answers
155 views

Running IIS and Virtualized SQL Server on same machine

I work for a small organization within the government. We maintain our own Windows Server 2003 web server on the the govt. DMZ. We have to migrate to Windows Server 2008 or 2012 by July. ...
2
votes
2answers
1k views

how to include error messages into backup reports for SQL Server 2008 R2?

Right now I have daily (differential) and weekly (full) backups set on my SQL Server 2008 R2 as jobs for SQL Server Agent with email notifications if job fails. I do get emails like this: JOB RUN: ...
0
votes
1answer
849 views

long access times and errors in iis application

I am having an issue with an IIS application (details of environment at the end of the message). The web site works great most of the time and I cannot reproduce any error in our test system. On the ...
1
vote
0answers
30 views

What are the network prerequisites for Windows Azure Pack

I have followed many articles to install and config windows azure pack distributed, But every time I finish configuring everything, the azure pack is not working and give me different errors, seams to ...
0
votes
2answers
40 views

Migrate MSSQL 2008R2 to 2012 (new hardware)

Since hardware support for our server ends we are migrating to a new hardware and simultaneously upgrading MSSQL 2008R2 to MSSQL 2012. I searched a little bit and found some guides, but they all ...
16
votes
2answers
8k 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
32 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
760 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
4k 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
48 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
35k 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
772 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, ...
3
votes
3answers
2k views

SQL Server Windows Authentication fails after tonight's security updates: The login is from an untrusted domain

We have the following setup: One Domain Controller (DC, Server 2003 R2 Standard x64) One SQL Server (SQL, Server 2008 R2 Standard x64) some clients. All machines are in the same domain. All user ...
8
votes
2answers
1k 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
565 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
227 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
40 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
68 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
13k 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
345 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
2k 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
7k 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
1k 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
50 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
23 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
773 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
43 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
53 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
60 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
38 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
3k 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
63 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
95 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 ...