December 5, 2009 at 7:37 am
Hi... everyone I am really new in sql server 2000. I only install the client tools. I used sql server 2000 standard edition in windows xp service pack 3. I opened the enterprise manager and create new registration using the sql server authentication asking for log in and password. I wasn't able to connect. I didn't know what is the log in and password because when I installed the sql server client tools only, there wasn't a option for the login and password. I wanted only to connect on a local server.
Kindly enlightened me on this one. Thank you very much 😀
December 5, 2009 at 9:05 am
If you only installed the client tools, there won't be a local server. It may be the default that SQL brings up, it's assuming that you installed a local server, but it's just a default that in this case won't work at all. To connect to an existing database server, ask the server admin for the username and password.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 5, 2009 at 9:17 am
There is no server. I am working on my own computer. I want to use sql server as my database in my school project. .. I am really confuse on the sql server....
Thanks for your reply...
December 5, 2009 at 9:40 am
If you want your own server then you need to install the server components of SQL as well as the client. The client tools are just interfaces to work with a server.
Not all versions will install on all operating systems. What version of SQL do you have? Also, why SQL 2000? It's 9 years old. You can download SQL Express (which is a free version both of the server component and the client tools) from the microsoft web sire.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 5, 2009 at 9:46 am
It is the version the school is using. SQL server 2000. My version of sql is SQL SERVER STANDARD edition.
December 5, 2009 at 9:48 am
That should install on Windows XP, vista and all other desktop versions of windows. You just need to install the server components. When you get to the feature selection, make sure that the database engine is selected.
Otherwise, ask your teacher for help. That's what they are there for.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 5, 2009 at 10:06 am
Thank you very much for your patience and replies Mr. Gail.. I hope my teacher could read my email as soon as possible...
Thanks again ... Have a nice day.
December 7, 2009 at 12:52 pm
So, are you still having an issue connecting? Did you install the database engine server component? That is the only way you will be able to connect locally using the SQL tools.
Joie Andrew
"Since 1982"
December 16, 2009 at 2:21 pm
Gail, it may be a little late now, but for what it's worth, I was unable to install 2000 standard on both a desktop and a laptop running XP pro. It's been a year or so, but I remember getting an error message saying that the OS was not compatible, and I did not look into it after that, since I ended up getting a copy of 2008 standard, which did install on XP. It might have been something easily overcome. Is there a way to make 2008 behave like 2000? For example, not allow CTE's, or any new key words not available in 2000?
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
December 17, 2009 at 12:33 am
Checked the hardware requirements for SQL 2000 and you're right. Server OS only. Must have been one of the changes in SQL 2005.
SQL 2008 with compat mode 80 will help with some stuff, but I know some of the newer features can be used (some of the DMVs for example). If it's absolutely essential that it's SQL 2000, developer edition (which does install on client OS) or the enterprose eval will work (if anyone can find the enterprise eval)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 10 posts - 1 through 10 (of 10 total)
You must be logged in to reply to this topic. Login to reply