1
vote
1answer
350 views

SQL Server 2008 R2 Express single CPU core usage and need of upgrade to SQL Server 2014 Express

In our office we are using SQL Server 2008R2 Express which is installed in Windows server 2012. The SQL Server database is accessed by more than 60 users in network simultaneously. In recent days we ...
1
vote
1answer
170 views

SQL Server - Service User Accounts and Licensing?

Maybe this is the wrong place to post, since its not necessarily sql server related, but here goes. If I want to setup some service user accounts in the domain to use to run sql services like the sql ...
1
vote
0answers
282 views

Error installing Clustering with SQL Server 2012 on Windows Server 2012

We are installing SQL Server 2012 on Windows Server 2012 and trying to accomplish clustering. We've setup all the core functionality on the servers: advanced cluster preparation on all nodes and ...
1
vote
1answer
1k views

How to diagnose what is causing DB timeouts [closed]

I'm a web developer which currently has the joy of managing a client website that is still using Classic ASP that uses SQL Server 2000. The code is quite old and in the process of been updated to a ...
0
votes
1answer
2k views

Does “use AWE to allocate memory” do anything on a SQL Server 2008 R2 64bit Windows 2003 system?

After checking the box I noticed that queries that would timeout after 30 seconds would complete execution. The TechNet article says "AWE is not required and cannot be configured on 64-bit ...
3
votes
3answers
168 views

Is it possible to setup failover clustering between a 32 bit instance and a 64 bit instance?

I am attempting to setup a couple of virtual machines in my lab for testing failover clustering on SQL Server 2008 and Windows Server 2008. One of the hosts I have is not capable of running a 64 bit ...
0
votes
1answer
201 views

Is the [NT Service\SQLSERVERAGENT] a supported type for SQL Server Agent service?

Reading and re-reading MSDN "Select an Account for the SQL Server Agent Service". NT Service\SQLSERVERAGENT is not listed in the "Supported Service Account Types" section. And, if not, what is it ...
0
votes
1answer
161 views

Installing SQL Server 2008 R2 Express on Server 2012 - Could not load file or assembly

I'm trying to install SQL Server 2008 R2 Express Edition SP2 on Windows 2012 server. The error is: Any clue?
0
votes
1answer
52 views

Software for working with SQL Server databases in Windows Server 2008 [closed]

We have an ASP .NET project that uses SQL Server that we host on a Windows Server 2008 machine. Where does Microsoft keeps its documentation for the tools that can be used for administering SQL Server ...
1
vote
1answer
6k views

The value could not be converted because of a potential loss of data

Let me start out by clarifying that this is not a duplicate question, nor a potential duplicate for that matter. I have tried implementing every answer to every single variant that already exists of ...
3
votes
3answers
7k views

Moving SQL Server to different domain

What are best practices/important steps when the Windows Server machine hosting SQL Server 2008 R2 is moved to another domain? What steps definitely/might need to be done for SQL Server before and ...
2
votes
3answers
2k views

SQL Server service shutdown due to 'bad?' SSL cert

This morning it transpired that SQL Server 2012 service running on Win2012 had shut itself down. When I logged in as the server admin and tried to access SSMS, after entering my credentials I got the ...
8
votes
3answers
766 views

I'm using the SQL Server Agent to schedule even non-database tasks - is this a bad idea?

Since I'm a DBA (and in many cases, the de-facto sysadmin), SQL Server is installed on pretty much every server I have to work with regularly. I realized recently that I've been using the SQL Agent as ...