Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 Hello World: SQL Server + ASP.NET

Author  Topic 

Desmag
Starting Member

18 Posts

Posted - 2006-03-15 : 12:43:24
Hi everybody,

This is propably very silly question...

I've used SQL Server for sometime now, but always through tools supplied by my hosts (my Little Admin, SQL Server Web Admin).

I always wanted to try running the real thing, so I've installed SQL Server 2K developer edition on my machine. I also have IIS and .NET framework running.

What would be the next step to see those 3 components in action? I have noticed Northwind database in the Enterprise Manager. How do I make the connection?

I have the SQL Server Service Manager running fine, but when I open Query Analyzer it comes up with the window "Connect to SQL Server" and this little dropdown, where you can choose the server is actually empty. What do I do?


Thank you all for your pointers.

Srinika
Master Smack Fu Yak Hacker

1378 Posts

Posted - 2006-03-15 : 12:55:59
U may find the following site useful (For ASP.Net / ADO.Net / Connecting to SQL Server ...)
WWW.W3schools.com

Go thru the Books OnLine (The help feature of MS SQL server) - to findout what u need to do to get connected to the Server thru' the Query Analyzer / Enterprise Manager
Go to Top of Page

Jim77
Constraint Violating Yak Guru

440 Posts

Posted - 2006-03-16 : 06:59:50
click the three little ... buttons next to the select server drop down box in Query analyser to locate your local server.That normally does the trick for me
Go to Top of Page
   

- Advertisement -