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
0answers
198 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
58 views

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

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
115 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
125 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
157 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
40 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
71 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
77 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
474 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
183 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
42 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
451 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
185 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 ...
1
vote
1answer
577 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
0answers
1k views

Fatal error 9001 on shared SQL Server 2008

I've asked this same question on StackOverflow, but I might actually have a better chance for an answer here so am posting here as well. I know this question has been asked here before, but none of ...
0
votes
0answers
83 views

401 accessing SQL Reports in SharePoint 2010 through UAG 2010

Simply put, when I try to access SQL Reports through SharePoint 2010 remotely I get a "The request failed with HTTP status 401: Unauthorized." error. When I access it locally the reports load up just ...
0
votes
3answers
372 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
531 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
290 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 ...
0
votes
1answer
1k views

How to Deploy an ASP.NET Web API- and Browser-based Application to a Production Environment [duplicate]

Possible Duplicate: How to Deploy an ASP.NET Web API- and Browser-based Application to a Production Environment We have an ASP.NET Web API server that serves up a SQL Server data driven ...
1
vote
1answer
306 views

Is there a negative impact to using SQL Server with a lower compatibility level

We have SQL Server 2008 R2 which we are using for a database with a compatibility level set as 2005 (90). We will by upgrading it to 2008 at some point, but in the meantime I would like to know if ...
1
vote
1answer
122 views

Will more memory help my CPU-peaking SQL Server 2008 R2

I'm supporting a system running against a SQL Server 2008 R2. The server is a single-CPU box with 8 GB of memory. As traffic has increased, the server has started saturating, peaking to 100% CPU ever ...
1
vote
0answers
291 views

MS SQL 2008 R2 64bit will not use more than 1.5GB in task manager

I have the latest MS SQL 2008 R2 installed on Windows Server 2008 R2 64-bit. The SQL server process never surpasses 1.5GB in the task manager resulting in heavy disk usage. I have solve this problem ...
-3
votes
1answer
648 views

Compatibility issues with sql server 2008 data center edition on windows 8 [closed]

I am trying to install Sql Server 2008 R2 Data Center Edition on Windows 8 but I am getting this message: "This program has compatibility issues" Is it save to install it anyway? Maybe someone has ...
0
votes
1answer
143 views

What to do instead of shrinking your databases and how to fix issues caused by previously shrunk databases?

I'm a fairly new SQL Server DBA but come from a software engineering background. I've been reading on several blogs that shrinking a database on a regular basis is bad and I understand why. The issue ...
0
votes
1answer
113 views

Sql Server 2008 Create Foreign Key Manually

I have inherited an old database which wasn't designed very well. It is a Sql Server 2008 database which is missing quite a lot of Foreign Key relationships. Below shows two of the tables, and I am ...
1
vote
1answer
22 views

Switch active Sql Server 2008 databases

I am dealing with large imports of data into SQL Server and need to know the easiest way to perform the import and rebuilding of indexes while minimizing the effect on web services that primarily read ...
2
votes
1answer
2k views

Unable to start SQL Server Instance 2008 R2 - DB file corrupt

I was not able to start the SQL Server 2008 R2 production DB instance. After reading the log file error message is " The log scan number passed to log scan in database ‘master’ is not valid. This ...
1
vote
1answer
48 views

Altering a table via SQL Server Management Studio - get SQL

Is there a way to get the ALTER statement run by the management studio when altering a table in the design view?
0
votes
3answers
2k views

2008 SQL Server, attach option does not show all the drive letters

I have a cluster DB, and i am trying to attach DB files, it doesn't let me navigate to any other drive except for DB? Is there something wrong that i am doing? Example, if my DB is created in F:\, i ...
1
vote
1answer
46 views

SQL Server 2008 login issue using Active Directory users [closed]

Sir i installed sql server 2008 in one domain i can login sql server in both login mode.Is it possible to login sql server from diffrent domain?
1
vote
1answer
305 views

What's the importance of restoring SQL Server system databases (model, master, etc.)?

I had to restore some production databases to a different drive on the same Microsoft SQL Server 2005 machine. That worked fine and the application using the databases is back online. However, i have ...
3
votes
2answers
267 views

