469,097 Members | 1,542 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,097 developers. It's quick & easy.

how to access Database from sql server of another computer ?

19
Hi.....

we are 5 members working in same project.we are using sql server 2005.so we have to share one database.how to do that?how to connect sqlserver from another computer?
Jul 15 '10 #1
6 27905
When you say "Connect", do you mean connect from Management Studio or do you mean connect programatically with some sort of connection object in code?

From Management Studio, you just choose Connect\Database Engine from the Object Explorer and enter in the server name and authentication mode/credentials.

If you are talking about a connection object, you should post in the forum related to your platform.
Jul 15 '10 #2
vidhyaG
19
@Christopher Nigro
Thanks for Replying...

I want to connect sqlserver of another system from my sqlserver Management Studio.

I tried following Steps..

1)in sqlserver surface area configuration i enabled local and remote connection
2)restarted database engine
3)enabled sql browser in sql configuration manager
i did that in two systems
then i did
4)tried to connect sqlserver of another system from my system
sqlserver management studio->object explorer->connect->gave sql server name of another system->connect
but i did not work successfully....

Error:
cannot connect to nexus1

A network related or instance specific error occurred while establishing a connection to server.the server was not found or not accessible.verify instance name is correct and that sql is configured to allow remote connections


Please help me...
Jul 16 '10 #3
Did you verify that the instance name from the SQL server that you are trying to connect to was the same as the name you entered? In the Server Name list, click <browse for more> and see if it shows up. Is the SQL Server in your environment/domain?
Jul 16 '10 #4
vidhyaG
19
@Christopher Nigro
ya.you are correct.... instance name is not there...

but i tried to browse..in that also system name is only there...then i typed ownly (Ex).Nexus1\SQLEXPRESS

but same error is coming..

then tried with another server which have correct name with instance...

but that also not working...

another error came...

ERROR:Login failed for user ".the user is not associated with a trusted sql server connection..(Microsoft sql server Error:18452)

Note :in security option windows authentication is enabled.
Jul 17 '10 #5
Jerry Winston
145 Expert 100+
Here's a few hot-spots to check:

1. Ensure all users are in the same domain
2. Check the CONNECT rights granted to domain group containing the 5 developer logins.
3. Make sure you have enabled your network protocols e.g. TCP/IP, Shared Memory, ect from inside SQL Server Configuration Manager.
4. Make sure your firewall is not blocking SQL Server ports 1433. (1434)

Try this:
1. Change the security mode to Mixed mode.(restart the SQL server)
2. Create a new SQL login and map it to the common database.
3. Grant the new login connect rights to the server.
4. Login using the IP address of the server and instance name 123.1.2.123\SQLEXPRESS and the new SQL login.
Jul 21 '10 #6
Just add a port in your firewall

add exception:

name : sql
port : 1433


or simply turn off fire wall
Oct 28 '10 #7

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

1 post views Thread by CARIGAR | last post: by
reply views Thread by zhoujie | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.