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.
| Author |
Topic |
|
logo711
Starting Member
2 Posts |
 Posted - 2006-02-01 : 20:33:49
|
| im trying to gain some experience using mssql. in my system tray there is a sql server service manager. my question is this...what do i use to interface with sql server? ive seen messages referencing 'enterprise manager', but i cant find it or this thing called 'query analyzer'.im running windows 2000 professional. i downloaded and installed a program called 'database fishing tool' which seems to do what i need but, im asked for a username and password. since ive never connected to the sql server i dont know this info.ive scoured the web for anything to help me with this, but cant find any info for what seems would be the most fundamental...please help. thank you. |
|
|
Srinika
Master Smack Fu Yak Hacker
1378 Posts |
Posted - 2006-02-01 : 20:43:51
|
| U installed SQL server ?Did u Installed Client tools as Enterprise manager / Query Analyzer ?Go to Start --> Programs --> MS SQL Server .... and check for the Enterprise manager / Query Analyzer If u couldn't c it, Install SQL server Client componenets |
 |
|
|
logo711
Starting Member
2 Posts |
Posted - 2006-02-01 : 20:49:40
|
| cant say that i 'installed' sql server per se...i dont have a sql server install disk or anything like that, but sql server is installed on my system obviously (right? i can start and stop the sql server service manager).the client tools are not installed. there is no ms sql server folder in my programs menu. do i install the tools from the 'windows components wizard'? |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-02-01 : 21:00:02
|
| You probably have MSDE installed which doesn't come with client tools. I'd suggest purchasing the developer edition (for 49 bucks I believe). This will give you everything you need. With MSDE, you'd have to use command line tools which is not easy for a newbie.Tara Kizeraka tduggan |
|
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2006-02-01 : 21:00:56
|
| >> i dont have a sql server install diskYou have to obtain that disk somehow to install the Client Tools----------------------------------'KH' |
|
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2006-02-01 : 21:05:12
|
| The username and password will be provided by your DBA or if you've locally installed the sql server, then you should create the user using the tool you have or enterprise manager or query analyzer. If you forgot to install EM and QA, install the client tools or check your third party tool for creation of users (I'm not familiar with the tool you mentioned though)HTH--------------------keeping it simple... |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-02-01 : 21:07:01
|
| The Windows Component wizard will not install what you need.Tara Kizeraka tduggan |
|
|
|
|
|
|
ultimate newb question