A version of Microsoft's database server, released in August 2008. This is different than SQL Server 2008R2.

learn more… | top users | synonyms

1
vote
3answers
837 views

Could SQL Server 2008 replication be used with NLB to allow unlimited scaling of reporting servers?

We are currently using transactional replication in SQL Server 2008 to keep a secondary reporting server synchronized with a primary database server. This has been working weel and keeps some of the ...
0
votes
0answers
721 views

SQL Server Error - HRESULT E_FAIL has been returned from a call to a COM component

I have a huge 200MB .SQL file. When I try to open this in SQL server management studio 2008, I get the error -Error HRESULT E_FAIL has been returned from a call to a COM component. What could the ...
1
vote
1answer
78 views

SQL Server does not enforce encryption rules

I am forcing encryption on my MS SQL server. My intention is to reject any client connection that does not use SSL to connect. Here are my detailed steps : makecert -r -pe -n ...
1
vote
1answer
231 views

Cannot Connect to MsSql2008 R2 Database Engine, While Connecting to Other Services

I have installed MsSQL 2008 R2 on my computer as I have installed always before. But unfortunately this time, I cannot connect to Database Engine while I can easily connect to the other services like ...
-2
votes
2answers
82 views

SQL Server: Network pauses after installing cheap SATA card: Is there a solution?

At the risk of being assigned to the "bad DBA" club... I did something desperate, and may have to undo it. Problem: After installing a low cost eSATA board, my SQL Server is intermittently ...
0
votes
1answer
347 views

Login failed for user 'sa'. … [CLIENT: 59.48.47.215]

I have an Amazon EC2 instance and i don't have anything running on it yet but my event log is full of below error "Login failed for user 'sa'. Reason: An attempt to login using SQL authentication ...
1
vote
0answers
3k views

SQL Server services not showing up in SQL Configuration Manager

I have SQL Server 2008 R2 (RTM) running on a Windows Server 2008 R2 (SP1) box. This instance exists primarily to run SSRS in SharePoint integrated mode. When I open SQL Server Configuration Manager, ...
4
votes
2answers
1k views

MS SQL access to restored database without sysadmin role

I have databases from different projects on one server. I can't give all developers administrative (sysadmin) access to the databases. They have to have the permissions needed to create and restore ...
1
vote
4answers
224 views

Sql Server Backup Compatibility - 2008 with 2005

I'm hoping to restore a backup from SQL Server 2008 into a Sql Server 2005 instance. Is there a way to have Sql 2008 back up in a format that 2005 will understand?
0
votes
4answers
2k views

Database planning - Multiple Schemas vs Multiple Databases vs Single large database vs Partitions

We design websites for Realty companies. The websites are used only to display the information and all the websites share a common template. We have around 150 websites for different customers. Some ...
0
votes
1answer
249 views

The timeout period elapsed prior to obtaining a connection from the pool

I have a WPF application which I want to use on multiple machines. I can connect to it on the same machine but I can't connect from another machine. I know I have to enaple TCP/IP connection and I ...
0
votes
1answer
50 views

Restore From Database not showing database I want to pick

In Management Studio I want to restore to a point in time from an existing database. However, the databases that I can choose from in the drop down list don't include the one I want to choose. And ...
2
votes
4answers
13k views

The database myDb is not accessible. (ObjectExplorer)

I'm developing an ASP.NET MVC3 web app, which connects to a SQL Server 2008 R2 database. Everything was working fine, until I started getting this error: The database myDb is not accessible. ...
0
votes
1answer
204 views

SQL 2008 R2 User Connections and Total Server Memory counters spike at the same time on multiple servers

We use SolarWinds SAM software to monitor servers and applications. We started using it to monitor our SQL servers through the performance counters. We started getting alerts two to three times ...
2
votes
4answers
11k views

Error when restoring database (Windows 7 test environment)

I have a windows 7 operating system as a test environment. I have SQL Server EE installed with two instances, named as test and production. I took a full backup from AdventureWorks database from test ...
1
vote
1answer
676 views

Error when connecting to Named Instance as a Linked Server

I have a MS SQL2008 server running a root instance and a named instances. SQL001\. SQL001\Pilgrim When I connected to SQL001\Pilgrim I can set-up a link to the default instance SQL001\. no ...
1
vote
1answer
200 views

single application multiple users through thin client

