Solved

SQL Server 2005 Connection Dialog question

Posted on 2007-03-20
5
190 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
  • 2
  • 2
5 Comments
 
LVL 20

Expert Comment

by:Sirees
Comment Utility
0
 
LVL 5

Accepted Solution

by:
dkDeveloper earned 500 total points
Comment Utility
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
Comment Utility
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
Comment Utility
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
Comment Utility
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

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
JSON is being used more and more, besides XML, and you surely wanted to parse the data out into SQL instead of doing it in some Javascript. The below function in SQL Server can do the job for you, returning a quick table with the parsed data.
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.

772 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

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now