| Author |
Topic |
|
DisasterPiece
Starting Member
5 Posts |
 Posted - 2011-09-02 : 20:27:35
|
| TITLE: Connect to Server------------------------------Cannot connect to SHAREFILE.------------------------------ADDITIONAL INFORMATION:A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) (Microsoft SQL Server, Error: 53)For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=53&LinkId=20476------------------------------BUTTONS:OK------------------------------I go to youtube asking how they make a server because when I enter a name to create for the server On SQL server Management studio it get this error. I tried making a server off of SQL server configuration manager. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-09-02 : 20:57:31
|
| is your sql server service running on the server? go to services.msc ans check if its running------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
DisasterPiece
Starting Member
5 Posts |
Posted - 2011-09-02 : 21:00:15
|
| I havent made one. How do I? |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-09-02 : 21:03:26
|
| if you've installed in your machine database engine it will be created automatically.------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
DisasterPiece
Starting Member
5 Posts |
Posted - 2011-09-02 : 21:32:53
|
| My server? I havent installed a server. I thought i would just have to type in a name and it would make the server on login. Please help! |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-09-02 : 21:44:06
|
| nope. you need to first install sql server on your machine. or are you by any chance trying to connect to a server which is running in some other machine from your machine?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
DisasterPiece
Starting Member
5 Posts |
Posted - 2011-09-02 : 21:49:00
|
| I have SQL server management studio and i dont even know how to make a server. I thought the login to managment studio was the form to create the server |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-09-02 : 21:55:19
|
| nope. first clarify my doubt.is your intention creation of new server in your machine or are you trying to connect to existing instance on another machine?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
DisasterPiece
Starting Member
5 Posts |
Posted - 2011-09-02 : 22:03:47
|
| I want to make a database but dont have one. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-09-02 : 23:09:25
|
| ok then first install sql server on your machine. once done , you'll have a service running in services.msc then you can try to login using login screen.------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
|
Not understanding this.