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 |
|
ilvuszq
Starting Member
2 Posts |
 Posted - 2008-05-12 : 10:20:17
|
| I just now installed sqlserver 2005 express.I am connecting to it via oracles 'sqldeveloper' using sourceforgejtds jdbc driver. I can connect to the server but I cannot logon probably because I dont know any user id or password.I can't find any reference to the default uid/password in the server 'help'.Does anyone know how to get started?thanksjim murray |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-05-12 : 10:23:48
|
| If you are administrator of computer and use windows authentication mode, you can use sysadmin account to login to sql server. |
 |
|
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2008-05-12 : 10:24:13
|
| Are you using Windows Authentication or SQL Server authentication? What authentication mode you set while installing SQL Server express?Harsh AthalyeIndia."The IMPOSSIBLE is often UNTRIED" |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-05-12 : 10:25:55
|
| can use sa username and password if you are admin if you install with mixed mode. |
|
|
|
ilvuszq
Starting Member
2 Posts |
Posted - 2008-05-12 : 10:37:47
|
| I installed it with vb express 2003 and it did not ask me any questions on install. I have only one account on my PC. Login fails using windows authentication mode, sysadmin/sysadmin, and sysadmin/null.It also fails using admin/null, admin admin, root/null, and root/root.Is there a setup step I missed?jim |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-05-12 : 10:46:47
|
| Did you install correctly? Try with your windows account |
|
|
|
|
|
|
who is default administrator