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)

3
votes
1answer
1k views

SQL Server Connection Timeout after load brought onto IIS web server

We have MSSQL 2008 R2 running on windows 2008 r2 it's being hit by 2 server 2008 r2 webservers running asp.net. Both are joined to an active directory domain and use integrated authentication to ...
19
votes
3answers
48k views

What is the difference between SQL Server standard and web edition?

Is there any technical difference between these 2 editions or is it just how they are licenced?
1
vote
2answers
56 views

SQL Management Studio Can't Connect to Database---Microsoft fixes failed

I just installed MS SQL Server 2014 a couple days ago and it was working fine until today. I attempted to connect using the Object Viewer and I got the error message Cannot Connect to MyserverName. ...
1
vote
2answers
3k views

Unable to start sql service when TCP/IP is enabled under SSCM - SS Network Configuration

in the Console , SQL Server Configuration Manager I get error 10048 when start sql service and this in event history: The SQL server service terminated with server-specific error. Only one usage ...
1
vote
1answer
54 views

SQL Server 2008 local connection an error occurred during the pre-login handshake

I am getting an error while trying to connect to SQL locally either via a web application or SQL management Studio. Oddly, I can connect fine remotely via apps on other servers or SQL management on my ...
0
votes
1answer
2k views

Error: Package 'Microsoft SQL Management Studio Package' failed to load. In SQL Server Management Studio

I had installed SQL Server 2008 R2, the installation was succesful. But I can't open the Management Studio because this error is shown: Package 'Microsoft SQL Management Studio Package' failed to ...
3
votes
2answers
2k views

destination directory for SQL Server 2012 is greyed out

I tried to install SQL Server 2012 Standard on Windows 2008 and on Windows 7 (I only wanted to install management studio on Win7). Same ISO; both machines are newly built. However, on Windows 7 Shared ...
1
vote
1answer
47 views

Cannot start the T-SQL debugger when logged into a remote server via SSMS

Background information SQL Server 2012 on Windows Server 2012 Connecting to server remotely using SSMS The user I am using is in the sysadmin role Able to log in with SSMS and run queries without ...
2
votes
3answers
2k views

Can’t connect to SQL Server 2008 - looks like Shared Memory problem

I am unable to connect to my local instance of SQL Server 2008 Express using SQL Server Management Studio. I believe the problem is related to a change I made to the connection protocols. Before the ...
3
votes
1answer
1k views

How To Tell If a MSSQL 2008 Database Has Transparent Data Encryption (TDE) Enabled

Does anyone happen to know if there is a way via WMI to tell whether a MSSQL 2008 database has TDE enabled? We have a large SQL estate that I'd like to survey and find out where we have TDE enabled. ...
2
votes
2answers
4k views

AclPermissionsFacet fault install SQL-2008-R2

While attempting to do an installation repair of SQL-2008R2, I'm failing the pre-check rules. Module that is failing is AclPermissionsFacet - with this message "The SQL Server registry keys from a ...
0
votes
2answers
1k views

SQL 2008 install failed - Could not find the Database Engine startup handle

My SQL 2008 install failed, I'm getting this error: Could not find the Database Engine startup handle This happens after uninstalling SQL Server 2008 and trying to install SQL Server 2008 R2, any ...
0
votes
1answer
2k views

MySQL ADO.NET Connector & MSSQL Integration Services

Here I am, day three... attempting to sync a data view on a Windows Vista box (64 bit) running MSSQL 2012 and Visual Studio 2010. Sanity is slipping and hunger for progress fills my attention. I ...
0
votes
1answer
1k views

Firewall configuration for SQL Server 2012 Express on Windows Server 2008 R2 for Workgroup

We are attempting to configure a server application to run on Windows Server 2008 R2 using SQL Server 2012 Express. With the server firewall turned off completely the application can communicate just ...
0
votes
0answers
27 views

Biztalk 2010 BAM on SQL Server 2014

While running Biztalk 2010 Configuration targeting my local PC with MS SQL Server 2014, the BAM Tools indicate that it is unable to find "Microsoft SQL Server 2008 SP1 or later" on the machine. I've ...
3
votes
1answer
76 views

SQL Server 2008 R2 Temporary Login Issue

We have a mature SQL Server 2008 R2 server, being used from many C# web applications, each with connection pooling. Last night, all web applications lost the ability to login to the database for 6 ...
-4
votes
1answer
29 views

