Connection in SQLserver 2008 R2

Question

I installed the SQL server 2008 R2.

after that shall i check anything  before connceting?

I installed it as a Default Instance MSSQLSERVER 

and MixedMode

Specify SQLserver Administrator is DMA\C.Mujeeb.Rahman(C.Mujeeb.Rahman)

and Password is 12345

My Computer IP 172.12.128.91

Computer Name is HQCSSTPM0076D

Full computer name is HQCSSTPM0076D.dma.gov.local

 Now i want to connect . How can i specifiy  the server name and other things

Plz tell me

                Server Name --------------------?

                Windows Authentication 

 

 

 

---

AK

Answer 1

refer http://sqlserver-help.com/2011/06/19/help-whats-my-sql-server-name/
I have given some example there.

---

Balmukund Lakhani | Please mark solved if I've answered your question, vote for it as helpful to help other user's find a solution quicker
--------------------------------------------------------------------------------
This posting is provided "AS IS" with no warranties, and confers no rights.
--------------------------------------------------------------------------------
My Blog | Team Blog | @Twitter

Answer 2

Server Name for Default Instance is your SYSTEM NAME

---

Thanks & Regards, Leela Prasad

Answer 3

Hi Mujeeb,

If you connecting via sql server management studio,

go to run, type ssms.exe  ---> this will open sql server management studio.

Now click on connect (on left hand side -Object Explorer) which will pop up a new window. In that select server type as Database Engine, Server name as HQCSSTPM0076D, Authentication - Windows Authentication

And assuming other things being perfect you will be able to connect.

Hope this helps!!

---

Regards, Vishal Srivastava

Answer 4

Hi ,

In addition ,if you are connectiong to SQL Server by some developed application, you could connection string to connect to SQL Server like

Data Source=HQCSSTPM0076D\MSSQLSERVER ;Initial Catalog=myDataBase;User Id=DMA\C.Mujeeb.Rahman;Password=12345;

Please refer to this link for more information.

Before connecting ,please follow the basic steps to check :

a. Check the server on which SQL Server is running can be accessible. You can use ping command to test that. For instance, ping <computer_name> or ping <IP_address>. The ping command may be block by the firewall, make sure ICMP is enabled in the firewall. More info, check: http://technet.microsoft.com/en-us/library/cc739791%28v=ws.10%29.aspx#BKMK_4.
b. Choose appropriate protocol
c. Configure Windows firewall accordingly based on what protocol you have chosen to use. For detailed information about how to configure Windows Firewall to allow SQL Server, please check http://msdn.microsoft.com/en-us/library/cc646023.aspx.
d. Enable SQL Server Browser Services
 You need to enable SQL Server Browser Services if the following are both true:
1. SQL Server is not listening on default 1433 port or not use default pipe name \\.\pipe\sql\query;
2. The corresponding TCP port or pipe name is not specified in the connection string (such as Srv1\SQL2008, 1500).
By the way, if you have enabled SQL Server Browser Services, you still need to open UDP 1434 port which is used by Browser Services in the Windows firewall. 

Hope this helps. 

---

Best Regards,
Peja

Please remember to click "Mark as Answer" on the post that helps you, and to click "Unmark as Answer" if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread.