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 (4)

2
votes
1answer
134 views

SQL server start-up bringing online database priority

we have hundreds of databases on one sql server instance. After restart sql server takes databases online one by one using default order from sys.databases view. This order use database_id, so first ...
2
votes
1answer
580 views

SQL Server synchronization failed

I'm getting the error message below when trying to synchronize a SQL compact database (SQL CE 2.0) to a SQL Server 2005 database. I have double and triple checked permissions, reconfigured IIS ...
2
votes
1answer
146 views

SQL Server 2005 question about procedure cache

Server: SQL Server 2005 SP2 64 bit, 32 gigs of memory. 2 instances of SQL server running. Main instance I'm using has 20 gigs visible. We have a situation where it appears every so often our entire ...
2
votes
1answer
724 views

SQL Server Instance login issue

I've just brought up a new installation of SQL Server 2008. I installed the default instance as well as one named instance. I'm having a problem connecting to the named instance from anywhere ...
2
votes
1answer
185 views

Citrix server running 3rd party app experiencing SQL timeouts

We are running an app that was not developed in house on several Citrix servers. The users of this application are experiencing intermittent SQL timeouts. The error message: ...
2
votes
1answer
360 views

SQL Server Database In Single User Mode after Failover

Here is a weird situation we experienced with a SQL Server 2008 Database Mirroring Failover. We have a pair of mirrored databases running in high-availability mode and both the principal and mirror ...
2
votes
1answer
624 views

SQL Server “Long running transaction” performance counter: why no workee?

Please explain to me the following observation: I have the following piece of T-SQL code that I run from SSMS: BEGIN TRAN SELECT COUNT (*) FROM m WHERE m.[x] = 123456 or m.[y] IN (SELECT f.x FROM ...
2
votes
1answer
123 views

Web Platform Installer - Wants to instal SQL 2008 Express when I already have SQL 2008 Standard installed

I'm finding my use of the Web Platform Installer somewhat muted by it's insistence on trying to install SQL Express when I already have a full copy of SQL Server installed. Why is this happening? Is ...
2
votes
1answer
150 views

SQL Server Bulk Insert Issue on Windows7

I’ve got an application that uses SQL Server Express 2005 SP3. This application is distributed to several hundred users, each of whom is running XP. However, our company will be moving to Windows7 ...
2
votes
1answer
225 views

SQL Server 2000 and SSL Encryption

We are a datacenter that hsots a SQL Server 2000 environment which provides database services for a product we sell that is loaded as a rich-client applicatin at each of our many clients and their ...
1
vote
1answer
56 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
48 views

Cannot start the T-SQL debugger when logged into a remote server via SSMS

Background information SQL Server 2012 on Windows Server 2012 Connecting to server remotely using SSMS The user I am using is in the sysadmin role Able to log in with SSMS and run queries without ...
1
vote
1answer
104 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
116 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
664 views

Get-ItemProperty : Cannot find path 'HKLM:\SOFTWARE\Microsoft\PowerShell\1\ShellIds\Microsoft.SqlServer.Management.PowerShell.sqlps'

I've tried re-installing SQL Server 2014 and I'm still getting the following error message when trying to import-module sqlps. The same registry key exists but is appended with 120. I'm able to use ...
1
vote
1answer
295 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
921 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
552 views

Log In failed for user error 18456

I have two servers. Both of the servers have two different database that will be joined together using SQL Server Agent. However, during this activity SQL Server is throwing a Log In Failed Error. ...
1
vote
1answer
862 views

Copy User Mappings for SQL Logins using SQLCMD - MS SQL Server

Is there a way to directly copy the User Mapping from one SQL Server login to another using SQLCMD? In SQL Server Management Studio Object Explorer | (local) | Security | Logins, Right-Click a user ...
1
vote
1answer
161 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
21 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
29 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
36 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
1k views

MS SQL Server configured for secure (SSL) connection allows non-secure connection from JDBC Client

I need to connect to the MS SQL Server 2008 r2 using the secure communication. I have been able to do the same using the following connection string: jdbc:sqlserver://<<db server ...
1
vote
1answer
27 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
201 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
174 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
43 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
266 views

Error During adding existing ms sql server 2012 in plesk

Recently I install Ms SQL 2012 in Windows server 2008 R2 edition and I want to add this database in Plesk 11, I make a user db02 in MS SQL Server Management Studio after this I logon to plesk . ...
1
vote
1answer
120 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
117 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
814 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
451 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
154 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
196 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
95 views

How to keep track (audit) of SQL Server users on multiple instances

I've a need probably most of you already solved in some way: beside (automatically) creating users (DB + users on single DBs) on multiple SQLServer instances, I need to keep "track" of them and, ...
1
vote
1answer
47 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
372 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
62 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
356 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
868 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
274 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
447 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
33 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
437 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
61 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
344 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
769 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
345 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
188 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 ...