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.

 All Forums
 SQL Server 2005 Forums
 Express Edition and Compact Edition (2005)
 Stay login in Sql Express

Author  Topic 

AskSQLTeam
Ask 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"

mikewa
Microsoft 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 Wachal
SQL Express

This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
Go to Top of Page
   

- Advertisement -