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], ...

learn more… | top users | synonyms

-2
votes
0answers
7 views

I would like to run a SQL Reporting Services service against my Azure Database how can I do this cheaply?

I have an Azure Sql Database. I don't have any SQL Server licences, but would like to be able to run SQL Reporting Services. Happy to pay for something, but I don't really want to pay for a full SQL ...
0
votes
0answers
7 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 ...
-2
votes
0answers
9 views

windows virtual private server database access [closed]

I got the access credentials to a windows virtual private server that has a sql server. Also the password for the sa account on sql server. I need to access some databases in that server which has got ...
0
votes
0answers
6 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
1answer
33 views

How to speed up off-site access to Access application

I built a calendar-type application on MS Access 2013 with SQL Server as the back-end (each day on the calendar is a subform). About 20 tables are connected using the line Call ...
0
votes
1answer
12 views

Clustered SQL database requires full recovery mode?

The application we provide customers with requires an SQL database. Due to the nature of the application, we recommend the recovery mode to be set to Simple as it is not critical data that is stored. ...
1
vote
0answers
38 views

SQL SERVER 2016 Plugin's not working [closed]

Recently I installed SQL SERVER 2016 in my PC Here is the detailed information of my server : Microsoft SQL Server 2016 (RC1) - 13.0.1200.242 (X64) Mar 10 2016 16:49:45 Copyright (c) ...
0
votes
1answer
54 views

MySQL won't start

I recently tried to run a basic MySQL command. Then I got the following response: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) I then ...
1
vote
1answer
34 views

Convert date from SQL text to Excel date format

I'm trying to export from my pervasive SQL database to Excel. the date is stored as CHAR(8) I need them in a recognized date format for Excel so that I can use date filtering. What do I have to add ...
0
votes
1answer
21 views

Link excel file to SQL table

In all versions of Microsoft Access, I used to link access table to any excel file. Can this be done with SQL server 2012 without the need to import the file itself?
0
votes
0answers
12 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
19 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 ...
0
votes
0answers
21 views

how to find out session id of executing ssis package through SP_target

I am executing a ssis Package which contains only one data flow task. Simply SELECT statement in source and Table in destination. I want to find out session id of this running Package in SP_TARGET. I ...
0
votes
0answers
21 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 ...
0
votes
0answers
9 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
12 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
34 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 ...
1
vote
1answer
41 views

How do I enable both PowerShell Remoting and SPN for SQL Server Reporting?

