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
8 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
8 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
4 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 ...
0
votes
0answers
10 views

PHP PDO Drivers to access MSSQL DB from OSX 10.6 (snow leopard)

I've seen many a post but none make it clear or provide proof that MSSQL drivers are supported on OSX. So has anyone had any success in connecting to SQL Server using PDO Drivers? If so it would be ...
0
votes
0answers
6 views

Can't remotely connect through SQL Server Management Studio over the internet using SQL Server Authentication

This question is quite similar to the this one: Can't remotely connect through SQL Server Management Studio The difference is that I don't host my SQL Server in a 1and1 environment, but an in ...
2
votes
1answer
17 views

Manage SQL Agent Jobs On Multiple Servers

Is there a way to deploy/modify/remove//manage SQL Agent Jobs across multiple servers within a domain without third-party software?
0
votes
1answer
26 views

Can I use SQL Server Enterprise Edition on VM Azure for production use

I have Microsoft BizSpark subscription in which I received Azure credits as well. I created a Virtual machine on it and I am planning to install SQL Server Enterprise edition which I see available ...
1
vote
1answer
25 views

install sql server driver on ubuntu

I want to connect to sql server database which is placed on a remote server while my php code has been installed on an ubuntu server. I found that it needs to install sqlsrv driver or mssql driver ...
-4
votes
2answers
53 views

Create a domain on server to have all users on it + shared SQL Server 2012

I'm new to Active Directory Domain Services and to Windows Servers in general. I created a domain on Windows Server 2008 R2 using AD DS and I joined all company's PCs to this domain. Now what I want ...
0
votes
0answers
10 views

SQL Server 2012 Microsoft-Windows-Perflib Error Message Event Code 1010

I am seeing the below error message occur every 15 minutes on a Hyper-V guest running Server 2012 R2 with SQL Server 2012 with SP2 (DB, SSIS, SSRS). I am wondering how to diagnose what this error ...
1
vote
0answers
9 views

Installing SSDT on Windows Server 2008 R2 SP1

I'm trying to install SQL Server Data Tools on a Windows Server 2008 R2 SP1 machine. I'm getting the following error: I've tried using both the .exe file and the ISO. I'm getting my files from ...
0
votes
0answers
24 views

Cannot add NT Authority login into SQL Server

I installed SQL Server 2014 on a Windows 2012 R2 instance. I named the instance SQLExpress. After installing SQL Server, I joined this machine to an Active Directory domain and logged in using the ...
0
votes
0answers
21 views

Importing bacpac file with 25000 tables on SQL Server fails with timeout

I'd like to import a bacpac file that was exported from an 500MB DB that however has around 25000 tables. The bacpac itself is around 18MB. Importing through the UI of SQL Server Management Studio ...
1
vote
0answers
18 views

Is it safe to back up SQL Server data directly if using VSS?

I have a client with a very basic single server setup that includes a small SQL Server Express database. I recently configured Symantec Backup Exec 2010 Quickstart edition for them. This is the ...
0
votes
1answer
20 views

How to record/log query execution stats for long running SQL Queries?

I work on a system that comprises of a SQL Server 2012 DB server that is queried frequently with complex queries. Sometimes these queries take more than 2 or 3 mins to return. How can I record or ...
0
votes
1answer
13 views

Bring back to restoring state an online database

I configured logshinging for a database. I did some tests and tried a controlled failover. During log shipping secondary db is in restoring state. To have a controlled failover i stopped the primary ...
0
votes
2answers
28 views

Restarting sql servers

Ok I am our only IT guy here and all this was set up by the previous guy. I know pretty much nothing about databases. We have some software called E2 that keeps track of all our inventory. We also ...
0
votes
1answer
21 views

MSDE 2000 database size limit workaround

We have an application that came with MSDE 2000 version (yeah, quite a while ago) that is no longer supported, but we have not replaced it with something else. It works for us just fine, and ...
1
vote
1answer
11 views

SQL Server 2005 repair

I have a SQL Server (on Windows XP) where I have published reports using Report Manager and a bunch of databases. Within the SQL Server, I have jobs scheduled to run updates on tables, etc. I came ...
0
votes
0answers
50 views

