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

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 ...
1
vote
1answer
1k views

How to save Windows credentials to a data source in SQL Server Reporting Services 2008 using Visual Studio

I am trying to create a shared data source for SQL Server Reporting Services 2008 that uses a specific Windows user ID and password to connect to the database. Using the Report Manager web interface, ...
1
vote
1answer
344 views

Opening offline version of Microsoft Books Online in browser

I often use the MSDN website for language reference. In order to make navigation faster, I downloaded the offline version of SQL Server 2005 Books Online from here: ...
1
vote
1answer
638 views

What do these Microsoft Updates do, and why can't they configure correctly?

MB: Biostar M7NCG 400 CPU: AMD Athlon XP 2200+ 1.8GHz RAM: 2.5GB (I don't know the speed, but does it really matter?) Display: NVidia GeForce 4 TI 4200, with hardware support for ...
1
vote
3answers
552 views

Is there a way to restrict direct write access to the database in Microsoft Access 2007?

I'd like to set up an Access (2007) project that contains queries on a database (actually in MS SQL Server 2005), but I don't want to allow any direct writing to the database. How can I make it ...
1
vote
1answer
259 views

Installation error while Installing SQL Server 2014 Standard Edition

I have tried to install Microsoft SQL Server 2014 Standard Edition and it is giving the error: TITLE: SQL Server Setup failure. SQL Server Setup has encountered the following error: ...
0
votes
2answers
441 views

SQL Server Licence in MSDN

I had bought a VS2010 Professional version licence through our corporate licence. I was recently browsing through the MSDN product download page and found that SQL server download were available for ...
0
votes
4answers
752 views

Sharing Excel sheet over network?

Is it possible to have a server PC running a Microsoft Excel sheet to which several Thin Clients, with Barcode Scanners, will be connected via TCP/IP? The scanners should dump their data in the Excel ...
0
votes
2answers
3k views

How to turn off IIS forever?

I have just installed Sql Server and it needed IIS. Now when I go to http://localhost/ I get -2147467259 (0x80004005) I bet its IIS. How to turn it off and remove it from autostart?
0
votes
4answers
1k views

How can I model a pre-existing SQL database structure?

I have a MS SQL database that has been running strong for 10+ years. I'd like to diagram the database structure, without spending hours laying it all out in Visio or something similar... I've ...
0
votes
1answer
1k views

Reducing system disk space usage on computer with SQL Server

The disk usage on my computer continues to rising with time. How can reduce his size without damaging programs and windows. The disk is SSD with 180 GB, because of that this is sensitive to me ! ...
0
votes
2answers
4k 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 ...
0
votes
3answers
5k views

Recommended utility to import .csv files into Microsoft SQL Server 2008 R2?

I'd like a better method to import .csv files into Microsoft SQL Server 2008 R2. The default import wizard maps everything, by default, to a varchar(50), even when its quite obvious that its a columm ...
0
votes
4answers
19k views

How to obtain the Windows product id from registry from a remote machine

Would like some assistance on how to obtain the Windows product id from the registry that will work where the WIndows (Windows 2003 Server, 2008 Server) is on a Domain or Workgroup and a remote ...
0
votes
3answers
15k views

SQL Server not working after upgrading windows 10 from windows 8.1

My Sql server 2012 has stopped working and now its not letting me login. Here is the error: https://drive.google.com/file/d/0ByGXmosQgHUqdGw4alFSb3otVkk/view?usp=sharing TITLE: Connect to Server ...
0
votes
2answers
2k views

How do I connect to some local DB server in MS SQL Server 2012? [closed]

I installed MS SQL Server and now want to create some tables and do some queries ... I need to have some local DB Server running to do that right? When I installed SQL Server there was no option to ...
0
votes
1answer
169 views

Error in installation of SQL Server 2008 Management Studio

I have installed SQL Server 2008 Express on my machine but I can't find the Management Studio. I downloaded two versions of SQL Server Management Studio, 2008 and R2 This is the result I don't ...
0
votes
4answers
488 views

What is the best way to manually edit and update data within a large table in MS SQL Server?

I have a table in MS SQL server which currently has around 800 records and 20 columns. I want to manually update and add to the information within this table on a frequent basis. Would exporting the ...
0
votes
2answers
3k views

Error code 0x80070001 on Windows Server 2008

I've been struggling to get Windows Server 2008 running on a virtual machine. I use VMplayer and want to install Windows Server 2008 Database and Enterprise from MSDN AA. The server is running now but ...
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. ...
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
126 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
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 ...
0
votes
1answer
793 views

Updating MS SQL Server from 10.50.1600 to 10.50.1617

How do I update my MS SQL Server from the version 10.50.1600 to 10.50.1617? I have downloaded the KB from here https://www.microsoft.com/en-us/download/details.aspx?id=26304 but i am still not ...
0
votes
1answer
362 views

Compatibility between Windows 7 and Windows 10. [closed]

I receive the free update from Microsoft for Windows 10. At the moment I'm using Windows 7 Ultimate. I have several question, for which I can't find anything in google or at least my search words was ...
0
votes
1answer
76 views

Silent, power saving mini-server for home [closed]

I am looking for hardware to make a small, silent, power saving mini-server for use at home. My specifications are: Small Fanless / Small fan Able to run Windows server OS Has 2GB of RAM, ideally ...
0
votes
1answer
365 views

Comma delimited import issues in SQL Server

I am having a problem with SQL Server. I have a table with 42 columns to which there is frequent monthly imports. These imports are from a flat file using the import and export wizard. My problem is ...
0
votes
1answer
56 views

Best practice on how to update & reboot a live server [closed]

We have a business critical server that has not been re-booted in over 2 years. It is running Windows Server 2003, with SQL Server 2005 (SP3), Visual Studio 2005 and 2008R2, and has numerous versions ...
0
votes
2answers
3k views

What characters are allowed in in column (nvarchar 50) of MSSQL Server 2008?

I have a column in MSSQL which is nvarchar(50) in which I enter passwords for users. I know that for example some special characters like $ % are allowed, but where do I see which list characters are ...
0
votes
3answers
6k 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
2answers
504 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
3answers
11k 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
2answers
2k 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
1answer
86 views

Edit sql code instead of clicking buttons

Does SQL Management Studio 2012 allow editing the SQL DDL (data definition language) code directly? If not, how can I view only the SQL code generated by the application?
0
votes
1answer
95 views

When will Microsoft stop supporting SQL Server 2005? [closed]

We are purchasing proprietary software that requires it run on a SQL Server 2005. My concern is we will not be able to change/modify/enhance at all. SQL Server 2005 is pretty old and want to know if ...
0
votes
2answers
2k views

How to setup Vagrant Windows Server machine with SQL Server on it

Can anyone explain (or give a link) how to setup MS Windows Server VM using Vagrant on Linux (Arch Linux)? I was searching in Google but only think that I found are instructions how to setup Vagrant ...
0
votes
1answer
5k views

Unable to install SQL Server 2012

When I am trying to install a new instance of SQL server 2012 on my server, I get the following error message when I try to run the iso (before any gui appears): The operating system on this ...
0
votes
2answers
4k views

SQL Server 2012 Maintenance Plan can't modify

Click on any created Maintenance Plan: TITLE: Microsoft SQL Server Management Studio Value cannot be null. Parameter name: component (System.Design) BUTTONS:OK Create a new Plan I get this error: ...
0
votes
3answers
2k views

Networking in VMware

I am required to imitate a remote database server environment for my project. So I am thinking of installing SQL Server 2008 on a virtual machine (VMware workstation) and then access it from my ...
0
votes
1answer
3k views

SQL Server Management Studio: network-related or instance-specific error while establishing a connection to SQL server

SQL Server Management Studio: network-related or instance-specific error while establishing a connection to SQL server. Here's a screenshot of the error:
0
votes
2answers
310 views

How to determine sql server name

I'm trying to install sap business one on my computer. But I can't seem to connect to the database server which is ms sql. ![enter image description here][1] I get the notice: unable to connect to ...
0
votes
2answers
675 views

Best SQL Server Configuration with this hardware

I just received my new SQL Server from Dell. The server will be serve approximately 15 OLTP databases which average 10GB in size. Here are the basic specs: Dell PowerEdge R510 with up to 12 Hot ...
0
votes
1answer
1k views

Install Microsoft SQL express database on Windows XP Home SP3?

I am trying to install Microsoft SQL express on a Windows XP SP3 Home Edition machine. But it does not satisfy the requirements. Is there a way to remove SP3 from my machine and revert to SP2? ...
0
votes
5answers
2k views

sqlserver 2008 or 2005 express cannot install on Windows 7 home?

When installing 2008 it says it requires .NET 3.5 and 2005 fails : what can I do ?
0
votes
1answer
2k views

Getting account lock status in MS SQL Server

I want to unlock an account in MS SQL Server. Before unlocking I have to check whether the account is locked or not - I only want to unlock if the account is locked. Are there any SQL queries or ...
0
votes
2answers
132 views

SQL Server on Linux

For a particular project that is coming up, I am trying to expand my knowledge of Linux, so I am going to set up a Linux system at home. Rather than dual booting, I am thinking about putting SQL ...
0
votes
1answer
316 views

How to find sql server instance?

I have sql server 2000 and 2005 installed on my machine. Now instances were installed as Machine04 [2000] and other Machine04\SomeInstance [2005] (this some instance i don't remember now) So is ...
0
votes
3answers
270 views

How can I know about the local SQL Server on my system ( windows 7 )

How do I know whether I have a local SQL Server on my system? If there is what are the login details to the local SQL Server ? I have a windows 7.
0
votes
1answer
60 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 ...