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
votes
1answer
19 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
14 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
11 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
27 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
32 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
21 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
32 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
0answers
20 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
0answers
26 views

Supposedly identical servers behave differently [closed]

I have two SQL Servers running on Azure that are supposed to be the same but one is not performing as well as the other. I backed up a database and restored it as a new database to both servers and ...
0
votes
1answer
13 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
15 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
27 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
60 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
0answers
28 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 ...
3
votes
0answers
44 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
0answers
24 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 ...
0
votes
0answers
7 views

How do I use a SP in SQL Server 2014 to call a external XML source? [migrated]

I am attempting to retrieve Currency Exchange rates from http://www.floatrates.com/daily/usd.xml using a SP in SQL Server 2014. The result is in XML. So I created the following SProc: --DROP ...
2
votes
1answer
181 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
28 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
42 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
53 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
24 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
32 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
65 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 ...
1
vote
0answers
34 views

MS SQL Server data lost or corrupted

I have a situation regarding MS SQL Server database. My friend ask me to repair a certain database, because a range of data has been lost after a hard disk failure, but eventually after ...
0
votes
0answers
108 views

Oracle 11.2 linked server from SQL Server: missing oraclient11.dll required for distributed transactions

I've set up a linked server to Oracle 11g R2 in my 32-bit SQL Server 2005 instance, using the Oracle-provided OraOLEDB.Oracle. When I try to query against the linked server from SSMS, I get OLE DB ...
0
votes
1answer
16 views

Microsoft Dynamics 2010 GP SQL Security

Migrating an install from server to server. First time I have heard of this application. It appears that login accounts are SQL server login accounts. I have migrated the accounts to the new SQL ...
1
vote
1answer
45 views

SQL/SSMS read only user who can only view a single database

I'm currently using SQL Server 2005 which has a number of databases on for individiaul clients. I need to create a single read only login for each of my clients, however I cannot allow them to see ...
0
votes
1answer
120 views

Windows Filtering Platform dropping SQL Server connections

I've been investigating connection issues between my web server (Web01) and a database server (Database01). My current setup: Web01 - two NICs, one external (firewalled), one internal (not ...
0
votes
1answer
42 views

Debugging random SQL login failure from Web Server

This is a very basic level question, but it could really benefit from some extra help in the diagnosis. We have a 2005 SQL Server Named: SERVERNAME-PROD We have a Web Apps Server that's running IIS ...
0
votes
1answer
66 views

Does the amount of disks in a RAID10 matter for a Microsoft SQL server in regards of the block size?

We are planning to deploy a Microsoft SQL Server and to store the databases on a RAID10 (RAID1+0) block-level-storage. Does it matter how many drives altogether I put into the array for optimum ...
0
votes
0answers
25 views

SQL Mirroring with Certificates and Domain?

We're replacing all our servers and wish to migrate a mirrored database running in one domain to the new servers in a different domain without downtime. Is it possible to turn off mirroring in the ...
1
vote
2answers
71 views

Automaticaly export Jobs and stored procedure from mssql server

I have MS SQL server with several jobs. Sometimes I and my colleagues change task. I want to export jobs, like at automaticaly so that put in mercurial and store version of jobs. I would also like ...
0
votes
1answer
152 views

SQL Server Integrated Security without a Domain

This question potentially sits somewhere between ServerFault and DBA Admins but the Domain element of this as led me to put it here. We have been developing an SOA product and are thinking about ...
2
votes
0answers
21 views

Reclaiming free space in filegroup with single chronological partition

-moved here from SO (no coments there) Question: what is a proper way of reclaiming space in big (hundreds of GBs) filegroup with single partition of table that is chronologically ordered and has no ...
1
vote
1answer
21 views

SQL SSMS Window Dissappear

When I open SSMS, I choose windows authentication, but the window just goes away; it doesn't say I'm not allowed. I've accessed these db servers before, the exact same way, and it has worked. Now, ...
0
votes
0answers
80 views

4624/4634 logon/logoff events from SQL Server machine to local PC

I've noticed that in my Security event log on my local PC there are lots of 4624 logon and 4634 logoff events relating to the machine account of servers on our network that have SQL Server installed. ...
1
vote
1answer
59 views

MSSQL Update: Backup-Restore vs Detach-Attach (different new servers and different new disks)

I am amidst of migrating an SQL Server 2005 database to an SQL Server 2012. Both environments are on different servers, and they both have different separated disks for the datafiles and logfiles. My ...
1
vote
1answer
176 views

“Unknown host machine name.” on FreeBSD + unixODBC + FreeTDS

I got some issues connecting to a Microsoft SQL Server 2012 from my FreeBSD 10.1 server. I installed FreeTDS and unixODBC via ports. I compiled FreeTDS with unixODBC support. This ist my ...
1
vote
2answers
71 views

What is RAID 5 write logic with 8 drives running SQL 2008?

We recently had a raid array fail on a SQL 2008 server with 8 x 73GB drives. (Dell 2950). There were two drives that went bad (one had been bad for a few months it seems and was not caught...). To ...
0
votes
1answer
46 views

T-SQL Code to backup database with multiple files failed

I'm trying to write an automated script that will allow me to backup the database to a NAS with multiple files. I just started to use T-SQL. My objective is to automatically calculate the size of the ...
0
votes
0answers
32 views

Using a Load Balancer in front of SQL Server

We are setting up SQL Server 2014 AG with multiple secondary readonly instances since we have some significant queries that are killing our primary. What we would like to do is put a Load Balancer in ...
-1
votes
1answer
41 views

Need help importing data to new SQL server from MySQL folder

My hard drive crashed, and can no longer write, but it can still read. Because of this, I was unable to export my SQL database to an .sql file for later importing. I can still access the drive, and ...
0
votes
2answers
24 views

SQL Server Autonumber or @@identy or a.n. Other

I have suddenly had an older system landed back in my lap and currently having to cast my mind back about 6 years. The system is accessed from 3 different offices and as such each users from these ...
0
votes
1answer
38 views

Installation of MS Host Integration Server 2006

We are in the process of upgrading from Windows 2003 R2 servers to Windows 2008 Standard Edition Service Pack 2 32 bit. We need to install Host Integration Server on this server, and it mentions ...
4
votes
3answers
335 views

vSphere Datastore for specific datatypes: NFS or iSCSI

I am looking into improving performance in my vSphere environment. We are using a NetApp appliance with all VMs stored in Datastores that are mounted via NFS. It was suggested to me that, for some ...
0
votes
1answer
31 views

SP with xp_cmdshell gives an error in the MessageQueue, but executes successfully in Management Studio

I have a SP, which calls xp_cmdshell in it. This SP is being used in a MessageQueue. The SQL server and Agent services are configured using a Domain service account, and this service account has a ...
1
vote
0answers
40 views

SQL Server Connection Issue with New Router But Works With Old Router

I have an issue that really has me stumped. I have a router that is overheating and needs to be upgraded. When I connect the new router and configure it with the same DHCP settings and IP ranges as ...
0
votes
0answers
81 views

Server high memory and cpu - no leads

I've been asked to troubleshoot a server hosting our application at a client's facility. The client has complained to us on two separate occasions in the last week - week and a half. In one instance ...