Tag with [sql-server] the question related to each database server that implements SQL (Structured Query Language) and not related with the specific Microsoft one. For the latter use the specific tag [ms-sql], or if related with a specific version with the relative tag [sql-server-2012], [sql-...

learn more… | top users | synonyms

2
votes
0answers
649 views

Getting error (Exception from HRESULT: 0x80029C4A (TYPE_E_CANTLOADLIBRARY) when migrating from MS Access 2013 to SQL Server 2014

OK.... I've checked and rechecked Google, StackFault, Experts-Exchange, etc... for a resolution on this error and they all say to register the DAO360.DLL and add its path to the environment settings. ...
2
votes
0answers
218 views

Error installing SQL Server

Yesterday I installed SQL Server 2014 onto a Win2012 server that has already SQL Express 2014 installed. I uninstalled/reinstalled it three times, but to no avail: The server wouldn't start after ...
2
votes
0answers
447 views

Access losing db connections

I have a weird problem going on at work. People have been using MS Access to connect to SQL Server db and lately people are getting sporadic problems with connecting to the servers. It's not always ...
1
vote
0answers
380 views

Hibernate Entities generated using IntelliJ have no Foreign Keys generated

I have a normalized SQL Server database with 20+ tables on it that created using SQL Server Management Studio 2014. I am able to connect to this database in IntelliJ and follow along with the steps ...
1
vote
0answers
196 views

How to install SQL Server ODBC driver on OSX?

I'm using MySQL Workbench on a Macbook to migrate a SQL Server database to MySQL. When I try to connect to SQL Server I get the error: The ODBC driver that was selected for the source connection ...
1
vote
0answers
40 views

Presenting relationship of rows in SQL Server

I have two tables named FORM and FORMACTION. The rows in FORM represent screens in a CRM system and FORMACTION represents which FORMs lead to which. e.g. FORM ID,NAME,LNAME 1,"CustomerD","Enter ...
1
vote
0answers
75 views

Why is sql server native client version “not marked” in odbc data source administrator?

Normally there's a version number in there:
1
vote
0answers
298 views

Connect to SQL Server. Error 26 : the type initializer threw an exception: error locating server instance specified

I have a SQL Server 2014 Express installation. It is configured for Remote connections TCP is activated mixed mode Authentications are allowed and the server firewall is deactivated My program ...
1
vote
0answers
98 views

Cannot install SQL Server 2012

I'm trying to install SQL Server 2012 and got this message: SQL Server Setup has encountered the following error: The resource 'Microsoft.SQL.Chainer.PackageData.Package.xml' failed to load from 'E:\...
1
vote
0answers
283 views

Setting up SQL Express on Azure VM

I'm trying to set up SQL express on an Azure VM. I already have SSMS 2012 installed but I cannot access .\SQLEXPRESS. This MSDN discussion says: run powershell script "ConfigureSQLExpress.ps1" ...
1
vote
0answers
828 views

SQL Server 2008 R2 - Process 6 generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process

I am running Microsoft SQL Server 2008 R2 (SP2) - 10.50.4302.0 (X64) (Latest CU11, Feb 2014) on Windows Server 2012 R2. I have a simple database and a website that runs on the same machine using IIS. ...
1
vote
0answers
80 views

SQL Server - Database with strange storage space

I have a strange problem with one SQL server database: The database takes 180GBs on disk, with no space available; while the only table it contains should use only sth like 25GBs: EDIT: database ...
1
vote
0answers
41 views

Visual Studio: Tables always added offscreen when editing EDMX files

I have a number of ASP.NET projects which utilise .edmx files to access tables on the relevant database for each app. If I add a new table, I have to open the .edmx and click Update Model from ...
1
vote
0answers
328 views

How to set up Openfire XMPP server?

I have installed Openfire and Microsoft Sql Server Management Studio 2102 on my PC. I have made a database called openfire, conected to it, and have executed the script called openfire_sqlserver.sql ...
1
vote
0answers
194 views

Importing data from database into Excel Web Services with parametres

I need to enable people to import the data they need from an SQL Server database into Excel Web Services in SharePoint. They should be able to choose certain parametres for the query. So, for example, ...
1
vote
0answers
520 views

Change language of error messages in Windows 7 x64

My Windows 7 installation had Russian localization. When I encountered errors, I thought to translate the errors to Google into English. I decided to change the display language to English. In "...
1
vote
0answers
338 views

View numeric columns in hex - SQL Server Management Studio

In SQL Server Management Studio, when I run a query which outputs a numeric column (int or similar types), they are displayed in decimal (example: 193). I want them to display in hex (example: 0xC1). ...
1
vote
0answers
49 views

Visual Studio 2010 DON'T CLEAR Query if doesn't succed or syntax error

In VS2010 when you perform a query against database if the query itself has any syntax error the VS by default clears all text from screen. This makes you to type again the text and resolve syntax. I'...
1
vote
0answers
162 views

Errors while installing SQL Server SSIS 2005

I was trying to use SQL Server SSIS 2005 for the first time and mysteriously all the SQL SSIS menu items were missing from my start menu and then from the BIDS project choices even though I did a full ...
0
votes
0answers
16 views

SQL Server 2016 Enterprise silent install

I'm trying to install SQL Server 2016 Enterprise unattended and I can not do. I have the original ".iso" image (SHA-1: 4B782D6B2512ED1844EF2B2549DB2C586D6BE88E) ;SQL Server 2016 Configuration File [...
0
votes
0answers
16 views

SQL Server Management Studio 2016 is always prompting me for scripts

I started using a database on Windows Azure and downloaded myself the SSMS 2016 to administer my DB. I haven't used SQL Server in a while and with the 2016 version every time I want to administer the ...
0
votes
0answers
14 views

Disable Excel Data Connections when no connection to the database

Is it possible to pause/disable Excel data connection on a macro? I don't want to remove the data connections, I would just like to create an option to disable them if the user can't connect to our ...
0
votes
0answers
28 views

SQL Server 2014 Express has reached database size limit. What is the quickest solution?

My SQL Server 2014 Express database has reached database size limit. What is the quickest solution to get back up and running? Is Express software the same as the full version, with just some ...
0
votes
0answers
9 views

sp_send_dbmail spamming Event Log

I have some unknown but work-relevant process on my development computer executing every 10 seconds. It calls a stored procedure in SQL Server. Part of this stored procedure is to call ...
0
votes
0answers
19 views

System Center 2012 R2 App Controller will not connect to SQL Server

So I am trying to implement App Controller 2012 R2 in my Hyper-V setup. I am running 1 VM that has 2 instances of SQL Server 2012 Developer edition (Default and Erpdev) and one with SQL Server 2012 ...
0
votes
0answers
25 views

Can Excel dropdown list be powered by SQL table (or view)?

I want to enter contractor acronyms into Excel cell. I want to achive: Validating contractor acronym with SQL table/view Autocomplete contractor acronym with SQL table/view while typing SQL table/...
0
votes
0answers
23 views

Accessing Static Internal IP from outside my LAN

I have a static private(Internal) IP for my desktop PC and i have a sql server database on this PC that i can access inside my LAN from any other computer , but when i connect to a wifi outside my LAN ...
0
votes
0answers
11 views

SQL Server Management Studio 2008 UI Issues

I work in a Citrix VDN virtual machine. When I get disconnected from my session and come back in, SSMS UI has a bunch of mini windows exploded all over the screen (sorry, no better way to describe it)...
0
votes
0answers
10 views

Curious search behavior in Sql Server 2014, searching for dot also returns comma results

Background I'm getting some unexpected search results, consider the following pseudo-query: SELECT SomeField1WithSearchCriteria, SomeField2WithSearchCriteria, ...
0
votes
0answers
14 views

installation issue in windows 8 sql server 2008

I have installed vs 2010 ultimate and sql 2008 in windows 8.but after installation sql is not found.i checked in C:\Program Files (x86)\Microsoft SQL Server\100\Tools\Binn also.There is an INSTALLOG ...
0
votes
0answers
5 views

AAA server with GUI and alert system

I am working on a project in which I plan to display the logs generated by an AAA server in a user friendly GUI view. Then evaluating the logs of the database, if any unprivileged user tries to access ...
0
votes
0answers
39 views

Risks of changing the account MS SQL Servers run under

I have a MS SQL Server 2008 R2 that was setup and is running under a "Virtual System Account" (NT Service\MSSQLSERVER). The problem is, that MS SQL Server isn't able to do backups (from within SQL ...
0
votes
0answers
62 views

Localizing SQL Server Reporting Services (SSRS) in Chrome

We have a report in SSRS that our users open in Chrome. The English version works great. However, we notice that Chrome does not appear to localize the built-in controls when we change the browser ...
0
votes
0answers
51 views

What is the best way to archive a large SQL DB table

Question: I am looking for recommendations on how to archive about 80% of the data in a SQL DB table. Software: I am using SQL Server Management Studio on a windows server. Background Info: I have ...
0
votes
0answers
33 views

MS SQL 2012 Express hangs on add DB when you click the files tab

I'm running SQL Express 2012. Sometimes when I'm restoring a DB and click on the files tab to link the DB to the actual files, the management studio just hangs. I manage a large number of small DB's, ...
0
votes
0answers
16 views

Cannot connect to SQL Server 2008 R2 from 3rd party program

I am running SQL 2008 R2 on a pc. I usually connect to a server instance from a 3rd party program all on the same machine, but suddenly I cannot connect. When I try I get message about network ...
0
votes
0answers
25 views

Export from SQL server 2008 to Excel 2013 put results on specific cell

I'm using SQL Server 2008 also i have Excel 2013, i have query to return count, and now i'm looking to export the results to excel sheet that "already created" and put the results on specific cell, ...
0
votes
0answers
41 views

Plesk Windows server & MSSQL

I am running Windows Server 2012 R2 with Plesk 12 and SQL Server 2014. Going to : Home -> Tools & Settings -> Services, I can see with green : SQL Server (MSSQLSERVER), SQL Server (...
0
votes
0answers
18 views

How to detect if someone is running perfmon locally or remotely against my server

One of my Microsoft SQL servers is lagging and I'm wondering if someone is running perfmon on it either locally or remotely - how can I detect if someone is running perfmon on the server (either ...
0
votes
0answers
72 views

Why does SSMS incorrectly report an invalid object name when the object does exist?

Why does SSMS incorrectly report an invalid object name when the object does exist? e.g. the table BinCollectionDay is in the current database And even better, how do I stop the incorrect ...
0
votes
0answers
13 views

Sql Blocked Query automation

I am running a Windows server 2012 standard and SQL Management Studio 2012 on it, i would like to get a dump of all the blocked queries to a excel sheet, if the queries get accumulated (greater than)>...
0
votes
0answers
8 views

How can you edit the list of servers displayed in the SSMS Connect to Server dialog?

How can you edit the list of servers displayed in the SQL Server Management Studio "Server Name" field of the "Connect to Server" dialog? I've got various old servers that I'd like to remove from the ...
0
votes
0answers
20 views

Can I simply rename a TDE-encrypted SQL Server database?

I encrypted an SQL Server database using TDE.  What happens when I rename the database?
0
votes
0answers
318 views

SQL Installation hanging on windows 10

I've tried installed every version of SQL Express I can get my hands on (And I've got the MSDN SQL 2016 CTP 2). Everythings hangs, and always at this point. I've a feeling its a .net related issue ...
0
votes
0answers
53 views

See SQL Server Reporting Services without logging in?

I have installed SQL Server 2015 with SSRS and I have some reports I need to run, but in order to access http://reportsserver/Reports I need to start Internet Explorer in administrator mode. This is ...
0
votes
0answers
60 views

RDP, IIS, SQL Server no longer working

Remote desktop, as well as SQL Server 2008 R2, as well as IIS 7.5 have all mysteriously stopped allowing connections via my local network. Originally, I thought that this could be the result of a root ...
0
votes
0answers
241 views

How to port forward through two routers in a network

I am trying to connect my SQL server through public network. So, I am having lots of problem in understanding it. One router is AirOS's(Outside my house) another is Iball's Baton(Inside my house). ...
0
votes
0answers
27 views

Error When Logging In

I am able to log in with Windows Authentication, but my user account does not have any permissions to perform the operation (e.g. Exec, grand, alter, create…etc). Even though I am not able to create ...
0
votes
0answers
86 views

Unable to open SSMS from run window

I'm having an issues that bugs me and can't seem to be able to solve it. I have SQL Server 2005 and 2012. For the 2005 instance this is my path (for both 2005 and 2012 the path that leads straight to ...
0
votes
0answers
22 views

How do you create a sql 2014 cluster disk for a cluster across multiple hyper-v machines

I have an SQL 2014 cluster spread across multiple physical machines running Windows Server 2012 and Hyper-V. I'm attempting to install Skype for Business 2015. However the install script appears to ...