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
1answer
3k views

Active Directory SQL Server Random Handshake Timeouts

We've installed active directory on a new server and joined our database server and web servers to this new domain. However, randomly, we'll get the following error. What would be the cause of the ...
0
votes
1answer
38 views

i am getting the following error MSSQL$SQLEXPRESS Application log on my server

TDSSNIClient initialization failed with error 0x80092004, status code 0x1. Reason: Initialization failed with an infrastructure error. Check for previous errors. Cannot find object or property. ...
2
votes
1answer
1k 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. ...
3
votes
2answers
5k 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
55 views

Why do I keep getting Microsoft-Kernel-Power error and my 2012 R2 DataCenter is randomly restarting with this error

Microsoft-Kernel-Power error ID=41 on Windows Server 2012 R2 Data Center. My server went down twice yesterday due to this error happening, causing the server to restart on its own. This is an Azure ...
1
vote
2answers
371 views

WebSites can't access to Sql Server DBs while recycling Application pool

I have some websites hosted on IIS7.5 windows 2008 R2 sometimes I am notified that sites report an error on connection to DBs and can't connect to DB while sql server is running. Nothing changed on ...
1
vote
1answer
2k views

Exception Enumerating SQL Server Instances with SMO WMI ManagedComputer

I'm trying to use the SMO WMI API/objects in PowerShell 2.0 on Windows 7 with SQL Server 2008 R2 installed to get a list of SQL Server instances on the local computer using the Managed Comuter object. ...
0
votes
1answer
1k views

No file access permissions after restore database

I have a strange phenomon. When I restore a SQL-Server 2012 database to a folder on my D-Drive, it gets restored just fine. I can access the database and basically it works fine. But when I check the ...
0
votes
1answer
35 views

freetds start job at step from linux python script on MSSQL DB

I'm trying to create a python script on a linux box that can execute an agent job. Looking around I found sp_start_job command. But it doesn't seem to exist on python. Does any one know if it does ...
0
votes
1answer
3k 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
2k 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, ...
0
votes
0answers
23 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
1answer
2k views

Error in trying to delete a local publication for DB replication

I logged in in db ad sa (super admin). I want to remove a publication made using management studio wizard (right click on Replication/Local Publications/ New publication) After trying to delete I ...
0
votes
0answers
67 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
1answer
70 views

How much data can SQL Server handle without a DBA / other professionals?

We deploy clusters that use Cassandra, Elasticsearch and similar NoSQL technologies to index and process data. We go to quite some lengths to make sure we can consume and process records quickly. One ...
2
votes
2answers
1k views

Install SQL Server 2000 on virtual machine Windows Server 2008 (HyperV) [closed]

My hierarchy ask me to setup a production Windows server 2008 virtual machine (HyperV) with SQL 2000 Standard Ed. installed on it. I can't find on the net much information about the relative "...
0
votes
0answers
22 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
1answer
16 views

Windows Server 2012 R2 Hyper-V connection to external SQL Server not working

For almost 2 years, I've had a Hyper-V virtual machine on my local Windows 10 (formerly 8.1) machine running IIS and connecting to my production SQL Server (the Hyper-V VM is a development machine). I ...
1
vote
1answer
1k views

PHP 5.3 mssql support on Linux

I have a RHEL 5 box with php 5.3 that I am tasked with installing mssql support on. I installed php53-mssql and reloaded apache. It seems that modules were installed to /usr/lib/php/modules but my ...
0
votes
2answers
24 views

SQL randomly disconnects in the middle of querying data

I have a strange problem - when I am querying SQL table with more than 9000 rows, SQL randomly disconnects with some unrelated error. 1.) What I mean with randomly disconnects: On average it happens ...
0
votes
0answers
54 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
1answer
73 views

How to secure dual-homed Windows Servers that are connected to the internet

We have two machines running windows server 2012. Both have one NIC port connected to the public internet and another NIC port connected to a switch with internal IPs (192.168...). What is the most ...
0
votes
2answers
2k views

SQL Server Express cannot connect error: 28 - Server doesn't support requested protocol