I am having one application built in C# winforms. In the backend I am using SQLSERVER 2008 Express. The application is used remotely through thin clients. My problem is that when one user is using my ...
0
votes
1answer
82 views

sa account not working anymore on SQLServer2008

I have been running SQLServer 2008 for some years now on my laptop. At a certain point I cannot login anymore with my sa account (mixed authentication turned on). I get the error message 233. This ...
2
votes
1answer
376 views

SQL Server Reporting Services subscription creation silently fails. No error message is displayed, but the subscription does not get created

I'm trying to set up a subscription for a SSRS report. I have deployed the report to the server and I can view the report in a web browser with no problems. I have tried to reproduce this issue on ...
0
votes
0answers
47 views

Dummy transaction to check if a system is up

We want to send a dummy transaction through our system (Application - DB) to ensure it is still up every minute. If the transaction fails we are alerted - Thereby knowing within a minute if there is ...
-1
votes
2answers
1k views

Can there be two machines with the same server name (SQL SERVER) in the same network? [closed]

I have a program in excel that connects to several sql servers using servername and instance. My question is, what would happen if there are two servers (machines) with the same servername in the same ...
3
votes
1answer
2k views

dbcc checkdb('XYZ', REPAIR_ALLOW_DATA_LOSS) indicating that XYZ is already open and can only have one user at a time

I have a DB, XYZ, that had a corrupt log file and now since the log file is totally unusable this is rendering this specific DB unusable and I need to be able to rebuild it. I've already done a lot ...
0
votes
2answers
28 views

SQL 2008 Failure after compressing HDD

I've absent-mindedly let Windows Server 2003 compress a HDD to try and save some space. That same drive contains an instance of SQL Server 2008. Since compressing, all the Databases have taken ...
-2
votes
1answer
57 views

Is is safe to upgrade SQL server 2008

I have a windows vps with sql2008 express r2 (with tools) installed, one of my clients require full-text search feature. Sql 2008 with advance services has that feature. So my question is, is it ...
6
votes
5answers
7k views

How can I have SQL Server Management Studio 2008 connect to my instances automatically?

I'm running a server with 3 database instances. Right now, when I open Management Studio, it opens the "Connect" prompt that lets me choose which instance I want (or connect to anything else). Would ...
-2
votes
2answers
70 views

Uninstall SQL Server

how do I uninstall SQL Server 2008 manually? Add/remove programs does not uninstall everything. Thanks in advance.
3
votes
4answers
7k views

How to recover the database which is accidently deleted using sql server 2008

How to recover the database which is accidently deleted using sql server 2008?
0
votes
1answer
128 views

SQL Port 1433 needed in SQL Server2008 IP Field for remote connection

I just installed SQL Server 2008 on my server. I do it often enough to forget what to do so I read through a couple of MS installation instructions. I installed with no issues. I tried to remote ...
3
votes
7answers
12k views

How do I solve MSSQL 2008 install error, “The MOF compiler could not connect with the WMI server”?

Possibly related to: SQL Server 2008 Install fails error reading etwcls.mof After manually removing MSSQL 2008 from my system (uninstall failed to remove two instances), I receive the following ...
1
vote
0answers
1k views

SQL Server 2008 R2 Express connection error

Hi I'm having issues with SQL connection for a client PC We have software that uses SQL database, and I have just updated from SQL2005 to SQL2008 We have 5 pcs: 2 x vista (32 bit) 2 x win7 (64bit) ...
-1
votes
1answer
47 views

SQL Server 2008 R2 memory consumption for no usage [closed]

I have a application that uses SQL Server 2008 R2. I have a problem of memory consumption on the client side. Whenever the client runs the application, the SQL server starts consuming memory even if ...
0
votes
1answer
2k views

MSSQL: "Could not allocate space for object 'dbo.SORT temporary run storage in database because 'PRIMARY' filegroup is full

I have been around the block with this issue several times today checking blog posts everywhere and nothing has helped me to fix and resolve this issue. I'm trying to add a non-clustered index to a ...
5
votes
5answers
1k views

Using SAN Replication/Snapshots for SQL Server disaster recovery?

We have a web application that utilizes SQL Server 2008 on a single database server. All storage is local. For the past year we have been trying to get any form of SQL Server Replication to work ...
0
votes
1answer
34 views

SQL Server datafile growths

For SQL Server 2008 what is the maximum number of growths? And which view do I query to find that information for a datafile in my database?
1
vote
1answer
441 views