I have tried this question on Stack Exchange - Database Administrators (http://dba.stackexchange.com/q/129286/51925), but I don't get any responses, so I'll try here. I'm struggling with remoting ...
0
votes
0answers
43 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 ...
-1
votes
1answer
89 views

C# console Application with DB

i have c# program connected to SQL server and it is working very good but when i am trying to install this program in other PC it doesn't work unless SQL installed the data base is very simple .. i ...
0
votes
1answer
61 views

Remove all references to removed Sql Server database

One of my programs that I have written, creates on installation a SQL Server database. The database name is hardcoded in the sources. Now I have the problem, that on a clients machine the program was ...
0
votes
2answers
29 views

Steps Needed to Install .Net and SQL Express on Windows Server 2012

Please forgive the simplicity of this question, but I work mostly with Linux servers and older versions of Windows Server. My exact question is how are packages installed on Windows Server 20212, ...
0
votes
1answer
15 views

Can't click on SQL Profiler

I used to be able to launch SQL Profiler from SSMS with no problem, but now when the application starts I can't click on anything. It just dings at me. It's almost like there's a dialog open off ...
0
votes
0answers
40 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
1answer
24 views

How can I determine which SQL db my Access app is pointing to?

There is no ini file containing any kind of connection string so it must be embedded somewhere, but where can I find this? The linked table manager appears to point to something but doesn't give ...
0
votes
0answers
17 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, ...
1
vote
1answer
65 views

Replicated SQL Database Recovery Model

I currently have a number of large databases replicating to secondary servers for reporting purposes. The publication DBs are all in simply recovery as we back these up nightly as that's as much as ...
0
votes
1answer
127 views

Do i need all of those MS SQL server and MS C++ Redistributable?

Steam has off sale games and i have planned on getting 8 games. With that, i'm starting to prepare my computer to receive those games by cleaning up some useless stuff. Though when i was on "Programs ...
0
votes
2answers
62 views

Buying MS SQL server, confused about CAL needs [closed]

I'm extremely confused as to which version of SQL server to buy... I've found versions for around $599 and then some for around $1,100... Currently we're running Express and only need to upgrade ...
0
votes
1answer
249 views

SQL Server Management Studio 2014 won't start: Exception has been thrown by the target of an invocation

I'm on Windows 7 Professional SP1. I just installed SQL Server Management Studio 2014 using the 64-bit download from Microsoft: SQLManagementStudio_x64_ENU.exe, and when I click on the shortcut in ...
1
vote
1answer
63 views

How to debug unattended installation of MS SQL Server 2012?

How can I diagnose and debug a configuration file for an unattended installation of MS SQL Server 2012? What I'm doing -- I'm building an installer for a product. The product requires MS SQL Server ...
1
vote
1answer
20 views

How do I add an AzureAD user to SQL Server for windows authentication

When users are logging in to a Windows 10 desktop with an Azure Active Directory account how do I add them as a user to SQL Server? Using the Search dialog from the Add Login dialog doesn't seem to ...
0
votes
1answer
181 views

Upgraded to windows 10 and now can't connect to sql server 2012

I upgraded to Windows 10 on my laptop. I have opened SQL Server Management Studio, but it can't connect to the server. I have looked at a few other questions, but nothing seems to work. I get the ...
0
votes
0answers
15 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 ...
1
vote
1answer
146 views

SQL Server Results to File Creates extra lines at end

When I route the output of my queries to a file, there are one or two blank lines at the bottom. When I run the query though SSMS (2008 or 2012), I get two extra blank lines. When I run the query ...
0
votes
1answer
161 views

Port 80 used by Microsoft-HTTPAPI/2.0

The port 80 is used by Microsoft-HTTPAPI/2.0 and cannot be stopped. I have tried many solutions, but no one worked. Here is what I have done. Also, here is what is on the page : Not Found HTTP Error ...
1
vote
0answers
273 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
2answers
2k views

Where is sql configuration manager in windows 10?

I just have upgraded to windows 10. I can't find sql server configuration manager. I have MSSQL 2008 and 2014 installed but there is no configuration manager in All Apps. This is just a picture of ...
0
votes
1answer
19 views

Copy columns between tables in different servers

Recently I moved to SQL Server 2012 from SQL Server 2005. Current scenario worked without any problem in SQL Server 2005. 1)Connect to server A 2)Open table X 3)Copy 3 columns(Clicking ...
0
votes
0answers
23 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, ...
2
votes
1answer
665 views

How do I allow multiple people to open my Access database?

I have an incredibly simple Access database. It has one pass-through query and that's it (no tables). The query simply executes a stored procedure against a SQL Server database to display the ...
0
votes
0answers
38 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 ...
1
vote
0answers
154 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 ...
0
votes
1answer
76 views

SQL server missing in ODBC

I installed a SQL Express server on a 32-bit Windows 2008 server r2. I installed this while installing a Phoenix fueling station program. When I am trying to add a user DSN in ODBC I am unable to find ...
0
votes
1answer
111 views

SQL Server Management Studio (SSMS) 2012 slow to show results in Grid only

I generally use Microsoft SQL Server Management Studio 2012 (11.0.3000.0) with query results being displayed in a grid. As of 3 or 4 days ago query results have been quite slow, but only ...
1
vote
1answer
61 views

How best to check connectivity of web server to database?

Our IT admin is asking for an api endpoint in our web application to use as a health check. The logic in the api should perform any simple database query to ensure that the web server can connect to ...
0
votes
1answer
62 views

Replace a filepath column in SQL with new file structure

I have recently changed the structure of a drive where I keep a lot of my 'estimating' files. The problem is, I use a program that has references to some of those files, in the old structure, stored ...