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
0answers
10 views

MySQL 5.5 performance settings [duplicate]

We are using server this theses parameters: 8 cores CPU 18GB RAM MySQL version 5.5 We would like to get the best performance. The DB is InnoDB type. I would like to know your experience and maybe you ...
0
votes
1answer
414 views

sqlsrv not showing up in phpinfo.

I'm using Win server 2k12, php 5.5.12, on wamp. Edited php.ini (both on apache dir and php dir) to add php_sqlsrv_55_ts.dll and the php_pdo_sqlsrv_55_ts.dll, and configured the extension dir path ...
1
vote
1answer
37 views

Failing over to mirror instance when not using a witness server

I have a set up where I have two SQL servers set up for failover mirroring to two other SQL servers. I am not using a witness server. I had previously used a witness server and that of course would ...
0
votes
1answer
28 views

Web application access permission

I have a web application that uses SQL server . SQL server is hosted on a server and accessed using port 1433 . My question is will the user who is accessing my application required to be able to ...
-1
votes
1answer
77 views

CentOS7 mysqlserver download error

[root@localhost bin]# rpm -qa httpd httpd-2.4.6-31.el7.centos.x86_64 [root@localhost bin]# rpm -qa php php-5.4.16-36.el7_1.x86_64 [root@localhost bin]# rpm -qa mysql [root@localhost bin]# I am a ...
1
vote
0answers
13 views

SQL Server Table Partitioning & Impact of Raid Levels

How does SQL Server Table partitioning get impacted by the DISK RAID level ? We have a SQL Server with 8 data disks . The main table in the database has over 200 million rows partitioned by day of ...
0
votes
1answer
139 views

Restoring a differential database file “the backup set holds a backup of a database other than the existing”

I am trying to test restoring a SQL database using a full/differential approach to a different server than it was backed up from. The database is in simple recovery mode as it is a test data warehouse....
0
votes
1answer
246 views

“Unable to connect to data source” Debian unixODBC FreeTDS; PHP CLI works, apache/web doesn't

Envoironment: webserver: Debian8 with Apache, PHP, unixODBC, FreeTDS (current versions installed with apt-get last week) dataserver: Windows Server 2008 with MS SQL Server 2008 Opening this in ...
0
votes
1answer
66 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
47 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
70 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
23 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
71 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 R2....
0
votes
1answer
36 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
41 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
97 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 ...
3
votes
0answers
517 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
27 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 ...
2
votes
0answers
81 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
688 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
28 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
40 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
107 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
57 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
324 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
170 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
189 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
264 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
277 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
59 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
93 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
1answer
551 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
701 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
50 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
320 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
107 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
125 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
55 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
126 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
100 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
14 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 ...