How to open sqlserver2005 after installing

40 pts.
Tags:
SQL Server 2005
SQL Server Password Management
I have installed Sqlserver 2005 into mys system and how can i set a username and password to that.I am the only user to that computer.

Answer Wiki

Thanks. We'll let you know when a new response is added.

When you install SQL Server one of the components you could have installed was the Client Tools. These are what you’ll use to connect to the SQL Server instance. If you installed the Express edition you’ll need to go back to Microsoft’s site and download the Express client tools as they aren’t included with the Express download.

Once you have done this you can connect to the SQL Server instance and create databases and accounts as needed.

Discuss This Question: 14  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • Vasi
    I installed Sql server completely.. If i select Sqlserver2005, it showing configuration tools.. In configuration tools i selected sql sevice Manager. There it showing sql server(sql express)and sql sever browser... If i click on Sql server(sql Express) one window is opening ..i.e sql sever properties...There which one i have to select "built in account" or "this account"..
    40 pointsBadges:
    report
  • Amin4rmOvexTechnology
    yeah that is right,, when you have install the SQL Server then Simply install the SQL Management Studio and manage your database by using this tool. If you choose the Window Authentication then they pick window Administrator password.that s it or if u have choose the SQL Server Authentication then use the user name and password which u have given during the installation. Regards,, Amin Anwar
    250 pointsBadges:
    report
  • Denny Cherry
    What edition did you install? Express, Web, Workgroup, Standard, Enterprise?
    66,365 pointsBadges:
    report
  • Vasi
    I installed Sql server 2005 along with visual studio 2008. it is a standard edition.
    40 pointsBadges:
    report
  • Vasi
    Thanks to all... can you give the link where can i download the sql client tools in microsoft .. I don't have software CD. I downloaded this from university.. I searched in microsoft.com..but i didn't get that software..
    40 pointsBadges:
    report
  • Denny Cherry
    Here's the link to download the SQL Express Management Studio.
    66,365 pointsBadges:
    report
  • Rajeshkanna
    hi.. i instaled sql 2005 into my sys along with visuval studio 2008. if i select sql server 2005 it showing Configaration tools.. in conifigaration tool i have 3 options SQL sever configaration manager,SQL server usage and repoting and SQL sever surface area configaration.. tell me which one i have to selcet... i checked all these 3 option but i can't find the dilog box like user name passward.. etc please give the answer
    10 pointsBadges:
    report
  • carlosdl
    Rajeshkanna, as previously mentioned by Mrdenny, you need to download and install Sql Server Management Studio Express.
    70,220 pointsBadges:
    report
  • Senweb
    There are two files to download from http://www.microsoft.com/downloads/en/details.aspx?displaylang=en&FamilyID=c243a5ae-4bd1-4e3d-94b8-5a0f62bf7796 1). SQLServer2005_SSMSEE.msi 2). SQLServer2005_SSMSEE_x64.msi Which one we have to download ?
    10 pointsBadges:
    report
  • Hlx
    From your link, if you have 32bit version of windows, download #1, 64bit windows, download #2: Instructions -------------------------------------------------------------------------------- Note: You must have administrative rights on the computer to install SSMSE. Step 1: For 32-bit platforms, download and install the 32-bit version of Microsoft .NET Framework 2.0. For 64-bit platforms (x64 and EMT64 only), download and install the 64-bit version of Microsoft .NET Framework 2.0. Note: If you have already installed SQL Server 2005 or Visual Studio 2005, you already have Microsoft .NET Framework 2.0. Step 2: Download and install Microsoft Core XML Services (MSXML) 6.0. Note: If you have already installed SQL Server 2005, you already have MSXML 6.0. Step 3: Download SSMSE by clicking the SQLServer2005_SSMSEE.msi link later on this page. To start the installation immediately, click Run. To install SSMSE at a later time, click Save. Step 4: Follow the installation instructions provided in the Readme.
    690 pointsBadges:
    report
  • Rayees
    Hi, I want to download sql server 2005 free. please give some link to download all the neccessary things used to instal sql 2005. -Rayees
    10 pointsBadges:
    report
  • Denny Cherry
    Rayees, SQL Server is not a free product in general. There is a free version which is a little limited called SQL Server Express. You'll have a hard time finding a copy of that for download on Microsoft's website for SQL 2005 as it is so old. You will probably need to download the newest version which is SQL Server 2008 R2. Anything other than the SQL Express edition does require that you pay for it. Getting it without paying for it is illegal in most countries.
    66,365 pointsBadges:
    report
  • mathu
    i want to open an sql server 2005 on new querry page  bt i cant i choose the sql server of sql express
    10 pointsBadges:
    report
  • TomLiotta
    bt i cant i choose the sql server of sql express   Your problem doesn't seem to fit in this thread. Please open a new question.   When you open a question, include the platforms that the server and client are installed on and the software versions. Also describe what you do to reach the problem, what you see when the problem appears and why it is a problem in those circumstances (i.e., tell us what you think should happen)   Then we can probably know how to respond.   Tom
    125,585 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following