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
6 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 ...
-2
votes
0answers
33 views

Create a SQL Server login for desktop app users

I am in need of help setting up a SQL user and login for anyone trying to connect to the app (read/write to the database) from any windows login on our company DOMAIN. I'm trying to make my desktop ...
-3
votes
0answers
16 views

I am confused with SQL server and usage [on hold]

Please help! I am the sibling to a wizard who is unavailable and off the grid for the next couple of weeks. His clients have been calling in saying there is unacceptable loading time and when I access ...
0
votes
1answer
22 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 ...
-2
votes
0answers
28 views

Unable to connect Linux/Apache to MSSql Database

I am using RHEL 6.5 on my Linux Server. I am trying to connect to our Database server which is hosted on an MS SQL Server. I have some perl code through which I am checking the connection with the ...
3
votes
2answers
33 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
20 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
16 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. ...
-1
votes
0answers
28 views

PCI DSS 3.1 compliance + SQL + Old browsers

Trustwave is complaining about TLS 1.0 on our server. Disabling TLS 1.0 breaks SQL and does not support old browsers. How do you become compliant while keeping SQL running and serving customer with ...
0
votes
0answers
4 views

SQL Server case insensitive queries [migrated]

I want to ignore case when comparing string in my queries using SQL Server. So far I am able to do it using something like this: SELECT * FROM Venue WHERE Name COLLATE Latin1_general_CI_AI Like ...
2
votes
1answer
34 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
5 views

Large Transaction Backup [migrated]

On my SQL database I run a full backup at 6am and transactional backups every 15 minutes on week days starting at 8am. Every Monday the first transactional backup is 7 Gb. I want to know why, my ...
1
vote
0answers
28 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
33 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
27 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
68 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
30 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
46 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
18 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
44 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
102 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
17 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
42 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
33 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
89 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
65 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
33 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
26 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
30 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
21 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
29 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
271 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
25 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
29 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
57 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 ...
0
votes
2answers
77 views

SQL Server Management Studio 2012 - password lag and failure

In a new installation of SQL Server 2012 Standard, we have mixed-mode authentication enabled. Using Windows authentication, I can authenticate and use SQL Management Studio as expected. Using SQL ...
-1
votes
2answers
188 views

MSSQL 2008 r2 Express: there is insufficient system memory in resource pool 'internal' to run this query

I'm experiencing this error during the lifecycle of my DotNetNuke Installation. I've change the hosting server and now I've got a Windows Server 2012 with IIS 8 an SQL server 2008 r2 Express running ...
1
vote
1answer
53 views

Windows Server 2012 R2 Virtual Switch

We have an Dell R510 that has Windows Server 2012 R2 Core installed. We are having a problem where the guest VMs are losing their network connections but will come back after a couple of minutes. The ...
1
vote
0answers
30 views

What are the network prerequisites for Windows Azure Pack

I have followed many articles to install and config windows azure pack distributed, But every time I finish configuring everything, the azure pack is not working and give me different errors, seams to ...
0
votes
3answers
156 views

Running IIS and Virtualized SQL Server on same machine

I work for a small organization within the government. We maintain our own Windows Server 2003 web server on the the govt. DMZ. We have to migrate to Windows Server 2008 or 2012 by July. ...
0
votes
2answers
40 views

Migrate MSSQL 2008R2 to 2012 (new hardware)

Since hardware support for our server ends we are migrating to a new hardware and simultaneously upgrading MSSQL 2008R2 to MSSQL 2012. I searched a little bit and found some guides, but they all ...
-1
votes
1answer
32 views

Windows update 2919355 causes our SQL based app perf to drop to 1/6 of previous perf

We have a VB6 app calling out to a local SQL2008R2 instance. We have had complaints about it's performance dropping considerably. After a lot of experimental research, we have determined at least 1 ...
0
votes
1answer
48 views

Upgrading SBS 2003 Premium (with SQL server) to Essentials 2012 R2

As support (and running on old hardware) is fading out for SBS 2003, we are considering upgrading to essentials R2, as suggested by microsoft. The exchange environment will be migrated to Office365, ...
0
votes
2answers
40 views

What the permission required to view all the permissions on a given database?

What permission can grant the right to view all the permissions on a given database? In my current context, the support team of a piece of software need to be able to investigate the cause of ...
3
votes
1answer
70 views

SQL Server 2008 Restored Database allows differential backup when no full exists

I restored a backup file (it's used as a template for new databases) as a new database. Normally as part of this process, I take a full backup after the restore, but this time I was called away on ...
4
votes
2answers
2k views

March 10th Patch Tuesday appears to cause SQL Server client connection problems

Since applying the full set of patches on a Win 7.1 Pro desktop and a Windows 2012 R2 Datacenter Azure server running SQL 2014, SQL Management Studio (2008 and 2014 versions) won't connect to the SQL ...
3
votes
3answers
2k views

SQL Server Windows Authentication fails after tonight's security updates: The login is from an untrusted domain

We have the following setup: One Domain Controller (DC, Server 2003 R2 Standard x64) One SQL Server (SQL, Server 2008 R2 Standard x64) some clients. All machines are in the same domain. All user ...
0
votes
0answers
23 views

MSSQL 2005 - Server Service unable to start while installing

I am trying to install MSSQL 2005 Express on an VM running Windows Server 2012. I get to the point where it installs everything but fails to start the service. I have tried checking the Log-On ...