How to Connect to SQL Server 2008 with VS 2010

Question

I need help.
  I use Visual studio 2010 and CSharp  try to connect to SQL Server (Developer edition install into my computer) 

string conStr = "Data Source=.\\MSSQLSERVER;Initial Catalog=AdventureWorks;Integrated Security=True";

SqlConnection conn = new SqlConnection(conStr);
conn.Open();

but it has error like below.
---------------------
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: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)
-------------------------
I also enable the  remote server connection option.

So, please help suggest me if you can.

Thank you

foonMod

Answer 1

Yes dear because i am beginner

Answer 2

Judging by his other threads today, the OP is just practicing doing various things with assemblies :)

Answer 3

why are you trying to globalize that .dll. may i know the reason?

Answer 4

hi
Dear


 Change the directory D to C: and run that command. And then check the assembly folder.... Otherwise check the .Dll file in D drive....

dear but

Library is in d: drive which i have created and how i make it globalize from c Drive....?

Answer 5

@Smart lucky: Yes. if it is a simple class library dll why r u trying to deploying it into GAC.

@Suthish: He might using that dll in some other applications like SharePoint etc.

Answer 6

If it is a simple Class Library dll then why you forcefully registering it into GAC?

Answer 7

Hi,
Change the directory D to C: and run that command.
And then check the assembly folder....

Otherwise check the .Dll file in D drive....

Answer 8

hi
 C:\WINDOWS\assembly
yes i am checking it in this folder but the assembly is added in G A C which is not shown here

d\:>c#sharp\sharedfolder\gacutil /i ClassLibrary.dll

i am adding in this way is it correct way...?
it is showing message , successfully but when i am going it the windolw\assembly folder it not showing 
can any one help me ....?

Answer 9

Hi,
Global assembly cache location is C:\WINDOWS\assembly. Here your .dll file stores.

Check it....

Answer 10

but not showing the assembly? where? which assembly you trying to add?