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 |
|
princess82
Starting Member
10 Posts |
 Posted - 2006-07-16 : 09:00:44
|
| i am new to this sql server..i have bought a cd to install sql server...when i finish installing..it said..cannot connect to the server..do i need any internet connection? since i'm using my pc at home..no connection to the internet..how can i use it?is there any way to get the server? from what i understand that server can get from the cd i bought...is it so? |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2006-07-16 : 09:45:31
|
| You don't need an interet connection.Which version of sql server? v2000 or v2005.Check that the sql server service is started.How are you trying to connect? Use query analyser or management studio depending on the version.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
princess82
Starting Member
10 Posts |
Posted - 2006-07-16 : 10:19:00
|
| i'm using version 2000..are u sure i don't need any connection to any thing?is it the server is already in there? |
|
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2006-07-16 : 10:22:45
|
| In programs go to sql server and load service manager.That will tell you if the sql server service is running.If it is then load query analyser.It will ask for a connection - type in (default) or . for the sql server (assuming you loaded a default instance).==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
|
princess82
Starting Member
10 Posts |
Posted - 2006-07-16 : 10:32:14
|
| still cannot connect to the server..is it because during my installation, when it ask the server name i put my name..do i have to reinstall back and change the server name? do you mean the default server name is . |
|
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2006-07-16 : 10:35:58
|
| Type in the same name as you see inservice manager.You may have insalled a named instance rather than the deault instance.That will be.\<myname> or<machinename>\<myname>as the server name==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
|
princess82
Starting Member
10 Posts |
Posted - 2006-07-16 : 10:45:04
|
| .\<myname>you mean that is the server name? so should i write exactly like that? myname- do i have to write my name(ex:princess)? or just write myname |
|
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2006-07-16 : 10:47:29
|
| Your name - whatever the instance name is.Have a look at the service manager and type in exactly what you see there.You could also load enterprise manager, register a server and see if it can detect your server name.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
|
princess82
Starting Member
10 Posts |
Posted - 2006-07-16 : 11:04:58
|
| thank u nr..i'll try.. |
|
|
|
|
|
|
how to get the server?