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 |
|
kaelinskytower
Starting Member
5 Posts |
 Posted - 2010-11-29 : 05:09:07
|
| I have looked through microsofts material so that I can find out which server I should connect to... They seem to have information for 2005 and 2000, but not for 2008. Is there a server name I can enter and it will find? or does anyone have a link to some information?Thanks. |
|
|
nigelrivett
Master Smack Fu Yak Hacker
3385 Posts |
Posted - 2010-11-29 : 05:14:17
|
| Not sure whathe connection is.Where are you connecting from?Why do you not know the name of the serverit will be <machine name>\<instance name> for a named instance<machine name> for a default instance.Unless you are aliasing - which I doubt otherwise you would know the name.Or are you asking which version you should install? Probably v2008.==========================================Cursors are useful if you don't know sql.SSIS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
kaelinskytower
Starting Member
5 Posts |
Posted - 2010-11-29 : 05:18:03
|
| it asks for a server type, server name, authentication, username, and password. I don't know the name of the server because I am just starting and I am not even sure what server it is refering to. I dont even know why I need a server to create a database. I dont understand why I can't just create a database and then link it to a server later ( I am assuming that is why it wants a server.) |
|
|
|
pk_bohra
Master Smack Fu Yak Hacker
1182 Posts |
Posted - 2010-11-29 : 05:23:58
|
quote:
Originally posted by kaelinskytower
it asks for a server type, server name, authentication, username, and password. I don't know the name of the server because I am just starting and I am not even sure what server it is refering to. I dont even know why I need a server to create a database. I dont understand why I can't just create a database and then link it to a server later ( I am assuming that is why it wants a server.)
Not only in SQL, i think in all other RDBMS , database can only be created inside the server and not outside the server.Why don't you check with network/ database administrator the name of the server you can use. |
|
|
|
kaelinskytower
Starting Member
5 Posts |
Posted - 2010-11-29 : 05:29:58
|
| I am on my couch in my underwear. I am the network/database administrator. I am trying to learn how to do this. (not sarcastic and no mean tone in my voice). Can I just use my laptop for this purpose (as a short term fix)? If so, do I need to do anything special? I tried my pc's name and that did not work O.o :) |
|
|
|
nigelrivett
Master Smack Fu Yak Hacker
3385 Posts |
Posted - 2010-11-29 : 05:34:21
|
| A database is only meaningful as part of a database server.With sql server the database is held within (at least two files) one for the data and one for the log. To interpret the data in those files you need to send requests via the server.You can install sql server on your laptop then create and use a database there. Later you can copy (backup and restore) that database to another server.Note - with things like access it looks like you are just creating a database but you actually have the database server as well to interpret the data and commands.==========================================Cursors are useful if you don't know sql.SSIS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
|
|
|
|
|
|
server connection