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 |
|
Lorna70
Starting Member
19 Posts |
 Posted - 2010-02-25 : 09:23:28
|
| HiI have SQL Server 2008 Express Edition installed on my laptop running Vista Home edition. I cannot seem to connect to an instance in the SSMS 'Connect to Server' dialog - the options in the Server name drop-down only give (local) with no mention of a SQL Server instance! I tried connecting to local but It won't let me in under Windows authentication and doesn't let me change my login either. I cannot get in under SQL authentication either because I don't know the login details! It all works fine under Visual Studio 2008 Express for my web sites so I don't want to reinstall it - are there any ways around this as I need to restore a DB and work on it in SSMS?? |
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2010-02-25 : 09:57:45
|
As the server type in: YOUR-PC-NAME\SQLEXPRESS and don't use the drop down.And then use windows authentication - that should work.
No, you're never too old to Yak'n'Roll if you're too young to die. |
 |
|
|
Lorna70
Starting Member
19 Posts |
Posted - 2010-02-26 : 05:22:58
|
| I now feel very stupid lol! But very thankful :-) |
|
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2010-02-26 : 06:13:19
|
welcome
No, you're never too old to Yak'n'Roll if you're too young to die. |
|
|
|
|
|
|
SQL Server 2008 Express - cannot connect to local