Cannot connect to (server name) after sql server 2008 installation
-
hi ,
I am new to SQL Server, I just tried to install sql server in my laptop running in WINDOWS 8.1.
I have installed from below link.
http://www.microsoft.com/en-us/download/details.aspx?id=1695
After the installation while first time to connect it,it says an error "Cant connect to SERVER NAME".
I have to install any other supporting files ? I need to do any other things?
TITLE: Connect to Server
------------------------------
Cannot connect to NEW.
------------------------------
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)
-
Dear Lakshmi,
In the server name textbox write "localhost" or try with a simple "." (Without the double quotes :-)) as the servername and use the existing username and password. Probably you will have sa password in case you have installed sql server with windows authentication then you just need to enter the servername and select Authentication as windows Authentication and click on OK.
Hope it helps.
Regards
Shafat Husain
Regards,
Shafat Husain
🙂
And Your Lord Never Forgets...!! (64:19 -- Quran) -
When you have installed your SQL Server instance , I hope that you are kept the name of your instance as you have to use it in the Server name box.
It seems that you have a named pipe problem according the error message ( if my remembrance is good , it is the default choice ). If your SQL Server is installed on your own laptop, you may use the connection form to get access to information not provided in this connection form by clicking on the 4th button ( at the right side ) labeled "Options>>".
But before the use of this button , I would suggest to click on the little arrow at the right end of the Server name ComboBox and select the last choice ( <Brows for more...> ). After some seconds , you will see the correct name of your local instance ( I suppose that you have only one local instance ). Select it and try to connect.
You may change the network protocol by clicking on the button labeled "Options>>" . You will arrive on the Options tab and for the network protocol "Shared Memory" which avoids some problems with Named Pipes protocol which is the "default" protocol . Be careful , you cannot used Shared Memory to connect to an instance which is not local.
You should try to use the SQL Server Configuration Manager to verify the network protocols which are enabled and whether your instance is started.
Don't hesitate to post again for more help or explanation.
-
1.Confirm that the SQL Server Database Engine is running in SQL Server Configuration Manager.
2.Make sure that you have enabled protocols properly in SQL Server Configuration Manager.
3. If you are connecting remote SQL Server instance, make sure that you open TCP port and UDP port in firewall.
4.Make sure your connection string is correct.
More information in the following blog.
How to Troubleshoot Connecting to the SQL Server Database Engine
-
There's some good advice in here.
Did you ever solve this problem?
Watch my free SQL Server Tutorials at:
http://MidnightDBA.com
Blog Author of:
DBA Rant – http://www.MidnightDBA.com/DBARantMinion Maintenance is FREE:
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply