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 |
|
elic05
Yak Posting Veteran
62 Posts |
 Posted - 2009-01-07 : 15:50:32
|
| I had a database on my local sql serverI got to the Microsoft SQL Server Management Studio Expresand I see that there is no + before the db nameI didnt changed the mdf and the log file path.what happened?please helptrying to solve the problemi played with the security>users of the serverand now i cant add a new database how can i restore default??please helpthanks |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2009-01-07 : 15:54:02
|
Log in as SA user and restore settings for other sql server accounts.
E 12°55'05.63"N 56°04'39.26" |
 |
|
|
elic05
Yak Posting Veteran
62 Posts |
Posted - 2009-01-07 : 16:04:50
|
| How can I login as SAUsually when I login I log as.\SQLEXPRESSwhat do I have to write? |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2009-01-07 : 16:06:33
|
That is the instance you login to, not the useraccount.
E 12°55'05.63"N 56°04'39.26" |
|
|
|
elic05
Yak Posting Veteran
62 Posts |
Posted - 2009-01-07 : 16:10:17
|
| Please Tell me exactly what to write and wherebecause as you can see I am very new to sql serverthanks a lot |
|
|
|
|
|
|
the plus sign disapeared