This is a discussion on Please Help within the SQL Server forums, part of the Database category; hi, i am new to SQL server 2005. whenever i tried to create database through SQL sever Management studio, it ...
|
|||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
|
|||
|
hi, i am new to SQL server 2005. whenever i tried to
create database through SQL sever Management studio, it asked me: server type: (here i select Database Engine) server Name : ( ??????????) Authentication : (Windows Authentiction is by default, another is SQL server Authentication, which one should i select?????????)... username: password: username & p/w acivated only when i select SQL server authentication. i don't know what to do with server name . if i entered Administrator (which is my computer's name), it gives following error: cannot connect to Administrator An error has occured while establishing a connection to the server. When conencting to SQL servr 2005, this failure may be caused by the fact that under the default settings SQL server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - could not open a connection to SQL server) (Microsoft SQL server err: 123) i had also tried MSSQLSERVER which is default server name, ".", "LOCAL" as suggested, but same error occurs. i don't know what to do with server name . plsssssssssssssss help me |