July 20, 2008 at 11:40 am
Sorry to trouble you all. I am a complete newby at SQL but need to start learning it. I have installed the trial of SQL server 2005, however after install the SQL Server Agent is not listed in services of the console.
Can anyone help?
David Knight
July 20, 2008 at 12:14 pm
You probably installed the Express version and not a trial edition. The express version does not come with the agent.
To verify, run: SELECT @@version; from a query window or SQLCMD.
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
July 20, 2008 at 12:22 pm
MICROSOFT SQL SERVER 2005 EVALUATION EDITION
July 20, 2008 at 12:26 pm
Okay, then it should be installed. How are you determining that it is not installed?
What services do you have that start with SQL*?
Try opening SQL Server Configuration Manager and see what services are listed there.
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
July 20, 2008 at 12:42 pm
weird
I downloaded it from Microsoft thinking it was 2005 server sql. however the services shown are windows internal database, sql server browser and sql server(sqlexpress)
July 20, 2008 at 1:44 pm
i have just checked and the download was the enterprise version
July 20, 2008 at 1:45 pm
if i had had the express version installed and I go to install the enterprise version would it not tell you as suh. Mine just installed over it.
July 20, 2008 at 1:58 pm
It probably did not install of the express edition - but, you probably missed the check box to install the database engine.
Try re-running the setup and make sure you select the database engine. You should then get a prompt to install a new instance or upgrade the existing instance.
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
Viewing 8 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply