Microsoft SQL Server, commonly referred to as simply "SQL Server," is the relational database engine developed by Microsoft. MS SQL Server 2008 was released on August 6th, 2008, and is major version 10 of the application.

learn more… | top users | synonyms

0
votes
3answers
983 views

Error while installing SQL Server 2008 on Windows 7 Home Edition 64 bit

I am trying to install SQL Server 2008 on my Windows 7 Home Edition, Setup is giving an error attempting to perform unauthorized operation
0
votes
2answers
332 views

How to connect SQL Server across the Work Network?

SQL 2008: I am trying to access SQL Database which is running on Server / Test Computer which has Windows XP OS. My Computer and Test Computer both are connected in our Local Network. Still I am ...
6
votes
1answer
2k views

SQL Server ODBC authentication errors

I'm trying to connect to a SQL Server 2008 database from a 3rd-party application through an ODBC connection. I am having success when the ODBC is set up with Windows Authentication but not when it's ...
1
vote
1answer
100 views

Visual j# asks for SQL 2005, but I already have SQL Server 2008 installed

I recently installed Visual Studio 2010 full pack (including SQL Server 2008). After that, I installed Visual j# Express 2005 in order to work on a project. The problem is: When I try to open a new ...
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, ...
0
votes
1answer
51 views

Creating a database in Visual Basic 2010 Express

I'm studying computing and I need to make a program for my project. My project is a fast food ordering system which needs a database. While trying to add a SQL Service Database I get an error message ...
0
votes
1answer
68 views

How to share a SQL Server 2008 Standard edition database to another on a computer (wireless network)

Does anyone know how to set the properties of database to be shared through wifi network? I'm running windows 8.1 OS and the other computer I need to share with, is Windows 7. I tried to use 'adhoc' ...
0
votes
1answer
68 views

Time and date filter in SSRS 2008

I am looking for an expression that can filter a time and date column to 4 hrs prior from what the actual value is. Example: 5/27/2015 5:00:30 pm So I am looking how to get: 5/27/2015 ...
0
votes
1answer
212 views

Can't install SQL server 2008 or SQL Server 2014

When I try to run the SQL SERVER 2008 setup, it shows the following error and exits: SQL Server Setup has encountered the following error: Unable to cast object of type ...
0
votes
1answer
32 views

SQL server connects after browser restart

I am using SQL server 2008 trying to connect the server using management studio using ssms with server name including ports and named instance with SQl authentication . Windows firewall is disabled . ...
0
votes
1answer
66 views

SQL Server 2008 Backup to networked drive

When I go to backup a SQL database - I only see options to do the backup on a local disk. Is it possible to backup to a network drive directly?
0
votes
1answer
259 views

Mysql Connector crash on SQL Server 2008

I would like to create a linked Server betwenn my MYSQL Server and a SQL Server 2008. I already installed the MYSQL Connector ODBC drivers 5.1 (previously the 5.3 Version but same problem) on my SQL ...
0
votes
1answer
242 views

sql server 2008 Management Studio does not see my copied database

