sql - Cannot connect to database using localhost\sqlserver -


i know should aware of such phrases of sudden connections localhost\sqlexpress stopped working. .\sqlexpress , (local)\sqlexpress work, wouldn't big deal if weren't fact working on team project connection strings defined in former format. , have hard time accept shouldn't work anymore spent several hours analysing , reinstalling several sql server versions no avail. (and on way breaking db projects in vs2010 needed reinstall well...).

but here details. mentioned couldn't connect localhost\sqlexpress .\sqlexpress. same symptoms using sql server manager, , connection strings deployment , running wcf services. funnily enough resolving default instance localhost works.

first things first, yes sql server running , sure enabled tcp/ip , set port fixed 1433 although works on colleagues machine tcp/ip disabled. (somewhere along way read localhost can resolved using shared memory when using native sql client guess what's happening on system.)

the setup 1 sql server express 2008 r2 instance , vs2010 on windows 7 professional.

starting sql express errorlog says:

server listening on [ 'any' <ipv6> 1433]. server listening on [ 'any' <ipv4> 1433].

netstat says (excerpt):

tcp    0.0.0.0:1433           machinenename:0             listening tcp    [::]:1433              machinenename:0             listening

i note absence of 127.0.0.1:1433 , udp on port 1433

in order diagnose problem use sqlcmd find out transport used:

1. localhost\sqlexpress

sqlcmd -slocalhost\sqlexpress  -> shared memory sqlcmd -stcp:localhost\sqlexpress ->  sql server network interfaces: error locating server/instance specified

cannot connect localhost\sqlexpress sql server management studio if specify shared memory protocol

2. localhost

sqlcmd -slocalhost -> tcp sqlcmd -stcp:localhost -> tcp

can connect localhost sql server management studio

3. (local)\sqlexpress

sqlcmd -s(local)\sqlexpress  -> shared memory sqlcmd -stcp:(local)\sqlexpress  ->  sql server network interfaces: error locating server/instance specified

can connect (local)\sqlexpress sql server management studio

so lost here. highly appreciated.

in ms sql, go configuration tools -> sql server configuration manager select sql server network configuration -> select protocol in right side window enable tcp/ip , restart services in services.msc try connect localhost\sqlexpress


Comments

Post a Comment

Popular posts from this blog

c++ - Is it possible to compile a VST on linux? -

for class project i'm attempting write vst plugin backed cuda. current cuda workflow on linux box, i'd prefer compile , link there. according wikipedia , should possible (i couldn't find steinberg documentation relevant linux) can't find makefile or instructions on how build if aren't using xcode or visual studio. i'm vst 3 sdk doesn't support linux. when try compile plugin under linux, error: ./base/source/fatomic.cpp:39:30: fatal error: libkern/osatomic.h: no such file or directory this issue caused following code in "vst3 sdk/base/source/fatomic.cpp" #if mac #include <libkern/osatomic.h> #if mac_os_x_version_min_required > mac_os_x_version_10_4 #define native_atomic_type (volatile int32_t*) #else #define native_atomic_type (int32_t*) #endif #elif windows #include <windows.h> #endif but hope compiling under linux work vst sdk 2.4. reading. jvstwrapper seems run on lin...
Read more

java - Output of Eclipse is rubbish -

i want write program in eclipse language different english. when display output using system.out program, displays output correctly in console editor. when accept input console , output it, output rubbish. how can solve it. many thnaks i'm not sure if problem, have character encoding problem. make sure you're using unicode, utf-8. you can read more @ official docs converting non-unicode text .
Read more

jquery - Confused with JSON data and normal data in Django ajax request -

i read json internet still have not got grasp of it. reading article http://webcloud.se/log/ajax-in-django-with-jquery/ i not understood first part function using json def xhr_test(request, format): if request.is_ajax(): if format == 'xml': mimetype = 'application/xml' if format == 'json': mimetype = 'application/javascript' data = serializers.serialize(format, examplemodel.objects.all()) return httpresponse(data,mimetype) # if want prevent non xhr calls else: return httpresponse(status=400) my main problems are from function getting format variable does format json mean data given function json or data recived json can give me simple example ouput of function data = serializers.serialize(format, examplemodel.objects.all()) how use data when response in jquery function if don't use json in above function how input , response chnage thanks ...
Read more