A question about connecting to SQL Server.?

Question

Just 10 minutes ago, I read an article which explained about various ways to connect to SQL Server. There, the author mentioned that if I type .(single dot), local or localhost, I can connect to my default instance of SQL server. However, I tried this in 2 computers available in my work place. It didn't work in the way it was supposed to. Can anybody explain me which configuration of SQL server might cause this issue?

Here's the link:

http://blog.sqlauthority.com/2012/09/07/sql-server-fun-post-connecting-same-sql-server-using-different-methods/

Many thanks!!!

Answer 1

Hi there, its working fine for me when i tried. i hope you are already familiar that you need to use sql service instance with local/localhost. Eg. localhost\sqlexpress...it will connect. Instaed now hes asking to try with .\sqlexpress. He says its not needed to use local/localhost like that. Simply that dot should work. Still if you are not able to connect then check for the protocols whether named pipes,Shared Memory and TCP/IP are enabled? These three should be enabled. You can check this from SQlServer Configuration manager and selecting the network configuration on the left side tree. You can then enable the protocols from right side. Then try. Should be fine.

Answer 2

you need to use the suggestion sources window in seen Studio to create a wisdom source that includes the relationship string and you'll be able to apply that comparable window to make optimistic that it works. The C# corner cyber web website has many functional and relevnat articles; my article "Database table replace in a DataGridView devoid of Writing Code" i wish is a delightful, usefull creation. additionally word that a trouble-free reason for the subject you're encountering is that frequently the sq. Server server isn't began. visit the sq. Server Configuration supervisor to envision it and you'll be able to start up it from there if needed.

Answer 3

You may have run into issues because the instance is not local. If the instance is local, you can use the dot. If it isn t, you can t. Here s an article that goes a little more in depth.