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)

3
votes
0answers
450 views

Why am I getting “RESTORE DATABASE TERMINATED ABNORMALLY” (Error 3013) when restoring from Azure Blob Storage to SQL Server 2014

Our production database server is backing up its databases nightly to Azure Blob Storage, using the BACKUP TO URL command in SQL Server 2014 Standard. I'm now attempting to restore those backups to a ...
0
votes
2answers
26 views

Why SQL Server Management Studio 2005 showing Version 2012 on running 'select @@version'

I have installed SSMS 2012 before. Now I have need to install MSS 2005 on same machine. I need to generate backup file which will be compatible with 2005 version. But when I run select @@version ...
0
votes
2answers
103 views

SQLServer Configuration - How to refute 1 drive on a SAN is same as multiple physical drives

I inherited a performance investigation problem where a SQLServer 2008( and also 2012 ) database has its Data, Indexes and Log files all on a single drive D: The D: drive is actually part of a SAN. I ...
1
vote
0answers
75 views

SQL Server VSS writer interfering with VMWare snapshots

After changing to TSM for the VMWare backups, we've started experiencing an odd issue with our Snapshot backups. We take system drive snapshots as a backup solution for the machine states. All the ...
10
votes
3answers
670 views

Importance of location of installation of Microsoft SQL Server

I have a server with cheap slow disk and an expensive fast disk. I want to use the expensive disk for all the things where it's important that it's fast, such as my databases. To save money, I want ...
2
votes
1answer
27 views

RemoteApp: Can one be sure that no unwanted programs are started?

Back story: In our company, we bought a client/server process management software from which the client directly communicates with an SQL server. This is in my opinion a major security flaw, because ...
1
vote
1answer
38 views

Check whether GRANT EXECUTE TO user or role was applied

In Microsoft SQL Server, I can use GRANT EXECUTE TO <principal> to grant execute permission to some user or role. I'm interested in detection: How can I equally simply check whether that ...
0
votes
0answers
22 views

Configuring witness server SQL failover

Looking to set up failover for two SQL servers. Question I have is about the witness server. Does the witness server have to be an instance of SQL whose only function is to be the witness server? ...
0
votes
0answers
95 views

Rebuild of fulltext catalog is very slow

I have recently added iFilters to my SQL Server and configured a FullText catalog to index a blob column on a database with 1.4 mil records. The SQL server is running in a production environment with ...
3
votes
1answer
53 views

Microsoft DPM, What are the Type Values in the Alert Table (SQL Backend)

Currently I have a PowerShell script which hooks into the SQL Backend of DPM and queries the list of unresolved alerts. In the table tbl_AHP_Alerts There is a field called Type. This Type Field ...
2
votes
0answers
310 views

The wait operation timed out

I have encountered this problem when running a Data-fill routine for a Data-set Data-adapter in C# which uses a stored procedure written in SQL Server Azure. The SQL Server stored procedure executed ...
0
votes
0answers
147 views

Reducing the initial size of the transaction log

We have a database (in production) where the initial size of the database was set inappropriately large (28GB). If I right click on the database in SQL Server management studio and attempt to shrink ...
2
votes
1answer
155 views

IS there a guide how to copy and sysprep Windows 2012 with Sql Server 2014 installed and running?

We have a server that is installed and running and now we would like to make copies of it. The server is Windows 2012 with Sql Server 2014 Standard. I havn't found any information regarding this, so ...
0
votes
0answers
13 views

Data is re-inserted when replication is done

I have a transactional publication done between two databases on different Virtual machines connected with a network. I noticed that for some reason Every time replication is happening (which is every ...
2
votes
1answer
230 views

SQL Server Replication only for Enterprise Edition? Does it require Enterprise on both sides? Other solution?

My situation: I've been looking for an option of data replication for my SQL Server (I'm not expert on it, I should say it - neither on English Language). I've seen a few options, like Log Shipping ...
0
votes
0answers
263 views

Could not create AppDomain manager: ''

Launching an i2.2xlarge instance using AWS, we sometimes run into an issue where SQL server 2008 does not start up correctly (about once every ten tries). The SQL server error log contains the ...
2
votes
1answer
53 views

Kerberos Error APP_MODIFIED when using a CNAME DNS record

I have a production server, which I'll call CONTOSO\MachineA, running SQL Server. I have a development server, which I'll call CONTOSO\MachineB, running IIS. Both servers are running Windows Server ...
2
votes
0answers
87 views

