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 |  
                                    | AskSQLTeamAsk SQLTeam Question
 
 
                                        0 Posts | 
                                            
                                            |  Posted - 2007-03-07 : 08:38:22 
 |  
                                            | Tomer  writes "Hi:I installed sql server express management studio. i'm able to login with the local user and sa user as well. However when I’m connected and i open a new file to a query window (a sql file for example) the login window prompts me and I need to login again. Do you think there's a way to overcome this problem and login only once?Thanks,Tomer" |  |  
                                    | mikewaMicrosoft SQL Server Product Team
 
 
                                    84 Posts | 
                                        
                                          |  Posted - 2007-03-12 : 13:35:26 
 |  
                                          | This is the designed behavior of Management Studio. It's not that you are being logged out, it's that the New Query is creatting new connection. There may be a way to configure when SSMS pulls connection information from other connections, you caould ask this in the SQL General Tool forum on the MSDN forums.Regards,Mike WachalSQL ExpressThis posting is provided "AS IS" with no warranties, and confers no rights.Use of included script samples are subject to the terms specified athttp://www.microsoft.com/info/cpyright.htm |  
                                          |  |  |  
                                |  |  |  |