How to add Server name ,Visual Studio 2010

Posted by Raja_89 under Visual Studio on 8/26/2013 | Points: 10 | Views : 1905 | Status : [Member] | Replies : 4
Hai
Is it possible to view the server name after visual studio 2010 was installed then SQL Server 2005 was installed first




Responses

Posted by: Bandi on: 8/26/2013 [Member] [MVP] Platinum | Points: 25

Up
0
Down
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

Posted by: WPF_G on: 11/18/2013 [Member] Starter | Points: 25

Up
0
Down
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

Posted by: aswinialuri-19361 on: 11/19/2013 [Member] Starter | Points: 25

Up
0
Down
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

Posted by: Allemahesh on: 11/19/2013 [Member] [MVP] Silver | Points: 25

Up
0
Down
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

Login to post response