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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2006-04-26 : 09:20:28
|
| asif writes "sir i have microsoft server 2000 and i have to use taht in my pc only i have instaled taht in my pc but when i run sql query analyser then its asking for database and many more please solve my problem. i am using windows xp service pack2 so please help me " |
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2006-04-26 : 09:43:31
|
| is it asking for the sql server name?asking if you wish to use windows or sql authentication?just provide as is: name = usually the machine nameuse windows authentication, so you don't need to supply loginame and passwordHTH--------------------keeping it simple... |
 |
|
|
druer
Constraint Violating Yak Guru
314 Posts |
Posted - 2006-04-26 : 11:09:24
|
| Often you need to use the value '(local)' for the server name.The user/pwd and whether or not you can say "windows authentication" is going to depend on what you selected when you installed the software. I think the default on installation is "both" so you should be able to use Windows Authentication mode if you are using the same logon that you were in when you installed the database. It should have prompted you to input a password for the user 'sa', or let you check a box that would use "no password" for that user. If you recall checking the box you'll need to use the user 'sa' and leave the password blank. If you recall inputting a password for the 'sa' user, then you'll have to use that password. Hope it helps,Dalton |
|
|
|
|
|
|
microsoft sql server 2000