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
vote
1answer
202 views

How do I use a domain account to connect to a MSSQL server for NPS accounting?

I'm trying to connect a Server 2008 R2 NPS to a MSSQL server for logging accounting data and I'm running into issues. I configured NPS Accounting through the "Configure Accounting" wizard and, using ...
1
vote
1answer
373 views

Activity Monitor not showing stored procedures?

This is SQL Server 2008 R2 running in Hyper-V virtual machine with 4 virtual cores. Task Manager is reporting sqlservr.exe to use at least 50% CPU, sometimes 100% for minutes. I/O is very low. The ...
1
vote
1answer
332 views

SQL Server 2008 local connection an error occurred during the pre-login handshake

I am getting an error while trying to connect to SQL locally either via a web application or SQL management Studio. Oddly, I can connect fine remotely via apps on other servers or SQL management on my ...
1
vote
1answer
521 views

MSSQL 2014 and Dynamics CRM 2013 SP1 (springwave)

Microsoft says MSSQL 2014 is not supported with MS Dynamics CRM 2013 (SP1 springwave '14). Is this because there are known problems with that configuration? Or does it just mean that Microsoft did ...
1
vote
1answer
296 views

BCP/xp_cmdshell access denied - but only when running procedure from outside the server

I've been attempting to run some of my team's database deployment code to a SQL 2014 server on a Windows 7 test box. Part of this code is a procedure that pulls in data from a file using BCP from a ...
1
vote
1answer
234 views

What happens to active connections to my SQL Server DB if I back up the transaction log with the NORECOVERY option?

Some background: I'm migrating my SQL Server DBs to a new machine and I wrote a few Powershell scripts to send/apply full backups and transaction logs asynchronously to the new server, but my question ...
1
vote
1answer
228 views

Is it possible to store a credential for Windows Authentication to an Analysis Services server?

SQL Server Analysis Services uses Windows authentication for server connections. Typically, you assign your domain account to a role (or the server administrator list), and then connect to the server ...
1
vote
1answer
689 views

PHP 5.3 mssql support on Linux

I have a RHEL 5 box with php 5.3 that I am tasked with installing mssql support on. I installed php53-mssql and reloaded apache. It seems that modules were installed to /usr/lib/php/modules but my ...
1
vote
1answer
2k views

Red Hat 6 connect to MS SQL server 2005 using freetds; pdo_dblib and php

I'm having a problem connecting to my Microsoft SQL Server 2005 from a Red Hat box using freetds. My end goal is to be able to connect using php's PDO, but I don't appear to be able to connect when ...
1
vote
1answer
273 views

Intermittent performance issues on Azure Web Application with ASYNC_NETWORK_IO errors

Our web application is suddenly experiencing intermittently slow performance (slow page loads, slow ajax calls going from <1 sec to over 20 secs). The only clue is when the application slows, we ...
1
vote
1answer
28 views

SQL Server 2005 DROP LOGIN syntax error

This snippet of code (it's just a repeater, not the actual code I'm going to run) throws a syntax error on the DROP LOGIN command: declare @obso_user varchar(16) set @obso_user = 'BEN_VA\20362781' ...
1
vote
1answer
30 views

Find out what is using SQL installations on a Windows Server

I have taken over a server that has tons of SQL Server related bits installed, and as far as I know, there are no applications on the server requiring the use of SQL. There are different SQL Server ...
1
vote
1answer
40 views

SQL: name without a login name

I have noticed that when I open SQL server enterprise manager and I navigate to the list of users under a specific DB, I found users with"Name" but some have no "Login Name" value. What does this ...
1
vote
1answer
30 views

create a view to show the backup status in every 10 mins

I have a question, my table have following data: userID, startTime, EndTime ————————————— 101, 04/11/2013 11:00:00, 04/11/2013 11:55:00 102, 04/11/2013 11:00:00, 04/11/2013 11:24:00 103, 04/11/2013 ...
1
vote
1answer
366 views

Slow MSSQL on DB (~2TB) - Index / fragmentation?

I have a fairly large MS SQL database (~2TB). Most of the data is in one table (~6 billion rows). Two weeks ago I dropped two non-clustered indexes on the large table and migrated the data onto a ...
1
vote
1answer
253 views

SQLIO IOPS Explanation

OK. We have a few PowerEdge Rack servers that we use for MSSQL. I have one server that has 3 raid arrays of RAID 1 that are SATA. I can run SQLIO and get close to 6,000 IOPS. How is this even remotely ...
1
vote
1answer
48 views

sql server seems hung when updating a table

I have a task which I run from the MS SQL Server Management Studio. I would expect it to finish in an hour and it has finished before in such time frame. The input data has not changed dramatically ...
1
vote
1answer
1k views

Exception Enumerating SQL Server Instances with SMO WMI ManagedComputer

I'm trying to use the SMO WMI API/objects in PowerShell 2.0 on Windows 7 with SQL Server 2008 R2 installed to get a list of SQL Server instances on the local computer using the Managed Comuter object. ...
1
vote
1answer
275 views

Trying to connect to a SQL Server 2000 instance via SSMS 2012

All -- I have a development VM server with Windows Server 2008-R2 and on it I have the following versions of SQL Server Installed: SQL 2000 - Developer Edition SQL 2005 - Enterprise Edition ...
1
vote
1answer
153 views

Unable to change schema of a Publication Database using TSQL (Ready-roll): being forced stop replication

I am trying to apply schema changes using T-SQL (using Ready-Roll database source control tool with Octopus Deployment) to a Publication database however it is forcing me stop Replication for the ...
1
vote
1answer
2k views

SQL Server ODBC Connection via Command Line

I need to create a number of ODBC connections to a MS SQL Server, the clients are mainly XP machines. The connection has to use SQL server authentication - is there a way to do this remotely via ...
1
vote
1answer
568 views

AWS MSSQL RDS Instance periodically timing out

Every 5 or so days (including just now) I get a barrage of timeout errors from my webapp. If I look at what my SQL instance is doing in CloudWatch, it reports this: Freeable space: http://cl.ly/NBRM ...
1
vote
1answer
168 views

SQL 2008 asynchronous replication with parent site

I have SQL 2008 installed on Win 2008 VM on one hardware which is in subnet of (parent) 192.168.0.0.24 and second site has similar hardware with win2008+SQL2008 in 10.1.1.0/24 (child) and third one is ...
1
vote
1answer
253 views

How do I configure a stored procedure wrapper and security settings to provide safe access to command-line operations?

I'm ultimately trying to find a way to allow the safe use of BCP and selected other command-line functionality from within SQL Server. The organisation I am in currently have xp_cmdshell disabled ...
1
vote
1answer
49 views

SQL Server Rights to backup drive

I'm trying to copy a backup I've made from one server to another using either an SSIS or Powershell step in a job. I've run into the same error on both systems when running the step under the sql ...
1
vote
1answer
478 views

How do I resolve the message “Validating WSFC quorum vote configuration - Action Required.”

I have a 3 node AlwaysOn Availability Group on a 3 node WSFC using node majority. 2 nodes are setup as synchronous with automatic fail-over, the 3rd is setup as asynchronous with manual fail-over. ...
1
vote
1answer
63 views

Bigger ProjectServer farm is performing worse

I am using Project Server 2007 sp3 with SharePoint 2007 sp3 and SQL Server 2008 r2. I have recently moved my farm from 2 servers (1 DB and 1 App/Web) to a very big farm having Many Servers, Clustered ...
1
vote
1answer
451 views

Security issues/risks connecting from IIS7.5 to SQL Server 2008+ using Machine Account (DOMAIN\MACHINENAME$)

I'm working with a group of engineers doing .NET 4 / MVC 3 development, using Windows 7 Enterprise and IIS 7.5 locally, and connecting to MSSQL 2008+ dev/testing databases. The databases are remote ...
1
vote
1answer
1k views

SharePoint 2010 Server Configuration Error -> “Cannot connect to database master”

I recieve the following error when I try to configure SharePoint 2010 Server: "Cannot connect to the database master at SQL server at [computer.domain]. The database might not exist, or the current ...
1
vote
1answer
478 views

One Way Replication of Oracle 11g to MSSQL 2008R2

We're in the midst of a major LOB system change which will use Oracle 11g, but we need to maintain a LARGE number of existing reports in SSRS. What is a good method to automate a one-way, read-only ...
1
vote
1answer
499 views

what is the difference between 'NT Authority\Service' and 'NT Authority\Network Service'?

I am configuring a SQL Server Express 2008R2 instance, and I want the current logged in user to be able to access SQLEXPRESS. Which one should I add at the Database engine configuration step of the ...
1
vote
1answer
37 views

Adding tables from 1 MSSQL database to the other

Here are college, every single student gets an MSSQL database. Because we have several thousand student however, user-rights are restricted. You get 1 database, and only one. If you're making ...
1
vote
1answer
518 views

Can I install a 32-bit SQL Server 2005 alongside a 64-bit SQL Server 2008 installation?

The place where I work at currently runs a 32-bit SQL Server 2005 installation on its server which we work with. In addition, the systems we are developing on have not yet been tested for 64 bit ODBC ...
1
vote
1answer
69 views

Replace SQL Server 2000 with 2008 same name

We are replacing an old SQL Server 2000 box with new hardware and SQL 2008. If we name the new server the same as the old will ODBC connections still work? What about replication and linked servers?
1
vote
1answer
464 views

Can BES 5.0 Express database be migrated from SQL Server 2005 Express to SQL Server 2008 R2 Express?

Would there be any issues for cross migration of database from SQL Server 2005 Express to SQL Server 2008 R2 for blackberry configuration database and database in general? If the database is backup ...
1
vote
1answer
974 views

Setup ejabberd with SQL Server 2008

Here's what I have got so far. Windows 2008 Server 64 bit. Installed the latest version of ejabberd, ejabberd-2.1.8-windows-installer.exe. The windows service starts up fine but seems ineffective. ...
1
vote
1answer
500 views

How to execute rskeymgmt utility silently in windows server 2008

When i run reskeymgmt.exe - to create a backup copy of the encryption key, it responses "Are you sure want to extract the key from the Report Server? Yes (y)/ No (n)?" I found this link which ...
1
vote
1answer
195 views

Site resilience with MSSQL Servers

What I'm trying to do is set up a failover system between two MS SQL Servers. It needs to be active/passive, and allow weighting (so Site 1 is preferable, before Site 2). I've done this between our ...
1
vote
1answer
162 views

Can I set MSSQL permissions for individual users with a group login?

I have a lot of SQL 2005 servers with a lot of databases and a lot of Windows users that need access to all the servers but only a few databases, and that last part changes regularly. Managing these ...
1
vote
1answer
1k views

Restore SQL 2008 database fails with error on page xxx:xxx

This is the situation: Got a full backup (.bak file) of a SQL 2008 database, with partitions. The .bak file is 100gb. I need to restore this database on a different server, to a new database. ...
1
vote
1answer
109 views

Remote restore of DB in MSSQL 2008

I have a remote MSSQL server meant to centralize SQL for development projects. I hand out DB's and access to developers as they need it. I do not want to give them access to filesystem in any way ...
1
vote
1answer
368 views

NHibernate won't connect to SQL Server

I have 3 SQL Server instances running on our server (dont ask why)! 2xSQL Server 2008 Workgroup (Default and MSSQLServer2) 1xSQL Server Express 2008 R2 (sqlexpress) Now I have a Windows Service/App ...
1
vote
1answer
699 views

Help with repairing Dynamics CRM 2011 Server

As stated above, I had a bit of an issue with my CRM 2011 server last week. I run a small computer repair company and use it to manage my clients. I was running the server in a VirtualBox VM and the ...
1
vote
1answer
435 views

SQL 2005 Cluster - How to move MSDTC

We currently have a 2 node (Win2003) SQL 2005 Cluster running 2 instances. We need to move all drives to a new SAN but are pondering over how to move the DTC that is currently 'logging' te Quorum ...
1
vote
1answer
51 views

Troubleshoot DBMail in SQL Server 2005

On a SQL Server 2005 machine, I have DBMail setup and correctly configured. I am able to use "Notify Operator" and EXEC msdb.dbo.sp_send_dbmail to queue emails. But the problem is the queued mails ...
1
vote
1answer
262 views

Can you use a relatively expensive filter on transactional replication?

I'm trying to replicate (transactional, push) a relatively small table (50K rows), subject to several different filters, which are rather expensive (each taking at least an hour long to complete, ...
1
vote
1answer
664 views

I had to drop and restore database again. I was able to drop but got error while restoring. can any one please help me how do i solve this issue

use [master] drop database [databasename] I got following error Database could not be dropped because the database is in use then i ran following script to deop database and it worked. ...
1
vote
1answer
341 views

MSSQL2008-R2 Scheduled Job Infinite Loop

I have two very similar jobs on a SQL2008r2 instance. Each one selects data from one of two structurally identical tables and exports it to one of two SQLAzure databases with the same schema every ...
1
vote
1answer
189 views

SQL 2008 R2 3rd Party Peer-to-Peer Replication, Global Site Distribution

We are looking at hosting 3 globally distributed SQL Server installations at different data centers. The intent is that Site A will serve web traffic and data for a specific region, same with Site B ...
1
vote
1answer
34 views

Adding Logical Drive in SQL Server 2000 Clustered Environment

I have a Sql Server 2000 Clustered (Active/Passive)Production box, My network guy is adding a new Logical Drive to the box. Also he is going to Add logical drive to cluster admin My Question is He is ...