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)

3
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 ...
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 ...
-3
votes
0answers
13 views

How many SQL server 2016 RCs will there be? [on hold]

I understand SQL server 2016 is at Release Candidate 3. Does anyone know about how many RCs there will be until the final one gets launched? (Based on past SQL server RCs). Is RC3 close to the final ...
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 ...
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 ...
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 ...
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 ...
1
vote
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. ...
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. ...
10
votes
1answer
2k views
+50

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". ...
-1
votes
0answers
12 views

Multiple sub-queries … Better way to [on hold]

I have a table with products stock in a specific date (a day) of some products ... Not everyday has a stock record if there aren't stock movement ... This is my table : Table : Stocks Columns : ...
1
vote
0answers
12 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
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
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 ...
-1
votes
0answers
8 views

Website issues with internal accessing

we are facing a problem within my organization. The problem we are hosting a website internally and allowing public to access it. Public can easily access the website, but for internal users only ...
0
votes
0answers
14 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
35 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
17 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 ...
0
votes
0answers
3 views

Transactional replication using articles filters and delete operations [migrated]

The problem with transactional replication using articles filters and delete operations. I have a problem with my transactional replication when I use articles filters and delete operation. When I ...
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
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 ...
3
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 ...
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
0answers
17 views

Consolidating various applications and databases [closed]

I'm hoping that you may be able to advise me how to best consolidate and reduce the number of servers that we currently have applications and databases reside on, in our Windows estate. I'm going to ...
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 ...
0
votes
0answers
18 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
28 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 ...
5
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
29 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
32 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 ...
0
votes
1answer
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 ...
1
vote
1answer
42 views

Azure SQL reserve external IP

How can I set an Azure SQL database to have a fixed static IP? We are using the Resource Group model - I can reserve IPs no problem and I can assign them to VMs easily but I cannot see how to assign ...
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 ...
2
votes
3answers
1k views

Retrieve MS SQL database or table structure in XML

Is there a way to export the database schema in well formed XML of a MS 2000 SQL Server. I'm looking for just the structure not the data and the more detailed the better. The XML may be used in a ...
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: ...
-1
votes
0answers
5 views

SSRS Reports in Dynamics CRM

I am currently working on SSRS and CRM Prem. connectivity. I have SSRS report which show detail information for specific client where I am passing GUID as ClientId to fetch all values in report. ...
-1
votes
0answers
25 views

Pricing of SQL Server with Remote Access [duplicate]

This isn't necessarily a technical question, but I thought Serverfault would know best. If I want to run SQL Server Management Studio on my local machine in order to access / modify a SQL Server ...
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 ...
-1
votes
2answers
45 views

MS SQL Server 2 identical databases on different servers replication or mirroring to each other possible? [closed]

Hi: I have one free version of SQL Server 2012 express database running on Amazon AWS with 1 CPU and only 1 GB Ram . As you can see the CPU and RAM power are barely enough for my PHP scripts running ...
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
0answers
36 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
14 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 ...
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 ...
1
vote
1answer
11 views

SQL Server Agent Service - SSIS package scheduling not working

We have a local admin privilege to our VPN users and we have created SSIS packages but not able to run it through SQL server agent services as its not allowing to run throwing error being ...
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 ...
6
votes
2answers
3k views

How to Rename a Database on a SQL Server Amazon RDS Instance?

Attempts via SQL Server Management Studio and Transact SQL to rename a database hosted on a SQL Server Amazon RDS instance result in the following error. User does not have permission to alter ...
0
votes
1answer
17 views

Does transferring a database to a new SQL Server instance lose statistics and execution plans?

I am transferring a database to a new SQL Server and was wondering, will it lose it's execution plans and statistics that its collected over the years for the benefit of performance and have to start ...
1
vote
5answers
2k views

SQL Server: Read .ldf files [closed]

Is there a free tool to read .ldf (Sql server database transaction log files) files ? Thanks in advance, Albert
0
votes
0answers
14 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 ...