c#sql-serversql-server-2008sql-server-2008-express
SQL Server 2008 Express remote connection
I have a connection string to connect to sql server express 2008
string ConnectionString = @"Server=.\SQLEXPRESS,1433; Network Library=DBMSSOCN; Initial Catalog=mydb; user id=sa; password=12345qwerty";
this works normally but when i want to remote connect using this connection string :
string ConnectionString = @"Server=119.225.128.211\SQLEXPRESS,1433; Network Library=DBMSSOCN; Initial Catalog=mydb; user id=sa; password=12345qwerty";
the connection doesn't work and gives this error :
I followed this article http://blogs.msdn.com/b/sqlexpress/archive/2005/05/05/415084.aspx and my firewall is off
Why can't I connect to SQL Server Express remotely?
Solution
This SO article may help you. Remote Connections are not configured by default: Remote connection to SQL Server Express fails
- When did C allow casting constants and variables to struct for assignment?
- Why in C can I initialize more values than the size of an array?
- What Values of Variables x and y Will Produce Incorrect Results When Testing for Overflow After Subtraction of x-y in the Following Program?
- How to write a general-type queue library in c?
- Which gcc and g++ version support which standard of c and c++?
- How to dereference a member in a struct whose definition is not visible?
- How to name a type in a meaningful way?
- In this case, how to achieve modularity and information hiding at the same time?
- What are Vectors and < > in C?
- Using c to create a file and write+read to it, what went wrong?
- Why does 1.0/100.0 == 0.1/10.0 give True?
- How to organize the receive msg and user current input in C network such that it's clean
- Using inclusive scan syntax in OpenMP in the C language
- Unable to understand context in book "OOP in C" by Axel Schreiner
- variable-length array in struct with TI compiler in C (socket programming)
- A faster way to test 32bpp DDBs for a valid Alpha channel
- How can I compile the zephyr example-application as a freestanding application?
- Why does my forked process sometimes overwrite data in a file?
- _Generic in C needs typecasting?
- Declaring/defining an unused variable changes the output from an unrelated variable
- How to use gdb to explore the stack/heap?
- How can I read an input string of unknown length?
- Confused by difference between expression inside if and expression outside if
- Fast Arc Cos algorithm?
- Discrepancy of `unsigned long` size between llvm and gcc in riscv32
- GCC (C) - error: 'x' redeclared as different kind of symbol
- Why does GCC’s static analyser falsely warn that a pointer to an allocated memory block itself stored in an allocated memory block may leak?
- c language gcc compiler *.i file #3 "" 2 what is this?
- How to make clang compile to llvm IR
- Hashtable implementation in C