SQL Question: Workstation vs server

[aaf6701]

I have been assigned a project of researching data on a remote hosted database. We don't have a portal to the db so I want to recreate a backup test environment locally to review data, and run crystal reports. I was able to get the hosting site to make a backup and I need to load it locally. I only have a budget for 1 massive workstation. I had tech support install sql 2000 on this workstation to be able to restore the database onto it. Does this sound reasonable?
Thanks,
Alan

 

[ptheriault]

did you purchase developer edition of SQL server?
What is the OS on your workstation? You shouldn't have any problems with that approach.

- Paul
- If at first you don't succeed, find out if the loser gets anything.

 

[aaf6701]

Paul,

I'm not sure what edition was purchased. I told the purchasing dept what I was looking to do. The Workstation is Windows XP, PRECISION 690 MT 2XCORE X/2X2GHZ 500GB 4GB WINXP DVD/RW. I'm confused about the terminology, wouldn't I be treating the workstation as the server?
Thanks,
Alan

 

[gmmastros]

Windows XP cannot run all version of SQL Server. Take a look here to determine the versions of sql server that you can run on Windows XP.

http://www.microsoft.com/sql/prodinfo/previousversions/system-requirements.mspx

-George

Strong and bitter words indicate a weak cause. - Fortune cookie wisdom

 

[ptheriault]

yes, you will be treating the workstation like a server. but...The only full version of SQL Server you can put on Windows XP is Developer Edition. It will give you all the funtionality of Enterprise Edition. MSDE will also install on a workstation but it has limits. Like the db can only be 2 gb max and it doesn't support SQL Server Agent. Besides developer edition of SQL will cost you around $50.00 (US) That is much cheaper that what other edition will cost you.
That workstation can more than handle the load of one person running some crystal reports. I've installed SQL server on less.

- Paul
- If at first you don't succeed, find out if the loser gets anything.

 

[aaf6701]

Where do I look on the workstation to find what version they installed?

Thanks for all of your help!
Alan

 

[ptheriault]

you can run

SELECT @@version

From Query Analyzer

- Paul
- If at first you don't succeed, find out if the loser gets anything.

 

[aaf6701]

Paul,

When I go to sql analyser, it's asking me to log into a server, should I have done something first? This may be getting ugly....

 

[ptheriault]

Have you been set up with a user/password.
Are you local admin on the server?
Try NT Authentication if you haven't been provided any login information.

- Paul
- If at first you don't succeed, find out if the loser gets anything.

 

[aaf6701]

I have been set up with a user/password to workstation as well as given admin rights to the workstation, so yes, I'm a local admin on the workstation. But when SQL analyzer asks for me to log into server, do they want the workstation ip address? Is it looking for 1 of the 4 drives? I have not established that the workstation should act like a server.

 

[ptheriault]

If you are running QA from you local PC.
click
start -> programs -> Microsoft SQL Server -> Query Analyzer.

When the program opens. Enter the name of the server instance in the SQL Server window. (if it a default instance just put the server name. If it is a name instance you will need to put server name\instance name )
Click on the windows authentication radio butten and click ok.

If you are on the PC that has SQL Server installed on it.
start -> programs -> Microsoft SQL Server -> Query Analyzer.
in the server name box you can just type local. Then select windows authentication.

- Paul
- If at first you don't succeed, find out if the loser gets anything.

 

[aaf6701]

Paul,

You have been so great helping me. I typed in local in the server name box and it looked like it was connected, but then an error appeared, "cannot find server or access denied"

I think I'm getting closer to the solution, but I feel I'm wasting your time. I'm going to get a book over the weekend and work on this. I'm new to this job and I'm trying to impress my boss by getting this set up by myself, but I may be a little bit over my head. Once the environment is all set up, I should be fine, but it's painful getting there.

 

[ptheriault]

No problem, We are all here to help. A book would be help. Don't forget about Books on-line (BOL) They should have been installed on the PC.

Start -> programs -> Microsoft SQL Server -> Books online

You can also get help at.

http://www.microsoft.com/technet/prodtechnol/sql/2000/default.mspx

You can get the SQL instance name from the services menu too. If you have a named instance installed there will be service name like.
SQL Server (Instance name)

Good Luck.



- Paul
- If at first you don't succeed, find out if the loser gets anything.