|
dev
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
Mobile Only? Why?I've just finished installing the workstation tools from the SQL Server 2005
DVD (No database engine). I've also installed Visual Studio 2005, with just the VB option and the other standard stuff. When I start the Management Studio, connect to a server (doesn't matter what version), then open a new query, the query is disconnected and the only connection option is for SQL Server Mobile. Anyone have any ideas? I've installed (and repaired) the native client. I can browse servers and see objects, etc., just no queries. I've installed/uninstalled three times. Thanks all. Am I correct that you are talking about the New Query dialog box in
Management Studio? On the File menu, point to New, do you see Database Engine Query as one of the choices? -- Show quoteRick Byham MCDBA, MCSE, MCSA Lead Technical Writer, Microsoft, SQL Server Books Online This posting is provided "as is" with no warranties, and confers no rights. "David Pendleton" <qnir***@gpd.arg> wrote in message news:u3yzF5H7FHA.1020@TK2MSFTNGP15.phx.gbl... > I've just finished installing the workstation tools from the SQL Server > 2005 DVD (No database engine). > > I've also installed Visual Studio 2005, with just the VB option and the > other standard stuff. > > When I start the Management Studio, connect to a server (doesn't matter > what version), then open a new query, the query is disconnected and the > only connection option is for SQL Server Mobile. > > Anyone have any ideas? > > I've installed (and repaired) the native client. I can browse servers and > see objects, etc., just no queries. I've installed/uninstalled three > times. > > Thanks all. > > Yes, the dropdown (to select a provider) is disabled with SQL Server Mobile
being the selected item. Show quote "Rick Byham [MS]" <rick***@online.microsoft.com> wrote in message news:%23WgVl5s7FHA.1420@TK2MSFTNGP09.phx.gbl... > Am I correct that you are talking about the New Query dialog box in > Management Studio? On the File menu, point to New, do you see Database > Engine Query as one of the choices? > -- > Rick Byham > MCDBA, MCSE, MCSA > Lead Technical Writer, > Microsoft, SQL Server Books Online > This posting is provided "as is" with > no warranties, and confers no rights. > > "David Pendleton" <qnir***@gpd.arg> wrote in message > news:u3yzF5H7FHA.1020@TK2MSFTNGP15.phx.gbl... >> I've just finished installing the workstation tools from the SQL Server >> 2005 DVD (No database engine). >> >> I've also installed Visual Studio 2005, with just the VB option and the >> other standard stuff. >> >> When I start the Management Studio, connect to a server (doesn't matter >> what version), then open a new query, the query is disconnected and the >> only connection option is for SQL Server Mobile. >> >> Anyone have any ideas? >> >> I've installed (and repaired) the native client. I can browse servers and >> see objects, etc., just no queries. I've installed/uninstalled three >> times. >> >> Thanks all. >> >> > > I've shopped your e-mail around Microsoft a bit, and we can't think of any
reasonable way you could get into that condition. The obvious but cop-out answer is that either Management Studio or the underlying Visual Studio is somehow damaged. It's less likely to be related to the SQL Native Client. Some more questions: Are you using the RTM version of SQL Server Management Studio? How consistent is this problem? That is, there are several ways to open the Connect to Server dialog box in Management Studio: - On the File menu, point to New, and then click Database Engine Query - On the Standard toolbar, click New Query - On the Standard toolbar, click Database Engine Query - On the Object Explorer toolbar, click Connect, and then click Database Engine Do you only get SQL Server Mobile with any of those ways? What about registering servers? On the View menu click Register Servers. In the Registered Servers window toolbar, click Database Engine. Now can you register a Database Engine by right-clicking Database Engine, point to New, and then click Server Registration? Now is the Server type listed as "Database Engine"? Can you connect to the Database Engine from the Server Explorer of Visual Studio? (I'm interested in assisting you but I will not be available again until Monday. Sorry. Holiday plans.) -- Show quoteRick Byham MCDBA, MCSE, MCSA Lead Technical Writer, Microsoft, SQL Server Books Online This posting is provided "as is" with no warranties, and confers no rights. "David Pendleton" <qnir***@gpd.arg> wrote in message news:%235DXeAt7FHA.2816@tk2msftngp13.phx.gbl... > Yes, the dropdown (to select a provider) is disabled with SQL Server > Mobile being the selected item. > > > "Rick Byham [MS]" <rick***@online.microsoft.com> wrote in message > news:%23WgVl5s7FHA.1420@TK2MSFTNGP09.phx.gbl... >> Am I correct that you are talking about the New Query dialog box in >> Management Studio? On the File menu, point to New, do you see Database >> Engine Query as one of the choices? >> -- >> Rick Byham >> MCDBA, MCSE, MCSA >> Lead Technical Writer, >> Microsoft, SQL Server Books Online >> This posting is provided "as is" with >> no warranties, and confers no rights. >> >> "David Pendleton" <qnir***@gpd.arg> wrote in message >> news:u3yzF5H7FHA.1020@TK2MSFTNGP15.phx.gbl... >>> I've just finished installing the workstation tools from the SQL Server >>> 2005 DVD (No database engine). >>> >>> I've also installed Visual Studio 2005, with just the VB option and the >>> other standard stuff. >>> >>> When I start the Management Studio, connect to a server (doesn't matter >>> what version), then open a new query, the query is disconnected and the >>> only connection option is for SQL Server Mobile. >>> >>> Anyone have any ideas? >>> >>> I've installed (and repaired) the native client. I can browse servers >>> and see objects, etc., just no queries. I've installed/uninstalled three >>> times. >>> >>> Thanks all. >>> >>> >> >> > > Yes, I'm using the version handed out in Vegas at the launch.
I have tried all the connection methods detailed below with the same results. I am able to register, and connect to a database server and browse objects, etc. Show quote "Rick Byham [MS]" <rick***@online.microsoft.com> wrote in message news:%23Ukue367FHA.1416@TK2MSFTNGP09.phx.gbl... > I've shopped your e-mail around Microsoft a bit, and we can't think of any > reasonable way you could get into that condition. The obvious but cop-out > answer is that either Management Studio or the underlying Visual Studio is > somehow damaged. It's less likely to be related to the SQL Native Client. > > Some more questions: > Are you using the RTM version of SQL Server Management Studio? > > How consistent is this problem? That is, there are several ways to open > the Connect to Server dialog box in Management Studio: > - On the File menu, point to New, and then click Database Engine Query > - On the Standard toolbar, click New Query > - On the Standard toolbar, click Database Engine Query > - On the Object Explorer toolbar, click Connect, and then click Database > Engine > Do you only get SQL Server Mobile with any of those ways? > > What about registering servers? On the View menu click Register Servers. > In the Registered Servers window toolbar, click Database Engine. Now can > you register a Database Engine by right-clicking Database Engine, point to > New, and then click Server Registration? Now is the Server type listed as > "Database Engine"? > > Can you connect to the Database Engine from the Server Explorer of Visual > Studio? > > (I'm interested in assisting you but I will not be available again until > Monday. Sorry. Holiday plans.) > -- > Rick Byham > MCDBA, MCSE, MCSA > Lead Technical Writer, > Microsoft, SQL Server Books Online > This posting is provided "as is" with > no warranties, and confers no rights. > > "David Pendleton" <qnir***@gpd.arg> wrote in message > news:%235DXeAt7FHA.2816@tk2msftngp13.phx.gbl... >> Yes, the dropdown (to select a provider) is disabled with SQL Server >> Mobile being the selected item. >> >> >> "Rick Byham [MS]" <rick***@online.microsoft.com> wrote in message >> news:%23WgVl5s7FHA.1420@TK2MSFTNGP09.phx.gbl... >>> Am I correct that you are talking about the New Query dialog box in >>> Management Studio? On the File menu, point to New, do you see Database >>> Engine Query as one of the choices? >>> -- >>> Rick Byham >>> MCDBA, MCSE, MCSA >>> Lead Technical Writer, >>> Microsoft, SQL Server Books Online >>> This posting is provided "as is" with >>> no warranties, and confers no rights. >>> >>> "David Pendleton" <qnir***@gpd.arg> wrote in message >>> news:u3yzF5H7FHA.1020@TK2MSFTNGP15.phx.gbl... >>>> I've just finished installing the workstation tools from the SQL Server >>>> 2005 DVD (No database engine). >>>> >>>> I've also installed Visual Studio 2005, with just the VB option and the >>>> other standard stuff. >>>> >>>> When I start the Management Studio, connect to a server (doesn't matter >>>> what version), then open a new query, the query is disconnected and the >>>> only connection option is for SQL Server Mobile. >>>> >>>> Anyone have any ideas? >>>> >>>> I've installed (and repaired) the native client. I can browse servers >>>> and see objects, etc., just no queries. I've installed/uninstalled >>>> three times. >>>> >>>> Thanks all. >>>> >>>> >>> >>> >> >> > > If you can browse objects, I presume that means you can connect with Object
Explorer. What happens in Object Explorer if you right-click a database, and then click New Query? You should get a Database Engine query window. Does that work? This will tell us if the Query Editor is working properly. -- Show quoteRick Byham MCDBA, MCSE, MCSA Lead Technical Writer, Microsoft, SQL Server Books Online This posting is provided "as is" with no warranties, and confers no rights. "David Pendleton" <qnir***@gpd.arg> wrote in message news:OVXgegF9FHA.808@TK2MSFTNGP09.phx.gbl... > Yes, I'm using the version handed out in Vegas at the launch. > > I have tried all the connection methods detailed below with the same > results. I am able to register, and connect to a database server and > browse objects, etc. > > > "Rick Byham [MS]" <rick***@online.microsoft.com> wrote in message > news:%23Ukue367FHA.1416@TK2MSFTNGP09.phx.gbl... >> I've shopped your e-mail around Microsoft a bit, and we can't think of >> any reasonable way you could get into that condition. The obvious but >> cop-out answer is that either Management Studio or the underlying Visual >> Studio is somehow damaged. It's less likely to be related to the SQL >> Native Client. >> >> Some more questions: >> Are you using the RTM version of SQL Server Management Studio? >> >> How consistent is this problem? That is, there are several ways to open >> the Connect to Server dialog box in Management Studio: >> - On the File menu, point to New, and then click Database Engine Query >> - On the Standard toolbar, click New Query >> - On the Standard toolbar, click Database Engine Query >> - On the Object Explorer toolbar, click Connect, and then click Database >> Engine >> Do you only get SQL Server Mobile with any of those ways? >> >> What about registering servers? On the View menu click Register Servers. >> In the Registered Servers window toolbar, click Database Engine. Now can >> you register a Database Engine by right-clicking Database Engine, point >> to New, and then click Server Registration? Now is the Server type listed >> as "Database Engine"? >> >> Can you connect to the Database Engine from the Server Explorer of Visual >> Studio? >> >> (I'm interested in assisting you but I will not be available again until >> Monday. Sorry. Holiday plans.) >> -- >> Rick Byham >> MCDBA, MCSE, MCSA >> Lead Technical Writer, >> Microsoft, SQL Server Books Online >> This posting is provided "as is" with >> no warranties, and confers no rights. >> >> "David Pendleton" <qnir***@gpd.arg> wrote in message >> news:%235DXeAt7FHA.2816@tk2msftngp13.phx.gbl... >>> Yes, the dropdown (to select a provider) is disabled with SQL Server >>> Mobile being the selected item. >>> >>> >>> "Rick Byham [MS]" <rick***@online.microsoft.com> wrote in message >>> news:%23WgVl5s7FHA.1420@TK2MSFTNGP09.phx.gbl... >>>> Am I correct that you are talking about the New Query dialog box in >>>> Management Studio? On the File menu, point to New, do you see Database >>>> Engine Query as one of the choices? >>>> -- >>>> Rick Byham >>>> MCDBA, MCSE, MCSA >>>> Lead Technical Writer, >>>> Microsoft, SQL Server Books Online >>>> This posting is provided "as is" with >>>> no warranties, and confers no rights. >>>> >>>> "David Pendleton" <qnir***@gpd.arg> wrote in message >>>> news:u3yzF5H7FHA.1020@TK2MSFTNGP15.phx.gbl... >>>>> I've just finished installing the workstation tools from the SQL >>>>> Server 2005 DVD (No database engine). >>>>> >>>>> I've also installed Visual Studio 2005, with just the VB option and >>>>> the other standard stuff. >>>>> >>>>> When I start the Management Studio, connect to a server (doesn't >>>>> matter what version), then open a new query, the query is disconnected >>>>> and the only connection option is for SQL Server Mobile. >>>>> >>>>> Anyone have any ideas? >>>>> >>>>> I've installed (and repaired) the native client. I can browse servers >>>>> and see objects, etc., just no queries. I've installed/uninstalled >>>>> three times. >>>>> >>>>> Thanks all. >>>>> >>>>> >>>> >>>> >>> >>> >> >> > > It comes up as a disconnected query. When I right-click in the query window
and select connect, the connection dialog appears. In this dialog, the dropdown (to select a provider) is disabled and SQL Server Mobile is the selected item. Thanks. Show quote "Rick Byham [MS]" <rick***@online.microsoft.com> wrote in message news:O5X4uld9FHA.3360@TK2MSFTNGP11.phx.gbl... > If you can browse objects, I presume that means you can connect with > Object Explorer. What happens in Object Explorer if you right-click a > database, and then click New Query? You should get a Database Engine query > window. Does that work? This will tell us if the Query Editor is working > properly. > -- > Rick Byham > MCDBA, MCSE, MCSA > Lead Technical Writer, > Microsoft, SQL Server Books Online > This posting is provided "as is" with > no warranties, and confers no rights. > > "David Pendleton" <qnir***@gpd.arg> wrote in message > news:OVXgegF9FHA.808@TK2MSFTNGP09.phx.gbl... >> Yes, I'm using the version handed out in Vegas at the launch. >> >> I have tried all the connection methods detailed below with the same >> results. I am able to register, and connect to a database server and >> browse objects, etc. >> >> >> "Rick Byham [MS]" <rick***@online.microsoft.com> wrote in message >> news:%23Ukue367FHA.1416@TK2MSFTNGP09.phx.gbl... >>> I've shopped your e-mail around Microsoft a bit, and we can't think of >>> any reasonable way you could get into that condition. The obvious but >>> cop-out answer is that either Management Studio or the underlying Visual >>> Studio is somehow damaged. It's less likely to be related to the SQL >>> Native Client. >>> >>> Some more questions: >>> Are you using the RTM version of SQL Server Management Studio? >>> >>> How consistent is this problem? That is, there are several ways to open >>> the Connect to Server dialog box in Management Studio: >>> - On the File menu, point to New, and then click Database Engine Query >>> - On the Standard toolbar, click New Query >>> - On the Standard toolbar, click Database Engine Query >>> - On the Object Explorer toolbar, click Connect, and then click Database >>> Engine >>> Do you only get SQL Server Mobile with any of those ways? >>> >>> What about registering servers? On the View menu click Register Servers. >>> In the Registered Servers window toolbar, click Database Engine. Now can >>> you register a Database Engine by right-clicking Database Engine, point >>> to New, and then click Server Registration? Now is the Server type >>> listed as "Database Engine"? >>> >>> Can you connect to the Database Engine from the Server Explorer of >>> Visual Studio? >>> >>> (I'm interested in assisting you but I will not be available again until >>> Monday. Sorry. Holiday plans.) >>> -- >>> Rick Byham >>> MCDBA, MCSE, MCSA >>> Lead Technical Writer, >>> Microsoft, SQL Server Books Online >>> This posting is provided "as is" with >>> no warranties, and confers no rights. >>> >>> "David Pendleton" <qnir***@gpd.arg> wrote in message >>> news:%235DXeAt7FHA.2816@tk2msftngp13.phx.gbl... >>>> Yes, the dropdown (to select a provider) is disabled with SQL Server >>>> Mobile being the selected item. >>>> >>>> >>>> "Rick Byham [MS]" <rick***@online.microsoft.com> wrote in message >>>> news:%23WgVl5s7FHA.1420@TK2MSFTNGP09.phx.gbl... >>>>> Am I correct that you are talking about the New Query dialog box in >>>>> Management Studio? On the File menu, point to New, do you see Database >>>>> Engine Query as one of the choices? >>>>> -- >>>>> Rick Byham >>>>> MCDBA, MCSE, MCSA >>>>> Lead Technical Writer, >>>>> Microsoft, SQL Server Books Online >>>>> This posting is provided "as is" with >>>>> no warranties, and confers no rights. >>>>> >>>>> "David Pendleton" <qnir***@gpd.arg> wrote in message >>>>> news:u3yzF5H7FHA.1020@TK2MSFTNGP15.phx.gbl... >>>>>> I've just finished installing the workstation tools from the SQL >>>>>> Server 2005 DVD (No database engine). >>>>>> >>>>>> I've also installed Visual Studio 2005, with just the VB option and >>>>>> the other standard stuff. >>>>>> >>>>>> When I start the Management Studio, connect to a server (doesn't >>>>>> matter what version), then open a new query, the query is >>>>>> disconnected and the only connection option is for SQL Server Mobile. >>>>>> >>>>>> Anyone have any ideas? >>>>>> >>>>>> I've installed (and repaired) the native client. I can browse servers >>>>>> and see objects, etc., just no queries. I've installed/uninstalled >>>>>> three times. >>>>>> >>>>>> Thanks all. >>>>>> >>>>>> >>>>> >>>>> >>>> >>>> >>> >>> >> >> > > I sorry. I know this must be frustrating for you, but I can think of no
reason for this. Since you have already uninstalled and reinstalled that should have fixed any damaged binaries or registry entries. I'm out of ideas. I guess that means you need a call to product support. -- Show quoteRick Byham MCDBA, MCSE, MCSA Lead Technical Writer, Microsoft, SQL Server Books Online This posting is provided "as is" with no warranties, and confers no rights. "David Pendleton" <qnir***@gpd.arg> wrote in message news:OYVPHzo9FHA.500@TK2MSFTNGP15.phx.gbl... > It comes up as a disconnected query. When I right-click in the query > window and select connect, the connection dialog appears. > > In this dialog, the dropdown (to select a provider) is disabled and SQL > Server Mobile is the selected item. > > Thanks. > > "Rick Byham [MS]" <rick***@online.microsoft.com> wrote in message > news:O5X4uld9FHA.3360@TK2MSFTNGP11.phx.gbl... >> If you can browse objects, I presume that means you can connect with >> Object Explorer. What happens in Object Explorer if you right-click a >> database, and then click New Query? You should get a Database Engine >> query window. Does that work? This will tell us if the Query Editor is >> working properly. >> -- >> Rick Byham >> MCDBA, MCSE, MCSA >> Lead Technical Writer, >> Microsoft, SQL Server Books Online >> This posting is provided "as is" with >> no warranties, and confers no rights. >> >> "David Pendleton" <qnir***@gpd.arg> wrote in message >> news:OVXgegF9FHA.808@TK2MSFTNGP09.phx.gbl... >>> Yes, I'm using the version handed out in Vegas at the launch. >>> >>> I have tried all the connection methods detailed below with the same >>> results. I am able to register, and connect to a database server and >>> browse objects, etc. >>> >>> >>> "Rick Byham [MS]" <rick***@online.microsoft.com> wrote in message >>> news:%23Ukue367FHA.1416@TK2MSFTNGP09.phx.gbl... >>>> I've shopped your e-mail around Microsoft a bit, and we can't think of >>>> any reasonable way you could get into that condition. The obvious but >>>> cop-out answer is that either Management Studio or the underlying >>>> Visual Studio is somehow damaged. It's less likely to be related to the >>>> SQL Native Client. >>>> >>>> Some more questions: >>>> Are you using the RTM version of SQL Server Management Studio? >>>> >>>> How consistent is this problem? That is, there are several ways to open >>>> the Connect to Server dialog box in Management Studio: >>>> - On the File menu, point to New, and then click Database Engine Query >>>> - On the Standard toolbar, click New Query >>>> - On the Standard toolbar, click Database Engine Query >>>> - On the Object Explorer toolbar, click Connect, and then click >>>> Database Engine >>>> Do you only get SQL Server Mobile with any of those ways? >>>> >>>> What about registering servers? On the View menu click Register >>>> Servers. In the Registered Servers window toolbar, click Database >>>> Engine. Now can you register a Database Engine by right-clicking >>>> Database Engine, point to New, and then click Server Registration? Now >>>> is the Server type listed as "Database Engine"? >>>> >>>> Can you connect to the Database Engine from the Server Explorer of >>>> Visual Studio? >>>> >>>> (I'm interested in assisting you but I will not be available again >>>> until Monday. Sorry. Holiday plans.) >>>> -- >>>> Rick Byham >>>> MCDBA, MCSE, MCSA >>>> Lead Technical Writer, >>>> Microsoft, SQL Server Books Online >>>> This posting is provided "as is" with >>>> no warranties, and confers no rights. >>>> >>>> "David Pendleton" <qnir***@gpd.arg> wrote in message >>>> news:%235DXeAt7FHA.2816@tk2msftngp13.phx.gbl... >>>>> Yes, the dropdown (to select a provider) is disabled with SQL Server >>>>> Mobile being the selected item. >>>>> >>>>> >>>>> "Rick Byham [MS]" <rick***@online.microsoft.com> wrote in message >>>>> news:%23WgVl5s7FHA.1420@TK2MSFTNGP09.phx.gbl... >>>>>> Am I correct that you are talking about the New Query dialog box in >>>>>> Management Studio? On the File menu, point to New, do you see >>>>>> Database Engine Query as one of the choices? >>>>>> -- >>>>>> Rick Byham >>>>>> MCDBA, MCSE, MCSA >>>>>> Lead Technical Writer, >>>>>> Microsoft, SQL Server Books Online >>>>>> This posting is provided "as is" with >>>>>> no warranties, and confers no rights. >>>>>> >>>>>> "David Pendleton" <qnir***@gpd.arg> wrote in message >>>>>> news:u3yzF5H7FHA.1020@TK2MSFTNGP15.phx.gbl... >>>>>>> I've just finished installing the workstation tools from the SQL >>>>>>> Server 2005 DVD (No database engine). >>>>>>> >>>>>>> I've also installed Visual Studio 2005, with just the VB option and >>>>>>> the other standard stuff. >>>>>>> >>>>>>> When I start the Management Studio, connect to a server (doesn't >>>>>>> matter what version), then open a new query, the query is >>>>>>> disconnected and the only connection option is for SQL Server >>>>>>> Mobile. >>>>>>> >>>>>>> Anyone have any ideas? >>>>>>> >>>>>>> I've installed (and repaired) the native client. I can browse >>>>>>> servers and see objects, etc., just no queries. I've >>>>>>> installed/uninstalled three times. >>>>>>> >>>>>>> Thanks all. >>>>>>> >>>>>>> >>>>>> >>>>>> >>>>> >>>>> >>>> >>>> >>> >>> >> >> > > Thanks for trying, anyway.
I'm out of ideas, also. I have successfully installed it on a second workstation and laptop, both more or less identically configured. It's probably about time I rebuilt this one anyway, it's been five years... Thanks again. Dave Show quote "Rick Byham [MS]" <rick***@online.microsoft.com> wrote in message news:eyd$Pyp9FHA.952@TK2MSFTNGP12.phx.gbl... >I sorry. I know this must be frustrating for you, but I can think of no >reason for this. Since you have already uninstalled and reinstalled that >should have fixed any damaged binaries or registry entries. I'm out of >ideas. I guess that means you need a call to product support. > -- > Rick Byham > MCDBA, MCSE, MCSA > Lead Technical Writer, > Microsoft, SQL Server Books Online > This posting is provided "as is" with > no warranties, and confers no rights. > > "David Pendleton" <qnir***@gpd.arg> wrote in message > news:OYVPHzo9FHA.500@TK2MSFTNGP15.phx.gbl... >> It comes up as a disconnected query. When I right-click in the query >> window and select connect, the connection dialog appears. >> >> In this dialog, the dropdown (to select a provider) is disabled and SQL >> Server Mobile is the selected item. >> >> Thanks. >> >> "Rick Byham [MS]" <rick***@online.microsoft.com> wrote in message >> news:O5X4uld9FHA.3360@TK2MSFTNGP11.phx.gbl... >>> If you can browse objects, I presume that means you can connect with >>> Object Explorer. What happens in Object Explorer if you right-click a >>> database, and then click New Query? You should get a Database Engine >>> query window. Does that work? This will tell us if the Query Editor is >>> working properly. >>> -- >>> Rick Byham >>> MCDBA, MCSE, MCSA >>> Lead Technical Writer, >>> Microsoft, SQL Server Books Online >>> This posting is provided "as is" with >>> no warranties, and confers no rights. >>> >>> "David Pendleton" <qnir***@gpd.arg> wrote in message >>> news:OVXgegF9FHA.808@TK2MSFTNGP09.phx.gbl... >>>> Yes, I'm using the version handed out in Vegas at the launch. >>>> >>>> I have tried all the connection methods detailed below with the same >>>> results. I am able to register, and connect to a database server and >>>> browse objects, etc. >>>> >>>> >>>> "Rick Byham [MS]" <rick***@online.microsoft.com> wrote in message >>>> news:%23Ukue367FHA.1416@TK2MSFTNGP09.phx.gbl... >>>>> I've shopped your e-mail around Microsoft a bit, and we can't think of >>>>> any reasonable way you could get into that condition. The obvious but >>>>> cop-out answer is that either Management Studio or the underlying >>>>> Visual Studio is somehow damaged. It's less likely to be related to >>>>> the SQL Native Client. >>>>> >>>>> Some more questions: >>>>> Are you using the RTM version of SQL Server Management Studio? >>>>> >>>>> How consistent is this problem? That is, there are several ways to >>>>> open the Connect to Server dialog box in Management Studio: >>>>> - On the File menu, point to New, and then click Database Engine Query >>>>> - On the Standard toolbar, click New Query >>>>> - On the Standard toolbar, click Database Engine Query >>>>> - On the Object Explorer toolbar, click Connect, and then click >>>>> Database Engine >>>>> Do you only get SQL Server Mobile with any of those ways? >>>>> >>>>> What about registering servers? On the View menu click Register >>>>> Servers. In the Registered Servers window toolbar, click Database >>>>> Engine. Now can you register a Database Engine by right-clicking >>>>> Database Engine, point to New, and then click Server Registration? Now >>>>> is the Server type listed as "Database Engine"? >>>>> >>>>> Can you connect to the Database Engine from the Server Explorer of >>>>> Visual Studio? >>>>> >>>>> (I'm interested in assisting you but I will not be available again >>>>> until Monday. Sorry. Holiday plans.) >>>>> -- >>>>> Rick Byham >>>>> MCDBA, MCSE, MCSA >>>>> Lead Technical Writer, >>>>> Microsoft, SQL Server Books Online >>>>> This posting is provided "as is" with >>>>> no warranties, and confers no rights. >>>>> >>>>> "David Pendleton" <qnir***@gpd.arg> wrote in message >>>>> news:%235DXeAt7FHA.2816@tk2msftngp13.phx.gbl... >>>>>> Yes, the dropdown (to select a provider) is disabled with SQL Server >>>>>> Mobile being the selected item. >>>>>> >>>>>> >>>>>> "Rick Byham [MS]" <rick***@online.microsoft.com> wrote in message >>>>>> news:%23WgVl5s7FHA.1420@TK2MSFTNGP09.phx.gbl... >>>>>>> Am I correct that you are talking about the New Query dialog box in >>>>>>> Management Studio? On the File menu, point to New, do you see >>>>>>> Database Engine Query as one of the choices? >>>>>>> -- >>>>>>> Rick Byham >>>>>>> MCDBA, MCSE, MCSA >>>>>>> Lead Technical Writer, >>>>>>> Microsoft, SQL Server Books Online >>>>>>> This posting is provided "as is" with >>>>>>> no warranties, and confers no rights. >>>>>>> >>>>>>> "David Pendleton" <qnir***@gpd.arg> wrote in message >>>>>>> news:u3yzF5H7FHA.1020@TK2MSFTNGP15.phx.gbl... >>>>>>>> I've just finished installing the workstation tools from the SQL >>>>>>>> Server 2005 DVD (No database engine). >>>>>>>> >>>>>>>> I've also installed Visual Studio 2005, with just the VB option and >>>>>>>> the other standard stuff. >>>>>>>> >>>>>>>> When I start the Management Studio, connect to a server (doesn't >>>>>>>> matter what version), then open a new query, the query is >>>>>>>> disconnected and the only connection option is for SQL Server >>>>>>>> Mobile. >>>>>>>> >>>>>>>> Anyone have any ideas? >>>>>>>> >>>>>>>> I've installed (and repaired) the native client. I can browse >>>>>>>> servers and see objects, etc., just no queries. I've >>>>>>>> installed/uninstalled three times. >>>>>>>> >>>>>>>> Thanks all. >>>>>>>> >>>>>>>> >>>>>>> >>>>>>> >>>>>> >>>>>> >>>>> >>>>> >>>> >>>> >>> >>> >> >> > > |
|||||||||||||||||||||||