How to add Server name ,Visual Studio 2010

Hi Raja,

I think you are asking about Server name which is required to connect to SQL Server from Visual Studio...
I have already posted the some sort of solution in previous posts...

Do you have SSMS(SQL Server Management Studio)? If YES then you can run the following query
Any way post the output of following query.. then I will tell you the connection string

SELECT @@VERSION, @@SERVERNAME, @@SERVICENAME

GO

SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition')

GO

NOTE: Refer this link to resolve your issue....
http://blog.sqlauthority.com/2007/04/23/sql-server-fix-error-40-could-not-open-a-connection-to-sql-server/

Mark This Response as Answer
--
Chandu
http://www.dotnetfunda.com/images/dnfmvp.gif

Raja_89, if this helps please login to Mark As Answer. | Alert Moderator

If you want to know more about Visual Studio you can download here a FREE eBook : http://www.tekkiebooks.com/campaign/freebook/dotnetfunda_02
LEARN step by step how to install Visual Studio 2012 on Windows 8. Use it as a quick reference or a standard how to document for your development team. Simplify your work and gain time!

Good luck in creating amazing applications!

Raja_89, if this helps please login to Mark As Answer. | Alert Moderator

hi Raja,
http://www.dotnetfunda.com/interviews/show/6859/how-can-you-detect-the-servername
please refer this link it might be helpful to you

Mark as Answer if it helps you
Thanks&Regards
Aswini Aluri

Raja_89, if this helps please login to Mark As Answer. | Alert Moderator

You can see the below link:-

http://msdn.microsoft.com/en-us/library/vstudio/edfcxas2.aspx

Happy Coding,
If it helps you or directs U towards the solution, MARK IT AS ANSWER

Raja_89, if this helps please login to Mark As Answer. | Alert Moderator