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

learn more… | top users | synonyms

0
votes
1answer
279 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 ...
0
votes
1answer
111 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 ...
0
votes
0answers
96 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
3k 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 ...
4
votes
1answer
6k 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
29 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
62 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 ...
0
votes
1answer
122 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 ...
0
votes
1answer
185 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 ...
2
votes
2answers
4k views

SQL Server remote backup query fails “cannot open the backup device”

I am trying to configure my scheduled backups of a MSSQL database to a mapped network drive, which is on a fileserver running Server 2003 Standard. Query reads like this: BACKUP DATABASE XXXX TO ...
1
vote
0answers
2k 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
49 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
3k 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
2k 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
35 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
262 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
1k 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
210 views

Connect SSMS to SQL Engine on VMWARE machine [closed]

This my first question so forgive me if i did anything wrong and tell me about it please. I have a VM on VMWare Workstation 9, it's windows 7 and i installed SQL Server Express on it. And i am trying ...
2
votes
3answers
5k 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
581 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
417 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
165 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 ...
0
votes
1answer
8k views

“There are currently no logon servers available to service the logon request” when trying to remote desktop to a VM after a power failure

I have SQL Server 2008 R2 running on a virtual machine (vmware, Windows Server 2008 R2). I was connected to the SQL Server from another virtual machine via SQL Server Management Studio, then a power ...
0
votes
1answer
831 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 ...
0
votes
3answers
55 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 ...
2
votes
2answers
80 views

Migrating to the Cloud: Private or Public [closed]

This is a matter of opinion but I'm looking for some advice regarding an upcoming migration of physical servers to the cloud. I'm looking for some perspective - any opinions are welcome. Scenario: ...
1
vote
1answer
97 views

sql server 2008 express, how login as admin

I am pretty newbie on sqlserver. I just want to logon by Management Studio on a sqlserver just for backup a db. But it seems that I haven't enough permissions because I am guest. Anyone could explain ...
0
votes
1answer
312 views

Not able to connect to the MS SQL server

Am getting error as show below. It was working fine with no issues but recently started taking long time in query execution and connection: Cannot connect to <serverName>. ...
0
votes
1answer
51 views

Need to DROP TABLE from 100s of SQL backup files

I have MS SQL Server 2008 available to me. Is it possible to script (perhaps with Powershell?) the processing of all my backup files to drop a table (or two) from each one? I used 7-Zip on the command ...
-2
votes
2answers
84 views

Is it Safe to Install SQL Server 2012 on a machine which have SQL Server 2008 R2 running?

I am using SQL Server 2008 R2 quite a while. It is working great. Now I need to use SQL Server 2012. Will this effect my existing database. How much Risk involved in installing SQL Server 2012 on a ...
1
vote
1answer
1k views

Exception Enumerating SQL Server Instances with SMO WMI ManagedComputer

I'm trying to use the SMO WMI API/objects in PowerShell 2.0 on Windows 7 with SQL Server 2008 R2 installed to get a list of SQL Server instances on the local computer using the Managed Comuter object. ...
1
vote
1answer
2k views

How to change the product key of SQL server 2008 R2

I am currently using SQL server 2008 R2 Standard edition in a Cluster. During the initial installation I used the product key which was automatically bonded with the setup DVD. Now I have a need to ...
1
vote
2answers
78 views

How to see what is cached in memory in SQL server 2008?

Is there a way how to find out what is cached in SQL Server 2008 R2? I have found the following nice article here: ...
0
votes
0answers
52 views

I must have done something wrong installing sample database

I downloaded file SQLEXPRADV_x86_ENU.exe (version 10.00.1600.22), and used it to install SQL Server 2008 Express with Advanced Services, which I think has capabilities comparable to SQL Server 2008 ...
0
votes
3answers
2k views

Increasing vCPUs for Server 2003?

