SQL Server

Question

0.00/5 (No votes)

See more:

SQL-Server

Hi,
i install sql server a single machine.now i want create table and run queries on onther lan machine

Posted 16-Jul-10 23:21pm

sandeep_bhawsar

Add a Solution

3 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Goutam Patra · Answer 1 · 2010-07-16T23:48:00

Solution 1

In your lan machine install SQL Server client version/Management studio and connect your server.

Posted 16-Jul-10 23:48pm

Goutam Patra

Sandeep Mewara · Answer 2 · 2010-07-17T00:02:00

You need to have SQL Management Studio on other system from which you want to create tables and queries.

Once you have environment ready on other system, connect to this system on which you installed SQL server. In order to connect this SQL Server, you need to configure it to allow remote connections.

Abhishek Sur · Answer 3 · 2010-07-17T01:20:00

Also, I must add, to access Sql Server instance from outside, you must install the server in Mixed mode.

Generally if you have already installed the Sql server, then you can check by Right-clicking the server, and then click Properties.
In the Security tab if "sql server and windows" is selected it is mixed mode.

Mixed mode authentication allows you to use SQL Authentication and so you can connect sql server using sql server userid and password. Otherwise for windows authentication, you have to login using domain account.

Other than that, you also need to carefully exempt the SqlBrowser and sqlservr.exe. This will allow you to find the server from outside.

:thumbsup:

SQL Server

3 solutions

Solution 1

Solution 2

Solution 3

Add your solution here

Preview 0