There is a server that has a potentially bad (beta?) dll and I cannot run sql server management on it w/o a MSCORLIB error when remoting in. I installed SQL 2005 Express on a diff workstation and had it connect to the main one. Now the user wants to see "Server Agent" so they can schedule jobs but suprise suprise, the express edition doesn't have it! I need to somehow connect to that main sql server w/o paying for a lisence for another full install of SQL on the RDP workstation I setup for them. Does anyone have any suggestions? Thanks.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Can't find SQL Server Agent on Express ed. when connecting to Standard
- Thread starter kamazon
- Start date
mrdenny
Programmer
- May 27, 2002
- 11,595
Take the SQL 2005 CD/DVD and stick it in there workstation. Run through the installer selecting to install only the Client Tools on thier workstation.
As far as the server, try reinstalling the most recent service pack on the server to reinstall the dll.
Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)
--Anything is possible. All it takes is a little research. (Me)
![[noevil]](/data/assets/smilies/noevil.gif "[noevil] [noevil]")
As far as the server, try reinstalling the most recent service pack on the server to reinstall the dll.
Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)
--Anything is possible. All it takes is a little research. (Me)
- Thread starter
- #3
mrdenny
Programmer
- May 27, 2002
- 11,595
No problem.
Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)
--Anything is possible. All it takes is a little research. (Me)
Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)
--Anything is possible. All it takes is a little research. (Me)
kamazon,
If you really think MrDenny's the best...show it by rewarding him a star. Oh, you ask me, how do I reward a star! Easy, look at the bottom of MrDenny's post that gave you the solution you liked. See the "Thank mrdenny for this valuable post!"? Click that link and follow the directions.
-SQLBill
The following is part of my signature block and is only intended to be informational.
Posting advice: FAQ481-4875
If you really think MrDenny's the best...show it by rewarding him a star. Oh, you ask me, how do I reward a star! Easy, look at the bottom of MrDenny's post that gave you the solution you liked. See the "Thank mrdenny for this valuable post!"? Click that link and follow the directions.
-SQLBill
The following is part of my signature block and is only intended to be informational.
Posting advice: FAQ481-4875
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question