| Author |
Topic |
|
gerreth
Starting Member
9 Posts |
 Posted - 2009-04-28 : 19:37:11
|
| Hi,I just reinstalled sql server on my computer. (due to some unknown problems) I need it for a school project. (ado project which needs data from ms sql)The install was succesfull. Now, i load server management studio, i run the database on this machine. So, i pick windows authentication, but what for the server name? I cant remember giving server names while installing?Any help is appreciated!Thx, Gerreth |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
gerreth
Starting Member
9 Posts |
Posted - 2009-04-28 : 19:43:55
|
The field username and password are disabled. The username field contains the name of my account COMPUTER/gerreth.But i dont know what to type in the server name field  I never specified a name for the database (as far as i know) |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
Amber99
Starting Member
11 Posts |
Posted - 2009-04-28 : 19:49:01
|
| I downloaded SQL Server Studio 8 as well and the SERVER name is a unique name... so you basically have to find that out from school... everyone has a different server name... Amber. |
|
|
|
gerreth
Starting Member
9 Posts |
Posted - 2009-04-28 : 19:50:49
|
| nope, neither, 'gerreth', 'MY-COMPUTER/gerreth', 'local' or 'administrator' won't work =/ |
|
|
|
gerreth
Starting Member
9 Posts |
Posted - 2009-04-28 : 19:53:13
|
| School? I just downloaded it from microsoft. It has to work on its own, on my computer. It's all local.Is there a way to look up that name? |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2009-04-28 : 19:56:27
|
quote:
Originally posted by Amber99
I downloaded SQL Server Studio 8 as well and the SERVER name is a unique name... so you basically have to find that out from school... everyone has a different server name... Amber.
This isn't rocket science. It's simply your computer's name, which can easily be found via the hostname command in a cmd window.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Subscribe to my blog"Let's begin with the premise that everything you've done up until this point is wrong." |
|
|
|
gerreth
Starting Member
9 Posts |
Posted - 2009-04-28 : 19:56:41
|
| hostname in cmd returns MY-COMPUTER and that doesn't work either... |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2009-04-28 : 19:59:52
|
| Well what instance name did you provide in the installer? You have to use that too if you didn't keep it at the default. So it would be MY-COMPUTER\YourChosenInstanceName. If you can't remember what you typed in, then you can find this out in SQL Server Configuration Manager or by viewing the Services in Admin Tools.Also, make sure the SQL Server service is started. You can't connect to it unless it is up.By the way, you never posted the error message you are getting, so I can only assume you are getting a connectivity error.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Subscribe to my blog"Let's begin with the premise that everything you've done up until this point is wrong." |
|
|
|
gerreth
Starting Member
9 Posts |
Posted - 2009-04-28 : 20:03:39
|
The error message :  (i know i installed the dutch version, i'm dutch  TITLE: Connect to Server------------------------------Cannot connect to MY-COMPUTER\gerreth.------------------------------ADDITIONAL INFORMATION:Er is een netwerkfout of een exemplaarspecifieke fout opgetreden tijdens het maken van verbinding met SQL Server. De server is niet gevonden of is niet toegankelijk. Controleer of de exemplaarnaam correct is en of in de instellingen van SQL Server externe verbindingen zijn toegestaan. (provider: SQL-netwerkinterfaces, error: 26 - Fout bij zoeken van opgegeven server/exemplaar) (Microsoft SQL Server, Error: -1)For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=-1&LinkId=20476------------------------------BUTTONS:OK------------------------------ |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2009-04-28 : 20:06:08
|
| Is "gerreth" the name you chose for the instance? Go to Services in Admin Tools and check for the name "SQL Server". Is there one that just says "SQL Server"? Or is there one with "SQL Server (YadaYadaYada)" instead? Whatever is in between those parenthesis is your instance name. If you don't have the parenthesis, then you have just the default instance installed. On whatever service you found, what is its status?Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Subscribe to my blog"Let's begin with the premise that everything you've done up until this point is wrong." |
|
|
|
gerreth
Starting Member
9 Posts |
Posted - 2009-04-28 : 20:07:37
|
SQl server config tells me the service is running and log on as 'LocalSystem'.But that name doesnt work either  |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
gerreth
Starting Member
9 Posts |
Posted - 2009-04-28 : 20:10:34
|
| Jup, vista.But installed SP2. I thought this should fix some issues. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
gerreth
Starting Member
9 Posts |
Posted - 2009-04-28 : 20:18:55
|
| Grmblz Vista.Thx for the help! |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
server name