I have a VM running Server 2003 and SQL Server 2008 on VMware ESXi. Can I safely assume this configuration can cope with a change to the number of vCPUs? Are there better solutions to address the ...
5
votes
2answers
17k views

SQL Server 2012 with account NT Service\MSSQLSERVER access is denied in domain

A few months ago we installed SQL Server 2012 in Windows 2008 R2 under the virtual account "NT Service\MSSQLSERVER", all good. A few days ago, one of the admins of the IT dept installed Full Text ...
0
votes
0answers
94 views

Identical tables, different sizes?

I have transactional replication with updatable subscriptions going between a few SQL 2008 R2 servers (publisher is Enterprise, subscribers are Express). I need to add another subscriber, and come to ...
3
votes
4answers
18k views

How do I install SQL Svr Native Client 10.1 after SQL 2012 has been installed

On a Windows Server 2012 I have SQL Server 2012 installed which has the SQL Server Native Client version 11. I am being told by a developer that he needs the SQL Server Native Client version 10.1 ...
0
votes
1answer
40 views

How to allow a SQL Login to see only ONE database

i have a SQL Server server 2008 r2. I wish to create a two new Login for a client who wishes to have access to their one database. But I don't want to give them access to the other my databases. ...
1
vote
0answers
48 views

Failover cluster wouldn't fail over

I have an active-passive failover cluster on 2008r2 with SQL server 2008 clustered on it. I go to fail it over for maintenance and the resource failed to come online on either node. Once I rebooted ...
0
votes
3answers
90 views

How to connect to ms sql express?

I have sql express on my local network computer, I created new account, I enabled server auth, and when I am trying to connect to this account from local machine, everything works fine. But when I try ...
0
votes
0answers
83 views

SQL failover cluster on single ESXi host

I'm setting up a virtual environment consisting of 10 VM's with 2 primary SQL databases required. The infrastructure allocates two pairs of SQL 2008 R2 Enterprise edition (VM's). The pairs are ...
0
votes
2answers
1k views

In sql-server, how do I give server-level permission to user to make backups on any database

I need to give a user server-level permissions, once and for all time, to back-up any existing or future database on the server instance, without making the user sysadmin. How can I do that? I've ...
0
votes
1answer
109 views

Restore backup from SQL 2008 to 2008R2 with standby

We are looking to replicate our production database to another instance so that when reports are run, it doesn't slow down the application to the point of being barely usable. I had limited success ...
1
vote
2answers
22 views

Exploring / editing SQL Server data of a runtime installation

I installed some software which has built into its installer a sort of minimal installation of SQL Server 2008 R2 Express. The software itself uses the database just fine, but I want somehow to be ...
-1
votes
1answer
280 views

SQL server ODBC connection for Active Directory user who doesn't log in to the windows

Do you think it is possible to create a SQL server ODBC Connection for an active directory user who doesn't log in into the windows. Ideally this type of users will be used in the batch process. So, ...
0
votes
0answers
576 views

SQL Server 2008r2 SP2 Manual Install Error

I am receiving an error I have never seen before, nor can I find any info on the net. When I try to install SP2 for SQL Server 2008r2 I receive the following error. Cannot find the value of the ...
0
votes
0answers
220 views

Download SQL 2008 R2 and install remotely with key

I have the media and product key for a copy of SQL Server 2008R2, however, I can not get my CD to the server at my data center. Is there a downloadable version (or can the trial be downloaded) of the ...
3
votes
1answer
2k views

How To Tell If a MSSQL 2008 Database Has Transparent Data Encryption (TDE) Enabled

Does anyone happen to know if there is a way via WMI to tell whether a MSSQL 2008 database has TDE enabled? We have a large SQL estate that I'd like to survey and find out where we have TDE enabled. ...
1
vote
1answer
461 views

My php site cannot connect to SQL Database - SqlExpress2012

Im quite new to SQL Express 2012, but have just installed it on my server 2008 r2. Im trying to install a CMS called joomla, which I' ve done many times before both on SQL community server and hosted ...