either use the stored procedure above in a sql 2008 query window or migrate the users not both

Asha

if you haven't migrated the logins then the database will have orphaned users as you have found. use the following to report orphaned users in the database

USE yourdb

exec sp_change_users_login 'report'

this...

srikumar.karthiknarayanan (1/20/2010)

---

Hi,

I have a 2 Node MSSQL 2008(64),

Today when i tried to install SP 1 on the Passive node the SP1 Failed and the Error (detail.txt) shows

Warning:...

Jason, to avoid confusing people (as you have here) please post in the correct forum in future. Saleems advice to you below is correct and valid for SQL Server 2008...

EdVassie (6/9/2010)

---

As Ed has said at the very least!

This is not something you learn and become an expert on in a few...

you could also use Microsoft Virtual Server 2005 R2, but to...

multiple sockets or cores or both??

Oracle_91 (6/8/2010)

---

Is that always good to take advantage of multiple...

Hi

the documents are fairly large but here they are

Installing Clustered SQL Server 2008 using VMWare Server2

Installing Clustered SQL Server 2005 using VMWare Server2

They allow you to create a ringfenced SQL...

Oracle_91 (6/7/2010)

---

Hi All,

Am very new to SQL Server Clusttering ?? I have less knowledge in this area nor i got any chance to work on it which involves

resources...

it all depends on

32 bit or 64 bit

memory available

CPUs available

SQL Server edition

and others besides. For example, What is the servers intended workload?

if for some reason this table does not have a clustered index then simply create into your new filegroup, either way if it is a large table this could take...

hi

sorry, not screenshots of the web pages. Screenshots of the sections in report services configuration manager

configuring IIS and service accounts are way beyond the scope of a post in this...

good man, was gonna be my next suggestion 😉

NazerMohamed (6/2/2010)

---

Good that I at least found out that SSRS 2008 does not require IIS. I was thinking it still uses IIS as SQL 2005.

My installation of SSRS is in...

presumably you are currently presenting these over iSCSI?

You would need agreed downtime for your cluster there's no getting away from that.

I would create the new LUNS and attach them...