I copied my database (mdf and ldf files) from my server to the cloud. Previously I have done it from one local server to another. I put it in the same directory (MSQLSERVER/../../data, confirmed that ...
0
votes
1answer
68 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, ...
0
votes
1answer
150 views

Move multiple SQL Server 2008 databases from C: to D: at once

I have SQL Server 2008 R2 with 323 databases consuming some 14 GB on my C: drive, a fast SSD. Because I want to reclaim some space on my C: drive, I would like to move them to my D: drive. I have ...
0
votes
1answer
306 views

Error when install SQL server 2008 the application was unable to start correctly (0xc0007b)

"the application was unable to start correctly (0xc0007b).click ok or close button to installing application)" Error come when i try to install SQL server 2008 in my system. How can i fix this ...
0
votes
1answer
509 views

SQL server replication, subscription to remote server : issue while choosing the publisher

I am trying to create a subscription to a remote server having SQL 2008 R2 the client PC is connected through VPN to the server and can discover it successfully. I can even connect to the database ...
0
votes
1answer
132 views

Windows XP, SQL Express, 3rd party application crash — how to check the possible lack of resources?

Summary: I need to log usage of resources on Windows XP machine to find if the lack of resources may be the reason for the application crash. I need your advice how to do that. Context: There is an ...
0
votes
1answer
837 views

Questions about setting up PHP-ODBC driver for remote SQL-Server-2008 connection on CentOS-6

I have CentOS 6 and PHP 5.3.3 VPS at GoDaddy. I have to interact with remote SQL Server 2008. I've seen many tutorials and quite lost here, so: There is a way to simply yum install it ? If not, what ...
0
votes
1answer
1k views

Trouble enabling remote connections to SQL Server Express 2008 R2

I'm trying to enable remote connections but i'm having some trouble. Here's my setup SQL Express is installed on Win2k8 R2. Windows firewall turned off SQL Browser service started and running SQL ...
0
votes
1answer
119 views

SQL Server Reporting?

I have a SQL Server instance setup, and on one of the databases I have a lot of views defined. I have to connect to our VPN before I can connect to the database. I'm wondering if there is a simple ...
0
votes
1answer
946 views

Troubleshooting inconsistent ODBC connectivity

I'm attempting to integrate UPS WorldShip with a SQL Server 2008 R2 database but the connection is very inconsistent. UPS claims this is a DSN/Windows problem and I have not been able to convince them ...
0
votes
1answer
1k views

Installing SQL Server 2008 R2 Management Studio

My dev box is a Windows 7 machine and I am trying to install SQL Server 2008 R2 Management Studio. When I run the installation SQLManagementStudio_x64_ENU.exe (downloaded from Microsoft site), it ...
0
votes
1answer
680 views

SQL Server service could not be run after installing Microsoft security essentials

I had a SQL server 2008 (Express edition) installation in my Windows 7 (64 bit) and it was working fine. Couple of days back,i installed Microsoft Security Essentials and now when i try to open my ...
5
votes
0answers
947 views

Unable to Connect to SQL Server 2008

I installed SQL Server 2008 on a PC with xxx.xxx.x.200. When I connected to the server from another machine(say xxx.xxx.x.81) using SQL Server Management Studio, I get the following error. TITLE: ...
1
vote
0answers
33 views

Sql server 2008 R2 is losing Intellisense after installing Visual Studio 2010 SP1

after installing service pack 1 on visual studio 2010 , i have lost Intellisense in sql server 2008 r2 , what should i do in order to fix this issue ?
1
vote
0answers
392 views

Export MS SQL database as *.dbschema

We have a production database and visual studio 2010 database project. We had to make some changes in database schema. Unfortunately we don't have previous database schema file for production ...
1
vote
0answers
714 views

Creating a New Database Across a Network with SQL Server 2008 R2

I appreciate that the above should not be done ('Creating a New Database Across a Network with SQL Server 2008 R2') for all of the reasons outlined here but a client wants to know how to do this and ...
1
vote
0answers
145 views

What is the command line that Visual Studio uses to install SQL Express?

I'm writing an application that will download and install all the prerequisites for a larger application. One of those prerequisites is SQL Express 2008. I need my application to be able to install ...
0
votes
0answers
35 views

Could not connect to remote MSSQL server

I am having a Microsoft Azure cloud server with Windows 2008 R2 Datacenter operating system and I have a web application running in it. I use this server as a testing server and hence no reserved IP ...
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, ...
0
votes
0answers
506 views

Unable to connect to sql server 2012 with SSL encryption enabled using sqljdbc4

I am trying to connect my web application to SQL server 2012 with SSL encryption enabled using sqljdbc4 but i get the below error : com.microsoft.sqlserver.jdbc.SQLServerException: The driver ...
0
votes
0answers
148 views

Cannot install SQL Server 2008 R2 express. Compiler returned error 0x8007005

First off, I'm having a very similar issue to this StackOverflow post here: http://stackoverflow.com/questions/31681386/sql-server-configuration-manager-wont-start-wmi-returns-error# Installing SQL ...
0
votes
0answers
281 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
18 views

Data transfer in sql server 2008

I have following requirement In SQL server 2008,Trying to implement in stored procedure source table T with 100000 records need to be insert into destination table T1.A Job will be schedule for ...
0
votes
0answers
20 views

SQL Server 2008 doesn't want to connect

I'm brain new into SQL Server and just installed Microsoft SQL Server 2008. Now I'm trying to starting it up but doesn't want to connect. Server type: Database Engine Server name: .\SQLEXPRESS ...
0
votes
0answers
24 views

Make changes in excel external datasource and send them to Sql Server?

I'm using data from Sql server as external data source in Excel. But if I change data in excel, then the data won't change in sql server. Can I make changes in excel and send them to sql server? I'm ...
0
votes
0answers
109 views

SQL server express 2008 failed to install

I am attempting to install SQL Server 2008 Express Edition as part of Visual Studio 2010 in Windows 8.1 and it gives the following fail message: SQL server 2008 express service pack ...
0
votes
0answers
37 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 ...
0
votes
0answers
46 views

Our application is responding different on client server

I have an application running on our local server and it works perfect. However when I deploy my application to our client's server there are problems. If i copy all the sources to another local from ...
0
votes
0answers
368 views

Cannot login to sql server 2008 express after the installation

After i have installed VS 2010 in windows 7 64 bit. I tried to install sql server 2008 express 64bit version. but the installation failed. saying some files is missing from the downloaded package. I ...
0
votes
0answers
983 views

Can't start SQL Server 2008

I just installed SQL Server 2008 R2 and I can't get it started. I opened the configuration manager, but the SQL Server, Agent and Browser options can't be started (the start option is greyed out, as ...
0
votes
0answers
960 views

SQL Server 2008 forgets my login and password

For some reason SQL Server 2008 (Management Studio) refuses to remember my username and password for a specific server instance even though I've checked "remember password" probably hundreds of times ...