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)

7
votes
1answer
118 views

Why can NT AUTHORITY\SYSTEM create SQL Server database backups?

I have a scheduled task (in Windows Task Scheduler) that connects to SQL Server using SMO (Windows Authentication) and creates a database backup. So far, this task was running under the Administrator ...
2
votes
3answers
2k views

Can’t connect to SQL Server 2008 - looks like Shared Memory problem

I am unable to connect to my local instance of SQL Server 2008 Express using SQL Server Management Studio. I believe the problem is related to a change I made to the connection protocols. Before the ...
0
votes
2answers
948 views

SQL 2008 install failed - Could not find the Database Engine startup handle

My SQL 2008 install failed, I'm getting this error: Could not find the Database Engine startup handle This happens after uninstalling SQL Server 2008 and trying to install SQL Server 2008 R2, any ...
-3
votes
0answers
12 views

sql server 2008 r2 licensing for production [duplicate]

I have a web application that work on sql server 2008 r2, I'd like to know if i will sell this application, how the client will get the sql server license, from me or he should buy a new one.
0
votes
1answer
2k views

Error: Package 'Microsoft SQL Management Studio Package' failed to load. In SQL Server Management Studio

I had installed SQL Server 2008 R2, the installation was succesful. But I can't open the Management Studio because this error is shown: Package 'Microsoft SQL Management Studio Package' failed to ...
0
votes
1answer
12 views

Unable to run query in SQL Management Studio because of JIT debugging error

Recently I have built a Windows server 2008 and installed SQL Server 2008 and Dynamics CRM 2011 on it. Everything is working fine but when I open the SQL Server management Studio and try to open a new ...
0
votes
1answer
20 views

Team Foundation Server 2013 and Large SQL Tables

I have a Windows 2008 R2 virtual machine running Team Foundation Server 2013 and MS SQL Server Express. We are a small (<10 programmers) development shop and have 3-4 collections in TFS. We stood ...
0
votes
1answer
10 views

SQL Server Virtual Network Name Change Error

I am in the process of configuring a two-node failover cluster for a migration project. We are transitioning a stand-alone SQL Server to a cluster. Environment: 2x nodes with Windows Server 2012 R2 ...
0
votes
1answer
19 views

Uninstall Older Sql Server After Upgrade

Is it ok to uninstall older versions of SQL Server after an upgrade? I have 2008/2008 R2 installed, but using 2014 since it was just upgraded.
0
votes
0answers
20 views

MSSQL Server 2014 Standard CAL licensing? [on hold]

I have a web service that is connecting to MSSQL database. There is aprox. 30 programs that are connecting to this service simultaneously. Is it enough to have 1 CAL license for 1 web service, or do I ...
1
vote
1answer
622 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. ...
0
votes
1answer
1k views

MySQL ADO.NET Connector & MSSQL Integration Services

Here I am, day three... attempting to sync a data view on a Windows Vista box (64 bit) running MSSQL 2012 and Visual Studio 2010. Sanity is slipping and hunger for progress fills my attention. I ...
3
votes
6answers
4k views

SQL Server 08 Express error when connecting to localhost - “Timeout expired”. Works with ::1 or 127.0.0.1

EDIT New info: Navigating to localhost:1434 in Chrome gives me an "ERR_EMPTY_RESPONSE", while other ports give me an "Oops! This link appears to be broken". So it seems to binding ok there? So ...
2
votes
2answers
3k views

AclPermissionsFacet fault install SQL-2008-R2

While attempting to do an installation repair of SQL-2008R2, I'm failing the pre-check rules. Module that is failing is AclPermissionsFacet - with this message "The SQL Server registry keys from a ...
2
votes
3answers
953 views

SQl Server - Which Inventory Tool ( Free )

I would like to get an inventory of all SQL Servers in my office and pertinent meta information about them. Need things like Version#, Instances, isClustered etc... I prefer to automate this and ...
0
votes
2answers
200 views

Weird behavior using Active Directory group mapped to SQL Server user/login

I've run across a very odd behavior on SQL Server 2008R2. I have a third-party application which acts as a SQL Server client. I have a subset of my users who should have access to this application. ...
0
votes
1answer
633 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 ...
0
votes
3answers
708 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 ...
0
votes
4answers
814 views

SET RECOVERY Model Using sp_msforeachdb

I wanted to build a script that sets the RECOVERY MODE for each user database to SIMPLE and put it into an agent job for my dev servers. It seemed simple (sorry for the pun): EXEC sp_msforeachdb ...
0
votes
1answer
1k views

SQL Server Issue: Could not allocate space for object … primary filegroup is full

Trying to figure out a problem at an office that has SQL Server 2005 installed on Windows SBS Server 2008. Here's the setup: It's an office, and the person who set this all up is nowhere to be ...
0
votes
2answers
658 views

How to setup Database Permissions on SqlServer Express 2008

I'm using a code-first approach of using the Entity Framework. When I first run the application it will try to create the database matching my MVC models. However, it doesn't have permission to ...
1
vote
2answers
939 views

What information about errors can MSSQL profiler report on?

I have a feeling a SQL client application is timing out, but because of how the application is coded, there's no way of telling. So I was hoping that running MSSQL profiler on the server would ...
0
votes
1answer
22 views

Amazon EC2 Windows with Sql Server Web, changed to an instance with just Windows no SQL Server?

