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
1k 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
479 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
156 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
204 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
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
406 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
385 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
980 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
312 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
462 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
34 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
451 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
382 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
823 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
391 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
190 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
160 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
940 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
333 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
587 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
402 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
49 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
225 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
550 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
297 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
182 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
33 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 ...
1
vote
1answer
2k views

sqlcmd won't execute - Claims Native Client not installed properly

I'm trying to use sqlcmd to execute some SQL scripts. Using a test command with a simple query like: sqlcmd -S HOSTNAME -d MYDATABASE -Q 'SELECT Names FROM Customers' sqlcmd does not appear to ...
1
vote
1answer
569 views

SQL Server - VMWare Install - Transactional Replication causing 100% CPU

I am having severe trouble with a SQL Server - in particular, with transactional replication. We used to have a Windows 2003 physical machine, with SQL 2000. We call this “WebDB” The server was ...
1
vote
1answer
1k views

SQL Full-Text indexing not populating

We installed a clustered SQL 2005 installation on windows 2008 and reattached our san drives from another machine and restored to do a migration to new hardware. There have been a few minor issues, ...
1
vote
1answer
124 views

Best solution for a mailing list based on a custom SQL Server database AND sync to Outlook?

This is really a two-part question but I'm writing them in the same question because there might be solutions that could handle both. A customer has a custom LOB database based on MS SQL Server with ...
1
vote
1answer
304 views

SQL server 2000, replication over WAN

I seem to have big difficulties setting up the first replication ever between two SQL2000 instances. They both run in seperate WAN's (IP with port assigned for SQL-remote) but I have been able to ...
1
vote
1answer
52 views

Failover Config for SQL Server 2005 Professional on Win2k3 64x Standard (2 machines available)

I have MS SQL Server 2005 Standard on Win2k3 64x Standard (on 2 separate machines) How to setup fail over cluster on this solution? I don't have neither SQL or Win Enterprise and it's too expensive ...
1
vote
1answer
214 views

SQL SERVER 2008 R2 INSTANCESHAREWOWDIR Issue

I am trying to install SQL SERVER R2 Express Advanced Services on my VServer (Windows 2008 SP2 64bit). The server has also a sql server 2005 express instance for plesk... I am running in the strange ...
1
vote
1answer
64 views

SQL Database and ArcSDE Database

Is it possible to have sql database and ArcSDE database running on the same server - virtual machine? What are the benefits? What are the negatives?
1
vote
1answer
127 views

Best database structure for an Admin Portal to a web service

I am primarily a web developer, not a DB admin, so hence this question! We have a webservice that we have created which has a Database on our SQL 2008 server. We are currently creating a web portal ...
1
vote
1answer
798 views

SQL Server: “This filegroup cannot be used as a backup destination” error when attempting restore

When running a command like the following: "RESTORE FILELISTONLY FROM DISK='\\\\server\\folder\\DummyDB.bak'" I'm getting this error: Backup destination "\\server" supports a FILESTREAM filegroup. ...
1
vote
1answer
514 views

No PerfMon data through WMI

I'm trying to get \DBServer\SQLServer:Buffer Manager\Page life expectancy data through WMI. When I do this through perfmon, I get actual data. However when I try and pull this from either of these ...
1
vote
1answer
153 views

backup of TFS with DPM 2007 - different backup times

I have DPM set up to back up my TFS server every 30 minutes, the reason being it's a way better interface than the quirky SQL backup interface. I also do a full backup nightly using an SQL ...
1
vote
1answer
272 views

Download databasename.bak file

I have downloaded databasename.bak file from my hosting company, when i tried to restore that DB file in SQL server 2008 it is keep on giving me following error. The media family on device ...
1
vote
1answer
539 views

Don't see job schedule added by sp_add_jobschedule in SQL Mgmt UI

I'm running a script like below on a SQL Server box and, even though it finishes correctly, then when, on SQL Mgmt UI, I right click on that job's properties, go to Schedules, I cannot see the ...
1
vote
1answer
105 views

MS SQL server 2005 replication

I have a problem with replication between 3 servers. I made something like this: server A replicate (transactional replication) to server B (to 'mydb' database), then server B replicate 'mydb' (using ...
1
vote
1answer
207 views

How do I enable a disabled Event Notification

I have a scenerio where I am using external notification to process documents being sent in from the entire navy fleet, normally I have no problems, but just a few days ago an administrator changed ...
0
votes
1answer
22 views

Unable to connect to SQL Server on live server

I have a copy of my client's database and website on my computer. There's also a matching copy of both online where my client's customers will use the website. When I test my local copy of the ...
0
votes
1answer
32 views

Un-cluster storage added to Windows Failover Cluster Manager

Forgive me if I'm mixing up terminology, I'm a DBA and trying to see if I can un-do my error here. Background: I was adding a 3rd DR site node to a Windows Server Failover Cluster to utilize AlwaysOn ...
0
votes
1answer
46 views

TCP packet loss against SQL-server

Where I work, we have had some issues with connections to the database. We get a lot of failures which appear as "recv failed" on the client side. I have used Wireshark to try to debug the problem and ...
0
votes
1answer
58 views

SQL 2008 R2 automated install w/ configuration file - The credentials you provided for the SQL Server Agent service are invalid

I am doing an automated installation of SQL Server 2008 R2. I have a new VMware guest with Windows 2008 R2 and ran the SQL Server 2008 R2 setup to create a configuration file. I am only installing the ...