Setup network between 2 computers connected using wifi [closed]

In my office I have a WiFi Router that allows 2 computers to connect to Internet. I have 2 questions - How can I create a network between these 2 computers for file sharing? Can I access SQL server ...
0
votes
0answers
20 views

MS SQL driver (Azure SQL) for PHP running on an Azure Website?

I am at my wits end. I've been googling this and all I get is 2010 blog posts that unfortunately do not appear to work today. I am trying to set up PHPBB on an Azure Website which uses the MS ...
5
votes
3answers
6k views

mdf file cannot be overwritten when restoring a database in SQL Server

I got a databse A. It has some data in it. I created a backup for A as A.bak file. Then I create a new empty database B. And then I try to restore B from A.bak. But the SQL Serve tell me the following ...
0
votes
0answers
16 views

SQL Server Witness Server Alternative Approach

I have the setup below: 3 Database Servers 1 DR Database Server 1 Domain Controller 1 DR Domain Controller Currently I have the DR domain controller acting as the mirroring witness for the 3 ...
0
votes
1answer
40 views

SQL Server Multiple Instances but showing the same databases

I am running SQL Server 2008 R2 Standard Edition and need to have multiple instances which I have installed. However, when I restore a database onto one instance, it is showing up on the other ...
1
vote
3answers
2k views

Error when trying to open SQL Maintenance Plan - SSMS 2008

If I open SSMS on my client machine, connect to our SQL server, and try and open a maintenance plan on there, I get this error: TITLE: Microsoft SQL Server Management Studio Could not ...
2
votes
1answer
3k views

How do I determine what database WSUS on my Windows Server 2012 is using?

I installed WSUS on a fresh installation of Windows Server 2012 (I assume this is WSUS 4 as it is bundled with Server 2012 with no option to download it anywhere online) I did not install any ...
1
vote
2answers
28 views

Configuring PHP and WikiMedia 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 ...
12
votes
9answers
3k views

Why is it so important to backup your transaction log?

We're currently implementing a backup solution for a client and their ERP solution uses SQL Server. The ERP solution was set up by a different company. And they are telling me that it is super ...
0
votes
0answers
33 views

Network connection from old application to SQL Server 2008 R2 lost once in a while

We are trying to migrate an Axapta 2.5 database from SQL Server 2000 to 2008 R2. We are testing performance etc. on the new server, but once in a while, these two events are thrown on the Axapta ...
6
votes
2answers
9k views

Login failed for “IIS AppPool\ASP.NET v4.0” - SQL Server Web

I'm trying to migrate a website from SQL Server 2008 Express to SQL Server Web, and the website is having trouble accessing the database. In truth, Express was only ever used by running the website ...
1
vote
1answer
40 views

SQL Server 2012 and 2014 memory limits

We're in the process of building a new server with 128GB of RAM. We would like to utilise as much of this as possible and my understanding is that 2008, 2008R2 and 2012 (all STANDARD) are all limited ...
4
votes
3answers
371 views

sql azure vs azure VM with SQLServer Express

Beside beeing cheaper is there any problem/advantages to use SQL Azure vs to use a VM with SQL Express? We are looking to setup a SQL server for more than 50 websites, do you have any ...
1
vote
5answers
7k views

Remote connection sql server not working but if firewall disabled it does?

I have setup sql server express 2008 on a windows 2008 server. And i have done all the standard stuff in sql to allow remote connections. The strange thing is if i disable the windows 2008 server ...
1
vote
1answer
776 views

SQL Server: “This filegroup cannot be used as a backup destination” error when attempting restore

When running a command like the following: "RESTORE FILELISTONLY FROM DISK='\\\\server\\folder\\DummyDB.bak'" I'm getting this error: Backup destination "\\server" supports a FILESTREAM filegroup. ...
0
votes
0answers
57 views

Volume Shadow Copy Service error: Unexpected error calling routine XML document is too long. hr = 0x80070018

I have about 1400 SQL databases on my environment (on 3 different volumes). I've got follow errors during taking VSS snap. Also SQLWriter goes from stable to failed "nonretryable" *Event ID 8193, ...
0
votes
2answers
52 views

Microsoft SQL Server Data Limit

