How to open sqlserver2005 after installing
Home > IT Answers > SQL Server > How to open sqlserver2005 after installing
Vasi
40 pts.
0
Q:
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.
ASKED: Aug 26 2009  4:00 PM GMT
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
RELATED QUESTIONS
0
Mrdenny
46810 pts.
0
A:
 RATE THIS ANSWER
+1
Click to Vote:
  •   1
  •  0
  • AddThis Social Bookmark Button
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 Answered: Aug 26 2009  5:51 PM GMT by Mrdenny   46810 pts.
  •   
0
0
RSS - Discussions Help
Discuss This Answer:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _



_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

Vasi   40 pts.  |   Aug 26 2009  11:33PM 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”..

 

Amin4rmOvexTechnology   250 pts.  |   Aug 27 2009  3:28AM 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

 

mrdenny   46810 pts.  |   Aug 27 2009  8:16PM GMT

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

 

Vasi   40 pts.  |   Aug 27 2009  11:58PM GMT

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

 

Vasi   40 pts.  |   Aug 28 2009  12:01AM 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 <a href="http://microsoft.com" title="http://microsoft. " target="_blank">microsoft.com</a>..but i didn’t get that software..

 

mrdenny   46810 pts.  |   Aug 28 2009  10:36PM GMT

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

 
0