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
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 ...
2
votes
2answers
78 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
90 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
153 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
48 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
80 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
881 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
73 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
48 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
1k 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 ...
3
votes
2answers
10k 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
63 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
9k 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
45 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
77 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
717 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
76 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
194 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
390 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
185 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
1k 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
287 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 ...
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
1answer
542 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
41 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
159 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
174 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 ...
5
votes
1answer
118 views

32-bit SQL eating up RAM on 64-bit OS until SQL is brought to its knees

This may be related to other threads I've seen, but I need a solution to this specific situation. The SQL instance continuously consumes more and more RAM until after about a week it's grabbed over ...
0
votes
1answer
271 views

Can I move all DB files on SQL server 2008 to a different logical drive and then change the drive letter?

I've got a SQL Server 2008 (std) with 19 DBs. Because I'm replacing my SAN, I need to move all the DB files to a different volume. I've moved individual DBs before using MS's recommended method: ...
0
votes
1answer
88 views

How to best move system DBs from SQL 2005 to SQL 2008 R2?

I'm in the process of moving from SQL 2005 to SQL 2008 R2. Moving the production DBs and logs is straightforward, through either detach/attach or backup/restore. (new hardware, so I have the old ...
1
vote
0answers
78 views

sql server x64 access x86 COM object

I want to transfer a database from SQL Server 2000 x86 to SQL Server 2008 R2 x64 but it uses a x86 COM object that I have no inside knowledge of. I know there are some articles out there about the ...
1
vote
0answers
416 views

SSMS stuck scripting database objects

SQL Server Management Studio sits stuck, after scripting all objects in a database. Except it didn't script all objects in a database. i scripted all the objects in an SQL Server 2008 database from ...
0
votes
1answer
34 views

MS SQL - syncronising “a view” to another MS SQL server

Let me open by saying that I am no MSSQL expert. I'm a linux admin, so please forgive me if I should know this. I've been asked to syncronise a view or a table from one MSSQL database to another. ...
0
votes
1answer
225 views

SQL Server reliance on Domain Controller

Just have had an interesting situation with a remote database server which I did not think happened. The setup is server A is a domain controller in the main network, and server B is on a remote ...
0
votes
1answer
46 views

How to un-install sql server 2008 analysis service only?

Initally I installed SQL server 2008 R2 Evaluation version. Then we bought licence key for SQL server 2008 R2 Web and wanted to update my licence, but unfortunately I installed analysis service when I ...
-1
votes
1answer
62 views

MS SQL Express - Memory limitation vs. web application [duplicate]

I have web application that will be similar to forums. I plan to have few thousands+ users on this application, and i wonder if i can use MS SQL Express - here is the list of it's limitations: ...
1
vote
1answer
527 views

Trouble Publishing an MVC4 site on HostGator

I have been working on a C# MVC4 website and trying to publish it to a Host Gator shared Windows hosting account. They are running both MSSQL 2008 and mySql. We have run into some trouble when trying ...
0
votes
1answer
157 views

opening firewall 1433 port to IP address that require a direct connection

We are upgrading from sql server 2005 to sql server 2008 and windows server 2008 R2. New server is behind a firewall, we have 30 or so windows XP machines, that will require the port 1433 to be ...
0
votes
0answers
33 views

Instant File Initialization Turned on but file grows slower in sql server 2008r2

What are the reasons a data file (8 GB) could take a long time to grow even if Instant file initialization is turned on in sql server 2008r2? The sql service account has admin access to "Perform ...
0
votes
1answer
190 views

DateTime of data file autogrowth in sql server

How to determine the datetime of the last auto file growth of a data file in sql server 2008, if I dont have a trace file at the time of autogrowth. One of the online posts mentioned that the ...
0
votes
1answer
971 views

SQL Server 2008: Large transaction log file in Simple Recovery Mode

I am having a problem with disk space in SQL Server 2008. This is the situation: - I had a DB set with Simple Recovery and this DB used to use 2-3 GB for the transaction log file - I moved this DB to ...
0
votes
1answer
40 views

Installing MS SQL Server 2008 R2 Utilizing Data Array

Maybe I can't put together a query that finds what I am looking for on the Internet, but I want to make sure this is done right. I have a new server that has Windows Server 2008 R2 loaded onto a RAID ...
0
votes
1answer
244 views

SQL Server 2008 intermitent error 40 running parallel queries

Here's our setup : We are using Red Gate SQL Multi-Script to run queries on our ~1000 databases which reside on a single SQL Server 2008. SQL Multi Script can be configured to run queries in ...
0
votes
1answer
239 views

Dynamics AX 2009 Falls Over when SQL Cluster Rolls

We had an issue on one of our production database nodes which caused it to fail over to another. This caused a brief outage whilst the service rolled. This temporary glitch however was enough to ...
0
votes
0answers
142 views

Network adapter on Windows can't access local network

I have a HP server which has Windows Server 2008 as OS. I also have an Ubuntu server VM running with Hyper-V. My ubuntu server runs a web application which connects to MS SQL Server running on the ...
2
votes
1answer
306 views

Missing MSSQL10.SQLEXPRESS folder

I seem to be missing my C:\Program Files\Microsoft Sql SERVER\MSSQL10.SQLEXPRESS folder. I have reinstalled SQL Server 2008 and Visual Studio 2010 but still do not have it. Any ideas?
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 ...