Constrained Delegation between IIS, SQL Server, SSRS and File System

First of all, not sure which site is best suited for this question be it SO, SF or SU so please feel free to suggest migration! I have a requirement to constrain delegation between several machines ...
0
votes
0answers
502 views

[S1090][unixODBC][Driver Manager]Invalid string or buffer length

I'm getting the error above when issuing isql 'odbc:Driver={ODBC Driver 11 for SQL Server};SERVER=<redacted>;DATABASE=<redacted>;' username password -v as root on my Linux CentOS 6.7. ...
1
vote
1answer
1k views

SQL Server 2014 Install Failed with The computer must be trusted for delegation and the current user error

I'm attempting to install SQL Sever 2014 newly installed Windows Sever 2012 R2 Standard edition OS. During the GUI portion of the installation it fails with the following error: There was an ...
0
votes
1answer
634 views

Cannot connect to SQL Server from local machine to virtual machine hosted on another PC

I have installed SQL Server Express 2008 R2 on a Windows 7 virtual machine - this virtual machine is hosted on another PC on our network. I would like to connect to the server using SQL Server ...
0
votes
2answers
57 views

SQL Server performance

I created a simple website (using C#) that import 70k rows data from a text file to my database but I got this problem: It takes 3 minutes to import 70k rows data to database on my desktop (DELL ...
0
votes
3answers
59 views

Changes to data ordering between SQL Server 2000 and 2012

My company recently migrated a .NET 1.1/SQL Server 2000 web application to SQL Server 2012. We've had a couple of support calls relating to unusual behaviour - particularly with stored procedure ...
0
votes
1answer
45 views

Dynamics AX Synchronization Errors

I have an issue when synchronizing my Dynamics AX 2012 data dictionary with the SQL Server. It is giving errors on a variety of tables/views, complaining of no valid runable code. The problem is, I'...
0
votes
2answers
278 views

Centos, PHP encrypted connection through freeTDS/ODBC to Microsoft SQL Server

I would like to connect from PHP to a Microsoft SQL Server through an encrypted connection. PHP scripts will run from a CentOS release 6.7 (Final) I want to connect to a Microsoft SQL Server 2014 ...
-1
votes
1answer
22 views

SQL 2008 developers edition functionality [duplicate]

I'm trying to find out if SQL developers edition will support windows 2008 HA / clustering. According to this link https://msdn.microsoft.com/en-us/library/cc645993(v=sql.105).ASPX#High_availability ...
1
vote
2answers
105 views

How to free up disk space on a drive which has BiztalkMsgBoxDB_log file in it

I have been asked to analyze a issue regarding one of the biztalk servers. I was asked to free up space on a particular drive, where I found the only file BiztalkMsgBoxDB_log.bak is taking up close 90%...
1
vote
0answers
113 views

Error when viewing database mirroring monitor in SQL Server with non-default port

I have database mirroring set up (with witness) on SQL Server 2014 Standard. Both servers use default instance on a non-default port (not 1433). Mirroring works perfectly fine. However, when I try to ...
1
vote
1answer
54 views

Coldfusion Server with MS SQL 2008 R2 - Database permissions

I have a Coldfusion server with a lot of websites and an MS SQL Server 2008 R2 connected with the webserver. The issue is that all datasources are connected to SQL with the sa which is wrong. So I ...
-2
votes
1answer
108 views

Server 2012 Cluster - Second Node Can't Ping Items

I've got a server 2012 SQL Cluster and all of the processes failover and run properly. The only odd behavior is that when I fail over to the secondary node, there are certain items on one NIC that can'...
0
votes
0answers
8 views

Is CAL licen for SQL Server [duplicate]

We have build a web application in asp.net and sql server 2014 but i was searching around and found that any who uses sql server requires a CAL. How are SQL Server CALs counted?. But what if non of ...
-1
votes
1answer
26 views

Stop SQL default instance

I have installed SQL Server 2014 named instance and configured to connect on static port 1433(Default SQL port). For example: db.mycompany.com\SQL2015,1433 But it's able to connect to the default ...
2
votes
3answers
96 views

RAID versus Storage Pools

I'm currently developing a requirements specification for a new server and am trying to weigh benefits & pitfalls with available technologies. Our current server uses a RAID-5 disc layout which ...
0
votes
0answers
13 views

Login Failed from IIS website

I have a two servers in a lab not using ActiveDirectory, ServerA holding a website and ServerB holding the SQL Server DB. The website C# code is trying to connect to the DB and is getting a strange ...
0
votes
0answers
14 views

Conservative Azure Windows VM to Run SQL Server 2008 R2 [duplicate]

For testing purposes I need to set up three Azure Windows VMs to each run an instance of SQL Server 2008 R2 each holding one DB of approx 100GB. There will be quite a few complex stored procedures/...
-1
votes
1answer
20 views

SQL Server restore operation reliability

I have a simple backup scheme on my SQL Server 2008 R2 that performs a weekly full backup and a daily incremental backup. Backups are retained for two weeks and everything works fine albeit there are ...
0
votes
2answers
66 views

Non Azure VPS connecting to an Azure SQL Server

Ive got a VPS running a web application where its performance is being slowed incredibly by the SQL Server that is installed alongside it. I want to use Azure SQL Server to host the database there and ...
0
votes
0answers
242 views

Connection to MS SQL Server instance through SSH SOCKS proxy fails

I use a local ssh socks proxy (localhost:7070) on my Linux Laptop to connect to my company's intranet over my company's Windows+cygwin laptop, which has intranet access: Linux --(ssh -N -D 7070 -p ...
0
votes
0answers
85 views

SQL Server Express 2014, Windows Authentication problems

I am using SQL Server Express 2014, and I currenly have a (probably) very stupid problem with Windows Authentication. I have a AD server, a MS-SQL server and a Client, where everything was installed ...
1
vote
1answer
278 views

Windows Server slow shared folder access

We have a Windows Small Business Server 2011 which acts as an Active Directory, DNS, Exchange and File server. (Update: and SQL server as well) More than 2 times a day the server becomes slow to ...
0
votes
1answer
2k views

Connecting to MSSQL db (PDO, FreeTDS, ODBC)

I have an Ubuntu 12.04 server and I'm trying to establish a connection to a MSSQL database. I've managed to connect using tsql and isql, but osql doesn't work and connecting with PHP using PDO also ...
1
vote
3answers
158 views

Do SQL backups run faster if you set the databases to read only first?

I have to do a backup of all databases back to back (3.25 GB of data for all .BAK files combined). Will it go faster if I configure the script to set the database to read only first before backing it ...
0
votes
1answer
18 views

sql server 2008 cant insertproduct key

I am trying to install SQL Server 2008 in a Windows Server 2008, but when i have to enter the product key, all option are blocked, and I can´t put the key or select a evaluation version.
0
votes
0answers
58 views

SQL Server 2014 SSIS job fails

I have an SSIS project that runs perfectly when I run it right off of the Microsoft Visual Studio editor. I need it to be a job in SQL SERVER 2014. I have created a proxy for it so that the same ...
0
votes
0answers
29 views

MSSQL Server 2008 - Allow One Outside IP with Windows Firewall

We have a MSSQL Server that has localhost connections, but need to have one connection to another machine. The other machine needs to login to MSSQL server. We added an Inbound Windows Firewall rule ...
0
votes
0answers
471 views

How to export SQLCMD output to Excel

I am using SQLCMD command in powershell to run SQL scripts. When i pipe the output to TXT ,the formatting is all messed up. i want to export the results to excel file. how can i do that. My command ...
1
vote
0answers
47 views

SQL Server Windows authentication - username not changed

I've recently changed my PC name and Windows user account as well. Before: OLDPCNAME\oldusername After: NEWPCNAME\newusername When I log in to my SQL Server management studio using Windows ...
0
votes
0answers
93 views

What format does commvault restore to for SQL server backups?

I have a pretty challenging task that I need to figure out. I have 6TB of data in New Hampshire that I need to move to Texas. It is all SQL Server data. The data is backed up to tape via Commvault as ...
0
votes
0answers
14 views

Sql Server recovery

We installed a POS system onto a pc which we used for an expo. Before we could create a backup and print the reports we had a SQL server connection error and had to re-set up the database. Is there ...
0
votes
0answers
43 views

SQL Activity monitor doesn't show information

i am using SQL Server 2014 Management studio, it seems there is some problem with my activity monitor when connecting to the local SQL server. I am not able to see any information in that [User SA]. I ...