Windows Failover and Load Balancing confusion

In the next couple months we are looking to add Failover and Load Balancing to our environment. We will have 2 servers that are Hyper V Hosts. We are looking to have an IIS App server and SQL ...
0
votes
1answer
443 views

SQL Server 2008 R2: starting SQL browser failed

During troubleshooting of the failed connection to sqldb in my testsystem I've tried to start sqlbrowser via command line. This results the following error message "failed starting SSRP redirection ...
1
vote
1answer
2k views

SQL 2008 Backups to UNC Share Failing 0xC002F210

This problem is driving me NUTS!! We take backups of all of our production databases to a network share, which are then backed up to tape nightly. 8pm Mon-Fri - Full backup, followed by log backup ...
0
votes
1answer
849 views

physical memory usage is high on production sql server [duplicate]

Possible Duplicate: SQL 2008 Memory Usage I'm going threw high physical memory usage in SQL Server. It always around 90%.When i reboot the server, it will initially good but end of the day ...
2
votes
1answer
1k views

unable to locate trace definition file for microsoft sql server version 10.50.0

I try to create a new trace in sql server profiler. got following error: unable to locate trace definition file for microsoft sql server version 10.50.0 the database I connected to is sql server ...
1
vote
1answer
190 views

String search and replace across an entire database

After an exploit on an ASP.NET site, the client was left with a specific string of malware code sprayed across the entire database, multiple columns of multiple tables. The prepended string is ...
0
votes
1answer
1k views

“could not find the database engine startup handle sql 2008 r2” error

I have hit a brick wall here... I am trying to install ssrs in one of my other VM. After installing sql server express and ssms(which installs successfully), I have tried to install ssrs(making ...
1
vote
3answers
3k views

Linked server issue. Can't use windows authentication as remote login account

I tried to set up linked server. The target server is MS SQL 2008R2. It works fine if I set Remote login by sa account. However, if I use a windows account, it will popup an error. And I get the ...
1
vote
1answer
616 views

Cannot deploy reports on localhost/reports

I am using Microsoft SQL Server 2008 R2, Sql Server Reporting Services(SSRS) on an xp virtual machine.. I have created a report and am trying to deploy it... but getting this error... The specified ...
0
votes
1answer
73 views

Unable to install SQL Server 2008 Express SP1

I am facing difficulties installing the MS SQL Server Express 2008 Service Pack 1. I already have MS SQL Server Express 2008 installed and all I want to do is to install the SP1 however I get ...
0
votes
1answer
522 views

Alias a linked Server in SQL server management studio?

Hoping someone can help - is there a way in SQL server management studio 2008 R2 that I can alias a linked SQL server? I have a server, added by IP address, to which I do not have the login ...
2
votes
1answer
109 views

SQL server 2008 enterprise installation error on Windows 7

When I try to install SQL Server 2008 enterprise on my Windows 7 machine, I get this error message. When I click on Retry, I get the same error again. Error reading from file ...
0
votes
1answer
26 views

installing a second instance of SQL Server 2008

I am trying to install second instance of SQL Server 2008 enterprise edition in my window 7 machine using network server, local service, and my admin account. However I keep getting the below error. ...
1
vote
2answers
2k views

Setting Timeouts: SQL Server 2008/IIS 7.5

We have recently migrated from a Win 2003/SQL Server 2000 system to Win 2008 64 bit R2, SQL Server 2008 R2. Our websites are in classic asp, and this can't be changed to another scripting language at ...
0
votes
1answer
54 views

What are the things to look out for when adding other domain user to your IIS?

I have a Windows Server 2008 R2 called Jack11 that joined a domain called Watson.org. It has IIS 7 installed. From my understanding, we need to add the following into the web.config file ...
2
votes
1answer
909 views

PerfMon counters have different Page File % Usage values for _Total and C:\pagefile.sys for SQL Server on VM

I am collecting PerfMon counters on a SQL Server 2008 server (which is hosted on a VM), and I am getting different Page File % Usage values for _Total and C:\pagefile.sys. The C:\pagefile.sys values ...