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
31 views

Connecting with SQL Server Management Studio (Remote)

All right, here's my problem: I have set up a sql server 2014 on a windows server 2012 R2. If I'm connecting through the local network just with the ip, everything works fine. Now we need to access ...
0
votes
0answers
22 views

SQL Report Server Subscription PDF Corrupted

I have a SQL Report Server 2012 with subscriptions that emails PDF reports to external users. The report runs once a week, and is about 100 pages long. However, the PDF the users get in their emails ...
1
vote
0answers
29 views

Creating an assymmetric key inside SQL server to access a DLL fails

I need to access a DLL (C#) from SQL trigger for one of our requirements. I have compiled the DLL and could load it in SQL server space by using the "Create Assembly" and then create a trigger for it. ...
1
vote
1answer
17 views

Restrict login to SQL availability groups

Is it possible to restrict the databases available to a user based on an availability group in SQL ent 2012/2014. Want to have two databases where a domain user has access right on these databases. ...
1
vote
2answers
41 views

Separate TLS control for MSSQL & IIS

We have a system that needs to provide both database and web services. We want to lock down the TLS security settings to the highest degree possible. It's running MS SQL 2008 on Windows Server 2008 ...
0
votes
1answer
28 views

What is Best Practice for migrating SQL 2012 system databases to failover cluster?

What is the best practice for copying system databases when migrating from SQL Server 2012 (no SP) to 2012 SP2 in a Failover Cluster? Just backup and restore? Or, script out and script in?
-2
votes
1answer
34 views

Share the database with another person in same network [closed]

I am a newbie to the database topic. I need to create a database and share the database to another person in my office so the other person can also create/delete tables in the same database. I created ...
3
votes
1answer
46 views

Error configuring witness server for failover in SQL Server

I'm lost here, I am configuring a SQL Server for failover and have three servers. Principal server > SQL 2008 R2 Witness server > SQL 2014 Mirror server > SQL 2008 R2 All three servers can ping the ...
2
votes
0answers
165 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
20 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
96 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
49 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
568 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
25 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
31 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
21 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
60 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
37 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
137 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
81 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
71 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
100 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
147 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
35 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
57 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
237 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
351 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
233 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
52 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
56 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
27 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, ...
0
votes
2answers
158 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
87 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 ...
1
vote
0answers
70 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
47 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
56 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 ...
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
25 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
84 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
10 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 ...
-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
47 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
140 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
50 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
198 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
838 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
114 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 ...