Exforsys

Online Training

Please Help

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 ...


Go Back   Exforsys > Database > SQL Server

Register FAQ Members List Calendar Search Today's Posts Mark Forums Read
  #1 (permalink)  
Old 03-21-2006, 06:59 AM
bhv bhv is offline
Junior Member
 
Join Date: Mar 2006
Posts: 5
bhv is on a distinguished road
Question Please Help

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
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT -4. The time now is 04:18 PM.


Powered by vBulletin® Version 3.7.3
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Search Engine Friendly URLs by vBSEO 3.1.0
Copyright 2004 - 2007 Exforsys Inc. All rights reserved.