Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

SQL 2005 Issue

Posted on 2007-07-24
1
Medium Priority
?
202 Views
Last Modified: 2010-03-19
I dont want to sound like an idiot, but I am used to using SQL 2000

I have installed SQL 2005 on a server and am playing around with it. I do not see an enterprise manager anymore and am wondering how I access the accounts and databases within 2005. I am trying to create a new DB and it says that the sa account is locked out.

Thanks
0
Comment
Question by:dsheltzel
1 Comment
 
LVL 143

Accepted Solution

by:
Guy Hengel [angelIII / a3] earned 2000 total points
ID: 19559531
>I do not see an enterprise manager anymore
it is called now SQL Management Studio, if you installed the client tools...
there you can do those stuff.
0

Featured Post

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

There are some very powerful Dynamic Management Views (DMV's) introduced with SQL 2005. The two in particular that we are going to discuss are sys.dm_db_index_usage_stats and sys.dm_db_index_operational_stats.   Recently, I was involved in a di…
Introduction This article will provide a solution for an error that might occur installing a new SQL 2005 64-bit cluster. This article will assume that you are fully prepared to complete the installation and describes the error as it occurred durin…
Exchange organizations may use the Journaling Agent of the Transport Service to archive messages going through Exchange. However, if the Transport Service is integrated with some email content management application (such as an anti-spam), the admin…
Please read the paragraph below before following the instructions in the video — there are important caveats in the paragraph that I did not mention in the video. If your PaperPort 12 or PaperPort 14 is failing to start, or crashing, or hanging, …

810 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question