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

Restricting SQL Server Management Studio using LogMeIn Hamachi

I have a SQL Server 2016 instance on Windows Service 2012 VM running in Azure. Currently the network security group/firewall allows for port 1433/TCP traffic so I can connect from my PC using SQL ...
0
votes
0answers
21 views

Why sql server send varbinary big data to application so slow?

I have 2 server : Database Server Application Server and client pc. On Database server using ms sql server i save data file in varbinary(max). On Application server using c# linq to sql i query ...
0
votes
0answers
24 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
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
31 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
0answers
30 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 ...
0
votes
0answers
9 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
0answers
7 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'...
0
votes
0answers
14 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 ...
0
votes
0answers
45 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
0answers
26 views

AD, Service Account, SQL Server DNS Issue

I have very very little experience with network admin and AD, so excuse my ignorance.. I am intermittently getting this error in a Windows Service and website running in IIS (both on the same Server ...
0
votes
0answers
164 views

Install SQL Server 2000 on Windows Server 2012 R2

We have a SQL Server 2000 running on a Windows Server 2008 R2 without problem. Now we have upgraded the main server to Windows Server 2012 R2. We have tried to install SQL Server 2000 on that ...
0
votes
0answers
23 views

SQL Server does not exist or access denied but management studio connection works

I am trying to log on to SQLServer express 2008R2 on a Windows 2003 server using Sql server authentication over a VPN. The login and password work for Management Studio but not for the connection ...
0
votes
0answers
69 views

Redhat 6.8 - Where to install php-mssql

I tried following tons resources online to install php-mssql on Redhat 6.8 by using the Extra Packages for Enterprise Linux (EPEL) repo and it says that "No package php-mssql available". I made sure ...
0
votes
0answers
15 views

OSQL only showing server name without the instance

When i run osql.exe -L on one of our MSSQL db servers, one particular server only ever returns its server name and now its servername and SQL instance name. This is causing an issue connecting ...
0
votes
0answers
42 views

Cannot create an instance of OLE DB provider. Error 7302

I am trying to connect to Oracle server from SQL server. I have installed Oracle DB and trying to create linked server following this link. But when I click ok on creating linked server it fails ...
0
votes
0answers
247 views

SQL Server 2016 RC2 and RC3 Install ERROR (Pictures and logs provided)

Can't install, updated Windows Server 2012 R2 fully with all Optional and Important Updates. I enabled a proxy to gain outside access which works (since Windows updates work). There is no anti-virus ...
0
votes
0answers
20 views

Ubuntu connecting to MS SQL Server shows users instead of schemas

I've tried several different Ubuntu 14.04 clients to connect to a remote MS SQL Server, and each one gives me a list of database users instead of a list of schemas or tables. I've tried DBeaver, ...
0
votes
0answers
19 views

SQL Server Mirroring and Azure Regions Connection Error

I can't seem to get my SQL Server mirroring to work. I keep getting a server can't be reached when I enable the mirroring part. My virtual machines are in different regions. I can connect to all ...
0
votes
0answers
53 views

Backing Up Multiple SQL Databases to Network Share at the Same Time

Junior SysAdmin/accidental DBA here so apologies in advance for the noob question. The previous DBA here had a SQL Backup Maintenance Plan that he would copy across 20+ database servers and have all ...
0
votes
0answers
17 views

SQL Server SSMS/Other Processes Allow Login from Untrusted and Unassociated domain

We have a Windows/SQL server development environment which is completely separate from our developers primary systems, including completely separate domains (no forest association, etc.) Our SQL ...
0
votes
0answers
16 views

MySQL not creating tables automatically when JAMES APACHE is started

The programs I am using: JAMES Apache Server 2.3.1 binary MySQL Workbench 6.1 CE MySQL Connector 5.1.38-bin.jar in ~/james/lib OS: Windows 10 64-bit In james 3, I am able to create MySQL ...
0
votes
0answers
37 views

Database locks up with READ_COMMITTED_SNAPSHOT ON after upgrade to SQL 2014

Since we migrated our database from SQL Server 2005 to SQL 2014, we're experiencing repetitive locks in the database. We used to have very few locks in SQL 2005. The READ_COMMITTED_SNAPSHOT is ON in ...
0
votes
0answers
9 views

SSPI Context not generated

I have migrated a SQL server from another server box that was decommissioned.They have the same name and also same IP address. I am however getting SSPI context error when I connect from an ...
0
votes
0answers
21 views

Does Microsoft SQL Server have something similar to 'sqlite:///:memory:'?

Python 2.7 SQLAlchemy Microsoft SQL Server Management Studio 10.50.2500.0 Microsoft Analysis Services Client Tools 10.50.2500.0 Microsoft Data Access Components ...
0
votes
0answers
32 views

php mssql ApplicationIntent=ReadOnly

I am trying to connect to a remote MSSQL database. Before i get too long into this i was wondering when i connected with SSMS i had to specify "ApplicationIntent=ReadOnly" because of the availability ...
0
votes
0answers
139 views

Problems connecting to SQL Server using ODBC

Since three days ago I have problems connecting to SQL Server on a local network using our Access based application which uses linked tables. It happened suddenly and it only happens on my PC which I ...
0
votes
0answers
31 views

A timeout occurred while waiting for memory resources to execute the query in resource pool 'internal' (1). Rerun the query

When I run this query Select -- Generate the row number ROW_NUMBER() over(order by MenuOrder) as 'rownum', -- get the minimum data from query (Select top 1 ROW_NUMBER(...
0
votes
0answers
25 views

OpenVPN access server on AWS and Integrated Authentication

I have setup an OpenVPN access server (using routed mode) on a VPC in AWS. our servers in the VPC are mostly windows machines, and so are the VPN clients. The client machine (in our office) are not ...
0
votes
0answers
7 views

Unable to access Reporting Services using Administrator account Windows 2012R2 / SQL Server 2012

We have a standalone Windows 2012 R2 server with SQL Server 2012 installed. The Windows 2012 server has an Administrator account only in the group "Administrators". This Administrator account is ...
0
votes
0answers
63 views

Block Windows Service Access to Remote SQL Server with Firewall

So I've got a fun firewall question. We have a windows service that we have running on a Windows Server 2012 instance. It is connecting to a remote SQL Server that we do not own, among other things. ...
0
votes
0answers
8 views

error configuration HTTP connect to analysis services

I want to connect to cube using HTTP/ internet outside. I already set up : copy Folder OLAP in inetpub/wwwroot Added Aplication pool in IIS Added website with application pool i just created enable ...
0
votes
0answers
21 views

Is there Equivilent of SQL Server 2012 Distributed Replay for SQL Azure?

I have a client that wants to replay their daily work load in a SQL Azure environment to test it's performance against their current environment. Does anyone know a product or process I could use to ...
0
votes
0answers
37 views

Establishing performance baseline with SCOM 2012 APM

We're lookign at establishing a performance baseline for our production environment. This could be as simple as establishing highest measured TPS for MS SQL environment and highest measured RPS for ...
0
votes
0answers
144 views

Azure Web Site stopped working because of timeouts on SQL queries

My site is crashed unexpectedly after several months of smoothly work. I haven't done any site updates or re-configuration. But for last 14 hours I have the following situation: When site is up and ...
0
votes
0answers
14 views

SQL Equivalent to Mysqltuner

We are running SQL Server 2008 R2 which powers our order processing system. I am familiar with the linux products like mysqltuner. Is there one that would do the same for sql databases?
0
votes
0answers
30 views

Unable to Change SQL Server 2012 Service Account When Using AlwaysOn Availability and TDE Encryption

I am unable to successfully change the service account in SQL Server 2012. Whenever I attempt to change the service account, the service starts up but the databases in the cluster are not synchronized....
0
votes
0answers
16 views

How to deploy database and blob storage in sql express 2014

this is my first time deploying my application (ASP.net MVC 5) in local environment and I had a lot of problems doing so. My first problem is deploying the database, I used entity framework which ...
0
votes
0answers
47 views

SQL Report Server Subscription PDF Corrupted

I have a SQL Report Server 2012 with subscriptions that emails PDF reports to external users. The report runs once a week, and is about 100 pages long. However, the PDF the users get in their emails ...
0
votes
0answers
22 views

Configuring witness server SQL failover

Looking to set up failover for two SQL servers. Question I have is about the witness server. Does the witness server have to be an instance of SQL whose only function is to be the witness server? ...
0
votes
0answers
107 views

Rebuild of fulltext catalog is very slow

I have recently added iFilters to my SQL Server and configured a FullText catalog to index a blob column on a database with 1.4 mil records. The SQL server is running in a production environment with ...
0
votes
0answers
170 views

Reducing the initial size of the transaction log

We have a database (in production) where the initial size of the database was set inappropriately large (28GB). If I right click on the database in SQL Server management studio and attempt to shrink ...
0
votes
0answers
13 views

Data is re-inserted when replication is done

I have a transactional publication done between two databases on different Virtual machines connected with a network. I noticed that for some reason Every time replication is happening (which is every ...
0
votes
0answers
277 views

Could not create AppDomain manager: ''

Launching an i2.2xlarge instance using AWS, we sometimes run into an issue where SQL server 2008 does not start up correctly (about once every ten tries). The SQL server error log contains the ...
0
votes
0answers
14 views

Login Failed from IIS website

I have a two servers in a lab not using ActiveDirectory, ServerA holding a website and ServerB holding the SQL Server DB. The website C# code is trying to connect to the DB and is getting a strange ...
0
votes
0answers
257 views

Connection to MS SQL Server instance through SSH SOCKS proxy fails

I use a local ssh socks proxy (localhost:7070) on my Linux Laptop to connect to my company's intranet over my company's Windows+cygwin laptop, which has intranet access: Linux --(ssh -N -D 7070 -p ...
0
votes
0answers
89 views

SQL Server Express 2014, Windows Authentication problems

I am using SQL Server Express 2014, and I currenly have a (probably) very stupid problem with Windows Authentication. I have a AD server, a MS-SQL server and a Client, where everything was installed ...
0
votes
0answers
59 views

SQL Server 2014 SSIS job fails

I have an SSIS project that runs perfectly when I run it right off of the Microsoft Visual Studio editor. I need it to be a job in SQL SERVER 2014. I have created a proxy for it so that the same ...
0
votes
0answers
29 views

MSSQL Server 2008 - Allow One Outside IP with Windows Firewall

We have a MSSQL Server that has localhost connections, but need to have one connection to another machine. The other machine needs to login to MSSQL server. We added an Inbound Windows Firewall rule ...
0
votes
0answers
507 views

How to export SQLCMD output to Excel

I am using SQLCMD command in powershell to run SQL scripts. When i pipe the output to TXT ,the formatting is all messed up. i want to export the results to excel file. how can i do that. My command ...