Viewing 7 posts - 1 through 7 (of 7 total)
run instcat.sql in SQL 2000 server...
http://support.microsoft.com/kb/906954
the issue is pretty much documented in MS, while creating a linked server from a 32 bit SQL server to a 64 bit...
February 22, 2008 at 3:48 am
Yes i agree that MS should have fixed this issue..however with my experience in installing many of sqlserver2005 instances...i faced this issue only when i applied SP2 on SQL server...
February 22, 2008 at 3:44 am
the root casue of this issue lies in instmsdb.sql....
the mentioned sql has a sample password.....(dont remeber it exactly...search for yukon it is something similar to this).
and this password is...
February 20, 2008 at 5:10 am
check the windows login account you have configured in remote login, make sure the login account is not locked..
password is not expired...
make sure the windows authentication is working first from...
February 20, 2008 at 2:40 am
you said.............
""I did the same thing on sqlserver2005 there was an error the user is not assocciated with trusted SQL Server connection. I'm using the same username and password for...
February 20, 2008 at 2:14 am
what edition (Developer,Standard or enterprise) of sql server are you using. And is SQL2005 a 64 bit or 32 bit edition.
try the below steps and let me know, login to...
February 20, 2008 at 1:16 am
You wouldnt be able to backup the mdf and ldf files using the mentioned third party software unless you stop the sql server service..
IF you still need to take a...
February 17, 2008 at 11:59 pm
Viewing 7 posts - 1 through 7 (of 7 total)