Solved

SQL Server 2005 Connection Dialog question

Posted on 2007-03-20
5
197 Views
Last Modified: 2012-05-05
Hi

I've just upgraded to Microsoft SQL Server 2005 Management Studio Express. I've noticed that each time I open a saved query the application displays the 'Connect to Database Engine' dialog and asks me to connect again. I'm sure this didn't happen when i first started using the software. Any ideas?

Regards
0
Comment
Question by:molar
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
5 Comments
 
LVL 20

Expert Comment

by:Sirees
ID: 18755558
0
 
LVL 5

Accepted Solution

by:
dkDeveloper earned 500 total points
ID: 18755563
molar,

That's a standard 2005 "feature".  You're prompted to login with each saved file (even if opened in batches).  If you install SP2, they provided an option to always utilize the last active connection for each newly opened file.  That's about the only way around this issue...

hth,
dK
0
 
LVL 2

Author Comment

by:molar
ID: 18758027
Thanks for the input.
The server is just the default instance on the local server. It's already registered so I don't think that that's the problem.

I've tried installting SP2 but I get the same problem. How do I get to the "always utilize the last active connection for each newly opened file" option?

0
 
LVL 5

Expert Comment

by:dkDeveloper
ID: 18758126
molar,

Maybe I misunderstood you.  The patch fixes the issue when opening multiple scripting files, it utilizes the active connection.  I would assume that it would do the same for each individual file (as indicated by this post)

http://sqladvice.com/blogs/repeatableread/archive/2007/02/19/SQL-Server-2005-SP2-Improvements.aspx
0
 
LVL 2

Author Comment

by:molar
ID: 18765266
I got the sql server 2005 connection to work. Downloaded SP2 from another link on the microsoft site and it seems to have fixed the problem.

Thanks dk
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.

690 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question