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 |
|
pupli
Starting Member
8 Posts |
 Posted - 2008-07-15 : 10:44:39
|
| hello everybody,I just installed both SQL Server 2005 and Visual Studio 2005 from a CD that a friend of mine gave to me.In fact, the version is SQL Server 2005 Enterprise Edition, and I just installed it on my Home PC.the problem is that, when I want to enter the Management Studio, it prompts me for a password (something like connecting to some server)Someone told me that I could have done some mistake through the installation steps.Had anyone had this kind of experience before ?I really need some help!thnx a lot!If I only could..... |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2008-07-15 : 10:53:07
|
What password did you use for the SA account when installing?
E 12°55'05.25"N 56°04'39.16" |
 |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-07-15 : 22:04:04
|
| Didn't it work with Windows authentication? |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-07-15 : 23:30:18
|
| What's os on your home pc? SQL Server 2005 Enterprise Edition runs on windows server. |
|
|
|
pupli
Starting Member
8 Posts |
Posted - 2008-08-18 : 10:03:05
|
| My OS is Windows XP Pro sp2.When I want to enter the Management Studio it asks for a server connection. And if I select the Win. Authentication it waits for an user & pass to be entered.Can it be a mistake during the installation,...meaning that...there comes a moment during the installation where I (the user) have to chose between the "domain account" or "local account". Naturally I ticked "local account", but I've also left ticked the optional box telling about "prompt me for username and password when I logon"...Can this be considered as an optional mistake ???------------------------------------------------If I only could..... |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-08-18 : 23:39:02
|
| Sql will not ask for id/pwd if you choose windows authentication. Did you see sql service on the machine by the way? |
|
|
|
sunsanvin
Master Smack Fu Yak Hacker
1274 Posts |
Posted - 2008-08-19 : 08:17:50
|
| enter the sql server management studion with windows authentication mode. after that create the password for sa and use sql authentication.as per my knowlwdge, you have installed correctlyArnavEven you learn 1%, Learn it with 100% confidence. |
|
|
|
sunsanvin
Master Smack Fu Yak Hacker
1274 Posts |
Posted - 2008-08-19 : 08:17:52
|
| enter the sql server management studion with windows authentication mode. after that create the password for sa and use sql authentication.as per my knowlwdge, you have installed correctlyArnavEven you learn 1%, Learn it with 100% confidence. |
|
|
|
|
|
|
|
|
SQL Server 2005 installation