visual studio express 2012 web cannot connect to Microsoft® SQL Server® 2012 Express -

-

is there bug when connecting visual studio express 2012 web installed on windows 7 connect sql server express 2012 or 2008r2?

the error message this:

> network-related or instance-specific error occurred while > establishing connection sql server. server not found or > not accessible. verify instance name correct , > sql server name configured allow remote connections. (provider: > sql network interfaces, error: 26 - error locating server/instance > specified.)

in situation, vs connects sql if server os server os

or win7 os win7 os ?

here scenario got in environment : have 4 machines

1-win2012srv: -virtual machine -windows 2012 serversql server express 2012 visual studio express 2012 web -symantec antivirus (disabled) -firewall disabled -static ip address

2- win08r2srv: -virtual machine -windows 2008 r2 server -sql express 2008 r2 -visual studio express 2012 web -no antivirus -firewall disabled -static ip address

3- win7pc1: -real machine (pc) -windows 7 -sql express 2012 -visual studio express 2012 web -avast antivirus (removed already) -firewall disabled -dynamic ip address

4- win7pc2: -real machine (pc) -windows 7 -visual studio express 2012 web -avast antivirus (running) -firewall disabled -dynamic ip address

the result is:

> legend :)  >  > vs = visual studio express 2012 web > --> = connect (i.e. can connect sql server database) > x--> = cannot connect (i.e. cannot add database connection)

vs on win2012srv --> sql on win08r2srv

vs on win08r2srv --> sql on win2012srv

vs on win7pc1 x--> sql on win2012srv

vs on win7pc1 x--> sql on win08r2srv

vs on win7pc2 x--> sql on win2012srv

vs on win7pc2 x--> sql on win08r2srv

vs on win7pc2 ---> sql on win7pc1

thanks

hasan

i appreciate valuable inputs. hair fall because of problem :(

tom, thanks, have gone through article weeks ago, no luck :)

the summary:

i have made work around resolve problem. have created new virtual server on second physical dell server (with sql express 2012).

the problem seems network issue on hyper-v virtual switch!!

more details:

as described previously, vs connects sql service within same hyper-v only, although configuration right. pc within domain, can connect sql server on first hyper-v service using odbc or connection string file (.udl), not through “visual studio express 2012 web” !!!!!!!!!

now, can connect pc (using visual studio express 2012 web) sql server express 2012 on second hyper-v .

i have made 4 virtual service on first hyperv , 4 on second hyperv. same result:

  • •vs on pc’s can connect sql server on second hyperv•vs on pc’s can not connect sql server on first hyperv

  • •vs on virtual servers on first hyperv can connect sql server on same physical machine/same hyperv .

  • •vs on virtual servers on first hyperv can connect sql server on second physical machine/second hyperv .

  • •vs on virtual servers on second hyperv can connect sql server on pc’s or on second hyperv/same physical machine.

  • •vs on virtual servers on second hyperv can not connect sql servers on first hyperv

long story last more 1 month :(


Comments

Post a Comment

Popular posts from this blog

java - WrongTypeOfReturnValue exception thrown when unit testing using mockito -

-
my test list<person> mylist; @test public void testisvalidperson() { mylist = new arraylist<person>(); mylist.add(new person("tom")); when(persondao.get(person)).thenreturn(mylist); when((persondao.get(person)).isempty()).thenreturn(false);//------exception thrown boolean result = service.isvalid("tom"); assertfalse(result); } method tested: public boolean isvalid(string person){ persondao = new persondao(); person personobj = new person(person); return (persondao.get(person).isempty())?false : true; } exception thrown: org.mockito.exceptions.misusing.wrongtypeofreturnvalue: boolean cannot returned get() get() should return list *** if you're unsure why you're getting above error read on. due nature of syntax above problem might occur because: 1. exception *might* occur in wrongly written multi-threaded tests. please refer mockito faq on limitations of concurrency testing. 2. sp
Read more

php - Magento - Deleted Base url key -

-
i working on cleaning url: http://mydomain.com/shop/shop/deals i going through settings in configuration tab in admin panel on magento , change secure , unsecure base urls remove first base url "shop" web page read: http://mydomain.com/shop/deals so changed unsecure base urls mydomain.com/shop mydomain.com , secure 12.345.67.89/shop 12.345.67.89. wrong thing do. i cannot reload page or admin console. how access these files through ftp , change correctly there?? when make changes in admin panel changes made in database not in file. have make changes in database. 1.go database , select core_config_data table under table find web/unsecure/base_url , web/secure/base_url . make changes here. don't forget clear cache in var/cache folder
Read more

android - How to disable Button if EditText is empty ? -

-
i have edittext , button in application. when button clicked,the text entered in edittext added listview. i want disable button if edittext empty.how ? this code button click imagebutton imb=(imagebutton)findviewbyid(r.id.btn_send); imb.setonclicklistener(new onclicklistener() { @override public void onclick(view arg0) { edittext et = (edittext)findviewbyid(r.id.edittext1); string str = et.gettext().tostring(); web1.add(str); toast.maketext(shoutsingleprogram.this, "you entered...."+str, toast.length_short).show(); adapter1.notifydatasetchanged(); et.settext(""); } }); } how can ? edittext1.addtextchangedlistener(new textwatcher() { @override public void ontextchanged(charsequence s, int start, int before, in
Read more