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
933 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
197 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
120 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
441 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
105 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
95 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
608 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
258 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
50 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
70 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
679 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
166 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
35 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
230 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
1k 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
44 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
290 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
322 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
163 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
447 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?
7
votes
2answers
37k 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 ...
0
votes
1answer
32 views

Backing PDF files and SQL server DB

I have my own Windows Server an Asp.Net application hosted live. The application allows users to upload CV PDF files and I have the DB also on that server. Which steps should I take to ensure that all ...
1
vote
0answers
51 views

Microsoft SQL Server Express 2008 access denied

I'm trying to install Target Process on a Windows 7 machine, but for that I need to install SQL Server Express 2008, but I've been hitting my head on the same problem for a while now. I found ...
0
votes
1answer
214 views

HA Options for Windows Servers

We are looking at different options to allow us to stay up and running when our primary datacenter (DC1) goes down for any reason. What is the main difference in having a offsite server updated all ...
1
vote
1answer
695 views

Error upgrading from SQL Server 2008 to SQL Server 2008 R2

I needed to restore a database (created in SQL Server 2008 R2 - version 10.50.1600) to a new DB in Server 2008 (version - 10.00.2531). I got the error - Restore failed for Server .... Additional info ...
0
votes
2answers
992 views

Server failed, can I retrieve my database from the my hard disk?

I have an old server running Windows Server 2003 R2. Windows got corrupted due to an improper shutdown. I attempted to repair the Windows installation, but it made things worse (it gets to the ...
1
vote
0answers
192 views

SQL Server 2005 on Windows 7 along with SQL Server 2008 R2 Express Edition

I've installed SQL Server 2008 R2 Express Edition in my Win 7 notebook. The Express Edition doesn't have SQL Profiler enabled. Thus it's hard for me to debug my SQL 2005 applications. I have a ...
0
votes
1answer
2k views

Can't enable 'sa' account in SQL Server 2008

I'm trying to enable 'sa' account in SQL Server 2008 through the MS SQL Server Management Studio Express. When I set the properties through the 'Properties' section of the login and click Ok, there ...
0
votes
1answer
723 views

Package run on SQL Server Job Agent - Login failed for user

I created a package on my SQL Server (2012) through the import/export data wizard which exports data to another SQL Server (2008). I set up a job which runs this package but I get an error: ...
-2
votes
2answers
84 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 ...
1
vote
0answers
237 views

SQL 2008 fail-over cluster---specified credentials for the SQL Server service are not valid

We had Two Node SQL 2008 fail-over cluster. Last week one node was crashed, so we decided to re-build the passive Node(crashed Node), we reinstalled the OS and added to windows cluster successfully, ...
0
votes
1answer
64 views

Which Website/User uses the Server resources on Windows Server 2008? [closed]

I have a shared webhosting server based on Windows 2008/IIS 7/Plesk 11.0 .Most of the time Server's CPU usage is over 80% and MS SQL Server process uses most of the CPU/RAM resources. I want to know ...
0
votes
0answers
123 views

SCOM 2012 with MS SQL Server 2008 Standard SP1

I've been trying to install SCOM 2012 on one machine with SQL 2008 Standard SP1... And I can't. During the installation of SCOM in the Operational Database phase, It WILL NOT connect to my SQL server. ...
2
votes
1answer
148 views

Cannot access SQL 2008 or 2012 R2 Express server remotely

I have tried to remotely access two different servers on two different machines, one 2008 the other 2012, and have had zero luck with either machine. I have followed the steps in: How to enable ...
0
votes
1answer
20 views

Error when creating Publications

Here`s a screenshot of error I get when I try to create publication .... Here's a link! What should I do? edit So now I have problem that I cant delete distributor I created, any tips?
0
votes
1answer
184 views

Best practice for setting up SQL server on a Virtual Machine [closed]

This is my first attempt at virtualizing SQL server on VMWare and I want to make sure I am doing things correctly. Should I have SQL server installed on the C: drive / same partition as the OS, Then ...
1
vote
1answer
48 views

How do I change the number of days a copied transaction log is kept in a log shipping configuration?

I think this is a pretty simple and perhaps stupid question. I've established log shipping between two SQL Server 2008 servers using the GUI (i.e. the SQL Server Management Studio). It's been ...
0
votes
1answer
77 views

Does the disk space used by this database seem normal (MSSQL 2008)?

The Disk Usage report is showing lots of unused transaction log space (seems normal, there are hourly log backups). However the data file is mostly indexes and there is very little unused space. Is ...
0
votes
4answers
85 views

SQL 2008 vs. SQL 2008 R2 - which to choose? [closed]

We should change our SQL 2005 Server to SQL 2008. My bet was 2008 R2 SP1 but in this week we had several problems with it (related to CU7 and CU8) and as far I see, R2 has bugs - confirmed by ...
2
votes
1answer
590 views

Microsoft SQL Server Management Studio causing system freeze

I'm experiencing very slow response from MSSMS and it causes other applications to slow down. Specially Skype crashes after few seconds from opening MSSMS, showing an error called "Disk I/O Error". ...
0
votes
1answer
223 views

SQLOLEDB from sql2005 to sql2008?

Can I use the SQLOLEDB provider in an OPENROWSET query from sql2005 to sql2008??? SELECT * FROM OPENROWSET ('SQLOLEDB','[servername]';'login';'pw', 'set fmtonly off EXEC DB.dbo.SP ...
1
vote
0answers
47 views

ssms script wizard not working with modified tables

I'm looking for a way to get all triggers and constraint we modified in a script to migrate them to a different database or reapply to this one if necessary. I'm using SQLServer Management Studio ...
1
vote
2answers
681 views

Adding anonymous IURS IIS user fails into SQL SERVER 2008 R2

I am trying to add a anonymous IIS user [IUSR] to a SQL SERVER 2008 r2 database. But I am getting the following error: 'notebook/iusr' is not a valid login or you do not have permission. I think ...
-2
votes
1answer
423 views

Set password for SQL Server 2008 R2 Account

I have just been given access to a new Windows Web Server 2008 R2 which has SQL Server 2008 R2 installed on it. When I open up SQL Server Management Studio and try to connect, it does so with Windows ...
2
votes
1answer
1k views

Possible to join an Amazon RDS SQL Server 2008 instance to a Windows Domain?

We're planning on using an Amazon RDS MS SQL Server 2008 instance in our Amazon VPC. Since we don't have access to the underlying OS for RDS, I was wondering if it's at all possible to join an RDS ...
0
votes
3answers
632 views

Can I use SQL-Server on Windows Server 2008 R2 core?

Is it possible to run SQL-Server 2008R2 or 2012 on Windows Server 2008 R2 Core installation. There are three questions to answer: Does the license allow this? Can I install and operate it? Is it ...
0
votes
1answer
24 views

clustered windows service

I will have a clustered instance of SQL server over two nodes (active/passive) available in my deployed architecture. I want to deploy a windows service and have it also be active/passive on the two ...
0
votes
4answers
894 views

Two MS SQL Instances, one database file

Is it possible to have one database file attached to two different instances of SQL? Consider that the MDF is located on a NAS and I want a primary and secondary instance of MS SQL on two different ...
0
votes
2answers
394 views

In Amazon RDS, how can a disabled master user be re-enabled?

With a SQL Server instance on Amazon RDS it is possible to do the following to your master user: ALTER LOGIN masteruserid1 DISABLE GO If this command is executed while logged in as the that master ...