--
Gail Erickson [MS]
SQL Server Documentation Team
This posting is provided "AS IS" with no warranties, and confers no rights
"Sal Young" <SalYoung@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:9BCEACF4-3E33-48B2-AB00-70AF2D087F5D@xxxxxxxxxxxxxxxx > I'm not able to run queries on a MS SQL Server 2005 using the Query
> Analyzer
> from an XP Pro machine running MS SQL 2000. I'm able to connect to the
> SQL
> 2005 server and display all objects in the Object Browser but can't run a
> simple query. Any ideas?
>
> By the way, I'm connecting with a new SQL account I created in SQL 2005
> with
> full rights.
Re: Access 2007->SQL Server2005 "connection was forcibly closed",G ... I moved every table I was able to move to the SQL...closed connections - but all of these errors are in the version which used ... the SQL Server 2000 and everything worked ... communication between ODBC (OLEDB and Native Client,... (microsoft.public.sqlserver.connect)
Re: Which Method to Create a Database Do I Use? ... BTW, I am still completely in the dark as to if I need to download SQL Express Edition because I don't have yet have any software that will allow a database connection to run on my computer, or because you assumed for some reason that I only want to use SQL Express Edition. ... To be fair, VS is a "generic" tool designed to front a variety of backend databases, but each of the serious engines have rights management needs as well. ... Hitchhiker's Guide to Visual Studio and SQL Server... (microsoft.public.dotnet.framework.adonet)
Re: Unable to Apply SP4 to SQL 2000 Cluster (new Node) ... Rebuild the node in the failover cluster.... Scenario 1" in SQL Server 2000 Books Online. ... This setup process updates to SP4 only the binaries on the new ... (microsoft.public.sqlserver.clustering)
Re: WSS 3.0 question ... I followed the advise given in removing WSS 3.0 etc, ... the server is complaining that the SQL service(?) was tempered with or corrupt. ... I may just instal the SQL server as I was going eventuall use it anyway. ... If WSUS 3.0 is installed, I would suggest you uninstall it and then you install WSS 3.0. ... (microsoft.public.windows.server.sbs)
Re: WSUS ... I'm not seeing performance issues with the full enchilada installed, and 25 users busy hitting SQL....WSUS isn't difficult to uninstall - if you have WSUS v2 (installed with SBS R2) uninstall R2 from add/remove programs. ... How can anyone work with 4 instances of SQL Server on the same box? ... (microsoft.public.windows.server.sbs)
