sql client in sql server 2005 - Microsoft SQL Server

nitin

HI all
Gurus i am struck up in sql 2005.I am new to sql 2005.I have my server
installed on one machine.Now what do i download so that i am able to
register it.
Now i want to connect to that machine thru enterprise manager or client
like we do in sql server 2000 thru query analyzer..
Will sql 2005 express help.?
Please help
Regards

May 30 '06 #1

Subscribe Reply

2263

Erland Sommarskog

nitin (ni*******@gmai l.com) writes:

Gurus i am struck up in sql 2005.I am new to sql 2005.I have my server
installed on one machine.Now what do i download so that i am able to
register it.
Now i want to connect to that machine thru enterprise manager or client
like we do in sql server 2000 thru query analyzer..

You cannot connect to SQL Server 2005 from Enterprise Manager. You cannot
connect from Query Analyzer to SQL 2005, although some features does not
work. But for running queries it works just fine!

In SQL 2005 EM and QA has been replaced ny SQL Server Management Studio.
This tool comes with all editions of SQL 2005, except for SQL Express.
So if you installed SQL 2005 Developer Editions (for instance), you
should have the tools there. It may be on a second CD or in a Tools
directory. (But as a tip: keep you Query Analyzer! Not everything is
better in the new tool.)

If you have SQL Express, you can download the Express version of
Management Studio from http://msdn.microsoft.com/sql/express/.
--
Erland Sommarskog, SQL Server MVP, es****@sommarsk og.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx

May 30 '06 #2

Hugo Kornelis

On 30 May 2006 09:38:18 -0700, nitin wrote:

HI all
Gurus i am struck up in sql 2005.I am new to sql 2005.I have my server
installed on one machine.Now what do i download so that i am able to
register it.
Now i want to connect to that machine thru enterprise manager or client
like we do in sql server 2000 thru query analyzer..
Will sql 2005 express help.?
Please help
Regards

Hi Nitin,

Install the client tools if yoou haven't already done so. Then, click
Start / All Programs / Microsoft SQL Server 2005 / SQL Server Management
Studio.

Management Studio is the replacement for both Query Analyzer and
Enterprise Manager.

--
Hugo Kornelis, SQL Server MVP

May 30 '06 #3

Similar topics

4464

2-player game, client and server at localhost

by: Michael Rybak | last post by:

hi, everyone. I'm writing a 2-players game that should support network mode. I'm now testing it on 1 PC since I don't have 2. I directly use sockets, and both client and server do computations, the only data transfered is user mouse/kbd input. It works synchronously, but somehow, when I play in client window, both client and ...

Python

4435

using Multiple client certificates

by: | last post by:

Hi all, HttpWebRequest, and SoapHttpClientProtocol both expose a ClientCertificates property, which can hold multiple client certificates, but on the service side, it can only receive one client certificate, since it derives System.Web.Services.WebService class, and it's Context.Request.ClientCertificate is a single HttpClientCertificate...

.NET Framework

2255

Remoting client exception

by: Sharon | last post by:

Hi, I'm using the remoting, and I have a remoting object that has a public event that other processes should register to it. But when the client process is registering to the remote event, it throw the following exception: System.Runtime.Serialization.SerializationException {â€œCannot find the assembly Tester, Version=1.0.2164.27180,...

C# / C Sharp

7712

Sending a WSE 2.0 security SOAP request from HTML client VBScript

by: Sydney | last post by:

Hi, I am trying to construct a WSE 2.0 security SOAP request in VBScript on an HTML page to send off to a webservice. I think I've almost got it but I'm having an issue generating the nonce value for the UserName token. Is it possilbe at all to do this from VBScript (or jscript?)? I know I will be limited with what I can do with the SOAP...

.NET Framework

6084

How to unique identify revisit client computer

by: Goh | last post by:

Hi, I would like to know how can we implement a web page that intelligent enough to unique identify that pc have been visit before without any cookies and login user require. I have try implement this by MAC address. When user browser the web site I sometime can get user pc MAC and sometime no. Why this type of implementation are so...

ASP.NET

16396

sql 2005 client tools

by: Phil Townsend | last post by:

I have installed SQL 2005 on a new machine and cannot find any of the client tools I am used to having: query analyzer, enterprise mgr., profiler. Shouldn't they be included in a default installation if I chose to install client tools? Where do I go to find them? *** Sent via Developersdex http://www.developersdex.com ***

Microsoft SQL Server

3129

Creat an Installation package for client and server

by: piggy | last post by:

I have developed an application using C# under .NET 2.0 framework. It is almost done and it is time for me to think about deploymnet to all users. I don't have any background about this and would like to see if anyone can help me get started. I have read some about clickonce deployment and not sure much about this yet. Thanks for your help.

C# / C Sharp

2528

What ports do i need to unblock on client and server (running msvsmon.exe) to debug remotely from my client box with visual studio 2005 pro?

by: DR | last post by:

What ports do i need to unblock on client and server (running msvsmon.exe) to debug remotely from my client box with visual studio 2005 pro? When I attach to remote process a connection shows up in msvsmon.exe on the remote machine, however, the client box with visual studio displays error: "Unable to connect to the mricosoft visual studio...

C# / C Sharp

1149

Downloading database from server on client machine

by: ShreyaTrivedi | last post by:

I have purchased a web space in a web server for hosting my website (eg. www.xyz.com) . I have put a Sql server 2005 database in the db folder of this web space. I want to download this database from another windows application .net c# which is on client side when user presses "Download" button. What code should I write on my client-side...

Microsoft SQL Server

7852

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language...

Windows Server

8216

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. ...

C / C++

8349

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that...

Online Marketing

7974

The easy way to turn off automatic updates for Windows 10/11

by: Hystou | last post by:

Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For...

Windows Server

6629

AI Job Threat for Devs

by: agi2029 | last post by:

Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then...

Career Advice

5719

Access Europe - Using VBA to create a class based on a table - Wed 1 May

by: isladogs | last post by:

The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes...

Microsoft Access / VBA

3845

Trying to create a lan-to-lan vpn between two differents networks

by: TSSRALBI | last post by:

Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in...

Networking - Hardware / Configuration

2364

transfer the data from one system to another through ip address

by: 6302768590 | last post by:

Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system

C# / C Sharp

1192

Comprehensive Guide to Website Development in Toronto: Expert Insights from BSMN Consultancy

by: bsmnconsultancy | last post by:

In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating...

General