How to open sqlserver2005 after installing

Vasi

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.

Asked: August 26, 2009 4:00 PM Last updated: September 22, 2011 5:13 PM

Answer Wiki

Last updated: August 26, 2009 5:51 PM GMT

Denny Cherry68,390 pts.
History
Contributors
- Ordered by most recent
- Denny Cherry68,390 pts.

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

Vasi Aug 26, 2009 11:33 PM GMT

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 Aug 27, 2009 3:28 AM GMT

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 Aug 27, 2009 8:16 PM GMT

What edition did you install? Express, Web, Workgroup, Standard, Enterprise?

68,390 pointsBadges:

report
Vasi Aug 27, 2009 11:58 PM GMT

I installed Sql server 2005 along with visual studio 2008. it is a standard edition.

40 pointsBadges:

report
Vasi Aug 28, 2009 0:01 AM GMT

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 Aug 28, 2009 10:36 PM GMT

Here's the link to download the SQL Express Management Studio.

68,390 pointsBadges:

report
Rajeshkanna Apr 19, 2010 5:48 PM GMT

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 Apr 19, 2010 6:43 PM GMT

Rajeshkanna, as previously mentioned by Mrdenny, you need to download and install Sql Server Management Studio Express.

84,495 pointsBadges:

report
Senweb Mar 4, 2011 6:13 AM GMT

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 Mar 4, 2011 5:22 PM GMT

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 Sep 22, 2011 5:46 AM GMT

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 Sep 22, 2011 5:13 PM GMT

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.

68,390 pointsBadges:

report
mathu Dec 21, 2012 6:31 AM GMT

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 Dec 21, 2012 6:47 AM GMT

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