Questions tagged [sql-server]
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-server-2008]...
769
questions
12
votes
1
answer
49k
views
Why don't I have SQL Profiler on SQL Server Management Studio?
I'm running SQL Server Management Studio 2008 (Microsoft SQL Server Management Studio 10.0.1600.22 ((SQL_PreRelease).080709-1414 ))
However I cannot find the option to open SQL Profiler.
I was ...
1
vote
0
answers
135
views
Redgate SQL Data Compare - Command LIne Output File
I am comparing 2 databases via command line. When I execute the following command:
SQLDataCompare /project:"C:\CompareFiles\compare_AW1_AW2.sdc" /Include:table:[Users] /Out:"C:\Users\mthurman\...
2
votes
1
answer
3k
views
MSB4018: The "SqlBuildTask" task failed unexpectedly ==> System.OutOfMemoryException
Sometimes, rebuilding my solution I get following error. Solution is huge, 270+ projects and I have no idea how to get rid of this error. It happens sometimes, most of the times solution builds ...
0
votes
1
answer
66
views
Can I add a password for SQL Server "sysadmin" role?
I need help in adding password to SQL server role. Actually I'm working on SQL server and Sybase ASE. In Sybase I can add a password for SA_ROLE & SSO_Role. Can I do the same in SQL Server?
...
1
vote
0
answers
225
views
Connect to an SQL Server (MSDE 2000) on a remotely hosted virtual machine
We have this old program that requires Windows XP and SQL Server MSDE 2000. We have solved the problem by installing Windows XP in VirtualBox. When inside the premises, we access the program via MS ...
0
votes
1
answer
777
views
Program connecting to SQL over port 445
I have a program called VHI(Visual Health Information - Network Version) that is a server/client model. I have installed the server portion and has a database. SQL Server Name\instance = "EDSERV03\...
0
votes
0
answers
801
views
Excel, ODBC - desired database not listed
When I attempt to create an ODBC to a server (named DARKHELMET for all you spaceballs fans out there) it doesn't show in the list of available data sources.
..but it does show up under data source ...
0
votes
1
answer
6k
views
Downloading MS SQL Server 2008 Standard edition
I want to download MS SQL Server 2008 with business intellegence standard edition. But I don't know how to download it, because the one I got was EXPRESS edition and everytime I run the x86 FULL 2008 ...
1
vote
1
answer
12k
views
How to calculate percentage with a SQL statement? [closed]
i have two sql tables i want to compare two tables ..comparing two tables is done now what i want is how many records are matched and not matched in the form of percentage .is it possible to write a ...
9
votes
1
answer
24k
views
Additional User Account, Windows Authentication in SQL Server Management Studio
I am transitioning my work laptop to a coworker (who we'll call Mary Smith) who is taking my place on my team as I move on to other things. One of the tools we use is Microsoft SQL Server Management ...
0
votes
0
answers
1k
views
Can not uninstall SQL Server 2017
I had SQL Server 2014 before installing SQL Server 2017; after I had installed SQL Server 2017, I decided to uninstall SQL Server 2014.
I can uninstall SQL Server 2014 completely, but when I tried to ...
4
votes
2
answers
12k
views
Unblocking Windows 10 Defender Firewall for MS SQL Server 2014
I have an instance of MS SQL Server 2014 (call it MSSQL) on a Windows 10 machine (call it WINTEN).
Running SSMS on WINTEN, I can connect to both the local SQL Server and also to SQL Server instances ...
3
votes
2
answers
4k
views
I can't "unmaximize" my window
I've got a windows app (I don't think it matters which one, but in case you're wondering, it's SQL Server Profiler) that I can't put back into "windowed" mode. I can maximize or minimize it, either ...
15
votes
1
answer
248k
views
Default SA password of SQL Server automatically installed by SharePoint Server 2010 setup
I installed SharePoint server 2010 recently on a test server. It was installed in standalone mode.
After the installation, I realized that it had installed SQL Server Express 2008 (10.0.2531.0) ...
0
votes
0
answers
441
views
Batch Error SQL Server BULK INSERT
I am attempting to have a script in my batch file that runs a SQL Server Stored Procedure. The Stored Procedure bulk inserts data from a .CSV file into a SQL Server table. When I run the Stored ...
0
votes
1
answer
1k
views
SQL Server 2012 repair/installation fails
We have a Windows 2012 R2 server and want to run MS SQL Server 2012.
It seems like someone attempted installation a while back but it is not installed properly since SQL Server does not show under ...
0
votes
0
answers
353
views
Can't connect to a SQL Server from Access
Via a Connection ODBC, we are trying to connect from an Access 2016 to a SQL Server, and we found this error message:
Both computers are in the same workgroup and they can see each other. Also they ...
1
vote
0
answers
790
views
Can't connect to database in SSMS 2017
I used to be able to connect, and now I can't. I have tried uninstalling and reinstalling SSMS. I have not changed my antivirus/firewall settings at all.
OS: Windows 10 Home
TITLE: Connect to Server
...
1
vote
1
answer
14k
views
How do I disable automated SQL Server Backups?
SQL Server seems to be doing full backups (.bak) at random intervals then storing them into,
C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\Backup
Is there an option to ...
1
vote
0
answers
423
views
Windows Authentication on Azure VM using Azure AD account from remote client
Issue
When connecting with Windows Authentication "Cannot connect to 172.16.1.5. The target principal name is incorrect. Cannot generate SSPI context." Nothing appears in the SQL Server log.
...
3
votes
2
answers
113k
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 ...
-1
votes
1
answer
4k
views
How do I connect to a MySQL database from another computer in VB.NET?
How do I connect to a database of another computer in the same local network using VB.NET? We have already enabled remote connection in the SQL Server configuration and the SQL browser, and we already ...
1
vote
1
answer
87
views
Possibility to join OVPN when user is not logged on
I am trying to achieve an automation for SQL server agent to store backups in a remote computer, but sql server agent has first to join OVPN.
I have tried all the methods described here, but in my ...
18
votes
8
answers
32k
views
SQL management studio hangs when opening after being closed down on dual screen
I have a dual screen set-up. I'm running windows 8.1. I have had this issue with Management studio 2008 R2, 2012 and 2014.
If I drag the management studio screen across to my 2nd display, and then ...
2
votes
0
answers
30
views
Anyone have success configured MySQL linked servers on SQL Server 2017 for Linux?
I am trying to figure out if SQL Server 2017 for Linux supports linked servers for MySQL? I know its possible on Windows OS if ODBC/OLEDB drivers are configured on the same server as SQL, but ...
2
votes
1
answer
12k
views
Cannot set static IP address using Netsh
I have followed this article to set the following environment:
DC: Windows Server 2008 R2 Enterprise (Full Installation) - Domain
controller for the lab network, contoso.com
SQL-A: Windows Server ...
2
votes
0
answers
96
views
SQL Server 2017 cannot connect to remote databases
I tried to uninstall some old versions of SQL Server I had installed just to free up hard drive space, and along the way I corrupted my SQL Server 2017 such that SSMS could no longer connect to any ...
1
vote
1
answer
516
views
Connecting to MS SQLServer from a Linux box
I am trying to connect to MS SQLServer from an application that I have written (using Qt) which runs on Linux. Here are some details of the setup:
The SQLServer box (SQLBox) is part of my domain (...
0
votes
0
answers
3k
views
I get "rsProcessingAborted" and "rsErrorExecutingCommand" randomly in my SQL Server Report builder report
I have a report in which I get randomly the following error after pressing the "View Report" button (because in this report I need to select a parameter value from the dropdown field first):
An error ...
1
vote
0
answers
32
views
What does it mean "Microsoft SQL 2010 R2" as an application requirement?
I have this terrible doubt of windows and hope someone of you might know what is it.
I bought a contability software (here in mexico there are few providers cause they are regulated), the thing is ...
0
votes
0
answers
58
views
Change SQL server back to a trial
I need to convert a SQL Server 2008 instance on a VM (which is licensed) back to a trial.
What are the steps to do this?
REASON for this: Need to give a VM with a custom solution on it to a 3rd ...
2
votes
1
answer
3k
views
How do I safely uninstall the many components of past SQL Server versions?
I recently installed SQL Server 2017 Express on my Windows 10 operating system (PC). I also though have installations of 2016, 2012 and apparently 2008 as well from older installs. I'd like to ...
1
vote
1
answer
2k
views
Application pool with custom account crashing
I've been developing with Visual Studio on a Windows 10 PC for the last year. I have a ASP.NET web application and a SQL Server 2014 database installed on the same computer.
I've got the site running ...
2
votes
1
answer
1k
views
How does an OLEDB/ODBC connection know the path to a SQL Server database by name only?
If i have a connection string like this that I use in a Data Connection in Excel to get data from a SQL Server database:
OLEDB;
Provider=SQLOLEDB.1;
User ID=MY_USERNAME;
Password=MY_PASSWORD;
Persist ...
1
vote
1
answer
2k
views
How to reduce the database size of MS SQL server
I have a website that runs on MS SQL Server 2014 Enterprise with two clustered virtual machines and AlwaysOn. A database backup is created each night and the size is now 20GB.
On my laptop, I also ...
1
vote
0
answers
327
views
Amazon DynamoDB, S3 or continue with SQL Server RDS for BLOB?
Right now we are using local SQL Server 2016 as the DB server and planning to move it to Amazon RDS. The issue is, currently there is a filestream filegroup in use to store some occasional binary ...
0
votes
1
answer
115
views
Can Microsoft SQL Server Management Studio run on macOS?
I know Microsoft SQL Server 2016 can run on macOS in a Docker container. But does can Microsoft SQL Server Management Studio run on macOS?
22
votes
8
answers
77k
views
Rule "Restart computer" failed when installing SQL Server 2008
When trying to install SQL Server 2008 Developer and Enterprise editions on a Windows 7 box I've got this message:
Rule "Restart computer" failed.
A computer restart is required. You must restart ...
0
votes
1
answer
464
views
Bizarre MSSQLSMS font size behavior on Windows 7
After several years, MSSQLSMS 2012 has suddenly started ignoring the font size setting:
I've tried changing it from 8 points to 4 and to 40, with no observable change in displayed font size. ...
0
votes
0
answers
73
views
SQL Backup Software (VDP) and Log Shipping
My understanding of a SQL restore operation is that a full backup is required as well as all incremental backups performed since.
Likewise my understanding of Log Shipping is that it is using a SQL ...
5
votes
1
answer
9k
views
Adding Full Text Search to my existing Sql Server 2014 installation
I have currently SQL Server 2014 installed on my computer (for testing purpose). I need to add Full Text Search functionalities. Then I re-executed the setup but I don't have any Full Text Search ...
2
votes
2
answers
301
views
How to trigger SQLServer suggestion popupmenu
I have a very big job to do on a very large SQLServer DB, with unusually large table names.
Having the popup menu suggesting the names of the tables and such, would really come in handy, but it ...
1
vote
1
answer
603
views
Linked Excel files in MS SQL server management studio
I am working on MS SQL server management studio 2014. Using linked Server, I can link Excel File as a Linked Server. I know how to link. But I want to know how can I link 5 files of Excel on a Linked ...
1
vote
0
answers
832
views
Linked Server between Progress database and MS SQL Server management studio
I wish to set up a linked server within MS SQL Server Management 2014 to access my PROGRESS DB. The Linked Server will allow us to update the tables etc and then run our queries off of SQL Server.
I ...
1
vote
1
answer
2k
views
Can't start SQL Server installation
I want to install SQL Server. I used the iso file en_sql_server_2008_r2_standard_x86_x64_ia64_dvd_521546.iso.
I extracted the files using 7zip and started setup.exe – a setup window opens for few a ...
3
votes
2
answers
3k
views
Why does Ubuntu on Windows crash on startup?
I'm running Windows 10 Insider Preview Build 17074 for PC. The Windows Subsystem for Linux is enabled and I've installed Ubuntu on Windows from the Windows Store.
Whenever I try to launch Ubuntu, it ...
2
votes
2
answers
3k
views
DQL/SQL to Excel - obtain results of multiple SELECT statements in spreadsheet
I wrote T-SQL query that contains few separate SELECT statements.
Each SELECT statement returns different number of columns and represents different properties/features, so that I don't want to join ...
3
votes
3
answers
4k
views
SQL Server Linux admin tools
I would like to know if there is sql server tools for linux?
eg. tools like sql server enterprise manager.
0
votes
0
answers
439
views
Odbc connection with Sqlserver Progress openEdge
I am working on the MS SQL server so I want to connect MS SQL Server to progress OpenEdge Database and import all data from OpenEdge to SQL Server through ODBC. I add driver from Data sources in ...
0
votes
1
answer
778
views
Azure File Share attached drive is not visible/accessible from SSMS or SSIS packages
In our DB migration project we need to migrate data from a SQL Server DB which are used by Desktop application installed in our clients location. For that we have implemented a desktop tool which ...