I am using a Microft SQL Express edition server limited to 10GB/database. The original database runs on a licenced server and it is ~15GB. I was given a small part of this database (last couple years ...
1
vote
1answer
1k views

How can I get SeSecurityPrivilege enabled?

I'm trying to install a hotfix for SQL Server 2008 and failing on the Rule Check with "Setup account privileges" failed. I am running SQL Server 2008 Standard on Windows Server 2008 R2. Searching on ...
0
votes
0answers
21 views

Password change to SQL user and SQL Agent user broke mail agent

We changed the passwords on the accounts which the SQL Server service and the SQL Server Agent use to log in. Both seem to be mostly working fine, however the mail agent is now having problems. It is ...
5
votes
4answers
6k views

Why would I take a database offline?

For what reasons and in what situations would you use the "Take Offline" / ALTER DATABASE dbName SET OFFLINE feature. What tasks can you perform with an offline database? What tasks can you only ...
3
votes
3answers
125 views

Is there an alternative to xp_cmdshell and net use for backing up MSSQL to UNC as a different user

Is there an alternative to xp_cmdshell and net use for backing up MSSQL to a UNC with a different user? I'm now using EXEC xp_cmdshell 'net use \\SERVER\SHARE Password /USER:DOMAIN\USER ...
0
votes
1answer
80 views

Exporting a Subset of Data in Microsoft SQL Server to Script

We are running a Microsoft 2012 SQL Server and are looking at a way to dump a subset of data (based on queries) to .sql scripts we could then run on another server to pull that data back in. We have ...
1
vote
0answers
35 views

How many MSDTC clustered services (if any) are needed for a multiple-instance SQL Server 2012 cluster?

I'm creating a new SQL Server 2012 cluster, running on 2 physical nodes (the O.S. is Windows Server 2012 R2); the cluster will host multiple SQL Server instances; the exact number is yet to be ...
0
votes
1answer
39 views

Securing Webserver and Database

I need to secure an internal web server and sql db, that is going to be made public(www) At this stage im only looking to provide a reasonable amount of security($$) until it gets bigger at which ...
0
votes
0answers
23 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 ...
0
votes
1answer
285 views

MSSQL 2014 and Dynamics CRM 2013 SP1 (springwave)

Microsoft says MSSQL 2014 is not supported with MS Dynamics CRM 2013 (SP1 springwave '14). Is this because there are known problems with that configuration? Or does it just mean that Microsoft did ...
0
votes
2answers
21 views

How to tell what process in SQL is making up the Processor Time reported in Activity Monitor

In SQL Activity Monitor, I see a constant 35% to 40% CPU usage in the Processor Time scrolling graph. How can I tell what Processes within SQL are responsible for that CPU usage?
2
votes
7answers
6k views

Sql server backups very slow

How can I estimate the time of a full backup for a 30gb database? In this moment it takes about 50 minutes. Can we improve that? Thanks
5
votes
2answers
1k views

How quickly will SQL Server release RAM when the OS signals a low memory condition?

From the SQL Server 2008 R2 Books Online: Server Memory Options When SQL Server is using memory dynamically, it queries the system periodically to determine the amount of free physical ...
0
votes
1answer
56 views

Easy way to alias the default SQL Server instance to a named instance?

I have SQL Server Express installed on my machine as the default instance. "server=.;database=...." I'm now working with a new client where their config files are all checked into the repository. They ...
1
vote
1answer
34 views

How to set up an authentication system to authenticate users against an existing SQL Server database

I have a pre-existing SQL Server database with login information (user names, password hashes) for thousands of users maintained by an ASP.NET website. I would like to provide an authentication ...
3
votes
4answers
4k views

SQL Server error 3415

When i attaching mdf file to SQL Server i am getting error database cannot be upgraded because it is read only or it has read only file. Make sure Database or files are writeable.
-11
votes
1answer
87 views

Super-power PC for many users - Server (2008 R2) on Hyper-V can not use full Machine hardware resources [closed]

Desription of problem changed : how to make sure, that my Hyper-V is using all my hardware resources, and if it is using, what is the bottleneck of the system, when discovering performance issues? - ...
3
votes
2answers
10k views

SQL Server 2012 with account NT Service\MSSQLSERVER access is denied in domain

A few months ago we installed SQL Server 2012 in Windows 2008 R2 under the virtual account "NT Service\MSSQLSERVER", all good. A few days ago, one of the admins of the IT dept installed Full Text ...