Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
smtraber
Starting Member
3 Posts |
 Posted - 2008-03-16 : 21:31:00
|
| I just installed Sql Server 2005, and opened the Sql Server management studio, and the connect to server dialog box popped up, i selected database engine, but what do I put in the server name box? I tried my computer name, and got an error, i tried localhost and got an error, i tried my computer name/localhost and got an error. I installed it as the default instance with windows authentication, and I verified that the sql server service is running, but I always get a login error. Can anyone help me get started? |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-03-16 : 22:27:02
|
| Did you reboot your computer after applying service packs and hot fixes? Check SQL server configuration manager. |
 |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-03-16 : 22:31:07
|
| You only need host name for default instance. What was the error by the way? |
|
|
|
smtraber
Starting Member
3 Posts |
Posted - 2008-03-16 : 22:57:08
|
| I have rebooted, and all the services are running. The error message said, "Cannot connect to Sean-LAPTOP, login failed for user 'Sean-LAPTOP\myUsername'. (Microsoft SQL Server, Error: 18456) I can't figure out why i can't connect, if I select Integeration Services instead of Database Engine, it connects fine, any ideas why this might be? |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-03-16 : 23:21:43
|
| Did you add Sean-LAPTOP\myUsername as sql login yet? |
|
|
|
smtraber
Starting Member
3 Posts |
Posted - 2008-03-16 : 23:58:22
|
| No, I didn't know I had to if I was using window authentication. How do I do that? |
|
|
|
|
|
|
|
|
Connecting to default instance for the first time