Home > IT Answers > SQL Server > How to open sqlserver2005 after installing
Vasi
40 pts.
 How to open sqlserver2005 after installing
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.

Software/Hardware used:
ASKED: August 26, 2009  4:00 PM
UPDATED: September 22, 2011  5:13 PM
RELATED QUESTIONS
Answer Wiki:
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.
Last Wiki Answer Submitted:  August 26, 2009  5:51 pm  by  Denny Cherry   64,520 pts.
All Answer Wiki Contributors:  Denny Cherry   64,520 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

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”..

Vasi
 40 pts.
 

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

Amin4rmOvexTechnology
 250 pts.
 

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

Denny Cherry
 64,520 pts.
 

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

Vasi
 40 pts.
 

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..

Vasi
 40 pts.
 

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

Denny Cherry
 64,520 pts.
 

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

Rajeshkanna
 10 pts.
 

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

carlosdl
 63,535 pts.
 

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 ?

Senweb
 10 pts.
 

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.

Hlx
 690 pts.
 

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

Rayees
 10 pts.
 

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.

Denny Cherry
 64,520 pts.
 

i want to open an sql server 2005 on new querry page  bt i cant i choose the sql server of sql express

mathu
 10 pts.
 

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

TomLiotta
 108,135 pts.