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
610 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
3
votes
2answers
2k views

What to enter as “Server Name” in SQL Server Management Studio

When I start SQL Server Managaemnt Studio (SSMS), I'm having a problem in connecting to the database. What will be the 'server name' if my computer's name is Rakesh?
0
votes
2answers
322 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 ...
1
vote
1answer
98 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
924 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
83 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
2k views

Remove column header from sql query output in powershell

I want to remove column header from sql server query output. I did the search but not found any solution. I have a script. $Database = "temp" $Server = "localhost" $AttachmentPath = "output.csv" # ...
0
votes
1answer
60 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
91 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
226 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
239 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
106 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
599 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
110 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
716 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
802 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
628 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 ...
3
votes
0answers
1k 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 ...
3
votes
0answers
695 views

Database 28 cannot be autostarted during server shutdown or startup

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
291 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
596 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
143 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
11 views

SQL Server Witness Server Alternative

I have the setup below: 3 Database Servers 1 DR Database Server 1 Domain Controller 1 DR Domain Controller Currently I have the DR domain controller acting as the mirroring witness for the 3 ...
0
votes
0answers
22 views

Stopping (and starting) remote services when MS SQLServer stops/is available

We have an application (windows service, Java) running on server A and MS SQLServer 2008R2 running on server B. What's the best way to stop the application on server A if the SQLServer on server B ...
0
votes
0answers
30 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
26 views

SQLServer compatibility with DoctrineDbal and Unix/Linux

I'm designing a solution for a web portal. This portal will use the micro-framework Silex which provide database access through Doctrine DBAL libraries. My target DB is a SQLServer 2008 which is ...
0
votes
0answers
28 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
57 views

How to create installer for my visual basic project with sql server 2008 database?

Hi guys I have a visual basic project and I developed it using visual studio 2010 and sql server 2008 for my database. Now, I want to make an installer that will include my sql server database. I ...
0
votes
0answers
587 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
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
279 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
2k views

SQL server 2008 R2 installation error

I have a windows 7,32 bit laptop. I am the administrator with all permissions. when I click on the SQL server 2008R2 set up file,it says : SQL server set up has encountered the following error: ...
0
votes
0answers
891 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
769 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 ...
-5
votes
0answers
16 views

Attempted to perform an unauthorized operation sql server 2008 in Windows7

I am instaling sql2008 and it is showing the following error: Attempted to perform an unauthorized operation sql server 2008 I have tried: Run setup as administrator Create new user as ...