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)

0
votes
0answers
13 views

How can I tell if there is a prepared SQL Server install on a machine using PowerShell?

How can I check in PowerShell if the SQL Server install on a machine is just a prepared install (done before a sysprep) or a full ready to go instance?
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. ...
0
votes
1answer
10 views

cant connect to sql server express on server from client

I just install sql server express on server with ip 10.222.117.17. I've been deactivated the firewall so i can ping server from client or my pc. but when i try to connect with navicat or management ...
0
votes
1answer
13 views

Deadlock after transferring to another IIS Server

We transferred an old ASP application from Windows 2000 to Windows 2008 R2 to upgrade its performance. We only transfer the ASP application, the database is still the same. After successful transfer, ...
8
votes
3answers
4k views

sql azure vs azure VM with SQLServer Express

Beside being cheaper is there any problem/advantages to use SQL Azure vs to use a Virtual Machine with SQL Express? We are looking to setup a SQL server for more than 50 websites, do you have any ...
-6
votes
0answers
20 views

SQL Server create a table [closed]

Thanks for everybody , How can i create program for this problem. It will be helpful for me. I need to know create program for this to store data in SQL Server. Thanks for your help, I am using twin ...
0
votes
1answer
2k 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
vote
2answers
4k 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 ...
0
votes
2answers
4k 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 load....
4
votes
2answers
3k views

MS Sql Server getting overloading with 'Suspended' queries, mostly reads. Any way to fix this?

I have a Microsoft Sql Server that handles a moderate amout of traffic for a company software suite made up of multiple clients in java and c#. It is getting overloaded with 'Suspended' queries. They ...
0
votes
1answer
1k views

Sql Server Transaction Log Backup Fails

I have a Sql Server 2008 Standard version. Mirroring is set up on the server in full safety mode. Its been working fine till today. The transaction log back-up fails every-time with an error "Error: ...
2
votes
1answer
2k 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
2answers
2k 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 ...
0
votes
0answers
9 views

Convert into multiple data ranges

I have employee data link below This is one example in the file a have multiple lines. Initial input can have more than 2 lines for each employee but convert logic will be the same. Thank you ...
0
votes
0answers
19 views

Azure SQL database stuck

I am currently working with a rather large database in Azure. I was deleting data in batches and all was going well. Then for some reason one of the batches seemed to get stuck. It was taking much ...
0
votes
0answers
21 views

Port 1433 blocked to Azure SQL Server

I'm having an issue connecting to an Azure-hosted SQL Server. After much trial and error, and studying the handshake, I've determined that port 1433 is being blocked somewhere along the way. I've ...
4
votes
3answers
3k 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
1answer
2k views

Powershell execution policy within SQL Server

Can anyone help? Firstly I apologise if this is the wrong forum and for the amount of text you have to read. I'm not allowed to post images yet and a picture is worth a thousand words..... When ...
0
votes
0answers
13 views

Exporting on-prem SQL Server to Azure SQL using BAPAC fails because of users with Windows Auth

I have an on-prem SQL Server 2014 database - the schema itself is fine and fully Azure SQL compatible. However, it has a USER object that is bound to a Server LOGIN which is configured to use Windows ...
0
votes
1answer
48 views

Can Windows Nano server run SQL server?

I am investigating the possibility of running a Nano server for a web service. I have been trying to find out if it can run an instance of SQL server 2016 in addition to IIS.
7
votes
1answer
1k views

SQL Server Installer Update Cache management

Is it safe to delete the old cumulative update directories from the %ProgramFiles%\Microsoft SQL Server\110\Setup Bootstrap\Update Cache folders? At least this MSDN blog post tells to leave anything ...
1
vote
1answer
25 views

Publishing to Azure for the first time

I've created an ASP.NET MVC / WebAPI 2 web application on my local environment. I am using LocalDb for my development purposes and I follow the EF "Code First" approach (I've written all my model ...
0
votes
0answers
7 views

What happens to user sessions in ASPState DB when SQL Server Cluster DB is failed over from one box to another

One of our customers have a Production Cluster SQL Server architecture with two nodes. Our customer have an ASP.NET based web application which uses ASPState database to manage sessions. We need to ...
0
votes
2answers
317 views

MAXDOP and Interesting Performance Experiences

i would like to receive an advice on the following topic. With one of our products from our company we "connect" to an existing database on customers side and import orders into our own SQL Server to ...
0
votes
1answer
34 views

Transferring MS SQL database to other server - Best Practice

What would be the best way to move a database from one server to another a) Stop the database > Create a database backup > restore onto 'other server' b) Detach the database > move the ldf and mdf ...
1
vote
0answers
44 views

