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
649 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
3k 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
325 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
941 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
26 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
30 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
104 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
66 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
101 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
240 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
261 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
111 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
653 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
112 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
732 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
846 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
637 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
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
726 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
304 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
603 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
17 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
41 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
51 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
45 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
78 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
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
293 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
900 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
796 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 ...