Running SQL Server under “NT Service\MSSQLServer” caused “Object or Property not found”

I have a server called "server.domain.com" which was a Windows Server 2008 R2 domain controller This server also ran SQL Server 2008 R2 I renamed the domain controller (using the instructions on ...
0
votes
1answer
26 views

SQL 2012 Availability Group Doesn't Failover When Shutting Down Service

I am having an issue with SQL 2012 Availability Groups where it does not fail over when shutting down the service. When you shut down the service you will get an error: A network-related or ...
0
votes
1answer
13 views

SQL Server 2012 AlwaysOn Availability Groups Server Logins Fails When Switching Between Nodes

I am setting up a 3 node cluster as part of an availability group. Initially I tested failover between nodes using SQL Management Studio and everything failed over successfully when I stopped a node, ...
0
votes
0answers
18 views

What does the sqldumper_errorlog file contain?

The SQL Server error logs are continually showing (along with many more messages) BEGIN STACK DUMP. * User initiated stack dump. This is not a server exception dump. Followed by External dump process ...
-1
votes
1answer
26 views

Why are server authentication mode options are greyed out in Sql server 2005

I tried to search for the solution but couldn't find any. Please help me understand why the server authentication mode options are greyed out in Sql server 2005. I want to allow SQL Server login mode ...
0
votes
0answers
15 views

MSSQL - Can Maintenance Plan wait for Agent Job Task to be completed?

I did start a Maintenance Plan project with Execute SQL Server Agent Job Task box. I added another task on success event. I realized that I was wrong. The second task is executed in parallel, because ...
-3
votes
1answer
19 views

System databases are in standby…how can I make them editable?

My System Databases are stuck in a standby/read-only state. RESTORE DATABASE msdb WITH RECOVERY does not seem to have had any affect. How can I get them out of the standby state?
-1
votes
0answers
25 views

How to push the SQL installation from SCCM 2012.

I need to push out SQL 2008 to a new server using SCCM 2012. I was wondering if anyone had done this? I thought it was a case of finding the device in collections and deploying a package to it. ...
-1
votes
1answer
35 views

Database sql server Mirroring or replication

I have SQL server 2008 R1 with standard edition. I have a large database i.e. 500GB that i.e. growing rapidly 10GB a month .It is a cloud based solution. We have another data center where the ...
0
votes
0answers
26 views

SQL 2012 AlwaysOn Availability Groups Failover Successfully But Application Complains About Login Failed for User

I am trying to get SQL 2012 AlwaysOn Availability Groups working for an application. The cluster has 2 SQL nodes and 1 witness server. Everything appears to be failing over successfully when I do ...
0
votes
1answer
20 views

SQL Server 2014 Backups not inheriting NTFS permissions

I am running a script I run on all my SQL servers however on this specific server I have run into the problem where the script fails to make a copy of the DB backups in an external location because ...
0
votes
0answers
81 views

Repairing corrupt MS SQL master database - no SQL client access

Apologies for any duplication but I feel like I'm falling at the first hurdle. I have a MS SQL 2005 Server which is refusing to start and for which I don't have a password (including the 'sa' ...
1
vote
1answer
49 views

Import IIS Advanced Logs into SQL

I'm using IIS 8.5 Advanced Logging and also logging some custom HTTP headers. How can I import the raw logs into SQL on a regular basis (i.e. every minute)? I want to avoid the overhead of ODBC ...
0
votes
2answers
45 views

Copy DB table across 2 different MSSQL servers

I have 2 MSSQL servers running, with more or less the same data set. It is really a production/development setup. Now, my workflow is like this. Every day backups are made of each one of the ...
0
votes
1answer
34 views

how to create public SQL server [closed]

I installed sql server on my computer. I can work with it as localserver. But i want to it to be a public server. I followed lot of tutorials but it's still don't work(I can't connect the server ...
0
votes
1answer
34 views

Backup and Restore Multiple MS SQL Databases

We have switched to a new CAD package at work (elecworks) which uses MS SQL Server to store it's data. Unfortunately, it seems to use a separate database for each drawing that is created. We are ...
0
votes
1answer
39 views

32Bit ODBC DSN “Server does not exist or access denied” but 64 bit ODBC OK connecting to SQL Server 2014

Using a new SQL Server 2014 Connecting via 32bit ODBC fails giving the error "Server does not exist or access denied" Connecting via 64 bit ODBC is successful What might cause this?
0
votes
1answer
20 views

Restoring From Another Dev's MDF on Same Database: MDF Cannot be Overwritten

Here is the situation: We have multiple developers. We want to import/export(restore/backup) .bak files whilst working on the same, but local, databases(Each dev has a local instance of DB: A). The ...
0
votes
1answer
56 views

Is it possible to connect to MS SQL server via HAProxy?

I need to be able to connect to MS SQL server hosted on Amazon (RDS, single AZ) via HAProxy. I tried the following configuration (bottom) but MS SQL returned me (although I used valid login and ...
1
vote
0answers
175 views

PostgreSQL - Invalid byte sequence for encoding “UTF8”: 0xe7 0x75 0x20

Here is the problem : Everything worked fine with my postgresql system until I decided to click on the "rotate logs" button in the server status tab (from pgAdmin). After that, I faced this issue, ...
0
votes
1answer
64 views

Intermittent DB connection failure

Recently I started to see intermittent errors in log files of my web application. Raising from different places of the application the error is always about failed connection to DB which is located on ...
4
votes
0answers
79 views

Windows Authentication to a Remote Server within an Intranet Environment

I have several servers (all on the same DC) within an Intranet environment at my company. For simplicity, I'll focus my question on the IIS and SQL Servers. I have an IIS 7.5 web server and a remote ...
0
votes
1answer
70 views

SQL 2014: Add Table gives “The requested operation cannot be completed. The computer must be trusted”

A single user is not able to "Add Table" to a database that he (or anyone else) created. Other users can add tables. We have checked permissions and they are the same - but obviously we've missed ...
2
votes
1answer
184 views

Easy way to resurrect numerous AD clients powered off for 2 years?

I have a pair of active directory domains with a one-way trust where I am attempting to revive some servers (~12, so automated steps would be handy but I can manually do everything if necessary) that ...
1
vote
1answer
32 views

Is there an Azure Virtual Machine Template for SQL 2014 Business Intelligence Edition?

From what I can tell SQL 2014 Business Intelligence Edition should be somewhat cheaper than Enterprise Edition. We currently run all our SQL servers on Azure and rent our licences monthly. I am ...
-1
votes
1answer
12 views

Use reporting service configuration to configure the database source name

So im upgrading to R2. When i get to the Reporting Services Authentication step i get the error: There are validation errors on this page. Click ok to close this dialog box. Review errors at the ...
0
votes
1answer
52 views

SCOM: SQL Server cannot authenticate using Kerberos

For past few months, we are getting these kind of alert in SCOM stating SQL Server cannot authenticate using Kerberos. One thing to note here is that this alert is coming from only one server not ...
3
votes
2answers
71 views

Where are diskshadow snapshots stored?

I am evaluating DISKSHADOW utility to take MSSQL database snapshots. I use the below set context persistent set option rollbackrecover txfrecover set verbose on begin backup add volume d: alias ...
2
votes
0answers
28 views

SQL server and PHP restart

i have Apache/PHP running on a server running windows 7 with SQL server 2008 r2 running on windows Server 2008. When SQL is restarted Apache/php will no longer connect to SQL once it is back up ...
0
votes
0answers
54 views

when using SSMA I get the following error (Exception from HRESULT: 0x80029C4A (TYPE_E_CANTLOADLIBRARY)

OK.... Ive checked and rechecked Google, StackFault, Experts-Exchange, etc... for a resolution on this error and they all say to register the DAO360.DLL and add its path to the environment settings. ...
3
votes
1answer
101 views

How to stop SQL Server from logging informational lines to SQLFT log files?

I checked on a SQL Server 2012 instance recently only to see that the HDD is full and after investigating what happened it was Full Text Search informational lines filling the log files and disk space ...