December 1, 2008 at 6:55 am
Hi,
I can't see any jobs under my Windows login. When I click on any job, the "New Job" prompt just shows up. It happens regardless of what db server I am on. I have sysadmin access to all servers I am trying to get into. When I try another login, I can see the scheduled jobs. Any ideas?
Thanks,
Ray
December 1, 2008 at 7:11 am
Are you sure your windows login is a member of the sysadmin group?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 1, 2008 at 8:05 am
Yes, it is.
Thanks.
December 1, 2008 at 8:20 am
ps-
Something is probably wrong with my copy of SQL Server Management Studio on my laptop. I logged to another machine using my same id and I am able to get in. Is there some setting I can look at in my SQL Server?
December 1, 2008 at 11:44 am
not sure...did u check if you have the sp 2 installed for 2005 and sp4 for 2000?...
December 1, 2008 at 11:51 am
Where do I check this? I checked the SQL Server Help..About and I don't see anything that says this.
December 1, 2008 at 12:08 pm
you can find the TSQL command at MS website for 2005 it will show at the bottom when u open a query window...
December 1, 2008 at 12:11 pm
Oh, I see it now. Its 9.0 SP2.
Thanks!
December 1, 2008 at 12:36 pm
hmm...it rlly shdnt matter whether u r acessing the server from ur laptop or other machine bcoz i assume that your laptop will have only the client tools installed...i could be wrong..maybe Gila could help you out...i would check once again at the permissions for the login..
December 1, 2008 at 1:03 pm
If you click help - about in management studio, it'll show you the version of the client tools. What version do you have for management studio?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 1, 2008 at 1:06 pm
Heres all the information from Help..about
Microsoft SQL Server Management Studio9.00.1399.00
Microsoft Analysis Services Client Tools2005.090.1399.00
Microsoft Data Access Components (MDAC)2000.085.1132.00 (xpsp.080413-0852)
Microsoft MSXML2.6 3.0 4.0 5.0 6.0
Microsoft Internet Explorer6.0.2900.5512
Microsoft .NET Framework2.0.50727.1433
Operating System5.1.2600
December 1, 2008 at 1:07 pm
Microsoft SQL Server Management Studio9.00.1399.00
Microsoft Analysis Services Client Tools2005.090.1399.00
Microsoft Data Access Components (MDAC)2000.085.1132.00 (xpsp.080413-0852)
Microsoft MSXML2.6 3.0 4.0 5.0 6.0
Microsoft Internet Explorer6.0.2900.5512
Microsoft .NET Framework2.0.50727.1433
Operating System5.1.2600
December 1, 2008 at 1:45 pm
u said that u are able to see the jobs when u try to login using other credential...so i dnt think it has to do anything with your SQL instance...you should ask u networking team regarding your windows login...and ..u are using SQL login to test other logins right?..
December 1, 2008 at 1:48 pm
You would have no access to the jobs that are running if you have logged on to the server using SSMSE which is a free download and doesnt allow you to view/schedule jobs through the agent.
Is this workstation yours?? is it the organization;s machine that you are working on?
Refer the features section :
December 1, 2008 at 1:49 pm
I can login using my id going to another machine. So it seems something with copy of SQL Server.
Viewing 15 posts - 1 through 15 (of 19 total)
You must be logged in to reply to this topic. Login to reply