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)

1
vote
2answers
793 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
138 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 ...
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
67 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 ...
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. ...
0
votes
0answers
57 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
121 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
44 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
56 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
7k 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
25 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
53 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 ...
2
votes
1answer
4k 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
91 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
71 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
285 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
1k 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
797 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
139 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
87 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
2k 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
24 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
7k 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 ...
0
votes
0answers
79 views

Migrating SQL Server 2000 from Physical to Virtual

My team will be tasked with a Physical-to-Virtual migration of SQL Server 2000. The main requirement will be: Minimization of downtime and minimization of impact on operation. The action plan is as ...
3
votes
3answers
398 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
202 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
79 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
43 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
43 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
366 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
30 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
245 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
55 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
97 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? - ...
4
votes
2answers
12k 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 ...
1
vote
2answers
335 views

SQL 2005 replication not working

I am in the process of creating replication between 2 remote servers, server 1 is the distributor and publisher and server 2 is the subscription Server 1 windows 2003 server 192.168.10.1 connected ...
2
votes
1answer
801 views

Sharepoint - restore single document from database level backup

Have a single Sharepoint webserver backed by a SQL 2005 server. The sharepoint server has a messed up document in a document library and I have a SQL database backup from the day before. What are my ...
0
votes
1answer
89 views

Deal with dashes and spaces in T-SQL String functions

I am searching for the occurrence of a string in a field on a table. The search statement is done through dynamic sql with my statement template looking like this. SET @sSQL = 'UPDATE ...
0
votes
2answers
57 views

Script out SQL Job Create Statement Without SSMS

Does anyone have an idea of how to generate the Create statement for a SQL Agent Job? I've looked everywhere, and I can't seem to find a search result that doesn't involve using SSMS and going ...
0
votes
0answers
21 views

Unable to view SQL Server Agent while logged in as user

I apologize for asking with insufficient information. I have granted SQLAgentUserRole permission to one of the user in SQL server on msdb database, but when user login in to SSMS using his ...
0
votes
0answers
20 views

SQL Client failing SSL certificate encryption under a AD Domain

I have a client machine (web server) that is attempting to connect to a SQL server. The SQL server is 2008 and has the force encryption flag turned on. Both servers are joined to the domain. The ...
0
votes
0answers
27 views

SQL Reporting Denying Access to User After Move to New Group

We have a SQL Server 2008 server setup with reporting services so that users can log in and run certain reports. I have a user that was granted browse permissions to this as we had their initial ...
18
votes
3answers
20k views

Database 'XXX' is in transition. Try the statement later

im trying to connect to a sql server database i get this error Database 'XXX' is in transition. Try the statement later. i cancelled a long query earlier today but for some reason i can't get the ...