I cannot connect to my local SQL Server Express (2012, but the version shouldn't matter) from my server (Windows 2008 R2) to use a tool on it (APEX SQL Data Diff if you are wondering). I can browse ...
0
votes
0answers
11 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
31 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 ...
2
votes
3answers
6k views

SQL Maintenance Plan - Send email on fail

I have a maintenance plan on my SQL 2008 box - I would like it to send an email address when (or if) it fails. I've set up database mail, and can send a test email.. How can I do this?
0
votes
2answers
17k views

Is it safe to shrink tempdb.mdf in MS SQL Server?

Hej, my TEMPDB.mdf grew up to 42GB on MS SQL Server 2005 installed on Windows Server 2003. Last date change is 31/01/2013 at night. So, I wonder whether this is ok to shrink it?
3
votes
5answers
4k views

Determine LSN of database in NORECOVERY mode

I'm restoring transaction logs to a database, but need a way to know which transaction log I should start with. Typically I'll see something like this: The log in this backup set terminates at ...
2
votes
7answers
2k views

Enabling xp_cmdshell in a production environment

A SQL developer on a project I am working on has asked whether it would be possible to enable xp_cmdshell on the production database as it is easier to export CSV files using xp_cmdshell than to write ...
-1
votes
1answer
49 views

Migration between Oracle and Azure SQL Data warehouse using SSMA

I am facing the below error while syncing table from Oracle to an Azure SQL data warehouse using SSMA tool (a tool used to migrate data from Oracle to Azure SQL). I am able to connect to the database ...
6
votes
4answers
8k views

SQL Server Backups using Volume Shadow Copy

Many well-known backup utilities for Windows use the Volume Shadow Copy Service built in to newer versions of windows to create a point-in-time snapshot of the disk in order to safely back up open ...
3
votes
3answers
4k views

How can I backup an SQL Server database using Windows Server Backup?

Apparently Windows Server Backup has some support for backup of SQL Server databases: Ability to recover applications. Windows Server Backup uses VSS functionality that is built into applications ...
0
votes
3answers
13k views

How can I get Transaction Logs to auto-truncate after Backup

Setup: Sql Server 2008 R2, databases set up with Full recovery mode. I have set up a maintenance plan that backs up the transaction logs for a number of databases on the server. It is set to create ...
0
votes
1answer
40 views

How do I upgrade Non-Readable replica to readable (active) replica in Azure SQL Database

We have a Azure SQL Database with one read-only replica. We want to upgrade it to a plan that makes the replica active, so that it becomes readable. However, the upgrade procedure produces the ...
0
votes
1answer
23 views

How to create a full dbo role for specified databases

We supply specialised data management software to the geothermal industry. From time to time, the database structure needs to be changed, and we issue a new version of the software that automatically ...
0
votes
2answers
57 views

SQL Server Named Pipe Error

I have been trying to install SQL Server Express for a few days now. I tried 2008, 2012, and now 2014 all with the same result. I cannot connect to the database remotely, even if I turn the firewall ...
10
votes
8answers
27k views

Is using integrated security (SSPI) for accessing SQL Server better for web applications?

When deploying web applications (.net) to a production environment, is it better to use integrated security or does it even matter? It seems to me that if a hacker breaks the web server, it won't ...
1
vote
1answer
25 views

Using AWS, EC2, can't reach port 1433 for sql server

we're using two AWS EC2 instances, win 2012 servers, one for MS SQL Server and one for IIS. IIS is unable to reach port 1433 on the SQL Server. Here's what we've tried: Checked VPC setting and no ...
12
votes
1answer
2k views

Delete performance for LOB data in SQL Server

This question is related to this forum thread. Running SQL Server 2008 Developer Edition on my workstation and an Enterprise Edition two-node virtual machine cluster where I refer to "alpha cluster". ...
4
votes
3answers
1k views

Map sql's BUILTIN\Administrators to Windows Administrators Group

Logged on as 'Administrator' (and a member of just one Group - Administrators) i am seen as God (ok ... god) to the SQL install. Where do I bestow the same level of permission to all members of the ...
0
votes
0answers
10 views

SQL Server Licensing Proof [duplicate]

I have a SQL Server 2008R2 installation that was purchased back in 2012. Our network admin did a MS SAM Audit and is requiring proof of purchase etc. I cannot find it in my records anywhere. Is ...
1
vote
0answers
19 views

Certificate is not showing up in SQL Server

I need to say first that I am not a DBA and so, my problem is getting SQL Server Configuration Manager to recognize a certificate. I have 3 SQL Instances I work on, 2 are on the same network, the ...
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
141 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 ...
1
vote
0answers
38 views

Move Azure SQL database server between subscriptions

We have two subscriptions (DEV and PROD). A database server has been deployed to the DEV subscription, but it is now in use by our production system. I want to move the Azure SQL database server to ...
4
votes
1answer
2k 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
0answers
19 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, ...
2
votes
0answers
33 views

SQL Server without memory reservation completely hangs

We are currently experiencing failures on our SQL Server machines. It appears that once a server on the same (VMWare) host as our SQL Servers starts a maintenance procedure. The SQL Servers will ...
6
votes
2answers
6k views

SQL Server Connection Timeout after load brought onto IIS web server

We have MSSQL 2008 R2 running on windows 2008 r2 it's being hit by 2 server 2008 r2 webservers running asp.net. Both are joined to an active directory domain and use integrated authentication to ...
1
vote
2answers
34 views

SQL2012 Evaluation expired - Trying to upgrade to fully licensed 2014 version

We have a dev box that one of our developers installed SQL2012 on. The problem is he used an evaluation version. Now I am in the unfortunate situation of it expiring and being unable to access the ...