|
|
You're in the
sql server connect
group:Management Studio fails to connect to local db for new queries
sql server connect:
existing database using Management Studio. I can then browse the database in the Object Explorer and open the tables. But whenever I try to create a new query it fails to connect, and I can't run any queries against the database. When I select Query | Connect from the menu, the connect dialog has preselected Analysis Services as the server type and I can't change this even though the Object Explorer allows me to connect to the Database Engine. How can I get the query windows to connect to the Database Engine? Additional info: During the installation I got a warning because I don't have IIS installed on my machine - I don't see the relevance of this but I thought that I'd
What rights do you (does your login account) have on the database?
-- ____________________________________ William (Bill) Vaughn Author, Mentor, Consultant Microsoft MVP INETA Speaker www.betav.com/blog/billva www.betav.com Please reply only to the newsgroup so that others can benefit. This posting is provided "AS IS" with no warranties, and confers no rights. __________________________________ Visit www.hitchhikerguides.net to get more information on my latest book: Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition) and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook) ----------------------------------------------------------------------------------------------------------------------- [quoted text, click to view] "Cato Lommerud" <CatoLommerud@discussions.microsoft.com> wrote in message news:66A66B46-ECE9-447E-9EC3-518061A6441E@microsoft.com... > I've just installed SQL Server 2005 on my workstation, and attached an > existing database using Management Studio. I can then browse the database > in > the Object Explorer and open the tables. > > But whenever I try to create a new query it fails to connect, and I can't > run any queries against the database. When I select Query | Connect from > the > menu, the connect dialog has preselected Analysis Services as the server > type > and I can't change this even though the Object Explorer allows me to > connect > to the Database Engine. > > How can I get the query windows to connect to the Database Engine? > > Additional info: > During the installation I got a warning because I don't have IIS installed > on my machine - I don't see the relevance of this but I thought that I'd > mention it just to be sure
To be honest, I can't figure out the acces rights the windows account used in
the connection has on the database, but I do know that the windows account is local admin. Just to make absolutely sure, I made a new connection in the Object Explorer using SQL Server authentication and loggin on as SA - the problem persists for this connection Cato [quoted text, click to view] "William (Bill) Vaughn" wrote:
> What rights do you (does your login account) have on the database? > > -- > ____________________________________ > William (Bill) Vaughn > Author, Mentor, Consultant > Microsoft MVP > INETA Speaker > www.betav.com/blog/billva > www.betav.com > Please reply only to the newsgroup so that others can benefit. > This posting is provided "AS IS" with no warranties, and confers no rights. > __________________________________ > Visit www.hitchhikerguides.net to get more information on my latest book: > Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition) > and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook) > -----------------------------------------------------------------------------------------------------------------------
First, if you cut off the original thread, it makes it harder to see the
original problem. What version of SQL Server is this? Remember that connections are a function of the "visibility" and rights assigned to the server instance. It might not be visible in the configuration you're trying. -- ____________________________________ William (Bill) Vaughn Author, Mentor, Consultant Microsoft MVP INETA Speaker www.betav.com/blog/billva www.betav.com Please reply only to the newsgroup so that others can benefit. This posting is provided "AS IS" with no warranties, and confers no rights. __________________________________ Visit www.hitchhikerguides.net to get more information on my latest book: Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition) and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook) ----------------------------------------------------------------------------------------------------------------------- [quoted text, click to view] "Cato Lommerud" <CatoLommerud@discussions.microsoft.com> wrote in message news:784CA160-2309-49E5-93D5-3598FA3588C8@microsoft.com... > To be honest, I can't figure out the acces rights the windows account used > in > the connection has on the database, but I do know that the windows account > is > local admin. > > Just to make absolutely sure, I made a new connection in the Object > Explorer > using SQL Server authentication and loggin on as SA - the problem persists > for this connection > > Cato > > "William (Bill) Vaughn" wrote: > >> What rights do you (does your login account) have on the database? >> >> -- >> ____________________________________ >> William (Bill) Vaughn >> Author, Mentor, Consultant >> Microsoft MVP >> INETA Speaker >> www.betav.com/blog/billva >> www.betav.com >> Please reply only to the newsgroup so that others can benefit. >> This posting is provided "AS IS" with no warranties, and confers no >> rights. >> __________________________________ >> Visit www.hitchhikerguides.net to get more information on my latest book: >> Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition) >> and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook) >> ----------------------------------------------------------------------------------------------------------------------- >
It is SQL Server 2005 (the install media was marked Developer), and I find it
strange that I can access the database from my .Net application and browse the tables (and data in them) in Object Explorer (using open table works just fine). Cato [quoted text, click to view] "William (Bill) Vaughn" wrote:
> First, if you cut off the original thread, it makes it harder to see the > original problem. > What version of SQL Server is this? Remember that connections are a function > of the "visibility" and rights assigned to the server instance. It might not > be visible in the configuration you're trying. > > -- > ____________________________________ > William (Bill) Vaughn > Author, Mentor, Consultant > Microsoft MVP > INETA Speaker > www.betav.com/blog/billva > www.betav.com > Please reply only to the newsgroup so that others can benefit. > This posting is provided "AS IS" with no warranties, and confers no rights. > __________________________________ > Visit www.hitchhikerguides.net to get more information on my latest book: > Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition) > and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook) > ----------------------------------------------------------------------------------------------------------------------- > > "Cato Lommerud" <CatoLommerud@discussions.microsoft.com> wrote in message > news:784CA160-2309-49E5-93D5-3598FA3588C8@microsoft.com... > > To be honest, I can't figure out the acces rights the windows account used > > in > > the connection has on the database, but I do know that the windows account > > is > > local admin. > > > > Just to make absolutely sure, I made a new connection in the Object > > Explorer > > using SQL Server authentication and loggin on as SA - the problem persists > > for this connection > > > > Cato > > > > "William (Bill) Vaughn" wrote: > > > >> What rights do you (does your login account) have on the database? > >> > >> -- > >> ____________________________________ > >> William (Bill) Vaughn > >> Author, Mentor, Consultant > >> Microsoft MVP > >> INETA Speaker > >> www.betav.com/blog/billva > >> www.betav.com > >> Please reply only to the newsgroup so that others can benefit. > >> This posting is provided "AS IS" with no warranties, and confers no > >> rights. > >> __________________________________ > >> Visit www.hitchhikerguides.net to get more information on my latest book: > >> Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition) > >> and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook) > >> ----------------------------------------------------------------------------------------------------------------------- > > > >
I have not seen SSMS get hung up on only exposing analysis services, but you
can expect it to build a database query against it. I would uninstall SQL Server (Developer Edition) tools and reinstall. If it won't let you open a Database query there is something else wrong. I would also take this to the SQL Server list to see if they can help. -- ____________________________________ William (Bill) Vaughn Author, Mentor, Consultant Microsoft MVP INETA Speaker www.betav.com/blog/billva www.betav.com Please reply only to the newsgroup so that others can benefit. This posting is provided "AS IS" with no warranties, and confers no rights. __________________________________ Visit www.hitchhikerguides.net to get more information on my latest book: Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition) and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook) ----------------------------------------------------------------------------------------------------------------------- [quoted text, click to view] "Cato Lommerud" <CatoLommerud@discussions.microsoft.com> wrote in message news:66A66B46-ECE9-447E-9EC3-518061A6441E@microsoft.com... > I've just installed SQL Server 2005 on my workstation, and attached an > existing database using Management Studio. I can then browse the database > in > the Object Explorer and open the tables. > > But whenever I try to create a new query it fails to connect, and I can't > run any queries against the database. When I select Query | Connect from > the > menu, the connect dialog has preselected Analysis Services as the server > type > and I can't change this even though the Object Explorer allows me to > connect > to the Database Engine. > > How can I get the query windows to connect to the Database Engine? > > Additional info: > During the installation I got a warning because I don't have IIS installed > on my machine - I don't see the relevance of this but I thought that I'd > mention it just to be sure
Don't see what you're looking for? Try a search.
|
June 2003
July 2003
August 2003
September 2003
October 2003
November 2003
December 2003
January 2004
February 2004
March 2004
April 2004
May 2004
June 2004
July 2004
August 2004
September 2004
October 2004
November 2004
December 2004
January 2005
February 2005
March 2005
April 2005
May 2005
June 2005
July 2005
August 2005
September 2005
October 2005
November 2005
December 2005
January 2006
February 2006
March 2006
April 2006
May 2006
June 2006
July 2006
August 2006
September 2006
October 2006
November 2006
December 2006
January 2007
February 2007
March 2007
April 2007
May 2007
June 2007
July 2007
August 2007
September 2007
October 2007
November 2007
| home · blog · groups | Questions? Comments? Contact the dn |