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
28 views

Architecting for Load Testing

I'm trying to architect a set of web and database servers so that we can load test them. I'm running into some problems given the constraints I have to work with: We can't load test against ...
0
votes
1answer
925 views

Performance Issue Between SQL and IIS on Seperate Machines

First time OP on serverfault, but an avid user of stackoverflow. We have two high-specification boxes, both running Windows Server 2008 R2 Standard. On one we have IIS 7.5, the other SQL Server 2008 ...
-1
votes
1answer
26 views

SQL Server Express 2005 cannot accept connection (but ODBC working from external and local server)

I'm having a problem with SQL Server Express 2005 edition; it's unable to be contacted from an application (3rd party monitoring utility software). I have perform the following tests, all of which ...
3
votes
1answer
55 views

Find Full or Differential backup from .bak (with powershell or by any other means)

I'm trying to determine whether an MS SQL backup file (.bak) is Full or Differential. Is there an easy way to do this? A way of doing this in powershell?
1
vote
0answers
7 views

How do I determine the spid of the session that is making a query on a linked server? [migrated]

I have a session running on a SQL Server instance that is blocking other sessions (holding on to a lock without releasing it). Querying sys.sysprocesses yielded the hostname of a different SQL Server ...
1
vote
1answer
846 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 ...
0
votes
2answers
379 views

SQL server performance over long distance

Is it reasonable to expect decent performance from a SQL server connected via fiber private WAN - 5000 km's away. The carrier is telling us that this network is the 'best' possible, and will ...
0
votes
1answer
3k views

RESTORE detected an error on page (0:0) in database <database> as read from the backup set

I'm attempting to restore a SQL Server 2012 .BAK file to my local server. I've successfully restored this .BAK file before. However now, when I try, I get the following error: RESTORE detected an ...
1
vote
3answers
46 views

Migrating Mssql databases from different instances to a new server

I have 3 instances of Sql (2008 R2) on 3 different servers. The versions are (10.50.2550.0 SP1 Standard Edition (64-bit), 10.50.2550.0 SP1 Standard Edition (64-bit)). The goal is to migrate all the ...
0
votes
1answer
38 views

How to upgrade a MSSQL Server?

As we were updating a service on an older enviroment, we experienced compartibility issues because the service we were updating is working with MSSQL Server 2008+ only. Now we have the issue that we ...
0
votes
0answers
21 views