Deployment fails for SQL Server 2014 SP1 Standard on Windows Server 2012 R2 VM

Apologize in advance - this stuff isn't exactly my wheelhouse. I'm trying to provision a VM with Windows Server 2012 R2 and setup SQL Server 2014 SP1 Standard using the Azure portal. I pretty much ...
0
votes
1answer
43 views

Failover server for EC2

I have one Amazon EC2 instance of Windows Server which is running application with SQL server. Our users from On-premise use RDP to login into this server using Elastic IP and do their work. I want to ...
4
votes
3answers
3k views

Uploading a file to a varbinary on SQL Server

Is there any way to upload a file to a varbinary on SQL Server without writting a program to do it?
0
votes
1answer
2k 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
2k views

Firewall configuration for SQL Server 2012 Express on Windows Server 2008 R2 for Workgroup

We are attempting to configure a server application to run on Windows Server 2008 R2 using SQL Server 2012 Express. With the server firewall turned off completely the application can communicate just ...
1
vote
3answers
19k views

MS SQL Server 2008 R2 Product Key

We are needing to perform a repair installation of our MS SQL Server 2008 R2 installation and cannot locate our original product key. Is there some way in which we can recover our product key from ...
4
votes
2answers
2k views

SSMS: Where does SQL Server store its server names?

I have a number of "old" servers or server names with a typo in them that keep showing up in my dropdown list of server in the "Connect to Database" dialog of SQL Server Management Studio: Where ...
0
votes
1answer
4k 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 ...
0
votes
0answers
40 views

Advice about scaling out IIS and SQL Server 2014 on Windows Server 2012R2

We are running a dual processor server E5-2630 V3 / 64 GB RAM with Windows Server 2012 R2, this server has IIS and SQL Server 2014 installed, only one web service is running to serve a mobile ...
0
votes
1answer
2k 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
2answers
1k views

Viewing previous query results from SQL Server Management Studio

I left my computer last night running a batch delete in the Query Editor of Sql Server Management Studio. I was running this to test the speed of the delete on a large database before we used the ...
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 ...
0
votes
0answers
6 views

Alternatives for large data usage over WCF

I'm working on a (C#, WPF) system originally built for in-house use, which grew over time and now has at least 20 people connecting to our SQL 2014 DB off-site via WCF services. Since the system wasn'...
1
vote
1answer
132 views

SQL 2012 SQL server Agent Jobs

I am trying to figure out how to troubleshoot a situation with SQL Server Agent (2012). A job that has been running nightly (user SQL Server Agent as its scheduler) for over a year in 2 to 4 seconds ...
8
votes
8answers
53k views

Can't connect to SQL Server using 'sa' account, what I'm missing?

I'm trying to log in to a SQL Server 2005 Express instance using the following command: osql -S .\INSTANCE -U sa -P password I get the error: Login failed for user 'sa'. I can connect just fine ...
0
votes
1answer
2k 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 ...
4
votes
2answers
4k 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 ...
3
votes
1answer
2k views

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

I've tried reinstalling 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 ...
0
votes
1answer
3k views

Easy way to alias the default SQL Server instance to a named instance?

I have SQL Server Express installed on my machine as the default instance. "server=.;database=...." I'm now working with a new client where their config files are all checked into the repository. They ...
3
votes
2answers
3k 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
38 views

Log Shipping and Security for reporting

I have a SQL 2008 server with a database replicated via log shipping to a reporting server. The reporting server database gets updated once a day. The reporting server database is left in Standby/Read-...
3
votes
1answer
1k views

SQL Server Debugging: “Unable to Step. Invalid operation”

I'm debugging a call to a Stored Procedure in SSMS (2012). Frequently, and various random points in the code, a dialog pops up: Microsoft SQL Server Management Studio: Unable to Step. Invalid ...
3
votes
1answer
5k views

The OLE DB provider “SQLNCLI10.1” has not been registered.; 42000

I have a SQL Server 2008 Analysis Services Project. In the Data Source View I have a Named Query which references a single Data Source containing three tables. The Project processes successfully and ...
0
votes
0answers
12 views

Azure SQL Server Listener not working for MS CRM

I have 2 web servers, 2 report servers and 2 DB servers for MS CRM 2013 SP1 installation in Azure VMs. This is the replication of the current on-premises CRM organization set up. I have configured SQL ...
29
votes
6answers
3k views

How can I prevent accidentally jacking with a production database?

Just recently, I had a developer accidentally try to restore a database to production, when he should have been restoring to a staging copy. It's easy to do, given that the db names are similar, i.e., ...