newbie question - how to connect to local server?
-
hi all, i am brand new to using SQL server. I just installed SQL server 2008 enterprise edition on my home PC and i am trying to do some exercises to learn the program. when I start the mangement studio, the login box appears and I have no idea how to connect.
do i need to set up a local server on my home pc first?
please help.
-
bkmj1mtym (1/10/2010)
hi all, i am brand new to using SQL server. I just installed SQL server 2008 enterprise edition on my home PC and i am trying to do some exercises to learn the program. when I start the mangement studio, the login box appears and I have no idea how to connect.do i need to set up a local server on my home pc first?
please help.
Did you choose integrated security when you isntalled SQL Server?
If not, you can login the first time after installation with the SA account. You should have set the password for that during installation.
Also, did you install the database engine, or just the management tools?
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events -
In response to your PM.
Server Name is the name of your workstation or server where SQL server is installed. If you installed it with a named instance then you would put
ServerName\InstanceName.
Since you don't recall if you selected Integrated security, change the login type to SQL (where it currently says Windows Authentication). Type SA in the Logon Name box, and type in the password that you entered during setup.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply