User myusername is not a valid user in the database not_the_database_I_am_connecting_to"
Here's a frustrating one: I have a new webhost with SQL server 2000 running my database. I have always used a DTS package to backup the database to my local SQL 2000 using "copy objects and data" as I am restricted from doing anything else.
However, when connecting to the remote database in Enterprise Manager the server connects but lists no databases, unless I am lucky when it lists them every now and then. When trying to run a saved DTS package It errors but the error is
"User myusername is not a valid user in the database notthedatabaseIamconnectingto"
And I get this sometimes when I try to edit a SP in query analyzer.
Has anyone come across this before?
Derren
[Mediocre talent - spread really thin]
Here's a frustrating one: I have a new webhost with SQL server 2000 running my database. I have always used a DTS package to backup the database to my local SQL 2000 using "copy objects and data" as I am restricted from doing anything else.
However, when connecting to the remote database in Enterprise Manager the server connects but lists no databases, unless I am lucky when it lists them every now and then. When trying to run a saved DTS package It errors but the error is
"User myusername is not a valid user in the database notthedatabaseIamconnectingto"
And I get this sometimes when I try to edit a SP in query analyzer.
Has anyone come across this before?
Derren
[Mediocre talent - spread really thin]