Viewing 15 posts - 841 through 855 (of 872 total)
pauls2 (1/24/2008)
January 24, 2008 at 11:23 am
Glad it worked! Now just get them servers updated 🙂
January 24, 2008 at 10:04 am
Sunny (1/24/2008)
Just try on our test server, it didn't help. I still can't create linked server? Any other idea?
Is the target server's SQL server listening on a different port?
What is...
January 24, 2008 at 9:45 am
zurikela (1/24/2008)
Which SSC site do you mean?
This site ... sqlservercentral.com
January 24, 2008 at 9:42 am
Not entirely sure, but it did resolve similar problems we had that you're speaking of ... regardless, it won't hurt to re-apply it to a SQL2000 server already on SP4....
January 24, 2008 at 9:18 am
Jason Shadonix (1/24/2008)
We don't even have that excuse 🙂 of the 25 some-odd SQL2K boxes we have, only 3 of them are RTM, the rest are all SP3 or SP4.
Wow,...
January 24, 2008 at 9:17 am
Jason Shadonix (1/24/2008)
The objection? I said it was a long story 😛 ... We have a...
January 24, 2008 at 9:12 am
Re-apply instcat.sql on the SQL2000 side from the SP4 install.
It won't let me upload a .sql file ... you should be able to Google it if you don't have it...
January 24, 2008 at 9:10 am
Ah good point ... I was thinking because a new login has to be created, that the user could not be re-applied to the login without manual intervention.
But with sp_change_users_login,...
January 24, 2008 at 9:09 am
What version SQL to what version?
Have you tried open data source?
January 24, 2008 at 9:04 am
There are some known problems using linked servers between 2005 and 2000. The fix is to re-apply the instacat.sql found in SP4. What is the objection to upgrading to SP4?
January 24, 2008 at 9:04 am
Have you tried running sqlwb from the run line?
January 24, 2008 at 7:34 am
Ever since SSC changed their site, I can never seem to find the scripts I'm looking for anymore using searches ... I looked for a few, didn't come across them....
January 24, 2008 at 7:30 am
zurikela (1/24/2008)
If you recreate account in SQL you will loose all relations in connection with the DB.
Correct, but there are numerous scripts provided here on SSC that will script out...
January 24, 2008 at 7:19 am
My apologies, I meant recreating the account in SQL Server.
I do believe you're correct about the SID though. An NT account in SQL server does in fact receive a SID,...
January 24, 2008 at 6:52 am
Viewing 15 posts - 841 through 855 (of 872 total)