troubleshooting Question

SQL 2005 Express problem; Error messages "Invalid object name" and "Cannot find user"

Avatar of D K
D KFlag for Germany asked on
Microsoft SQL Server
6 Comments1 Solution1289 ViewsLast Modified:
Hi folks,

I have a problem with my SQL 2005 Express server that I have installed yesterday on XP SP2. Everything was working fine up to an hour ago, but now not even a select * from is successful. I have no idea what I did to make this happen.

I want to use xp_cmdshell in a trigger. In SQL 2005 you have to activate this before you can use. So I clicked the check box in SQL Server Surface Area Configuration tool. Then I got an access denied for xp_cmdshell. Searching the net I found the following code and tried to run it:

USE master;
GRANT EXECUTE ON sys.xp_cmdshell TO MyUser;

I received: Cannot find the user 'MyUser', because it does not exist or you do not have permission ( I am logged in as 'sa').

Then I ran: GRANT CONTROL SERVER TO MyLogin; which seemed to be successful.

But now I can't even do a simple SELECT * FROM tablename or SELECT * FROM dbo.tablename. I always receive:

Invalid object name '<tablename>'.

I have no clue, what to do to make the server work again.

Any help would be greatly appreciated. Thanks in advance!
ASKER CERTIFIED SOLUTION
lluthien

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 6 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 6 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros