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 |
|
RightClick
Starting Member
3 Posts |
 Posted - 2007-11-01 : 11:01:30
|
| Hi,I installed sql server 2005 on my computer. I can't login. I don't have a user name or password. After log-in i would like to import a acces database to start with.This is what i get on my screen:server type: database engine server name: (i don't know)pcname/username is not working.authentication: windows authenticationlog-in and pasw: It's grey,i can't change it.what did i do wrong ?thanks |
|
|
KenW
Constraint Violating Yak Guru
391 Posts |
Posted - 2007-11-01 : 13:03:55
|
| You probably didn't do anything wrong.By default, the server name is (local), and the instance name is SQLEXPRESS. So, set the servername to be (local)\SQLExpress. If that doesn't work, use YourComputerName\SQLExpress.The login and password are grey because they're disabled. You've told it to use Windows authentication, so it will use the credentials of user who is logged in to Windows. |
 |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-11-01 : 22:14:28
|
| If it's not sql2k5 express, will not use express as instance name by default. Should look at sql server configuration manager or services applet for correct instance name. If it's default instance, just connect with host name. |
|
|
|
dataguru1971
Master Smack Fu Yak Hacker
1464 Posts |
Posted - 2007-11-01 : 22:51:53
|
| rightclick of Mr.excel.com fame? or just a coincidence...? |
|
|
|
|
|
|
Sql 2005 Log-in Problems