MS Excel error [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied [on hold]

Hi I am trying to connect to SQL Server on another machine using Data >> Other Source >> SQL Server. I have given IP Address of server in Server Name: and Username and Password. But it is giving ...
0
votes
1answer
2k views

MSSQL 2008 is claiming the firewall is blocking ports even from local machine

I was just hoping to step through a couple queries to see how the temp tables are interacting and I'm getting this message. The windows firewall on this machine is currently blocking remote ...
0
votes
1answer
811 views

long access times and errors in iis application

I am having an issue with an IIS application (details of environment at the end of the message). The web site works great most of the time and I cannot reproduce any error in our test system. On the ...
2
votes
1answer
49 views

Azure IO performance sql server [duplicate]

We are in the process of migrating our on-premises sql server to Azure and I am having trouble with the IO performance. I have created a new D14 instance and attached 16 virtual disks at 100GB in ...
0
votes
1answer
1k views

SQL Server replication pending transactions

I'm having a problem with a transactional replication. I have the publisher in my server and there is a subscriber in another server. In my server, if I go to the details of the subscription I can ...
1
vote
1answer
901 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
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
2answers
2k views

How to set up Zabbix to monitor SQL Server Failover Active-Passive Cluster?

It should be simple, so it is just most likely my approach being totally off and someone will hopefully prod me into the right direction. We have a Zabbix 2.0.3 server instance set up monitoring a ...
4
votes
4answers
7k views

Optimising MSSQL 2008 server inside VMWare ESXi

I normally run my MSSQL servers on dedicated servers, but we've taken on a client who is running their SQL Server inside a VMWare ESXi 4 host, and quite frankly it's running like crap. We have ...
2
votes
1answer
2k views

Monitoring SQL Server 2008

I understand SQL Server doesn't release the memory unless the OS needs it. Then, monitoring Available Bytes (free memory) is not the best way to monitor the service. What other variables can give me a ...
37
votes
22answers
14k views

PowerShell? Do you use it? Can you show me some cool system administration things I can do with it? [closed]

I keep reading everywhere that PowerShell is the way of the future. When it was first released I did a whole bunch of virtual labs, but since then I still haven't used it in a production environment. ...
0
votes
3answers
520 views

Moving MODx Files to Other MODx Website

I have one website with modx installed to www.website.com/modx/ --- Keep in mind there are other Websites In Progress on this storage server. My issue is that I'm moving all this: templates, template ...
4
votes
1answer
1k views

SQL Server 2008 R2 cluster, “available storage” shows “offline”

I've installed a SQL Server 2008 R2 cluster and I found the resource group "available storage" shows "offline" status. What does it mean? It seems I can't take it online. I tried to use the cluster ...
0
votes
1answer
1k views

Cancel/Kill SQL-Server BACKUP in SUPSPENDED state (WRITELOG)

I have a SQL 2008 R2 Express on which backups are made by executing sqlmaint from windows task planer. Several backups ran into an error and got stuck in state SUSPENDED with wait type WRITELOG. How ...
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
votes
0answers
11 views

Can I change a trial sql server 2012 install into an ISV one? [duplicate]

I have a server where the company which sells ERP wants to install the ISV SQL Server 2012. I'd like to prepare everything before they come, even install SQL Server 2012, but I can only install it as ...
-2
votes
0answers
8 views

Extracting Data from multiple archive tables(SQL Server) [migrated]

I am developing a report in report builder 3.0 where i am extracting data from a table dbo.odcalls. now the problem is this table is archived on monthly basis on a seperate database(HN_Backup) and i ...
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 ...
2
votes
1answer
1k views

WSS Search fills 10 GB limit on SBS server 2011

I've got a SBS Server 2011 Standard SP1 that isn't very busy. 2 Users local and 2 remote. We have sharepoint that has maybe a dozen small documents at most. I've just started getting the following ...
-2
votes
3answers
50 views

SSDs for MS SQL Server 2008: slc or mlc: what is expected life for mlc? [closed]

Until recently, Dell et all would only provide slc drives for servers. It appears the winds have shifted and now the cheaper mlc drives are avail for servers. In a sql environment, will mlc give ...
0
votes
1answer
1k views

Can't connect to remote mssql server

I'm trying to connect to my remote mssql server for my GunZ private server, but for some reason i get the following error Cannot connect to 94.xx.xx.xx. ADDITIONAL INFORMATION: A connection was ...
2
votes
1answer
35 views

IIS 7.5 web application failing with NT Authority\Anonymous Logon

I am finding various google results, but none seem to fix my problem. I am setting up a new WINDOWS 2008 R2 box at work that is to communicate with an existing SQL 2012 box via web tools running in ...
0
votes
1answer
2k views

Change server on sap client

I have a SAP business one 8.0 installed on my Windows server 2003. It uses sql-server express 2005 for the database. Then I installed the client on another PC. How do I configure the client so it can ...
-2
votes
1answer
184 views

SQL server slows down

We have a java application running on Tomcat and we are using SQL 2008 and 2005 as database. Our databases sometimes slows down really significantly and we don't see any blocking, deadlock, etc. I ...
2
votes
1answer
28 views

Will SQL Server Express do in this specific situation

I'm doing research on the best suitable database for an in-house web application for our (non-IT) company. It's a web information system with few database-heavy tasks. Users can add new customer ...
3
votes
5answers
2k views

SQL Server 2008 R2 transactional replication over VPN

I'm having difficulty setting up replication over a VPN. I have a SQL Server 2008 R2, Enterprise Edition database on a Windows 2008 R2 Server. SQL Server is running on a non-standard port. I have ...
2
votes
3answers
6k views

DBCC CheckDB The operating system returned error 21(The device is not ready.)

The operating system returned error 21(The device is not ready.) to SQL Server during a read at offset 0x0000000001c000 in file 'E:\SQL Database\S***d\NewAdvWorks.mdf'. Additional messages in the SQL ...
1
vote
2answers
2k views

Can't install SQL Express 2008R2- caspol.exe application error - the application failed to initialize

I'm trying to install SQL Server Express 2008 R2 on Windows 2003 Server (enterprise edition). I get the following error message: Title: caspol.exe - Application Error Text: The application failed ...
4
votes
1answer
948 views

netlogon errors

I have two instances of mssql 2005 and am using CA XOSoft replication. The master is a failover cluster and the replica is a standalone server. They are all running Server 2003 sp2 x64. Same patch ...
1
vote
1answer
33 views

SQL Express Reporting Server 2014

I have a problem getting my SQL SSRS service working. Version: SQL Express 2014 When I try to start SQL SSRS in services, the service starts, but looking at the event viewer it fails to connect to ...
-1
votes
0answers
21 views

What server config I need to answer 600k request in every 15 minutes for 300 SQL Server database [duplicate]

I will have 300 SQL Server databases on my machine that must answer 600000 request every 15 minutes. This server has a valid IP address and all request come from internet channel. for now I have a ...
0
votes
0answers
13 views

EMC AVAMAR Compatibility with SQL Server 2008 R2 in Active/Passive Clustered Mode

We are currently using EMC AVAMAR as part of our backup policy for backing up all our servers. We also have a SQL Server 2008 R2 active/passive setup. Does anyone know if EMC AVAMAR is compatible in ...
0
votes
1answer
2k views

How to get php_mssql.dll working properly on IIS 7.5 and PHP version 5.2.17?

First of all I'll give a very brief introduction of what I'm trying to make. I need the mssql php functions to work on the webserver. I know that such functions were deprecated in PHP 5.3 and above. ...
0
votes
1answer
7 views

FIM2010 R2 SP1 service account requirements on database after installation

We're in the process of updating our Forefront Identity Manager to 2010 R2 SP1. The SQL Server instance for the old installation has the FIM service account in the sysadmin role, as is required for ...
0
votes
1answer
13 views

SQL BCP Permission needed?

Need to check a permission level, a user needs bulk insert\update\delete permission. If I add them to "BulkAdmin" server role, will this be enough? (Running SQL 2012)
1
vote
1answer
864 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 ...
2
votes
2answers
3k views

How can we recover/restore lost/overwritten data in our MSSQL 2008 table?

I am in serious trouble and I am seeking professional advices here. We are using MSSQL server 2008. We removed primary key, replaced exiting data with new data resulted losing our critical business ...
0
votes
3answers
930 views

syspolicy_purge_history generates failed logins

I have a development server with 3 instances: Default, A and B. It is a physical server, non clustered. Whenever the syspolicy_purge_history job runs at 2 am, I get failed login alerts. Looking ...
1
vote
3answers
35 views

SQL Server 2012 SP1 transaction log getting full?

One of my DBs is having a problem with the transaction log filling up. It's set to full recovery and is regularly being backup via maintenance plan. I have a full DB backup every weekend then daily ...
1
vote
1answer
892 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. ...