If I start a windows AMI with Sql Server Web, this will include a licensed Sql Server Web installation. What will happen if I then create a Windows only AMI instance and connect the volume with Sql ...
0
votes
2answers
671 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 ...
1
vote
3answers
2k views

Error when trying to open SQL Maintenance Plan - SSMS 2008

If I open SSMS on my client machine, connect to our SQL server, and try and open a maintenance plan on there, I get this error: TITLE: Microsoft SQL Server Management Studio Could not ...
0
votes
1answer
1k views

Export Import error 'SSIS Data Flow Task could not be created' … registering DTSPipeline.dll, cannot create task “STOCK:PipelineTask”

I'm about to throw in the towel on this one. Running SQL Server 2008 enterprise on Windows 7 x64. Can't get past this issue. When I try to Import / Export Data from databases through SQL Server ...
0
votes
0answers
28 views

How do you RESET the SQL Server 2008 TCP/IP Protocol settings back to default?

We have a SQL Server with multiple interfaces and a previous admin wanted to enable TCP/IP protocol to listen on a specific port. I believe that wherever he saw a specific IP address, he replaced it ...
0
votes
1answer
19 views

Is there DDL viewer role in SQL Server?

I have a user that have db_datareader role in SQL Server 2008 I need this user to be able to see Stored Procedures, functions, table scripts, etc. What role is that? I don't want user to RUN DDL ...
0
votes
2answers
937 views

Cannot access local database with IIS Manager

I've created a local .mdf database with Visual Studio 2010 and did a couple of modifications to it. Now I want to edit it in IIS Manager. However, I cannot access it neither by connection string, nor ...
1
vote
2answers
968 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 ...
0
votes
1answer
1k views

Best practice on how to update & reboot a live server [closed]

We have a business critical server that has not been re-booted in over 2 years. It is running Windows Server 2003, with SQL Server 2005 (SP3), Visual Studio 2005 and 2008R2, and has numerous versions ...
1
vote
1answer
27 views

How export database from mssql by using command line

I am using windows7 os and i have a database on MSSQL server 2005 i am using following codes to import database sqlcmd -S [server instance name] -d [database name] -i [filename you want to import] ...
1
vote
0answers
19 views

SQL 2014 Install failed to install Data Services and SSAS, rest is installed, how to fix without uninstall?

I just installed SQL 2014 trial version, but it failed to install SQL Data Services and SSAS Services due to space issues, which have been resolved. How can I re-install only those services without ...
0
votes
1answer
1k 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
0answers
10 views

SQL Server 2008 - how to set automatic ANSI to OEM conversion option

I have a product I am installing where the pre-requisite is SQL Server. The product documentation (which is quite old) talks about SQL Server 2000. However I am installing SQL Server 2008. The ...
0
votes
2answers
29 views

Configure MSSQL 2008 to use kerberos authentication

I would like to set my current mssql db (2008 and 2012) to authenticate using a linux kerberos server that I have in my environment . The windows station is in a workgroup and I would like to avoid ...
1
vote
3answers
5k views

How do I grant a database role execute permissions on a schema? What am I doing wrong?

I am using SQL Server 2008 Express edition. I have created a Login , User, Role and Schema. I have mapped the user to the login, and assigned the role to the user. The schema contains a number of ...
4
votes
1answer
826 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 ...
3
votes
1answer
1k views

Reporting Services 2008 configuration for basic authentication using username and password

I want to configure Reporting Services 2008 to use a custom defined username and password for access. I read that I must set reporting services to do basic authentication : ...
0
votes
0answers
13 views

Typical max API call volume for shared enterprise hosting accounts? [duplicate]

We are hosting our site with SectorLink and have a shared enterprise hosting package, running on Windows with MS SQL Server. The provider will start to throttle us once we reach 10% of the server's ...
2
votes
1answer
765 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
0answers
48 views

Error connecting to MS SQL from one server but not the other

We got a MS SQL server and two web site servers. I'm in the process of moving all the sites from one of the web site servers to the new one. My asp.net sites are not able to connect to the external ...
0
votes
2answers
755 views

Where are the SQLServer jobs stored?

I'd like to know what is the process a SqlServer job is executing, but I only can find that it calls DTSRun with an encrypted string. After decoding the string, it results is just the name of the job ...
0
votes
2answers
605 views

SQL Maintenance Cleanup Task Working but Not Deleting

I have a Maintenance Plan that is suppose to go through the BACKUP folder and remove all .bak older than 5 days. When I run the job, it gives me a success message but older .bak files are still ...
1
vote
1answer
66 views

Failover Cluster Client Access Point Only Responds to Pings on the Owner Node

Background We're running two VMs (Windows Server 2012 R2) on Azure with SQL Server installed, set up as an availability group. We also, of course, have another VM as a dedicated DC. These are all ...
0
votes
0answers
18 views

Changing how tempdb log space is monitored in SCOM

We are monitoring our SQL installation with SCOM. We get an alert about once a day saying that the log file in tempdb is filling up. However, because checkpointing works differently in tempdb than it ...
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 ...
0
votes
0answers
9 views

SCCM DB - Client assignment with DPs

I am trying to imitate SCCM 2012's behaviour when assigning a client to a distribution point for package downloads. Please tell me if I understood it correctly or if there are any errors in my ...
0
votes
1answer
795 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
158 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: ...