sql sever evaluation version, i have just installed 1

[henin]

At my home computer.
Now i'm trying to connect ("sql sever management studio") but i dont know the server's name nor user name. I dont rememeber ever asked to supply any during the installation.
Bottom line- the evaluation version of sql server 2005 is installed but i cannot log in. How do i get to know my user name ? server name ? What ever i try i'm announced that the present version is not working for remote connections. I try to connect from the same very machine of the sql server. What is wrong ?
Thanks

 

[bborissov]

If SQL Server is installed on your computer, Try to connect to (localhost) with Trusted Connection.

Borislav Borissov
VFP9 SP2, SQL Server 2000/2005.
Microsoft MVP VFP

 

[henin]

Hi Borislav,
And thanks for your reply.
This is how i try to connect (and fail to do so):
1. I click: "SQL SERVER Management studio" shortcut
2. In the "SERVER TYPE" text box I leave the default: "Data base engine" as is.
3. In the "SERVER NAME" text box I write "localhost" according to your suggestion (or as i understood it)
4. In the "AUTHENTICATIONA" selection box i select "Windows Authentication"
5. I press the "connect" button and here is what i get:

connect to server

cannot connect to localhost

An error has occured while establishing connecetion to the server......sql server does not allow remote connections...error 40: could not open a connection..
Can you deal with that ? Maybe i should install again ?
Thanks.

 

[gmmastros]

For Server Name, try (local).

If that doesn't work, try:

Click Start -> Run
Type Services.msc
Click Ok

Scroll down to SQL Server. If you have a named instance installed (and you probably do), you will see something like...

SQL Server ([!]YourInstanceName[/!])

So... In the login window, you will need to specify the instance to log in to. The instance name will be:

[!]YourComputerName[/!]\[!]YourInstanceName[/!]

Put that in for Server Name in the login window.


-George

"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom

 

[henin]

Hi George
And thanks for your help.
I tried "local" and "(local)" and "localhost" but nothing worked up (this is "server name" i'm talking about). Then i selected "run" from "start" menu, wrote: "Services.msc" anf from the list i got, i searched for "SQL SERVER" and all i could find was "sever". so i typed "server" in "server name" which didnt help.
Could it be i didnt install properly the 2005 server ?
Thanks

 

[gmmastros]

Well...

Go back in to services.msc, and look for MSSQLSERVER. It could also be listed as MSSQLSERVER([!]InstanceName[/!]).

If you have an MSSQLSERVER instance, then you have SQL 2000 installed (not 2005).

If you cannot find MSSQLSERVER or SQL Server service, then you don't have the database engine installed at all.

Depending on your requirements (for wanting sql server in the first place), you may want to download and install SQL Server Express. In some cases, this is better than the evaluation version because it will never expire (like the evaluation version will). There are some limitations with SQL Express (like 4 gigabyte database and some other things). If you can tolerate the limitations, then SQL Express is a better option.

http://msdn2.microsoft.com/en-us/express/bb410792.aspx

-George

"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom

 

[henin]

Thanks again,
I preferred the "evaluation" because i need the 2005 server installed at home in order to learn "SSIS" which, as i understood, doesnt exist in the "express" version. I dont care about expiration or db limitation. All i need is few days for the SSIS learning.
Ah, almost forgotten, i didnt find any mssql nor sql server..
I'll try to install one more time.
Thanks

 

[henin]

One more thing. Trying to reinstall i'm told that IIS is not installed on my computer. I was informed that from the first time i installed 2005 but skipped it thinking it was not important.
Could that be the reason for not having server name ?

 

[mrdenny]

Sounds like all you installed was the client tools, not the actual database engine.

Run through the installer again and make sure that you select the SQL Server Database and the Integration Services check boxes on the page with the list of things to install.

IIS is only used for Reporting Services so if you aren't going to be using Reporting Services for anything don't worry about not having IIS installed.

You are correct Express Edition doesn't come with IIS.

I would plan on more than a few days to learn SSIS. It is a very complex ETL tool which takes more than a few days to learn, much less master.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

My Blog

 

[henin]

Thank you Denny,
You are right, installing IIS didnt change anything.
far as i rememeber (and i guess i'll have to try again) I checked all boxes. I had 2 choices, i opened each cohice (clicking the +) and signed every thing at the list.
I'll try again, maybe this is where i went wrong.

 

[mrdenny]

When you get to the screen, feel free to take a screenshot and stick it up on the net and point us to it and we'll let you know which check boxes to select.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

My Blog

 

[henin]

Hi Denny,
And guess what. Apparently i was installing client only..
The server installation was on the other CD...
I guess there's no other way of thanking you but with a star...
And thanks again

 

[mrdenny]

No problem.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

My Blog