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
60 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
1answer
154 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
436 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
36 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
498 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
339 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
32 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
56 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
424 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 ...
1
vote
2answers
1k 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
108 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
110 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 ...
-1
votes
1answer
90 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
424 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
176 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
48 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
71 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: ...
0
votes
0answers
23 views

Access is denied on SQL server start

When I want to start SQL server service from services with AUTHORITY\NetworkService user but this error occurred: I tried many ways that suggested in this question but no success.
1
vote
1answer
74 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
80 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
0answers
22 views

SQL Server 2008 Cluster Not Failing Over Correctly

I currently have 2 x Windows Server 2008 R2 Enterprise servers in a windows cluster. Installed on both of them are SQL Server 2008 Standard R2 in a cluster configuration. It has a virtual IP of ...
0
votes
1answer
44 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 ...
0
votes
0answers
41 views

Reformatting Windows Cluster Disk

We have a Windows 2008 r2 cluster for SQL Server. It is working, but we just found out the the NetApp LUN's were formatted with 4K allocation units instead of the recommended 64K allocation unit size. ...
-2
votes
2answers
71 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 ...
0
votes
1answer
339 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
659 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
60 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
15 views

Resuming database mirror after moving mirror server to different domain

I have a mirror setup between 2 sql server 20008r2 servers. The mirror is operating in high performance mode (async) without a witness. I moved both server from one active directory domain to ...
0
votes
0answers
44 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
304 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 ...
2
votes
1answer
4k 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
43 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 ...
0
votes
0answers
52 views

Proxy DMZ server to bounce data between sql server and clients

Is this feasible? I have a sql server that is setup behind a corporate firewall. I have clients that need direct connection to that sql server via ODBC. Instead of punching holes in the firewall I ...
1
vote
3answers
4k 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
37 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
38 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
0answers
73 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
494 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
0answers
75 views

Using SSMS, how do I add a row to when a column is read only?

How do I add a row to when a column is read only? I think this issue I am having is because I am using an ID field (column) that is automatically generated and incremented whenever a new row is added ...
0
votes
1answer
49 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
21 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
106 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
155 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
121 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 ...
1
vote
1answer
115 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 ...
0
votes
1answer
144 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
1answer
195 views

Cannot Connect to SQL Server 2008 R2 from Sharepoint Server

I have installed SQL Server 2008 R2 on dbserver and Sharepoint 2010 on webserver. When trying to configure Sharepoint to use the database installed on dbserver, it says it cannot connect. Then I ...
0
votes
1answer
38 views

Problems restoring local instance in SQL Server 2008 R2 Express

I have set up a local instance in SQL Server 2008 R2. I have a database (called GD_LOCAL_TC) that I need to restore so I can begin working in it (right now it's empty). When I right click on ...
0
votes
1answer
102 views

Best Practices Analyzer for Microsoft Dynamics AX 2009

We recently uncovered a potential issue with our Dynamics AX setup whereby Receive Side Scaling (RSS) was not enabled on our AOS servers, which we believe is limiting their performance (currently ...
0
votes
1answer
123 views

SQL 2008 R2 Clustering AND DB Mirroring (Async)

I've got a MS SQL 2008 R2 Fail-Over Clustered Instance running between two Windows 2008 R2 servers using the inbuilt Windows Clustering features, that is working with a DTC and Quorum with a disk ...