MS SQL 2008 - Can I use Windows Authentication to connect from a Mac

I have been using Navicat SQL on Mac (Snow Leopard) to connect to MS 2005 via "Basic Auth" and all is good. However the DB is now being migrated to MS 2008 and try as I might I cant get on via Windows ...
0
votes
3answers
290 views

Can Accpac be used with Windows authentication for SQL Server?

I'm the DBA and the Accpac guy is telling me we need a SQL login for the Accpac databases. Right now I use only Windows authentication, and I don't like the idea of turning on mixed authentication if ...
1
vote
1answer
62 views

Bigger ProjectServer farm is performing worse

I am using Project Server 2007 sp3 with SharePoint 2007 sp3 and SQL Server 2008 r2. I have recently moved my farm from 2 servers (1 DB and 1 App/Web) to a very big farm having Many Servers, Clustered ...
1
vote
1answer
140 views

SQL Databases get stuck in Unavailable State daily

Every day I notice several of my project DBs on SQL 2008 R2 (v. 10.50.2500) get into a limbo state where they are unavailable. They're not technically offline in this case. In Management Studio, ...
1
vote
1answer
886 views

SQL 2008 Reporting Service SSL certificate chain not trusted

I got a SQL Server 2008 Standard Edition installed on a Server 2008 R2, OS and SQL Server got newest Service Packs and updates installed. The SQL Server is up and running but I cant connect to the ...
2
votes
2answers
4k views

SQL2008R2 install issues on windows 7 - unable to install setup support files?

I am trying to install the above but am getting the following errors when its attempting to install the setup support files, This is the first error that occurs during installation of the setup ...
4
votes
2answers
21k views

Install SQL CLR types & Report Viewer 2012 on Sql 2008 server

I'm in the process of installing a client's ASP.net site on a Windows Server 2003 box running Sql 2008. The site uses Report Viewer 2012, but when I attempted to install it on the server, I got the ...
1
vote
2answers
815 views

SQL and Shadow Protect Server

Rolling out a Server2008R2 box with SQL2008R2 on it to trial some new payroll software. I have ShadowProtect virtual licences for my VM's and this box will get one. My question is: What is the best ...
1
vote
3answers
372 views

How to clear stale Server Name entries in the Sql Server Management Studio Connection Dialog?

All but one of the following entries are stale/don't exist and I just want them out. I've Ctrl-F'd the registry but to no avail. Any ideas?
1
vote
2answers
3k views

How do I find the root cause of Memory pressure failure on an SQL server 2008?

One of the servers I have been performance monitoring started throwing the following warnings from the Resource-Exhaustion-Detector: Windows successfully diagnosed a low virtual memory condition. ...
0
votes
1answer
276 views

SQL Server 2008 side-by-side with SQL Server 2012, possible issues with SAP Business One 8.81 PL:07?

We have a Windows Server 2008 R2 Enterprise system running SQL Server 2008 Enterprise (x64) version 10.0.4067.0 and SAP Business One 8.81 PL:07. We would like to install a named instance of SQL Server ...
3
votes
1answer
225 views

Are SQL Collations per Instance or per Database?

I have a single SQL Instance, let's say MSSQLSRV - is the collation per Instance, i.e. every database in the given instance has the same collation, or are collations set per database? i.e. multiple ...
0
votes
1answer
131 views

Real trouble for opening port in SQL Server 2008

I'm having trouble trouble opening port in SQL Server 2008 R2 Express Edition (http://www.microsoft.com/en-us/download/details.aspx?id=30438) even by disabling the Firewall. I also installed the ...
3
votes
1answer
4k views

Problems with SQL Server 2008 - “The client was unable to reuse a session with SPID 62, which had …” [closed]

I'm having problems with my SQL Server 2008 installation (10.0.2531.0 - SP1 installed). It works as a database server for small hosting environment (about 500 sites). I'm getting errors like this: ...
0
votes
3answers
49 views

SQL Instances and Servers

I have two installations of SQL on two seperate boxes (I have "Inherited" these). A SQL 2005 Installation, with instance called SQL2005 - I connect to this via SQL Studio Manager and when I connect ...
0
votes
1answer
590 views

Backing up database fully from remote server, and restoring to another remote server

I currently have three copies of my website (Live, Staging, and Development), with the database for each on three separate servers. More often not, a bug will appear that requires an up-to-date ...