StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
text
Body
copied!<p><strong>UPDATED:</strong></p> <p><strong>FOR MIGRATING BETWEEN SQL CE AND SQL SERVER: Please take a look at this instruction <a href="http://erikej.blogspot.com/2012/02/migrating-databases-between-sql-server.html?utm_source=feedburner&utm_medium=feed&utm_campaign=Feed%3a%20ErikejBlogsAboutSqlCompactnetAndRelatedStuff%20%28Everything%20SQL%20Server%20Compact%29&utm_content=Google%20Reader" rel="nofollow">here</a>.</strong></p> <p>You should follow these steps:</p> <p><strong>1- Set the virtual machine to have a physical IP address.</strong></p> <p>For configuring network on Microsoft Virtual PC: <a href="http://support.microsoft.com/kb/833134" rel="nofollow">http://support.microsoft.com/kb/833134</a></p> <p><strong>2- Be sure that you can see the VM with a static IP address.</strong> (ping is a good idea for checking that, but don't forget to turn off the firewall on the target machine, I mean the machine you wanna ping. There is no need for the server to see the client, so check that your client (in this case your VM) can ping the server IP address like <code>"ping 192.168.10.1 -t"</code>)</p> <p><strong>3- Use Configuration Manager (All Programs\Microsoft SQL Server\Configuration Tools) and set SQL port and visibility over network.</strong></p> <p>Reference: <a href="http://msdn.microsoft.com/en-us/library/ms189083(v=sql.105).aspx" rel="nofollow">http://msdn.microsoft.com/en-us/library/ms189083(v=sql.105).aspx</a></p> <p><strong>4- Restart the SQL server.</strong></p> <p><strong>5- Be sure that <code>"SQL Server Browser"</code> service is started.</strong> (incase you wanna use the instance name to access the SQL server)</p> <p><strong>6- Config the firewall on the host machine (machine that has SQL engine) and add the port you specified in the Configuration Manager to TCP Inbound rules.</strong></p> <p>Take a look at here: <a href="http://www.tavislovell.com/post/How-to-configure-Windows-Firewall-to-allow-access-to-SQL-Server.aspx" rel="nofollow">http://www.tavislovell.com/post/How-to-configure-Windows-Firewall-to-allow-access-to-SQL-Server.aspx</a></p> <p>BUT be advised that you should set the port specified in the Configuration Manager (default is 1433 but sometimes it's dynamic and you should set it again)</p> <p><strong>7- After you set the port and network visibility, you should change the <code>"Server"</code> value in the connection string to this format <code>"IPAddress, PORT"</code> like <code>"192.168.10.50, 1433"</code></strong> (When you specify the port, there is no need to set the instance name like this <code>"192.168.10.50\SQLEXPRESS"</code>)</p> <p>Hope it helps</p>

Querying!

Guidance

An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload