The MS SQL Server is a database management relational database created by Microsoft in partnership with Sybase in 1988 and inserted as a complementary product to Windows NT. Tag questions specific to a version with [sql-server-2012], [sql-server-2008], etc.

learn more… | top users | synonyms

0
votes
1answer
69 views

How to access SQLite database?

I have run BinDiff on two binary files, and stored the results in a .BinDiff file. (Which the manufactures assure me is just an SQLite database. How would I open and access this database?
2
votes
4answers
482 views

MySQL - “Root Element is Missing”

Something has happened to the MySQL server installation on my computer. Normally, the MySQL notifier program, which is supposed to start automatically and run in the system tray has stopped starting ...
0
votes
0answers
20 views

Trying to install SQLExpress tools goes nuts, attempts to install Ati Radeon driver

This applies to all of the downloads with tools, the database itself isn't the problem. Attempting to follow what's going on I find it unpacking itself into a directory on the drive with the most ...
0
votes
0answers
276 views

How to install Mahout on Windows 8.1?

My goal is to build up a recommendation system and after going through many articles, I came across Mahout as a simple, yet effective way to go on. I already have XAMPP installed on my system. How ...
0
votes
0answers
181 views

How can I access my home MS SQL Server DB from a remotely hosted web service?

As can probably be seen (if not already see below) I am fairly networking illiterate. Here is what I would like to do: Setup a SQL Server DB hosted on a computer I have in my home. I want to be able ...
0
votes
0answers
470 views

Windows could not start the SQL Server (mssqlserver) service on local computer error 17058

I'm working with a virtual machine on Windows 8. There is a SQL Server 2008 on the virtual machine. And in the services, when I try to start the SQL Server service I am getting an error like this:
0
votes
1answer
33 views

MS Access Autonumber dilemma

I am using a sql query that will copy the data from one table to another. The problem though is the counter which I put in the Second table of my Insert into Select Statement. It all started from ...
3
votes
3answers
4k views

Cannot find one or more components. Please reinstall application

I am running Windows 8, 64 bit and have SQL Server 2012 installed. I downloaded the client tools, looked in the directory for SQL Server Management Studio, and see it's there. When I try to run SQL ...
0
votes
2answers
1k views

How do I login to MS SQL server ? authentication

I have no idea on how SQL works. I'm just trying to use a program that is using SQL Server. I have SQL Server 2005 and 2008. In my start menu I only see a list of programs in 2008. In the 2005, I ...
0
votes
1answer
485 views

Connecting to a local SQL Server instance fails with an error

I have installed MS SQL Server 2008 R2 with authentication mode but when now when I click to the connect I gives such kind of error: A network-related or instance-specific error occurred while ...
0
votes
0answers
68 views

OTRS and MS SQL Server

I'm installing OTRS Help Desk for our organization. We're installing the application on a CentOS server but would like to connect to a Microsft SQL Server database. However, I was not able to install ...
0
votes
1answer
95 views

Unable to run dtsx package

Error is thrown "To run a SSIS package outside of SQL Server Data Tools you must install SSIS log provider for SQL Server of Integration Services or higher." When I am trying to run package from ...
0
votes
1answer
54 views

SQL : swap 2 values in a column without using an intermediate value

Given a table with a single column containing only 2 values, say 'A' and 'B', is there a way to swap them in a single statement Ex: A B A B to B A B A It is a trivial process if we use a bit ...
2
votes
0answers
240 views

Calculation takes forever in large data set on Excel

I connected my excel to ODBC SQL Database(SQL Server) and now my excel pivot table is getting its data from the sql server VIEW. There is a total of about 1 million plus rows from the QUERY. From the ...
1
vote
0answers
44 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 ...
0
votes
0answers
20 views

SQL Server and Windows 2008 Firewall rules

I have SQL Server Express 2008 installed on a Windows 2008 R2 box. There is a 3rd party application which needs to access SQL Server over the network. For some reason, the app is unable to do this, ...
0
votes
2answers
2k views

Error message on SQL Server 2012 install

I am trying to install SQL Server 2012 Standard Edition on my Windows Server 2012. The installation keeps failing, and I have tried everything that I can come up with, but nothing helps. The error ...
0
votes
0answers
114 views

TFS 2012 Backup configuration fails. “TF400998: The current user failed to retrieve the SQL Server service account information”

I'm at a loss with trying to find a solution to this issue. When I am trying to create a backup plan in TFS 2012 I get "TF400998: The current user failed to retrieve the SQL Server service account ...
0
votes
1answer
89 views

Can't open SSMS - stating I don't have permissions

Whenever I try and run SSMS I get the following error. 'Windows cannot access the specified device, path or file. You may not have the approiate permissions to access the item. ' The dialog box ...
0
votes
1answer
55 views

MS SQL Server 2012 drives

I am buying machine for MS SQL Server 2012 Standard and I have questions about drives and performance. How to locate OS, database, logs, backup on WD RE4 500GB and Intel SSD DC S3500 120GB? OS, ...
3
votes
1answer
42 views

SQL Server 7 Transaction Logs Issues

Over the week my database server transaction log was full. With our app people could select from the database but could not update or insert into the database. In the past we have just truncated the ...
-1
votes
2answers
676 views

Files left after uninstallation of MS SQL Server

I just uninstalled MS SQL Server 2008 from my machine (using the "Uninstall or change a program" feature in Windows Control Panel). Now I notice that there's still a lot of files left. Around 1 GB ...
1
vote
1answer
164 views

Deployment Fail During Generate Star Schema

I am Using SQL Server Data Tools for Visual Studio 2012 for Generating Start Schema.I am using one Database with four Tables.When i am Click on Start Button. I Got This Error The project could ...
1
vote
0answers
153 views

excel sql server error: Invalid object name

I access a stored procedure on a Microsoft SQL Server 2005 database within excel using Select * from [dbo].[fn_ph_by15minbyQueue] ('2013-09-01','2013-09-30','LocationCode') in the data ...
0
votes
1answer
75 views

SQL Server Unattended Install through SSH

I'm trying to install SQL Server from the command line through Cygwin open-ssh. The install works when I log onto the server as Administrator and execute the script through a Cygwin shell, but the ...
2
votes
2answers
1k views

Can't connect to local Sql Server while connected to a VPN

We have a Sql Server in our office here that I connect to regularly. No problems. We have a client now to whose VPN we need to connect using the Windows VPN software. When I connect to the VPN ...
0
votes
0answers
16 views

Why must I add SSMS to Firewall to be able to connect as CLIENT

This issue is confusing me very much. I am connecting to a remote SQL Server (through VPN) and was unable to connect to it at all until I disabled the windows 7 firewall. I didn't want to ...
2
votes
1answer
711 views

Is SQLCMD part of the DB Engine or Client Tools?

We have hundreds of locations where our software is installed, and it used to use SQL 2005 Express. As part of an upgrade to our software, we are doing an automated upgrade to the DB Engine to SQL ...
2
votes
2answers
414 views

understanding Microsoft Download Center naming convention

The following are the download names for SQL Server Express Editions. SQLEXPR_x86_ENU.exe SQLEXPR_x64_ENU.exe SQLEXPR32_x86_ENU.exe The machine I have is a 32 bit intel machine. Which one should ...
1
vote
0answers
30 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 ...
0
votes
2answers
3k views

how to synchronize local and remote database?

I have a database in SQL server on local computer, we have the same database on remote p.c , i want to sync it with remote server, is there any script for SQL server or any plugin? Thank you. OS: ...
0
votes
1answer
105 views

What is the thread_stack in Oracle and MSSQL compared to MySQL

I'm using a recursive stocked procedure in MySQL and had to change the thread_stack value in the my.ini from 128K to 512K. I need to deploy the same procedure now to an Oracle and Microsoft SQL ...
0
votes
2answers
169 views

How can Windows performance counter data be saved directly to SQL Server tables?

I would like to log data from a given set of Windows performance counters directly to tables SQL Server. Does Windows provide a way to do this without writing a custom application to do so? If so, ...
0
votes
2answers
2k views

SQL Server Express while attaching a database getting error 5120

I have SQL Server Express installed on my local machine. When I try to attach a database file, it's giving me the following error Unable to open physical file "C:\Adventures2012_data.mdf. ...
0
votes
0answers
26 views

How to setup a unix-based MySQL database to be accessible remotely?

Please forgive my likely noob question, but I am new to SQL in general, and am having trouble configuring my server. Background -- I have a mysql server running on unix. I formatted a database using ...
0
votes
1answer
40 views

Visual Studio and SQL Server

I've been looking for users that have development tools installed within a company and have identified many that have Visual Studio and believe they need to keep it because they do SQL Queries. In my ...
0
votes
1answer
342 views

List of Services for SQL Server 2012 Express

I recently installed VS2013 Preview onto a clean OS and I'm trying to figure out if SQL Server Express 2012 got installed. Unfortunately, when I look in Control Panel->Administrative Tools->Services, ...
0
votes
2answers
1k views

Remote access sql server 2005 over internet

I find so many similar question/problem and go through but unable to solve my problem. As so I am repeating the question again. I would like to connect my sql server 2005 remotely over internet. I ...
0
votes
0answers
39 views

How to cancel all sql server jobs without starting ms sql server process

I am using ms sql server 2012, at the midlle of huge query execution, my system crash so i decided to end task ms sql server process. Now, each time i want to start ms sql service my system crash ...
1
vote
1answer
605 views

Query parameters in an external connection to sql server

I want to do exactly this:http://dailydoseofexcel.com/archives/2004/12/13/parameters-in-excel-external-data-queries/ but I want to do it in Excel 2010 and also I am querying SQL Server instead of MS ...
1
vote
0answers
40 views

Microsoft Server Deployment Training [closed]

I am creating a learning plan to become more proficient in deploying Windows 2008 Server R2 and Microsoft SQL Server 2008 and 2012. This is a work related goal, so getting a certificate or pass/fail ...
0
votes
3answers
50 views

Removing Microsoft SQL Server

I have quite a lot of Microsoft SQL Server installed on my computed which I'ld like to unistall. They were probably used by the previous computer owner, who used it for his software developing, and ...
1
vote
1answer
332 views

SQL Server Express “hangs”, on startup

I recently installed SQL Server 2012 "Express", and, also, Visual Studio 2012. I was working with it, and all worked ok. At some point, a few hours ago, SQL Server Express, however, started ...
-1
votes
1answer
1k views

.NET Framework 4 Extended?

To avoid XY, I will preface with the following: I am trying to uninstall an unneeded installation of MS SQL Server 2008 R2 on a production server. The server is also running SQL Server 2008 Express, ...
0
votes
2answers
196 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 ...
0
votes
0answers
68 views

SQL Server Data Tools Explore Data error

I am reading a step-by-step book to learn more about SQL Server Analysis Services. I am creating a dimension for an AdventureWorks data source. In the Design Diagram pane, I right click on the header ...
1
vote
2answers
67 views

SQL Management Studio external database only

I'm trying to speed up my PC, and I figured out that a full version of SQL Management Studio 2012 is installed including localhost server. I only need to connect to remote hosts, so running a local ...
-3
votes
2answers
82 views

how to create website using asp.net and sql server 2005 as backend? [closed]

How to create website in asp.net and sql server 2005 as backend? And i wants to know it is possible to use stored procedure in this Website? How to upload this website into server?
0
votes
2answers
1k views

Cannot uninstall SQL Server 2005, no matter what I do

Windows 2003 Server R2 64 bit I do Control Panel, remove programs, and get: Setup failed.. the dialog box disappears so fast that I am unable to write down all the messages, but the items get the red ...
0
votes
1answer
120 views

Microsoft.SqlServer.SMO.dll issue in powershell

I dont have a sql server installed in my server. I am designing a powershell script that can execute sql scripts remotely in a db. I have powershellv1.0 in my server and dont have ...