what version ESX server are you using out of interest?

how many disks are in the array that the file sits on?

also what is the set up of sql server, where are the data and log files stored?

in linked table manager when the login box appears use trusted connection

can you not just take a backup

use

CREATE LOGIN prova WITH PASSWORD = 'prova123prova'

my guess is the password is not being recognised

you could use a trusted connection or a file DSN

we have a few SQL VM's in our enterprise, personally unless there was a drastic need i would prefer to do a fresh build of the SQL server and migrate...

hey, happy to help 😉

Jack Corbett (7/22/2008)

---

Sure, but it applies to ALL user tables in the database. Using the datareader role is...

FreeHansje (7/22/2008)

---

Tnx Cath,

Did not link the Client Config Tool with this problem as a solution.

Now to find how to restore my Admin privilege on my pc, which also seems to...

are the file paths exactly the same on the new server?

what steps did you take to move the databases and what commands did you use?

what errors are you getting?

datareader only applies to user tables so should be safe

as wildcat mentioned above, to move a table create a clustered index on that table into the new filegroup with drop existing on the tablename. Logically when you create the...

the datareader role should grant select on tables.

of course you could modify the public role but i wouldnt recommend that